| Resource | Value |
|---|---|
| User CPU time | 204.429 msec |
| System CPU time | 1.954 msec |
| Total CPU time | 206.383 msec |
| Elapsed time | 224.717 msec |
| Context switches | 104 voluntary, 13 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| 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", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND "auth_user"."username" = 'mboehlen') LIMIT 21SELECT ••• FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND "auth_user"."username" = 'mboehlen') LIMIT 21 |
8.87 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(327) profile_user = get_object_or_404(ProxyUser, username=username) |
|||||||||||||||||||||
|
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
2 similar queries.
Duplicated 2 times.
"auth_group"."id", "auth_group"."name" FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (118227)SELECT ••• FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (118227) |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(327) profile_user = get_object_or_404(ProxyUser, username=username) |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
6 similar queries.
Duplicated 6 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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(343) context['designer_ga_tracking_id'] = profile_user.designer.get_ga_tracking_id() |
|||||||||||||||||||||
|
SELECT "accounts_userplan"."user_id",
"accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 118227 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 118227 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(343) context['designer_ga_tracking_id'] = profile_user.designer.get_ga_tracking_id() /home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(88) if self.plan.is_designer(): /usr/lib/python3.10/contextlib.py in inner(79) return func(*args, **kwds) /home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36) .__get__(instance, instance_type) |
|||||||||||||||||||||
|
SELECT "plans_plan"."id",
2 similar queries.
Duplicated 2 times.
"plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21 |
0.06 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(343) context['designer_ga_tracking_id'] = profile_user.designer.get_ga_tracking_id() /home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(88) if self.plan.is_designer(): /home/nathan/rb/site/./accounts/models/users.py in is_designer(381) return self.plan.is_designer() |
|||||||||||||||||||||
|
SELECT "accounts_userprofilesection"."id",
"accounts_userprofilesection"."user_id", "accounts_userprofilesection"."section", "accounts_userprofilesection"."order", "accounts_userprofilesection"."options" FROM "accounts_userprofilesection" WHERE "accounts_userprofilesection"."user_id" = 118227 ORDER BY "accounts_userprofilesection"."order" ASCSELECT ••• FROM "accounts_userprofilesection" WHERE "accounts_userprofilesection"."user_id" = 118227 ORDER BY "accounts_userprofilesection"."order" ASC |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(351) if len(context['sections']) == 0: |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_moc"."baseset_ptr_id", "lego_moc"."designer_id", "lego_moc"."detail_url", "lego_moc"."gallery_url", "lego_moc"."bi_url", "lego_moc"."cad_url", "lego_moc"."video", "lego_moc"."bi_type", "lego_moc"."is_for_sale", "lego_moc"."is_hosted", "lego_moc"."cost", "lego_moc"."currency_id", "lego_moc"."parent_set_1_id", "lego_moc"."parent_set_2_id", "lego_moc"."parent_set_3_id", "lego_moc"."parent_set_4_id", "lego_moc"."parent_set_5_id", "lego_moc"."parent_inv_1_id", "lego_moc"."parent_inv_2_id", "lego_moc"."parent_inv_3_id", "lego_moc"."parent_inv_4_id", "lego_moc"."parent_inv_5_id", "lego_moc"."parent_type", "lego_moc"."is_allowed_premium", "lego_moc"."is_locked", "lego_moc"."last_social_post", "lego_moc"."is_review_requested", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T5."id", T5."parent_id", T5."name", T5."slug", T5."set_count", T5."t1_id", T5."t1_name", T5."t2_name", T5."t3_name", T5."lego_blurb", T5."banner_img", T5."descr", T6."id", T6."parent_id", T6."name", T6."slug", T6."set_count", T6."t1_id", T6."t1_name", T6."t2_name", T6."t3_name", T6."lego_blurb", T6."banner_img", T6."descr", "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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent", "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly", T10."id", T10."set_num", T10."name", T10."year", T10."theme_id", T10."set_type", T10."num_parts", T10."default_inventory_id", T10."is_active", T10."is_accessory", T10."added_dt", T10."added_by_id", T10."last_modified_dt", T10."last_modified_by_id", T10."last_checked_for_bi", T10."descr", T10."primary_photo_id", T10."is_gear", T10."is_book", T10."search_vector", T10."mfhash_vector", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_baseset" T10 ON ("lego_moc"."parent_set_1_id" = T10."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) ORDER BY "lego_setstatstotal"."likes" DESC LIMIT 6SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_baseset" T10 ON ("lego_moc"."parent_set_1_id" = T10."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) ORDER BY "lego_setstatstotal"."likes" DESC LIMIT 6 |
1.59 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1836) mocs = Designer.get_liked_mocs(user.id, 6) /home/nathan/rb/site/./lego/models/designers.py in get_liked_mocs(180) pop_mocs = list(qs[:limit]) |
|||||||||||||||||||||
|
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
"taggit_tag"."id", "taggit_tag"."name", "taggit_tag"."slug" FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (31435))SELECT ••• FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (31435)) |
0.40 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1836) mocs = Designer.get_liked_mocs(user.id, 6) /home/nathan/rb/site/./lego/models/designers.py in get_liked_mocs(180) pop_mocs = list(qs[:limit]) |
|||||||||||||||||||||
|
SELECT "lego_designerdiscount"."id",
"lego_designerdiscount"."designer_id", "lego_designerdiscount"."name", "lego_designerdiscount"."start_date", "lego_designerdiscount"."end_date", "lego_designerdiscount"."discount_pct", "lego_designerdiscount"."mocs" FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-23T00:11:12.409436+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-23T00:11:12.409432+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['31435']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-23T00:11:12.409436+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-23T00:11:12.409432+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['31435']]::jsonb[]))) |
1.42 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1842) Moc.attach_discount_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_discount_to_mocs(1531) for discount in discounts: |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (118227))SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (118227)) |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1843) Moc.attach_designer_plan_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_designer_plan_to_mocs(1550) settings_map = {s.user_id: s.value['is_public_plan'] for s in settings} |
|||||||||||||||||||||
|
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"."id" = 118227 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 118227 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1882) badges = UserBadge.objects.filter(user=self.user).order_by('badge__num_users')[:6] |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
4 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1884) is_public_badges = user.get_privacy_option('is_public_badges') /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269) options = self.get_privacy_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263) options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS) |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
"django_comments"."content_type_id", "django_comments"."object_pk", "django_comments"."site_id", "django_comments"."user_id", "django_comments"."user_name", "django_comments"."user_email", "django_comments"."user_url", "django_comments"."comment", "django_comments"."submit_date", "django_comments"."ip_address", "django_comments"."is_public", "django_comments"."is_removed", "threadedcomments_comment"."comment_ptr_id", "threadedcomments_comment"."title", "threadedcomments_comment"."parent_id", "threadedcomments_comment"."last_child_id", "threadedcomments_comment"."tree_path", "threadedcomments_comment"."newest_activity", "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", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent", "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly", "accounts_userprofile"."user_id", "accounts_userprofile"."last_mod_inv", "accounts_userprofile"."last_activity", "accounts_userprofile"."last_ip", "accounts_userprofile"."last_country_id", "accounts_userprofile"."last_agent", "accounts_userprofile"."is_email_verified", "accounts_userprofile"."is_email_idle", "accounts_userprofile"."email_last_clicked", "accounts_userprofile"."api_token", "accounts_userprofile"."real_name", "accounts_userprofile"."location", "accounts_userprofile"."brickset_url", "accounts_userprofile"."mocpages_url", "accounts_userprofile"."flickr_url", "accounts_userprofile"."eurobricks_url", "accounts_userprofile"."youtube_url", "accounts_userprofile"."bricklink_url", "accounts_userprofile"."brickowl_url", "accounts_userprofile"."bricksafe_url", "accounts_userprofile"."website_url", "accounts_userprofile"."facebook_url", "accounts_userprofile"."twitter_url", "accounts_userprofile"."karma", "accounts_userprofile"."trophy_badge_id", "accounts_userprofile"."comments", "accounts_userprofile"."mfhash_vector", "accounts_userprofile"."is_muted", "accounts_userprofile"."is_banned", "accounts_userprofile"."is_suspected_pirate", "accounts_userprofile"."muted_until", "accounts_userprofile"."blocked_operations", "accounts_userprofile"."is_guest", "accounts_userprofile"."guest_token" FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") INNER JOIN "auth_user" ON ("django_comments"."user_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "accounts_userprofile" ON ("auth_user"."id" = "accounts_userprofile"."user_id") WHERE (NOT "django_comments"."is_removed" AND "django_comments"."user_id" = 118227) ORDER BY "django_comments"."submit_date" DESC LIMIT 5SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") INNER JOIN "auth_user" ON ("django_comments"."user_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "accounts_userprofile" ON ("auth_user"."id" = "accounts_userprofile"."user_id") WHERE (NOT "django_comments"."is_removed" AND "django_comments"."user_id" = 118227) ORDER BY "django_comments"."submit_date" DESC LIMIT 5 |
0.82 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1833) return {'comments': (comments, len(comments))} |
|||||||||||||||||||||
|
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
2 similar queries.
Duplicated 2 times.
"auth_group"."id", "auth_group"."name" FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (118227)SELECT ••• FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (118227) |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1833) return {'comments': (comments, len(comments))} |
|||||||||||||||||||||
|
SELECT "countries_plus_country"."iso",
"countries_plus_country"."iso3", "countries_plus_country"."iso_numeric", "countries_plus_country"."fips", "countries_plus_country"."name", "countries_plus_country"."capital", "countries_plus_country"."area", "countries_plus_country"."population", "countries_plus_country"."continent", "countries_plus_country"."tld", "countries_plus_country"."currency_code", "countries_plus_country"."currency_symbol", "countries_plus_country"."currency_name", "countries_plus_country"."phone", "countries_plus_country"."postal_code_format", "countries_plus_country"."postal_code_regex", "countries_plus_country"."languages", "countries_plus_country"."geonameid", "countries_plus_country"."neighbours", "countries_plus_country"."equivalent_fips_code" FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21 |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20) geo_data = user.geo.get_user_currency() /home/nathan/rb/site/./geo/geo.py in get_user_currency(252) country = Country.objects.get(iso=country_code)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
7 similar queries.
Duplicated 7 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_mobile_menu.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
4 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263) options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)
/home/nathan/rb/site/accounts/templates/accounts/user_profile.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
4 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263) options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
4 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 118227) LIMIT 21 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263) options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
7 similar queries.
Duplicated 7 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "accounts_userstats"."id",
"accounts_userstats"."user_id", "accounts_userstats"."num_profile_views", "accounts_userstats"."num_shopper_scans", "accounts_userstats"."total_is_stale", "accounts_userstats"."total_sets", "accounts_userstats"."total_loose_parts", "accounts_userstats"."total_lost_set_parts", "accounts_userstats"."total_figures", "accounts_userstats"."total_all_parts" FROM "accounts_userstats" WHERE "accounts_userstats"."user_id" = 118227 LIMIT 21SELECT ••• FROM "accounts_userstats" WHERE "accounts_userstats"."user_id" = 118227 LIMIT 21 |
0.31 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(380) return self.stats.get_num_parts_summary() /usr/lib/python3.10/contextlib.py in inner(79) return func(*args, **kwds) /home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36) .__get__(instance, instance_type)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "plans_plan"."id",
2 similar queries.
Duplicated 2 times.
"plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "accounts_userprofile"."user_id",
"accounts_userprofile"."last_mod_inv", "accounts_userprofile"."last_activity", "accounts_userprofile"."last_ip", "accounts_userprofile"."last_country_id", "accounts_userprofile"."last_agent", "accounts_userprofile"."is_email_verified", "accounts_userprofile"."is_email_idle", "accounts_userprofile"."email_last_clicked", "accounts_userprofile"."api_token", "accounts_userprofile"."real_name", "accounts_userprofile"."location", "accounts_userprofile"."brickset_url", "accounts_userprofile"."mocpages_url", "accounts_userprofile"."flickr_url", "accounts_userprofile"."eurobricks_url", "accounts_userprofile"."youtube_url", "accounts_userprofile"."bricklink_url", "accounts_userprofile"."brickowl_url", "accounts_userprofile"."bricksafe_url", "accounts_userprofile"."website_url", "accounts_userprofile"."facebook_url", "accounts_userprofile"."twitter_url", "accounts_userprofile"."karma", "accounts_userprofile"."trophy_badge_id", "accounts_userprofile"."comments", "accounts_userprofile"."mfhash_vector", "accounts_userprofile"."is_muted", "accounts_userprofile"."is_banned", "accounts_userprofile"."is_suspected_pirate", "accounts_userprofile"."muted_until", "accounts_userprofile"."blocked_operations", "accounts_userprofile"."is_guest", "accounts_userprofile"."guest_token" FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 118227 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 118227 LIMIT 21 |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /usr/lib/python3.10/contextlib.py in inner(79) return func(*args, **kwds) /home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36) .__get__(instance, instance_type)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "accounts_userbadge"."id",
"accounts_userbadge"."user_id", "accounts_userbadge"."badge_id" FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 113039 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 113039 LIMIT 21 |
0.24 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 40 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 40 LIMIT 21 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227)SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_num_mocs(866) self._num_mocs = Moc.objects.filter(designer=self.designer).count()
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT SUM("lego_setstatstotal"."likes") AS "likes__sum"
FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" IN ( SELECT U0."baseset_ptr_id" FROM "lego_moc" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") WHERE (U1."is_active" AND U0."designer_id" = 118227) )SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" IN (SELECT ••• FROM "lego_moc" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") WHERE (U1."is_active" AND U0."designer_id" = 118227)) |
0.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./lego/models/designers.py in get_stats(79) num_likes = SetStatsTotal.objects.filter(set__in=Moc.objects.filter(designer=self)).aggregate(Sum('likes'))['likes__sum'] or 0
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 118227SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 118227 |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./lego/models/designers.py in get_stats(82) 'num_followers': self.get_num_followers_formatted(), /home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(231) i = DesignerFollower.objects.filter(designer_id=self.id).count()
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 118227SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 118227 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_trophy.html |
|||||||||||||||||||||
|
SELECT "accounts_userrank"."user_id",
"accounts_userrank"."rank_points", "accounts_userrank"."rank_parts", "accounts_userrank"."rank_views" FROM "accounts_userrank" WHERE "accounts_userrank"."user_id" = 118227 LIMIT 21SELECT ••• FROM "accounts_userrank" WHERE "accounts_userrank"."user_id" = 118227 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /usr/lib/python3.10/contextlib.py in inner(79) return func(*args, **kwds) /home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36) .__get__(instance, instance_type)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 31435 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 31435 LIMIT 1 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set, /home/nathan/rb/site/./lego/models/mocs.py in is_alternate(204) if not self.is_pending and MocsWithErrors.objects.filter(moc=self).exists():
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
7 similar queries.
Duplicated 7 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
6 similar queries.
Duplicated 6 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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.25 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
7 similar queries.
Duplicated 7 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
6 similar queries.
Duplicated 6 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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
7 similar queries.
Duplicated 7 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
6 similar queries.
Duplicated 6 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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
7 similar queries.
Duplicated 7 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
6 similar queries.
Duplicated 6 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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.24 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
7 similar queries.
Duplicated 7 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 118227 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
6 similar queries.
Duplicated 6 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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 118227 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
11 similar queries.
Duplicated 11 times.
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 118227) LIMIT 1 |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 118227SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 118227 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_trophy.html |
|||||||||||||||||||||
No messages logged.
When doubting between different sets in the shop, went for this one due to this MOC.
Next to it, there is only one alternate build (and the set has a lot of pieces) so intending to come up something myself, but will never beat this one.... and it seems hard to come up with something as soon wheels are excluded ;-)