MOCs Designed by Kirvet

Kirvet
Showing 50 MOCs (770 total quantity)
10265 Plymouth Cuda
MOC-247508
(1106 parts)
Creator > Creator Expert 2026
Alt
BMW M3 (e36)
MOC-246881
(300 parts)
Speed Champions 2026
76924 5 in 1 Alternative Set
MOC-244647
(811 parts)
Speed Champions 2026
Alt
76924 M4
MOC-245943
(341 parts)
Speed Champions 2025
Alt
31133 White Poodle
MOC-244840
(136 parts)
Creator > Creator 3-in-1 2025
76924 Urus
MOC-244507
(419 parts)
Speed Champions 2025
Alt
76924 UAZ-452 (Bukhanka)
MOC-243773
(423 parts)
Speed Champions 2025
Alt
76924 Camaro
MOC-241189
(314 parts)
Speed Champions 2025
Alt
10337 Cobra
MOC-240439
(1034 parts)
Creator > Creator Expert 2025
Alt
10337 Kamaz 6520
MOC-238950
(907 parts)
Creator > Creator Expert 2025
Alt
76905 Hearse
MOC-239832
(374 parts)
Speed Champions 2025
Alt
76924 VAZ 2108
MOC-239389
(469 parts)
Speed Champions 2025
Alt
76900 Police Cruiser
MOC-238780
(234 parts)
Speed Champions 2025
10295 5 in 1 set
MOC-238606
(1458 parts)
Creator > Creator Expert 2025
Alt
10295 Nissan 350Z
MOC-236847
(1128 parts)
Creator > Creator Expert 2025
Alt
10295 Mazda 787b
MOC-235881
(978 parts)
Creator > Creator Expert 2025
Alt
76904 LMP Racecar
MOC-233188
(281 parts)
Speed Champions 2025
Alt
76904 Classic Muscle
MOC-234077
(293 parts)
Speed Champions 2025
Alt
76904 Honda NSX
MOC-233585
(298 parts)
Speed Champions 2025
Alt
76896 NSX
MOC-233440
(232 parts)
Speed Champions 2025
Alt
76896 Nissan Atlas
MOC-232653
(260 parts)
Speed Champions 2025
Alt
76896 Nismo GT
MOC-230941
(251 parts)
Speed Champions 2025
Alt
10321 Ultimate rebuilding experience (12 in 1)
MOC-232469
(1210 parts)
Creator > Creator Expert 2025
Alt
76924 5 in 1 set
MOC-230747
(811 parts)
Speed Champions 2025
Alt
76924 Tesla Cybertruck
MOC-232234
(416 parts)
Speed Champions 2025
Alt
10321 Niva
MOC-229870
(919 parts)
Creator > Creator Expert 2025
Alt
10321 3 in 1 set
MOC-227103
(1210 parts)
Creator > Creator Expert 2025
Alt
10321 Caterham 7
MOC-227099
(650 parts)
Creator > Creator Expert 2025
Alt
10321 Citroёn DS
MOC-223855
(919 parts)
Creator > Creator Expert 2025
Alt
76924 Racing Truck
MOC-221386
(383 parts)
Speed Champions 2025
Alt
76924 Helicopter
MOC-221589
(373 parts)
Speed Champions 2025
Alt
76924 Vintage Pickup
MOC-218692
(315 parts)
Speed Champions 2025
Alt
76924 Toyota Land Cruiser 40
MOC-218375
(329 parts)
Speed Champions 2025
Alt
76920 Honda NSX
MOC-219512
(258 parts)
Speed Champions 2025
Alt
10290 Belvedere Hardtop
MOC-218442
(1196 parts)
Creator > Creator Expert 2025
Alt
76920 Go Kart
MOC-217374
(200 parts)
Speed Champions 2025
76920 Mustang
MOC-215585
(284 parts)
Speed Champions 2025
Alt
76920 Dark Horse F40
MOC-216535
(274 parts)
Speed Champions 2025
Alt
76914 Hyper X
MOC-216032
(214 parts)
Speed Champions 2025
Alt
76914 Muscle car
MOC-215565
(228 parts)
Speed Champions 2025
76914 Rescue Copter
MOC-213813
(216 parts)
Speed Champions 2025
76914 Go Cart
MOC-215181
(177 parts)
Speed Champions 2025
10321 Hermes
MOC-214733
(804 parts)
Creator > Creator Expert 2025
Alt
76924 Ultimate rebuilding experience (16 in 1)
MOC-213874
(811 parts)
Speed Champions 2025
Alt
76924 6 in 1 set
MOC-213869
(811 parts)
Speed Champions 2025
Alt
76924 Porsche 911
MOC-212126
(293 parts)
Speed Champions 2025
Alt
76924 Romero
MOC-213029
(360 parts)
Speed Champions 2025
Alt
76924 Supra
MOC-212461
(297 parts)
Speed Champions 2025
Alt
76924 Fairlady
MOC-212020
(292 parts)
Speed Champions 2025
Alt
10300 4 in 1 set
MOC-211637
(1872 parts)
Creator > Creator Expert 2025
Alt
DJDT

