MOCs Designed by LegoOri

LegoOri
Showing 50 MOCs (629 total quantity)
66712 - Quad-Powered Dragster
MOC-245098
(260 parts)
Technic 2025
Alt
31058 - Beholder
MOC-231925
(130 parts)
Creator > Creator 3-in-1 2025
Kindergarten Airport
MOC-215300
(260 parts)
Creator 2025
Cuttlefish
MOC-197394
(24 parts)
Creator 2024
71783 - Mech Mod
MOC-195679
(124 parts)
Ninjago 2024
40650 - Helicopter
MOC-195115
(135 parts)
Creator 2024
40650 - Cargo Plane
MOC-192288
(131 parts)
Creator 2024
40650 - Supercar
MOC-193802
(137 parts)
Creator 2024
40650 - Dragster
MOC-193647
(124 parts)
Creator 2024
40650 - F1 car
MOC-193539
(126 parts)
Creator 2024
66712 - 4WD Quad
MOC-188879
(457 parts)
Technic 2024
Alt
75127 - The Gladiator
MOC-167830
(97 parts)
Star Wars 2023
Bugatti(?)
MOC-167715
(103 parts)
Creator 2023
75127 - Helicopter
MOC-166172
(92 parts)
Creator 2023
75127 - Fish
MOC-166068
(85 parts)
Creator 2023
75127 - The Ninja
MOC-165515
(92 parts)
Star Wars 2023
75127 - Mech
MOC-164963
(95 parts)
Star Wars 2023
75127 - Jet Microfighter
MOC-164897
(65 parts)
Star Wars 2023
Steamroller (Nano)
MOC-157840
(18 parts)
Creator 2023
31072 - Digger
MOC-156559
(100 parts)
Creator 2023
31072 - Motorboat
MOC-157143
(83 parts)
Creator 2023
31072 - Bike
MOC-157061
(100 parts)
Creator 2023
31072 - Dump Truck
MOC-156648
(99 parts)
Creator 2023
31072 - Light Plane
MOC-156574
(69 parts)
Creator 2023
Spectral Horned Dragon (Nano)
MOC-155639
(9 parts)
Ninjago 2023
Bat (Nano)
MOC-155638
(12 parts)
Creator 2023
Skeletal Vulture (Nano)
MOC-155636
(21 parts)
Creator 2023
Golden Dragon (Nano)
MOC-155634
(15 parts)
Creator 2023
SS Entomologist
MOC-154676
(224 parts)
Creator 2023
Chanukia (@LegoStoreIL)
MOC-132424
(187 parts)
Creator 2022
SNOT Shuttle Launch
MOC-130455
(208 parts)
Creator 2022
Pacifier Shrine
MOC-129678
(83 parts)
Creator 2022
Minecraft Sword (SNOT)
MOC-123893
(206 parts)
Minecraft 2022
Hot Wheels-ish car
MOC-119336
(60 parts)
System 2022
70321 - Steamy Roller
MOC-119127
(245 parts)
Nexo Knights 2022
Dreidel #4 - SNOT
MOC-117634
(39 parts)
Classic 2022
Bricktank2.0
MOC-116781
(131 parts)
Classic 2022
Bricktank
MOC-116679
(56 parts)
Creator 2022
Dreidel #3 - Classic
MOC-112766
(92 parts)
Games 2022
70321 - Magmar's X-Wing
MOC-112163
(336 parts)
Technic > Star Wars 2022
Dreidel #2 - Rainbow Star
MOC-110094
(30 parts)
Games 2022
70321 - Magma Cycle
MOC-109674
(266 parts)
Nexo Knights 2022
Dreidel #1
MOC-109600
(66 parts)
Games 2022
70321 - Magma Truck
MOC-102269
(367 parts)
Ninjago 2022
Brick Built Star
MOC-93382
(108 parts)
Sculptures 2021
Nano Burger Joint
MOC-91961
(141 parts)
Modular Buildings > Mini 2021
31058 - Peacock
MOC-88520
(147 parts)
Creator 2021
Easter Island Statue
MOC-88033
(85 parts)
Architecture 2021
31058 - Beetle
MOC-86675
(142 parts)
Creator 2021
DJDT

Time

Resource usage

