MOC Photos by Shattertype

Shattertype
MOC-142361 by Shattertype
MOC-140406 by Shattertype
MOC-140406 by Shattertype
MOC-128273 by Shattertype
DJDT

Time

Resource usage

Resource Value
User CPU time 125.859 msec
System CPU time 2.874 msec
Total CPU time 128.733 msec
Elapsed time 140.934 msec
Context switches 29 voluntary, 4 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

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

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(882)
  profile_user = get_object_or_404(ProxyUser, 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 (241485)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 (241485)
 0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(882)
  profile_user = get_object_or_404(ProxyUser, username__iexact=username)
SELECT COUNT(*) AS "__count"
  FROM "accounts_usersetphoto"
 WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."user_id" = 241485)SELECT ••• FROM "accounts_usersetphoto" WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."user_id" = 241485)
 0.32

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(886)
  total_photos = photos.count()
SELECT "accounts_usersetphoto"."id",
       "accounts_usersetphoto"."user_id",
       "accounts_usersetphoto"."set_id",
       "accounts_usersetphoto"."image",
       "accounts_usersetphoto"."created",
       "accounts_usersetphoto"."status",
       "accounts_usersetphoto"."is_active",
       "accounts_usersetphoto"."descr",
       "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",
       "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",
       "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_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",
       "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",
       T9."id",
       T9."password",
       T9."last_login",
       T9."is_superuser",
       T9."username",
       T9."first_name",
       T9."last_name",
       T9."email",
       T9."is_staff",
       T9."is_active",
       T9."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "accounts_usersetphoto"
 INNER JOIN "auth_user"
    ON ("accounts_usersetphoto"."user_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")
 INNER JOIN "lego_baseset"
    ON ("accounts_usersetphoto"."set_id" = "lego_baseset"."id")
 INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_moc"
    ON ("lego_baseset"."id" = "lego_moc"."baseset_ptr_id")
  LEFT OUTER JOIN "lego_designer"
    ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id")
  LEFT OUTER JOIN "auth_user" T9
    ON ("lego_designer"."user_ptr_id" = T9."id")
 WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."user_id" = 241485)
 ORDER BY "accounts_usersetphoto"."created" DESCSELECT ••• FROM "accounts_usersetphoto" INNER JOIN "auth_user" ON ("accounts_usersetphoto"."user_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") INNER JOIN "lego_baseset" ON ("accounts_usersetphoto"."set_id" = "lego_baseset"."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_moc" ON ("lego_baseset"."id" = "lego_moc"."baseset_ptr_id") LEFT OUTER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") LEFT OUTER JOIN "auth_user" T9 ON ("lego_designer"."user_ptr_id" = T9."id") WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."user_id" = 241485) ORDER BY "accounts_usersetphoto"."created" DESC
 1.27

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(892)
  drill_downs = get_set_drill_downs(photos, request.GET, all_items=all_photos)

/home/nathan/rb/site/./lego/filters.py in get_set_drill_downs(1266)
  if len(sets) > 0:
SELECT "accounts_usersetphoto"."id",
       "accounts_usersetphoto"."user_id",
       "accounts_usersetphoto"."set_id",
       "accounts_usersetphoto"."image",
       "accounts_usersetphoto"."created",
       "accounts_usersetphoto"."status",
       "accounts_usersetphoto"."is_active",
       "accounts_usersetphoto"."descr",
       "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",
       "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",
       "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_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",
       "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",
       T9."id",
       T9."password",
       T9."last_login",
       T9."is_superuser",
       T9."username",
       T9."first_name",
       T9."last_name",
       T9."email",
       T9."is_staff",
       T9."is_active",
       T9."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "accounts_usersetphoto"
 INNER JOIN "auth_user"
    ON ("accounts_usersetphoto"."user_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")
 INNER JOIN "lego_baseset"
    ON ("accounts_usersetphoto"."set_id" = "lego_baseset"."id")
 INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_moc"
    ON ("lego_baseset"."id" = "lego_moc"."baseset_ptr_id")
  LEFT OUTER JOIN "lego_designer"
    ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id")
  LEFT OUTER JOIN "auth_user" T9
    ON ("lego_designer"."user_ptr_id" = T9."id")
 WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."user_id" = 241485)SELECT ••• FROM "accounts_usersetphoto" INNER JOIN "auth_user" ON ("accounts_usersetphoto"."user_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") INNER JOIN "lego_baseset" ON ("accounts_usersetphoto"."set_id" = "lego_baseset"."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_moc" ON ("lego_baseset"."id" = "lego_moc"."baseset_ptr_id") LEFT OUTER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") LEFT OUTER JOIN "auth_user" T9 ON ("lego_designer"."user_ptr_id" = T9."id") WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."user_id" = 241485)
 0.83

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(892)
  drill_downs = get_set_drill_downs(photos, request.GET, all_items=all_photos)

/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 "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_set"."baseset_ptr_id",
       "lego_set"."start_date",
       "lego_set"."end_date"
  FROM "lego_set"
 INNER JOIN "lego_baseset"
    ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_set"."baseset_ptr_id" = 166293
 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 166293 LIMIT 21
4 similar queries. 		0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(892)
  drill_downs = get_set_drill_downs(photos, request.GET, all_items=all_photos)

/home/nathan/rb/site/./lego/filters.py in get_set_drill_downs(1272)
  fields['Tags'] = get_tag_drill_down(sets, params=params)

/home/nathan/rb/site/./lego/filters.py in get_tag_drill_down(1124)
  elif hasattr(item, 'set') and hasattr(item.set, 'set') and hasattr(item.set.set, '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_set"."baseset_ptr_id",
       "lego_set"."start_date",
       "lego_set"."end_date"
  FROM "lego_set"
 INNER JOIN "lego_baseset"
    ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_set"."baseset_ptr_id" = 164309
 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 164309 LIMIT 21
4 similar queries. Duplicated 2 times. 		0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(892)
  drill_downs = get_set_drill_downs(photos, request.GET, all_items=all_photos)

/home/nathan/rb/site/./lego/filters.py in get_set_drill_downs(1272)
  fields['Tags'] = get_tag_drill_down(sets, params=params)

/home/nathan/rb/site/./lego/filters.py in get_tag_drill_down(1124)
  elif hasattr(item, 'set') and hasattr(item.set, 'set') and hasattr(item.set.set, '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_set"."baseset_ptr_id",
       "lego_set"."start_date",
       "lego_set"."end_date"
  FROM "lego_set"
 INNER JOIN "lego_baseset"
    ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_set"."baseset_ptr_id" = 164309
 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 164309 LIMIT 21
4 similar queries. Duplicated 2 times. 		0.09

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(892)
  drill_downs = get_set_drill_downs(photos, request.GET, all_items=all_photos)

/home/nathan/rb/site/./lego/filters.py in get_set_drill_downs(1272)
  fields['Tags'] = get_tag_drill_down(sets, params=params)

/home/nathan/rb/site/./lego/filters.py in get_tag_drill_down(1124)
  elif hasattr(item, 'set') and hasattr(item.set, 'set') and hasattr(item.set.set, '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_set"."baseset_ptr_id",
       "lego_set"."start_date",
       "lego_set"."end_date"
  FROM "lego_set"
 INNER JOIN "lego_baseset"
    ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_set"."baseset_ptr_id" = 151775
 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 151775 LIMIT 21
4 similar queries. 		0.09

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(892)
  drill_downs = get_set_drill_downs(photos, request.GET, all_items=all_photos)

/home/nathan/rb/site/./lego/filters.py in get_set_drill_downs(1272)
  fields['Tags'] = get_tag_drill_down(sets, params=params)

/home/nathan/rb/site/./lego/filters.py in get_tag_drill_down(1124)
  elif hasattr(item, 'set') and hasattr(item.set, 'set') and hasattr(item.set.set, 'tags'):
SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM "countries_plus_country"
 WHERE "countries_plus_country"."iso" = 'US'
 LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
 0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(907)
  return render(request, 'accounts/user_moc_photos.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_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" = 241485
 LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 241485 LIMIT 21
 0.21

Connection: default

Transaction status: In transaction

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(907)
  return render(request, 'accounts/user_moc_photos.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)
24 {% block help %}{% endblock %}
25
26 {% block list-text %}
27 {% if profile_user.profile.best_url %}
28 <p><a href="{{ profile_user.profile.best_url }}" target="_blank"><i class="fa fa-external-link fa-fw"></i> {{ profile_user.profile.best_url }}</a></p>
29 {% endif %}
30
31 {% if request.user == profile_user %}

/home/nathan/rb/site/accounts/templates/accounts/user_moc_photos.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" = 241485
 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 241485 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1
 0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./accounts/views/profile.py in user_moc_photos(907)
  return render(request, 'accounts/user_moc_photos.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.