| Resource | Value |
|---|---|
| User CPU time | 862.945 msec |
| System CPU time | 16.039 msec |
| Total CPU time | 878.984 msec |
| Elapsed time | 981.097 msec |
| Context switches | 541 voluntary, 190 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('meregt')) 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('meregt')) LIMIT 21 |
8.87 | ||||||||||||||||||||
|
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 (129468)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 (129468) |
0.24 | ||||||||||||||||||||
|
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('meregt') 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('meregt') LIMIT 21 |
0.30 | ||||||||||||||||||||
|
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" = 129468)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" = 129468) |
3.87 | ||||||||||||||||||||
|
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" = 129468) 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" = 129468) ORDER BY "lego_baseset"."added_dt" DESC |
30.17 | ||||||||||||||||||||
|
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 (110592, 110593, 110594, 110596, 110597, 102413, 102414, 233492, 174100, 112663, 112664, 284697, 280608, 280609, 90147, 75816, 75817, 145450, 75818, 145452, 73772, 73771, 73769, 43158, 290870, 176182, 290872, 112697, 112698, 112701, 43160, 110659, 223300, 110661, 110662, 110663, 110664, 108623, 108624, 139345, 139346, 108627, 108626, 108625, 88150, 88149, 69715, 59480, 129122, 129123, 159844, 159845, 186470, 180330, 180331, 180332, 77931, 77930, 118899, 118900, 106613, 106614, 106615, 106611, 73849, 73850, 73848, 92285, 65667, 194692, 47236, 194695, 41100, 61585, 49302, 43159, 176280, 176281, 110746, 176282, 176283, 43161, 110750, 110751, 110752, 110753, 71849, 71850, 135340, 135341, 135342, 127152, 108722, 80052, 266425, 45247, 45248, 118987, 118988, 84172, 112848, 112849, 88285, 159966, 159967, 76006, 100610, 100611, 84229, 190733, 190734, 133404, 106781, 106782, 106784, 106785, 192802, 192804, 192806, 82215, 182595, 90435, 182597, 182598, 137547, 129360, 221521, 55634, 287059, 287060, 186710, 47447, 47449, 110946, 110947, 110948, 110949, 110950, 156007, 156008, 174441, 88420, 88419, 78188, 125293, 49509, 104818, 108915, 108916, 104821, 108918, 104820, 108920, 108921, 104819, 102783, 102785, 102786, 188824, 188825, 188827, 47515, 47517, 72097, 78248, 145843, 145845, 113080, 113084, 213437, 111038, 113086, 113085, 111041, 111042, 111040, 111039, 152009, 152010, 227788, 88537, 88538, 98782, 98783, 78303, 96743, 53736, 53737, 96746, 53738, 137709, 109038, 109037, 109040, 109041, 109042, 74223, 74222, 74221, 66035, 66039, 66040, 66033, 295431, 295432, 111112, 111114, 111115, 111116, 111113, 41624, 137744, 41625, 49693, 270879, 68128, 68129, 68130, 43555, 43556, 43557, 43558, 74279, 43560, 74281, 43554, 74283, 41517, 86579, 86580, 41525, 70208, 47689, 47690, 207440, 207441, 135761, 88657, 133723, 84571, 66143, 66145, 72290, 72291, 178793, 49770, 39529, 238189, 109166, 109168, 109169, 109170, 109171, 98941, 103038, 98942, 103040, 103042, 103043, 45711, 191128, 191129, 123545, 41626, 41628, 41629, 101022, 41631, 101024, 41632, 86690, 86691, 115364, 49827, 49826, 76455, 60073, 47790, 74425, 74426, 74427, 47804, 45757, 45758, 45759, 105152, 105153, 105154, 105155, 84675, 76482, 76481, 47814, 109256, 47817, 109258, 109260, 109261, 109262, 96972, 178905, 88798, 160480, 211698, 94975, 94976, 180996, 146189, 299790, 146190, 308000, 74529, 160546, 76578, 76580, 78629, 76581, 74532, 74531, 86832, 70458, 70460, 70461, 150334, 150335, 72512, 70464, 70463, 111428, 111431, 111432, 111433, 113480, 256842, 170824, 113481, 111436, 70474, 70473, 70472, 80725, 80726, 101215, 101216, 47974, 115559, 76659, 76660, 72565, 72566, 72567, 72568, 74617, 74618, 74619, 72569, 47993, 84863, 84864, 107397, 107398, 107399, 107400, 160660, 160661, 111510, 111511, 111512, 111513, 111514, 109467, 109468, 109466, 123806, 109465, 285600, 109464, 86940, 86939, 41895, 304040, 41896, 185263, 48055, 48056, 76733, 39870, 39871, 224192, 207809, 39872, 39878, 72647, 48078, 99279, 80791, 78801, 78804, 80792, 39894, 39895, 187356, 74717, 74718, 74719, 218085, 39915, 189421, 111597, 189423, 111600, 111601, 111602, 111599, 89075, 89074, 76790, 76789, 115707, 115708, 103424, 103425, 103426, 103427, 39936, 82839, 128020, 76826, 109596, 62492, 109601, 109603, 109604, 85029, 109606, 85031, 195627, 87084, 187437, 87085, 62512, 89165, 89166, 89167, 91223, 91224, 230489, 193626, 91226, 193629, 193631, 275560, 275561, 275562, 111735, 228476, 40061, 40064, 109713, 109714, 109715, 109716, 109717, 101590, 40126, 40131, 283849, 87243, 263373, 107734, 107735, 107736, 107737, 175322, 128218, 163036, 163037, 101592, 101591, 40171, 191724, 191729, 77042, 77043, 77044, 77041, 128249, 109818, 40186, 109820, 109823, 109824, 109825, 111878, 89351, 89352, 89353, 189720, 68894, 68895, 68896, 118059, 118060, 60718, 154936, 154937, 226632, 91470, 91471, 46428, 46429, 191856, 191858, 75136, 75137, 183693, 183695, 58769, 103829, 103830, 112023, 112024, 112025, 103832, 103831, 87452, 87453, 87454, 87451, 247209, 261549, 261550, 40371, 179641, 73146, 83395, 159177, 118218, 159179, 251349, 75226, 110043, 110044, 110045, 110046, 110047, 75228, 79329, 175586, 130530, 161254, 161255, 214512, 46579, 85501, 85502, 85504, 85505, 46593, 40452, 112134, 161287, 161289, 161290, 128522, 222732, 46604, 46602, 73251, 112164, 157221, 157222, 87590, 40488, 40490, 112174, 48733, 89694, 73311, 79459, 79461, 71283, 52855, 73336, 73337, 52858, 52857, 108167, 108168, 108170, 108172, 110221, 110222, 110223, 110224, 110225, 67217, 48784, 75414, 124567, 75415, 243356, 59037, 73379, 40613, 188071, 188072, 73389, 216759, 73403, 83646, 75461, 75462, 161480, 161482, 161483, 48848, 46801, 46803, 46804, 126679, 73433, 46809, 46811, 95964, 284381, 95965, 284383, 46813, 112359, 112361, 122608, 122609, 118514, 118513, 175860, 118512, 48894, 73471, 73474, 73475, 106244, 106245, 106246, 106247, 73476, 71431, 71430, 46853, 41878, 75534, 75535, 75536, 41879, 186130, 108310, 108314, 108315, 108317, 147231, 147233, 114487, 40760, 114490, 102203, 102204, 102202, 48956, 104257, 104258, 104259, 159556, 159557, 104260, 190279, 288584, 190280, 194391, 194393, 175965, 175966, 110431, 132957, 110433, 110434, 112479, 112478, 110436, 110435, 81767, 81768, 89970, 161652, 161654, 161656, 137090, 73603, 73604, 73605, 110471, 110472, 110473, 110474, 110475, 44941, 94099, 94100, 53141, 53148, 75686, 75687, 75688, 73650, 108468, 108469, 108470, 73654, 108472, 73656, 165818, 165821, 63425, 63428, 128966, 79823, 192465, 192466, 79825, 73684, 73682, 73681, 198619, 198620, 198621, 61414, 88041, 88042, 104430, 104431, 104432, 104433, 43553))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 (110592, 110593, 110594, 110596, 110597, 102413, 102414, 233492, 174100, 112663, 112664, 284697, 280608, 280609, 90147, 75816, 75817, 145450, 75818, 145452, 73772, 73771, 73769, 43158, 290870, 176182, 290872, 112697, 112698, 112701, 43160, 110659, 223300, 110661, 110662, 110663, 110664, 108623, 108624, 139345, 139346, 108627, 108626, 108625, 88150, 88149, 69715, 59480, 129122, 129123, 159844, 159845, 186470, 180330, 180331, 180332, 77931, 77930, 118899, 118900, 106613, 106614, 106615, 106611, 73849, 73850, 73848, 92285, 65667, 194692, 47236, 194695, 41100, 61585, 49302, 43159, 176280, 176281, 110746, 176282, 176283, 43161, 110750, 110751, 110752, 110753, 71849, 71850, 135340, 135341, 135342, 127152, 108722, 80052, 266425, 45247, 45248, 118987, 118988, 84172, 112848, 112849, 88285, 159966, 159967, 76006, 100610, 100611, 84229, 190733, 190734, 133404, 106781, 106782, 106784, 106785, 192802, 192804, 192806, 82215, 182595, 90435, 182597, 182598, 137547, 129360, 221521, 55634, 287059, 287060, 186710, 47447, 47449, 110946, 110947, 110948, 110949, 110950, 156007, 156008, 174441, 88420, 88419, 78188, 125293, 49509, 104818, 108915, 108916, 104821, 108918, 104820, 108920, 108921, 104819, 102783, 102785, 102786, 188824, 188825, 188827, 47515, 47517, 72097, 78248, 145843, 145845, 113080, 113084, 213437, 111038, 113086, 113085, 111041, 111042, 111040, 111039, 152009, 152010, 227788, 88537, 88538, 98782, 98783, 78303, 96743, 53736, 53737, 96746, 53738, 137709, 109038, 109037, 109040, 109041, 109042, 74223, 74222, 74221, 66035, 66039, 66040, 66033, 295431, 295432, 111112, 111114, 111115, 111116, 111113, 41624, 137744, 41625, 49693, 270879, 68128, 68129, 68130, 43555, 43556, 43557, 43558, 74279, 43560, 74281, 43554, 74283, 41517, 86579, 86580, 41525, 70208, 47689, 47690, 207440, 207441, 135761, 88657, 133723, 84571, 66143, 66145, 72290, 72291, 178793, 49770, 39529, 238189, 109166, 109168, 109169, 109170, 109171, 98941, 103038, 98942, 103040, 103042, 103043, 45711, 191128, 191129, 123545, 41626, 41628, 41629, 101022, 41631, 101024, 41632, 86690, 86691, 115364, 49827, 49826, 76455, 60073, 47790, 74425, 74426, 74427, 47804, 45757, 45758, 45759, 105152, 105153, 105154, 105155, 84675, 76482, 76481, 47814, 109256, 47817, 109258, 109260, 109261, 109262, 96972, 178905, 88798, 160480, 211698, 94975, 94976, 180996, 146189, 299790, 146190, 308000, 74529, 160546, 76578, 76580, 78629, 76581, 74532, 74531, 86832, 70458, 70460, 70461, 150334, 150335, 72512, 70464, 70463, 111428, 111431, 111432, 111433, 113480, 256842, 170824, 113481, 111436, 70474, 70473, 70472, 80725, 80726, 101215, 101216, 47974, 115559, 76659, 76660, 72565, 72566, 72567, 72568, 74617, 74618, 74619, 72569, 47993, 84863, 84864, 107397, 107398, 107399, 107400, 160660, 160661, 111510, 111511, 111512, 111513, 111514, 109467, 109468, 109466, 123806, 109465, 285600, 109464, 86940, 86939, 41895, 304040, 41896, 185263, 48055, 48056, 76733, 39870, 39871, 224192, 207809, 39872, 39878, 72647, 48078, 99279, 80791, 78801, 78804, 80792, 39894, 39895, 187356, 74717, 74718, 74719, 218085, 39915, 189421, 111597, 189423, 111600, 111601, 111602, 111599, 89075, 89074, 76790, 76789, 115707, 115708, 103424, 103425, 103426, 103427, 39936, 82839, 128020, 76826, 109596, 62492, 109601, 109603, 109604, 85029, 109606, 85031, 195627, 87084, 187437, 87085, 62512, 89165, 89166, 89167, 91223, 91224, 230489, 193626, 91226, 193629, 193631, 275560, 275561, 275562, 111735, 228476, 40061, 40064, 109713, 109714, 109715, 109716, 109717, 101590, 40126, 40131, 283849, 87243, 263373, 107734, 107735, 107736, 107737, 175322, 128218, 163036, 163037, 101592, 101591, 40171, 191724, 191729, 77042, 77043, 77044, 77041, 128249, 109818, 40186, 109820, 109823, 109824, 109825, 111878, 89351, 89352, 89353, 189720, 68894, 68895, 68896, 118059, 118060, 60718, 154936, 154937, 226632, 91470, 91471, 46428, 46429, 191856, 191858, 75136, 75137, 183693, 183695, 58769, 103829, 103830, 112023, 112024, 112025, 103832, 103831, 87452, 87453, 87454, 87451, 247209, 261549, 261550, 40371, 179641, 73146, 83395, 159177, 118218, 159179, 251349, 75226, 110043, 110044, 110045, 110046, 110047, 75228, 79329, 175586, 130530, 161254, 161255, 214512, 46579, 85501, 85502, 85504, 85505, 46593, 40452, 112134, 161287, 161289, 161290, 128522, 222732, 46604, 46602, 73251, 112164, 157221, 157222, 87590, 40488, 40490, 112174, 48733, 89694, 73311, 79459, 79461, 71283, 52855, 73336, 73337, 52858, 52857, 108167, 108168, 108170, 108172, 110221, 110222, 110223, 110224, 110225, 67217, 48784, 75414, 124567, 75415, 243356, 59037, 73379, 40613, 188071, 188072, 73389, 216759, 73403, 83646, 75461, 75462, 161480, 161482, 161483, 48848, 46801, 46803, 46804, 126679, 73433, 46809, 46811, 95964, 284381, 95965, 284383, 46813, 112359, 112361, 122608, 122609, 118514, 118513, 175860, 118512, 48894, 73471, 73474, 73475, 106244, 106245, 106246, 106247, 73476, 71431, 71430, 46853, 41878, 75534, 75535, 75536, 41879, 186130, 108310, 108314, 108315, 108317, 147231, 147233, 114487, 40760, 114490, 102203, 102204, 102202, 48956, 104257, 104258, 104259, 159556, 159557, 104260, 190279, 288584, 190280, 194391, 194393, 175965, 175966, 110431, 132957, 110433, 110434, 112479, 112478, 110436, 110435, 81767, 81768, 89970, 161652, 161654, 161656, 137090, 73603, 73604, 73605, 110471, 110472, 110473, 110474, 110475, 44941, 94099, 94100, 53141, 53148, 75686, 75687, 75688, 73650, 108468, 108469, 108470, 73654, 108472, 73656, 165818, 165821, 63425, 63428, 128966, 79823, 192465, 192466, 79825, 73684, 73682, 73681, 198619, 198620, 198621, 61414, 88041, 88042, 104430, 104431, 104432, 104433, 43553)) |
20.17 | ||||||||||||||||||||
|
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" = 129468)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" = 129468) |
13.19 | ||||||||||||||||||||
|
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" = 129468) )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" = 129468)) |
7.62 | ||||||||||||||||||||
|
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" = 129468SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 129468 |
2.72 | ||||||||||||||||||||
|
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" = 129468 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 129468 LIMIT 21 |
0.26 | ||||||||||||||||||||
|
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.16 | ||||||||||||||||||||
|
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:25:18.701666+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:25:18.701662+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['308000', '304040', '299790', '295432', '295431', '290872', '290870', '288584', '287060', '287059', '285600', '284697', '284383', '284381', '283849', '280609', '280608', '275562', '275561', '275560', '270879', '266425', '263373', '261550', '261549', '256842', '251349', '247209', '243356', '238189', '233492', '230489', '228476', '227788', '226632', '224192', '223300', '222732', '221521', '218085', '216759', '214512', '213437', '211698', '207809', '207441', '207440', '198621', '198620', '198619']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T06:25:18.701666+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:25:18.701662+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['308000', '304040', '299790', '295432', '295431', '290872', '290870', '288584', '287060', '287059', '285600', '284697', '284383', '284381', '283849', '280609', '280608', '275562', '275561', '275560', '270879', '266425', '263373', '261550', '261549', '256842', '251349', '247209', '243356', '238189', '233492', '230489', '228476', '227788', '226632', '224192', '223300', '222732', '221521', '218085', '216759', '214512', '213437', '211698', '207809', '207441', '207440', '198621', '198620', '198619']]::jsonb[]))) |
2.44 | ||||||||||||||||||||
|
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 (304040, 299790, 295432, 295431, 290872, 290870, 288584, 287060, 287059, 285600, 284697, 284383, 284381, 283849, 280609, 280608, 275562, 275561, 275560, 270879, 266425, 261550, 261549, 256842, 247209, 243356, 238189, 233492, 230489, 228476, 226632, 223300, 222732, 221521, 218085, 216759, 213437, 207809, 207440, 198621, 198620, 198619)SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" IN (304040, 299790, 295432, 295431, 290872, 290870, 288584, 287060, 287059, 285600, 284697, 284383, 284381, 283849, 280609, 280608, 275562, 275561, 275560, 270879, 266425, 261550, 261549, 256842, 247209, 243356, 238189, 233492, 230489, 228476, 226632, 223300, 222732, 221521, 218085, 216759, 213437, 207809, 207440, 198621, 198620, 198619) |
0.19 | ||||||||||||||||||||
|
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 "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.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/./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" = 129468) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 129468) LIMIT 21 |
0.22 | ||||||||||||||||||||
|
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" = 129468 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 129468 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.13 | ||||||||||||||||||||
|
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" = 129468 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 129468 LIMIT 21 |
0.14 | ||||||||||||||||||||
|
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" = 129468) 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" = 129468) LIMIT 1 |
0.24 | ||||||||||||||||||||
|
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" = 129468 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 129468 LIMIT 21 |
0.22 | ||||||||||||||||||||
|
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" = 580393 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 580393 LIMIT 21 |
0.36 | ||||||||||||||||||||
|
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" = 9 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 9 LIMIT 21 |
0.15 | ||||||||||||||||||||
|
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" = 129468)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" = 129468) |
1.65 | ||||||||||||||||||||
|
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" = 129468) )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" = 129468)) |
2.38 | ||||||||||||||||||||
|
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" = 129468SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 129468 |
0.64 | ||||||||||||||||||||
|
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" = 129468 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 129468 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(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 |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 43495 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 43495 LIMIT 21 |
0.28 | ||||||||||||||||||||
|
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/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 43495 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 43495 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/lego/templates/sets/render_set.html |
|||||||||||||||||||||
No messages logged.