Showing 50 MOCs (742 total quantity)
Warhammer 40k Primaris Apothecary
MOC-245784
(50 parts)
Other 2025
31102 A-10 Thunderbolt (''Warthog'')
MOC-243056
(174 parts)
Creator > Creator 3-in-1 2025
42197 A-10 Thunderbolt (''Warthog'')
MOC-237648
(85 parts)
Technic 2025
30708 Starfighter
MOC-236964
(49 parts)
Space 2025
30709 A-10 Thunderbolt (''Warthog'')
MOC-236963
(49 parts)
Other 2025
30708 N-1 Starfighter (2 versions)
MOC-233745
(66 parts)
Star Wars 2025
912405 A-10 Thunderbolt (''Warthog'')
MOC-233743
(44 parts)
Other 2025
30708 Tank
MOC-232135
(52 parts)
Other 2025
30708 Dropship #3
MOC-231038
(75 parts)
Other 2025
30708 Imperial Star-Destroyer
MOC-231037
(66 parts)
Star Wars 2025
31159 A-10 Thunderbolt (''Warthog'')
MOC-228104
(134 parts)
Creator > Creator 3-in-1 2025
30708 Venator-Class Republic Attack Cruiser (2 versions)
MOC-229489
(72 parts)
Star Wars 2025
2x912055 Dreadnought
MOC-229276
(56 parts)
Other 2025
30708 Dropship #2
MOC-229274
(69 parts)
Other 2025
30708 Dropship #1 (2 versions)
MOC-228867
(74 parts)
Other 2025
30708 Droid Gunship
MOC-226509
(74 parts)
Star Wars 2025
30708 A-10 Thunderbolt (''Warthog'')
MOC-226508
(72 parts)
Other 2025
77941 A-10 Thunderbolt (''Warthog'') 2 versions
MOC-223057
(117 parts)
Creator > Creator 3-in-1 2025
77940 A-10 Thunderbolt (''Warthog'') 2 versions
MOC-223056
(117 parts)
Creator > Creator 3-in-1 2025
31058 A-10 Thunderbolt (''Warthog'') 2 versions
MOC-223055
(123 parts)
Creator > Creator 3-in-1 2025
31088 A-10 Thunderbolt (''Warthog'')
MOC-217968
(187 parts)
Creator > Creator 3-in-1 2025
31057 A-10 Thunderbolt (''Warthog'')
MOC-216595
(76 parts)
Creator > Creator 3-in-1 2025
Warhammer 40k Invictor Tactical Warsuit
MOC-214408
(916 parts)
Other 2025
31092 A-10 Thunderbolt (''Warthog'')
MOC-211292
(106 parts)
Creator > Creator 3-in-1 2025
11950 A-10 Thunderbolt (''Warthog'')
MOC-211196
(29 parts)
Creator 2025
31087 - A-10 Thunderbolt (''Warthog'')
MOC-209801
(113 parts)
Creator > Creator 3-in-1 2025
Micro Droid Gunship
MOC-206137
(92 parts)
Star Wars 2025
42163 A-10 Thunderbolt (''Warthog'')
MOC-203070
(87 parts)
Technic 2024
30669 A-10 Thunderbolt (''Warthog'')
MOC-200168
(45 parts)
Creator > Creator 3-in-1 2024
31134 A-10 Thunderbolt (''Warthog'')
MOC-196517
(106 parts)
Creator > Creator 3-in-1 2024
31145 A-10 Thunderbolt (''Warthog'') 2 versions
MOC-193162
(106 parts)
Creator > Creator 3-in-1 2024
31140 A-10 Thunderbolt (''Warthog'')
MOC-191301
(114 parts)
Creator > Creator 3-in-1 2024
30659 A-10 Thunderbolt (''Warthog'')
MOC-189929
(44 parts)
Other 2024
Warhammer 40k Redemptor Dreadnought
MOC-189541
(196 parts)
Other 2024
2x912055 X-Wing
MOC-188711
(42 parts)
Star Wars 2024
Warhammer 40k Dreadnought
MOC-186816
(175 parts)
Other 2024
30682 Armored Car
MOC-184699
(67 parts)
Technic 2024
30450 A-10 Thunderbolt (''Warthog'')
MOC-185730
(50 parts)
Other 2024
40220 A-10 Thunderbolt (''Warthog'')
MOC-184945
(74 parts)
Creator 2024
30682 A-10 Thunderbolt (''Warthog'')
MOC-182290
(55 parts)
Technic 2024
30683 A-10 Thunderbolt (''Warthog'')
MOC-181268
(54 parts)
Other 2024
Samurai Jack & Aku
MOC-179573
(145 parts)
Other 2024
30666 A-10 Thunderbolt (''Warthog'')
MOC-178753
(69 parts)
Creator > Creator 3-in-1 2024
Warhammer 40k Terminator
MOC-177437
(53 parts)
Other 2024
30435 A-10 Thunderbolt (''Warthog'')
MOC-174508
(53 parts)
Other 2024
Warhammer 40k Space Marine
MOC-174214
(65 parts)
Other 2024
7803 A-10 Thunderbolt (''Warthog'')
MOC-174213
(37 parts)
Creator 2024
30386 A-10 Thunderbolt (''Warthog'')
MOC-167618
(71 parts)
Other 2023
30342 A-10 Thunderbolt (''Warthog'')
MOC-167617
(65 parts)
Other 2023
30278 A-10 Thunderbolt (''Warthog'')
MOC-167616
(59 parts)
Other 2023
DJDT