Time

Resource usage

Resource Value
User CPU time 666.860 msec
System CPU time 12.839 msec
Total CPU time 679.699 msec
Elapsed time 773.919 msec
Context switches 671 voluntary, 6 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 86.70 ms (24 queries including 10 similar and 10 duplicates )
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('Kirvet'))
 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('Kirvet')) LIMIT 21
 9.25

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(767)
  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 (84620)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 (84620)
 0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(767)
  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('Kirvet')
 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('Kirvet') LIMIT 21
 0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(784)
  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"
  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" = 84620)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" = 84620)
2 similar queries. Duplicated 2 times. 		3.86

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(807)
  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" = 84620)
 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" = 84620) ORDER BY "lego_baseset"."added_dt" DESC
 22.51

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(813)
  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 (305161, 43022, 43023, 165906, 182292, 47125, 79894, 133145, 217115, 112682, 106539, 100394, 79916, 79918, 256047, 188463, 79915, 165942, 135223, 176186, 94268, 84030, 131135, 71742, 102469, 36934, 43085, 75856, 102483, 75860, 200791, 266330, 34909, 67680, 288865, 114786, 247907, 249956, 114790, 161895, 39014, 106601, 190576, 118897, 237682, 120947, 96368, 73847, 184443, 106620, 106625, 45185, 159877, 43142, 65675, 233612, 69772, 217230, 61586, 170132, 75929, 163996, 155807, 77983, 75935, 41129, 80047, 139440, 198833, 182457, 41146, 188603, 250046, 186563, 75973, 37062, 75975, 86216, 75976, 118986, 161997, 53455, 168145, 92370, 100564, 149717, 100566, 303322, 94426, 116967, 264426, 162027, 80108, 215281, 162033, 157943, 82173, 90369, 289026, 270594, 88321, 133383, 133385, 248076, 98576, 149779, 74003, 30996, 117014, 96534, 47388, 47389, 47390, 135457, 104738, 110884, 71976, 217387, 71981, 43323, 104767, 194880, 72001, 43336, 43337, 37193, 67916, 41292, 41294, 246096, 80209, 57682, 129369, 74078, 43358, 37216, 43362, 123235, 297316, 262501, 125285, 110953, 43370, 43371, 289133, 104815, 57712, 94577, 121205, 139645, 221566, 76158, 39295, 55688, 86409, 276875, 207248, 149906, 45459, 88470, 84376, 90529, 141741, 80302, 260527, 223667, 207283, 151992, 68025, 115141, 102855, 41418, 203215, 156112, 41424, 100823, 180696, 70110, 86495, 70112, 43496, 100841, 149994, 149995, 125418, 39403, 39401, 289264, 211441, 135664, 115187, 78324, 41468, 291329, 127489, 66052, 66053, 49671, 47624, 49674, 49675, 49676, 119313, 78354, 262677, 168469, 262683, 172571, 76316, 119327, 102944, 248353, 119329, 41504, 107047, 254504, 160306, 49714, 49717, 309814, 197175, 47669, 47673, 43574, 43573, 199228, 164414, 49726, 41535, 37439, 201285, 207443, 299604, 64085, 76375, 109151, 49762, 76388, 43624, 80491, 80492, 31343, 100976, 103025, 103026, 60020, 215674, 127617, 127619, 199301, 49797, 152202, 125579, 184974, 205456, 58000, 39571, 240278, 264858, 35486, 211621, 39591, 39592, 66219, 133804, 180910, 76466, 178868, 45751, 131770, 111290, 84666, 49852, 49851, 49855, 232128, 201408, 201411, 144067, 156359, 189128, 297680, 152272, 117456, 74450, 66258, 43742, 43743, 35551, 35550, 92904, 58094, 146159, 58095, 47857, 47858, 47859, 47860, 140027, 35583, 35584, 35585, 43778, 164613, 113414, 195339, 35595, 162574, 109326, 176912, 70417, 183059, 76566, 160537, 88858, 189212, 117534, 111398, 123689, 105257, 123693, 84790, 230206, 209726, 74560, 92995, 95045, 232265, 80713, 170827, 158540, 265037, 47965, 47966, 35680, 70497, 45923, 41829, 154470, 35690, 125805, 68466, 107379, 82806, 62334, 43903, 62336, 37763, 281482, 68490, 246669, 281486, 246670, 174996, 269206, 76699, 41883, 203677, 105383, 220074, 89005, 97198, 170927, 93104, 80823, 293821, 297921, 244673, 48073, 86987, 254926, 115664, 80848, 132055, 80857, 41958, 95207, 183272, 35814, 144365, 35821, 154607, 127986, 166899, 140280, 148475, 150529, 35842, 246789, 308230, 171016, 203785, 218125, 76815, 203794, 42005, 42015, 187424, 42016, 306220, 138286, 134191, 80952, 101434, 46140, 70717, 85054, 181311, 121920, 91202, 121923, 78915, 72770, 140358, 193609, 253002, 148558, 113743, 44110, 87121, 44113, 35923, 35924, 40023, 128091, 40027, 97373, 255070, 191583, 35933, 46179, 89190, 46183, 46182, 195689, 70761, 152687, 187505, 183410, 117873, 54385, 242806, 183416, 60536, 76931, 107652, 54404, 173191, 160904, 109706, 259221, 216219, 271516, 97436, 101534, 76957, 74907, 76964, 87205, 273574, 76966, 130216, 179373, 36019, 126133, 76981, 193726, 253121, 253122, 156869, 103623, 72903, 107725, 234705, 105682, 300247, 249048, 210135, 195803, 228572, 42209, 107748, 122090, 173293, 111854, 238833, 267507, 48372, 44277, 89337, 216314, 44281, 99581, 68862, 216319, 103679, 99583, 56577, 261379, 197892, 72964, 142598, 44289, 255240, 56584, 52493, 107793, 107796, 107800, 154909, 81181, 42271, 220452, 93485, 79156, 302391, 259384, 193847, 46398, 236865, 167233, 105801, 167247, 191825, 83282, 197975, 167255, 146776, 120151, 267611, 111964, 101723, 46432, 75106, 73063, 36204, 114030, 32124, 89472, 109955, 130436, 87427, 36230, 142727, 79240, 216457, 105870, 243087, 105874, 73106, 236949, 191901, 255391, 77218, 99747, 79269, 159143, 36265, 101802, 138667, 101803, 118197, 140726, 132534, 89530, 56763, 265661, 116161, 161218, 171459, 173509, 93652, 134616, 112088, 95709, 155102, 155103, 79325, 44509, 249318, 128491, 288235, 169453, 75244, 75247, 49148, 101873, 36336, 32237, 114165, 310774, 60917, 239096, 224761, 101881, 306684, 101885, 177664, 69120, 44549, 126472, 110090, 75280, 75281, 224789, 224790, 169493, 181784, 181786, 181788, 103965, 48668, 95775, 48671, 245284, 146987, 124466, 249395, 69171, 292405, 83511, 181816, 165435, 228933, 120394, 87626, 108108, 75339, 308814, 290383, 36430, 42583, 159324, 89696, 56932, 81510, 73319, 73318, 271983, 46704, 67185, 67186, 46706, 46705, 46710, 52856, 91780, 263814, 167560, 126603, 71307, 274067, 87700, 212635, 120476, 251556, 93862, 155304, 118447, 163504, 77490, 138931, 169652, 36538, 48827, 239302, 48845, 181966, 79570, 151251, 151252, 81619, 114402, 79588, 48872, 114411, 93932, 77547, 134895, 247538, 85746, 73459, 42761, 153355, 229143, 102168, 114458, 198430, 163617, 241444, 106277, 190246, 173863, 106280, 106279, 180012, 245550, 161584, 83760, 75570, 75571, 46899, 143162, 290619, 42812, 42810, 57150, 114495, 134985, 57165, 143182, 57166, 75601, 259928, 73565, 89952, 239459, 128869, 75622, 75627, 155500, 298861, 75628, 46955, 102263, 223096, 145273, 122744, 253819, 69504, 69506, 192389, 44933, 49031, 176011, 229273, 180126, 110496, 81826, 81827, 235428, 81828, 47028, 42934, 42936, 61369, 79809, 49090, 196551, 288713, 124876, 245717, 206805, 104405, 65493, 45014, 32727, 77793, 225251, 67556, 94181, 165868, 38892, 112623, 108530, 42994, 57332, 141307, 180220, 88061))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 (305161, 43022, 43023, 165906, 182292, 47125, 79894, 133145, 217115, 112682, 106539, 100394, 79916, 79918, 256047, 188463, 79915, 165942, 135223, 176186, 94268, 84030, 131135, 71742, 102469, 36934, 43085, 75856, 102483, 75860, 200791, 266330, 34909, 67680, 288865, 114786, 247907, 249956, 114790, 161895, 39014, 106601, 190576, 118897, 237682, 120947, 96368, 73847, 184443, 106620, 106625, 45185, 159877, 43142, 65675, 233612, 69772, 217230, 61586, 170132, 75929, 163996, 155807, 77983, 75935, 41129, 80047, 139440, 198833, 182457, 41146, 188603, 250046, 186563, 75973, 37062, 75975, 86216, 75976, 118986, 161997, 53455, 168145, 92370, 100564, 149717, 100566, 303322, 94426, 116967, 264426, 162027, 80108, 215281, 162033, 157943, 82173, 90369, 289026, 270594, 88321, 133383, 133385, 248076, 98576, 149779, 74003, 30996, 117014, 96534, 47388, 47389, 47390, 135457, 104738, 110884, 71976, 217387, 71981, 43323, 104767, 194880, 72001, 43336, 43337, 37193, 67916, 41292, 41294, 246096, 80209, 57682, 129369, 74078, 43358, 37216, 43362, 123235, 297316, 262501, 125285, 110953, 43370, 43371, 289133, 104815, 57712, 94577, 121205, 139645, 221566, 76158, 39295, 55688, 86409, 276875, 207248, 149906, 45459, 88470, 84376, 90529, 141741, 80302, 260527, 223667, 207283, 151992, 68025, 115141, 102855, 41418, 203215, 156112, 41424, 100823, 180696, 70110, 86495, 70112, 43496, 100841, 149994, 149995, 125418, 39403, 39401, 289264, 211441, 135664, 115187, 78324, 41468, 291329, 127489, 66052, 66053, 49671, 47624, 49674, 49675, 49676, 119313, 78354, 262677, 168469, 262683, 172571, 76316, 119327, 102944, 248353, 119329, 41504, 107047, 254504, 160306, 49714, 49717, 309814, 197175, 47669, 47673, 43574, 43573, 199228, 164414, 49726, 41535, 37439, 201285, 207443, 299604, 64085, 76375, 109151, 49762, 76388, 43624, 80491, 80492, 31343, 100976, 103025, 103026, 60020, 215674, 127617, 127619, 199301, 49797, 152202, 125579, 184974, 205456, 58000, 39571, 240278, 264858, 35486, 211621, 39591, 39592, 66219, 133804, 180910, 76466, 178868, 45751, 131770, 111290, 84666, 49852, 49851, 49855, 232128, 201408, 201411, 144067, 156359, 189128, 297680, 152272, 117456, 74450, 66258, 43742, 43743, 35551, 35550, 92904, 58094, 146159, 58095, 47857, 47858, 47859, 47860, 140027, 35583, 35584, 35585, 43778, 164613, 113414, 195339, 35595, 162574, 109326, 176912, 70417, 183059, 76566, 160537, 88858, 189212, 117534, 111398, 123689, 105257, 123693, 84790, 230206, 209726, 74560, 92995, 95045, 232265, 80713, 170827, 158540, 265037, 47965, 47966, 35680, 70497, 45923, 41829, 154470, 35690, 125805, 68466, 107379, 82806, 62334, 43903, 62336, 37763, 281482, 68490, 246669, 281486, 246670, 174996, 269206, 76699, 41883, 203677, 105383, 220074, 89005, 97198, 170927, 93104, 80823, 293821, 297921, 244673, 48073, 86987, 254926, 115664, 80848, 132055, 80857, 41958, 95207, 183272, 35814, 144365, 35821, 154607, 127986, 166899, 140280, 148475, 150529, 35842, 246789, 308230, 171016, 203785, 218125, 76815, 203794, 42005, 42015, 187424, 42016, 306220, 138286, 134191, 80952, 101434, 46140, 70717, 85054, 181311, 121920, 91202, 121923, 78915, 72770, 140358, 193609, 253002, 148558, 113743, 44110, 87121, 44113, 35923, 35924, 40023, 128091, 40027, 97373, 255070, 191583, 35933, 46179, 89190, 46183, 46182, 195689, 70761, 152687, 187505, 183410, 117873, 54385, 242806, 183416, 60536, 76931, 107652, 54404, 173191, 160904, 109706, 259221, 216219, 271516, 97436, 101534, 76957, 74907, 76964, 87205, 273574, 76966, 130216, 179373, 36019, 126133, 76981, 193726, 253121, 253122, 156869, 103623, 72903, 107725, 234705, 105682, 300247, 249048, 210135, 195803, 228572, 42209, 107748, 122090, 173293, 111854, 238833, 267507, 48372, 44277, 89337, 216314, 44281, 99581, 68862, 216319, 103679, 99583, 56577, 261379, 197892, 72964, 142598, 44289, 255240, 56584, 52493, 107793, 107796, 107800, 154909, 81181, 42271, 220452, 93485, 79156, 302391, 259384, 193847, 46398, 236865, 167233, 105801, 167247, 191825, 83282, 197975, 167255, 146776, 120151, 267611, 111964, 101723, 46432, 75106, 73063, 36204, 114030, 32124, 89472, 109955, 130436, 87427, 36230, 142727, 79240, 216457, 105870, 243087, 105874, 73106, 236949, 191901, 255391, 77218, 99747, 79269, 159143, 36265, 101802, 138667, 101803, 118197, 140726, 132534, 89530, 56763, 265661, 116161, 161218, 171459, 173509, 93652, 134616, 112088, 95709, 155102, 155103, 79325, 44509, 249318, 128491, 288235, 169453, 75244, 75247, 49148, 101873, 36336, 32237, 114165, 310774, 60917, 239096, 224761, 101881, 306684, 101885, 177664, 69120, 44549, 126472, 110090, 75280, 75281, 224789, 224790, 169493, 181784, 181786, 181788, 103965, 48668, 95775, 48671, 245284, 146987, 124466, 249395, 69171, 292405, 83511, 181816, 165435, 228933, 120394, 87626, 108108, 75339, 308814, 290383, 36430, 42583, 159324, 89696, 56932, 81510, 73319, 73318, 271983, 46704, 67185, 67186, 46706, 46705, 46710, 52856, 91780, 263814, 167560, 126603, 71307, 274067, 87700, 212635, 120476, 251556, 93862, 155304, 118447, 163504, 77490, 138931, 169652, 36538, 48827, 239302, 48845, 181966, 79570, 151251, 151252, 81619, 114402, 79588, 48872, 114411, 93932, 77547, 134895, 247538, 85746, 73459, 42761, 153355, 229143, 102168, 114458, 198430, 163617, 241444, 106277, 190246, 173863, 106280, 106279, 180012, 245550, 161584, 83760, 75570, 75571, 46899, 143162, 290619, 42812, 42810, 57150, 114495, 134985, 57165, 143182, 57166, 75601, 259928, 73565, 89952, 239459, 128869, 75622, 75627, 155500, 298861, 75628, 46955, 102263, 223096, 145273, 122744, 253819, 69504, 69506, 192389, 44933, 49031, 176011, 229273, 180126, 110496, 81826, 81827, 235428, 81828, 47028, 42934, 42936, 61369, 79809, 49090, 196551, 288713, 124876, 245717, 206805, 104405, 65493, 45014, 32727, 77793, 225251, 67556, 94181, 165868, 38892, 112623, 108530, 42994, 57332, 141307, 180220, 88061))
 12.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(821)
  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" = 84620)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" = 84620)
 13.56

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(822)
  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"
  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" = 84620)
       )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" = 84620))