Resource Value
User CPU time 669.280 msec
System CPU time 7.780 msec
Total CPU time 677.060 msec
Elapsed time 764.990 msec
Context switches 638 voluntary, 18 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 80.93 ms (27 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('LegoOri'))
 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('LegoOri')) LIMIT 21
 8.82

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(763)
  profile_user = ProxyUser.objects.get(username__iexact=username)
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
       "auth_group"."id",
       "auth_group"."name"
  FROM "auth_group"
 INNER JOIN "auth_user_groups"
    ON ("auth_group"."id" = "auth_user_groups"."group_id")
 WHERE "auth_user_groups"."user_id" IN (82556)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 (82556)
 0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(763)
  profile_user = ProxyUser.objects.get(username__iexact=username)
SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
 INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
 WHERE UPPER("auth_user"."username"::text) = UPPER('LegoOri')
 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('LegoOri') LIMIT 21
 0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(780)
  designer = Designer.objects.get_or_none(username__iexact=username)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)
SELECT COUNT(*) AS "__count"
  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" = 82556)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" = 82556)
2 similar queries. Duplicated 2 times. 		3.24

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(803)
  total_mocs = mocs.count()
SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "lego_theme"."id",
       "lego_theme"."parent_id",
       "lego_theme"."name",
       "lego_theme"."slug",
       "lego_theme"."set_count",
       "lego_theme"."t1_id",
       "lego_theme"."t1_name",
       "lego_theme"."t2_name",
       "lego_theme"."t3_name",
       "lego_theme"."lego_blurb",
       "lego_theme"."banner_img",
       "lego_theme"."descr",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "lego_inventory"."id",
       "lego_inventory"."set_id",
       "lego_inventory"."version",
       "lego_inventory"."name",
       "lego_inventory"."is_active",
       "lego_inventory"."num_parts",
       "lego_inventory"."num_versions",
       "lego_setphoto"."id",
       "lego_setphoto"."set_id",
       "lego_setphoto"."photo_type_id",
       "lego_setphoto"."submitted_by_id",
       "lego_setphoto"."timestamp",
       "lego_setphoto"."is_active",
       "lego_setphoto"."is_primary",
       T9."id",
       T9."set_num",
       T9."name",
       T9."year",
       T9."theme_id",
       T9."set_type",
       T9."num_parts",
       T9."default_inventory_id",
       T9."is_active",
       T9."is_accessory",
       T9."added_dt",
       T9."added_by_id",
       T9."last_modified_dt",
       T9."last_modified_by_id",
       T9."last_checked_for_bi",
       T9."descr",
       T9."primary_photo_id",
       T9."is_gear",
       T9."is_book",
       T9."search_vector",
       T9."mfhash_vector",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T13."id",
       T13."set_num",
       T13."name",
       T13."year",
       T13."theme_id",
       T13."set_type",
       T13."num_parts",
       T13."default_inventory_id",
       T13."is_active",
       T13."is_accessory",
       T13."added_dt",
       T13."added_by_id",
       T13."last_modified_dt",
       T13."last_modified_by_id",
       T13."last_checked_for_bi",
       T13."descr",
       T13."primary_photo_id",
       T13."is_gear",
       T13."is_book",
       T13."search_vector",
       T13."mfhash_vector",
       "lego_setstatstotal"."set_id",
       "lego_setstatstotal"."hits",
       "lego_setstatstotal"."builds",
       "lego_setstatstotal"."likes",
       "lego_setstatstotal"."bi_downloads",
       "lego_setstatstotal"."featured_hits",
       "lego_setstatstotal"."user_hits"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 INNER JOIN "lego_designer"
    ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id")
 INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T5
    ON ("lego_theme"."parent_id" = T5."id")
  LEFT OUTER JOIN "lego_theme" T6
    ON (T5."parent_id" = T6."id")
  LEFT OUTER JOIN "lego_inventory"
    ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id")
  LEFT OUTER JOIN "lego_setphoto"
    ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id")
  LEFT OUTER JOIN "lego_baseset" T9
    ON ("lego_setphoto"."set_id" = T9."id")
 INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
  LEFT OUTER JOIN "lego_baseset" T13
    ON ("lego_moc"."parent_set_1_id" = T13."id")
  LEFT OUTER JOIN "lego_setstatstotal"
    ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
 WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 82556)
 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" = 82556) ORDER BY "lego_baseset"."added_dt" DESC
 24.81

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(809)
  mocs = sort_user_mocs(request, mocs, default_sort_by=MocSorter.added.value, default_sort_dir='D')

