| Resource | Value |
|---|---|
| User CPU time | 742.435 msec |
| System CPU time | 15.023 msec |
| Total CPU time | 757.458 msec |
| Elapsed time | 928.614 msec |
| Context switches | 1034 voluntary, 7 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT "auth_user"."id",
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('IBrickedItUp')) 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('IBrickedItUp')) LIMIT 21 |
9.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_groups"."user_id") AS "_prefetch_related_val_user_id",
2 similar queries.
Duplicated 2 times.
"auth_group"."id", "auth_group"."name" FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (534828)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 (534828) |
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('IBrickedItUp') 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('IBrickedItUp') LIMIT 21 |
0.19 | ||||||||||||||||||||
|
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" = 534828)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" = 534828) |
3.98 | ||||||||||||||||||||
|
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" = 534828) 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" = 534828) ORDER BY "lego_baseset"."added_dt" DESC |
69.95 | ||||||||||||||||||||
|
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 (112643, 192523, 165914, 165915, 145437, 196638, 165919, 145438, 145439, 223266, 223268, 106543, 108592, 163889, 153649, 153651, 153650, 249915, 190532, 280653, 280655, 280656, 280657, 231505, 231504, 231511, 221272, 188505, 188504, 188506, 104535, 174173, 125022, 102493, 114787, 114788, 114789, 141416, 141417, 247920, 247922, 245881, 245882, 159867, 159868, 106626, 116868, 106628, 106630, 151687, 151688, 151689, 135304, 108689, 108690, 108691, 313501, 194719, 194720, 194721, 174240, 168112, 168113, 168114, 112821, 127160, 110778, 110779, 110780, 184509, 110781, 229581, 114895, 106706, 132335, 116948, 116949, 116947, 132336, 131291, 243942, 121063, 121064, 121065, 135402, 149739, 149740, 149741, 135403, 121066, 215280, 182512, 182514, 104686, 147700, 315640, 108792, 196860, 196861, 129299, 106772, 106773, 106774, 106775, 106771, 125209, 172314, 172315, 125212, 125210, 192798, 125211, 109963, 209190, 209191, 109964, 196906, 176428, 198968, 262461, 244038, 139591, 244040, 139592, 139590, 139593, 264530, 264531, 237907, 123220, 227672, 227673, 227675, 186726, 196968, 196969, 110952, 352626, 166262, 156022, 180608, 115073, 180611, 184713, 336273, 336275, 108951, 108952, 108953, 203164, 203166, 143777, 143778, 143779, 143780, 147882, 147883, 147884, 137644, 137645, 119210, 117167, 131505, 299442, 113074, 170426, 170427, 170429, 178624, 178625, 178626, 178627, 160194, 162245, 162246, 160193, 102853, 291275, 164308, 164309, 115158, 115157, 289247, 193024, 129537, 129538, 129539, 129540, 305672, 305673, 305674, 219658, 117260, 225805, 305678, 305679, 225806, 117261, 117259, 145944, 145945, 127514, 127515, 127513, 156189, 156190, 156191, 156192, 127512, 143908, 109093, 109094, 109095, 109092, 131625, 131626, 131627, 131629, 191022, 191023, 180782, 115247, 111151, 107067, 184892, 199230, 250433, 236108, 105039, 236112, 242263, 242265, 242267, 113260, 213627, 213629, 205438, 205439, 187014, 133775, 230032, 133776, 133778, 133777, 109204, 283289, 283290, 283291, 283292, 283293, 117406, 117405, 117408, 117409, 199330, 117404, 117403, 221861, 107171, 107170, 107168, 115373, 113326, 113327, 113328, 113330, 111287, 111288, 137916, 197309, 197310, 129733, 189126, 127694, 127695, 127696, 127697, 207570, 234201, 234204, 234205, 273118, 273120, 266979, 109284, 109285, 109286, 197351, 197352, 217833, 152298, 217835, 152300, 152299, 115437, 166660, 166662, 103139, 105227, 283404, 105229, 105230, 211737, 211738, 107289, 154398, 154400, 230180, 230182, 109352, 111401, 240427, 123691, 240431, 238387, 240440, 131915, 150357, 150358, 109399, 197469, 224107, 224109, 158576, 158577, 275314, 275316, 158583, 158584, 248700, 136061, 136062, 291711, 136063, 107391, 291714, 107389, 189316, 107388, 156555, 156556, 156557, 103309, 168847, 111506, 168851, 168852, 123797, 123796, 123795, 111508, 277405, 105374, 301983, 301985, 301986, 301987, 312227, 312228, 301988, 312231, 146340, 115622, 172972, 172973, 172974, 172976, 199610, 310211, 187335, 142295, 242649, 175068, 142301, 142302, 291807, 142300, 111583, 111582, 107486, 105439, 105443, 105440, 115687, 322536, 254952, 322538, 322539, 140267, 115689, 115688, 238576, 238577, 160754, 140274, 140272, 109554, 113675, 134160, 128027, 306216, 111664, 216115, 121917, 103487, 132162, 109641, 197721, 351322, 205919, 205920, 144481, 144482, 144483, 107687, 312427, 179307, 179309, 179310, 111724, 246903, 246906, 144508, 191616, 109711, 244882, 128148, 197786, 197787, 111777, 111778, 146599, 146600, 226473, 226474, 146601, 115883, 115882, 115881, 171183, 115880, 122041, 122042, 122043, 312513, 253126, 230598, 230602, 130251, 183502, 109774, 222428, 163043, 107752, 138473, 195820, 201965, 197869, 201967, 208112, 177393, 208113, 208115, 195823, 195822, 195821, 132338, 234744, 177400, 132337, 187643, 105715, 244991, 244992, 244993, 111875, 187655, 128274, 144667, 126237, 126239, 126240, 142629, 113957, 189735, 185640, 185641, 181549, 181551, 107824, 107825, 107826, 193846, 197947, 109884, 228671, 296261, 296262, 326988, 103757, 165198, 165202, 163154, 165206, 138585, 138586, 251241, 140664, 181630, 118144, 193926, 134539, 236940, 236941, 236942, 159119, 159120, 312721, 134541, 134540, 175508, 175509, 112021, 220567, 191896, 175511, 106119, 105711, 105712, 126368, 105714, 204195, 265641, 150955, 150958, 150959, 150960, 153009, 153010, 153011, 103861, 179640, 214464, 112080, 112081, 112082, 194003, 194004, 116181, 110040, 148959, 148960, 148961, 167394, 167396, 167397, 171494, 171495, 171496, 122343, 136686, 151023, 136687, 136689, 232949, 189943, 232951, 189944, 232955, 124416, 124418, 124419, 124420, 132619, 183822, 116249, 198170, 198171, 116251, 116250, 198174, 261664, 179744, 149026, 149027, 337444, 337445, 337446, 337447, 337448, 149025, 110117, 106025, 106020, 106023, 106024, 155184, 210492, 210493, 112194, 128580, 128581, 128582, 128583, 114254, 224847, 224848, 263762, 126569, 196203, 196204, 196205, 183922, 112249, 112250, 112251, 321148, 161405, 104060, 267906, 161413, 161414, 114310, 235144, 235145, 210569, 142987, 142988, 142986, 114312, 185999, 114311, 110220, 110219, 110218, 175769, 173723, 173727, 173728, 124575, 134818, 163499, 243375, 243376, 243377, 163503, 159414, 253623, 159415, 341696, 216768, 198338, 255684, 130757, 130758, 192199, 255688, 130760, 130759, 138955, 110283, 110282, 110281, 138959, 138960, 138961, 341724, 167648, 212710, 212716, 155386, 155387, 155388, 245503, 182016, 182017, 141061, 141062, 141063, 141064, 110347, 124686, 130840, 130841, 130842, 130843, 130844, 108231, 136990, 177954, 177955, 177956, 177957, 147238, 147239, 247597, 200495, 200498, 108339, 128826, 198466, 198468, 114501, 118601, 241483, 241484, 204621, 180046, 180047, 337744, 337745, 337746, 180050, 249687, 112473, 110427, 110428, 110429, 110430, 135008, 116579, 126821, 126823, 126824, 126825, 169834, 169835, 169836, 196469, 196470, 239480, 239481, 315259, 239483, 106364, 157578, 157579, 114573, 114574, 114575, 108432, 223127, 122779, 122780, 122781, 147358, 122783, 133029, 186279, 135080, 135079, 339883, 137140, 137141, 137142, 108476, 198590, 110535, 188380, 106460, 272350, 251871, 272352, 116702, 251874, 106464, 251876, 128997, 128998, 128996, 106463, 129002, 239595, 331756, 331757, 331758, 331759, 331760, 268268, 129005, 104435, 176118, 108534, 176120))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 (112643, 192523, 165914, 165915, 145437, 196638, 165919, 145438, 145439, 223266, 223268, 106543, 108592, 163889, 153649, 153651, 153650, 249915, 190532, 280653, 280655, 280656, 280657, 231505, 231504, 231511, 221272, 188505, 188504, 188506, 104535, 174173, 125022, 102493, 114787, 114788, 114789, 141416, 141417, 247920, 247922, 245881, 245882, 159867, 159868, 106626, 116868, 106628, 106630, 151687, 151688, 151689, 135304, 108689, 108690, 108691, 313501, 194719, 194720, 194721, 174240, 168112, 168113, 168114, 112821, 127160, 110778, 110779, 110780, 184509, 110781, 229581, 114895, 106706, 132335, 116948, 116949, 116947, 132336, 131291, 243942, 121063, 121064, 121065, 135402, 149739, 149740, 149741, 135403, 121066, 215280, 182512, 182514, 104686, 147700, 315640, 108792, 196860, 196861, 129299, 106772, 106773, 106774, 106775, 106771, 125209, 172314, 172315, 125212, 125210, 192798, 125211, 109963, 209190, 209191, 109964, 196906, 176428, 198968, 262461, 244038, 139591, 244040, 139592, 139590, 139593, 264530, 264531, 237907, 123220, 227672, 227673, 227675, 186726, 196968, 196969, 110952, 352626, 166262, 156022, 180608, 115073, 180611, 184713, 336273, 336275, 108951, 108952, 108953, 203164, 203166, 143777, 143778, 143779, 143780, 147882, 147883, 147884, 137644, 137645, 119210, 117167, 131505, 299442, 113074, 170426, 170427, 170429, 178624, 178625, 178626, 178627, 160194, 162245, 162246, 160193, 102853, 291275, 164308, 164309, 115158, 115157, 289247, 193024, 129537, 129538, 129539, 129540, 305672, 305673, 305674, 219658, 117260, 225805, 305678, 305679, 225806, 117261, 117259, 145944, 145945, 127514, 127515, 127513, 156189, 156190, 156191, 156192, 127512, 143908, 109093, 109094, 109095, 109092, 131625, 131626, 131627, 131629, 191022, 191023, 180782, 115247, 111151, 107067, 184892, 199230, 250433, 236108, 105039, 236112, 242263, 242265, 242267, 113260, 213627, 213629, 205438, 205439, 187014, 133775, 230032, 133776, 133778, 133777, 109204, 283289, 283290, 283291, 283292, 283293, 117406, 117405, 117408, 117409, 199330, 117404, 117403, 221861, 107171, 107170, 107168, 115373, 113326, 113327, 113328, 113330, 111287, 111288, 137916, 197309, 197310, 129733, 189126, 127694, 127695, 127696, 127697, 207570, 234201, 234204, 234205, 273118, 273120, 266979, 109284, 109285, 109286, 197351, 197352, 217833, 152298, 217835, 152300, 152299, 115437, 166660, 166662, 103139, 105227, 283404, 105229, 105230, 211737, 211738, 107289, 154398, 154400, 230180, 230182, 109352, 111401, 240427, 123691, 240431, 238387, 240440, 131915, 150357, 150358, 109399, 197469, 224107, 224109, 158576, 158577, 275314, 275316, 158583, 158584, 248700, 136061, 136062, 291711, 136063, 107391, 291714, 107389, 189316, 107388, 156555, 156556, 156557, 103309, 168847, 111506, 168851, 168852, 123797, 123796, 123795, 111508, 277405, 105374, 301983, 301985, 301986, 301987, 312227, 312228, 301988, 312231, 146340, 115622, 172972, 172973, 172974, 172976, 199610, 310211, 187335, 142295, 242649, 175068, 142301, 142302, 291807, 142300, 111583, 111582, 107486, 105439, 105443, 105440, 115687, 322536, 254952, 322538, 322539, 140267, 115689, 115688, 238576, 238577, 160754, 140274, 140272, 109554, 113675, 134160, 128027, 306216, 111664, 216115, 121917, 103487, 132162, 109641, 197721, 351322, 205919, 205920, 144481, 144482, 144483, 107687, 312427, 179307, 179309, 179310, 111724, 246903, 246906, 144508, 191616, 109711, 244882, 128148, 197786, 197787, 111777, 111778, 146599, 146600, 226473, 226474, 146601, 115883, 115882, 115881, 171183, 115880, 122041, 122042, 122043, 312513, 253126, 230598, 230602, 130251, 183502, 109774, 222428, 163043, 107752, 138473, 195820, 201965, 197869, 201967, 208112, 177393, 208113, 208115, 195823, 195822, 195821, 132338, 234744, 177400, 132337, 187643, 105715, 244991, 244992, 244993, 111875, 187655, 128274, 144667, 126237, 126239, 126240, 142629, 113957, 189735, 185640, 185641, 181549, 181551, 107824, 107825, 107826, 193846, 197947, 109884, 228671, 296261, 296262, 326988, 103757, 165198, 165202, 163154, 165206, 138585, 138586, 251241, 140664, 181630, 118144, 193926, 134539, 236940, 236941, 236942, 159119, 159120, 312721, 134541, 134540, 175508, 175509, 112021, 220567, 191896, 175511, 106119, 105711, 105712, 126368, 105714, 204195, 265641, 150955, 150958, 150959, 150960, 153009, 153010, 153011, 103861, 179640, 214464, 112080, 112081, 112082, 194003, 194004, 116181, 110040, 148959, 148960, 148961, 167394, 167396, 167397, 171494, 171495, 171496, 122343, 136686, 151023, 136687, 136689, 232949, 189943, 232951, 189944, 232955, 124416, 124418, 124419, 124420, 132619, 183822, 116249, 198170, 198171, 116251, 116250, 198174, 261664, 179744, 149026, 149027, 337444, 337445, 337446, 337447, 337448, 149025, 110117, 106025, 106020, 106023, 106024, 155184, 210492, 210493, 112194, 128580, 128581, 128582, 128583, 114254, 224847, 224848, 263762, 126569, 196203, 196204, 196205, 183922, 112249, 112250, 112251, 321148, 161405, 104060, 267906, 161413, 161414, 114310, 235144, 235145, 210569, 142987, 142988, 142986, 114312, 185999, 114311, 110220, 110219, 110218, 175769, 173723, 173727, 173728, 124575, 134818, 163499, 243375, 243376, 243377, 163503, 159414, 253623, 159415, 341696, 216768, 198338, 255684, 130757, 130758, 192199, 255688, 130760, 130759, 138955, 110283, 110282, 110281, 138959, 138960, 138961, 341724, 167648, 212710, 212716, 155386, 155387, 155388, 245503, 182016, 182017, 141061, 141062, 141063, 141064, 110347, 124686, 130840, 130841, 130842, 130843, 130844, 108231, 136990, 177954, 177955, 177956, 177957, 147238, 147239, 247597, 200495, 200498, 108339, 128826, 198466, 198468, 114501, 118601, 241483, 241484, 204621, 180046, 180047, 337744, 337745, 337746, 180050, 249687, 112473, 110427, 110428, 110429, 110430, 135008, 116579, 126821, 126823, 126824, 126825, 169834, 169835, 169836, 196469, 196470, 239480, 239481, 315259, 239483, 106364, 157578, 157579, 114573, 114574, 114575, 108432, 223127, 122779, 122780, 122781, 147358, 122783, 133029, 186279, 135080, 135079, 339883, 137140, 137141, 137142, 108476, 198590, 110535, 188380, 106460, 272350, 251871, 272352, 116702, 251874, 106464, 251876, 128997, 128998, 128996, 106463, 129002, 239595, 331756, 331757, 331758, 331759, 331760, 268268, 129005, 104435, 176118, 108534, 176120)) |
20.90 | ||||||||||||||||||||
|
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" = 534828)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" = 534828) |
19.33 | ||||||||||||||||||||
|
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" = 534828) )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" = 534828)) |
21.90 | ||||||||||||||||||||
|
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" = 534828SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 534828 |
0.29 | ||||||||||||||||||||
|
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" = 534828 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 534828 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
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" = 4 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 4 LIMIT 21 |
0.07 | ||||||||||||||||||||
|
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 "auth_user"."id",
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND "auth_user"."id" = 534828) LIMIT 21SELECT ••• FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND "auth_user"."id" = 534828) LIMIT 21 |
0.14 | ||||||||||||||||||||
|
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(93) user = ProxyUser.objects.get(id=self.id) # Designer class won't have options pre-loaded so do a lookup instead |
|||||||||||||||||||||
|
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
2 similar queries.
Duplicated 2 times.
"auth_group"."id", "auth_group"."name" FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (534828)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 (534828) |
0.12 | ||||||||||||||||||||
|
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(93) user = ProxyUser.objects.get(id=self.id) # Designer class won't have options pre-loaded so do a lookup instead |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'personalisation' AND "accounts_usersetting"."user_id" = 534828)SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'personalisation' AND "accounts_usersetting"."user_id" = 534828) |
0.09 | ||||||||||||||||||||
|
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(94) ga_tracking_id = user.get_personalisation_option('ga_tracking_id') /home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_option(191) options = self.get_personalisation_options() /home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_options(183) if len(self.personalisation_options) == 0: |
|||||||||||||||||||||
|
SELECT "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:24:02.819616+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:24:02.819613+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['352626', '351322', '341724', '341696', '339883', '337744', '337745', '337746', '337448', '337447', '337446', '337444', '337445', '336275', '336273', '331760', '331757', '331756', '331758', '331759', '326988', '322536', '322538', '322539', '321148', '315640', '315259', '313501', '312427', '312721', '312231', '312228', '312227', '312513', '310211', '306216', '305679', '305678', '305674', '305672', '305673', '301983', '301988', '301986', '301987', '301985', '299442', '296261', '296262', '291807']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-11-16T00:24:02.819616+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:24:02.819613+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['352626', '351322', '341724', '341696', '339883', '337744', '337745', '337746', '337448', '337447', '337446', '337444', '337445', '336275', '336273', '331760', '331757', '331756', '331758', '331759', '326988', '322536', '322538', '322539', '321148', '315640', '315259', '313501', '312427', '312721', '312231', '312228', '312227', '312513', '310211', '306216', '305679', '305678', '305674', '305672', '305673', '301983', '301988', '301986', '301987', '301985', '299442', '296261', '296262', '291807']]::jsonb[]))) |
1.73 | ||||||||||||||||||||
|
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 "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.13 | ||||||||||||||||||||
|
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" = 534828) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 534828) LIMIT 21 |
0.14 | ||||||||||||||||||||
|
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" = 534828 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 534828 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(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" = 534828 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 534828 LIMIT 21 |
0.14 | ||||||||||||||||||||
|
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" = 534828) 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" = 534828) LIMIT 1 |
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_rolename(634) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html |
|||||||||||||||||||||
|
SELECT "plans_plan"."id",
2 similar queries.
Duplicated 2 times.
"plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 4 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 4 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/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" = 534828 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 534828 LIMIT 21 |
0.17 | ||||||||||||||||||||
|
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 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" = 534828)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" = 534828) |
1.65 | ||||||||||||||||||||
|
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" = 534828) )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" = 534828)) |
20.37 | ||||||||||||||||||||
|
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" = 534828SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 534828 |
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/./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" = 534828 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 534828 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.19 | ||||||||||||||||||||
|
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.