BUFR ZONE

Versions

Installed Packages

Installation paths relative to:

/opt/boss/venv/lib/python3.9/site-packages

Package	Version	Installed Path
aiohappyeyeballs	2.4.4
aiohttp	3.11.1
aiosignal	1.3.2
alembic	1.8.0
amqp	5.3.1
aniso8601	7.0.0
async-timeout	5.0.1
attrs	25.1.0
Authlib	0.14.1
Babel	2.9.1
bidict	0.21.4
billiard	4.2.1
bleach	3.3.0
blinker	1.9.0
cachelib	0.9.0
celery	5.4.0
certifi	2025.1.31
cffi	1.17.1
cfgv	3.4.0
charset-normalizer	3.4.1
click	8.1.3
click-didyoumean	0.3.1
click-plugins	1.1.1
click-repl	0.3.0
cryptography	44.0.0
Deprecated	1.2.18
distlib	0.3.9
dnspython	2.7.0
email-validator	1.1.3
filelock	3.17.0
Flask	2.1.2
Flask-Babel	2.0.0
Flask-Breadcrumbs	0.5.1
Flask-Caching	2.0.2
Flask-Cors	3.0.10
Flask-DebugToolbar	0.13.1
Flask-Limiter	3.8.0
Flask-Login	0.6.2
Flask-Mail	0.9.1
Flask-Markdown	0.3
flask-menu	2.0.0
Flask-Migrate	3.1.0
Flask-Principal	0.4.0
flask-restx	1.0.5
Flask-Reuploaded	1.3.0
Flask-Script	2.0.6
Flask-Security-Too	5.1.0
Flask-Session	0.4.0
Flask-SocketIO	5.2.0
Flask-SQLAlchemy	2.5.1
Flask-WTF	1.0.1
frozenlist	1.5.0
gevent	23.9.0
gevent-websocket	0.10.1
gitdb2	2.0.5
GitPython	2.1.11
greenlet	3.1.0
gunicorn	20.1.0
identify	2.6.6
idna	3.10
importlib-metadata	4.13.0
itsdangerous	2.1.2
Jinja2	3.1.2
jsonschema	4.23.0
jsonschema-specifications	2024.10.1
kombu	5.4.2
limits	4.0.1
Mako	1.0.13
Markdown	3.7
markdown-it-py	3.0.0
MarkupSafe	2.1.1
mdurl	0.1.2
multidict	6.1.0
nodeenv	1.9.1
ordered-set	4.1.0
packaging	24.2
passlib	1.7.4
pilkit	2.0
Pillow	9.4.0
pip	20.3.4
pkg-resources	0.0.0
platformdirs	4.3.6
pre-commit	2.19.0
prompt-toolkit	3.0.50
propcache	0.2.1
psutil	5.7.0
psycopg2-binary	2.9.10
pycparser	2.22
pygments	2.19.1
PyMySQL	0.9.3
pypng	0.20220715.0
PyQRCode	1.2.1
python-dateutil	2.8.2
python-dotenv	0.20.0
python-editor	1.0.4
python-engineio	4.3.1
python-socketio	5.0.2
pytz	2022.1
PyYAML	6.0.2
qrcode	7.4.2
redis	4.3.3
referencing	0.36.2
requests	2.28.2
rich	13.9.4
rpds-py	0.22.3
sentry-sdk	1.12.1
setuptools	44.1.1
six	1.17.0
smmap2	2.0.5
speaklater	1.3
SQLAlchemy	1.4.37
toml	0.10.2
typing-extensions	4.12.2
tzdata	2025.1
urllib3	1.26.20
vine	5.1.0
virtualenv	20.29.1
wcwidth	0.2.13
webencodings	0.5.1
Werkzeug	2.1.2
wheel	0.41.1
wrapt	1.17.2
WTForms	3.0.1
xmltodict	0.13.0
yarl	1.18.3
zipp	3.21.0
zope.event	5.0
zope.interface	7.2

Resource Usage

Resource	Value
User CPU time	66.105 msec
System CPU time	2.797 msec
Total CPU time	68.902 msec
Elapsed time	91.751 msec
Context switches	73 voluntary, 0 involuntary

HTTP Headers

Key	Value
HTTP_ACCEPT	/
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_CONNECTION	close
HTTP_HOST	bufr.zone:443
HTTP_REFERER	https://bufr.zone/channel
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
QUERY_STRING
REMOTE_ADDR	216.73.216.147
REQUEST_METHOD	GET
SCRIPT_NAME
SERVER_NAME	nFxedPLEX.bufr.zone
SERVER_PORT	5008
SERVER_PROTOCOL	HTTP/1.0
SERVER_SOFTWARE	gevent/23.9.0 gunicorn/20.1.0

Request Vars

View information

View Function	args	kwargs
blueprints.channels.channels_page	[]	None

COOKIES Variables

Variable	Value
'bossSession'	'b0fb14c1-90e3-4b4a-9efd-35f256b5e36c'
'route'	'bcc153c0967c0cbb04e6e6329910f46b'

SESSION Variables

Variable	Value
'_permanent'	True
'_fresh'	False
'guestUUID'	'f75d419c-f2c2-4155-a1d7-2ab3f094c825'

GET Variables

Variable	Value

POST Variables

Variable	Value

Config