Time

Resource usage

Resource Value
User CPU time 862.945 msec
System CPU time 16.039 msec
Total CPU time 878.984 msec
Elapsed time 981.097 msec
Context switches 541 voluntary, 190 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 97.46 ms (28 queries including 12 similar and 12 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('meregt'))
 LIMIT
21
SELECT ••• FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('meregt')) LIMIT 21
8.87

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(763)
  profile_user = ProxyUser.objects.get(username__iexact=username)

SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
       "auth_group"."id",
       "auth_group"."name"
  FROM
"auth_group"
 INNER JOIN
"auth_user_groups"
    ON
("auth_group"."id" = "auth_user_groups"."group_id")
 WHERE
"auth_user_groups"."user_id" IN (129468)
SELECT ••• FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (129468)
0.24

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(763)
  profile_user = ProxyUser.objects.get(username__iexact=username)

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM
"lego_designer"
 INNER JOIN
"auth_user"
    ON
("lego_designer"."user_ptr_id" = "auth_user"."id")
 WHERE
UPPER("auth_user"."username"::text) = UPPER('meregt')
 LIMIT
21
SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE UPPER("auth_user"."username"::text) = UPPER('meregt') LIMIT 21
0.30

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

SELECT COUNT(*) AS "__count"
  FROM
"lego_moc"
 INNER JOIN
"lego_baseset"
    ON
("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE
("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 129468)
SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 129468)
2 similar queries. Duplicated 2 times.
3.87

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(803)
  total_mocs = mocs.count()

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

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/constants/mocs.py in sort_user_sets(133)
  return list(sets.order_by(*order_by_fields))

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

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_mocs(817)
  prefetch_related_objects(mocs, 'tags')

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

Connection: default

Transaction status: Idle

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

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

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

/home/nathan/rb/site/./lego/filters.py in get_drill_down(958)
  for item in all_items:

SELECT SUM("lego_setstatstotal"."likes") AS "likes__sum"
  FROM
"lego_setstatstotal"
 WHERE
"lego_setstatstotal"."set_id" IN (
        SELECT U0."baseset_ptr_id"
          FROM
"lego_moc" U0
         INNER JOIN
"lego_baseset" U1
            ON
(U0."baseset_ptr_id" = U1."id")
         WHERE
(U1."is_active" AND U0."designer_id" = 129468)
       )
SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" IN (SELECT ••• FROM "lego_moc" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") WHERE (U1."is_active" AND U0."designer_id" = 129468))
2 similar queries. Duplicated 2 times.
7.62

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/designers.py in get_stats(79)
  num_likes = SetStatsTotal.objects.filter(set__in=Moc.objects.filter(designer=self)).aggregate(Sum('likes'))['likes__sum'] or 0

