BUFR OPEN STREAMING SYSTEM Version 0.0.35a
Website | bufr.zone |
Repository | boss-group/flask-nginx-rtmp-manager |
Wiki | bufr-open-streaming-system.readthedocs.io |
/r/bufr.zone | |
Discord | BUFR OPEN STREAMING SYSTEM |
MIT License
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 | Value |
---|---|
User CPU time | 70.951 msec |
System CPU time | 2.539 msec |
Total CPU time | 73.490 msec |
Elapsed time | 85.480 msec |
Context switches | 62 voluntary, 1 involuntary |
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.179 |
REQUEST_METHOD | GET |
SCRIPT_NAME | |
SERVER_NAME | nFxedPLEX.bufr.zone |
SERVER_PORT | 5002 |
SERVER_PROTOCOL | HTTP/1.0 |
SERVER_SOFTWARE | gevent/23.9.0 gunicorn/20.1.0 |
View Function | args | kwargs |
---|---|---|
blueprints.channels.channels_page | [] | None |
Variable | Value |
---|---|
'route' | 'b5a02f0d5ab38b7682260ef941ba2a7b' |
'bossSession' | '0eaf7b15-4547-473b-9ef2-d7fcde1e26a6' |
Variable | Value |
---|---|
'_permanent' | True |
'_fresh' | False |
'guestUUID' | '5b5053a6-4135-41a5-a300-38ddecd3bf01' |
Variable | Value |
---|
Variable | Value |
---|
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 0x92c460> |
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 | 'BZDP - Email Confirmation Request' |
SECURITY_EMAIL_SUBJECT_PASSWORD_CHANGE_NOTICE | 'Your password has been changed' |
SECURITY_EMAIL_SUBJECT_PASSWORD_NOTICE | 'BZDP - Password Reset Notification' |
SECURITY_EMAIL_SUBJECT_PASSWORD_RESET | 'BZDP - Password Reset Request' |
SECURITY_EMAIL_SUBJECT_PASSWORDLESS | 'Login instructions' |
SECURITY_EMAIL_SUBJECT_REGISTER | 'BZDP - 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_bcrypt', 'django_bcrypt_sha256', 'django_salted_sha1', 'django_argon2', 'django_salted_md5', 'django_pbkdf2_sha1', 'django_des_crypt', 'plaintext', 'django_pbkdf2_sha256'} |
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 | 'BZDP' |
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 0x7fcda2c741f0>, '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/' |
Variable | Value |
---|---|
allowRegistration | True |
channelList | [(2, 1, 'Citizen nFluance', '7a0eacc1-62ae-44e3-91f6-74c9945a7c95', 2, 1528, 1, True, True, 'Standard', '#FFFFFF', 'slide-in-left', 'e965b7c2-3958-4e32-8c08-365282d8f9ac.png', 'da6d4f77-9f1a-4bdc-809e-dfed08148831.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, 58, 1, 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, 2372, 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, 2650, 1, 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, 2656, 1, 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), (23, 14, 'Smooth Brain Radio', '9862d489-c5be-48bd-bf10-cea1a704e46e', 5, 1397, 1, True, True, 'Standard', '#FFFFFF', 'slide-in-left', 'f27116fe-f343-4504-a651-9c062ebe2fb4.png', '86611672-c6b6-4f94-93e2-dfef921aa686.png', '28a43eca-abac-4e31-a792-f481b53b5247.png', '**SMOOTH BRAIN RADIO**:\nWhere we try and add a wrinkle into that smooth brain of yours!', True, False, False, True, 'EPISODE XX', True, 'SBR', False, '044e2293-07c4-4d97-9afc-64429f3f8cad', '41b957a3ce5371385696507909b4eb2c14ac51941cc29e57961999434248555e', 'messenger', 2, True, True, 0, 0, False, False), (24, 14, 'SBR EARLY ACCESS', '1e1d0b7c-a33f-4719-9af7-e865545e8d7b', 5, 7, 0, True, True, 'Standard', '#FFFFFF', 'slide-in-left', 'de148eb3-c02f-488d-a08b-2a30313835a6.png', '716b58a5-251c-49c7-a88f-5edcd3cf2f04.png', None, "**SMOOTH BRAIN RADIO EARLY ACCESS:** Where we try and add a wrinkle into that smooth brain of yours a little quicker then those regular ol BONOBO's out there!", True, True, False, True, 'EPISODE XX', True, None, True, '740b7c77-2c1d-4307-a1a7-ab4993dd39f9', '4309d1d915447f180aca4ececdf22e1b3328b0123de29867167cdc3a3c75091d', 'messenger', 2, True, True, 0, 0, False, False)] |
current_user | <flask_security.core.AnonymousUser object at 0x7fcd9c7cd6d0> |
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 0x7fcd9ec69850> |
session | <RedisSession {'_permanent': True, '_fresh': False, 'guestUUID': '5b5053a6-4135-41a5-a300-38ddecd3bf01'}> |
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 0x7fcda2c715e0> |
(ms) | Action | Context | Query |
---|---|---|---|
0.8388 |
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
|
4.7779 |
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.7551 | ./app.py:936 (do_before_request) |
UPDATE `Guest` SET last_active_at=%(last_active_at)s WHERE `Guest`.id = %(Guest_id)s
|
|
2.4517 | <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.8903 |
SELECT EXPLAIN |
<unknown> |
SELECT settings.`systemTheme` AS `settings_systemTheme`, settings.`maintenanceMode` AS `settings_maintenanceMode`
FROM settings
LIMIT %(param_1)s
|
0.9561 |
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.9269 |
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`
|
1.4739 |
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
|
1.1830 |
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`
|
1.4322 |
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.7429 |
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.8709 |
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.7102 |
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.7188 |
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.6104 |
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.6516 |
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.4454 |
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.6931 |
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.6776 |
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.7248 |
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
|
No messages logged.
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 |
Key | Value |
---|---|
_login_user | <flask_security.core.AnonymousUser object at 0x7fcd9c7cd6d0> |
debug_toolbar | <flask_debugtoolbar.DebugToolbarExtension object at 0x7fcd9ef7e160> |
identity | <AnonymousIdentity id="None" auth_type="None" provides=set()> |