2 similar queries. Duplicated 2 times. 		3.46

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(840)
  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"
  FROM "lego_designerfollower"
 WHERE "lego_designerfollower"."designer_id" = 84620SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 84620
2 similar queries. Duplicated 2 times. 		13.66

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(840)
  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" = 84620
 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 84620 LIMIT 21
 0.16

Connection: default

Transaction status: In transaction

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(852)
  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",
       "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
2 similar queries. Duplicated 2 times. 		0.08

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(852)
  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-31T13:51:28.311574+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-31T13:51:28.311571+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['310774', '309814', '308814', '308230', '306684', '306220', '305161', '303322', '302391', '300247', '299604', '298861', '297921', '297680', '297316', '293821', '292405', '291329', '290619', '290383', '289264', '289133', '289026', '288865', '288713', '288235', '281486', '281482', '276875', '274067', '273574', '271983', '271516', '270594', '269206', '267611', '267507', '266330', '265661', '265037', '264858', '264426', '263814', '262683', '262677', '262501', '261379', '260527', '259928', '259384']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-31T13:51:28.311574+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-31T13:51:28.311571+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['310774', '309814', '308814', '308230', '306684', '306220', '305161', '303322', '302391', '300247', '299604', '298861', '297921', '297680', '297316', '293821', '292405', '291329', '290619', '290383', '289264', '289133', '289026', '288865', '288713', '288235', '281486', '281482', '276875', '274067', '273574', '271983', '271516', '270594', '269206', '267611', '267507', '266330', '265661', '265037', '264858', '264426', '263814', '262683', '262677', '262501', '261379', '260527', '259928', '259384']]::jsonb[])))
 1.55

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(859)
  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 (310774, 308814, 308230, 306684, 306220, 305161, 303322, 302391, 300247, 299604, 298861, 297921, 297680, 297316, 293821, 292405, 291329, 290619, 290383, 289264, 289133, 289026, 288865, 288713, 288235, 281486, 281482, 276875, 274067, 273574, 271983, 271516, 270594, 269206, 267611, 267507, 266330, 265661, 265037, 264858, 264426, 263814, 262683, 262677, 262501, 261379, 260527, 259928, 259384)SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" IN (310774, 308814, 308230, 306684, 306220, 305161, 303322, 302391, 300247, 299604, 298861, 297921, 297680, 297316, 293821, 292405, 291329, 290619, 290383, 289264, 289133, 289026, 288865, 288713, 288235, 281486, 281482, 276875, 274067, 273574, 271983, 271516, 270594, 269206, 267611, 267507, 266330, 265661, 265037, 264858, 264426, 263814, 262683, 262677, 262501, 261379, 260527, 259928, 259384)
 0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(860)
  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.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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)
