| Resource | Value |
|---|---|
| User CPU time | 466.293 msec |
| System CPU time | 5.519 msec |
| Total CPU time | 471.812 msec |
| Elapsed time | 568.550 msec |
| Context switches | 165 voluntary, 8 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" = 'Made With Brix') 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" = 'Made With Brix') LIMIT 21 |
8.75 | ||||||||||||||||||||
|
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",
3 similar queries.
Duplicated 3 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 (591017)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 (591017) |
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(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" = 591017 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 591017 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(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" = 591017 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 591017 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" = 4 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 4 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 "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"."id" = 591017) 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"."id" = 591017) 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(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(89) user = ProxyUser.objects.get(id=self.id) # Designer class won't have options pre-loaded so do a lookup instead |
|||||||||||||||||||||
|
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
3 similar queries.
Duplicated 3 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 (591017)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 (591017) |
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(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(89) user = ProxyUser.objects.get(id=self.id) # Designer class won't have options pre-loaded so do a lookup instead |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'personalisation' AND "accounts_usersetting"."user_id" = 591017)SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'personalisation' AND "accounts_usersetting"."user_id" = 591017) |
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() /home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(90) ga_tracking_id = user.get_personalisation_option('ga_tracking_id') /home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_option(175) options = self.get_personalisation_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_options(167) if len(self.personalisation_options) == 0: |
|||||||||||||||||||||
|
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" = 591017 ORDER BY "accounts_userprofilesection"."order" ASCSELECT ••• FROM "accounts_userprofilesection" WHERE "accounts_userprofilesection"."user_id" = 591017 ORDER BY "accounts_userprofilesection"."order" ASC |
0.35 | ||||||||||||||||||||
|
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" = 591017) ORDER BY "lego_baseset"."added_dt" 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" = 591017) ORDER BY "lego_baseset"."added_dt" DESC LIMIT 6 |
2.34 | ||||||||||||||||||||
|
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(1859) for moc in mocs: |
|||||||||||||||||||||
|
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
3 similar queries.
Duplicated 3 times.
"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 (124384, 150501, 304680, 187534, 209043, 165430))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 (124384, 150501, 304680, 187534, 209043, 165430)) |
0.63 | ||||||||||||||||||||
|
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(1859) for moc in mocs: |
|||||||||||||||||||||
|
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-22T14:44:46.049230+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T14:44:46.049228+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['304680', '209043', '187534', '165430', '150501', '124384']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T14:44:46.049230+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T14:44:46.049228+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['304680', '209043', '187534', '165430', '150501', '124384']]::jsonb[]))) |
0.53 | ||||||||||||||||||||
|
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(1864) 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",
3 similar queries.
Duplicated 3 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (591017))SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (591017)) |
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(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1865) 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 (
select count(*) from accounts_mocpurchase where moc_id=lego_moc.baseset_ptr_id ) AS "score", "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" = 591017 AND "lego_moc"."is_for_sale" AND "lego_moc"."is_hosted") ORDER BY 1 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" = 591017 AND "lego_moc"."is_for_sale" AND "lego_moc"."is_hosted") ORDER BY 1 DESC LIMIT 6 |
65.32 | ||||||||||||||||||||
|
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(1872) for moc in mocs: |
|||||||||||||||||||||
|
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
3 similar queries.
Duplicated 3 times.
"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 (124384, 150501, 304680, 187534, 209043, 165430))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 (124384, 150501, 304680, 187534, 209043, 165430)) |
0.46 | ||||||||||||||||||||
|
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(1872) for moc in mocs: |
|||||||||||||||||||||
|
SELECT "lego_designerdiscount"."id",
2 similar queries.
"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-22T14:44:46.120891+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T14:44:46.120888+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['124384', '150501', '209043', '165430', '304680', '187534']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T14:44:46.120891+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T14:44:46.120888+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['124384', '150501', '209043', '165430', '304680', '187534']]::jsonb[]))) |
0.48 | ||||||||||||||||||||
|
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(1877) 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",
3 similar queries.
Duplicated 3 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (591017))SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (591017)) |
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(1878) 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 "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" = 591017) 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" = 591017) ORDER BY "lego_setstatstotal"."likes" DESC LIMIT 6 |
1.93 | ||||||||||||||||||||
|
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",
3 similar queries.
Duplicated 3 times.
"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 (124384, 150501, 304680, 187534, 209043, 165430))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 (124384, 150501, 304680, 187534, 209043, 165430)) |
0.29 | ||||||||||||||||||||
|
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",
2 similar queries.
"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-22T14:44:46.128526+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T14:44:46.128524+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['124384', '150501', '209043', '165430', '304680', '187534']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T14:44:46.128526+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T14:44:46.128524+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['124384', '150501', '209043', '165430', '304680', '187534']]::jsonb[]))) |
0.37 | ||||||||||||||||||||
|
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",
3 similar queries.
Duplicated 3 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (591017))SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (591017)) |
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(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" = 591017 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 591017 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(1882) badges = UserBadge.objects.filter(user=self.user).order_by('badge__num_users')[:6] |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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(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" = 591017) 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" = 591017) ORDER BY "django_comments"."submit_date" DESC LIMIT 5 |
2.77 | ||||||||||||||||||||
|
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",
3 similar queries.
Duplicated 3 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 (591017)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 (591017) |
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(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.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/./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" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 591017 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/accounts/templates/accounts/includes/user_profile_mobile_menu.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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_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",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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_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",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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/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" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 591017 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/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" = 591017) 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" = 591017) 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/./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 "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" = 4 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 4 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" = 591017 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 591017 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" = 868995 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 868995 LIMIT 21 |
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/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" = 21 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 21 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/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" = 591017)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" = 591017) |
0.26 | ||||||||||||||||||||
|
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" = 591017) )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" = 591017)) |
0.30 | ||||||||||||||||||||
|
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" = 591017SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 591017 |
5.39 | ||||||||||||||||||||
|
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" = 591017SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 591017 |
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_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" = 591017 LIMIT 21SELECT ••• FROM "accounts_userstats" WHERE "accounts_userstats"."user_id" = 591017 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) /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 "accounts_userrank"."user_id",
"accounts_userrank"."rank_points", "accounts_userrank"."rank_parts", "accounts_userrank"."rank_views" FROM "accounts_userrank" WHERE "accounts_userrank"."user_id" = 591017 LIMIT 21SELECT ••• FROM "accounts_userrank" WHERE "accounts_userrank"."user_id" = 591017 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
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"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 304680 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 304680 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 3 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 270817 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 270817 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 209043 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 209043 LIMIT 1 |
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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21 |
0.30 | ||||||||||||||||||||
|
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/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 187534 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 187534 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/./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 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 165430 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 165430 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/./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 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 150501 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 150501 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 124384 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 124384 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 124384 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 124384 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 150501 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 150501 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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 209043 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 209043 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 165430 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 165430 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/./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 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 304680 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 304680 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 3 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 270817 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 270817 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 187534 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 187534 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 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 124384 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 124384 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 150501 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 150501 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 209043 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 209043 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 "lego_baseset"."id",
12 similar queries.
Duplicated 9 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 98028 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 165430 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 165430 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/./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 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 304680 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 304680 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/./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 "lego_baseset"."id",
12 similar queries.
Duplicated 3 times.
"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" FROM "lego_baseset" WHERE "lego_baseset"."id" = 270817 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 270817 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/./lego/templatetags/sets/drawing.py in render_moc(78) return render_to_string('sets/render_set.html', {'set': set,
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
18 similar queries.
Duplicated 3 times.
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 187534 LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 187534 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/./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" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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" = 591017 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 591017 LIMIT 21 |
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 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" = 591017) 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" = 591017) 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" = 591017) 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" = 591017) 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 "accounts_usersetting"."id",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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 is_public_plan(654) return self.get_privacy_option('is_public_plan') /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)
/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" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 591017 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" = 591017 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 591017 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" = 591017) 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" = 591017) 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" = 591017) 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" = 591017) 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 "accounts_usersetting"."id",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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 is_public_plan(654) return self.get_privacy_option('is_public_plan') /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)
/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" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 591017 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" = 591017 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 591017 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_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" = 591017) 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" = 591017) LIMIT 1 |
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(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" = 591017) 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" = 591017) 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 "accounts_usersetting"."id",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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 is_public_plan(654) return self.get_privacy_option('is_public_plan') /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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
3 similar queries.
Duplicated 3 times.
FROM "lego_part" WHERE "lego_part"."part_num" = '000000' LIMIT 1SELECT ••• FROM "lego_part" WHERE "lego_part"."part_num" = '000000' 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/./rb/templatetags/rb_helpers.py in parse_cards(561) return parse_cards(txt) /home/nathan/rb/site/./rb/utils.py in parse_cards(1698) d = re.sub(r'#(\d{2,5}[a-z0-9]*)', conditional_replacer, d) # part eg 75c09 /usr/lib/python3.10/re.py in sub(209) return _compile(pattern, flags).sub(repl, string, count) /home/nathan/rb/site/./rb/utils.py in conditional_replacer(1683) if Part.all_objects.filter(part_num=x).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
3 similar queries.
Duplicated 3 times.
FROM "lego_part" WHERE "lego_part"."part_num" = '000000' LIMIT 1SELECT ••• FROM "lego_part" WHERE "lego_part"."part_num" = '000000' 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/./rb/templatetags/rb_helpers.py in parse_cards(561) return parse_cards(txt) /home/nathan/rb/site/./rb/utils.py in parse_cards(1698) d = re.sub(r'#(\d{2,5}[a-z0-9]*)', conditional_replacer, d) # part eg 75c09 /usr/lib/python3.10/re.py in sub(209) return _compile(pattern, flags).sub(repl, string, count) /home/nathan/rb/site/./rb/utils.py in conditional_replacer(1683) if Part.all_objects.filter(part_num=x).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
3 similar queries.
Duplicated 3 times.
FROM "lego_part" WHERE "lego_part"."part_num" = '000000' LIMIT 1SELECT ••• FROM "lego_part" WHERE "lego_part"."part_num" = '000000' 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/./rb/templatetags/rb_helpers.py in parse_cards(561) return parse_cards(txt) /home/nathan/rb/site/./rb/utils.py in parse_cards(1698) d = re.sub(r'#(\d{2,5}[a-z0-9]*)', conditional_replacer, d) # part eg 75c09 /usr/lib/python3.10/re.py in sub(209) return _compile(pattern, flags).sub(repl, string, count) /home/nathan/rb/site/./rb/utils.py in conditional_replacer(1683) if Part.all_objects.filter(part_num=x).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" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 591017 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" = 591017 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 591017 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_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" = 591017) 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" = 591017) LIMIT 1 |
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(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" = 591017) 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" = 591017) 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 "accounts_usersetting"."id",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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 is_public_plan(654) return self.get_privacy_option('is_public_plan') /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)
/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" = 591017 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 591017 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" = 591017 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 591017 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_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" = 591017) 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" = 591017) 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 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" = 591017) 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" = 591017) 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 "accounts_usersetting"."id",
9 similar queries.
Duplicated 9 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 591017) 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 is_public_plan(654) return self.get_privacy_option('is_public_plan') /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)
/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" = 591017SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 591017 |
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.
Once that foundation is set, I focus on the most eye-catching angles first and refine those areas with as much detail as possible. After that, I work my way around the rest of the build. When the full structure is in place, I usually rebuild everything several times to improve stability; this castle went through about five or six full revisions before it felt sturdy and visually balanced.
For me, the hardest part is settling on the right idea and sticking with it. There are plenty of moments where I don’t like what I’ve made—or even worse, I really like a section but it just doesn’t fit into the overall model! 😂