/home/nathan/rb/site/./lego/filters.py in sort_user_mocs(1552)
  return MocSorter.sort_user_sets(user_sets, sort_by, sort_dir, group_by=group_by, group_by_db=group_by_db, apply_limit=apply_limit)

/home/nathan/rb/site/./lego/constants/mocs.py in sort_user_sets(133)
  return list(sets.order_by(*order_by_fields))
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
       "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug"
  FROM "taggit_tag"
 INNER JOIN "taggit_taggeditem"
    ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
 INNER JOIN "django_content_type"
    ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
 WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (196608, 24577, 184324, 43015, 63496, 30727, 22546, 45075, 28695, 110618, 20509, 49185, 32811, 59436, 24619, 43054, 90159, 24623, 22574, 24626, 18489, 45115, 41019, 38978, 61508, 18502, 20551, 18509, 30801, 94290, 28755, 32852, 69717, 41047, 73817, 198747, 20578, 184432, 59504, 22640, 45172, 196734, 39039, 22656, 49294, 22671, 18581, 75927, 24745, 28844, 22706, 37043, 41147, 73917, 18622, 35015, 43212, 22732, 108757, 47317, 20697, 32987, 75997, 22754, 198885, 41196, 24816, 67831, 20729, 26877, 67840, 18690, 30982, 22790, 49416, 41224, 31002, 22813, 33055, 43307, 43308, 155949, 24878, 39217, 20787, 86328, 22841, 31037, 80191, 22849, 194894, 43345, 22876, 76126, 22882, 20836, 26981, 24941, 18801, 24949, 153974, 104823, 39288, 24952, 20860, 22909, 264582, 29063, 20874, 88460, 194968, 84377, 72089, 72090, 22940, 22941, 24990, 20905, 37290, 20906, 49584, 18864, 43443, 45493, 20919, 18873, 18876, 55741, 94662, 47558, 22983, 72142, 41422, 27094, 33242, 104923, 16862, 25067, 25068, 39407, 27120, 23027, 25080, 41466, 18939, 49661, 68093, 18943, 135680, 35329, 20995, 92677, 25094, 20999, 23049, 18954, 74252, 41494, 18969, 35354, 94752, 31267, 234021, 231975, 29224, 23085, 18990, 100921, 33339, 21058, 23112, 29257, 180818, 76370, 47698, 29270, 27227, 41573, 139878, 37482, 25197, 23149, 21103, 43643, 17021, 60030, 47749, 23173, 25229, 39567, 35471, 35477, 21149, 39585, 68263, 23208, 234153, 29356, 19133, 29374, 31423, 21182, 33475, 37577, 21193, 139980, 76492, 23246, 39632, 99025, 37585, 27345, 74452, 103125, 236246, 103126, 19159, 17107, 45786, 41691, 25306, 70371, 92900, 45798, 25320, 21231, 35572, 29429, 19191, 27386, 25338, 23292, 54014, 47873, 45829, 21257, 19212, 21269, 41750, 23321, 23334, 35624, 23336, 31532, 19248, 103218, 70453, 21304, 33599, 27457, 29510, 21318, 58184, 43859, 31580, 29532, 95070, 25438, 17257, 70520, 70525, 21377, 35716, 33668, 70537, 19338, 27535, 39824, 43926, 21399, 25496, 25499, 115620, 45990, 19367, 23466, 41901, 89014, 76727, 23479, 29625, 56257, 19394, 25541, 43974, 27590, 31690, 39886, 23502, 46036, 68571, 35805, 29661, 19427, 19430, 25579, 19435, 29677, 19438, 39935, 19457, 44035, 27654, 19462, 31752, 25611, 41998, 25619, 29718, 48152, 21538, 19491, 78888, 234539, 19499, 103471, 48176, 23601, 37943, 21559, 37946, 35906, 23620, 21572, 29766, 31819, 23635, 142421, 27734, 35929, 33890, 19555, 19556, 23657, 21609, 40045, 19568, 185457, 95346, 31859, 21622, 19574, 46201, 195706, 29820, 35965, 29839, 54427, 38044, 23710, 42145, 91316, 25781, 44215, 23739, 31933, 15550, 185535, 44223, 15552, 15551, 76995, 19660, 21709, 66770, 17618, 40153, 40154, 36063, 29922, 23779, 42217, 183536, 27888, 36083, 23799, 19707, 31997, 23811, 15623, 15625, 101642, 40204, 60693, 29979, 68892, 27931, 21797, 29990, 97578, 44333, 99630, 21807, 40241, 15667, 23860, 17719, 44344, 17720, 17721, 17723, 15683, 142661, 15690, 183629, 23888, 34130, 34131, 103765, 42327, 19803, 44390, 25966, 23918, 42352, 21870, 36211, 73078, 25974, 34180, 32132, 28036, 97673, 132491, 87436, 23947, 40335, 26006, 28056, 52646, 32175, 38324, 28084, 17845, 26040, 44474, 38331, 48572, 15806, 73153, 40386, 15810, 15818, 19916, 24017, 21971, 132565, 24021, 15830, 40410, 24027, 30175, 114153, 21994, 15850, 24046, 19954, 83445, 48631, 60927, 15872, 40450, 237059, 32258, 17927, 36361, 226826, 19978, 42508, 34317, 34321, 15890, 24086, 44567, 17942, 15903, 26144, 46625, 24098, 140835, 73252, 22051, 34342, 17957, 15905, 288297, 15913, 28203, 40492, 15916, 110128, 40496, 22065, 17975, 77368, 24127, 26178, 75333, 28230, 24138, 34383, 20050, 24150, 20055, 30296, 18016, 104034, 83554, 153193, 22125, 44656, 32372, 69238, 28280, 48762, 40572, 36476, 20093, 30335, 22154, 24206, 79503, 26255, 30358, 24215, 22168, 20119, 73371, 42651, 26271, 36517, 20140, 24242, 30393, 24256, 22208, 24261, 67270, 28359, 20169, 32472, 36571, 20191, 28388, 22258, 24320, 30465, 22272, 44814, 42767, 36628, 28445, 22302, 26400, 75554, 67366, 24364, 18226, 24378, 22331, 30524, 40767, 20288, 307009, 16195, 46918, 32582, 46924, 24400, 22357, 22358, 24408, 28506, 28513, 59234, 26467, 75625, 71529, 147307, 28522, 18287, 22385, 24435, 85876, 16251, 235392, 132993, 40834, 40832, 20357, 239495, 53134, 24465, 44946, 30616, 22425, 24474, 32669, 135077, 22449, 75699, 44988, 47037, 22462, 182216, 182218, 182221, 182222, 124878, 88013, 30671, 22484, 20447, 36832, 32737, 22497, 28643, 57316, 20451, 67559, 18407, 22506, 94187, 90092, 81901, 71659, 40941, 18414, 20478))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 (196608, 24577, 184324, 43015, 63496, 30727, 22546, 45075, 28695, 110618, 20509, 49185, 32811, 59436, 24619, 43054, 90159, 24623, 22574, 24626, 18489, 45115, 41019, 38978, 61508, 18502, 20551, 18509, 30801, 94290, 28755, 32852, 69717, 41047, 73817, 198747, 20578, 184432, 59504, 22640, 45172, 196734, 39039, 22656, 49294, 22671, 18581, 75927, 24745, 28844, 22706, 37043, 41147, 73917, 18622, 35015, 43212, 22732, 108757, 47317, 20697, 32987, 75997, 22754, 198885, 41196, 24816, 67831, 20729, 26877, 67840, 18690, 30982, 22790, 49416, 41224, 31002, 22813, 33055, 43307, 43308, 155949, 24878, 39217, 20787, 86328, 22841, 31037, 80191, 22849, 194894, 43345, 22876, 76126, 22882, 20836, 26981, 24941, 18801, 24949, 153974, 104823, 39288, 24952, 20860, 22909, 264582, 29063, 20874, 88460, 194968, 84377, 72089, 72090, 22940, 22941, 24990, 20905, 37290, 20906, 49584, 18864, 43443, 45493, 20919, 18873, 18876, 55741, 94662, 47558, 22983, 72142, 41422, 27094, 33242, 104923, 16862, 25067, 25068, 39407, 27120, 23027, 25080, 41466, 18939, 49661, 68093, 18943, 135680, 35329, 20995, 92677, 25094, 20999, 23049, 18954, 74252, 41494, 18969, 35354, 94752, 31267, 234021, 231975, 29224, 23085, 18990, 100921, 33339, 21058, 23112, 29257, 180818, 76370, 47698, 29270, 27227, 41573, 139878, 37482, 25197, 23149, 21103, 43643, 17021, 60030, 47749, 23173, 25229, 39567, 35471, 35477, 21149, 39585, 68263, 23208, 234153, 29356, 19133, 29374, 31423, 21182, 33475, 37577, 21193, 139980, 76492, 23246, 39632, 99025, 37585, 27345, 74452, 103125, 236246, 103126, 19159, 17107, 45786, 41691, 25306, 70371, 92900, 45798, 25320, 21231, 35572, 29429, 19191, 27386, 25338, 23292, 54014, 47873, 45829, 21257, 19212, 21269, 41750, 23321, 23334, 35624, 23336, 31532, 19248, 103218, 70453, 21304, 33599, 27457, 29510, 21318, 58184, 43859, 31580, 29532, 95070, 25438, 17257, 70520, 70525, 21377, 35716, 33668, 70537, 19338, 27535, 39824, 43926, 21399, 25496, 25499, 115620, 45990, 19367, 23466, 41901, 89014, 76727, 23479, 29625, 56257, 19394, 25541, 43974, 27590, 31690, 39886, 23502, 46036, 68571, 35805, 29661, 19427, 19430, 25579, 19435, 29677, 19438, 39935, 19457, 44035, 27654, 19462, 31752, 25611, 41998, 25619, 29718, 48152, 21538, 19491, 78888, 234539, 19499, 103471, 48176, 23601, 37943, 21559, 37946, 35906, 23620, 21572, 29766, 31819, 23635, 142421, 27734, 35929, 33890, 19555, 19556, 23657, 21609, 40045, 19568, 185457, 95346, 31859, 21622, 19574, 46201, 195706, 29820, 35965, 29839, 54427, 38044, 23710, 42145, 91316, 25781, 44215, 23739, 31933, 15550, 185535, 44223, 15552, 15551, 76995, 19660, 21709, 66770, 17618, 40153, 40154, 36063, 29922, 23779, 42217, 183536, 27888, 36083, 23799, 19707, 31997, 23811, 15623, 15625, 101642, 40204, 60693, 29979, 68892, 27931, 21797, 29990, 97578, 44333, 99630, 21807, 40241, 15667, 23860, 17719, 44344, 17720, 17721, 17723, 15683, 142661, 15690, 183629, 23888, 34130, 34131, 103765, 42327, 19803, 44390, 25966, 23918, 42352, 21870, 36211, 73078, 25974, 34180, 32132, 28036, 97673, 132491, 87436, 23947, 40335, 26006, 28056, 52646, 32175, 38324, 28084, 17845, 26040, 44474, 38331, 48572, 15806, 73153, 40386, 15810, 15818, 19916, 24017, 21971, 132565, 24021, 15830, 40410, 24027, 30175, 114153, 21994, 15850, 24046, 19954, 83445, 48631, 60927, 15872, 40450, 237059, 32258, 17927, 36361, 226826, 19978, 42508, 34317, 34321, 15890, 24086, 44567, 17942, 15903, 26144, 46625, 24098, 140835, 73252, 22051, 34342, 17957, 15905, 288297, 15913, 28203, 40492, 15916, 110128, 40496, 22065, 17975, 77368, 24127, 26178, 75333, 28230, 24138, 34383, 20050, 24150, 20055, 30296, 18016, 104034, 83554, 153193, 22125, 44656, 32372, 69238, 28280, 48762, 40572, 36476, 20093, 30335, 22154, 24206, 79503, 26255, 30358, 24215, 22168, 20119, 73371, 42651, 26271, 36517, 20140, 24242, 30393, 24256, 22208, 24261, 67270, 28359, 20169, 32472, 36571, 20191, 28388, 22258, 24320, 30465, 22272, 44814, 42767, 36628, 28445, 22302, 26400, 75554, 67366, 24364, 18226, 24378, 22331, 30524, 40767, 20288, 307009, 16195, 46918, 32582, 46924, 24400, 22357, 22358, 24408, 28506, 28513, 59234, 26467, 75625, 71529, 147307, 28522, 18287, 22385, 24435, 85876, 16251, 235392, 132993, 40834, 40832, 20357, 239495, 53134, 24465, 44946, 30616, 22425, 24474, 32669, 135077, 22449, 75699, 44988, 47037, 22462, 182216, 182218, 182221, 182222, 124878, 88013, 30671, 22484, 20447, 36832, 32737, 22497, 28643, 57316, 20451, 67559, 18407, 22506, 94187, 90092, 81901, 71659, 40941, 18414, 20478))
 17.01

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(817)
  prefetch_related_objects(mocs, 'tags')
SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "lego_theme"."id",
       "lego_theme"."parent_id",
       "lego_theme"."name",
       "lego_theme"."slug",
       "lego_theme"."set_count",
       "lego_theme"."t1_id",
       "lego_theme"."t1_name",
       "lego_theme"."t2_name",
       "lego_theme"."t3_name",
       "lego_theme"."lego_blurb",
       "lego_theme"."banner_img",
       "lego_theme"."descr",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "lego_inventory"."id",
       "lego_inventory"."set_id",
       "lego_inventory"."version",
       "lego_inventory"."name",
       "lego_inventory"."is_active",
       "lego_inventory"."num_parts",
       "lego_inventory"."num_versions",
       "lego_setphoto"."id",
       "lego_setphoto"."set_id",
       "lego_setphoto"."photo_type_id",
       "lego_setphoto"."submitted_by_id",
       "lego_setphoto"."timestamp",
       "lego_setphoto"."is_active",
       "lego_setphoto"."is_primary",
       T9."id",
       T9."set_num",
       T9."name",
       T9."year",
       T9."theme_id",
       T9."set_type",
       T9."num_parts",
       T9."default_inventory_id",
       T9."is_active",
       T9."is_accessory",
       T9."added_dt",
       T9."added_by_id",
       T9."last_modified_dt",
       T9."last_modified_by_id",
       T9."last_checked_for_bi",
       T9."descr",
       T9."primary_photo_id",
       T9."is_gear",
       T9."is_book",
       T9."search_vector",
       T9."mfhash_vector",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T13."id",
       T13."set_num",
       T13."name",
       T13."year",
       T13."theme_id",
       T13."set_type",
       T13."num_parts",
       T13."default_inventory_id",
       T13."is_active",
       T13."is_accessory",
       T13."added_dt",
       T13."added_by_id",
       T13."last_modified_dt",
       T13."last_modified_by_id",
       T13."last_checked_for_bi",
       T13."descr",
       T13."primary_photo_id",
       T13."is_gear",
       T13."is_book",
       T13."search_vector",
       T13."mfhash_vector",
       "lego_setstatstotal"."set_id",
       "lego_setstatstotal"."hits",
       "lego_setstatstotal"."builds",
       "lego_setstatstotal"."likes",
       "lego_setstatstotal"."bi_downloads",
       "lego_setstatstotal"."featured_hits",
       "lego_setstatstotal"."user_hits"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 INNER JOIN "lego_designer"
    ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id")
 INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T5
    ON ("lego_theme"."parent_id" = T5."id")
  LEFT OUTER JOIN "lego_theme" T6
    ON (T5."parent_id" = T6."id")
  LEFT OUTER JOIN "lego_inventory"
    ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id")
  LEFT OUTER JOIN "lego_setphoto"
    ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id")
  LEFT OUTER JOIN "lego_baseset" T9
    ON ("lego_setphoto"."set_id" = T9."id")
 INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
  LEFT OUTER JOIN "lego_baseset" T13
    ON ("lego_moc"."parent_set_1_id" = T13."id")
  LEFT OUTER JOIN "lego_setstatstotal"
    ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
 WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 82556)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" = 82556)
 12.86

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(818)
  drill_downs = get_set_drill_downs(mocs, request.GET, all_items=all_mocs)