412 </a>
413 </li>
414 <li class="hidden-xs">
415 {% geo_currency request.user %}
416 </li>
417 {% comment %}
418 <li class="hidden-xs hidden-sm">
419 <a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>

/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" = 84620)
 LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 84620) LIMIT 21
 0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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)
7 {% url 'add_profile_avatar' request.user.get_username as url %}
8 {% include 'lego/includes/get_img_url_modal.html' with url=url %}
9
10 {% with profile_user.get_privacy_options as privacy_options %}
11 <div class="text-center pt-3 border-1 mb-20">
12 <a href="{% url 'user_profile' profile_user.username %}">
13 <img id="user_profile_avatar" src="{% avatar_url profile_user 150 %}" class="avatar" width="150px" height="150px">
14 </a>

/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html
SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
 WHERE "avatar_avatar"."user_id" = 84620
 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 84620 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1
2 similar queries. Duplicated 2 times. 		0.21

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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]
10 {% with profile_user.get_privacy_options as privacy_options %}
11 <div class="text-center pt-3 border-1 mb-20">
12 <a href="{% url 'user_profile' profile_user.username %}">
13 <img id="user_profile_avatar" src="{% avatar_url profile_user 150 %}" class="avatar" width="150px" height="150px">
14 </a>
15
16 {% if request.user == profile_user %}
17 <div class="js-load_user_avatar" data-modal="#change_avatar_modal"