Key	Value
APPLICATION_ROOT	`'/'`
BABEL_DEFAULT_LOCALE	`'en'`
BABEL_DEFAULT_TIMEZONE	`'UTC'`
BABEL_DOMAIN	`'messages'`
broker_url	`'redis://localhost:6379'`
DEBUG	`True`
DEBUG_TB_ENABLED	`True`
DEBUG_TB_HOSTS	`()`
DEBUG_TB_INTERCEPT_REDIRECTS	`True`
DEBUG_TB_PANELS	('flask_debugtoolbar.panels.versions.VersionDebugPanel', 'flask_debugtoolbar.panels.timer.TimerDebugPanel', 'flask_debugtoolbar.panels.headers.HeaderDebugPanel', 'flask_debugtoolbar.panels.request_vars.RequestVarsDebugPanel', 'flask_debugtoolbar.panels.config_vars.ConfigVarsDebugPanel', 'flask_debugtoolbar.panels.template.TemplateDebugPanel', 'flask_debugtoolbar.panels.sqlalchemy.SQLAlchemyDebugPanel', 'flask_debugtoolbar.panels.logger.LoggingPanel', 'flask_debugtoolbar.panels.route_list.RouteListDebugPanel', 'flask_debugtoolbar.panels.profiler.ProfilerDebugPanel', 'flask_debugtoolbar.panels.g.GDebugPanel')
ENV	`'production'`
EXPLAIN_TEMPLATE_LOADING	`False`
JSON_AS_ASCII	`True`
JSON_SORT_KEYS	`True`
JSONIFY_MIMETYPE	`'application/json'`
JSONIFY_PRETTYPRINT_REGULAR	`False`
MAIL_DEFAULT_SENDER	`'info@bufr.zone'`
MAIL_PASSWORD	`'ykxggnsgfqzkzyho'`
MAIL_PORT	`465`
MAIL_SERVER	`'smtp.gmail.com'`
MAIL_USE_SSL	`True`
MAIL_USE_TLS	`False`
MAIL_USERNAME	`'nfxus@bufr.zone'`
MAX_CONTENT_LENGTH	`4000000000`
MAX_COOKIE_SIZE	`4093`
MYSQL_DATABASE_CHARSET	`'utf8'`
PERMANENT_SESSION_LIFETIME	`datetime.timedelta(days=31)`
PREFERRED_URL_SCHEME	`'http'`
PRESERVE_CONTEXT_ON_EXCEPTION	`None`
PROPAGATE_EXCEPTIONS	`None`
RATELIMIT_ENABLED	`True`
RATELIMIT_STORAGE_URL	`'redis://localhost:6379'`
RATELIMIT_STRATEGY	`'fixed-window'`
RESTX_INCLUDE_ALL_MODELS	`False`
RESTX_MASK_HEADER	`'X-Fields'`
RESTX_MASK_SWAGGER	`True`
result_backend	`'redis://localhost:6379'`
SECRET_KEY	`'BjUwLD^uh3kdvpeEJwUS25g9%5nDdkD^u9$4YLR5o6abvxxmnSph&sR$!vjSUt$SBvmfe4eMUsNkL8fX#e*aZ3FMWHe!YJo%Vd&#N67qnKUYe6mnj9tMg4QJxwCS$'`
SECURITY_API_ENABLED_METHODS	`['session', 'token']`
SECURITY_AUTO_LOGIN_AFTER_CONFIRM	`True`
SECURITY_BACKWARDS_COMPAT_AUTH_TOKEN	`False`
SECURITY_BACKWARDS_COMPAT_UNAUTHN	`False`
SECURITY_BLUEPRINT_NAME	`'security'`
SECURITY_CHANGABLE	`True`
SECURITY_CHANGE_PASSWORD_TEMPLATE	`'security/change_password.html'`
SECURITY_CHANGE_SALT	`'change-salt'`
SECURITY_CHANGE_URL	`'/change'`
SECURITY_CHANGEABLE	`False`
SECURITY_CLI_ROLES_NAME	`'roles'`
SECURITY_CLI_USERS_NAME	`'users'`
SECURITY_CONFIRM_EMAIL_WITHIN	`'5 days'`
SECURITY_CONFIRM_ERROR_VIEW	`None`
SECURITY_CONFIRM_SALT	`'confirm-salt'`
SECURITY_CONFIRM_URL	`'/confirm'`
SECURITY_CONFIRMABLE	`True`
SECURITY_CSRF_COOKIE	`{'samesite': 'Strict', 'httponly': False, 'secure': False}`
SECURITY_CSRF_COOKIE_NAME	`None`
SECURITY_CSRF_COOKIE_REFRESH_EACH_REQUEST	`False`
SECURITY_CSRF_HEADER	`'X-XSRF-Token'`
SECURITY_CSRF_IGNORE_UNAUTH_ENDPOINTS	`False`
SECURITY_CSRF_PROTECT_MECHANISMS	`('basic', 'session', 'token')`
SECURITY_DATETIME_FACTORY	`<built-in method utcnow of type object at 0x92c3e0>`
SECURITY_DEFAULT_HTTP_AUTH_REALM	`'Login Required'`
SECURITY_DEFAULT_REMEMBER_ME	`False`
SECURITY_DEPRECATED_HASHING_SCHEMES	`['hex_md5']`
SECURITY_DEPRECATED_PASSWORD_SCHEMES	`['auto']`
SECURITY_EMAIL_HTML	`True`
SECURITY_EMAIL_PLAINTEXT	`True`
SECURITY_EMAIL_SENDER	`'info@bufr.zone'`
SECURITY_EMAIL_SUBJECT_CONFIRM	`'BUFR ZONE - Email Confirmation Request'`
SECURITY_EMAIL_SUBJECT_PASSWORD_CHANGE_NOTICE	`'Your password has been changed'`
SECURITY_EMAIL_SUBJECT_PASSWORD_NOTICE	`'BUFR ZONE - Password Reset Notification'`
SECURITY_EMAIL_SUBJECT_PASSWORD_RESET	`'BUFR ZONE - Password Reset Request'`
SECURITY_EMAIL_SUBJECT_PASSWORDLESS	`'Login instructions'`
SECURITY_EMAIL_SUBJECT_REGISTER	`'BUFR ZONE - Welcome!'`
SECURITY_EMAIL_SUBJECT_TWO_FACTOR	`'Two-factor Login'`
SECURITY_EMAIL_SUBJECT_TWO_FACTOR_RESCUE	`'Two-factor Rescue'`
SECURITY_EMAIL_VALIDATOR_ARGS	`None`
SECURITY_FLASH_MESSAGES	`True`
SECURITY_FORGOT_PASSWORD_TEMPLATE	`'security/forgot_password.html'`
SECURITY_FRESHNESS	`datetime.timedelta(days=1)`
SECURITY_FRESHNESS_GRACE_PERIOD	`datetime.timedelta(seconds=3600)`
SECURITY_HASHING_SCHEMES	`['sha256_crypt', 'hex_md5']`
SECURITY_I18N_DIRNAME	`'/opt/boss/venv/lib/python3.9/site-packages/flask_security/translations'`
SECURITY_I18N_DOMAIN	`'flask_security'`
SECURITY_JOIN_USER_ROLES	`True`
SECURITY_LOGIN_ERROR_VIEW	`None`
SECURITY_LOGIN_SALT	`'login-salt'`
SECURITY_LOGIN_URL	`'/login'`
SECURITY_LOGIN_USER_TEMPLATE	`'security/login_user.html'`
SECURITY_LOGIN_WITHIN	`'1 days'`
SECURITY_LOGIN_WITHOUT_CONFIRMATION	`False`
SECURITY_LOGOUT_METHODS	`['GET', 'POST']`
SECURITY_LOGOUT_URL	`'/logout'`
SECURITY_MSG_ALREADY_CONFIRMED	`('Your email has already been confirmed.', 'info')`
SECURITY_MSG_ANONYMOUS_USER_REQUIRED	`('You can only access this endpoint when not logged in.', 'error')`
SECURITY_MSG_API_ERROR	`('Input not appropriate for requested API', 'error')`
SECURITY_MSG_CODE_HAS_BEEN_SENT	`('Code has been sent.', 'info')`
SECURITY_MSG_CONFIRM_REGISTRATION	`('Thank you. Confirmation instructions have been sent to %(email)s.', 'success')`
SECURITY_MSG_CONFIRMATION_EXPIRED	`('You did not confirm your email within %(within)s. New instructions to confirm your email have been sent to %(email)s.', 'error')`
SECURITY_MSG_CONFIRMATION_REQUEST	`('Confirmation instructions have been sent to %(email)s.', 'info')`
SECURITY_MSG_CONFIRMATION_REQUIRED	`('Email requires confirmation.', 'error')`
SECURITY_MSG_DISABLED_ACCOUNT	`('Account Disabled', 'error')`
SECURITY_MSG_EMAIL_ALREADY_ASSOCIATED	`('Username or Email Already Associated with an Account', 'error')`
SECURITY_MSG_EMAIL_CONFIRMED	`('Thank you. Your email has been confirmed.', 'success')`
SECURITY_MSG_EMAIL_NOT_PROVIDED	`('Email not provided', 'error')`
SECURITY_MSG_FAILED_TO_SEND_CODE	`('Failed to send code. Please try again later', 'error')`
SECURITY_MSG_FORGOT_PASSWORD	`('Forgot password?', 'info')`
SECURITY_MSG_GENERIC_AUTHN_FAILED	`('Authentication failed - identity or password/passcode invalid', 'error')`
SECURITY_MSG_GENERIC_RECOVERY	`('If that email address is in our system, you will receive an email describing how to reset your password.', 'info')`
SECURITY_MSG_GENERIC_US_SIGNIN	`('If that identity is in our system, you were sent a code.', 'info')`
SECURITY_MSG_IDENTITY_ALREADY_ASSOCIATED	`("Identity attribute '%(attr)s' with value '%(value)s' is already associated with an account.", 'error')`
SECURITY_MSG_IDENTITY_NOT_REGISTERED	`('Identity %(id)s not registered', 'error')`
SECURITY_MSG_INVALID_CODE	`('Invalid code', 'error')`
SECURITY_MSG_INVALID_CONFIRMATION_TOKEN	`('Invalid confirmation token.', 'error')`
SECURITY_MSG_INVALID_EMAIL_ADDRESS	`('Invalid Username or Password', 'error')`
SECURITY_MSG_INVALID_LOGIN_TOKEN	`('Invalid login token.', 'error')`
SECURITY_MSG_INVALID_PASSWORD	`('Invalid Username or Password', 'error')`
SECURITY_MSG_INVALID_PASSWORD_CODE	`('Password or code submitted is not valid', 'error')`
SECURITY_MSG_INVALID_RECOVERY_CODE	`('Recovery code invalid', 'error')`
SECURITY_MSG_INVALID_REDIRECT	`('Redirections outside the domain are forbidden', 'error')`
SECURITY_MSG_INVALID_RESET_PASSWORD_TOKEN	`('Invalid reset password token.', 'error')`
SECURITY_MSG_LOGIN	`('Please log in to access this page.', 'info')`
SECURITY_MSG_LOGIN_EMAIL_SENT	`('Instructions to login have been sent to %(email)s.', 'success')`
SECURITY_MSG_LOGIN_EXPIRED	`('You did not login within %(within)s. New instructions to login have been sent to %(email)s.', 'error')`
SECURITY_MSG_NO_RECOVERY_CODES_SETUP	`('No recovery codes generated yet', 'info')`
SECURITY_MSG_OAUTH_HANDSHAKE_ERROR	`('An error occurred while communicating with the Oauth provider. Please try again.', 'error')`
SECURITY_MSG_PASSWORD_BREACHED	`('Password on breached list', 'error')`
SECURITY_MSG_PASSWORD_BREACHED_SITE_ERROR	`('Failed to contact breached passwords site', 'error')`
SECURITY_MSG_PASSWORD_CHANGE	`('You successfully changed your password.', 'success')`
SECURITY_MSG_PASSWORD_INVALID_LENGTH	`('Password must be at least %(length)s characters', 'error')`
SECURITY_MSG_PASSWORD_IS_THE_SAME	`('Your new password must be different than your previous password.', 'error')`
SECURITY_MSG_PASSWORD_MISMATCH	`('Password does not match', 'error')`
SECURITY_MSG_PASSWORD_NOT_PROVIDED	`('Password not provided', 'error')`
SECURITY_MSG_PASSWORD_RESET	`('You successfully reset your password and you have been logged in automatically.', 'success')`
SECURITY_MSG_PASSWORD_RESET_EXPIRED	`('You did not reset your password within %(within)s. New instructions have been sent to %(email)s.', 'error')`
SECURITY_MSG_PASSWORD_RESET_REQUEST	`('Instructions to reset your password have been sent to %(email)s.', 'info')`
SECURITY_MSG_PASSWORD_TOO_SIMPLE	`('Password not complex enough', 'error')`
SECURITY_MSG_PASSWORDLESS_LOGIN_SUCCESSFUL	`('You have successfully logged in.', 'success')`
SECURITY_MSG_PHONE_INVALID	`('Phone number not valid e.g. missing country code', 'error')`
SECURITY_MSG_REAUTHENTICATION_REQUIRED	`('You must re-authenticate to access this endpoint', 'error')`
SECURITY_MSG_REAUTHENTICATION_SUCCESSFUL	`('Reauthentication successful', 'info')`
SECURITY_MSG_REFRESH	`('Please reauthenticate to access this page.', 'info')`
SECURITY_MSG_RETYPE_PASSWORD_MISMATCH	`('Passwords do not match', 'error')`
SECURITY_MSG_TWO_FACTOR_CHANGE_METHOD_SUCCESSFUL	`('You successfully changed your two-factor method.', 'success')`
SECURITY_MSG_TWO_FACTOR_DISABLED	`('You successfully disabled two factor authorization.', 'success')`
SECURITY_MSG_TWO_FACTOR_INVALID_TOKEN	`('Invalid code', 'error')`
SECURITY_MSG_TWO_FACTOR_LOGIN_SUCCESSFUL	`('Your code has been confirmed', 'success')`
SECURITY_MSG_TWO_FACTOR_METHOD_NOT_AVAILABLE	`('Marked method is not valid', 'error')`
SECURITY_MSG_TWO_FACTOR_PERMISSION_DENIED	`('You currently do not have permissions to access this page', 'error')`
SECURITY_MSG_UNAUTHENTICATED	`('You are not authenticated. Please supply the correct credentials.', 'error')`
SECURITY_MSG_UNAUTHORIZED	`('You do not have permission to view this resource.', 'error')`
SECURITY_MSG_US_METHOD_NOT_AVAILABLE	`('Requested method is not valid', 'error')`
SECURITY_MSG_US_SETUP_EXPIRED	`('Setup must be completed within %(within)s. Please start over.', 'error')`
SECURITY_MSG_US_SETUP_SUCCESSFUL	`('Unified sign in setup successful', 'info')`
SECURITY_MSG_US_SPECIFY_IDENTITY	`('You must specify a valid identity to sign in', 'error')`
SECURITY_MSG_USE_CODE	`('Use this code to sign in: %(code)s.', 'info')`
SECURITY_MSG_USER_DOES_NOT_EXIST	`('Invalid Username or Password', 'error')`
SECURITY_MSG_USERNAME_ALREADY_ASSOCIATED	`('%(username)s is already associated with an account.', 'error')`
SECURITY_MSG_USERNAME_DISALLOWED_CHARACTERS	`('Username can contain only letters and numbers', 'error')`
SECURITY_MSG_USERNAME_ILLEGAL_CHARACTERS	`('Username contains illegal characters', 'error')`
SECURITY_MSG_USERNAME_INVALID_LENGTH	`('Username must be at least %(min)d characters and less than %(max)d characters', 'error')`
SECURITY_MSG_USERNAME_NOT_PROVIDED	`('Username not provided', 'error')`
SECURITY_MSG_WEBAUTHN_CREDENTIAL_DELETED	`('Successfully deleted WebAuthn credential with name: %(name)s', 'info')`
SECURITY_MSG_WEBAUTHN_CREDENTIAL_ID_INUSE	`('WebAuthn credential id already registered.', 'error')`
SECURITY_MSG_WEBAUTHN_CREDENTIAL_WRONG_USAGE	`('Credential not registered for this use (first or secondary)', 'error')`
SECURITY_MSG_WEBAUTHN_EXPIRED	`('WebAuthn operation must be completed within %(within)s. Please start over.', 'error')`
SECURITY_MSG_WEBAUTHN_MISMATCH_USER_HANDLE	`("Credential user handle didn't match", 'error')`
SECURITY_MSG_WEBAUTHN_NAME_INUSE	`('%(name)s is already associated with a credential.', 'error')`
SECURITY_MSG_WEBAUTHN_NAME_NOT_FOUND	`('%(name)s not registered with current user.', 'error')`
SECURITY_MSG_WEBAUTHN_NAME_REQUIRED	`('Nickname for new credential is required.', 'error')`
SECURITY_MSG_WEBAUTHN_NO_VERIFY	`('Could not verify WebAuthn credential: %(cause)s.', 'error')`
SECURITY_MSG_WEBAUTHN_ORPHAN_CREDENTIAL_ID	`("WebAuthn credential doesn't belong to any user.", 'error')`
SECURITY_MSG_WEBAUTHN_REGISTER_SUCCESSFUL	`('Successfully added WebAuthn credential with name: %(name)s', 'info')`
SECURITY_MSG_WEBAUTHN_UNKNOWN_CREDENTIAL_ID	`('Unregistered WebAuthn credential id.', 'error')`
SECURITY_MULTI_FACTOR_RECOVERY_CODE_TTL	`None`
SECURITY_MULTI_FACTOR_RECOVERY_CODES	`False`
SECURITY_MULTI_FACTOR_RECOVERY_CODES_KEYS	`None`
SECURITY_MULTI_FACTOR_RECOVERY_CODES_N	`5`
SECURITY_MULTI_FACTOR_RECOVERY_CODES_TEMPLATE	`'security/mf_recovery_codes.html'`
SECURITY_MULTI_FACTOR_RECOVERY_CODES_URL	`'/mf-recovery-codes'`
SECURITY_MULTI_FACTOR_RECOVERY_TEMPLATE	`'security/mf_recovery.html'`
SECURITY_MULTI_FACTOR_RECOVERY_URL	`'/mf-recovery'`
SECURITY_OAUTH_BUILTIN_PROVIDERS	`['github', 'google']`
SECURITY_OAUTH_ENABLE	`False`
SECURITY_OAUTH_RESPONSE_URL	`'/login/oauthresponse'`
SECURITY_OAUTH_START_URL	`'/login/oauthstart'`
SECURITY_PASSWORD_BREACHED_COUNT	`1`
SECURITY_PASSWORD_CHECK_BREACHED	`False`
SECURITY_PASSWORD_COMPLEXITY_CHECKER	`None`
SECURITY_PASSWORD_HASH	`'pbkdf2_sha512'`
SECURITY_PASSWORD_HASH_OPTIONS	`{}`
SECURITY_PASSWORD_HASH_PASSLIB_OPTIONS	`{'argon2__rounds': 10}`
SECURITY_PASSWORD_LENGTH_MIN	`8`
SECURITY_PASSWORD_NORMALIZE_FORM	`'NFKD'`
SECURITY_PASSWORD_REQUIRED	`True`
SECURITY_PASSWORD_SALT	`'C25mwDG8fiS%$aBw$vRK&y$gYrr^9Pm5!GoRd8hyejBFu9GzNTCToJW&%$EgDCSjH!xWvy7PWkSmx*U%AFL5PGk&8^4B#S2$ZZkzP9qXmAWzdT#qYfB8tEj4U7Jbr'`
SECURITY_PASSWORD_SCHEMES	`['bcrypt', 'argon2', 'des_crypt', 'pbkdf2_sha256', 'pbkdf2_sha512', 'sha256_crypt', 'sha512_crypt', 'plaintext']`
SECURITY_PASSWORD_SINGLE_HASH	`{'django_des_crypt', 'django_salted_md5', 'django_pbkdf2_sha256', 'django_bcrypt_sha256', 'django_bcrypt', 'django_salted_sha1', 'plaintext', 'django_pbkdf2_sha1', 'django_argon2'}`
SECURITY_PASSWORDLESS	`False`
SECURITY_PHONE_REGION_DEFAULT	`'US'`
SECURITY_POST_CHANGE_VIEW	`None`
SECURITY_POST_CONFIRM_VIEW	`None`
SECURITY_POST_LOGIN_VIEW	`'/'`
SECURITY_POST_LOGOUT_VIEW	`'/'`
SECURITY_POST_REGISTER_VIEW	`None`
SECURITY_POST_RESET_VIEW	`None`
SECURITY_POST_VERIFY_VIEW	`None`
SECURITY_RECOVERABLE	`True`
SECURITY_REDIRECT_ALLOW_SUBDOMAINS	`False`
SECURITY_REDIRECT_BEHAVIOR	`None`
SECURITY_REDIRECT_HOST	`None`
SECURITY_REDIRECT_VALIDATE_MODE	`None`
SECURITY_REDIRECT_VALIDATE_RE	`'^/{4,}\|\\\\{3,}\|[\\s\\000-\\037][/\\\\]{2,}'`
SECURITY_REGISTER_URL	`'/register'`
SECURITY_REGISTER_USER_TEMPLATE	`'security/register_user.html'`
SECURITY_REGISTERABLE	`True`
SECURITY_REMEMBER_SALT	`'remember-salt'`
SECURITY_REQUIRES_CONFIRMATION_ERROR_VIEW	`None`
SECURITY_RESET_ERROR_VIEW	`None`
SECURITY_RESET_PASSWORD_TEMPLATE	`'security/reset_password.html'`
SECURITY_RESET_PASSWORD_WITHIN	`'5 days'`
SECURITY_RESET_SALT	`'reset-salt'`
SECURITY_RESET_URL	`'/reset'`
SECURITY_RESET_VIEW	`None`
SECURITY_RETURN_GENERIC_RESPONSES	`False`
SECURITY_SEND_CONFIRMATION_TEMPLATE	`'security/send_confirmation.html'`
SECURITY_SEND_LOGIN_TEMPLATE	`'security/send_login.html'`
SECURITY_SEND_PASSWORD_CHANGE_EMAIL	`True`
SECURITY_SEND_PASSWORD_RESET_EMAIL	`True`
SECURITY_SEND_PASSWORD_RESET_NOTICE_EMAIL	`True`
SECURITY_SEND_REGISTER_EMAIL	`True`
SECURITY_SMS_SERVICE	`'Dummy'`
SECURITY_SMS_SERVICE_CONFIG	`{'ACCOUNT_SID': None, 'AUTH_TOKEN': None, 'PHONE_NUMBER': None}`
SECURITY_STATIC_FOLDER	`'static'`
SECURITY_STATIC_FOLDER_URL	`'/fs-static'`
SECURITY_SUBDOMAIN	`None`
SECURITY_TOKEN_AUTHENTICATION_HEADER	`'Authentication-Token'`
SECURITY_TOKEN_AUTHENTICATION_KEY	`'auth_token'`
SECURITY_TOKEN_MAX_AGE	`None`
SECURITY_TOTP_ISSUER	`'BUFR ZONE'`
SECURITY_TOTP_SECRETS	`{'1': 'BjUwLD^uh3kdvpeEJwUS25g9%5nDdkD^u9$4YLR5o6abvxxmnSph&sR$!vjSUt$SBvmfe4eMUsNkL8fX#e*aZ3FMWHe!YJo%Vd&#N67qnKUYe6mnj9tMg4QJxwCS$'}`
SECURITY_TRACKABLE	`True`
SECURITY_TWO_FACTOR	`True`
SECURITY_TWO_FACTOR_ALWAYS_VALIDATE	`False`
SECURITY_TWO_FACTOR_AUTHENTICATOR_VALIDITY	`120`
SECURITY_TWO_FACTOR_ENABLED_METHODS	`['authenticator']`
SECURITY_TWO_FACTOR_ERROR_VIEW	`'.login'`
SECURITY_TWO_FACTOR_IMPLEMENTATIONS	`{'code': 'flask_security.twofactor.CodeTfPlugin', 'webauthn': 'flask_security.webauthn.WebAuthnTfPlugin'}`
SECURITY_TWO_FACTOR_LOGIN_VALIDITY	`'7 days'`
SECURITY_TWO_FACTOR_MAIL_VALIDITY	`300`
SECURITY_TWO_FACTOR_POST_SETUP_VIEW	`'.two_factor_setup'`
SECURITY_TWO_FACTOR_REQUIRED	`False`
SECURITY_TWO_FACTOR_RESCUE_EMAIL	`True`
SECURITY_TWO_FACTOR_RESCUE_MAIL	`'no-reply@localhost'`
SECURITY_TWO_FACTOR_RESCUE_URL	`'/tf-rescue'`
SECURITY_TWO_FACTOR_SECRET	`None`
SECURITY_TWO_FACTOR_SELECT_TEMPLATE	`'security/two_factor_select.html'`
SECURITY_TWO_FACTOR_SELECT_URL	`'/tf-select'`
SECURITY_TWO_FACTOR_SETUP_TEMPLATE	`'security/two_factor_setup.html'`
SECURITY_TWO_FACTOR_SETUP_URL	`'/tf-setup'`
SECURITY_TWO_FACTOR_SMS_SERVICE	`'Dummy'`
SECURITY_TWO_FACTOR_SMS_SERVICE_CONFIG	`{'ACCOUNT_SID': None, 'AUTH_TOKEN': None, 'PHONE_NUMBER': None}`
SECURITY_TWO_FACTOR_SMS_VALIDITY	`120`
SECURITY_TWO_FACTOR_TOKEN_VALIDATION_URL	`'/tf-validate'`
SECURITY_TWO_FACTOR_URI_SERVICE_NAME	`'service_name'`
SECURITY_TWO_FACTOR_VALIDITY_COOKIE	`{'httponly': True, 'secure': False, 'samesite': 'Strict'}`
SECURITY_TWO_FACTOR_VALIDITY_SALT	`'tf-validity-salt'`
SECURITY_TWO_FACTOR_VERIFY_CODE_TEMPLATE	`'security/two_factor_verify_code.html'`
SECURITY_UNAUTHORIZED_VIEW	`None`
SECURITY_UNIFIED_SIGNIN	`False`
SECURITY_URL_PREFIX	`None`
SECURITY_US_EMAIL_SUBJECT	`'Verification Code'`
SECURITY_US_ENABLED_METHODS	`['password', 'email', 'authenticator', 'sms']`
SECURITY_US_MFA_REQUIRED	`['password', 'email']`
SECURITY_US_POST_SETUP_VIEW	`'.us_setup'`
SECURITY_US_SETUP_SALT	`'us-setup-salt'`
SECURITY_US_SETUP_TEMPLATE	`'security/us_setup.html'`
SECURITY_US_SETUP_URL	`'/us-setup'`
SECURITY_US_SETUP_WITHIN	`'30 minutes'`
SECURITY_US_SIGNIN_REPLACES_LOGIN	`False`
SECURITY_US_SIGNIN_SEND_CODE_URL	`'/us-signin/send-code'`
SECURITY_US_SIGNIN_TEMPLATE	`'security/us_signin.html'`
SECURITY_US_SIGNIN_URL	`'/us-signin'`
SECURITY_US_TOKEN_VALIDITY	`120`
SECURITY_US_VERIFY_LINK_URL	`'/us-verify-link'`
SECURITY_US_VERIFY_SEND_CODE_URL	`'/us-verify/send-code'`
SECURITY_US_VERIFY_TEMPLATE	`'security/us_verify.html'`
SECURITY_US_VERIFY_URL	`'/us-verify'`
SECURITY_USER_IDENTITY_ATTRIBUTES	`[{'email': {'mapper': <function uia_email_mapper at 0x7f94a0e4e280>, 'case_insensitive': True}}]`
SECURITY_USERNAME_ENABLE	`False`
SECURITY_USERNAME_MAX_LENGTH	`32`
SECURITY_USERNAME_MIN_LENGTH	`4`
SECURITY_USERNAME_NORMALIZE_FORM	`'NFKD'`
SECURITY_USERNAME_REQUIRED	`False`
SECURITY_VERIFY_TEMPLATE	`'security/verify.html'`
SECURITY_VERIFY_URL	`'/verify'`
SECURITY_WAN_ALLOW_AS_FIRST_FACTOR	`True`
SECURITY_WAN_ALLOW_AS_MULTI_FACTOR	`True`
SECURITY_WAN_ALLOW_AS_VERIFY	`['first', 'secondary']`
SECURITY_WAN_ALLOW_USER_HINTS	`True`
SECURITY_WAN_CHALLENGE_BYTES	`None`
SECURITY_WAN_DELETE_URL	`'/wan-delete'`
SECURITY_WAN_POST_REGISTER_VIEW	`'.wan_register'`
SECURITY_WAN_REGISTER_TEMPLATE	`'security/wan_register.html'`
SECURITY_WAN_REGISTER_TIMEOUT	`60000`
SECURITY_WAN_REGISTER_URL	`'/wan-register'`
SECURITY_WAN_REGISTER_WITHIN	`'30 minutes'`
SECURITY_WAN_RP_NAME	`'My Flask App'`
SECURITY_WAN_SALT	`'wan-salt'`
SECURITY_WAN_SIGNIN_TEMPLATE	`'security/wan_signin.html'`
SECURITY_WAN_SIGNIN_TIMEOUT	`60000`
SECURITY_WAN_SIGNIN_URL	`'/wan-signin'`
SECURITY_WAN_SIGNIN_WITHIN	`'1 minutes'`
SECURITY_WAN_VERIFY_TEMPLATE	`'security/wan_verify.html'`
SECURITY_WAN_VERIFY_URL	`'/wan-verify'`
SECURITY_WEBAUTHN	`False`
SECURITY_ZXCVBN_MINIMUM_SCORE	`3`
SEND_FILE_MAX_AGE_DEFAULT	`None`
SERVER_NAME	`None`
SESSION_COOKIE_DOMAIN	`False`
SESSION_COOKIE_HTTPONLY	`True`
SESSION_COOKIE_NAME	`'bossSession'`
SESSION_COOKIE_PATH	`None`
SESSION_COOKIE_SAMESITE	`'Lax'`
SESSION_COOKIE_SECURE	`False`
SESSION_REDIS	`Redis<ConnectionPool<Connection<host=localhost,port=6379,db=0>>>`
SESSION_REFRESH_EACH_REQUEST	`True`
SESSION_TYPE	`'redis'`
SQLALCHEMY_BINDS	`None`
SQLALCHEMY_COMMIT_ON_TEARDOWN	`False`
SQLALCHEMY_DATABASE_URI	`'mysql+pymysql://osp:R1v1t3d0n31@localhost/osp?charset=utf8mb4'`
SQLALCHEMY_ECHO	`False`
SQLALCHEMY_ENGINE_OPTIONS	`{'encoding': 'utf8', 'pool_use_lifo': 'False', 'pool_size': 10, 'pool_pre_ping': True}`
SQLALCHEMY_MAX_OVERFLOW	`-1`
SQLALCHEMY_NATIVE_UNICODE	`None`
SQLALCHEMY_POOL_RECYCLE	`300`
SQLALCHEMY_POOL_SIZE	`None`
SQLALCHEMY_POOL_TIMEOUT	`600`
SQLALCHEMY_RECORD_QUERIES	`None`
SQLALCHEMY_TRACK_MODIFICATIONS	`False`
TEMPLATES_AUTO_RELOAD	`None`
TESTING	`False`
TRAP_BAD_REQUEST_ERRORS	`None`
TRAP_HTTP_EXCEPTIONS	`False`
UPLOADED_DEFAULT_DEST	`'/var/www/images'`
UPLOADED_PHOTOS_DEST	`'/var/www/images'`
UPLOADED_STICKERS_DEST	`'/var/www/images'`
USE_X_SENDFILE	`False`
VIDEO_UPLOAD_EXTENSIONS	`['PNG', 'JPG', 'MP4', 'MOV', 'MKV', 'AVI']`
VIDEO_UPLOAD_TEMPFOLDER	`'/var/www/videos/temp'`
WEB_ROOT	`'/var/www/'`