/home/nathan/rb/site/./lego/filters.py in get_set_drill_downs(1267)
  fields['Themes'] = get_theme_drill_down(sets, params=params, all_items=all_items)

/home/nathan/rb/site/./lego/filters.py in get_theme_drill_down(1069)
  drill_down = get_drill_down(items, params, 'theme', filter_fn, all_items=all_items)

/home/nathan/rb/site/./lego/filters.py in get_drill_down(958)
  for item in all_items:
SELECT SUM("lego_setstatstotal"."likes") AS "likes__sum"
  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" = 82556)
       )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" = 82556))
2 similar queries. Duplicated 2 times. 		2.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(836)
  designer_stats = designer.get_stats()

/home/nathan/rb/site/./lego/models/designers.py in get_stats(79)
  num_likes = SetStatsTotal.objects.filter(set__in=Moc.objects.filter(designer=self)).aggregate(Sum('likes'))['likes__sum'] or 0
SELECT COUNT(*) AS "__count"
  FROM "lego_designerfollower"
 WHERE "lego_designerfollower"."designer_id" = 82556SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 82556
2 similar queries. Duplicated 2 times. 		3.37

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(836)
  designer_stats = designer.get_stats()

/home/nathan/rb/site/./lego/models/designers.py in get_stats(82)
  'num_followers': self.get_num_followers_formatted(),