/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" = 84620
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 84620 LIMIT 21
 0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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():
24 <h2 class="size-18 mt-10 mb-0 js-hover-card" data-hover="{% url 'user_card' profile_user.username %}">{{ profile_user.username }}</h2>
25
26 <a href="{% url 'about' %}#roles">
27 <h3 class="size-12 mt-0 mb-10 text-info">{{ profile_user.get_rolename.0|upper }}</h3>
28 </a>
29 {% if request.user == profile_user or privacy_options.is_public_legosummary %}
30 <h3 class="size-12 mt-0 mb-10 text-muted">{{ profile_user.get_num_parts_summary.all_parts|intcomma }} Parts</h3>
31 {% endif %}

/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" = 84620)
 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" = 84620) LIMIT 1
 0.20

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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():
24 <h2 class="size-18 mt-10 mb-0 js-hover-card" data-hover="{% url 'user_card' profile_user.username %}">{{ profile_user.username }}</h2>
25
26 <a href="{% url 'about' %}#roles">
27 <h3 class="size-12 mt-0 mb-10 text-info">{{ profile_user.get_rolename.0|upper }}</h3>
28 </a>
29 {% if request.user == profile_user or privacy_options.is_public_legosummary %}
30 <h3 class="size-12 mt-0 mb-10 text-muted">{{ profile_user.get_num_parts_summary.all_parts|intcomma }} Parts</h3>
31 {% endif %}

