Showing 50 MOCs (784 total quantity)
Minifig Scale Mario Karts
MOC-275034
(430 parts)
Premium
Ken Block's Hoonicorn
MOC-268214
(219 parts)
Premium
Ken Block's Hoonicorn (set 77262) Upgrades
MOC-268815
(568 parts)
Premium
Brian's Supra (set 77260) Upgrades
MOC-267533
(306 parts)
Premium
Raging Bull Countach
MOC-266077
(238 parts)
Premium
Raging Bull V12 Vision GT
MOC-266078
(222 parts)
Premium
Raging Bull Gallardo
MOC-265870
(238 parts)
Premium
Raging Bull Espada
MOC-265869
(264 parts)
Premium
Raging Bull Diablo
MOC-265868
(289 parts)
Premium
Raging Bull Reventon
MOC-265866
(267 parts)
Premium
Raging Bull Sesto Elemento
MOC-265867
(277 parts)
Premium
Funday Santa Fe - Set of Five Colors
MOC-264994
(2387 parts)
Premium
Funday Santa Fe
MOC-264992
(473 parts)
Premium
EV Supercar Complete Combo Pack
MOC-262122
(1649 parts)
Premium
EV Supercar 8-Stud Scale Conversion
MOC-262119
(348 parts)
Premium
EV Supercar Transformer
MOC-262118
(178 parts)
Premium
EV Supercar Mecha Tank Platform
MOC-262120
(541 parts)
Premium
EV Supercar Spy Jet Add-On
MOC-262121
(257 parts)
Premium
60498 Tractor Add-Ons
MOC-258849
(2018 parts)
Premium
Whistlin Diesel's Bob & Weave Challenger
MOC-255621
(236 parts)
Premium
Built Tough Bronco Sport
MOC-255623
(251 parts)
Premium
Built Tough F-150
MOC-255624
(220 parts)
Premium
Off Road Mountain Truck Mods
MOC-254670
(176 parts)
THE TIme Machine Version 2
MOC-250901
(283 parts)
Premium
APXGP Team Race Car from F1 The Movie
MOC-249383
(200 parts)
Premium
Silver Star G63 & SL63
MOC-246219
(456 parts)
Premium
Boogy Vision GT
MOC-248869
(222 parts)
Premium
Woking W1
MOC-248541
(249 parts)
Premium
Prancing Horse SF90 XX Stradale
MOC-248538
(283 parts)
Premium
Stuttgart 911 GT3 RS
MOC-248537
(239 parts)
Premium
Literally 100 Logos
MOC-247121
(7276 parts)
Prancing Horse Logo Display
MOC-244133
(607 parts)
Prancing Horse 250 GT California
MOC-244128
(168 parts)
Premium
Prancing Horse F40 Engine
MOC-244126
(91 parts)
Prancing Horse Testarossa Engine
MOC-244127
(26 parts)
Mario Kart TV Display
MOC-241614
(908 parts)
Premium
The Ultimate Lego Car Garage Display Diorama
MOC-241620
(753 parts)
Premium
The Ultimate Jurassic Park Dinosaur Diorama
MOC-241618
(379 parts)
Premium
The Ultimate Autobot Display Diorama
MOC-241619
(640 parts)
Premium
Car Manufacturer Display Platform
MOC-241617
(423 parts)
Premium
Lex IS 350
MOC-239792
(377 parts)
Premium
Bob & Weave Challenger
MOC-237590
(223 parts)
Premium
Sean's Mitsy Lancer from Tokyo Drift
MOC-237591
(338 parts)
Premium
Suki's Honduh S2000 from 2 Fast 2 Furious
MOC-234439
(188 parts)
Premium
DJDT

Time

Resource usage

Resource Value
User CPU time 742.435 msec
System CPU time 15.023 msec
Total CPU time 757.458 msec
Elapsed time 928.614 msec
Context switches 1034 voluntary, 7 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 171.64 ms (26 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('IBrickedItUp'))
 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('IBrickedItUp')) LIMIT 21
9.15

Connection: default

Transaction status: Idle

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

SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
       "auth_group"."id",
       "auth_group"."name"
  FROM
"auth_group"
 INNER JOIN
"auth_user_groups"
    ON
