MOCs Designed by Berth

Berth
Showing 50 MOCs (616 total quantity)
75395 Starship #13
MOC-226478
(27 parts)
Seasonal > Advent > Star Wars 2025
75395 Gunship #2
MOC-228065
(26 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #12
MOC-224424
(29 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #11
MOC-226158
(52 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #10
MOC-225586
(51 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #9
MOC-225081
(24 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #8
MOC-224903
(35 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #7
MOC-224650
(35 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #6
MOC-224349
(28 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #5
MOC-221527
(44 parts)
Seasonal > Advent > Star Wars 2025
75395 Spaceship #4
MOC-223764
(35 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #3
MOC-223687
(23 parts)
Seasonal > Advent > Star Wars 2025
75395 Motojet
MOC-221906
(34 parts)
Seasonal > Advent > Star Wars 2025
75188 Starfighter
MOC-221799
(454 parts)
Star Wars 2025
75395 Gunship
MOC-221743
(30 parts)
Seasonal > Advent > Star Wars 2025
75395 Starship #2
MOC-221629
(37 parts)
Seasonal > Advent > Star Wars 2025
75323 Freighter
MOC-220904
(624 parts)
Star Wars 2025
75395 Starship #1
MOC-220549
(35 parts)
Seasonal > Advent > Star Wars 2025
75395 Day 14 : Freighter
MOC-207330
(16 parts)
Seasonal > Advent > Star Wars 2025
75395 Day 22 : Spaceship
MOC-207313
(14 parts)
Seasonal > Advent > Star Wars 2025
75395 Day 23 : Oldtimer
MOC-207309
(19 parts)
Seasonal > Advent > Star Wars 2025
75395 Day 9 : Spaceship #3
MOC-205776
(19 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 16 : Spaceship #2
MOC-205698
(25 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 24 : Spaceship
MOC-205681
(16 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 22 : Spaceship
MOC-205470
(15 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 9 : Racer 2
MOC-205085
(18 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 19 : Spaceship
MOC-204829
(12 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 14 : Speeder
MOC-204781
(13 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 16 : Spaceship
MOC-204690
(23 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 14 ; Racer
MOC-203312
(18 parts)
Seasonal > Advent > Star Wars 2024
912405 Spaceship
MOC-204592
(41 parts)
Star Wars 2024
75395 Day 13 : Red wing
MOC-204413
(15 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 12 : grey wing
MOC-202992
(13 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 9 : Racer
MOC-202977
(20 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 6 : Shuttle
MOC-204047
(11 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 1 : Starfighter #2
MOC-203525
(17 parts)
Seasonal > Advent > Star Wars 2024
75395 Day3 : Black Wing
MOC-203433
(8 parts)
Seasonal > Advent > Star Wars 2024
75395 Day 1 : Starfighter
MOC-203071
(16 parts)
Seasonal > Advent > Star Wars 2024
75366 Starship #3
MOC-191644
(40 parts)
Seasonal > Advent > Star Wars 2024
75340 Starship #10
MOC-191502
(43 parts)
Seasonal > Advent > Star Wars 2024
75266 Starship
MOC-186559
(31 parts)
Star Wars 2024
75307 Starship #9
MOC-183891
(24 parts)
Seasonal > Advent > Star Wars 2024
75340 Starship #9
MOC-183724
(35 parts)
Star Wars 2024
75178 Spacehopper
MOC-174558
(234 parts)
Star Wars 2024
75366 Spaceship #2
MOC-172119
(35 parts)
Star Wars 2024
75366 Spaceship #1
MOC-170962
(28 parts)
Star Wars 2024
75366 Day 2 : Spaceship #2
MOC-170818
(14 parts)
Star Wars 2024
75325 Starfighter
MOC-169289
(301 parts)
Star Wars 2024
75366 Day 9 : Droid starfighter
MOC-167829
(11 parts)
Seasonal > Advent > Star Wars 2023
75366 Day 13 : Starfighter
MOC-167718
(18 parts)
Seasonal > Advent > Star Wars 2023
DJDT

Time

Resource usage

Resource Value
User CPU time 671.183 msec
System CPU time 9.435 msec
Total CPU time 680.618 msec
Elapsed time 763.839 msec
Context switches 483 voluntary, 176 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 75.65 ms (25 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('Berth'))
 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('Berth')) LIMIT 21
 8.95

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 (41458)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 (41458)
 0.26

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('Berth')
 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('Berth') LIMIT 21
 0.26

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" = 41458)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" = 41458)
2 similar queries. Duplicated 2 times. 		3.32

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" = 41458)
 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" = 41458) ORDER BY "lego_baseset"."added_dt" DESC
 15.89

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 (14337, 14342, 49159, 30734, 22542, 14352, 182289, 20499, 14360, 14364, 159777, 20513, 14370, 77860, 14373, 26664, 14383, 14385, 94259, 55348, 249911, 278585, 84026, 61499, 61500, 14395, 14398, 110658, 59461, 20550, 14408, 22609, 112726, 14425, 49242, 198750, 108638, 14436, 247913, 14442, 14446, 22642, 110707, 14453, 30844, 39038, 14463, 14469, 77959, 22664, 80010, 14476, 61587, 14483, 276630, 30871, 82073, 155802, 14489, 49310, 30881, 14500, 182439, 84135, 14503, 282796, 14510, 22707, 18615, 14530, 116935, 14538, 20684, 118989, 26842, 14555, 108766, 272607, 49375, 198883, 110819, 53476, 14563, 14571, 26864, 14578, 80125, 14591, 160001, 155906, 106753, 276740, 200964, 86277, 22796, 119055, 18708, 30999, 59675, 14621, 55585, 61738, 26922, 14638, 22831, 282928, 14642, 35133, 33085, 108863, 78144, 14656, 92486, 203079, 41293, 41295, 57681, 14673, 14689, 39270, 22893, 14707, 110964, 160120, 14714, 49531, 78217, 14729, 80267, 27021, 14736, 14737, 18838, 14743, 49565, 14749, 20900, 53685, 156085, 106933, 154044, 14780, 22974, 113097, 14794, 27088, 178645, 117206, 20967, 59885, 203248, 49653, 23036, 55805, 107011, 119303, 14857, 84500, 27157, 47639, 47640, 47642, 277021, 57890, 117283, 82478, 78391, 62007, 47672, 49722, 111163, 33338, 27196, 41559, 176732, 14940, 250467, 47730, 47731, 223860, 35447, 17018, 197253, 78470, 84617, 49807, 123539, 23194, 27297, 15010, 60067, 15011, 15009, 111278, 162484, 17081, 29372, 86717, 53951, 41665, 174789, 15048, 19160, 117470, 279265, 19172, 17125, 27366, 15080, 19180, 107247, 76527, 84730, 17146, 158462, 248578, 29447, 15114, 111374, 176914, 25364, 19225, 62239, 117541, 25390, 17205, 25405, 15174, 160585, 219978, 56140, 119629, 19277, 15190, 47959, 107352, 107356, 58217, 15215, 27506, 25463, 117636, 17288, 250761, 21390, 84883, 62355, 250779, 60317, 168866, 25511, 23463, 17323, 27566, 154549, 48058, 29634, 15300, 175045, 31688, 107465, 25544, 111570, 54229, 117738, 250860, 60399, 82936, 15352, 119803, 80895, 207874, 25603, 220174, 76819, 109593, 85018, 27684, 89127, 48167, 29739, 13359, 13360, 13362, 13368, 13369, 13370, 13373, 58430, 76867, 173128, 52302, 13396, 27733, 13400, 117849, 13402, 13403, 21600, 13412, 48231, 62569, 13421, 13425, 13432, 13439, 54400, 29824, 13440, 13441, 13444, 60552, 21641, 13452, 25742, 13463, 109724, 81060, 48299, 13484, 119982, 107694, 154801, 56498, 13498, 113854, 83135, 249040, 277713, 273618, 249041, 13520, 13528, 77017, 249055, 13543, 48373, 25849, 77053, 111869, 177407, 23820, 60686, 13582, 107792, 62737, 13584, 66837, 13589, 171289, 118049, 79141, 21798, 13606, 13611, 13621, 15670, 30010, 13626, 48450, 109891, 48451, 13636, 13639, 107849, 48459, 83277, 34126, 25933, 13646, 19796, 157013, 13653, 79196, 197986, 159074, 159076, 13669, 273767, 58727, 15721, 13676, 13681, 13683, 13694, 13696, 13705, 48523, 25996, 48525, 62862, 21899, 52624, 13712, 13710, 77203, 253336, 13722, 13725, 13727, 13729, 253352, 247210, 79275, 19885, 13745, 26035, 26036, 77237, 83382, 13750, 13749, 253370, 13759, 249283, 277957, 15815, 273864, 13771, 13773, 48596, 15829, 13782, 230875, 28126, 13792, 110050, 60900, 13796, 159207, 15856, 13809, 13815, 13819, 54782, 26114, 108041, 13842, 79380, 54805, 13844, 48663, 19992, 15896, 114202, 13849, 13855, 13856, 249381, 13862, 280103, 85546, 13871, 77362, 13876, 13879, 13880, 13881, 13885, 13888, 13895, 13899, 26188, 249423, 24144, 108113, 13906, 61011, 112212, 52819, 13910, 13911, 13905, 13919, 26210, 177763, 13924, 83560, 13928, 274026, 145003, 13931, 13934, 20080, 13936, 13943, 13956, 56966, 48776, 13964, 16013, 28302, 93842, 13970, 30356, 231062, 112279, 145051, 87708, 108191, 36513, 13988, 13991, 30376, 61101, 28333, 13997, 28337, 249523, 28339, 14004, 159416, 14011, 196284, 48832, 16067, 157382, 14024, 14028, 22223, 120529, 175827, 28377, 14041, 42717, 83678, 14045, 28387, 14057, 22252, 93935, 14068, 249591, 14073, 14079, 112387, 59140, 22275, 155403, 14092, 272147, 108309, 14104, 14106, 77599, 280353, 22306, 14122, 48939, 14133, 16183, 22334, 278338, 20291, 14149, 14154, 36684, 120657, 57171, 24403, 16211, 14163, 14171, 94060, 110446, 22382, 14208, 14217, 53135, 30607, 16271, 83858, 14225, 14228, 28565, 112534, 16277, 14229, 14233, 57244, 26524, 22428, 30624, 14240, 77732, 63402, 20396, 16300, 14254, 26543, 14252, 14258, 94139, 178108, 178109, 49084, 14270, 30657, 14273, 14275, 16326, 155592, 14281, 14285, 14294, 22487, 30680, 61401, 14298, 204763, 14314, 14317, 14326, 28663, 14330, 247804))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 (14337, 14342, 49159, 30734, 22542, 14352, 182289, 20499, 14360, 14364, 159777, 20513, 14370, 77860, 14373, 26664, 14383, 14385, 94259, 55348, 249911, 278585, 84026, 61499, 61500, 14395, 14398, 110658, 59461, 20550, 14408, 22609, 112726, 14425, 49242, 198750, 108638, 14436, 247913, 14442, 14446, 22642, 110707, 14453, 30844, 39038, 14463, 14469, 77959, 22664, 80010, 14476, 61587, 14483, 276630, 30871, 82073, 155802, 14489, 49310, 30881, 14500, 182439, 84135, 14503, 282796, 14510, 22707, 18615, 14530, 116935, 14538, 20684, 118989, 26842, 14555, 108766, 272607, 49375, 198883, 110819, 53476, 14563, 14571, 26864, 14578, 80125, 14591, 160001, 155906, 106753, 276740, 200964, 86277, 22796, 119055, 18708, 30999, 59675, 14621, 55585, 61738, 26922, 14638, 22831, 282928, 14642, 35133, 33085, 108863, 78144, 14656, 92486, 203079, 41293, 41295, 57681, 14673, 14689, 39270, 22893, 14707, 110964, 160120, 14714, 49531, 78217, 14729, 80267, 27021, 14736, 14737, 18838, 14743, 49565, 14749, 20900, 53685, 156085, 106933, 154044, 14780, 22974, 113097, 14794, 27088, 178645, 117206, 20967, 59885, 203248, 49653, 23036, 55805, 107011, 119303, 14857, 84500, 27157, 47639, 47640, 47642, 277021, 57890, 117283, 82478, 78391, 62007, 47672, 49722, 111163, 33338, 27196, 41559, 176732, 14940, 250467, 47730, 47731, 223860, 35447, 17018, 197253, 78470, 84617, 49807, 123539, 23194, 27297, 15010, 60067, 15011, 15009, 111278, 162484, 17081, 29372, 86717, 53951, 41665, 174789, 15048, 19160, 117470, 279265, 19172, 17125, 27366, 15080, 19180, 107247, 76527, 84730, 17146, 158462, 248578, 29447, 15114, 111374, 176914, 25364, 19225, 62239, 117541, 25390, 17205, 25405, 15174, 160585, 219978, 56140, 119629, 19277, 15190, 47959, 107352, 107356, 58217, 15215, 27506, 25463, 117636, 17288, 250761, 21390, 84883, 62355, 250779, 60317, 168866, 25511, 23463, 17323, 27566, 154549, 48058, 29634, 15300, 175045, 31688, 107465, 25544, 111570, 54229, 117738, 250860, 60399, 82936, 15352, 119803, 80895, 207874, 25603, 220174, 76819, 109593, 85018, 27684, 89127, 48167, 29739, 13359, 13360, 13362, 13368, 13369, 13370, 13373, 58430, 76867, 173128, 52302, 13396, 27733, 13400, 117849, 13402, 13403, 21600, 13412, 48231, 62569, 13421, 13425, 13432, 13439, 54400, 29824, 13440, 13441, 13444, 60552, 21641, 13452, 25742, 13463, 109724, 81060, 48299, 13484, 119982, 107694, 154801, 56498, 13498, 113854, 83135, 249040, 277713, 273618, 249041, 13520, 13528, 77017, 249055, 13543, 48373, 25849, 77053, 111869, 177407, 23820, 60686, 13582, 107792, 62737, 13584, 66837, 13589, 171289, 118049, 79141, 21798, 13606, 13611, 13621, 15670, 30010, 13626, 48450, 109891, 48451, 13636, 13639, 107849, 48459, 83277, 34126, 25933, 13646, 19796, 157013, 13653, 79196, 197986, 159074, 159076, 13669, 273767, 58727, 15721, 13676, 13681, 13683, 13694, 13696, 13705, 48523, 25996, 48525, 62862, 21899, 52624, 13712, 13710, 77203, 253336, 13722, 13725, 13727, 13729, 253352, 247210, 79275, 19885, 13745, 26035, 26036, 77237, 83382, 13750, 13749, 253370, 13759, 249283, 277957, 15815, 273864, 13771, 13773, 48596, 15829, 13782, 230875, 28126, 13792, 110050, 60900, 13796, 159207, 15856, 13809, 13815, 13819, 54782, 26114, 108041, 13842, 79380, 54805, 13844, 48663, 19992, 15896, 114202, 13849, 13855, 13856, 249381, 13862, 280103, 85546, 13871, 77362, 13876, 13879, 13880, 13881, 13885, 13888, 13895, 13899, 26188, 249423, 24144, 108113, 13906, 61011, 112212, 52819, 13910, 13911, 13905, 13919, 26210, 177763, 13924, 83560, 13928, 274026, 145003, 13931, 13934, 20080, 13936, 13943, 13956, 56966, 48776, 13964, 16013, 28302, 93842, 13970, 30356, 231062, 112279, 145051, 87708, 108191, 36513, 13988, 13991, 30376, 61101, 28333, 13997, 28337, 249523, 28339, 14004, 159416, 14011, 196284, 48832, 16067, 157382, 14024, 14028, 22223, 120529, 175827, 28377, 14041, 42717, 83678, 14045, 28387, 14057, 22252, 93935, 14068, 249591, 14073, 14079, 112387, 59140, 22275, 155403, 14092, 272147, 108309, 14104, 14106, 77599, 280353, 22306, 14122, 48939, 14133, 16183, 22334, 278338, 20291, 14149, 14154, 36684, 120657, 57171, 24403, 16211, 14163, 14171, 94060, 110446, 22382, 14208, 14217, 53135, 30607, 16271, 83858, 14225, 14228, 28565, 112534, 16277, 14229, 14233, 57244, 26524, 22428, 30624, 14240, 77732, 63402, 20396, 16300, 14254, 26543, 14252, 14258, 94139, 178108, 178109, 49084, 14270, 30657, 14273, 14275, 16326, 155592, 14281, 14285, 14294, 22487, 30680, 61401, 14298, 204763, 14314, 14317, 14326, 28663, 14330, 247804))
 10.72

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" = 41458)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" = 41458)
 13.08

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" = 41458)
       )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" = 41458))
2 similar queries. Duplicated 2 times. 		2.59

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" = 41458SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 41458
2 similar queries. Duplicated 2 times. 		11.03

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" = 41458
 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 41458 LIMIT 21
 0.19

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-22T06:23:20.697568+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:23:20.697566+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['282928', '282796', '280353', '280103', '279265', '278585', '278338', '277957', '277713', '277021', '276740', '276630', '274026', '273864', '273767', '273618', '272607', '272147', '253370', '253352', '253336', '250860', '250779', '250761', '250467', '249911', '249591', '249523', '249423', '249381', '249283', '249055', '249041', '249040', '248578', '247913', '247804', '247210', '231062', '230875', '223860', '220174', '219978', '207874', '204763', '203248', '203079', '200964', '198883', '198750']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T06:23:20.697568+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:23:20.697566+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['282928', '282796', '280353', '280103', '279265', '278585', '278338', '277957', '277713', '277021', '276740', '276630', '274026', '273864', '273767', '273618', '272607', '272147', '253370', '253352', '253336', '250860', '250779', '250761', '250467', '249911', '249591', '249523', '249423', '249381', '249283', '249055', '249041', '249040', '248578', '247913', '247804', '247210', '231062', '230875', '223860', '220174', '219978', '207874', '204763', '203248', '203079', '200964', '198883', '198750']]::jsonb[])))
 1.80

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 (282928, 282796, 280353, 280103, 279265, 278585, 278338, 277713, 277021, 276740, 276630, 274026, 273864, 273767, 273618, 272607, 272147, 253370, 253352, 253336, 250860, 250779, 250761, 250467, 249911, 249591, 249523, 249423, 249381, 249283, 249055, 249041, 249040, 248578, 247913, 247804, 247210, 231062, 230875, 223860, 220174, 219978, 207874, 204763, 203248, 203079, 200964, 198883, 198750)SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" IN (282928, 282796, 280353, 280103, 279265, 278585, 278338, 277713, 277021, 276740, 276630, 274026, 273864, 273767, 273618, 272607, 272147, 253370, 253352, 253336, 250860, 250779, 250761, 250467, 249911, 249591, 249523, 249423, 249381, 249283, 249055, 249041, 249040, 248578, 247913, 247804, 247210, 231062, 230875, 223860, 220174, 219978, 207874, 204763, 203248, 203079, 200964, 198883, 198750)
 0.17

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.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)

/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" = 41458)
 LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 41458) 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" = 41458
 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 41458 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]
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 "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" = 41458
 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 41458 LIMIT 21
 0.17

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" = 23341
 LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 23341 LIMIT 21
 0.27

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.08

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_mocs(865)
  if hasattr(self, 'designer'):
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 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" = 41458)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" = 41458)
2 similar queries. Duplicated 2 times. 		1.48

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" = 41458)
       )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" = 41458))
2 similar queries. Duplicated 2 times. 		3.39

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" = 41458SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 41458
2 similar queries. Duplicated 2 times. 		0.77

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" = 41458
 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 41458 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1
2 similar queries. Duplicated 2 times. 		0.25

Connection: default

Transaction status: Idle

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

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