/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html
SELECT "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"
  FROM "plans_plan"
 WHERE "plans_plan"."id" = 2
 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21
2 similar queries. Duplicated 2 times. 		0.09

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  return render(request, 'accounts/user_mocs.html', context)
31 {% endif %}
32
33 {% if request.user == profile_user or privacy_options.is_public_plan %}
34 {% if not profile_user.plan.plan.is_free %}
35 <a href="{% url 'help_plan_limits' %}">
36 <div class="mb-10">{{ profile_user.get_plan_html }}</div>
37 </a>
38 {% endif %}

/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" = 84620
 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 84620 LIMIT 21
 0.17

Connection: default

Transaction status: In transaction

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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)
52 {% endwith %}
53 {% endif %}
54
55 {% if profile_user.profile.trophy_badge.badge and privacy_options.is_public_badges %}
56 <a href="{% url 'badges' %}#{{ profile_user.profile.trophy_badge.badge.code }}">
57 <div class="text-center" style="margin:auto">
58 {% render_badge profile_user.profile.trophy_badge.badge %}
59 </div>

/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html
SELECT COUNT(*) AS "__count"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 84620)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" = 84620)
2 similar queries. Duplicated 2 times. 		1.49

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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()
60 </a>
61 {% endif %}
62
63 {% if profile_user.get_num_mocs > 0 %}
64 {% with profile_user.designer.get_stats as designer_stats %}
65 <div class="border-top-1 box-light">
66 <div class="row">
67 <div class="col-xs-4">