("auth_group"."id" = "auth_user_groups"."group_id")
 WHERE
"auth_user_groups"."user_id" IN (534828)
SELECT ••• FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (534828)
2 similar queries. Duplicated 2 times.
0.15

Connection: default

Transaction status: Idle

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

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM
"lego_designer"
 INNER JOIN
"auth_user"
    ON
("lego_designer"."user_ptr_id" = "auth_user"."id")
 WHERE
UPPER("auth_user"."username"::text) = UPPER('IBrickedItUp')
 LIMIT
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('IBrickedItUp') LIMIT 21
0.19

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
       "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug"
  FROM
"taggit_tag"
 INNER JOIN
"taggit_taggeditem"
    ON
("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
 INNER JOIN
"django_content_type"
    ON
("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
 WHERE
("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (112643, 192523, 165914, 165915, 145437, 196638, 165919, 145438, 145439, 223266, 223268, 106543, 108592, 163889, 153649, 153651, 153650, 249915, 190532, 280653, 280655, 280656, 280657, 231505, 231504, 231511, 221272, 188505, 188504, 188506, 104535, 174173, 125022, 102493, 114787, 114788, 114789, 141416, 141417, 247920, 247922, 245881, 245882, 159867, 159868, 106626, 116868, 106628, 106630, 151687, 151688, 151689, 135304, 108689, 108690, 108691, 313501, 194719, 194720, 194721, 174240, 168112, 168113, 168114, 112821, 127160, 110778, 110779, 110780, 184509, 110781, 229581, 114895, 106706, 132335, 116948, 116949, 116947, 132336, 131291, 243942, 121063, 121064, 121065, 135402, 149739, 149740, 149741, 135403, 121066, 215280, 182512, 182514, 104686, 147700, 315640, 108792, 196860, 196861, 129299, 106772, 106773, 106774, 106775, 106771, 125209, 172314, 172315, 125212, 125210, 192798, 125211, 109963, 209190, 209191, 109964, 196906, 176428, 198968, 262461, 244038, 139591, 244040, 139592, 139590, 139593, 264530, 264531, 237907, 123220, 227672, 227673, 227675, 186726, 196968, 196969, 110952, 352626, 166262, 156022, 180608, 115073, 180611, 184713, 336273, 336275, 108951, 108952, 108953, 203164, 203166, 143777, 143778, 143779, 143780, 147882, 147883, 147884, 137644, 137645, 119210, 117167, 131505, 299442, 113074, 170426, 170427, 170429, 178624, 178625, 178626, 178627, 160194, 162245, 162246, 160193, 102853, 291275, 164308, 164309, 115158, 115157, 289247, 193024, 129537, 129538, 129539, 129540, 305672, 305673, 305674, 219658, 117260, 225805, 305678, 305679, 225806, 117261, 117259, 145944, 145945, 127514, 127515, 127513, 156189, 156190, 156191, 156192, 127512, 143908, 109093, 109094, 109095, 109092, 131625, 131626, 131627, 131629, 191022, 191023, 180782, 115247, 111151, 107067, 184892, 199230, 250433, 236108, 105039, 236112, 242263, 242265, 242267, 113260, 213627, 213629, 205438, 205439, 187014, 133775, 230032, 133776, 133778, 133777, 109204, 283289, 283290, 283291, 283292, 283293, 117406, 117405, 117408, 117409, 199330, 117404, 117403, 221861, 107171, 107170, 107168, 115373, 113326, 113327, 113328, 113330, 111287, 111288, 137916, 197309, 197310, 129733, 189126, 127694, 127695, 127696, 127697, 207570, 234201, 234204, 234205, 273118, 273120, 266979, 109284, 109285, 109286, 197351, 197352, 217833, 152298, 217835, 152300, 152299, 115437, 166660, 166662, 103139, 105227, 283404, 105229, 105230, 211737, 211738, 107289, 154398, 154400, 230180, 230182, 109352, 111401, 240427, 123691, 240431, 238387, 240440, 131915, 150357, 150358, 109399, 197469, 224107, 224109, 158576, 158577, 275314, 275316, 158583, 158584, 248700, 136061, 136062, 291711, 136063, 107391, 291714, 107389, 189316, 107388, 156555, 156556, 156557, 103309, 168847, 111506, 168851, 168852, 123797, 123796, 123795, 111508, 277405, 105374, 301983, 301985, 301986, 301987, 312227, 312228, 301988, 312231, 146340, 115622, 172972, 172973, 172974, 172976, 199610, 310211, 187335, 142295, 242649, 175068, 142301, 142302, 291807, 142300, 111583, 111582, 107486, 105439, 105443, 105440, 115687, 322536, 254952, 322538, 322539, 140267, 115689, 115688, 238576, 238577, 160754, 140274, 140272, 109554, 113675, 134160, 128027, 306216, 111664, 216115, 121917, 103487, 132162, 109641, 197721, 351322, 205919, 205920, 144481, 144482, 144483, 107687, 312427, 179307, 179309, 179310, 111724, 246903, 246906, 144508, 191616, 109711, 244882, 128148, 197786, 197787, 111777, 111778, 146599, 146600, 226473, 226474, 146601, 115883, 115882, 115881, 171183, 115880, 122041, 122042, 122043, 312513, 253126, 230598, 230602, 130251, 183502, 109774, 222428, 163043, 107752, 138473, 195820, 201965, 197869, 201967, 208112, 177393, 208113, 208115, 195823, 195822, 195821, 132338, 234744, 177400, 132337, 187643, 105715, 244991, 244992, 244993, 111875, 187655, 128274, 144667, 126237, 126239, 126240, 142629, 113957, 189735, 185640, 185641, 181549, 181551, 107824, 107825, 107826, 193846, 197947, 109884, 228671, 296261, 296262, 326988, 103757, 165198, 165202, 163154, 165206, 138585, 138586, 251241, 140664, 181630, 118144, 193926, 134539, 236940, 236941, 236942, 159119, 159120, 312721, 134541, 134540, 175508, 175509, 112021, 220567, 191896, 175511, 106119, 105711, 105712, 126368, 105714, 204195, 265641, 150955, 150958, 150959, 150960, 153009, 153010, 153011, 103861, 179640, 214464, 112080, 112081, 112082, 194003, 194004, 116181, 110040, 148959, 148960, 148961, 167394, 167396, 167397, 171494, 171495, 171496, 122343, 136686, 151023, 136687, 136689, 232949, 189943, 232951, 189944, 232955, 124416, 124418, 124419, 124420, 132619, 183822, 116249, 198170, 198171, 116251, 116250, 198174, 261664, 179744, 149026, 149027, 337444, 337445, 337446, 337447, 337448, 149025, 110117, 106025, 106020, 106023, 106024, 155184, 210492, 210493, 112194, 128580, 128581, 128582, 128583, 114254, 224847, 224848, 263762, 126569, 196203, 196204, 196205, 183922, 112249, 112250, 112251, 321148, 161405, 104060, 267906, 161413, 161414, 114310, 235144, 235145, 210569, 142987, 142988, 142986, 114312, 185999, 114311, 110220, 110219, 110218, 175769, 173723, 173727, 173728, 124575, 134818, 163499, 243375, 243376, 243377, 163503, 159414, 253623, 159415, 341696, 216768, 198338, 255684, 130757, 130758, 192199, 255688, 130760, 130759, 138955, 110283, 110282, 110281, 138959, 138960, 138961, 341724, 167648, 212710, 212716, 155386, 155387, 155388, 245503, 182016, 182017, 141061, 141062, 141063, 141064, 110347, 124686, 130840, 130841, 130842, 130843, 130844, 108231, 136990, 177954, 177955, 177956, 177957, 147238, 147239, 247597, 200495, 200498, 108339, 128826, 198466, 198468, 114501, 118601, 241483, 241484, 204621, 180046, 180047, 337744, 337745, 337746, 180050, 249687, 112473, 110427, 110428, 110429, 110430, 135008, 116579, 126821, 126823, 126824, 126825, 169834, 169835, 169836, 196469, 196470, 239480, 239481, 315259, 239483, 106364, 157578, 157579, 114573, 114574, 114575, 108432, 223127, 122779, 122780, 122781, 147358, 122783, 133029, 186279, 135080, 135079, 339883, 137140, 137141, 137142, 108476, 198590, 110535, 188380, 106460, 272350, 251871, 272352, 116702, 251874, 106464, 251876, 128997, 128998, 128996, 106463, 129002, 239595, 331756, 331757, 331758, 331759, 331760, 268268, 129005, 104435, 176118, 108534, 176120))
SELECT ••• FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (112643, 192523, 165914, 165915, 145437, 196638, 165919, 145438, 145439, 223266, 223268, 106543, 108592, 163889, 153649, 153651, 153650, 249915, 190532, 280653, 280655, 280656, 280657, 231505, 231504, 231511, 221272, 188505, 188504, 188506, 104535, 174173, 125022, 102493, 114787, 114788, 114789, 141416, 141417, 247920, 247922, 245881, 245882, 159867, 159868, 106626, 116868, 106628, 106630, 151687, 151688, 151689, 135304, 108689, 108690, 108691, 313501, 194719, 194720, 194721, 174240, 168112, 168113, 168114, 112821, 127160, 110778, 110779, 110780, 184509, 110781, 229581, 114895, 106706, 132335, 116948, 116949, 116947, 132336, 131291, 243942, 121063, 121064, 121065, 135402, 149739, 149740, 149741, 135403, 121066, 215280, 182512, 182514, 104686, 147700, 315640, 108792, 196860, 196861, 129299, 106772, 106773, 106774, 106775, 106771, 125209, 172314, 172315, 125212, 125210, 192798, 125211, 109963, 209190, 209191, 109964, 196906, 176428, 198968, 262461, 244038, 139591, 244040, 139592, 139590, 139593, 264530, 264531, 237907, 123220, 227672, 227673, 227675, 186726, 196968, 196969, 110952, 352626, 166262, 156022, 180608, 115073, 180611, 184713, 336273, 336275, 108951, 108952, 108953, 203164, 203166, 143777, 143778, 143779, 143780, 147882, 147883, 147884, 137644, 137645, 119210, 117167, 131505, 299442, 113074, 170426, 170427, 170429, 178624, 178625, 178626, 178627, 160194, 162245, 162246, 160193, 102853, 291275, 164308, 164309, 115158, 115157, 289247, 193024, 129537, 129538, 129539, 129540, 305672, 305673, 305674, 219658, 117260, 225805, 305678, 305679, 225806, 117261, 117259, 145944, 145945, 127514, 127515, 127513, 156189, 156190, 156191, 156192, 127512, 143908, 109093, 109094, 109095, 109092, 131625, 131626, 131627, 131629, 191022, 191023, 180782, 115247, 111151, 107067, 184892, 199230, 250433, 236108, 105039, 236112, 242263, 242265, 242267, 113260, 213627, 213629, 205438, 205439, 187014, 133775, 230032, 133776, 133778, 133777, 109204, 283289, 283290, 283291, 283292, 283293, 117406, 117405, 117408, 117409, 199330, 117404, 117403, 221861, 107171, 107170, 107168, 115373, 113326, 113327, 113328, 113330, 111287, 111288, 137916, 197309, 197310, 129733, 189126, 127694, 127695, 127696, 127697, 207570, 234201, 234204, 234205, 273118, 273120, 266979, 109284, 109285, 109286, 197351, 197352, 217833, 152298, 217835, 152300, 152299, 115437, 166660, 166662, 103139, 105227, 283404, 105229, 105230, 211737, 211738, 107289, 154398, 154400, 230180, 230182, 109352, 111401, 240427, 123691, 240431, 238387, 240440, 131915, 150357, 150358, 109399, 197469, 224107, 224109, 158576, 158577, 275314, 275316, 158583, 158584, 248700, 136061, 136062, 291711, 136063, 107391, 291714, 107389, 189316, 107388, 156555, 156556, 156557, 103309, 168847, 111506, 168851, 168852, 123797, 123796, 123795, 111508, 277405, 105374, 301983, 301985, 301986, 301987, 312227, 312228, 301988, 312231, 146340, 115622, 172972, 172973, 172974, 172976, 199610, 310211, 187335, 142295, 242649, 175068, 142301, 142302, 291807, 142300, 111583, 111582, 107486, 105439, 105443, 105440, 115687, 322536, 254952, 322538, 322539, 140267, 115689, 115688, 238576, 238577, 160754, 140274, 140272, 109554, 113675, 134160, 128027, 306216, 111664, 216115, 121917, 103487, 132162, 109641, 197721, 351322, 205919, 205920, 144481, 144482, 144483, 107687, 312427, 179307, 179309, 179310, 111724, 246903, 246906, 144508, 191616, 109711, 244882, 128148, 197786, 197787, 111777, 111778, 146599, 146600, 226473, 226474, 146601, 115883, 115882, 115881, 171183, 115880, 122041, 122042, 122043, 312513, 253126, 230598, 230602, 130251, 183502, 109774, 222428, 163043, 107752, 138473, 195820, 201965, 197869, 201967, 208112, 177393, 208113, 208115, 195823, 195822, 195821, 132338, 234744, 177400, 132337, 187643, 105715, 244991, 244992, 244993, 111875, 187655, 128274, 144667, 126237, 126239, 126240, 142629, 113957, 189735, 185640, 185641, 181549, 181551, 107824, 107825, 107826, 193846, 197947, 109884, 228671, 296261, 296262, 326988, 103757, 165198, 165202, 163154, 165206, 138585, 138586, 251241, 140664, 181630, 118144, 193926, 134539, 236940, 236941, 236942, 159119, 159120, 312721, 134541, 134540, 175508, 175509, 112021, 220567, 191896, 175511, 106119, 105711, 105712, 126368, 105714, 204195, 265641, 150955, 150958, 150959, 150960, 153009, 153010, 153011, 103861, 179640, 214464, 112080, 112081, 112082, 194003, 194004, 116181, 110040, 148959, 148960, 148961, 167394, 167396, 167397, 171494, 171495, 171496, 122343, 136686, 151023, 136687, 136689, 232949, 189943, 232951, 189944, 232955, 124416, 124418, 124419, 124420, 132619, 183822, 116249, 198170, 198171, 116251, 116250, 198174, 261664, 179744, 149026, 149027, 337444, 337445, 337446, 337447, 337448, 149025, 110117, 106025, 106020, 106023, 106024, 155184, 210492, 210493, 112194, 128580, 128581, 128582, 128583, 114254, 224847, 224848, 263762, 126569, 196203, 196204, 196205, 183922, 112249, 112250, 112251, 321148, 161405, 104060, 267906, 161413, 161414, 114310, 235144, 235145, 210569, 142987, 142988, 142986, 114312, 185999, 114311, 110220, 110219, 110218, 175769, 173723, 173727, 173728, 124575, 134818, 163499, 243375, 243376, 243377, 163503, 159414, 253623, 159415, 341696, 216768, 198338, 255684, 130757, 130758, 192199, 255688, 130760, 130759, 138955, 110283, 110282, 110281, 138959, 138960, 138961, 341724, 167648, 212710, 212716, 155386, 155387, 155388, 245503, 182016, 182017, 141061, 141062, 141063, 141064, 110347, 124686, 130840, 130841, 130842, 130843, 130844, 108231, 136990, 177954, 177955, 177956, 177957, 147238, 147239, 247597, 200495, 200498, 108339, 128826, 198466, 198468, 114501, 118601, 241483, 241484, 204621, 180046, 180047, 337744, 337745, 337746, 180050, 249687, 112473, 110427, 110428, 110429, 110430, 135008, 116579, 126821, 126823, 126824, 126825, 169834, 169835, 169836, 196469, 196470, 239480, 239481, 315259, 239483, 106364, 157578, 157579, 114573, 114574, 114575, 108432, 223127, 122779, 122780, 122781, 147358, 122783, 133029, 186279, 135080, 135079, 339883, 137140, 137141, 137142, 108476, 198590, 110535, 188380, 106460, 272350, 251871, 272352, 116702, 251874, 106464, 251876, 128997, 128998, 128996, 106463, 129002, 239595, 331756, 331757, 331758, 331759, 331760, 268268, 129005, 104435, 176118, 108534, 176120))
20.90

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

Connection: default

Transaction status: In transaction

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

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

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

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

SELECT "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly"
  FROM
"plans_plan"
 WHERE
"plans_plan"."id" = 4
 LIMIT
21
SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 4 LIMIT 21
2 similar queries. Duplicated 2 times.
0.07

Connection: default

Transaction status: Idle

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

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

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

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent"
  FROM
"auth_user"
  LEFT OUTER JOIN
"accounts_userplan"
    ON
("auth_user"."id" = "accounts_userplan"."user_id")
 WHERE
("auth_user"."is_active" AND "auth_user"."id" = 534828)
 LIMIT
21
SELECT ••• FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND "auth_user"."id" = 534828) LIMIT 21
0.14

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(93)
  user = ProxyUser.objects.get(id=self.id)  # Designer class won't have options pre-loaded so do a lookup instead

SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
       "auth_group"."id",
       "auth_group"."name"
  FROM
"auth_group"
 INNER JOIN
"auth_user_groups"
    ON
("auth_group"."id" = "auth_user_groups"."group_id")
 WHERE
"auth_user_groups"."user_id" IN (534828)
SELECT ••• FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (534828)
2 similar queries. Duplicated 2 times.
0.12

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(93)
  user = ProxyUser.objects.get(id=self.id)  # Designer class won't have options pre-loaded so do a lookup instead

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM
"accounts_usersetting"
 WHERE
("accounts_usersetting"."name" = 'personalisation' AND "accounts_usersetting"."user_id" = 534828)
SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'personalisation' AND "accounts_usersetting"."user_id" = 534828)
0.09

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/designers.py in get_ga_tracking_id(94)
  ga_tracking_id = user.get_personalisation_option('ga_tracking_id')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_option(191)
  options = self.get_personalisation_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_personalisation_options(183)
  if len(self.personalisation_options) == 0:

