I love LEGO! I prefer the minifigure scale. Mostly I build from my kids' sets and they play with my creations :).
| Resource | Value |
|---|---|
| User CPU time | 337.799 msec |
| System CPU time | 3.736 msec |
| Total CPU time | 341.535 msec |
| Elapsed time | 378.968 msec |
| Context switches | 170 voluntary, 7 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" = '_TLG_') 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" = '_TLG_') LIMIT 21 |
8.96 | ||||||||||||||||||||
|
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 (460321)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 (460321) |
0.23 | ||||||||||||||||||||
|
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" = 460321 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 460321 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(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" = 460321 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 460321 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(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(92) 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.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(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(92) if self.plan.is_designer(): /home/nathan/rb/site/./accounts/models/users.py in is_designer(518) 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" = 460321) 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" = 460321) LIMIT 21 |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(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(93) 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 (460321)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 (460321) |
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(93) 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" = 460321)SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'personalisation' AND "accounts_usersetting"."user_id" = 460321) |
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(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(94) ga_tracking_id = user.get_personalisation_option('ga_tracking_id') /home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_option(191) options = self.get_personalisation_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_options(183) 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" = 460321 ORDER BY "accounts_userprofilesection"."order" ASCSELECT ••• FROM "accounts_userprofilesection" WHERE "accounts_userprofilesection"."user_id" = 460321 ORDER BY "accounts_userprofilesection"."order" ASC |
0.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(351) if len(context['sections']) == 0: |
|||||||||||||||||||||
|
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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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."active_change_dt", T10."active_change_by_id", T10."last_checked_for_bi", T10."descr", T10."primary_photo_id", T10."primary_moc_image_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" = 460321 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" = 460321 AND "lego_moc"."is_for_sale" AND "lego_moc"."is_hosted") ORDER BY 1 DESC LIMIT 6 |
7.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(2020) for moc in mocs: |
|||||||||||||||||||||
|
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
2 similar queries.
"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 (85472, 102147, 73032, 211883, 78932, 260734))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 (85472, 102147, 73032, 211883, 78932, 260734)) |
0.55 | ||||||||||||||||||||
|
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(2020) 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-11-16T00:43:01.087301+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:43:01.087298+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['78932', '73032', '85472', '102147', '260734', '211883']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-11-16T00:43:01.087301+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:43:01.087298+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['78932', '73032', '85472', '102147', '260734', '211883']]::jsonb[]))) |
0.67 | ||||||||||||||||||||
|
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(2025) Moc.attach_discount_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_discount_to_mocs(1582) for discount in discounts: |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
2 similar queries.
Duplicated 2 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 (460321))SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (460321)) |
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(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(2026) Moc.attach_designer_plan_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_designer_plan_to_mocs(1601) 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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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."active_change_dt", T10."active_change_by_id", T10."last_checked_for_bi", T10."descr", T10."primary_photo_id", T10."primary_moc_image_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" = 460321) 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" = 460321) ORDER BY "lego_setstatstotal"."likes" DESC LIMIT 6 |
2.68 | ||||||||||||||||||||
|
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(1984) mocs = Designer.get_liked_mocs(user.id, 6) /home/nathan/rb/site/./lego/models/designers.py in get_liked_mocs(202) pop_mocs = list(qs[:limit]) |
|||||||||||||||||||||
|
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
2 similar queries.
"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 (85472, 73032, 260734, 78932, 109883, 233566))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 (85472, 73032, 260734, 78932, 109883, 233566)) |
0.36 | ||||||||||||||||||||
|
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(1984) mocs = Designer.get_liked_mocs(user.id, 6) /home/nathan/rb/site/./lego/models/designers.py in get_liked_mocs(202) pop_mocs = list(qs[:limit]) |
|||||||||||||||||||||
|
SELECT "lego_designerdiscount"."id",
"lego_designerdiscount"."designer_id", "lego_designerdiscount"."name", "lego_designerdiscount"."start_date", "lego_designerdiscount"."end_date", "lego_designerdiscount"."discount_pct", "lego_designerdiscount"."mocs" FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-11-16T00:43:01.095764+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:43:01.095762+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['78932', '73032', '85472', '233566', '109883', '260734']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-11-16T00:43:01.095764+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:43:01.095762+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['78932', '73032', '85472', '233566', '109883', '260734']]::jsonb[]))) |
0.41 | ||||||||||||||||||||
|
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(1990) Moc.attach_discount_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_discount_to_mocs(1582) for discount in discounts: |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
2 similar queries.
Duplicated 2 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 (460321))SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" IN (460321)) |
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(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1991) Moc.attach_designer_plan_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_designer_plan_to_mocs(1601) 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" = 460321 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 460321 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(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(2030) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(2032) is_public_badges = user.get_privacy_option('is_public_badges') /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285) options = self.get_privacy_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(279) 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" = 460321) 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" = 460321) ORDER BY "django_comments"."submit_date" DESC LIMIT 5 |
6.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(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1981) 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 (460321)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 (460321) |
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(357) context.update(section.get_context(request, profile_user)) /home/nathan/rb/site/./accounts/models/users.py in get_context(1981) return {'comments': (comments, len(comments))} |
|||||||||||||||||||||
|
SELECT "rb_sitesettings"."id",
"rb_sitesettings"."name", "rb_sitesettings"."value" FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21SELECT ••• FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' 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/./rb/templatetags/rb_settings.py in site_message(147) message = SiteSettings.get_site_message() /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./rb/models/site.py in get_site_message(24) setting = cls.objects.get(name=SiteSettings.SITE_MESSAGE)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
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.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/./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(253) country = Country.objects.get(iso=country_code)
/home/nathan/rb/site/rb/templates/rb/includes/topbar.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" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC 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/./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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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(279) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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_privacy_options(279) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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_privacy_options(279) 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" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 460321 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_navbar_card.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) LIMIT 1 |
0.24 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(634) 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.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/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" = 460321 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 460321 LIMIT 21 |
0.16 | ||||||||||||||||||||
|
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" = 464232 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 464232 LIMIT 21 |
0.23 | ||||||||||||||||||||
|
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",
7 similar queries.
Duplicated 2 times.
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 20 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 20 LIMIT 21 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 460321)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" = 460321) |
0.23 | ||||||||||||||||||||
|
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(882) 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" = 460321) )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" = 460321)) |
0.31 | ||||||||||||||||||||
|
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(83) 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" = 460321SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 460321 |
0.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(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./lego/models/designers.py in get_stats(86) 'num_followers': self.get_num_followers_formatted(), /home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(253) 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_userprofile" WHERE UPPER("accounts_userprofile"."location"::text) = UPPER('Budapest, Hungary')SELECT ••• FROM "accounts_userprofile" WHERE UPPER("accounts_userprofile"."location"::text) = UPPER('Budapest, Hungary') |
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(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_num_users_at_location(610) return UserProfile.objects.filter(location__iexact=self.profile.location).count()
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_location.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 460321SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 460321 |
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" = 460321 LIMIT 21SELECT ••• FROM "accounts_userstats" WHERE "accounts_userstats"."user_id" = 460321 LIMIT 21 |
0.30 | ||||||||||||||||||||
|
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" = 460321 LIMIT 21SELECT ••• FROM "accounts_userrank" WHERE "accounts_userrank"."user_id" = 460321 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 "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 312157 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 312157 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 321654 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 321654 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/./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/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 302346 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 302346 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 274955 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 274955 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 559306 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 559306 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 87186 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 87186 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 312157 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 312157 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 321654 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 321654 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 302346 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 302346 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 428455 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 428455 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 467077 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 467077 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_mocimage"."id",
12 similar queries.
Duplicated 2 times.
"lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension" FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 559306 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 559306 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/models/sets.py in img_dir(771) img = self.primary_moc_image
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "accounts_userbadge"."id",
"accounts_userbadge"."user_id", "accounts_userbadge"."badge_id" FROM "accounts_userbadge" INNER JOIN "lego_badge" ON ("accounts_userbadge"."badge_id" = "lego_badge"."id") WHERE "accounts_userbadge"."user_id" = 460321 ORDER BY "lego_badge"."num_users" ASC LIMIT 6SELECT ••• FROM "accounts_userbadge" INNER JOIN "lego_badge" ON ("accounts_userbadge"."badge_id" = "lego_badge"."id") WHERE "accounts_userbadge"."user_id" = 460321 ORDER BY "lego_badge"."num_users" ASC LIMIT 6 |
0.89 | ||||||||||||||||||||
|
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_section_badges.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
7 similar queries.
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 7 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 7 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/templates/accounts/includes/user_profile_section_badges.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
7 similar queries.
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 60 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 60 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/templates/accounts/includes/user_profile_section_badges.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
7 similar queries.
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 36 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 36 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_section_badges.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
7 similar queries.
Duplicated 2 times.
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 20 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 20 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_section_badges.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
7 similar queries.
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 2 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 2 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/templates/accounts/includes/user_profile_section_badges.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
7 similar queries.
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 30 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 30 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/templates/accounts/includes/user_profile_section_badges.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" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
6 similar queries.
Duplicated 6 times.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 460321 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 460321 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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(670) return self.get_privacy_option('is_public_plan') /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285) options = self.get_privacy_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(279) 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" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 460321 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" = 460321 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 460321 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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(670) return self.get_privacy_option('is_public_plan') /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285) options = self.get_privacy_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(279) 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" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 460321 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" = 460321 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 460321 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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/./accounts/models/user_extras.py in get_rolename(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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/./accounts/models/user_extras.py in get_rolename(634) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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(670) return self.get_privacy_option('is_public_plan') /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285) options = self.get_privacy_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(279) 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" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 460321 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" = 460321 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 460321 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./accounts/views/profile.py in user_profile(358) return render(request, 'accounts/user_profile.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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(670) return self.get_privacy_option('is_public_plan') /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285) options = self.get_privacy_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(279) 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" = 460321 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 460321 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" = 460321 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 460321 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(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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/./accounts/models/user_extras.py in get_rolename(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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/./accounts/models/user_extras.py in get_rolename(634) 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"
16 similar queries.
Duplicated 16 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" = 460321) 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" = 460321) 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(634) 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" = 460321) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 460321) 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(670) return self.get_privacy_option('is_public_plan') /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285) options = self.get_privacy_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(279) 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_userprofile" WHERE UPPER("accounts_userprofile"."location"::text) = UPPER('Budapest, Hungary')SELECT ••• FROM "accounts_userprofile" WHERE UPPER("accounts_userprofile"."location"::text) = UPPER('Budapest, Hungary') |
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_num_users_at_location(610) return UserProfile.objects.filter(location__iexact=self.profile.location).count()
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_location.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 460321SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 460321 |
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/templates/accounts/includes/user_profile_navbar_trophy.html |
|||||||||||||||||||||
No messages logged.
I completely understand your points regarding the fragility during posing. This model is indeed much more of a display piece than a play set, and the tension of the joints can make posing a bit nerve-wracking. That is actually why I added the red warning section to the description, to prepare builders for the fact that the rotation joints and decorative assemblies require extra care.
I am sorry if the balance between poseability and stability didn't fully meet your expectations, but your review gives me great insights on what to improve in my future designs. Thanks again for taking the time to share your experience!