| Resource | Value |
|---|---|
| User CPU time | 507.282 msec |
| System CPU time | 6.913 msec |
| Total CPU time | 514.195 msec |
| Elapsed time | 598.183 msec |
| Context switches | 472 voluntary, 12 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('ilyabuilder724')) 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('ilyabuilder724')) LIMIT 21 |
0.62 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(799) 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 (66302)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 (66302) |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(799) 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('ilyabuilder724') 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('ilyabuilder724') LIMIT 21 |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(816) designer = Designer.objects.get_or_none(username__iexact=username) /home/nathan/rb/site/./rb/utils.py in get_or_none(734) 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" = 66302)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" = 66302) |
2.37 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(839) 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"."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", "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."active_change_dt", T9."active_change_by_id", T9."last_checked_for_bi", T9."descr", T9."primary_photo_id", T9."primary_moc_image_id", T9."is_gear", T9."is_book", T9."search_vector", T9."mfhash_vector", "lego_mocimage"."id", "lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension", "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", T14."id", T14."set_num", T14."name", T14."year", T14."theme_id", T14."set_type", T14."num_parts", T14."default_inventory_id", T14."is_active", T14."is_accessory", T14."added_dt", T14."added_by_id", T14."last_modified_dt", T14."last_modified_by_id", T14."active_change_dt", T14."active_change_by_id", T14."last_checked_for_bi", T14."descr", T14."primary_photo_id", T14."primary_moc_image_id", T14."is_gear", T14."is_book", T14."search_vector", T14."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") LEFT OUTER JOIN "lego_mocimage" ON ("lego_baseset"."primary_moc_image_id" = "lego_mocimage"."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" T14 ON ("lego_moc"."parent_set_1_id" = T14."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 66302) 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") LEFT OUTER JOIN "lego_mocimage" ON ("lego_baseset"."primary_moc_image_id" = "lego_mocimage"."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" T14 ON ("lego_moc"."parent_set_1_id" = T14."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 66302) ORDER BY "lego_baseset"."added_dt" DESC |
37.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(845) 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(1570) 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 (141316, 120838, 59423, 241697, 231457, 165926, 327723, 215083, 149551, 86068, 69687, 204861, 198728, 182344, 276559, 61519, 88155, 116828, 342118, 176233, 237676, 104560, 186481, 278647, 147576, 206970, 184446, 260230, 346251, 133259, 170125, 71821, 190615, 209055, 284833, 164002, 346279, 221357, 219310, 129202, 329915, 248009, 178380, 20685, 118993, 45267, 94434, 245994, 211180, 80140, 110866, 84258, 168227, 203046, 358708, 162109, 192838, 16711, 16712, 16710, 196946, 20821, 180568, 47466, 350573, 172398, 145779, 108922, 289147, 262527, 102791, 336264, 153998, 250256, 360859, 31138, 135590, 131494, 254379, 309676, 139693, 213433, 244154, 352705, 115145, 80330, 16841, 16844, 16842, 158158, 43470, 18896, 18897, 16858, 16859, 29149, 29150, 233955, 113135, 152048, 231925, 305670, 16909, 18959, 18960, 23066, 23067, 117276, 160286, 166456, 16953, 16952, 217659, 19004, 19003, 301632, 102981, 156232, 311889, 307798, 121433, 43609, 43611, 332385, 178794, 338542, 84591, 322158, 266865, 78461, 23165, 176767, 242306, 17029, 17032, 320138, 297617, 19092, 287387, 144030, 76446, 256678, 146095, 223920, 211632, 141999, 99006, 123585, 17092, 17093, 19147, 19148, 189135, 150223, 187089, 324306, 17106, 94935, 303832, 291544, 113370, 355035, 355036, 17113, 293598, 236254, 17112, 281324, 21229, 215806, 135945, 283409, 45844, 127767, 17176, 17177, 344871, 25385, 271151, 195375, 82740, 160567, 348984, 148279, 299852, 275279, 316243, 228189, 121695, 111477, 230263, 334714, 170875, 226176, 19334, 19335, 131978, 174989, 48035, 48037, 48038, 48039, 48040, 19366, 240558, 220080, 113585, 318392, 185277, 164804, 78788, 199634, 158676, 173031, 191470, 248822, 19463, 130056, 168972, 70672, 295971, 357416, 259117, 62519, 279610, 138299, 123970, 42051, 23618, 234566, 140364, 328785, 101458, 107605, 154730, 31857, 193650, 189555, 181364, 40063, 117889, 134276, 83076, 205959, 99477, 238747, 224417, 246953, 212140, 197810, 95417, 208063, 156868, 337094, 48329, 48330, 48331, 179404, 120013, 48333, 48332, 19659, 46298, 314604, 167152, 72944, 152819, 113929, 163089, 326954, 144685, 116013, 36160, 263494, 77126, 95560, 120138, 187724, 245075, 161113, 150878, 173413, 56689, 210291, 19832, 44411, 87425, 148871, 220554, 52620, 23951, 169371, 42395, 99742, 236963, 214443, 359853, 165294, 320960, 232902, 194002, 89561, 204250, 69095, 249321, 265709, 146925, 101875, 142837, 355832, 347641, 278014, 189952, 69126, 343560, 114189, 316953, 255522, 73255, 243249, 110132, 175669, 218684, 144960, 110144, 63042, 95813, 22087, 181837, 196174, 128590, 267868, 202339, 325232, 261744, 24190, 323200, 93825, 300675, 118404, 331408, 306832, 290453, 288405, 333465, 216734, 38568, 130729, 302764, 73388, 171694, 26286, 20152, 229053, 163519, 112319, 282306, 24263, 136910, 294611, 270038, 235222, 106200, 222961, 28401, 292597, 71435, 139024, 42770, 341780, 167702, 210722, 153380, 304937, 257836, 274224, 180023, 77624, 173887, 313159, 177994, 83794, 227155, 192341, 159599, 339824, 151409, 44922, 116605, 124801, 298886, 272270, 22415, 22414, 225170, 161695, 221098, 325558, 16310, 114622, 22463, 309187, 135111, 75720, 16328, 16330, 16331, 296908, 16332, 16335, 16338, 268245, 143319, 24542, 194528, 188384, 24544, 110584, 155642))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 (141316, 120838, 59423, 241697, 231457, 165926, 327723, 215083, 149551, 86068, 69687, 204861, 198728, 182344, 276559, 61519, 88155, 116828, 342118, 176233, 237676, 104560, 186481, 278647, 147576, 206970, 184446, 260230, 346251, 133259, 170125, 71821, 190615, 209055, 284833, 164002, 346279, 221357, 219310, 129202, 329915, 248009, 178380, 20685, 118993, 45267, 94434, 245994, 211180, 80140, 110866, 84258, 168227, 203046, 358708, 162109, 192838, 16711, 16712, 16710, 196946, 20821, 180568, 47466, 350573, 172398, 145779, 108922, 289147, 262527, 102791, 336264, 153998, 250256, 360859, 31138, 135590, 131494, 254379, 309676, 139693, 213433, 244154, 352705, 115145, 80330, 16841, 16844, 16842, 158158, 43470, 18896, 18897, 16858, 16859, 29149, 29150, 233955, 113135, 152048, 231925, 305670, 16909, 18959, 18960, 23066, 23067, 117276, 160286, 166456, 16953, 16952, 217659, 19004, 19003, 301632, 102981, 156232, 311889, 307798, 121433, 43609, 43611, 332385, 178794, 338542, 84591, 322158, 266865, 78461, 23165, 176767, 242306, 17029, 17032, 320138, 297617, 19092, 287387, 144030, 76446, 256678, 146095, 223920, 211632, 141999, 99006, 123585, 17092, 17093, 19147, 19148, 189135, 150223, 187089, 324306, 17106, 94935, 303832, 291544, 113370, 355035, 355036, 17113, 293598, 236254, 17112, 281324, 21229, 215806, 135945, 283409, 45844, 127767, 17176, 17177, 344871, 25385, 271151, 195375, 82740, 160567, 348984, 148279, 299852, 275279, 316243, 228189, 121695, 111477, 230263, 334714, 170875, 226176, 19334, 19335, 131978, 174989, 48035, 48037, 48038, 48039, 48040, 19366, 240558, 220080, 113585, 318392, 185277, 164804, 78788, 199634, 158676, 173031, 191470, 248822, 19463, 130056, 168972, 70672, 295971, 357416, 259117, 62519, 279610, 138299, 123970, 42051, 23618, 234566, 140364, 328785, 101458, 107605, 154730, 31857, 193650, 189555, 181364, 40063, 117889, 134276, 83076, 205959, 99477, 238747, 224417, 246953, 212140, 197810, 95417, 208063, 156868, 337094, 48329, 48330, 48331, 179404, 120013, 48333, 48332, 19659, 46298, 314604, 167152, 72944, 152819, 113929, 163089, 326954, 144685, 116013, 36160, 263494, 77126, 95560, 120138, 187724, 245075, 161113, 150878, 173413, 56689, 210291, 19832, 44411, 87425, 148871, 220554, 52620, 23951, 169371, 42395, 99742, 236963, 214443, 359853, 165294, 320960, 232902, 194002, 89561, 204250, 69095, 249321, 265709, 146925, 101875, 142837, 355832, 347641, 278014, 189952, 69126, 343560, 114189, 316953, 255522, 73255, 243249, 110132, 175669, 218684, 144960, 110144, 63042, 95813, 22087, 181837, 196174, 128590, 267868, 202339, 325232, 261744, 24190, 323200, 93825, 300675, 118404, 331408, 306832, 290453, 288405, 333465, 216734, 38568, 130729, 302764, 73388, 171694, 26286, 20152, 229053, 163519, 112319, 282306, 24263, 136910, 294611, 270038, 235222, 106200, 222961, 28401, 292597, 71435, 139024, 42770, 341780, 167702, 210722, 153380, 304937, 257836, 274224, 180023, 77624, 173887, 313159, 177994, 83794, 227155, 192341, 159599, 339824, 151409, 44922, 116605, 124801, 298886, 272270, 22415, 22414, 225170, 161695, 221098, 325558, 16310, 114622, 22463, 309187, 135111, 75720, 16328, 16330, 16331, 296908, 16332, 16335, 16338, 268245, 143319, 24542, 194528, 188384, 24544, 110584, 155642)) |
16.47 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(853) 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"."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", "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."active_change_dt", T9."active_change_by_id", T9."last_checked_for_bi", T9."descr", T9."primary_photo_id", T9."primary_moc_image_id", T9."is_gear", T9."is_book", T9."search_vector", T9."mfhash_vector", "lego_mocimage"."id", "lego_mocimage"."moc_id", "lego_mocimage"."is_primary", "lego_mocimage"."file_extension", "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", T14."id", T14."set_num", T14."name", T14."year", T14."theme_id", T14."set_type", T14."num_parts", T14."default_inventory_id", T14."is_active", T14."is_accessory", T14."added_dt", T14."added_by_id", T14."last_modified_dt", T14."last_modified_by_id", T14."active_change_dt", T14."active_change_by_id", T14."last_checked_for_bi", T14."descr", T14."primary_photo_id", T14."primary_moc_image_id", T14."is_gear", T14."is_book", T14."search_vector", T14."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") LEFT OUTER JOIN "lego_mocimage" ON ("lego_baseset"."primary_moc_image_id" = "lego_mocimage"."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" T14 ON ("lego_moc"."parent_set_1_id" = T14."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 66302)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") LEFT OUTER JOIN "lego_mocimage" ON ("lego_baseset"."primary_moc_image_id" = "lego_mocimage"."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" T14 ON ("lego_moc"."parent_set_1_id" = T14."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 66302) |
10.59 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(854) 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(1285) 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(1087) 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(976) 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" = 66302) )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" = 66302)) |
2.39 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(872) designer_stats = designer.get_stats() /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 |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 66302SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 66302 |
0.25 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(872) designer_stats = designer.get_stats() /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() |
|||||||||||||||||||||
|
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" = 66302 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 66302 LIMIT 21 |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(884) designer_ga_tracking_id = 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" = 2 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(884) designer_ga_tracking_id = 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 "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:00:09.095950+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:00:09.095947+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['360859', '359853', '358708', '357416', '355036', '355832', '355035', '352705', '350573', '348984', '347641', '346279', '346251', '344871', '343560', '342118', '341780', '339824', '338542', '337094', '336264', '334714', '333465', '332385', '331408', '329915', '328785', '327723', '326954', '325558', '325232', '324306', '323200', '322158', '320960', '320138', '318392', '316953', '316243', '314604', '313159', '311889', '309676', '309187', '307798', '306832', '305670', '304937', '303832', '302764']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-11-16T00:00:09.095950+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:00:09.095947+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['360859', '359853', '358708', '357416', '355036', '355832', '355035', '352705', '350573', '348984', '347641', '346279', '346251', '344871', '343560', '342118', '341780', '339824', '338542', '337094', '336264', '334714', '333465', '332385', '331408', '329915', '328785', '327723', '326954', '325558', '325232', '324306', '323200', '322158', '320960', '320138', '318392', '316953', '316243', '314604', '313159', '311889', '309676', '309187', '307798', '306832', '305670', '304937', '303832', '302764']]::jsonb[]))) |
1.89 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(891) 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 "lego_mocswitherrors"."moc_id" AS "moc_id"
FROM "lego_mocswitherrors" WHERE ("lego_mocswitherrors"."error_type" = 'inventory' AND "lego_mocswitherrors"."moc_id" IN (360859, 359853, 358708, 357416, 355036, 355832, 355035, 352705, 350573, 348984, 347641, 346279, 344871, 343560, 342118, 339824, 338542, 337094, 336264, 334714, 333465, 332385, 331408, 329915, 328785, 327723, 326954, 325558, 324306, 323200, 322158, 320960, 320138, 318392, 316953, 314604, 313159, 311889, 309676, 309187, 307798, 306832, 305670, 304937, 303832))SELECT ••• FROM "lego_mocswitherrors" WHERE ("lego_mocswitherrors"."error_type" = 'inventory' AND "lego_mocswitherrors"."moc_id" IN (360859, 359853, 358708, 357416, 355036, 355832, 355035, 352705, 350573, 348984, 347641, 346279, 344871, 343560, 342118, 339824, 338542, 337094, 336264, 334714, 333465, 332385, 331408, 329915, 328785, 327723, 326954, 325558, 324306, 323200, 322158, 320960, 320138, 318392, 316953, 314604, 313159, 311889, 309676, 309187, 307798, 306832, 305670, 304937, 303832)) |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(892) Moc.attach_alternate_to_mocs(mocs) /home/nathan/rb/site/./lego/models/sets.py in attach_alternate_to_mocs(1619) errors = set(errors) |
|||||||||||||||||||||
|
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.28 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) 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(253) country = Country.objects.get(iso=country_code)
/home/nathan/rb/site/rb/templates/rb/includes/topbar.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" = 66302) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 66302) LIMIT 21 |
0.23 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) return render(request, 'accounts/user_mocs.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",
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" = 66302 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 66302 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.26 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) 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" = 66302 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 66302 LIMIT 21 |
0.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) return render(request, 'accounts/user_mocs.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 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" = 66302) 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" = 66302) LIMIT 1 |
0.25 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) return render(request, 'accounts/user_mocs.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 "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" = 66302 LIMIT 21SELECT ••• FROM "accounts_userstats" WHERE "accounts_userstats"."user_id" = 66302 LIMIT 21 |
0.31 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) return render(request, 'accounts/user_mocs.html', context) /home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396) return self.stats.get_num_parts_summary() /usr/lib/python3.10/contextlib.py in inner(79) return func(*args, **kwds) /home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36) .__get__(instance, instance_type)
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "plans_plan"."id",
2 similar queries.
Duplicated 2 times.
"plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) 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" = 66302 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 66302 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) 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" = 431135 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 431135 LIMIT 21 |
0.31 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) 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.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) 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" = 66302)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" = 66302) |
1.26 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) return render(request, 'accounts/user_mocs.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"
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" = 66302) )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" = 66302)) |
1.69 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) return render(request, 'accounts/user_mocs.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"
2 similar queries.
Duplicated 2 times.
FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 66302SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 66302 |
0.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) return render(request, 'accounts/user_mocs.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 "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" = 66302 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 66302 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./accounts/views/profile.py in user_mocs(913) 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.