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
Close
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 |
Close
Resource Usage
| Resource | Value |
|---|---|
| User CPU time | 74.740 msec |
| System CPU time | 5.233 msec |
| Total CPU time | 79.973 msec |
| Elapsed time | 94.025 msec |
| Context switches | 55 voluntary, 12 involuntary |
Close
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/streamer/1 |
| 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 | 5000 |
| SERVER_PROTOCOL | HTTP/1.0 |
| SERVER_SOFTWARE | gevent/23.9.0 gunicorn/20.1.0 |
Close
Request Vars
View information
| View Function | args | kwargs |
|---|---|---|
| blueprints.streamers.streamers_view_page | [] | userID=1 |
COOKIES Variables
| Variable | Value |
|---|---|
| 'bossSession' | 'c4d63ae2-b606-4067-b578-2ba3202d1db7' |
| 'route' | '48d85fabdf12057a0bb461705e9003ca' |
SESSION Variables
| Variable | Value |
|---|---|
| '_permanent' | True |
| '_fresh' | False |
| 'guestUUID' | '5826565e-2344-4498-a25c-51107f9f8687' |
GET Variables
| Variable | Value |
|---|
POST Variables
| Variable | Value |
|---|
Close
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 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_salted_md5', 'plaintext', 'django_bcrypt_sha256', 'django_bcrypt', 'django_des_crypt', 'django_pbkdf2_sha256', 'django_argon2', 'django_pbkdf2_sha1', 'django_salted_sha1'} |
| 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 0x7f587fdc01f0>, '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/' |
Close
Templates
themes/ABZ/videoListView.html
| Variable | Value |
|---|---|
| allowRegistration | True |
| clipsList | [] |
| current_user | <flask_security.core.AnonymousUser object at 0x7f58755a8190> |
| g | <flask.g of 'app'> |
| messageCount | 0 |
| notifications | [] |
| openStreams | [] |
| ownedChannels | [] |
| recaptchaEnabled | False |
| recordedVids | [(139, '0c1574f6-daef-4ecb-87ae-efc96de03a7d', datetime.datetime(2025, 6, 17, 22, 40, 51), 1, 'Strange grouping of stars Elite Dangerous', 2, 'Testing uploads', 2, 37, 192.401, '7a0eacc1-62ae-44e3-91f6-74c9945a7c95/9e91822a-c040-4ed5-8653-47e2f8664e76_20250617_224051.mp4', '7a0eacc1-62ae-44e3-91f6-74c9945a7c95/9e91822a-c040-4ed5-8653-47e2f8664e76_20250617_224051.png', '7a0eacc1-62ae-44e3-91f6-74c9945a7c95/9e91822a-c040-4ed5-8653-47e2f8664e76_20250617_224051.gif', False, True, True, None), (138, 'a3a73bbb-8d53-4ab8-a05a-d248712e120e', datetime.datetime(2024, 8, 16, 0, 1, 44), 1, 'Best of MARViN', 2, 'Best of Marvin video. ORG SRC youtube', 1, 325, 369.755, '7a0eacc1-62ae-44e3-91f6-74c9945a7c95/1efb87fe-82ae-4109-b053-5d7be053e0f4_20240816_000144.mp4', '7a0eacc1-62ae-44e3-91f6-74c9945a7c95/1efb87fe-82ae-4109-b053-5d7be053e0f4_20240816_000144.png', '7a0eacc1-62ae-44e3-91f6-74c9945a7c95/1efb87fe-82ae-4109-b053-5d7be053e0f4_20240816_000144.gif', False, True, True, None)] |
| request | <AnyJsonRequest 'https://bufr.zone/streamer/1/' [GET]> |
| restartRequired | False |
| security | <flask_security.core.Security object at 0x7f5877d8c820> |
| session | <RedisSession {'_permanent': True, '_fresh': False, 'guestUUID': '5826565e-2344-4498-a25c-51107f9f8687'}> |
| static_pages | [] |
| streamerData | <User 1> |
| sysSettings | <id 1> |
| SystemOAuthProviders | [<id 1>, <id 2>] |
| title | 'nFxus' |
| uploadTopics | [<id 1>, <id 2>, <id 3>, <id 4>, <id 5>, <id 6>] |
| url_for_security | <function url_for_security at 0x7f587fdbd5e0> |
| userChannels | [(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)] |
Close
SQLAlchemy queries
| (ms) | Action | Context | Query |
|---|---|---|---|
| 0.8295 |
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.5502 |
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.7246 | ./app.py:936 (do_before_request) |
UPDATE `Guest` SET last_active_at=%(last_active_at)s WHERE `Guest`.id = %(Guest_id)s
|
|
| 3.2043 |
SELECT EXPLAIN |
<unknown> |
SELECT anon_1.user_id AS anon_1_user_id, anon_1.user_uuid AS anon_1_user_uuid, anon_1.user_username AS anon_1_user_username, anon_1.user_email AS anon_1_user_email, anon_1.user_fs_uniquifier AS anon_1_user_fs_uniquifier, anon_1.user_tf_primary_method AS anon_1_user_tf_primary_method, anon_1.user_tf_totp_secret AS anon_1_user_tf_totp_secret, anon_1.user_password AS anon_1_user_password, anon_1.user_biography AS anon_1_user_biography, anon_1.user_active AS anon_1_user_active, anon_1.user_confirmed_at AS anon_1_user_confirmed_at, anon_1.user_last_login_at AS anon_1_user_last_login_at, anon_1.user_current_login_at AS anon_1_user_current_login_at, anon_1.user_last_login_ip AS anon_1_user_last_login_ip, anon_1.user_current_login_ip AS anon_1_user_current_login_ip, anon_1.user_login_count AS anon_1_user_login_count, anon_1.`user_pictureLocation` AS `anon_1_user_pictureLocation`, anon_1.`user_bannerLocation` AS `anon_1_user_bannerLocation`, anon_1.`user_authType` AS `anon_1_user_authType`, anon_1.`user_oAuthID` AS `anon_1_user_oAuthID`, anon_1.`user_oAuthProvider` AS `anon_1_user_oAuthProvider`, anon_1.`user_xmppToken` AS `anon_1_user_xmppToken`, anon_1.`user_emailVideo` AS `anon_1_user_emailVideo`, anon_1.`user_emailStream` AS `anon_1_user_emailStream`, anon_1.`user_emailMessage` AS `anon_1_user_emailMessage`, `OAuth2Token_1`.id AS `OAuth2Token_1_id`, `OAuth2Token_1`.name AS `OAuth2Token_1_name`, `OAuth2Token_1`.token_type AS `OAuth2Token_1_token_type`, `OAuth2Token_1`.access_token AS `OAuth2Token_1_access_token`, `OAuth2Token_1`.refresh_token AS `OAuth2Token_1_refresh_token`, `OAuth2Token_1`.expires_at AS `OAuth2Token_1_expires_at`, `OAuth2Token_1`.user AS `OAuth2Token_1_user`
FROM (SELECT user.id AS user_id, user.uuid AS user_uuid, user.username AS user_username, user.email AS user_email, user.fs_uniquifier AS user_fs_uniquifier, user.tf_primary_method AS user_tf_primary_method, user.tf_totp_secret AS user_tf_totp_secret, user.password AS user_password, user.biography AS user_biography, user.active AS user_active, user.confirmed_at AS user_confirmed_at, user.last_login_at AS user_last_login_at, user.current_login_at AS user_current_login_at, user.last_login_ip AS user_last_login_ip, user.current_login_ip AS user_current_login_ip, user.login_count AS user_login_count, user.`pictureLocation` AS `user_pictureLocation`, user.`bannerLocation` AS `user_bannerLocation`, user.`authType` AS `user_authType`, user.`oAuthID` AS `user_oAuthID`, user.`oAuthProvider` AS `user_oAuthProvider`, user.`xmppToken` AS `user_xmppToken`, user.`emailVideo` AS `user_emailVideo`, user.`emailStream` AS `user_emailStream`, user.`emailMessage` AS `user_emailMessage`
FROM user
WHERE user.id = %(id_1)s
LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN `OAuth2Token` AS `OAuth2Token_1` ON anon_1.user_id = `OAuth2Token_1`.user
|
| 1.1890 |
SELECT EXPLAIN |
<unknown> |
SELECT role.id AS role_id, role.name AS role_name, role.description AS role_description, role.permissions AS role_permissions, role.`default` AS role_default
FROM role, roles_users
WHERE %(param_1)s = roles_users.user_id AND role.id = roles_users.role_id
|
| 1.1683 |
SELECT EXPLAIN |
<unknown> |
SELECT `Stream`.id AS `Stream_id`, `Stream`.`linkedChannel` AS `Stream_linkedChannel`, `Stream`.`currentViewers` AS `Stream_currentViewers`, `Stream`.topic AS `Stream_topic`, `Stream`.`streamName` AS `Stream_streamName`, `Stream`.`totalViewers` AS `Stream_totalViewers`, `Stream`.`startTimestamp` AS `Stream_startTimestamp`, `Stream`.uuid AS `Stream_uuid`, `Stream`.active AS `Stream_active`
FROM `Stream`
WHERE `Stream`.active = true AND `Stream`.`linkedChannel` IN (%(linkedChannel_1_1)s, %(linkedChannel_1_2)s, %(linkedChannel_1_3)s, %(linkedChannel_1_4)s, %(linkedChannel_1_5)s)
|
| 1.6024 |
SELECT EXPLAIN |
<unknown> |
SELECT `RecordedVideo`.id AS `RecordedVideo_id`, `RecordedVideo`.uuid AS `RecordedVideo_uuid`, `RecordedVideo`.`videoDate` AS `RecordedVideo_videoDate`, `RecordedVideo`.`owningUser` AS `RecordedVideo_owningUser`, `RecordedVideo`.`channelName` AS `RecordedVideo_channelName`, `RecordedVideo`.`channelID` AS `RecordedVideo_channelID`, `RecordedVideo`.description AS `RecordedVideo_description`, `RecordedVideo`.topic AS `RecordedVideo_topic`, `RecordedVideo`.views AS `RecordedVideo_views`, `RecordedVideo`.length AS `RecordedVideo_length`, `RecordedVideo`.`videoLocation` AS `RecordedVideo_videoLocation`, `RecordedVideo`.`thumbnailLocation` AS `RecordedVideo_thumbnailLocation`, `RecordedVideo`.`gifLocation` AS `RecordedVideo_gifLocation`, `RecordedVideo`.pending AS `RecordedVideo_pending`, `RecordedVideo`.`allowComments` AS `RecordedVideo_allowComments`, `RecordedVideo`.published AS `RecordedVideo_published`, `RecordedVideo`.`originalStreamID` AS `RecordedVideo_originalStreamID`
FROM `RecordedVideo`
WHERE `RecordedVideo`.`owningUser` = %(owningUser_1)s AND `RecordedVideo`.pending = false AND `RecordedVideo`.published = true
|
| 1.5137 |
SELECT EXPLAIN |
<unknown> |
SELECT `Clips`.id AS `Clips_id`, `Clips`.`clipName` AS `Clips_clipName`, `Clips`.uuid AS `Clips_uuid`, `Clips`.`thumbnailLocation` AS `Clips_thumbnailLocation`, `Clips`.`owningUser` AS `Clips_owningUser`, `Clips`.views AS `Clips_views`, `Clips`.length AS `Clips_length`, `Channel`.protected AS `Channel_protected`, `Clips`.`channelID` AS `Clips_channelID`, `Channel`.`channelName` AS `Channel_channelName`, `Clips`.topic AS `Clips_topic`, user.`pictureLocation` AS `user_pictureLocation`, user.`bannerLocation` AS `user_bannerLocation`, `Clips`.`parentVideo` AS `Clips_parentVideo`, `Clips`.description AS `Clips_description`, `Clips`.published AS `Clips_published`
FROM `Clips` INNER JOIN `Channel` ON `Channel`.id = `Clips`.`channelID` INNER JOIN user ON user.id = `Clips`.`owningUser`
WHERE `Clips`.published = true AND `Clips`.`owningUser` = %(owningUser_1)s
|
| 0.6213 |
SELECT EXPLAIN |
<unknown> |
SELECT settings.`systemTheme` AS `settings_systemTheme`, settings.`maintenanceMode` AS `settings_maintenanceMode`
FROM settings
LIMIT %(param_1)s
|
| 0.5255 |
SELECT EXPLAIN |
<unknown> |
SELECT `UserSocial`.id AS `UserSocial_id`, `UserSocial`.`userID` AS `UserSocial_userID`, `UserSocial`.`socialType` AS `UserSocial_socialType`, `UserSocial`.url AS `UserSocial_url`
FROM `UserSocial`
WHERE %(param_1)s = `UserSocial`.`userID`
|
| 0.4103 |
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.7427 |
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.2593 |
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.6273 |
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.6549 |
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.5784 |
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.0872 |
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.6177 |
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.1020 |
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.5779 |
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.3159 |
SELECT EXPLAIN |
<unknown> |
SELECT user.id AS user_id, user.`pictureLocation` AS `user_pictureLocation`
FROM user
WHERE user.id = %(id_1)s
LIMIT %(param_1)s
|
| 0.3207 |
SELECT EXPLAIN |
<unknown> |
SELECT video_tags.id AS video_tags_id, video_tags.name AS video_tags_name, video_tags.`videoID` AS `video_tags_videoID`, video_tags.`taggedByUser` AS `video_tags_taggedByUser`
FROM video_tags
WHERE video_tags.`videoID` = %(videoID_1)s
|
| 0.3452 |
SELECT EXPLAIN |
<unknown> |
SELECT video_tags.id AS video_tags_id, video_tags.name AS video_tags_name, video_tags.`videoID` AS `video_tags_videoID`, video_tags.`taggedByUser` AS `video_tags_taggedByUser`
FROM video_tags
WHERE video_tags.`videoID` = %(videoID_1)s
|
Close
Log Messages
No messages logged.
Close
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 |
Close
Profiler not active
The profiler is not activated, activate it to use it
Close
flask.g content
| Key | Value |
|---|---|
| _login_user | <flask_security.core.AnonymousUser object at 0x7f58755a8190> |
| debug_toolbar | <flask_debugtoolbar.DebugToolbarExtension object at 0x7f587c0ca130> |
| identity | <AnonymousIdentity id="None" auth_type="None" provides=set()> |