SELECT "lego_designerdiscount"."id",
       "lego_designerdiscount"."designer_id",
       "lego_designerdiscount"."name",
       "lego_designerdiscount"."start_date",
       "lego_designerdiscount"."end_date",
       "lego_designerdiscount"."discount_pct",
       "lego_designerdiscount"."mocs"
  FROM
"lego_designerdiscount"
 WHERE
("lego_designerdiscount"."end_date" > '2026-11-16T00:24:02.819616+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:24:02.819613+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['352626', '351322', '341724', '341696', '339883', '337744', '337745', '337746', '337448', '337447', '337446', '337444', '337445', '336275', '336273', '331760', '331757', '331756', '331758', '331759', '326988', '322536', '322538', '322539', '321148', '315640', '315259', '313501', '312427', '312721', '312231', '312228', '312227', '312513', '310211', '306216', '305679', '305678', '305674', '305672', '305673', '301983', '301988', '301986', '301987', '301985', '299442', '296261', '296262', '291807']]::jsonb[])))
SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-11-16T00:24:02.819616+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-16T00:24:02.819613+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['352626', '351322', '341724', '341696', '339883', '337744', '337745', '337746', '337448', '337447', '337446', '337444', '337445', '336275', '336273', '331760', '331757', '331756', '331758', '331759', '326988', '322536', '322538', '322539', '321148', '315640', '315259', '313501', '312427', '312721', '312231', '312228', '312227', '312513', '310211', '306216', '305679', '305678', '305674', '305672', '305673', '301983', '301988', '301986', '301987', '301985', '299442', '296261', '296262', '291807']]::jsonb[])))
1.73

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

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

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

74 </a>
75 </li>
76 <li>
77 {% geo_currency request.user %}
78 </li>
79 {% comment %}
80 <li class="hidden-xs hidden-sm">
81 <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/includes/topbar.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM
"accounts_usersetting"
 WHERE
("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 534828)
 LIMIT
21
SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 534828) LIMIT 21
0.14

Connection: default

Transaction status: Idle

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

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

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="rb-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" = 534828
 ORDER BY
"avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT
1
SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 534828 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(913)
  return render(request, 'accounts/user_mocs.html', context)

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

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

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

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="rb-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" = 534828
 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" = 534828 LIMIT 21
0.14

Connection: default

Transaction status: Idle

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

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

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" = 534828)
 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" = 534828) LIMIT 1
0.23

Connection: default

Transaction status: Idle

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

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

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" = 4
 LIMIT
21
SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 4 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(913)
  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" = 534828
 LIMIT
21
SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 534828 LIMIT 21
0.17

Connection: default

Transaction status: In transaction

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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.