Templates

themes/ABZ/channels.html

Variable	Value
allowRegistration	True
channelList	[(2, 1, 'Citizen nFluance', '7a0eacc1-62ae-44e3-91f6-74c9945a7c95', 2, 2377, 0, True, True, 'Standard', '#FFFFFF', 'slide-in-left', 'e965b7c2-3958-4e32-8c08-365282d8f9ac.png', '53088a68-4d58-426d-a0b1-965b0a04e64f.png', '88033a28-1a9f-45e4-9ac7-b19472e6b164.png', "nFluanced Citizen is my series of streams I have done playing *[Star Citizen](https://robertsspaceindustries.com/enlist?referral=STAR-KQVZ-44SB ... (149 characters truncated) ... n.\n\nMake sure to subscribe to get alerts when I go live!\n\nSocials... Here on BUFR EXCLUSIVELY! This is my BUFR ZONE to the world!", True, False, False, True, '', True, None, False, 'dd7102b6-46e3-4812-a341-75488a394d81', '7087b3b88f3a1b8ae49105589334e5f4a512864319549fa11999489d9e9e2dc0', 'irc', 2, True, True, 0, 0, False, False), (8, 1, 'nFluance Code', 'dcac1e8c-396b-40c2-a715-ee9e56b3fb7f', 3, 67, 0, True, True, 'Standard', '#FFFFFF', 'slide-in-left', '4c7e083c-7628-4588-ab66-07605e5e8e13.png', '98bd31cc-73f2-43da-a45e-dff6c58222af.jpg', '6e163dc5-2c38-4cfb-85e8-3d6754103b0c.jpg', 'nFluanced Code are my random coding streams I have done!\n\nMake sure to subscribe to get alerts when I go live!\n\nSocials... Here on BUFR EXCLUSIVELY! This is my BUFR** to the world!', True, False, False, True, '', True, None, False, 'c5febd9f-0f14-4878-b840-3cae308f0c0d', '22d1a64385961e044728e5d328b36f45a14b5a24660336e8a59606f44c1562f3', 'messenger', 2, True, True, 0, 0, False, False), (10, 1, 'nFluance MUZiK', 'eff51462-5ee1-4159-a69f-ca5637d1ffcd', 4, 5726, 0, True, True, 'Standard', '#FFFFFF', 'slide-in-left', 'dff35d7d-d30b-478e-a904-2dd055a4dab7.jpg', 'addbb68f-f168-474f-9204-9902ba7e0b43.png', '77e4e9d4-c222-4069-a781-8b6085460064.png', 'MUZiK to nFluance the world with!', False, False, False, True, '', True, None, False, '2c4ebf68-6bcf-45c1-be18-46360225fce1', '6df4e88750ac7de32bcc69f72ef3a81b77abff068334b1d02ecfe391c88e7a23', 'irc', 2, True, True, 0, 0, False, False), (12, 1, 'nFluance Gaming', '58921739-79d1-45a6-a2e1-894927a9569c', 2, 2658, 0, True, True, 'Standard', '#FFFFFF', 'slide-in-left', '3388402d-4b64-430f-8963-2696016f71c6.png', '8446acae-eeaf-44f1-9770-dedf74fbb28f.png', '5fce07d5-7edf-45c7-97be-00d461985225.png', 'Here you will find my gaming life. No I am not a full time gamer, I have a 9-5. Enjoy the madness that ensues!', True, False, False, True, '', True, None, False, 'ecce28fb-1898-4b78-b4e0-8e8b111c1418', '2dd0bbf612bd22f86eba86dcf235fda23e50a346befac6419b1b0cf849665ab0', 'irc', 2, True, True, 0, 0, False, False), (19, 1, 'HELLDIVER: nFluance', 'cbac4d5a-afea-4c66-9760-be42ca9277d7', 2, 2661, 0, True, True, 'Standard', '#FFFFFF', 'slide-in-left', 'e68d4766-5630-447b-9f93-8af59cdf8be7.webp', 'e92e9cb5-1333-49d2-acc0-834e8d7db96f.png', '6b87f286-100c-4e04-b1e2-eca9e742e328.png', 'Just my Helldivers 2 Streams and Uploaded videos. Enjoy, I will add more here soon.', True, False, False, True, 'Helldiver: nFluance Reporting for Duty!', True, 'HDnfluance', False, '1730f69c-7673-43ec-9683-26f903efe45b', '722197bb6b4930e1c250602a788ee8613d7899a202ad22e972aeabd3285ed5d7', 'irc', 2, True, True, 0, 0, False, False), (33, 21, 'SMOOTH BRAIN RADIO', '17bd2bf6-b83a-46b2-ab18-108631fe5498', 5, 3263, 0, True, True, 'Standard', '#FFFFFF', 'slide-in-left', '3cb83e89-4df7-488d-86f2-5341386e48a6.png', '1c05bea3-8332-4f63-bb63-5e4ac8ef6453.png', 'e064538c-0e4a-4a3a-9ff6-515ac25e8f0b.png', 'Smooth Brain Radio featuring nFxus nFluance, Lothens and Grimzie.\nTopics range from the normal to way the F out there!\nEnjoy and leave a comment!', True, False, False, True, '', True, None, False, 'c264a8a0-f010-442d-9ddb-39bcc9917b3e', '96a4223d6eccc6bf093e4da594892083b80f13e64ddffcaff879460c6f518a75', 'messenger', 2, True, True, 0, 0, False, False)]
current_user	<flask_security.core.AnonymousUser object at 0x7f9454a387c0>
g	<flask.g of 'app'>
messageCount	0
notifications	[]
ownedChannels	[]
recaptchaEnabled	False
request	<AnyJsonRequest 'https://bufr.zone/channel/' [GET]>
restartRequired	False
security	<flask_security.core.Security object at 0x7f949ce46820>
session	<RedisSession {'_permanent': True, '_fresh': False, 'guestUUID': 'f75d419c-f2c2-4155-a1d7-2ab3f094c825'}>
static_pages	[]
sysSettings	<id 1>
SystemOAuthProviders	[<id 1>, <id 2>]
uploadTopics	[<id 1>, <id 2>, <id 3>, <id 4>, <id 5>, <id 6>]
url_for_security	<function url_for_security at 0x7f94a0e4b670>