/home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(231)
  i = DesignerFollower.objects.filter(designer_id=self.id).count()
SELECT "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent"
  FROM "accounts_userplan"
 WHERE "accounts_userplan"."user_id" = 82556
 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 82556 LIMIT 21
 0.15

Connection: default

Transaction status: In transaction

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(848)
  designer_ga_tracking_id = designer.get_ga_tracking_id()

/home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(88)
  if self.plan.is_designer():

/usr/lib/python3.10/contextlib.py in inner(79)
  return func(*args, **kwds)

/home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36)
  .__get__(instance, instance_type)
SELECT "plans_plan"."id",
       "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(848)
  designer_ga_tracking_id = designer.get_ga_tracking_id()

/home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(88)
  if self.plan.is_designer():

/home/nathan/rb/site/./accounts/models/users.py in is_designer(381)
  return self.plan.is_designer()
SELECT "lego_designerdiscount"."id",
       "lego_designerdiscount"."designer_id",
       "lego_designerdiscount"."name",
       "lego_designerdiscount"."start_date",
       "lego_designerdiscount"."end_date",
       "lego_designerdiscount"."discount_pct",
       "lego_designerdiscount"."mocs"
  FROM "lego_designerdiscount"
 WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T10:15:59.741513+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T10:15:59.741510+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['307009', '288297', '264582', '239495', '237059', '236246', '235392', '234539', '234153', '234021', '231975', '226826', '198885', '198747', '196734', '196608', '195706', '194968', '194894', '185535', '185457', '184432', '184324', '183629', '183536', '182222', '182221', '182218', '182216', '180818', '155949', '153974', '153193', '147307', '142661', '142421', '140835', '139980', '139878', '135680', '135077', '132993', '132565', '132491', '124878', '115620', '114153', '110618', '110128', '108757']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T10:15:59.741513+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T10:15:59.741510+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['307009', '288297', '264582', '239495', '237059', '236246', '235392', '234539', '234153', '234021', '231975', '226826', '198885', '198747', '196734', '196608', '195706', '194968', '194894', '185535', '185457', '184432', '184324', '183629', '183536', '182222', '182221', '182218', '182216', '180818', '155949', '153974', '153193', '147307', '142661', '142421', '140835', '139980', '139878', '135680', '135077', '132993', '132565', '132491', '124878', '115620', '114153', '110618', '110128', '108757']]::jsonb[])))
 1.60

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(855)
  Moc.attach_discount_to_mocs(mocs)