SELECT COUNT(*) AS "__count"
  FROM
"lego_designerfollower"
 WHERE
"lego_designerfollower"."designer_id" = 129468
SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 129468
2 similar queries. Duplicated 2 times.
2.72

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(231)
  i = DesignerFollower.objects.filter(designer_id=self.id).count()

SELECT "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent"
  FROM
"accounts_userplan"
 WHERE
"accounts_userplan"."user_id" = 129468
 LIMIT
21
SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 129468 LIMIT 21
0.26

Connection: default

Transaction status: In transaction

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

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

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

/home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36)
  .__get__(instance, instance_type)

SELECT "plans_plan"."id",
       "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
21
SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 2 LIMIT 21
2 similar queries. Duplicated 2 times.
0.16

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./accounts/models/users.py in is_designer(381)
  return self.plan.is_designer()

SELECT "lego_designerdiscount"."id",
       "lego_designerdiscount"."designer_id",
       "lego_designerdiscount"."name",
       "lego_designerdiscount"."start_date",
       "lego_designerdiscount"."end_date",
       "lego_designerdiscount"."discount_pct",
       "lego_designerdiscount"."mocs"
  FROM
"lego_designerdiscount"
 WHERE
("lego_designerdiscount"."end_date" > '2026-01-22T06:25:18.701666+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:25:18.701662+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['308000', '304040', '299790', '295432', '295431', '290872', '290870', '288584', '287060', '287059', '285600', '284697', '284383', '284381', '283849', '280609', '280608', '275562', '275561', '275560', '270879', '266425', '263373', '261550', '261549', '256842', '251349', '247209', '243356', '238189', '233492', '230489', '228476', '227788', '226632', '224192', '223300', '222732', '221521', '218085', '216759', '214512', '213437', '211698', '207809', '207441', '207440', '198621', '198620', '198619']]::jsonb[])))
SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-22T06:25:18.701666+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-22T06:25:18.701662+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['308000', '304040', '299790', '295432', '295431', '290872', '290870', '288584', '287060', '287059', '285600', '284697', '284383', '284381', '283849', '280609', '280608', '275562', '275561', '275560', '270879', '266425', '263373', '261550', '261549', '256842', '251349', '247209', '243356', '238189', '233492', '230489', '228476', '227788', '226632', '224192', '223300', '222732', '221521', '218085', '216759', '214512', '213437', '211698', '207809', '207441', '207440', '198621', '198620', '198619']]::jsonb[])))
2.44

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in attach_discount_to_mocs(1531)
  for discount in discounts:

SELECT "lego_mocswitherrors"."moc_id"
  FROM
"lego_mocswitherrors"
 WHERE
"lego_mocswitherrors"."moc_id" IN (304040, 299790, 295432, 295431, 290872, 290870, 288584, 287060, 287059, 285600, 284697, 284383, 284381, 283849, 280609, 280608, 275562, 275561, 275560, 270879, 266425, 261550, 261549, 256842, 247209, 243356, 238189, 233492, 230489, 228476, 226632, 223300, 222732, 221521, 218085, 216759, 213437, 207809, 207440, 198621, 198620, 198619)
SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" IN (304040, 299790, 295432, 295431, 290872, 290870, 288584, 287060, 287059, 285600, 284697, 284383, 284381, 283849, 280609, 280608, 275562, 275561, 275560, 270879, 266425, 261550, 261549, 256842, 247209, 243356, 238189, 233492, 230489, 228476, 226632, 223300, 222732, 221521, 218085, 216759, 213437, 207809, 207440, 198621, 198620, 198619)
0.19

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in attach_alternate_to_mocs(1568)
  errors = set(errors)

SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM
"countries_plus_country"
 WHERE
"countries_plus_country"."iso" = 'US'
 LIMIT
21
SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
  geo_data = user.geo.get_user_currency()