SQLAlchemy queries

(ms)	Action	Context	Query
0.8695	SELECT EXPLAIN	./app.py:922 (do_before_request)	SELECT ip_list.id AS ip_list_id, ip_list.`ipAddress` AS `ip_list_ipAddress`, ip_list.reason AS ip_list_reason FROM ip_list WHERE ip_list.`ipAddress` = %(ipAddress_1)s LIMIT %(param_1)s
16.6750	SELECT EXPLAIN	./app.py:930 (do_before_request)	SELECT `Guest`.id AS `Guest_id`, `Guest`.`UUID` AS `Guest_UUID`, `Guest`.last_active_at AS `Guest_last_active_at`, `Guest`.last_active_ip AS `Guest_last_active_ip` FROM `Guest` WHERE `Guest`.`UUID` = %(UUID_1)s LIMIT %(param_1)s
0.7358		./app.py:936 (do_before_request)	UPDATE `Guest` SET last_active_at=%(last_active_at)s WHERE `Guest`.id = %(Guest_id)s
2.3911		<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel`
0.8633	SELECT EXPLAIN	<unknown>	SELECT settings.`systemTheme` AS `settings_systemTheme`, settings.`maintenanceMode` AS `settings_maintenanceMode` FROM settings LIMIT %(param_1)s
1.4946	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.id = %(id_1)s LIMIT %(param_1)s
0.6502	SELECT EXPLAIN	<unknown>	SELECT user.id AS user_id, user.uuid AS user_uuid, user.username AS user_username, user.biography AS user_biography, user.`pictureLocation` AS `user_pictureLocation`, user.`bannerLocation` AS `user_bannerLocation` FROM user WHERE user.id = %(id_1)s LIMIT %(param_1)s
1.2977	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.`owningUser` = %(owningUser_1)s
0.9062	SELECT EXPLAIN	<unknown>	SELECT anon_1.`Stream_id` AS `anon_1_Stream_id`, anon_1.`Stream_uuid` AS `anon_1_Stream_uuid`, anon_1.`Stream_startTimestamp` AS `anon_1_Stream_startTimestamp`, anon_1.`Stream_endTimeStamp` AS `anon_1_Stream_endTimeStamp`, anon_1.`Stream_linkedChannel` AS `anon_1_Stream_linkedChannel`, anon_1.`Stream_streamKey` AS `anon_1_Stream_streamKey`, anon_1.`Stream_streamName` AS `anon_1_Stream_streamName`, anon_1.`Stream_topic` AS `anon_1_Stream_topic`, anon_1.`Stream_currentViewers` AS `anon_1_Stream_currentViewers`, anon_1.`Stream_totalViewers` AS `anon_1_Stream_totalViewers`, anon_1.`Stream_active` AS `anon_1_Stream_active`, anon_1.`Stream_pending` AS `anon_1_Stream_pending`, anon_1.`Stream_complete` AS `anon_1_Stream_complete`, anon_1.`Stream_recordedVideoId` AS `anon_1_Stream_recordedVideoId`, anon_1.`Stream_rtmpServer` AS `anon_1_Stream_rtmpServer`, stream_upvotes_1.id AS stream_upvotes_1_id, stream_upvotes_1.`userID` AS `stream_upvotes_1_userID`, stream_upvotes_1.`streamID` AS `stream_upvotes_1_streamID` FROM (SELECT `Stream`.id AS `Stream_id`, `Stream`.uuid AS `Stream_uuid`, `Stream`.`startTimestamp` AS `Stream_startTimestamp`, `Stream`.`endTimeStamp` AS `Stream_endTimeStamp`, `Stream`.`linkedChannel` AS `Stream_linkedChannel`, `Stream`.`streamKey` AS `Stream_streamKey`, `Stream`.`streamName` AS `Stream_streamName`, `Stream`.topic AS `Stream_topic`, `Stream`.`currentViewers` AS `Stream_currentViewers`, `Stream`.`totalViewers` AS `Stream_totalViewers`, `Stream`.active AS `Stream_active`, `Stream`.pending AS `Stream_pending`, `Stream`.complete AS `Stream_complete`, `Stream`.`recordedVideoId` AS `Stream_recordedVideoId`, `Stream`.`rtmpServer` AS `Stream_rtmpServer` FROM `Stream` WHERE `Stream`.active = true AND `Stream`.`linkedChannel` = %(linkedChannel_1)s LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN stream_upvotes AS stream_upvotes_1 ON anon_1.`Stream_id` = stream_upvotes_1.`streamID`
0.8886	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.id = %(id_1)s LIMIT %(param_1)s
0.7374	SELECT EXPLAIN	<unknown>	SELECT anon_1.`Stream_id` AS `anon_1_Stream_id`, anon_1.`Stream_uuid` AS `anon_1_Stream_uuid`, anon_1.`Stream_startTimestamp` AS `anon_1_Stream_startTimestamp`, anon_1.`Stream_endTimeStamp` AS `anon_1_Stream_endTimeStamp`, anon_1.`Stream_linkedChannel` AS `anon_1_Stream_linkedChannel`, anon_1.`Stream_streamKey` AS `anon_1_Stream_streamKey`, anon_1.`Stream_streamName` AS `anon_1_Stream_streamName`, anon_1.`Stream_topic` AS `anon_1_Stream_topic`, anon_1.`Stream_currentViewers` AS `anon_1_Stream_currentViewers`, anon_1.`Stream_totalViewers` AS `anon_1_Stream_totalViewers`, anon_1.`Stream_active` AS `anon_1_Stream_active`, anon_1.`Stream_pending` AS `anon_1_Stream_pending`, anon_1.`Stream_complete` AS `anon_1_Stream_complete`, anon_1.`Stream_recordedVideoId` AS `anon_1_Stream_recordedVideoId`, anon_1.`Stream_rtmpServer` AS `anon_1_Stream_rtmpServer`, stream_upvotes_1.id AS stream_upvotes_1_id, stream_upvotes_1.`userID` AS `stream_upvotes_1_userID`, stream_upvotes_1.`streamID` AS `stream_upvotes_1_streamID` FROM (SELECT `Stream`.id AS `Stream_id`, `Stream`.uuid AS `Stream_uuid`, `Stream`.`startTimestamp` AS `Stream_startTimestamp`, `Stream`.`endTimeStamp` AS `Stream_endTimeStamp`, `Stream`.`linkedChannel` AS `Stream_linkedChannel`, `Stream`.`streamKey` AS `Stream_streamKey`, `Stream`.`streamName` AS `Stream_streamName`, `Stream`.topic AS `Stream_topic`, `Stream`.`currentViewers` AS `Stream_currentViewers`, `Stream`.`totalViewers` AS `Stream_totalViewers`, `Stream`.active AS `Stream_active`, `Stream`.pending AS `Stream_pending`, `Stream`.complete AS `Stream_complete`, `Stream`.`recordedVideoId` AS `Stream_recordedVideoId`, `Stream`.`rtmpServer` AS `Stream_rtmpServer` FROM `Stream` WHERE `Stream`.active = true AND `Stream`.`linkedChannel` = %(linkedChannel_1)s LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN stream_upvotes AS stream_upvotes_1 ON anon_1.`Stream_id` = stream_upvotes_1.`streamID`
0.8972	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.id = %(id_1)s LIMIT %(param_1)s
0.6237	SELECT EXPLAIN	<unknown>	SELECT anon_1.`Stream_id` AS `anon_1_Stream_id`, anon_1.`Stream_uuid` AS `anon_1_Stream_uuid`, anon_1.`Stream_startTimestamp` AS `anon_1_Stream_startTimestamp`, anon_1.`Stream_endTimeStamp` AS `anon_1_Stream_endTimeStamp`, anon_1.`Stream_linkedChannel` AS `anon_1_Stream_linkedChannel`, anon_1.`Stream_streamKey` AS `anon_1_Stream_streamKey`, anon_1.`Stream_streamName` AS `anon_1_Stream_streamName`, anon_1.`Stream_topic` AS `anon_1_Stream_topic`, anon_1.`Stream_currentViewers` AS `anon_1_Stream_currentViewers`, anon_1.`Stream_totalViewers` AS `anon_1_Stream_totalViewers`, anon_1.`Stream_active` AS `anon_1_Stream_active`, anon_1.`Stream_pending` AS `anon_1_Stream_pending`, anon_1.`Stream_complete` AS `anon_1_Stream_complete`, anon_1.`Stream_recordedVideoId` AS `anon_1_Stream_recordedVideoId`, anon_1.`Stream_rtmpServer` AS `anon_1_Stream_rtmpServer`, stream_upvotes_1.id AS stream_upvotes_1_id, stream_upvotes_1.`userID` AS `stream_upvotes_1_userID`, stream_upvotes_1.`streamID` AS `stream_upvotes_1_streamID` FROM (SELECT `Stream`.id AS `Stream_id`, `Stream`.uuid AS `Stream_uuid`, `Stream`.`startTimestamp` AS `Stream_startTimestamp`, `Stream`.`endTimeStamp` AS `Stream_endTimeStamp`, `Stream`.`linkedChannel` AS `Stream_linkedChannel`, `Stream`.`streamKey` AS `Stream_streamKey`, `Stream`.`streamName` AS `Stream_streamName`, `Stream`.topic AS `Stream_topic`, `Stream`.`currentViewers` AS `Stream_currentViewers`, `Stream`.`totalViewers` AS `Stream_totalViewers`, `Stream`.active AS `Stream_active`, `Stream`.pending AS `Stream_pending`, `Stream`.complete AS `Stream_complete`, `Stream`.`recordedVideoId` AS `Stream_recordedVideoId`, `Stream`.`rtmpServer` AS `Stream_rtmpServer` FROM `Stream` WHERE `Stream`.active = true AND `Stream`.`linkedChannel` = %(linkedChannel_1)s LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN stream_upvotes AS stream_upvotes_1 ON anon_1.`Stream_id` = stream_upvotes_1.`streamID`
0.6666	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.id = %(id_1)s LIMIT %(param_1)s
0.6225	SELECT EXPLAIN	<unknown>	SELECT anon_1.`Stream_id` AS `anon_1_Stream_id`, anon_1.`Stream_uuid` AS `anon_1_Stream_uuid`, anon_1.`Stream_startTimestamp` AS `anon_1_Stream_startTimestamp`, anon_1.`Stream_endTimeStamp` AS `anon_1_Stream_endTimeStamp`, anon_1.`Stream_linkedChannel` AS `anon_1_Stream_linkedChannel`, anon_1.`Stream_streamKey` AS `anon_1_Stream_streamKey`, anon_1.`Stream_streamName` AS `anon_1_Stream_streamName`, anon_1.`Stream_topic` AS `anon_1_Stream_topic`, anon_1.`Stream_currentViewers` AS `anon_1_Stream_currentViewers`, anon_1.`Stream_totalViewers` AS `anon_1_Stream_totalViewers`, anon_1.`Stream_active` AS `anon_1_Stream_active`, anon_1.`Stream_pending` AS `anon_1_Stream_pending`, anon_1.`Stream_complete` AS `anon_1_Stream_complete`, anon_1.`Stream_recordedVideoId` AS `anon_1_Stream_recordedVideoId`, anon_1.`Stream_rtmpServer` AS `anon_1_Stream_rtmpServer`, stream_upvotes_1.id AS stream_upvotes_1_id, stream_upvotes_1.`userID` AS `stream_upvotes_1_userID`, stream_upvotes_1.`streamID` AS `stream_upvotes_1_streamID` FROM (SELECT `Stream`.id AS `Stream_id`, `Stream`.uuid AS `Stream_uuid`, `Stream`.`startTimestamp` AS `Stream_startTimestamp`, `Stream`.`endTimeStamp` AS `Stream_endTimeStamp`, `Stream`.`linkedChannel` AS `Stream_linkedChannel`, `Stream`.`streamKey` AS `Stream_streamKey`, `Stream`.`streamName` AS `Stream_streamName`, `Stream`.topic AS `Stream_topic`, `Stream`.`currentViewers` AS `Stream_currentViewers`, `Stream`.`totalViewers` AS `Stream_totalViewers`, `Stream`.active AS `Stream_active`, `Stream`.pending AS `Stream_pending`, `Stream`.complete AS `Stream_complete`, `Stream`.`recordedVideoId` AS `Stream_recordedVideoId`, `Stream`.`rtmpServer` AS `Stream_rtmpServer` FROM `Stream` WHERE `Stream`.active = true AND `Stream`.`linkedChannel` = %(linkedChannel_1)s LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN stream_upvotes AS stream_upvotes_1 ON anon_1.`Stream_id` = stream_upvotes_1.`streamID`
0.7298	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.id = %(id_1)s LIMIT %(param_1)s
0.5841	SELECT EXPLAIN	<unknown>	SELECT anon_1.`Stream_id` AS `anon_1_Stream_id`, anon_1.`Stream_uuid` AS `anon_1_Stream_uuid`, anon_1.`Stream_startTimestamp` AS `anon_1_Stream_startTimestamp`, anon_1.`Stream_endTimeStamp` AS `anon_1_Stream_endTimeStamp`, anon_1.`Stream_linkedChannel` AS `anon_1_Stream_linkedChannel`, anon_1.`Stream_streamKey` AS `anon_1_Stream_streamKey`, anon_1.`Stream_streamName` AS `anon_1_Stream_streamName`, anon_1.`Stream_topic` AS `anon_1_Stream_topic`, anon_1.`Stream_currentViewers` AS `anon_1_Stream_currentViewers`, anon_1.`Stream_totalViewers` AS `anon_1_Stream_totalViewers`, anon_1.`Stream_active` AS `anon_1_Stream_active`, anon_1.`Stream_pending` AS `anon_1_Stream_pending`, anon_1.`Stream_complete` AS `anon_1_Stream_complete`, anon_1.`Stream_recordedVideoId` AS `anon_1_Stream_recordedVideoId`, anon_1.`Stream_rtmpServer` AS `anon_1_Stream_rtmpServer`, stream_upvotes_1.id AS stream_upvotes_1_id, stream_upvotes_1.`userID` AS `stream_upvotes_1_userID`, stream_upvotes_1.`streamID` AS `stream_upvotes_1_streamID` FROM (SELECT `Stream`.id AS `Stream_id`, `Stream`.uuid AS `Stream_uuid`, `Stream`.`startTimestamp` AS `Stream_startTimestamp`, `Stream`.`endTimeStamp` AS `Stream_endTimeStamp`, `Stream`.`linkedChannel` AS `Stream_linkedChannel`, `Stream`.`streamKey` AS `Stream_streamKey`, `Stream`.`streamName` AS `Stream_streamName`, `Stream`.topic AS `Stream_topic`, `Stream`.`currentViewers` AS `Stream_currentViewers`, `Stream`.`totalViewers` AS `Stream_totalViewers`, `Stream`.active AS `Stream_active`, `Stream`.pending AS `Stream_pending`, `Stream`.complete AS `Stream_complete`, `Stream`.`recordedVideoId` AS `Stream_recordedVideoId`, `Stream`.`rtmpServer` AS `Stream_rtmpServer` FROM `Stream` WHERE `Stream`.active = true AND `Stream`.`linkedChannel` = %(linkedChannel_1)s LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN stream_upvotes AS stream_upvotes_1 ON anon_1.`Stream_id` = stream_upvotes_1.`streamID`
0.6540	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.id = %(id_1)s LIMIT %(param_1)s
0.3610	SELECT EXPLAIN	<unknown>	SELECT user.id AS user_id, user.uuid AS user_uuid, user.username AS user_username, user.biography AS user_biography, user.`pictureLocation` AS `user_pictureLocation`, user.`bannerLocation` AS `user_bannerLocation` FROM user WHERE user.id = %(id_1)s LIMIT %(param_1)s
0.7787	SELECT EXPLAIN	<unknown>	SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chatEnabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation` AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.`channelBannerLocation` AS `Channel_channelBannerLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `Channel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`vanityURL` AS `Channel_vanityURL`, `Channel`.private AS `Channel_private`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`chatFormat` AS `Channel_chatFormat`, `Channel`.`chatHistory` AS `Channel_chatHistory`, `Channel`.`allowGuestNickChange` AS `Channel_allowGuestNickChange`, `Channel`.`showHome` AS `Channel_showHome`, `Channel`.`maxVideoRetention` AS `Channel_maxVideoRetention`, `Channel`.`maxClipRetention` AS `Channel_maxClipRetention`, `Channel`.`hubEnabled` AS `Channel_hubEnabled`, `Channel`.`hubNSFW` AS `Channel_hubNSFW` FROM `Channel` WHERE `Channel`.`owningUser` = %(owningUser_1)s
0.5808	SELECT EXPLAIN	<unknown>	SELECT anon_1.`Stream_id` AS `anon_1_Stream_id`, anon_1.`Stream_uuid` AS `anon_1_Stream_uuid`, anon_1.`Stream_startTimestamp` AS `anon_1_Stream_startTimestamp`, anon_1.`Stream_endTimeStamp` AS `anon_1_Stream_endTimeStamp`, anon_1.`Stream_linkedChannel` AS `anon_1_Stream_linkedChannel`, anon_1.`Stream_streamKey` AS `anon_1_Stream_streamKey`, anon_1.`Stream_streamName` AS `anon_1_Stream_streamName`, anon_1.`Stream_topic` AS `anon_1_Stream_topic`, anon_1.`Stream_currentViewers` AS `anon_1_Stream_currentViewers`, anon_1.`Stream_totalViewers` AS `anon_1_Stream_totalViewers`, anon_1.`Stream_active` AS `anon_1_Stream_active`, anon_1.`Stream_pending` AS `anon_1_Stream_pending`, anon_1.`Stream_complete` AS `anon_1_Stream_complete`, anon_1.`Stream_recordedVideoId` AS `anon_1_Stream_recordedVideoId`, anon_1.`Stream_rtmpServer` AS `anon_1_Stream_rtmpServer`, stream_upvotes_1.id AS stream_upvotes_1_id, stream_upvotes_1.`userID` AS `stream_upvotes_1_userID`, stream_upvotes_1.`streamID` AS `stream_upvotes_1_streamID` FROM (SELECT `Stream`.id AS `Stream_id`, `Stream`.uuid AS `Stream_uuid`, `Stream`.`startTimestamp` AS `Stream_startTimestamp`, `Stream`.`endTimeStamp` AS `Stream_endTimeStamp`, `Stream`.`linkedChannel` AS `Stream_linkedChannel`, `Stream`.`streamKey` AS `Stream_streamKey`, `Stream`.`streamName` AS `Stream_streamName`, `Stream`.topic AS `Stream_topic`, `Stream`.`currentViewers` AS `Stream_currentViewers`, `Stream`.`totalViewers` AS `Stream_totalViewers`, `Stream`.active AS `Stream_active`, `Stream`.pending AS `Stream_pending`, `Stream`.complete AS `Stream_complete`, `Stream`.`recordedVideoId` AS `Stream_recordedVideoId`, `Stream`.`rtmpServer` AS `Stream_rtmpServer` FROM `Stream` WHERE `Stream`.active = true AND `Stream`.`linkedChannel` = %(linkedChannel_1)s LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN stream_upvotes AS stream_upvotes_1 ON anon_1.`Stream_id` = stream_upvotes_1.`streamID`

Log Messages

No messages logged.

Route List

URL route	Endpoint name	HTTP methods	Is alias	Redirect to
/	root.main_page	GET, HEAD, OPTIONS	False	None
/apiv1/	api.doc	GET, HEAD, OPTIONS	False	None
/apiv1/	api.root	GET, HEAD, OPTIONS	False	None
/apiv1/channel/	api.channel_api_1__list_channels	GET, HEAD, OPTIONS, POST	False	None
/apiv1/channel/<string:channelEndpointID>	api.channel_api_1__list_channel	DELETE, GET, HEAD, OPTIONS, PUT	False	None
/apiv1/channel/<string:channelEndpointID>/invites	api.channel_api_1__invites	DELETE, GET, HEAD, OPTIONS, POST	False	None
/apiv1/channel/<string:channelEndpointID>/restreams	api.channel_api_1__get_restreams	GET, HEAD, OPTIONS	False	None
/apiv1/channel/<string:channelEndpointID>/streams	api.channel_api_1__streams	GET, HEAD, OPTIONS	False	None
/apiv1/channel/activeChannels	api.channel_api_1__active_channels	GET, HEAD, OPTIONS	False	None
/apiv1/channel/authed/	api.channel_api_1__list_channel_authed	GET, HEAD, OPTIONS	False	None
/apiv1/channel/hubChannels	api.channel_api_1_hub_channels	GET, HEAD, OPTIONS	False	None
/apiv1/channel/hubChannelsLive	api.channel_api_1__active_hub_channels	GET, HEAD, OPTIONS	False	None
/apiv1/channel/search	api.channel_api_1__search_channels	OPTIONS, POST	False	None
/apiv1/clip/	api.clip_api_1__list_clips	GET, HEAD, OPTIONS	False	None
/apiv1/clip/<int:clipID>	api.clip_api_1__list_clip	DELETE, GET, HEAD, OPTIONS, PUT	False	None
/apiv1/clip/search	api.clip_api_1__search_clips	OPTIONS, POST	False	None
/apiv1/rtmp/playbackauth	api.rtmp_api_1_rtmp_playbackauth	OPTIONS, POST	False	None
/apiv1/rtmp/reccheck	api.rtmp_api_1_rtmp_reccheck	OPTIONS, POST	False	None
/apiv1/rtmp/recclose	api.rtmp_api_1_rtmp_recclose	OPTIONS, POST	False	None
/apiv1/rtmp/stage1	api.rtmp_api_1_rtmp_stage1	OPTIONS, POST	False	None
/apiv1/rtmp/stage2	api.rtmp_api_1_rtmp_stage2	OPTIONS, POST	False	None
/apiv1/rtmp/streamclose	api.rtmp_api_1_rtmp_streamclose	OPTIONS, POST	False	None
/apiv1/server/	api.server_api_1__server	GET, HEAD, OPTIONS	False	None
/apiv1/server/edges	api.server_api_1__edges	GET, HEAD, OPTIONS	False	None
/apiv1/server/ping	api.server_api_1__ping	GET, HEAD, OPTIONS	False	None
/apiv1/server/rtmp	api.server_api_1__rtmp	DELETE, GET, HEAD, OPTIONS, POST	False	None
/apiv1/stream/	api.stream_api_1__list_streams	GET, HEAD, OPTIONS	False	None
/apiv1/stream/<int:streamID>	api.stream_api_1__list_stream	GET, HEAD, OPTIONS, PUT	False	None
/apiv1/stream/search	api.stream_api_1__search_streams	OPTIONS, POST	False	None
/apiv1/swagger.json	api.specs	GET, HEAD, OPTIONS	False	None
/apiv1/topic/	api.topic_api_1__list_topics	GET, HEAD, OPTIONS	False	None
/apiv1/topic/<int:topicID>	api.topic_api_1__list_topic	GET, HEAD, OPTIONS	False	None
/apiv1/topic/search	api.topic_api_1__search_topics	OPTIONS, POST	False	None
/apiv1/user/	api.user_api_1__admin_user	DELETE, GET, HEAD, OPTIONS, POST	False	None
/apiv1/user/<string:username>	api.user_api_1__list_user	GET, HEAD, OPTIONS	False	None
/apiv1/user/role	api.user_api_1__role_mgmt	DELETE, OPTIONS, POST	False	None
/apiv1/user/search	api.user_api_1__search_users	OPTIONS, POST	False	None
/apiv1/video/	api.video_api_1__list_videos	GET, HEAD, OPTIONS	False	None
/apiv1/video/<int:videoID>	api.video_api_1__list_video	DELETE, GET, HEAD, OPTIONS, PUT	False	None
/apiv1/video/search	api.video_api_1__search_videos	OPTIONS, POST	False	None
/apiv1/xmpp/auth	api.xmpp_api_1_xmpp_auth	OPTIONS, POST	False	None
/apiv1/xmpp/isuser	api.xmpp_api_1_xmppisuser	OPTIONS, POST	False	None
/auth	root.auth_check	GET, HEAD, OPTIONS, POST	False	None
/c/<vanityURL>	root.vanityURL_channel_link	GET, HEAD, OPTIONS	False	None
/c/<vanityURL>/live	root.vanityURL_live_link	GET, HEAD, OPTIONS	False	None
/channel/	channel.channels_page	GET, HEAD, OPTIONS	False	None
/channel/<int:chanID>/	channel.channel_view_page	GET, HEAD, OPTIONS	False	None
/channel/<loc>/stream	channel.channel_stream_link_page	GET, HEAD, OPTIONS	False	None
/channel/link/<channelLoc>/	channel.channel_view_link_page	GET, HEAD, OPTIONS	False	None
/clip/<clipID>	clip.view_clip_page	GET, HEAD, OPTIONS	False	None
/clip/<clipID>/change	clip.clip_change_page	OPTIONS, POST	False	None
/clip/<clipID>/delete	clip.delete_clip_page	GET, HEAD, OPTIONS	False	None
/confirm	security.send_confirmation	GET, HEAD, OPTIONS, POST	False	None
/confirm/<token>	security.confirm_email	GET, HEAD, OPTIONS, POST	False	None
/fs-static/<path:filename>	security.static	GET, HEAD, OPTIONS	False	None
/login	security.login	GET, HEAD, OPTIONS, POST	False	None
/logout	security.logout	GET, HEAD, OPTIONS, POST	False	None
/m3u8/stream/index.m3u8	m3u8.get_stream_index	GET, HEAD, OPTIONS	False	None
/m3u8/video/index.m3u8	m3u8.get_all_video_index	GET, HEAD, OPTIONS	False	None
/messages	root.messages_page	GET, HEAD, OPTIONS	False	None
/notifications	root.notification_page	GET, HEAD, OPTIONS	False	None
/oauth/authorize/<provider>	oauth.oAuthAuthorize	GET, HEAD, OPTIONS	False	None
/oauth/convert/<provider>	oauth.oAuthConvert	OPTIONS, POST	False	None
/oauth/login/<provider>	oauth.oAuthLogin	GET, HEAD, OPTIONS	False	None
/p/<static_page>	root.render_staticPage	GET, HEAD, OPTIONS	False	None
/play/<videoID>	play.view_vid_page	GET, HEAD, OPTIONS	False	None
/play/<videoID>/change	play.vid_change_page	OPTIONS, POST	False	None
/play/<videoID>/clip	play.vid_clip_page	OPTIONS, POST	False	None
/play/<videoID>/comment	play.comments_vid_page	GET, HEAD, OPTIONS, POST	False	None
/play/<videoID>/delete	play.delete_vid_page	GET, HEAD, OPTIONS	False	None
/play/<videoID>/move	play.vid_move_page	OPTIONS, POST	False	None
/profile/<username>	profile.profile_view_page	GET, HEAD, OPTIONS	False	None
/proxy-adapt/<channelLoc>.m3u8	root.proxy_adaptive_redirect	GET, HEAD, OPTIONS	False	None
/proxy-adapt/<channelLoc>/<file>	root.proxy_adaptive_subfolder_redirect	GET, HEAD, OPTIONS	False	None
/proxy/<channelLoc>/<file>	root.proxy_redirect	GET, HEAD, OPTIONS	False	None
/register	security.register	GET, HEAD, OPTIONS, POST	False	None
/reset	security.forgot_password	GET, HEAD, OPTIONS, POST	False	None
/reset/<token>	security.reset_password	GET, HEAD, OPTIONS, POST	False	None
/robots.txt	root.static_from_root	GET, HEAD, OPTIONS	False	None
/rtmpCheck	root.rtmp_check	GET, HEAD, OPTIONS, POST	False	None
/search	root.search_page	GET, HEAD, OPTIONS, POST	False	None
/settings/admin/channels/	settings.admin_settings.admin_settings_channels.admin_channels_page	GET, HEAD, OPTIONS	False	None
/settings/admin/create_test_task	settings.admin_settings.createtestask	GET, HEAD, OPTIONS	False	None
/settings/admin/dashboard	settings.admin_settings.admin_dashboard	GET, HEAD, OPTIONS	False	None
/settings/admin/edge/	settings.admin_settings.admin_settings_edge.edge_page	GET, HEAD, OPTIONS	False	None
/settings/admin/edge/	settings.admin_settings.admin_settings_edge.edge_post	OPTIONS, POST	False	None
/settings/admin/features	settings.admin_settings.admin_devFeatures	GET, HEAD, OPTIONS	False	None
/settings/admin/oauth/	settings.admin_settings.admin_settings_oauth.ouath_page	GET, HEAD, OPTIONS	False	None
/settings/admin/oauth/	settings.admin_settings.admin_settings_oauth.oauth_post	OPTIONS, POST	False	None
/settings/admin/roles/	settings.admin_settings.admin_settings_roles.roles_page	GET, HEAD, OPTIONS	False	None
/settings/admin/roles/<string:role_name>	settings.admin_settings.admin_settings_roles.role_get_perms	GET, HEAD, OPTIONS	False	None
/settings/admin/roles/custom	settings.admin_settings.admin_settings_roles.role_set_perms	OPTIONS, POST	False	None
/settings/admin/roles/delete	settings.admin_settings.admin_settings_roles.delete_custom_role	OPTIONS, POST	False	None
/settings/admin/rtmp/	settings.admin_settings.admin_settings_rtmp.rtmp_page	GET, HEAD, OPTIONS	False	None
/settings/admin/rtmp/	settings.admin_settings.admin_settings_rtmp.rtmp_post	OPTIONS, POST	False	None
/settings/admin/rtmpstat/<node>	settings.admin_settings.rtmpStat_page	GET, HEAD, OPTIONS	False	None
/settings/admin/run_task/<task>	settings.admin_settings.run_task	GET, HEAD, OPTIONS	False	None
/settings/admin/scheduler	settings.admin_settings.scheduler_page	GET, HEAD, OPTIONS	False	None
/settings/admin/settings/	settings.admin_settings.global_settings.global_settings_page	GET, HEAD, OPTIONS	False	None
/settings/admin/settings/	settings.admin_settings.global_settings.global_settings_post	OPTIONS, POST	False	None
/settings/admin/stickers/	settings.admin_settings.admin_settings_stickers.stickers_page	GET, HEAD, OPTIONS	False	None
/settings/admin/stickers/	settings.admin_settings.admin_settings_stickers.stickers_post	OPTIONS, POST	False	None
/settings/admin/streams/	settings.admin_settings.admin_settings_streams.streams_page	GET, HEAD, OPTIONS	False	None
/settings/admin/topics/	settings.admin_settings.admin_settings_topics.topics_page	GET, HEAD, OPTIONS	False	None
/settings/admin/topics/	settings.admin_settings.admin_settings_topics.topics_post	OPTIONS, POST	False	None
/settings/admin/users/	settings.admin_settings.admin_settings_users.users_admin_page	GET, HEAD, OPTIONS	False	None
/settings/admin/users/	settings.admin_settings.admin_settings_users.users_admin_post	OPTIONS, POST	False	None
/settings/admin/users/action/<string:action>	settings.admin_settings.admin_settings_users.users_admin_action	GET, HEAD, OPTIONS	False	None
/settings/admin/webhooks/	settings.admin_settings.admin_settings_webhooks.admin_page	GET, HEAD, OPTIONS	False	None
/settings/api	settings.settings_apikeys_page	GET, HEAD, OPTIONS	False	None
/settings/api/<string:action>	settings.settings_apikeys_post_page	OPTIONS, POST	False	None
/settings/channels/	settings.channel_settings.settings_channels_page	GET, HEAD, OPTIONS, POST	False	None
/settings/channels/chat	settings.channel_settings.settings_channels_chat_page	GET, HEAD, OPTIONS, POST	False	None
/settings/channels/streamKey	settings.channel_settings.settings_channel_new_stream_key	OPTIONS, POST	False	None
/settings/initialSetup	settings.initialSetup	OPTIONS, POST	False	None
/settings/user/	settings.user_settings.user_page	GET, HEAD, OPTIONS, POST	False	None
/settings/user/addInviteCode	settings.user_settings.user_addInviteCode	GET, HEAD, OPTIONS	False	None
/settings/user/deleteSelf	settings.user_settings.user_delete_own_account	OPTIONS, POST	False	None
/settings/user/subscriptions	settings.user_settings.subscription_page	GET, HEAD, OPTIONS	False	None
/static/<path:filename>	static	GET, HEAD, OPTIONS	False	None
/streamer/	streamers.streamers_page	GET, HEAD, OPTIONS	False	None
/streamer/<userID>/	streamers.streamers_view_page	GET, HEAD, OPTIONS	False	None
/sw.js	root.static_from_root_sw	GET, HEAD, OPTIONS	False	None
/swaggerui/<path:filename>	restx_doc.static	GET, HEAD, OPTIONS	False	None
/tf-rescue	security.two_factor_rescue	GET, HEAD, OPTIONS, POST	False	None
/tf-select	security.tf_select	GET, HEAD, OPTIONS, POST	False	None
/tf-setup	security.two_factor_setup	GET, HEAD, OPTIONS, POST	False	None
/tf-validate	security.two_factor_token_validation	GET, HEAD, OPTIONS, POST	False	None
/topic/	topic.topic_page	GET, HEAD, OPTIONS	False	None
/topic/<topicID>/	topic.topic_view_page	GET, HEAD, OPTIONS	False	None
/u/<username>	root.vanityURL_username_link	GET, HEAD, OPTIONS	False	None
/unsubscribe	root.unsubscribe_page	GET, HEAD, OPTIONS	False	None
/upload/video-details	upload.upload_vid	OPTIONS, POST	False	None
/upload/video-files	upload.upload	GET, HEAD, OPTIONS, POST	False	None
/verify	security.verify	GET, HEAD, OPTIONS, POST	False	None
/view/<loc>/	liveview.view_page	GET, HEAD, OPTIONS	False	None
/xmpp	root.xmpp_proxy	DELETE, GET, HEAD, OPTIONS, POST	False	None

Profiler not active

The profiler is not activated, activate it to use it

flask.g content

Key	Value
_login_user	<flask_security.core.AnonymousUser object at 0x7f9454a387c0>
debug_toolbar	<flask_debugtoolbar.DebugToolbarExtension object at 0x7f949d1541c0>
identity	<AnonymousIdentity id="None" auth_type="None" provides=set()>

Website	bufr.zone
Repository	boss-group/flask-nginx-rtmp-manager
Wiki	bufr-open-streaming-system.readthedocs.io
Reddit	/r/bufr.zone
Discord	BUFR OPEN STREAMING SYSTEM

Channels

Citizen nFluance

2377

nFluance Code

67

nFluance MUZiK

5726

nFluance Gaming

2658

HELLDIVER: nFluance

2661

SMOOTH BRAIN RADIO

3263

Versions

Installed Packages

Resource Usage

HTTP Headers

Request Vars

View information

COOKIES Variables

SESSION Variables

GET Variables

POST Variables

Config

Templates

themes/ABZ/channels.html

SQLAlchemy queries

Log Messages

Route List

Profiler not active

flask.g content