No about added..
Only public portfolio and mentor content is shown. Mentor content is either part of the fast track program or has a personal subscription option.
| Date | Category | Title | Portfolios |
|---|---|---|---|
| July 30, 2022 | Watchlist | New Public Post | Public Portfolio, |
| March 30, 2021 | lesson / review | Demo Post Title | none |
*Results are not typical and will vary from person to person. Making money trading stocks takes time, dedication, and hard work. There are inherent risks involved with investing in the stock market, including the loss of your investment. Past performance in the market is not indicative of future results. Any investment is at your own risk. Read More
Winkler Capital LLC, 100100 Overseas Hwy PO 370697 Key Largo, FL 33037-9998. This is for information purposes only as Winkler Capital LLC nor Alex Winkler is registered as a securities broker-dealer or an investment adviser. No information herein is intended as securities brokerage, investment, tax, accounting, or legal advice, as an offer or solicitation of an offer to sell or buy, or as an endorsement, recommendation, or sponsorship of any company, security, or fund. Winkler Capital LLC and Alex Winkler cannot and does not assess, verify, or guarantee the adequacy, accuracy, or completeness of any information, the suitability or profitability of any particular investment, or the potential value of any investment or informational source. The reader bears responsibility for his/her own investment research and decisions, should seek the advice of a qualified securities professional before making any investment, and investigate and fully understand any and all risks before investing. Winkler Capital LLC and Alex Winkler in no way warrants the solvency, financial condition, or investment advisability of any of the securities mentioned in communications or websites. In addition, Winkler Capital LLC and Alex Winkler accept no liability whatsoever for any direct or consequential loss arising from any use of this information. This information is not intended to be used as the sole basis of any investment decision, nor should it be construed as advice designed to meet the investment needs of any particular investor. Past performance is not necessarily indicative of future returns.
| Package | Name | Version |
|---|---|---|
| Django | 3.2.18 | |
| Python | 3.9.20 | |
| admin_honeypot | Admin_Honeypot | 1.1.0 |
| allauth | Allauth | 0.62.1.final.0 |
| ckeditor | Ckeditor | 6.6.1 |
| collectfast | Collectfast | 2.2.0 |
| debug_toolbar | Debug Toolbar | 4.3.0 |
| django_celery_beat | Periodic Tasks | 2.5.0 |
| django_celery_results | Celery Results | 2.4.0 |
| django_comments_xtd | Comments Xtd | 2.9.13 |
| django_extensions | Django Extensions | 3.1.0 |
| django_filters | Django_Filters | 2.4.0 |
| djstripe | Djstripe | 2.4.3 |
| import_export | Import_Export | 2.4.0 |
| jsonfield | Jsonfield | 1.4.1 |
| notifications | Notifications | 1.6.0 |
| post_office | Post Office | 3.8.0 |
| rangefilter | Range Filter | 0.9.0 |
| rest_framework | Django REST framework | 3.12.2 |
| rest_framework_datatables | Rest_Framework_Datatables | 0.5.2 |
| storages | Storages | 1.10.1 |
| Resource | Value |
|---|---|
| User CPU time | 542.721 msec |
| System CPU time | 8.667 msec |
| Total CPU time | 551.388 msec |
| Elapsed time | 794.890 msec |
| Context switches | 16 voluntary, 133 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Setting | Value |
|---|---|
| ABSOLUTE_URL_OVERRIDES | {} |
| ACCOUNT_ADAPTER | 'tj3.adapters.AccountAdapter' |
| ACCOUNT_AUTHENTICATION_METHOD | 'username_email' |
| ACCOUNT_EMAIL_REQUIRED | True |
| ACCOUNT_EMAIL_VERIFICATION | 'optional' |
| ACCOUNT_FORMS | {'signup': 'referrals.customforms.ReferralSignupForm'} |
| ACCOUNT_LOGOUT_ON_GET | True |
| ACCOUNT_PRESERVE_USERNAME_CASING | False |
| ACCOUNT_SIGNUP_PASSWORD_ENTER_TWICE | '********************' |
| ACCOUNT_SIGNUP_REDIRECT_URL | '/pro/' |
| ACCOUNT_UNIQUE_EMAIL | True |
| ACCOUNT_USERNAME_BLACKLIST | ['admin',
'aw',
'alex',
'alexwinkler',
'alexwinkleroffical',
'administrator',
'winkler',
'account',
'accounts',
'stats',
'trade',
'trades',
'chart',
'charts',
'broker',
'brokers',
'exchange',
'exchanges',
'connect',
'post',
'posts',
'portfolio',
'portfolios',
'dash',
'store',
'logout',
'login',
'log',
'support',
'meow',
'profile',
'dashboard',
'about',
'support',
'tutorials',
'privacy',
'terms',
'legal',
'conduct'] |
| ADMINS | [] |
| ALLOWED_HOSTS | ['ALLOWED_HOSTS=127.0.0.1',
'67.207.82.125',
'tradejournal.co',
'test.tradejournal.co',
'www.localhost',
'localhost',
'localhost:8000',
'www.test.tradejournal.co',
'www.tradejournal.co',
'ALLOWED_HOSTS=127.0.0.1',
'67.207.82.125',
'tradejournal.co',
'test.tradejournal.co',
'www.localhost',
'localhost',
'localhost:8000',
'www.test.tradejournal.co',
'cpanel.tradejournal.co',
'webmail.tradejournal.co'] |
| ALPHA_VANTAGE_API_KEY | '********************' |
| APPEND_SLASH | True |
| AUTHENTICATION_BACKENDS | ('tj3.authentication.SpamCheckBackend',
'django.contrib.auth.backends.ModelBackend',
'allauth.account.auth_backends.AuthenticationBackend') |
| AUTH_PASSWORD_VALIDATORS | '********************' |
| AUTH_USER_MODEL | 'auth.User' |
| AWS_ACCESS_KEY_ID | '********************' |
| AWS_DEFAULT_ACL | 'public-read' |
| AWS_MEDIA_LOCATION | 'media' |
| AWS_QUERYSTRING_AUTH | False |
| AWS_QUERYSTRING_EXPIRE | 3600 |
| AWS_S3_CUSTOM_DOMAIN | 'tradejournal.s3.amazonaws.com' |
| AWS_S3_FILE_OVERWRITE | False |
| AWS_S3_OBJECT_PARAMETERS | {'CacheControl': 'max-age=86400'} |
| AWS_SECRET_ACCESS_KEY | '********************' |
| AWS_SES_ACCESS_KEY_ID | '********************' |
| AWS_SES_REGION_ENDPOINT | 'email.us-east-2.amazonaws.com' |
| AWS_SES_REGION_NAME | 'us-east-2' |
| AWS_SES_SECRET_ACCESS_KEY | '********************' |
| AWS_STATIC_LOCATION | 'static' |
| AWS_STORAGE_BUCKET_NAME | 'tradejournal' |
| AWS_STORAGE_REGION | 'us-east-1' |
| BASE_DIR | '/home/alex/tj3' |
| CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
| CACHE_MIDDLEWARE_ALIAS | 'default' |
| CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
| CACHE_MIDDLEWARE_SECONDS | 600 |
| CACHE_TOP_MENTORS | 86400 |
| CELERY_BEAT_MAX_LOOP_INTERVAL | 300 |
| CELERY_BEAT_SCHEDULE | {'close_expire_option_trade': {'schedule': <crontab: 0 0 * * * (m/h/dM/MY/d)>,
'task': 'portfolios.tasks.expire_option_trades'},
'update_snaptrade_brokerage': {'schedule': <crontab: 0 0 */10 * * (m/h/dM/MY/d)>,
'task': 'snaptrade.tasks.update_snaptrade_brokerage'}} |
| CELERY_BEAT_SCHEDULER | 'django_celery_beat.schedulers:DatabaseScheduler' |
| CELERY_BROKER_URL | 'redis://127.0.0.1:6379/0' |
| CELERY_ENABLE_UTC | True |
| CELERY_RESULT_BACKEND | 'django-db' |
| CELERY_RESULT_SERIALIZER | 'json' |
| CELERY_TASK_SERIALIZER | 'json' |
| CELERY_TASK_SOFT_TIME_LIMIT | 1800 |
| CELERY_TASK_TIME_LIMIT | 2000 |
| CELERY_TIMEZONE | 'America/New_York' |
| CKEDITOR_ALLOW_NONIMAGE_FILES | False |
| CKEDITOR_CONFIGS | {'clean': {'extraPlugins': 'uploadimage,div,autolink,autoembed,embedsemantic,autogrow,widget,lineutils,clipboard,dialog,dialogui,elementspath',
'height': 300,
'skin': 'moono-lisa',
'tabSpaces': 5,
'toolbar': 'Custom',
'toolbar_Basic': [['Source', '-', 'Bold', 'Italic']],
'toolbar_Custom': [{'items': ['Bold', 'Italic', 'Underline'],
'name': 'basicstyles'},
{'items': ['NumberedList',
'BulletedList',
'-',
'Outdent',
'Indent',
'-',
'Blockquote-',
'JustifyLeft',
'JustifyCenter',
'JustifyRight',
'JustifyBlock'],
'name': 'paragraph'},
{'items': ['Link', 'Unlink'], 'name': 'links'},
{'items': ['Smiley', 'SpecialChar'],
'name': 'insert'},
{'items': ['TextColor', 'BGColor'],
'name': 'colors'},
{'items': ['Source'], 'name': 'document'}],
'width': '100%'},
'default': {'extraPlugins': 'uploadimage,div,autolink,autoembed,embedsemantic,autogrow,widget,lineutils,clipboard,dialog,dialogui,elementspath',
'skin': 'moono-lisa',
'tabSpaces': 4,
'toolbar': 'YourCustomToolbarConfig',
'toolbar_Basic': [['Source', '-', 'Bold', 'Italic']],
'toolbar_YourCustomToolbarConfig': [{'items': ['Bold',
'Italic',
'Underline',
'Strike'],
'name': 'basicstyles'},
{'items': ['NumberedList',
'BulletedList',
'-',
'Outdent',
'Indent',
'-',
'Blockquote-',
'JustifyLeft',
'JustifyCenter',
'JustifyRight',
'JustifyBlock'],
'name': 'paragraph'},
{'items': ['Link',
'Unlink',
'Anchor'],
'name': 'links'},
{'items': ['Image',
'Table',
'HorizontalRule',
'Smiley',
'SpecialChar'],
'name': 'insert'},
'/',
{'items': ['Styles',
'Format',
'Font',
'FontSize'],
'name': 'styles'},
{'items': ['TextColor',
'BGColor'],
'name': 'colors'},
{'items': ['Maximize'],
'name': 'tools'},
{'items': ['Source'],
'name': 'document'}],
'width': '100%'}} |
| CKEDITOR_FILENAME_GENERATOR | 'portfolios.utils.get_filename' |
| CKEDITOR_IMAGE_BACKEND | 'pillow' |
| CKEDITOR_JQUERY_URL | 'https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js' |
| CKEDITOR_RESTRICT_BY_USER | True |
| CKEDITOR_UPLOAD_PATH | 'uploads/' |
| COLLECTFAST_CACHE | 'collectfast' |
| COLLECTFAST_STRATEGY | 'collectfast.strategies.boto3.Boto3Strategy' |
| COLLECTFAST_THREADS | 20 |
| COMMENTS_APP | 'django_comments_xtd' |
| COMMENTS_XTD_APP_MODEL_OPTIONS | {'default': {'allow_edit': True,
'allow_feedback': True,
'allow_flagging': True,
'show_feedback': True,
'who_can_post': 'users'},
'portfolios.post': {'allow_edit': True,
'allow_feedback': True,
'allow_flagging': True,
'show_feedback': True,
'who_can_post': 'users'},
'portfolios.trade': {'allow_edit': True,
'allow_feedback': True,
'allow_flagging': True,
'show_feedback': True,
'who_can_post': 'users'}} |
| COMMENTS_XTD_CONFIRM_EMAIL | True |
| COMMENTS_XTD_CONTACT_EMAIL | 'helpdesk@example.com' |
| COMMENTS_XTD_FROM_EMAIL | 'noreply@example.com' |
| COMMENTS_XTD_LIST_ORDER | ('-thread_id', 'order') |
| COMMENTS_XTD_MAX_THREAD_LEVEL | 1 |
| COMMENTS_XTD_MODEL | 'portfolios.models.MyComment' |
| COMMENTS_XTD_SALT | b'es-war-einmal-una-bella-princesa-in-a-beautiful-castle' |
| COMMENTS_XTD_THREADED_EMAILS | False |
| CONNECT_WEBHOOK_SECRET | '********************' |
| CRISPY_ALLOWED_TEMPLATE_PACKS | 'bootstrap5' |
| CRISPY_TEMPLATE_PACK | 'bootstrap5' |
| CSRF_COOKIE_AGE | 31449600 |
| CSRF_COOKIE_DOMAIN | None |
| CSRF_COOKIE_HTTPONLY | False |
| CSRF_COOKIE_NAME | 'csrftoken' |
| CSRF_COOKIE_PATH | '/' |
| CSRF_COOKIE_SAMESITE | 'Lax' |
| CSRF_COOKIE_SECURE | False |
| CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
| CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
| CSRF_TRUSTED_ORIGINS | [] |
| CSRF_USE_SESSIONS | False |
| DATABASES | {'default': {'ATOMIC_REQUESTS': False,
'AUTOCOMMIT': True,
'CONN_MAX_AGE': 0,
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'HOST': 'localhost',
'NAME': 'tj3',
'OPTIONS': {},
'PASSWORD': '********************',
'PORT': '5432',
'TEST': {'CHARSET': None,
'COLLATION': None,
'HOST': 'localhost',
'MIGRATE': True,
'MIRROR': None,
'NAME': None},
'TIME_ZONE': None,
'USER': 'tj3user'}} |
| DATABASE_ROUTERS | [] |
| DATA_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
| DATA_UPLOAD_MAX_NUMBER_FIELDS | 1500 |
| DATA_UPLOAD_MAX_NUMBER_FILES | 100 |
| DATETIME_FORMAT | 'N j, Y, P' |
| DATETIME_INPUT_FORMATS | ['%Y-%m-%d %H:%M:%S',
'%Y-%m-%d %H:%M:%S.%f',
'%Y-%m-%d %H:%M',
'%m/%d/%Y %H:%M:%S',
'%m/%d/%Y %H:%M:%S.%f',
'%m/%d/%Y %H:%M',
'%m/%d/%y %H:%M:%S',
'%m/%d/%y %H:%M:%S.%f',
'%m/%d/%y %H:%M'] |
| DATE_FORMAT | 'N j, Y' |
| DATE_INPUT_FORMATS | ['%Y-%m-%d',
'%m/%d/%Y',
'%m/%d/%y',
'%b %d %Y',
'%b %d, %Y',
'%d %b %Y',
'%d %b, %Y',
'%B %d %Y',
'%B %d, %Y',
'%d %B %Y',
'%d %B, %Y'] |
| DEBUG | True |
| DEBUG_PROPAGATE_EXCEPTIONS | False |
| DEBUG_TOOLBAR_CONFIG | {'SHOW_TOOLBAR_CALLBACK': <function <lambda> at 0x7feeb418ff70>} |
| DEBUG_TOOLBAR_PANELS | ['debug_toolbar.panels.versions.VersionsPanel',
'debug_toolbar.panels.timer.TimerPanel',
'debug_toolbar.panels.settings.SettingsPanel',
'debug_toolbar.panels.headers.HeadersPanel',
'debug_toolbar.panels.request.RequestPanel',
'debug_toolbar.panels.sql.SQLPanel',
'debug_toolbar.panels.staticfiles.StaticFilesPanel',
'debug_toolbar.panels.templates.TemplatesPanel',
'debug_toolbar.panels.cache.CachePanel',
'debug_toolbar.panels.signals.SignalsPanel',
'debug_toolbar.panels.logging.LoggingPanel',
'debug_toolbar.panels.redirects.RedirectsPanel',
'debug_toolbar.panels.profiling.ProfilingPanel'] |
| DECIMAL_SEPARATOR | '.' |
| DEFAULT_AUTO_FIELD | 'django.db.models.AutoField' |
| DEFAULT_CHARSET | 'utf-8' |
| DEFAULT_COMMENT_EMAIL | 'support@tradejournal.co' |
| DEFAULT_EXCEPTION_REPORTER | 'django.views.debug.ExceptionReporter' |
| DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
| DEFAULT_FILE_STORAGE | 'tj3.storage_backends.PublicMediaStorage' |
| DEFAULT_FROM_EMAIL | 'support@tradejournal.co' |
| DEFAULT_HASHING_ALGORITHM | 'sha256' |
| DEFAULT_INDEX_TABLESPACE | '' |
| DEFAULT_TABLESPACE | '' |
| DEFAULT_TO_EMAIL | 'support@tradejournal.co' |
| DISALLOWED_USER_AGENTS | [] |
| DISCORD_APPLICATION_ID | '1161712455265833021' |
| DISCORD_BOT_TOKEN | '********************' |
| DISCORD_GUILD_ID | '493876863765053440' |
| DISCORD_PUBLIC_KEY | '********************' |
| DISCORD_SERVER_ID | '493876863765053440' |
| DJANGO_NOTIFICATIONS_CONFIG | {'SOFT_DELETE': True, 'USE_JSONFIELD': True} |
| DJSTRIPE_FOREIGN_KEY_TO_FIELD | '********************' |
| DJSTRIPE_USE_NATIVE_JSONFIELD | True |
| DJSTRIPE_WEBHOOK_SECRET | '********************' |
| EMAIL_BACKEND | 'post_office.EmailBackend' |
| EMAIL_HOST | 'localhost' |
| EMAIL_HOST_PASSWORD | '********************' |
| EMAIL_HOST_USER | '' |
| EMAIL_PORT | 25 |
| EMAIL_SSL_CERTFILE | None |
| EMAIL_SSL_KEYFILE | '********************' |
| EMAIL_SUBJECT_PREFIX | '[Django] ' |
| EMAIL_TIMEOUT | None |
| EMAIL_USE_LOCALTIME | False |
| EMAIL_USE_SSL | False |
| EMAIL_USE_TLS | False |
| FAVICON_PATH | 'static/favicon/favicon.ico' |
| FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
| FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler',
'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
| FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
| FILE_UPLOAD_PERMISSIONS | 420 |
| FILE_UPLOAD_TEMP_DIR | None |
| FIRST_DAY_OF_WEEK | 0 |
| FIXTURE_DIRS | [] |
| FORCE_SCRIPT_NAME | None |
| FORMAT_MODULE_PATH | None |
| FORM_RENDERER | 'django.forms.renderers.DjangoTemplates' |
| IGNORABLE_404_URLS | [] |
| IMPORT_EXPORT_USE_TRANSACTIONS | True |
| INSTALLED_APPS | ['dal',
'dal_select2',
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.sites',
'django.contrib.sitemaps',
'allauth',
'allauth.account',
'allauth.socialaccount',
'allauth.socialaccount.providers.google',
'allauth.socialaccount.providers.discord',
'collectfast',
'django.contrib.staticfiles',
'ckeditor',
'ckeditor_uploader',
'rest_framework',
'storages',
'widget_tweaks',
'flatpickr',
'django_filters',
'import_export',
'rest_framework_datatables',
'django_extensions',
'django_quill',
'admin_honeypot',
'djstripe',
'django_markdown2',
'django_comments_xtd',
'django_comments',
'notifications',
'django_celery_results',
'django_celery_beat',
'hijack',
'hijack.contrib.admin',
'rangefilter',
'pg_copy',
'portfolios',
'referrals',
'billing',
'community',
'mentors',
'notifyme',
'importservices',
'emailapi',
'symbolapp',
'tjadmin',
'chat',
'jsonfield',
'post_office',
'snaptrade',
'debug_toolbar'] |
| INTERNAL_IPS | ['127.0.1.1', '127.0.0.1', '10.0.2.2', 'localhost', '::1', '172.18.0.1'] |
| LANGUAGES | [('af', 'Afrikaans'),
('ar', 'Arabic'),
('ar-dz', 'Algerian Arabic'),
('ast', 'Asturian'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'),
('be', 'Belarusian'),
('bn', 'Bengali'),
('br', 'Breton'),
('bs', 'Bosnian'),
('ca', 'Catalan'),
('cs', 'Czech'),
('cy', 'Welsh'),
('da', 'Danish'),
('de', 'German'),
('dsb', 'Lower Sorbian'),
('el', 'Greek'),
('en', 'English'),
('en-au', 'Australian English'),
('en-gb', 'British English'),
('eo', 'Esperanto'),
('es', 'Spanish'),
('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'),
('et', 'Estonian'),
('eu', 'Basque'),
('fa', 'Persian'),
('fi', 'Finnish'),
('fr', 'French'),
('fy', 'Frisian'),
('ga', 'Irish'),
('gd', 'Scottish Gaelic'),
('gl', 'Galician'),
('he', 'Hebrew'),
('hi', 'Hindi'),
('hr', 'Croatian'),
('hsb', 'Upper Sorbian'),
('hu', 'Hungarian'),
('hy', 'Armenian'),
('ia', 'Interlingua'),
('id', 'Indonesian'),
('ig', 'Igbo'),
('io', 'Ido'),
('is', 'Icelandic'),
('it', 'Italian'),
('ja', 'Japanese'),
('ka', 'Georgian'),
('kab', 'Kabyle'),
('kk', 'Kazakh'),
('km', 'Khmer'),
('kn', 'Kannada'),
('ko', 'Korean'),
('ky', 'Kyrgyz'),
('lb', 'Luxembourgish'),
('lt', 'Lithuanian'),
('lv', 'Latvian'),
('mk', 'Macedonian'),
('ml', 'Malayalam'),
('mn', 'Mongolian'),
('mr', 'Marathi'),
('my', 'Burmese'),
('nb', 'Norwegian Bokmål'),
('ne', 'Nepali'),
('nl', 'Dutch'),
('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'),
('pa', 'Punjabi'),
('pl', 'Polish'),
('pt', 'Portuguese'),
('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'),
('ru', 'Russian'),
('sk', 'Slovak'),
('sl', 'Slovenian'),
('sq', 'Albanian'),
('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'),
('sw', 'Swahili'),
('ta', 'Tamil'),
('te', 'Telugu'),
('tg', 'Tajik'),
('th', 'Thai'),
('tk', 'Turkmen'),
('tr', 'Turkish'),
('tt', 'Tatar'),
('udm', 'Udmurt'),
('uk', 'Ukrainian'),
('ur', 'Urdu'),
('uz', 'Uzbek'),
('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')] |
| LANGUAGES_BIDI | ['he', 'ar', 'ar-dz', 'fa', 'ur'] |
| LANGUAGE_CODE | 'en-us' |
| LANGUAGE_COOKIE_AGE | None |
| LANGUAGE_COOKIE_DOMAIN | None |
| LANGUAGE_COOKIE_HTTPONLY | False |
| LANGUAGE_COOKIE_NAME | 'django_language' |
| LANGUAGE_COOKIE_PATH | '/' |
| LANGUAGE_COOKIE_SAMESITE | None |
| LANGUAGE_COOKIE_SECURE | False |
| LOCALE_PATHS | [] |
| LOCAL_IPS | ['127.0.1.1', '127.0.0.1', '10.0.2.2', 'localhost', '::1', '172.18.0.1'] |
| LOGGING | {} |
| LOGGING_CONFIG | 'logging.config.dictConfig' |
| LOGIN_REDIRECT_URL | 'home' |
| LOGIN_URL | '/accounts/login/' |
| LOGOUT_REDIRECT_URL | 'home' |
| MANAGERS | [] |
| MEDIA_ROOT | '/home/alex/tj3/media' |
| MEDIA_URL | 'https://tradejournal.s3.amazonaws.com/media/' |
| MENTOR_TRIAL_COOL_DOWN_DAYS | 90 |
| MENTOR_TRIAL_DAYS | 7 |
| MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
| MESSAGE_TAGS | {10: 'alert-info',
20: 'alert-info',
25: 'alert-success',
30: 'alert-warning',
40: 'alert-danger'} |
| MIDDLEWARE | ['django.middleware.security.SecurityMiddleware',
'debug_toolbar.middleware.DebugToolbarMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'tj3.middleware.CaseInsensitiveURLMiddleware',
'django.middleware.common.CommonMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'hijack.middleware.HijackUserMiddleware',
'allauth.account.middleware.AccountMiddleware',
'tj3.middleware.SpamLogoutMiddleware'] |
| MIGRATION_MODULES | {} |
| MONTH_DAY_FORMAT | 'F j' |
| NOTIFICATIONS_NOTIFICATION_MODEL | 'notifyme.Notify' |
| NUMBER_GROUPING | 0 |
| OPENAI_API_KEY | '********************' |
| OPENAI_API_TESTING | '********************' |
| PASSWORD_HASHERS | '********************' |
| PASSWORD_RESET_TIMEOUT | '********************' |
| PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
| PERCENT_FEE | 17 |
| POST_OFFICE | {'BACKENDS': {'default': 'django_ses.SESBackend',
'sendgrid': 'sendgrid_backend.SendgridBackend',
'ses': 'django_ses.SESBackend'},
'CELERY_ENABLED': True,
'DEFAULT_PRIORITY': 'now',
'THREADS_PER_PROCESS': 10} |
| PREPEND_WWW | True |
| PUBLIC_POSTS_TRADES_CACHE | 7200 |
| REST_FRAMEWORK | {'DEFAULT_AUTHENTICATION_CLASSES': ['rest_framework.authentication.SessionAuthentication'],
'DEFAULT_FILTER_BACKENDS': ('rest_framework_datatables.filters.DatatablesFilterBackend',),
'DEFAULT_PAGINATION_CLASS': 'rest_framework_datatables.pagination.DatatablesPageNumberPagination',
'DEFAULT_RENDERER_CLASSES': ('rest_framework.renderers.JSONRenderer',
'rest_framework.renderers.BrowsableAPIRenderer',
'rest_framework_datatables.renderers.DatatablesRenderer'),
'PAGE_SIZE': 10} |
| ROOT_DIR | '/home/alex/tj3/tj3' |
| ROOT_URLCONF | 'tj3.urls' |
| SECRET_KEY | '********************' |
| SECURE_BROWSER_XSS_FILTER | False |
| SECURE_CONTENT_TYPE_NOSNIFF | True |
| SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
| SECURE_HSTS_PRELOAD | False |
| SECURE_HSTS_SECONDS | 0 |
| SECURE_PROXY_SSL_HEADER | None |
| SECURE_REDIRECT_EXEMPT | [] |
| SECURE_REFERRER_POLICY | 'same-origin' |
| SECURE_SSL_HOST | None |
| SECURE_SSL_REDIRECT | False |
| SENDGRID_API_KEY | '********************' |
| SENDGRID_ECHO_TO_STDOUT | True |
| SENDGRID_SANDBOX_MODE_IN_DEBUG | False |
| SERVER_EMAIL | 'root@localhost' |
| SESSION_CACHE_ALIAS | 'default' |
| SESSION_COOKIE_AGE | 1209600 |
| SESSION_COOKIE_DOMAIN | None |
| SESSION_COOKIE_HTTPONLY | True |
| SESSION_COOKIE_NAME | 'sessionid' |
| SESSION_COOKIE_PATH | '/' |
| SESSION_COOKIE_SAMESITE | 'Lax' |
| SESSION_COOKIE_SECURE | False |
| SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
| SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
| SESSION_FILE_PATH | None |
| SESSION_SAVE_EVERY_REQUEST | False |
| SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
| SETTINGS_MODULE | 'tj3.settings' |
| SHORT_DATETIME_FORMAT | 'm/d/Y P' |
| SHORT_DATE_FORMAT | 'm/d/Y' |
| SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
| SIGNUP_REDIRECT_URL | 'pro' |
| SILENCED_SYSTEM_CHECKS | [] |
| SITE_ID | 2 |
| SNAPTRADE_CLIENT_ID | 'TRADEJOURNAL' |
| SNAPTRADE_CONSUMER_KEY | '********************' |
| SOCIALACCOUNT_EMAIL_AUTHENTICATION | True |
| SOCIALACCOUNT_EMAIL_AUTHENTICATION_AUTO_CONNECT | True |
| SOCIALACCOUNT_EMAIL_VERIFICATION | 'optional' |
| SOCIALACCOUNT_PROVIDERS | {'discord': {'EMAIL_AUTHENTICATION': True, 'SCOPE': ['identify', 'email']},
'google': {'AUTH_PARAMS': {'access_type': 'offline'},
'EMAIL_AUTHENTICATION': True,
'SCOPE': ['profile', 'email']}} |
| STATICFILES_DIRS | ['/home/alex/tj3/static'] |
| STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder',
'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
| STATICFILES_LOCATION | 'static' |
| STATICFILES_STORAGE | 'tj3.storage_backends.PublicStaticStorage' |
| STATIC_ROOT | '/home/alex/tj3/staticfiles' |
| STATIC_URL | 'https://tradejournal.s3.amazonaws.com/static/' |
| STRIPE_CONNECT_CLIENT_ID | 'ca_Fe13QsdGwQwC3aX4jzYx8PocMIT7dIcS' |
| STRIPE_LIVE_CONNECT_CLIENT_ID | 'ca_Fe13QsdGwQwC3aX4jzYx8PocMIT7dIcS' |
| STRIPE_LIVE_MODE | True |
| STRIPE_LIVE_PUBLIC_KEY | '********************' |
| STRIPE_LIVE_SECRET_KEY | '********************' |
| STRIPE_PUBLIC_KEY | '********************' |
| STRIPE_SECRET_KEY | '********************' |
| STRIPE_TEST_CONNECT_CLIENT_ID | 'ca_Fe13ZbfLlgUCzrfy0vVCHP8nFcLlpn81' |
| STRIPE_TEST_PUBLIC_KEY | '********************' |
| STRIPE_TEST_SECRET_KEY | '********************' |
| TEMPLATES | [{'APP_DIRS': True,
'BACKEND': 'django.template.backends.django.DjangoTemplates',
'DIRS': ['/home/alex/tj3/templates'],
'OPTIONS': {'context_processors': ['django.template.context_processors.request',
'django.contrib.auth.context_processors.auth',
'django.contrib.messages.context_processors.messages',
'django.template.context_processors.media',
'importservices.context_processors.global_context'],
'libraries': {'staticfiles': 'django.templatetags.static'}}}] |
| TEST_NON_SERIALIZED_APPS | [] |
| TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
| THOUSAND_SEPARATOR | ',' |
| TIME_FORMAT | 'P' |
| TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
| TIME_ZONE | 'UTC' |
| USE_I18N | True |
| USE_L10N | True |
| USE_S3 | True |
| USE_THOUSAND_SEPARATOR | True |
| USE_TZ | True |
| USE_X_FORWARDED_HOST | False |
| USE_X_FORWARDED_PORT | False |
| WSGI_APPLICATION | 'tj3.wsgi.application' |
| X_FRAME_OPTIONS | 'DENY' |
| YEAR_MONTH_FORMAT | 'F Y' |
| Key | Value |
|---|---|
| Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
| Accept-Encoding | br,gzip |
| Accept-Language | en-US,en;q=0.5 |
| Connection | close |
| Host | www.tradejournal.co |
| User-Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
| X-Forwarded-For | 18.97.9.174 |
| X-Forwarded-Proto | https |
| X-Real-Ip | 18.97.9.174 |
| Key | Value |
|---|---|
| Content-Length | 88608 |
| Content-Type | text/html; charset=utf-8 |
| Vary | Cookie |
Since the WSGI environ inherits the environment of the server, only a significant subset is shown below.
| Key | Value |
|---|---|
| PATH_INFO | /demo/ |
| QUERY_STRING | |
| REMOTE_ADDR | |
| REQUEST_METHOD | GET |
| SCRIPT_NAME | |
| SERVER_NAME | www.tradejournal.co |
| SERVER_PORT | 443 |
| SERVER_PROTOCOL | HTTP/1.0 |
| SERVER_SOFTWARE | gunicorn/20.0.4 |
| View function | Arguments | Keyword arguments | URL name |
|---|---|---|---|
portfolios.views.UserDetail |
() |
{'username': 'demo'} |
user-detail |
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT "auth_user"."id",
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."username" = 'demo' LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'demo' LIMIT 21 |
1.69 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(106) self.object = self.get_object() /home/alex/tj3/portfolios/views.py in get_object(1587) user = get_object_or_404(User, username=self.kwargs["username"]) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/shortcuts.py in get_object_or_404(76) return queryset.get(*args, **kwargs) |
|||||||||||||||||||||
|
SELECT "portfolios_profile"."id",
"portfolios_profile"."user_id", "portfolios_profile"."display_username", "portfolios_profile"."bio", "portfolios_profile"."location", "portfolios_profile"."birth_date", "portfolios_profile"."image", "portfolios_profile"."website", "portfolios_profile"."facebook", "portfolios_profile"."twitter", "portfolios_profile"."instagram", "portfolios_profile"."youtube", "portfolios_profile"."stocktwits", "portfolios_profile"."tradingview", "portfolios_profile"."social_promotions", "portfolios_profile"."hubspot", "portfolios_profile"."insider_approved", "portfolios_profile"."discord", "portfolios_profile"."tz", "portfolios_profile"."timezone", "portfolios_profile"."theme", "portfolios_profile"."is_spammer", "portfolios_profile"."private_policy", "portfolios_profile"."show_following_reminders", "portfolios_profile"."stripe_account_id", "portfolios_profile"."mentor_subscription_id", "portfolios_profile"."mentor_subscription_start", "portfolios_profile"."customer_id", "portfolios_profile"."mentor_access", "portfolios_profile"."default_import_broker_id", "portfolios_profile"."onboarding_tutorial", "portfolios_profile"."claimed_free_analysis" FROM "portfolios_profile" WHERE "portfolios_profile"."user_id" = 1420 LIMIT 21SELECT ••• FROM "portfolios_profile" WHERE "portfolios_profile"."user_id" = 1420 LIMIT 21 |
1.36 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(106) self.object = self.get_object() /home/alex/tj3/portfolios/views.py in get_object(1591) if user.profile.is_spammer: |
|||||||||||||||||||||
|
SELECT "mentors_mentor"."user_id"
4 similar queries.
Duplicated 4 times.
FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1SELECT ••• FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1 |
0.81 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1608) public_trades = get_all_public_mentor_trades(user=otheruser) /home/alex/tj3/portfolios/service.py in get_all_public_mentor_trades(1287) Mentor.objects.filter(status=3, user=user).values_list("user").last() |
|||||||||||||||||||||
|
SELECT "mentors_mentor"."user_id"
4 similar queries.
Duplicated 4 times.
FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1SELECT ••• FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1 |
0.56 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1609) private_trades = get_all_private_not_mentor_trades(user=otheruser) /home/alex/tj3/portfolios/service.py in get_all_private_not_mentor_trades(1382) Mentor.objects.filter(status=3, user=user).values_list("user").last() |
|||||||||||||||||||||
|
SELECT "mentors_mentor"."user_id"
4 similar queries.
Duplicated 4 times.
FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1SELECT ••• FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1 |
18.41 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1610) public_posts = get_public_mentor_posts( /home/alex/tj3/portfolios/service.py in get_public_mentor_posts(950) Mentor.objects.filter(status=3, user=user).values_list("user").last() |
|||||||||||||||||||||
|
SELECT "mentors_mentor"."user_id"
4 similar queries.
Duplicated 4 times.
FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1SELECT ••• FROM "mentors_mentor" WHERE ("mentors_mentor"."status" = 3 AND "mentors_mentor"."user_id" = 1420) ORDER BY "mentors_mentor"."id" DESC LIMIT 1 |
11.75 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1613) private_posts = get_private_not_mentor_posts(user=otheruser) /home/alex/tj3/portfolios/service.py in get_private_not_mentor_posts(1046) Mentor.objects.filter(status=3, user=user).values_list("user").last() |
|||||||||||||||||||||
|
SELECT SUM("__col1")
FROM ( SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29, "portfolios_trade"."profit_loss_value_fees" AS "__col1" FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_trade_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3)))) AND "portfolios_trade"."status" = 'cl') ) subquerySELECT SUM("__col1") FROM (SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29, "portfolios_trade"."profit_loss_value_fees" AS "__col1" FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_trade_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3)))) AND "portfolios_trade"."status" = 'cl')) subquery |
6.78 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1614) public_profit = public_trades.filter(status="cl").aggregate( |
|||||||||||||||||||||
|
SELECT SUM("__col1")
FROM ( SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29, "portfolios_trade"."profit_loss_value_fees" AS "__col1" FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") INNER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1)) AND "portfolios_trade_associated_portfolios"."portfolio_id" IS NOT NULL AND (("portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private"))) OR (NOT "portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private")) AND V1."id" = "portfolios_trade_associated_portfolios"."id" AND "portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LIMIT 1)))) AND "portfolios_trade"."status" = 'cl') ) subquerySELECT SUM("__col1") FROM (SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29, "portfolios_trade"."profit_loss_value_fees" AS "__col1" FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") INNER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1)) AND "portfolios_trade_associated_portfolios"."portfolio_id" IS NOT NULL AND (("portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private"))) OR (NOT "portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private")) AND V1."id" = "portfolios_trade_associated_portfolios"."id" AND "portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LIMIT 1)))) AND "portfolios_trade"."status" = 'cl')) subquery |
12.53 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1618) private_profit = private_trades.filter(status="cl").aggregate( |
|||||||||||||||||||||
|
SELECT COUNT(*)
FROM ( SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29 FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_trade_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ) subquerySELECT COUNT(*) FROM (SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29 FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_trade_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3)))))) subquery |
13.59 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1624) public_trades_count = public_trades.count() |
|||||||||||||||||||||
|
SELECT COUNT(*)
FROM ( SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29 FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") INNER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1)) AND "portfolios_trade_associated_portfolios"."portfolio_id" IS NOT NULL AND (("portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private"))) OR (NOT "portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private")) AND V1."id" = "portfolios_trade_associated_portfolios"."id" AND "portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LIMIT 1))))) ) subquerySELECT COUNT(*) FROM (SELECT DISTINCT "portfolios_trade"."id" AS Col1, "portfolios_trade"."user_id" AS Col2, "portfolios_trade"."status" AS Col3, "portfolios_trade"."type" AS Col4, "portfolios_trade"."broker_id" AS Col5, "portfolios_trade"."asset_id" AS Col6, "portfolios_trade"."symbol_id" AS Col7, "portfolios_trade"."notes" AS Col8, "portfolios_trade"."created" AS Col9, "portfolios_trade"."modified" AS Col10, "portfolios_trade"."image" AS Col11, "portfolios_trade"."max_amount" AS Col12, "portfolios_trade"."fees" AS Col13, "portfolios_trade"."reg_fees" AS Col14, "portfolios_trade"."commission_fees" AS Col15, "portfolios_trade"."entry_cpu" AS Col16, "portfolios_trade"."exit_cpu" AS Col17, "portfolios_trade"."position_size" AS Col18, "portfolios_trade"."profit_loss_percent" AS Col19, "portfolios_trade"."profit_loss_value" AS Col20, "portfolios_trade"."profit_loss_value_fees" AS Col21, "portfolios_trade"."trade_result" AS Col22, "portfolios_trade"."last_entry" AS Col23, "portfolios_trade"."option_type" AS Col24, "portfolios_trade"."option_strike" AS Col25, "portfolios_trade"."option_expiration" AS Col26, "portfolios_trade"."future_date" AS Col27, "portfolios_trade"."allow_comments" AS Col28, "portfolios_trade"."wizard_id" AS Col29 FROM "portfolios_trade" INNER JOIN "auth_user" ON ("portfolios_trade"."user_id" = "auth_user"."id") INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") INNER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") WHERE ("portfolios_trade"."user_id" = 1420 AND "portfolios_trade"."status" = 'cl' AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))) AND V1."trade_id" = "portfolios_trade"."id") LIMIT 1)) AND "portfolios_trade_associated_portfolios"."portfolio_id" IS NOT NULL AND (("portfolios_profile"."private_policy" AND "portfolios_trade_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private"))) OR (NOT "portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_trade_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private")) AND V1."id" = "portfolios_trade_associated_portfolios"."id" AND "portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LIMIT 1)))))) subquery |
16.87 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1625) private_trades_count = private_trades.count() |
|||||||||||||||||||||
|
SELECT COUNT(*)
FROM ( SELECT DISTINCT "portfolios_post"."id" AS Col1, "portfolios_post"."user_id" AS Col2, "portfolios_post"."title" AS Col3, "portfolios_post"."body" AS Col4, "portfolios_post"."category" AS Col5, "portfolios_post"."created_on" AS Col6, "portfolios_post"."updated_on" AS Col7, "portfolios_post"."published_on" AS Col8, "portfolios_post"."published" AS Col9, "portfolios_post"."last_published" AS Col10, "portfolios_post"."slug" AS Col11, "portfolios_post"."allow_comments" AS Col12, "portfolios_post"."is_spam" AS Col13 FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ) subquerySELECT COUNT(*) FROM (SELECT DISTINCT "portfolios_post"."id" AS Col1, "portfolios_post"."user_id" AS Col2, "portfolios_post"."title" AS Col3, "portfolios_post"."body" AS Col4, "portfolios_post"."category" AS Col5, "portfolios_post"."created_on" AS Col6, "portfolios_post"."updated_on" AS Col7, "portfolios_post"."published_on" AS Col8, "portfolios_post"."published" AS Col9, "portfolios_post"."last_published" AS Col10, "portfolios_post"."slug" AS Col11, "portfolios_post"."allow_comments" AS Col12, "portfolios_post"."is_spam" AS Col13 FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3)))))) subquery |
17.67 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1626) public_posts_count = public_posts.count() |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") INNER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") WHERE ("portfolios_post"."user_id" = 1420 AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))) AND V1."post_id" = "portfolios_post"."id") LIMIT 1)) AND "portfolios_post_associated_portfolios"."portfolio_id" IS NOT NULL AND (("portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private"))) OR (NOT "portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private")) AND V1."id" = "portfolios_post_associated_portfolios"."id" AND "portfolios_post_associated_portfolios"."post_id" = "portfolios_post"."id") LIMIT 1)))))SELECT COUNT(*) AS "__count" FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") INNER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") WHERE ("portfolios_post"."user_id" = 1420 AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))) AND V1."post_id" = "portfolios_post"."id") LIMIT 1)) AND "portfolios_post_associated_portfolios"."portfolio_id" IS NOT NULL AND (("portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private"))) OR (NOT "portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private")) AND V1."id" = "portfolios_post_associated_portfolios"."id" AND "portfolios_post_associated_portfolios"."post_id" = "portfolios_post"."id") LIMIT 1))))) |
1.77 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1627) private_posts_count = private_posts.count() |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "portfolios_followingprofile" WHERE "portfolios_followingprofile"."profile_to_id" = 1419SELECT COUNT(*) AS "__count" FROM "portfolios_followingprofile" WHERE "portfolios_followingprofile"."profile_to_id" = 1419 |
17.92 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1686) followers_count = FollowingProfile.objects.filter( |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "portfolios_followingprofile" WHERE "portfolios_followingprofile"."profile_from_id" = 1419SELECT COUNT(*) AS "__count" FROM "portfolios_followingprofile" WHERE "portfolios_followingprofile"."profile_from_id" = 1419 |
0.50 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in view(70) return self.dispatch(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/base.py in dispatch(98) return handler(request, *args, **kwargs) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/views/generic/detail.py in get(107) context = self.get_context_data(object=self.object) /home/alex/tj3/portfolios/views.py in get_context_data(1689) following_count = FollowingProfile.objects.filter( |
|||||||||||||||||||||
|
SELECT "portfolios_portfolio"."id",
"portfolios_portfolio"."user_id", "portfolios_portfolio"."name", "portfolios_portfolio"."description", "portfolios_portfolio"."private", "portfolios_portfolio"."custompromopage", "portfolios_portfolio"."mentor_enabled", "portfolios_portfolio"."subscription_enabled", "portfolios_portfolio"."price", "portfolios_portfolio"."recurring_interval", "portfolios_portfolio"."product_id", "portfolios_portfolio"."created_at", "portfolios_portfolio"."price_obj_id", "portfolios_portfolio"."subscription_approve", SUM("portfolios_trade"."profit_loss_value_fees") FILTER (WHERE "portfolios_trade"."status" = 'cl') AS "profit", "djstripe_price"."djstripe_id", "djstripe_price"."id", "djstripe_price"."djstripe_owner_account_id", "djstripe_price"."livemode", "djstripe_price"."created", "djstripe_price"."metadata", "djstripe_price"."description", "djstripe_price"."djstripe_created", "djstripe_price"."djstripe_updated", "djstripe_price"."active", "djstripe_price"."currency", "djstripe_price"."nickname", "djstripe_price"."product_id", "djstripe_price"."recurring", "djstripe_price"."type", "djstripe_price"."unit_amount", "djstripe_price"."unit_amount_decimal", "djstripe_price"."billing_scheme", "djstripe_price"."lookup_key", "djstripe_price"."tiers", "djstripe_price"."tiers_mode", "djstripe_price"."transform_quantity" FROM "portfolios_portfolio" LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_trade_associated_portfolios"."portfolio_id") LEFT OUTER JOIN "portfolios_trade" ON ("portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LEFT OUTER JOIN "djstripe_price" ON ("portfolios_portfolio"."price_obj_id" = "djstripe_price"."djstripe_id") WHERE "portfolios_portfolio"."user_id" = 1420 GROUP BY "portfolios_portfolio"."id", "djstripe_price"."djstripe_id" ORDER BY "profit" DESC LIMIT 1SELECT ••• FROM "portfolios_portfolio" LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_trade_associated_portfolios"."portfolio_id") LEFT OUTER JOIN "portfolios_trade" ON ("portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LEFT OUTER JOIN "djstripe_price" ON ("portfolios_portfolio"."price_obj_id" = "djstripe_price"."djstripe_id") WHERE "portfolios_portfolio"."user_id" = 1420 GROUP BY "portfolios_portfolio"."id", "djstripe_price"."djstripe_id" ORDER BY "profit" DESC LIMIT 1 |
3.31 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(102) '!=': infix(10, lambda context, x, y: x.eval(context) != y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(858) current = current()
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT ("portfolios_trade_associated_portfolios"."portfolio_id") AS "_prefetch_related_val_portfolio_id",
"portfolios_trade"."id", "portfolios_trade"."user_id", "portfolios_trade"."status", "portfolios_trade"."type", "portfolios_trade"."broker_id", "portfolios_trade"."asset_id", "portfolios_trade"."symbol_id", "portfolios_trade"."notes", "portfolios_trade"."created", "portfolios_trade"."modified", "portfolios_trade"."image", "portfolios_trade"."max_amount", "portfolios_trade"."fees", "portfolios_trade"."reg_fees", "portfolios_trade"."commission_fees", "portfolios_trade"."entry_cpu", "portfolios_trade"."exit_cpu", "portfolios_trade"."position_size", "portfolios_trade"."profit_loss_percent", "portfolios_trade"."profit_loss_value", "portfolios_trade"."profit_loss_value_fees", "portfolios_trade"."trade_result", "portfolios_trade"."last_entry", "portfolios_trade"."option_type", "portfolios_trade"."option_strike", "portfolios_trade"."option_expiration", "portfolios_trade"."future_date", "portfolios_trade"."allow_comments", "portfolios_trade"."wizard_id" FROM "portfolios_trade" INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE "portfolios_trade_associated_portfolios"."portfolio_id" IN (458) ORDER BY "portfolios_trade"."id" DESCSELECT ••• FROM "portfolios_trade" INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE "portfolios_trade_associated_portfolios"."portfolio_id" IN (458) ORDER BY "portfolios_trade"."id" DESC |
0.88 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(102) '!=': infix(10, lambda context, x, y: x.eval(context) != y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(858) current = current()
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT ("portfolios_post_associated_portfolios"."portfolio_id") AS "_prefetch_related_val_portfolio_id",
"portfolios_post"."id", "portfolios_post"."user_id", "portfolios_post"."title", "portfolios_post"."body", "portfolios_post"."category", "portfolios_post"."created_on", "portfolios_post"."updated_on", "portfolios_post"."published_on", "portfolios_post"."published", "portfolios_post"."last_published", "portfolios_post"."slug", "portfolios_post"."allow_comments", "portfolios_post"."is_spam" FROM "portfolios_post" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE "portfolios_post_associated_portfolios"."portfolio_id" IN (458) ORDER BY "portfolios_post"."published_on" DESCSELECT ••• FROM "portfolios_post" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE "portfolios_post_associated_portfolios"."portfolio_id" IN (458) ORDER BY "portfolios_post"."published_on" DESC |
0.62 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(102) '!=': infix(10, lambda context, x, y: x.eval(context) != y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(858) current = current()
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
0.36 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(102) '!=': infix(10, lambda context, x, y: x.eval(context) != y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT "portfolios_portfolio"."id",
"portfolios_portfolio"."user_id", "portfolios_portfolio"."name", "portfolios_portfolio"."description", "portfolios_portfolio"."private", "portfolios_portfolio"."custompromopage", "portfolios_portfolio"."mentor_enabled", "portfolios_portfolio"."subscription_enabled", "portfolios_portfolio"."price", "portfolios_portfolio"."recurring_interval", "portfolios_portfolio"."product_id", "portfolios_portfolio"."created_at", "portfolios_portfolio"."price_obj_id", "portfolios_portfolio"."subscription_approve", SUM("portfolios_trade"."profit_loss_value_fees") FILTER (WHERE "portfolios_trade"."status" = 'cl') AS "profit", "djstripe_price"."djstripe_id", "djstripe_price"."id", "djstripe_price"."djstripe_owner_account_id", "djstripe_price"."livemode", "djstripe_price"."created", "djstripe_price"."metadata", "djstripe_price"."description", "djstripe_price"."djstripe_created", "djstripe_price"."djstripe_updated", "djstripe_price"."active", "djstripe_price"."currency", "djstripe_price"."nickname", "djstripe_price"."product_id", "djstripe_price"."recurring", "djstripe_price"."type", "djstripe_price"."unit_amount", "djstripe_price"."unit_amount_decimal", "djstripe_price"."billing_scheme", "djstripe_price"."lookup_key", "djstripe_price"."tiers", "djstripe_price"."tiers_mode", "djstripe_price"."transform_quantity" FROM "portfolios_portfolio" LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_trade_associated_portfolios"."portfolio_id") LEFT OUTER JOIN "portfolios_trade" ON ("portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LEFT OUTER JOIN "djstripe_price" ON ("portfolios_portfolio"."price_obj_id" = "djstripe_price"."djstripe_id") WHERE "portfolios_portfolio"."user_id" = 1420 GROUP BY "portfolios_portfolio"."id", "djstripe_price"."djstripe_id" ORDER BY "profit" DESC LIMIT 5SELECT ••• FROM "portfolios_portfolio" LEFT OUTER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_trade_associated_portfolios"."portfolio_id") LEFT OUTER JOIN "portfolios_trade" ON ("portfolios_trade_associated_portfolios"."trade_id" = "portfolios_trade"."id") LEFT OUTER JOIN "djstripe_price" ON ("portfolios_portfolio"."price_obj_id" = "djstripe_price"."djstripe_id") WHERE "portfolios_portfolio"."user_id" = 1420 GROUP BY "portfolios_portfolio"."id", "djstripe_price"."djstripe_id" ORDER BY "profit" DESC LIMIT 5 |
2.59 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(171) len_values = len(values)
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT ("portfolios_trade_associated_portfolios"."portfolio_id") AS "_prefetch_related_val_portfolio_id",
"portfolios_trade"."id", "portfolios_trade"."user_id", "portfolios_trade"."status", "portfolios_trade"."type", "portfolios_trade"."broker_id", "portfolios_trade"."asset_id", "portfolios_trade"."symbol_id", "portfolios_trade"."notes", "portfolios_trade"."created", "portfolios_trade"."modified", "portfolios_trade"."image", "portfolios_trade"."max_amount", "portfolios_trade"."fees", "portfolios_trade"."reg_fees", "portfolios_trade"."commission_fees", "portfolios_trade"."entry_cpu", "portfolios_trade"."exit_cpu", "portfolios_trade"."position_size", "portfolios_trade"."profit_loss_percent", "portfolios_trade"."profit_loss_value", "portfolios_trade"."profit_loss_value_fees", "portfolios_trade"."trade_result", "portfolios_trade"."last_entry", "portfolios_trade"."option_type", "portfolios_trade"."option_strike", "portfolios_trade"."option_expiration", "portfolios_trade"."future_date", "portfolios_trade"."allow_comments", "portfolios_trade"."wizard_id" FROM "portfolios_trade" INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE "portfolios_trade_associated_portfolios"."portfolio_id" IN (5913, 458, 500, 6080, 537) ORDER BY "portfolios_trade"."id" DESCSELECT ••• FROM "portfolios_trade" INNER JOIN "portfolios_trade_associated_portfolios" ON ("portfolios_trade"."id" = "portfolios_trade_associated_portfolios"."trade_id") WHERE "portfolios_trade_associated_portfolios"."portfolio_id" IN (5913, 458, 500, 6080, 537) ORDER BY "portfolios_trade"."id" DESC |
1.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(171) len_values = len(values)
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT ("portfolios_post_associated_portfolios"."portfolio_id") AS "_prefetch_related_val_portfolio_id",
"portfolios_post"."id", "portfolios_post"."user_id", "portfolios_post"."title", "portfolios_post"."body", "portfolios_post"."category", "portfolios_post"."created_on", "portfolios_post"."updated_on", "portfolios_post"."published_on", "portfolios_post"."published", "portfolios_post"."last_published", "portfolios_post"."slug", "portfolios_post"."allow_comments", "portfolios_post"."is_spam" FROM "portfolios_post" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE "portfolios_post_associated_portfolios"."portfolio_id" IN (5913, 458, 500, 6080, 537) ORDER BY "portfolios_post"."published_on" DESCSELECT ••• FROM "portfolios_post" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE "portfolios_post_associated_portfolios"."portfolio_id" IN (5913, 458, 500, 6080, 537) ORDER BY "portfolios_post"."published_on" DESC |
0.75 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(171) len_values = len(values)
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
0.43 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(214) nodelist.append(node.render_annotated(context)) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/port_analytics_breadcrumb_dropdown.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
0.41 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(214) nodelist.append(node.render_annotated(context)) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(83) return func(context, self.first) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(96) 'not': prefix(8, lambda context, x: not x.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
0.56 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(214) nodelist.append(node.render_annotated(context)) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/port_analytics_breadcrumb_dropdown.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
0.46 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(214) nodelist.append(node.render_annotated(context)) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/port_analytics_breadcrumb_dropdown.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
0.32 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(214) nodelist.append(node.render_annotated(context)) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(83) return func(context, self.first) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(96) 'not': prefix(8, lambda context, x: not x.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/portfolio_list_table.html |
|||||||||||||||||||||
|
SELECT DISTINCT "portfolios_post"."id",
2 similar queries.
Duplicated 2 times.
"portfolios_post"."user_id", "portfolios_post"."title", "portfolios_post"."body", "portfolios_post"."category", "portfolios_post"."created_on", "portfolios_post"."updated_on", "portfolios_post"."published_on", "portfolios_post"."published", "portfolios_post"."last_published", "portfolios_post"."slug", "portfolios_post"."allow_comments", "portfolios_post"."is_spam" FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ORDER BY "portfolios_post"."published_on" DESC LIMIT 1SELECT ••• FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ORDER BY "portfolios_post"."published_on" DESC LIMIT 1 |
1.64 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(843) current = current[int(bit)]
/home/alex/tj3/templates/snippets/post_list_snippet.html |
|||||||||||||||||||||
|
SELECT ("portfolios_post_associated_portfolios"."post_id") AS "_prefetch_related_val_post_id",
2 similar queries.
Duplicated 2 times.
"portfolios_portfolio"."id", "portfolios_portfolio"."user_id", "portfolios_portfolio"."name", "portfolios_portfolio"."description", "portfolios_portfolio"."private", "portfolios_portfolio"."custompromopage", "portfolios_portfolio"."mentor_enabled", "portfolios_portfolio"."subscription_enabled", "portfolios_portfolio"."price", "portfolios_portfolio"."recurring_interval", "portfolios_portfolio"."product_id", "portfolios_portfolio"."created_at", "portfolios_portfolio"."price_obj_id", "portfolios_portfolio"."subscription_approve" FROM "portfolios_portfolio" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_post_associated_portfolios"."portfolio_id") WHERE "portfolios_post_associated_portfolios"."post_id" IN (901)SELECT ••• FROM "portfolios_portfolio" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_post_associated_portfolios"."portfolio_id") WHERE "portfolios_post_associated_portfolios"."post_id" IN (901) |
0.62 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(843) current = current[int(bit)]
/home/alex/tj3/templates/snippets/post_list_snippet.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
0.54 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/post_list_snippet.html |
|||||||||||||||||||||
|
SELECT DISTINCT "portfolios_post"."id",
2 similar queries.
Duplicated 2 times.
"portfolios_post"."user_id", "portfolios_post"."title", "portfolios_post"."body", "portfolios_post"."category", "portfolios_post"."created_on", "portfolios_post"."updated_on", "portfolios_post"."published_on", "portfolios_post"."published", "portfolios_post"."last_published", "portfolios_post"."slug", "portfolios_post"."allow_comments", "portfolios_post"."is_spam" FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ORDER BY "portfolios_post"."published_on" DESC LIMIT 1SELECT ••• FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ORDER BY "portfolios_post"."published_on" DESC LIMIT 1 |
4.02 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(843) current = current[int(bit)]
/home/alex/tj3/templates/snippets/post_list_snippet.html |
|||||||||||||||||||||
|
SELECT ("portfolios_post_associated_portfolios"."post_id") AS "_prefetch_related_val_post_id",
2 similar queries.
Duplicated 2 times.
"portfolios_portfolio"."id", "portfolios_portfolio"."user_id", "portfolios_portfolio"."name", "portfolios_portfolio"."description", "portfolios_portfolio"."private", "portfolios_portfolio"."custompromopage", "portfolios_portfolio"."mentor_enabled", "portfolios_portfolio"."subscription_enabled", "portfolios_portfolio"."price", "portfolios_portfolio"."recurring_interval", "portfolios_portfolio"."product_id", "portfolios_portfolio"."created_at", "portfolios_portfolio"."price_obj_id", "portfolios_portfolio"."subscription_approve" FROM "portfolios_portfolio" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_post_associated_portfolios"."portfolio_id") WHERE "portfolios_post_associated_portfolios"."post_id" IN (901)SELECT ••• FROM "portfolios_portfolio" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_post_associated_portfolios"."portfolio_id") WHERE "portfolios_post_associated_portfolios"."post_id" IN (901) |
0.80 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(843) current = current[int(bit)]
/home/alex/tj3/templates/snippets/post_list_snippet.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
Duplicated 10 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1420 LIMIT 21 |
1.04 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/smartif.py in <lambda>(101) '==': infix(10, lambda context, x, y: x.eval(context) == y.eval(context)), /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/home/alex/tj3/templates/snippets/post_list_snippet.html |
|||||||||||||||||||||
|
SELECT DISTINCT "portfolios_post"."id",
"portfolios_post"."user_id", "portfolios_post"."title", "portfolios_post"."body", "portfolios_post"."category", "portfolios_post"."created_on", "portfolios_post"."updated_on", "portfolios_post"."published_on", "portfolios_post"."published", "portfolios_post"."last_published", "portfolios_post"."slug", "portfolios_post"."allow_comments", "portfolios_post"."is_spam" FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ORDER BY "portfolios_post"."published_on" DESC LIMIT 5SELECT ••• FROM "portfolios_post" INNER JOIN "auth_user" ON ("portfolios_post"."user_id" = "auth_user"."id") LEFT OUTER JOIN "portfolios_profile" ON ("auth_user"."id" = "portfolios_profile"."user_id") LEFT OUTER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_post"."id" = "portfolios_post_associated_portfolios"."post_id") WHERE ("portfolios_post"."published" AND "portfolios_post"."user_id" = 1420 AND (("portfolios_profile"."private_policy" AND NOT (EXISTS(SELECT (1) AS "a" FROM "portfolios_post_associated_portfolios" V1 WHERE (V1."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND U0."private")) AND V1."post_id" = "portfolios_post"."id") LIMIT 1))) OR (NOT "portfolios_profile"."private_policy" AND "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND NOT U0."private"))) OR "portfolios_post_associated_portfolios"."portfolio_id" IS NULL OR "portfolios_post_associated_portfolios"."portfolio_id" IN (SELECT U0."id" FROM "portfolios_portfolio" U0 WHERE (U0."user_id" = 1420 AND (U0."subscription_enabled" AND U0."subscription_approve" = 3))))) ORDER BY "portfolios_post"."published_on" DESC LIMIT 5 |
1.72 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/alex/tj3/venv3.9.16/bin/gunicorn in <module>(8) sys.exit(run()) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/wsgiapp.py in run(58) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(228) super().run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in manage_workers(545) self.spawn_workers() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_workers(616) self.spawn_worker() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/arbiter.py in spawn_worker(583) worker.init_process() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/base.py in init_process(140) self.run() /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run(123) self.run_for_one(timeout) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in run_for_one(67) self.accept(listener) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in accept(29) self.handle(listener, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle(134) self.handle_request(listener, req, client, addr) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/gunicorn/workers/sync.py in handle_request(175) respiter = self.wsgi(environ, resp.start_response) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/allauth/account/middleware.py in middleware(34) response = get_response(request) /home/alex/tj3/tj3/middleware.py in __call__(45) response = self.get_response(request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in render(105) self.content = self.rendered_content /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/response.py in rendered_content(83) return template.render(context, self._request) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/backends/django.py in render(61) return self.template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(170) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/loader_tags.py in render(195) return template.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(172) return self._render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/base.py in render_annotated(905) return self.render(context) /home/alex/tj3/venv3.9.16/lib/python3.9/site-packages/django/template/defaulttags.py in render(171) len_values = len(values)
/home/alex/tj3/templates/snippets/post_list_snippet.html |
|||||||||||||||||||||
|
SELECT ("portfolios_post_associated_portfolios"."post_id") AS "_prefetch_related_val_post_id",
"portfolios_portfolio"."id", "portfolios_portfolio"."user_id", "portfolios_portfolio"."name", "portfolios_portfolio"."description", "portfolios_portfolio"."private", "portfolios_portfolio"."custompromopage", "portfolios_portfolio"."mentor_enabled", "portfolios_portfolio"."subscription_enabled", "portfolios_portfolio"."price", "portfolios_portfolio"."recurring_interval", "portfolios_portfolio"."product_id", "portfolios_portfolio"."created_at", "portfolios_portfolio"."price_obj_id", "portfolios_portfolio"."subscription_approve" FROM "portfolios_portfolio" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_post_associated_portfolios"."portfolio_id") WHERE "portfolios_post_associated_portfolios"."post_id" IN (901, 456)SELECT ••• FROM "portfolios_portfolio" INNER JOIN "portfolios_post_associated_portfolios" ON ("portfolios_portfolio"."id" = "portfolios_post_associated_portfolios"."portfolio_id") WHERE "portfolios_post_associated_portfolios"."post_id" IN (901, 456) |
0.64 | ||||||||||||||||||||