/home/nathan/rb/site/./geo/geo.py in get_user_currency(252)
  country = Country.objects.get(iso=country_code)

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

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

Connection: default

Transaction status: Idle

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

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

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

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

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" = 129468)
 LIMIT
1
SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 129468) LIMIT 1
0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

24 <h2 class="size-18 mt-10 mb-0 js-hover-card" data-hover="{% url 'user_card' profile_user.username %}">{{ profile_user.username }}</h2>
25
26 <a href="{% url 'about' %}#roles">
27 <h3 class="size-12 mt-0 mb-10 text-info">{{ profile_user.get_rolename.0|upper }}</h3>
28 </a>
29 {% if request.user == profile_user or privacy_options.is_public_legosummary %}
30 <h3 class="size-12 mt-0 mb-10 text-muted">{{ profile_user.get_num_parts_summary.all_parts|intcomma }} Parts</h3>
31 {% endif %}

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

SELECT "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly"
  FROM
"plans_plan"
 WHERE
"plans_plan"."id" = 2
 LIMIT
21
SELECT ••• 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(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" = 129468
 LIMIT
21
SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 129468 LIMIT 21
0.22

Connection: default

Transaction status: In transaction

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

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

/home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36)
  .__get__(instance, instance_type)

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

Connection: default

Transaction status: Idle

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

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" = 9
 LIMIT
21
SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 9 LIMIT 21
0.15

Connection: default

Transaction status: Idle

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

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" = 129468)
SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 129468)
2 similar queries. Duplicated 2 times.
1.65

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_mocs(866)
  self._num_mocs = Moc.objects.filter(designer=self.designer).count()

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" = 129468)
       )
SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" IN (SELECT ••• FROM "lego_moc" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") WHERE (U1."is_active" AND U0."designer_id" = 129468))
2 similar queries. Duplicated 2 times.
2.38

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/designers.py in get_stats(79)
  num_likes = SetStatsTotal.objects.filter(set__in=Moc.objects.filter(designer=self)).aggregate(Sum('likes'))['likes__sum'] or 0

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

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/models/designers.py in get_num_followers_formatted(231)
  i = DesignerFollower.objects.filter(designer_id=self.id).count()

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

Connection: default

Transaction status: Idle

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

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

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

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

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

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"
  FROM
"lego_baseset"
 WHERE
"lego_baseset"."id" = 43495
 LIMIT
21
SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 43495 LIMIT 21
2 similar queries. Duplicated 2 times.
0.28

Connection: default

Transaction status: Idle

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

182 {% else %}
183 {# repeat alt label check here so dont have to recalculate discount #}
184 {% if set.is_moc and set.get_moc.is_alternate %}
185 <span class="label label-altbuild size-10" title="Alternate Build MOC{% if set.get_moc.parent_set_2 %}{% else %} - only uses parts from {{ set.get_moc.parent_set_1 }}{% endif %}"><i class="fa fa-fw fa-retweet text-white"></i> <span class="hidden-xs"> Alt</span></span>
186 {% endif %}
187 {% endif %}
188
189 {% if sub_text %}

/home/nathan/rb/site/lego/templates/sets/render_set.html

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"
  FROM
"lego_baseset"
 WHERE
"lego_baseset"."id" = 43495
 LIMIT
21
SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 43495 LIMIT 21
2 similar queries. Duplicated 2 times.
0.26

Connection: default

Transaction status: Idle

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

182 {% else %}
183 {# repeat alt label check here so dont have to recalculate discount #}
184 {% if set.is_moc and set.get_moc.is_alternate %}
185 <span class="label label-altbuild size-10" title="Alternate Build MOC{% if set.get_moc.parent_set_2 %}{% else %} - only uses parts from {{ set.get_moc.parent_set_1 }}{% endif %}"><i class="fa fa-fw fa-retweet text-white"></i> <span class="hidden-xs"> Alt</span></span>
186 {% endif %}
187 {% endif %}
188
189 {% if sub_text %}

/home/nathan/rb/site/lego/templates/sets/render_set.html

Log messages

No messages logged.