| Resource | Value |
|---|---|
| User CPU time | 546.112 msec |
| System CPU time | 13.130 msec |
| Total CPU time | 559.242 msec |
| Elapsed time | 619.565 msec |
| Context switches | 352 voluntary, 171 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 UPPER("auth_user"."username"::text) = UPPER('KlintIsztvud')) LIMIT 21SELECT ••• FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('KlintIsztvud')) LIMIT 21 |
8.89 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(763) profile_user = ProxyUser.objects.get(username__iexact=username) |
|||||||||||||||||||||
|
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
"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 (312876)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 (312876) |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(763) profile_user = ProxyUser.objects.get(username__iexact=username) |
|||||||||||||||||||||
|
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", "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 UPPER("auth_user"."username"::text) = UPPER('KlintIsztvud') LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE UPPER("auth_user"."username"::text) = UPPER('KlintIsztvud') LIMIT 21 |
0.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(780) designer = Designer.objects.get_or_none(username__iexact=username) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 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" = 312876)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" = 312876) |
2.76 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(803) total_mocs = mocs.count() |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_moc"."baseset_ptr_id", "lego_moc"."designer_id", "lego_moc"."detail_url", "lego_moc"."gallery_url", "lego_moc"."bi_url", "lego_moc"."cad_url", "lego_moc"."video", "lego_moc"."bi_type", "lego_moc"."is_for_sale", "lego_moc"."is_hosted", "lego_moc"."cost", "lego_moc"."currency_id", "lego_moc"."parent_set_1_id", "lego_moc"."parent_set_2_id", "lego_moc"."parent_set_3_id", "lego_moc"."parent_set_4_id", "lego_moc"."parent_set_5_id", "lego_moc"."parent_inv_1_id", "lego_moc"."parent_inv_2_id", "lego_moc"."parent_inv_3_id", "lego_moc"."parent_inv_4_id", "lego_moc"."parent_inv_5_id", "lego_moc"."parent_type", "lego_moc"."is_allowed_premium", "lego_moc"."is_locked", "lego_moc"."last_social_post", "lego_moc"."is_review_requested", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T5."id", T5."parent_id", T5."name", T5."slug", T5."set_count", T5."t1_id", T5."t1_name", T5."t2_name", T5."t3_name", T5."lego_blurb", T5."banner_img", T5."descr", T6."id", T6."parent_id", T6."name", T6."slug", T6."set_count", T6."t1_id", T6."t1_name", T6."t2_name", T6."t3_name", T6."lego_blurb", T6."banner_img", T6."descr", "lego_inventory"."id", "lego_inventory"."set_id", "lego_inventory"."version", "lego_inventory"."name", "lego_inventory"."is_active", "lego_inventory"."num_parts", "lego_inventory"."num_versions", "lego_setphoto"."id", "lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary", T9."id", T9."set_num", T9."name", T9."year", T9."theme_id", T9."set_type", T9."num_parts", T9."default_inventory_id", T9."is_active", T9."is_accessory", T9."added_dt", T9."added_by_id", T9."last_modified_dt", T9."last_modified_by_id", T9."last_checked_for_bi", T9."descr", T9."primary_photo_id", T9."is_gear", T9."is_book", T9."search_vector", T9."mfhash_vector", "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", T13."id", T13."set_num", T13."name", T13."year", T13."theme_id", T13."set_type", T13."num_parts", T13."default_inventory_id", T13."is_active", T13."is_accessory", T13."added_dt", T13."added_by_id", T13."last_modified_dt", T13."last_modified_by_id", T13."last_checked_for_bi", T13."descr", T13."primary_photo_id", T13."is_gear", T13."is_book", T13."search_vector", T13."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") LEFT OUTER JOIN "lego_inventory" ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id") LEFT OUTER JOIN "lego_setphoto" ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id") LEFT OUTER JOIN "lego_baseset" T9 ON ("lego_setphoto"."set_id" = T9."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" T13 ON ("lego_moc"."parent_set_1_id" = T13."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 312876) ORDER BY "lego_baseset"."added_dt" DESCSELECT ••• 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") LEFT OUTER JOIN "lego_inventory" ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id") LEFT OUTER JOIN "lego_setphoto" ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id") LEFT OUTER JOIN "lego_baseset" T9 ON ("lego_setphoto"."set_id" = T9."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" T13 ON ("lego_moc"."parent_set_1_id" = T13."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 312876) ORDER BY "lego_baseset"."added_dt" DESC |
11.58 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(809) mocs = sort_user_mocs(request, mocs, default_sort_by=MocSorter.added.value, default_sort_dir='D') /home/nathan/rb/site/./lego/filters.py in sort_user_mocs(1552) return MocSorter.sort_user_sets(user_sets, sort_by, sort_dir, group_by=group_by, group_by_db=group_by_db, apply_limit=apply_limit) /home/nathan/rb/site/./lego/constants/mocs.py in sort_user_sets(133) return list(sets.order_by(*order_by_fields)) |
|||||||||||||||||||||
|
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
"taggit_tag"."id", "taggit_tag"."name", "taggit_tag"."slug" FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (53251, 77841, 178199, 178201, 178203, 67616, 67618, 67619, 147495, 75815, 49197, 151599, 63548, 47164, 61503, 79936, 243785, 45137, 45138, 45139, 243797, 75865, 180315, 151643, 90204, 190567, 190568, 190573, 190585, 190586, 178297, 69755, 69754, 57465, 69760, 75912, 127127, 61599, 256163, 256166, 59558, 256168, 256169, 256170, 67757, 123061, 69814, 92346, 65724, 151750, 245963, 63691, 45262, 63697, 243922, 84179, 84178, 243925, 252125, 116961, 243948, 153843, 69878, 127228, 78098, 151827, 65821, 147742, 182563, 74030, 74032, 49458, 49459, 196923, 196924, 190781, 80192, 65860, 80237, 61806, 74108, 196999, 299402, 299405, 76174, 301455, 299409, 178578, 151974, 49577, 47533, 72122, 92606, 68035, 68036, 195025, 195027, 149973, 47576, 139738, 76252, 68060, 78310, 244200, 45549, 74234, 64009, 258571, 68123, 70178, 90671, 72246, 246341, 66120, 88655, 68213, 49782, 49783, 76415, 76416, 139917, 47766, 309912, 62117, 92842, 92843, 49856, 90820, 154324, 150230, 47843, 80615, 74472, 74473, 183018, 76532, 178933, 178934, 82686, 64260, 140037, 86794, 60178, 178965, 80662, 60183, 178968, 95001, 95000, 252699, 76569, 47900, 84768, 86837, 152377, 76607, 117569, 252742, 54091, 154444, 183118, 183119, 179024, 181074, 74579, 74580, 181079, 72538, 117595, 131932, 248687, 166768, 166767, 68471, 82811, 123787, 95131, 148387, 150444, 179123, 76730, 66490, 211905, 76737, 244675, 89029, 244678, 60368, 58324, 82912, 48115, 48120, 62460, 60412, 95231, 254978, 78878, 66596, 46119, 160808, 252969, 46120, 97329, 60479, 252995, 244803, 48202, 46164, 181337, 148585, 150644, 130165, 246915, 246916, 91272, 197769, 197770, 197772, 76942, 95379, 48276, 150677, 150687, 64675, 122021, 46246, 81069, 249008, 76984, 52411, 93373, 95422, 70848, 183492, 66758, 62666, 300237, 193743, 66781, 169184, 247013, 214245, 46315, 64751, 79089, 48382, 62731, 181519, 48402, 77075, 46364, 152862, 97585, 245048, 245049, 181561, 197962, 197963, 89429, 45048, 181607, 60775, 56688, 304498, 56691, 48501, 304502, 97662, 77192, 79246, 46479, 64944, 64953, 46527, 87497, 87500, 150989, 249298, 99838, 181764, 52746, 46610, 171541, 171542, 171544, 171546, 171547, 171548, 171550, 171551, 60968, 54842, 48705, 48707, 79431, 151113, 83529, 46667, 190030, 120399, 120400, 120401, 120398, 54875, 155232, 179812, 138854, 138855, 79470, 87663, 87665, 67187, 302709, 67189, 67192, 46720, 116354, 116355, 93826, 67206, 253589, 167581, 59048, 247471, 48819, 61111, 259769, 245434, 245433, 151240, 116429, 67313, 253686, 169722, 169723, 48890, 46876, 87838, 155424, 83744, 48940, 249651, 151347, 300862, 300867, 153415, 63304, 53063, 48967, 300876, 85836, 55117, 251735, 302940, 104298, 130939, 87945, 77711, 44954, 59294, 49056, 137136, 137139, 255929, 63426, 104392, 63434, 243661, 243662, 243664, 180177, 47058, 180179, 188372, 188373, 243670, 153558, 243678, 243679, 85989, 49135, 153589, 45046, 90104, 90105))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 (53251, 77841, 178199, 178201, 178203, 67616, 67618, 67619, 147495, 75815, 49197, 151599, 63548, 47164, 61503, 79936, 243785, 45137, 45138, 45139, 243797, 75865, 180315, 151643, 90204, 190567, 190568, 190573, 190585, 190586, 178297, 69755, 69754, 57465, 69760, 75912, 127127, 61599, 256163, 256166, 59558, 256168, 256169, 256170, 67757, 123061, 69814, 92346, 65724, 151750, 245963, 63691, 45262, 63697, 243922, 84179, 84178, 243925, 252125, 116961, 243948, 153843, 69878, 127228, 78098, 151827, 65821, 147742, 182563, 74030, 74032, 49458, 49459, 196923, 196924, 190781, 80192, 65860, 80237, 61806, 74108, 196999, 299402, 299405, 76174, 301455, 299409, 178578, 151974, 49577, 47533, 72122, 92606, 68035, 68036, 195025, 195027, 149973, 47576, 139738, 76252, 68060, 78310, 244200, 45549, 74234, 64009, 258571, 68123, 70178, 90671, 72246, 246341, 66120, 88655, 68213, 49782, 49783, 76415, 76416, 139917, 47766, 309912, 62117, 92842, 92843, 49856, 90820, 154324, 150230, 47843, 80615, 74472, 74473, 183018, 76532, 178933, 178934, 82686, 64260, 140037, 86794, 60178, 178965, 80662, 60183, 178968, 95001, 95000, 252699, 76569, 47900, 84768, 86837, 152377, 76607, 117569, 252742, 54091, 154444, 183118, 183119, 179024, 181074, 74579, 74580, 181079, 72538, 117595, 131932, 248687, 166768, 166767, 68471, 82811, 123787, 95131, 148387, 150444, 179123, 76730, 66490, 211905, 76737, 244675, 89029, 244678, 60368, 58324, 82912, 48115, 48120, 62460, 60412, 95231, 254978, 78878, 66596, 46119, 160808, 252969, 46120, 97329, 60479, 252995, 244803, 48202, 46164, 181337, 148585, 150644, 130165, 246915, 246916, 91272, 197769, 197770, 197772, 76942, 95379, 48276, 150677, 150687, 64675, 122021, 46246, 81069, 249008, 76984, 52411, 93373, 95422, 70848, 183492, 66758, 62666, 300237, 193743, 66781, 169184, 247013, 214245, 46315, 64751, 79089, 48382, 62731, 181519, 48402, 77075, 46364, 152862, 97585, 245048, 245049, 181561, 197962, 197963, 89429, 45048, 181607, 60775, 56688, 304498, 56691, 48501, 304502, 97662, 77192, 79246, 46479, 64944, 64953, 46527, 87497, 87500, 150989, 249298, 99838, 181764, 52746, 46610, 171541, 171542, 171544, 171546, 171547, 171548, 171550, 171551, 60968, 54842, 48705, 48707, 79431, 151113, 83529, 46667, 190030, 120399, 120400, 120401, 120398, 54875, 155232, 179812, 138854, 138855, 79470, 87663, 87665, 67187, 302709, 67189, 67192, 46720, 116354, 116355, 93826, 67206, 253589, 167581, 59048, 247471, 48819, 61111, 259769, 245434, 245433, 151240, 116429, 67313, 253686, 169722, 169723, 48890, 46876, 87838, 155424, 83744, 48940, 249651, 151347, 300862, 300867, 153415, 63304, 53063, 48967, 300876, 85836, 55117, 251735, 302940, 104298, 130939, 87945, 77711, 44954, 59294, 49056, 137136, 137139, 255929, 63426, 104392, 63434, 243661, 243662, 243664, 180177, 47058, 180179, 188372, 188373, 243670, 153558, 243678, 243679, 85989, 49135, 153589, 45046, 90104, 90105)) |
3.59 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(817) prefetch_related_objects(mocs, 'tags') |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_moc"."baseset_ptr_id", "lego_moc"."designer_id", "lego_moc"."detail_url", "lego_moc"."gallery_url", "lego_moc"."bi_url", "lego_moc"."cad_url", "lego_moc"."video", "lego_moc"."bi_type", "lego_moc"."is_for_sale", "lego_moc"."is_hosted", "lego_moc"."cost", "lego_moc"."currency_id", "lego_moc"."parent_set_1_id", "lego_moc"."parent_set_2_id", "lego_moc"."parent_set_3_id", "lego_moc"."parent_set_4_id", "lego_moc"."parent_set_5_id", "lego_moc"."parent_inv_1_id", "lego_moc"."parent_inv_2_id", "lego_moc"."parent_inv_3_id", "lego_moc"."parent_inv_4_id", "lego_moc"."parent_inv_5_id", "lego_moc"."parent_type", "lego_moc"."is_allowed_premium", "lego_moc"."is_locked", "lego_moc"."last_social_post", "lego_moc"."is_review_requested", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T5."id", T5."parent_id", T5."name", T5."slug", T5."set_count", T5."t1_id", T5."t1_name", T5."t2_name", T5."t3_name", T5."lego_blurb", T5."banner_img", T5."descr", T6."id", T6."parent_id", T6."name", T6."slug", T6."set_count", T6."t1_id", T6."t1_name", T6."t2_name", T6."t3_name", T6."lego_blurb", T6."banner_img", T6."descr", "lego_inventory"."id", "lego_inventory"."set_id", "lego_inventory"."version", "lego_inventory"."name", "lego_inventory"."is_active", "lego_inventory"."num_parts", "lego_inventory"."num_versions", "lego_setphoto"."id", "lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary", T9."id", T9."set_num", T9."name", T9."year", T9."theme_id", T9."set_type", T9."num_parts", T9."default_inventory_id", T9."is_active", T9."is_accessory", T9."added_dt", T9."added_by_id", T9."last_modified_dt", T9."last_modified_by_id", T9."last_checked_for_bi", T9."descr", T9."primary_photo_id", T9."is_gear", T9."is_book", T9."search_vector", T9."mfhash_vector", "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", T13."id", T13."set_num", T13."name", T13."year", T13."theme_id", T13."set_type", T13."num_parts", T13."default_inventory_id", T13."is_active", T13."is_accessory", T13."added_dt", T13."added_by_id", T13."last_modified_dt", T13."last_modified_by_id", T13."last_checked_for_bi", T13."descr", T13."primary_photo_id", T13."is_gear", T13."is_book", T13."search_vector", T13."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") LEFT OUTER JOIN "lego_inventory" ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id") LEFT OUTER JOIN "lego_setphoto" ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id") LEFT OUTER JOIN "lego_baseset" T9 ON ("lego_setphoto"."set_id" = T9."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" T13 ON ("lego_moc"."parent_set_1_id" = T13."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 312876)SELECT ••• 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") LEFT OUTER JOIN "lego_inventory" ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id") LEFT OUTER JOIN "lego_setphoto" ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id") LEFT OUTER JOIN "lego_baseset" T9 ON ("lego_setphoto"."set_id" = T9."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" T13 ON ("lego_moc"."parent_set_1_id" = T13."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 312876) |
9.61 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(818) drill_downs = get_set_drill_downs(mocs, request.GET, all_items=all_mocs) /home/nathan/rb/site/./lego/filters.py in get_set_drill_downs(1267) fields['Themes'] = get_theme_drill_down(sets, params=params, all_items=all_items) /home/nathan/rb/site/./lego/filters.py in get_theme_drill_down(1069) drill_down = get_drill_down(items, params, 'theme', filter_fn, all_items=all_items) /home/nathan/rb/site/./lego/filters.py in get_drill_down(958) for item in all_items: |
|||||||||||||||||||||
|
SELECT SUM("lego_setstatstotal"."likes") AS "likes__sum"
2 similar queries.
Duplicated 2 times.
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" = 312876) )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" = 312876)) |
1.90 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(836) designer_stats = designer.get_stats() /home/nathan/rb/site/./lego/models/designers.py in get_stats(79) num_likes = SetStatsTotal.objects.filter(set__in=Moc.objects.filter(designer=self)).aggregate(Sum('likes'))['likes__sum'] or 0 |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 312876SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 312876 |
10.44 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(836) designer_stats = designer.get_stats() /home/nathan/rb/site/./lego/models/designers.py in get_stats(82) 'num_followers': self.get_num_followers_formatted(), /home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(231) i = DesignerFollower.objects.filter(designer_id=self.id).count() |
|||||||||||||||||||||
|
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" = 312876 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 312876 LIMIT 21 |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(848) designer_ga_tracking_id = designer.get_ga_tracking_id() /home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(88) if self.plan.is_designer(): /usr/lib/python3.10/contextlib.py in inner(79) return func(*args, **kwds) /home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36) .__get__(instance, instance_type) |
|||||||||||||||||||||
|
SELECT "plans_plan"."id",
2 similar queries.
Duplicated 2 times.
"plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(848) designer_ga_tracking_id = designer.get_ga_tracking_id() /home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(88) if self.plan.is_designer(): /home/nathan/rb/site/./accounts/models/users.py in is_designer(381) return self.plan.is_designer() |
|||||||||||||||||||||
|
SELECT "lego_designerdiscount"."id",
"lego_designerdiscount"."designer_id", "lego_designerdiscount"."name", "lego_designerdiscount"."start_date", "lego_designerdiscount"."end_date", "lego_designerdiscount"."discount_pct", "lego_designerdiscount"."mocs" FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T06:31:51.190852+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:31:51.190850+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['309912', '304502', '304498', '302940', '302709', '301455', '300876', '300867', '300862', '300237', '299409', '299405', '299402', '259769', '258571', '256170', '256169', '256168', '256166', '256163', '255929', '254978', '253686', '253589', '252995', '252969', '252742', '252699', '252125', '251735', '249651', '249298', '249008', '248687', '247471', '247013', '246916', '246915', '246341', '245963', '245434', '245433', '245049', '245048', '244803', '244678', '244675', '244200', '243948', '243925']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T06:31:51.190852+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:31:51.190850+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['309912', '304502', '304498', '302940', '302709', '301455', '300876', '300867', '300862', '300237', '299409', '299405', '299402', '259769', '258571', '256170', '256169', '256168', '256166', '256163', '255929', '254978', '253686', '253589', '252995', '252969', '252742', '252699', '252125', '251735', '249651', '249298', '249008', '248687', '247471', '247013', '246916', '246915', '246341', '245963', '245434', '245433', '245049', '245048', '244803', '244678', '244675', '244200', '243948', '243925']]::jsonb[]))) |
1.95 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(855) Moc.attach_discount_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_discount_to_mocs(1531) for discount in discounts: |
|||||||||||||||||||||
|
SELECT "lego_mocswitherrors"."moc_id"
FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" IN (309912, 304502, 304498, 302940, 302709, 301455, 300876, 300867, 300862, 300237, 299409, 299405, 299402, 259769, 258571, 256170, 256169, 256168, 256166, 256163, 255929, 254978, 253686, 253589, 252995, 252969, 252742, 252699, 252125, 251735, 249651, 249298, 249008, 248687, 247471, 247013, 246916, 246915, 246341, 245963, 245434, 245433, 245049, 245048, 244803, 244678, 244675, 244200, 243948, 243925)SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" IN (309912, 304502, 304498, 302940, 302709, 301455, 300876, 300867, 300862, 300237, 299409, 299405, 299402, 259769, 258571, 256170, 256169, 256168, 256166, 256163, 255929, 254978, 253686, 253589, 252995, 252969, 252742, 252699, 252125, 251735, 249651, 249298, 249008, 248687, 247471, 247013, 246916, 246915, 246341, 245963, 245434, 245433, 245049, 245048, 244803, 244678, 244675, 244200, 243948, 243925) |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(856) Moc.attach_alternate_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_alternate_to_mocs(1568) errors = set(errors) |
|||||||||||||||||||||
|
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.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.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.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20) geo_data = user.geo.get_user_currency() /home/nathan/rb/site/./geo/geo.py in get_user_currency(252) country = Country.objects.get(iso=country_code)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 312876) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 312876) LIMIT 21 |
0.35 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263) options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
2 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 312876 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 312876 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.23 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.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 "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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 312876 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 312876 LIMIT 21 |
0.30 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
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" = 312876) 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" = 312876) LIMIT 1 |
0.25 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "plans_plan"."id",
2 similar queries.
Duplicated 2 times.
"plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.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" = 312876 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 312876 LIMIT 21 |
0.29 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.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" = 414773 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 414773 LIMIT 21 |
0.26 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "lego_badge"."id",
"lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."id" = 3 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 3 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 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" = 312876)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" = 312876) |
1.06 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_num_mocs(866) self._num_mocs = Moc.objects.filter(designer=self.designer).count()
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT SUM("lego_setstatstotal"."likes") AS "likes__sum"
2 similar queries.
Duplicated 2 times.
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" = 312876) )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" = 312876)) |
1.48 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./lego/models/designers.py in get_stats(79) num_likes = SetStatsTotal.objects.filter(set__in=Moc.objects.filter(designer=self)).aggregate(Sum('likes'))['likes__sum'] or 0
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 312876SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 312876 |
0.46 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./lego/models/designers.py in get_stats(82) 'num_followers': self.get_num_followers_formatted(), /home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(231) i = DesignerFollower.objects.filter(designer_id=self.id).count()
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
2 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 312876 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 312876 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.25 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877) return render(request, 'accounts/user_mocs.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 |
|||||||||||||||||||||
No messages logged.