/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html
SELECT SUM("lego_setstatstotal"."likes") AS "likes__sum"
  FROM "lego_setstatstotal"
 WHERE "lego_setstatstotal"."set_id" IN (
        SELECT U0."baseset_ptr_id"
          FROM "lego_moc" U0
         INNER JOIN "lego_baseset" U1
            ON (U0."baseset_ptr_id" = U1."id")
         WHERE (U1."is_active" AND U0."designer_id" = 84620)
       )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" = 84620))
2 similar queries. Duplicated 2 times. 		1.97

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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
61 {% endif %}
62
63 {% if profile_user.get_num_mocs > 0 %}
64 {% with profile_user.designer.get_stats as designer_stats %}
65 <div class="border-top-1 box-light">
66 <div class="row">
67 <div class="col-xs-4">
68 <a href="{% url 'user_mocs' profile_user.username %}">

/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html
SELECT COUNT(*) AS "__count"
  FROM "lego_designerfollower"
 WHERE "lego_designerfollower"."designer_id" = 84620SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 84620
2 similar queries. Duplicated 2 times. 		1.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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()
61 {% endif %}
62
63 {% if profile_user.get_num_mocs > 0 %}
64 {% with profile_user.designer.get_stats as designer_stats %}
65 <div class="border-top-1 box-light">
66 <div class="row">
67 <div class="col-xs-4">
68 <a href="{% url 'user_mocs' profile_user.username %}">

/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_navbar_card.html
SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
 WHERE "avatar_avatar"."user_id" = 84620
 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 84620 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1
2 similar queries. Duplicated 2 times. 		0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(881)
  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]
4 <div class="visible-xs user-mobile-menu mb-30">
5 <div class="mb-10">
6 <a href="{% url 'user_profile' profile_user.username %}">
7 <img id="user_profile_avatar" src="{% avatar_url profile_user 75 %}" class="avatar mr-10" width="50px" height="50px">
8 {{ profile_user.username }}
9 </a>
10
11 {% if request.user.is_authenticated and request.user != profile_user %}

/home/nathan/rb/site/accounts/templates/accounts/includes/user_profile_mobile_menu.html

Log messages

No messages logged.