/home/nathan/rb/site/./lego/models/sets.py in attach_discount_to_mocs(1531)
  for discount in discounts:
SELECT "lego_mocswitherrors"."moc_id"
  FROM "lego_mocswitherrors"
 WHERE "lego_mocswitherrors"."moc_id" IN (307009, 288297, 236246, 235392, 234539, 234153, 234021, 231975, 226826, 198885, 196734, 196608, 195706, 194968, 194894, 185457, 184432, 184324, 183629, 183536, 142421, 135077, 132565, 124878, 110618, 108757)SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" IN (307009, 288297, 236246, 235392, 234539, 234153, 234021, 231975, 226826, 198885, 196734, 196608, 195706, 194968, 194894, 185457, 184432, 184324, 183629, 183536, 142421, 135077, 132565, 124878, 110618, 108757)
 0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(856)
  Moc.attach_alternate_to_mocs(mocs)

/home/nathan/rb/site/./lego/models/sets.py in attach_alternate_to_mocs(1568)
  errors = set(errors)
SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM "countries_plus_country"
 WHERE "countries_plus_country"."iso" = 'US'
 LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
 0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./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" = 82556)
 LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 82556) LIMIT 21
 0.29

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)
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" = 82556
 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 82556 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1
2 similar queries. Duplicated 2 times. 		0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
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" = 82556
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 82556 LIMIT 21
 0.20

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
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" = 82556)
 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" = 82556) LIMIT 1
 0.23

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./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 "accounts_userstats"."id",
       "accounts_userstats"."user_id",
       "accounts_userstats"."num_profile_views",
       "accounts_userstats"."num_shopper_scans",
       "accounts_userstats"."total_is_stale",
       "accounts_userstats"."total_sets",
       "accounts_userstats"."total_loose_parts",
       "accounts_userstats"."total_lost_set_parts",
       "accounts_userstats"."total_figures",
       "accounts_userstats"."total_all_parts"
  FROM "accounts_userstats"
 WHERE "accounts_userstats"."user_id" = 82556
 LIMIT 21SELECT ••• FROM "accounts_userstats" WHERE "accounts_userstats"."user_id" = 82556 LIMIT 21
 0.32

Connection: default

Transaction status: In transaction

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(380)
  return self.stats.get_num_parts_summary()

/usr/lib/python3.10/contextlib.py in inner(79)
  return func(*args, **kwds)

/home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36)
  .__get__(instance, instance_type)
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 %}
32
33 {% if request.user == profile_user or privacy_options.is_public_plan %}
34 {% if not profile_user.plan.plan.is_free %}

/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.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)
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" = 82556
 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 82556 LIMIT 21
 0.19

Connection: default

Transaction status: In transaction

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/usr/lib/python3.10/contextlib.py in inner(79)
  return func(*args, **kwds)

/home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36)
  .__get__(instance, instance_type)
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 "accounts_userbadge"."id",
       "accounts_userbadge"."user_id",
       "accounts_userbadge"."badge_id"
  FROM "accounts_userbadge"
 WHERE "accounts_userbadge"."id" = 73144
 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 73144 LIMIT 21
 0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)
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 "lego_badge"."id",
       "lego_badge"."code",
       "lego_badge"."level",
       "lego_badge"."name",
       "lego_badge"."descr",
       "lego_badge"."num_users"
  FROM "lego_badge"
 WHERE "lego_badge"."id" = 3
 LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 3 LIMIT 21
 0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)
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" = 82556)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" = 82556)
2 similar queries. Duplicated 2 times. 		1.32

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_mocs(866)
  self._num_mocs = Moc.objects.filter(designer=self.designer).count()
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" = 82556)
       )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" = 82556))
2 similar queries. Duplicated 2 times. 		2.04

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./lego/models/designers.py in get_stats(79)
  num_likes = SetStatsTotal.objects.filter(set__in=Moc.objects.filter(designer=self)).aggregate(Sum('likes'))['likes__sum'] or 0
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" = 82556SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 82556
2 similar queries. Duplicated 2 times. 		0.94

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./lego/models/designers.py in get_stats(82)
  'num_followers': self.get_num_followers_formatted(),

/home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(231)
  i = DesignerFollower.objects.filter(designer_id=self.id).count()
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" = 82556
 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 82556 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1
2 similar queries. Duplicated 2 times. 		0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(877)
  return render(request, 'accounts/user_mocs.html', context)

/home/nathan/rb/site/./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.