MOCs Designed by Renk

DJDT

Time

Resource usage

Resource	Value
User CPU time	221.092 msec
System CPU time	0.000 msec
Total CPU time	221.092 msec
Elapsed time	245.242 msec
Context switches	88 voluntary, 7 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 21.50 ms (23 queries including 10 similar and 10 duplicates )

Query Timeline Time (ms) Action

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent"
  FROM "auth_user"
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
WHERE ("auth_user"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('Renk'))
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('Renk')) LIMIT 21

8.86

Connection: default

Transaction status: Idle

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

SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
       "auth_group"."id",
       "auth_group"."name"
  FROM "auth_group"
INNER JOIN "auth_user_groups"
    ON ("auth_group"."id" = "auth_user_groups"."group_id")
WHERE "auth_user_groups"."user_id" IN (711538)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 (711538)

0.14

Connection: default

Transaction status: Idle

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

0.18

Connection: default

Transaction status: Idle

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

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

SELECT COUNT(*) AS "__count"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 711538)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" = 711538)

2 similar queries. Duplicated 2 times.

0.41

Connection: default

Transaction status: Idle

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

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

3.91

Connection: default

Transaction status: Idle

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

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

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

SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
       "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug"
  FROM "taggit_tag"
INNER JOIN "taggit_taggeditem"
    ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
INNER JOIN "django_content_type"
    ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (161280, 161162, 268049, 242343, 212135, 167975, 247339, 247340, 201522, 208187, 248253, 210622, 202944, 166082, 270790, 230605, 237522, 229972, 235997, 254949, 182251, 214640, 214643, 176246, 214648, 214653, 182654))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 (161280, 161162, 268049, 242343, 212135, 167975, 247339, 247340, 201522, 208187, 248253, 210622, 202944, 166082, 270790, 230605, 237522, 229972, 235997, 254949, 182251, 214640, 214643, 176246, 214648, 214653, 182654))

1.33

Connection: default

Transaction status: Idle

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

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

2.41

Connection: default

Transaction status: Idle

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

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

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

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

SELECT SUM("lego_setstatstotal"."likes") AS "likes__sum"
  FROM "lego_setstatstotal"
WHERE "lego_setstatstotal"."set_id" IN (
        SELECT U0."baseset_ptr_id"
          FROM "lego_moc" U0
         INNER JOIN "lego_baseset" U1
            ON (U0."baseset_ptr_id" = U1."id")
         WHERE (U1."is_active" AND U0."designer_id" = 711538)
       )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" = 711538))

2 similar queries. Duplicated 2 times.

0.30

Connection: default

Transaction status: Idle

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

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

SELECT COUNT(*) AS "__count"
FROM "lego_designerfollower"
WHERE "lego_designerfollower"."designer_id" = 711538SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 711538

2 similar queries. Duplicated 2 times.

0.74

Connection: default

Transaction status: Idle

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

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

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

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

0.16

Connection: default

Transaction status: In transaction

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

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

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

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

SELECT "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly"
  FROM "plans_plan"
WHERE "plans_plan"."id" = 5
LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 5 LIMIT 21

2 similar queries. Duplicated 2 times.

0.09

Connection: default

Transaction status: Idle

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

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

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

SELECT "lego_designerdiscount"."id",
       "lego_designerdiscount"."designer_id",
       "lego_designerdiscount"."name",
       "lego_designerdiscount"."start_date",
       "lego_designerdiscount"."end_date",
       "lego_designerdiscount"."discount_pct",
       "lego_designerdiscount"."mocs"
  FROM "lego_designerdiscount"
WHERE ("lego_designerdiscount"."end_date" > '2026-01-23T02:45:02.729446+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-23T02:45:02.729443+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['270790', '268049', '254949', '248253', '247340', '247339', '242343', '237522', '235997', '230605', '229972', '214653', '214648', '214643', '214640', '212135', '210622', '208187', '202944', '201522', '182654', '182251', '176246', '167975', '166082', '161280', '161162']]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-01-23T02:45:02.729446+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-01-23T02:45:02.729443+00:00'::timestamptz AND (mocs @> ANY (ARRAY[['270790', '268049', '254949', '248253', '247340', '247339', '242343', '237522', '235997', '230605', '229972', '214653', '214648', '214643', '214640', '212135', '210622', '208187', '202944', '201522', '182654', '182251', '176246', '167975', '166082', '161280', '161162']]::jsonb[])))

0.98

Connection: default

Transaction status: Idle

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

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

SELECT "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.13

Connection: default

Transaction status: Idle

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

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

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

412	`</a>`
413	`</li>`
414	`<li class="hidden-xs">`
415	`{% geo_currency request.user %}`
416	`</li>`
417	`{% comment %}`
418	`<li class="hidden-xs hidden-sm">`
419	`<a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>`

/home/nathan/rb/site/rb/templates/rb/base_root.html

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

0.30

Connection: default

Transaction status: Idle

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

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

7	`{% url 'add_profile_avatar' request.user.get_username as url %}`
8	`{% include 'lego/includes/get_img_url_modal.html' with url=url %}`
9
10	`{% with profile_user.get_privacy_options as privacy_options %}`
11	`<div class="text-center pt-3 border-1 mb-20">`
12	`<a href="{% url 'user_profile' profile_user.username %}">`
13	`<img id="user_profile_avatar" src="{% avatar_url profile_user 150 %}" class="avatar" width="150px" height="150px">`
14	`</a>`

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

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

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

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

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

10	`{% with profile_user.get_privacy_options as privacy_options %}`
11	`<div class="text-center pt-3 border-1 mb-20">`
12	`<a href="{% url 'user_profile' profile_user.username %}">`
13	`<img id="user_profile_avatar" src="{% avatar_url profile_user 150 %}" class="avatar" width="150px" height="150px">`
14	`</a>`
15
16	`{% if request.user == profile_user %}`
17	`<div class="js-load_user_avatar" data-modal="#change_avatar_modal"`

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

0.11

Connection: default

Transaction status: Idle

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

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

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

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

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 711538)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 711538) LIMIT 1

0.14

Connection: default

Transaction status: Idle

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

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

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

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

2 similar queries. Duplicated 2 times.

0.07

Connection: default

Transaction status: Idle

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

31	`{% endif %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`
35	`<a href="{% url 'help_plan_limits' %}">`
36	`<div class="mb-10">{{ profile_user.get_plan_html }}</div>`
37	`</a>`
38	`{% endif %}`

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

SELECT "accounts_userprofile"."user_id",
       "accounts_userprofile"."last_mod_inv",
       "accounts_userprofile"."last_activity",
       "accounts_userprofile"."last_ip",
       "accounts_userprofile"."last_country_id",
       "accounts_userprofile"."last_agent",
       "accounts_userprofile"."is_email_verified",
       "accounts_userprofile"."is_email_idle",
       "accounts_userprofile"."email_last_clicked",
       "accounts_userprofile"."api_token",
       "accounts_userprofile"."real_name",
       "accounts_userprofile"."location",
       "accounts_userprofile"."brickset_url",
       "accounts_userprofile"."mocpages_url",
       "accounts_userprofile"."flickr_url",
       "accounts_userprofile"."eurobricks_url",
       "accounts_userprofile"."youtube_url",
       "accounts_userprofile"."bricklink_url",
       "accounts_userprofile"."brickowl_url",
       "accounts_userprofile"."bricksafe_url",
       "accounts_userprofile"."website_url",
       "accounts_userprofile"."facebook_url",
       "accounts_userprofile"."twitter_url",
       "accounts_userprofile"."karma",
       "accounts_userprofile"."trophy_badge_id",
       "accounts_userprofile"."comments",
       "accounts_userprofile"."mfhash_vector",
       "accounts_userprofile"."is_muted",
       "accounts_userprofile"."is_banned",
       "accounts_userprofile"."is_suspected_pirate",
       "accounts_userprofile"."muted_until",
       "accounts_userprofile"."blocked_operations",
       "accounts_userprofile"."is_guest",
       "accounts_userprofile"."guest_token"
  FROM "accounts_userprofile"
WHERE "accounts_userprofile"."user_id" = 711538
LIMIT 21SELECT ••• FROM "accounts_userprofile" WHERE "accounts_userprofile"."user_id" = 711538 LIMIT 21

0.32

Connection: default

Transaction status: In transaction

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

/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

2 similar queries. Duplicated 2 times.

0.18

Connection: default

Transaction status: Idle

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

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

60	`</a>`
61	`{% endif %}`
62
63	`{% if profile_user.get_num_mocs > 0 %}`
64	`{% with profile_user.designer.get_stats as designer_stats %}`
65	`<div class="border-top-1 box-light">`
66	`<div class="row">`
67	`<div class="col-xs-4">`

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

2 similar queries. Duplicated 2 times.

0.26

Connection: default

Transaction status: Idle

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

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

61	`{% endif %}`
62
63	`{% if profile_user.get_num_mocs > 0 %}`
64	`{% with profile_user.designer.get_stats as designer_stats %}`
65	`<div class="border-top-1 box-light">`
66	`<div class="row">`
67	`<div class="col-xs-4">`
68	`<a href="{% url 'user_mocs' profile_user.username %}">`

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

2 similar queries. Duplicated 2 times.

0.18

Connection: default

Transaction status: Idle

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

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

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

61	`{% endif %}`
62
63	`{% if profile_user.get_num_mocs > 0 %}`
64	`{% with profile_user.designer.get_stats as designer_stats %}`
65	`<div class="border-top-1 box-light">`
66	`<div class="row">`
67	`<div class="col-xs-4">`
68	`<a href="{% url 'user_mocs' profile_user.username %}">`

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

2 similar queries. Duplicated 2 times.

0.12

Connection: default

Transaction status: Idle

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

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

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

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

4	`<div class="visible-xs user-mobile-menu mb-30">`
5	`<div class="mb-10">`
6	`<a href="{% url 'user_profile' profile_user.username %}">`
7	`<img id="user_profile_avatar" src="{% avatar_url profile_user 75 %}" class="avatar mr-10" width="50px" height="50px">`
8	`{{ profile_user.username }}`
9	`</a>`
10
11	`{% if request.user.is_authenticated and request.user != profile_user %}`

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

Log messages

No messages logged.

Renk

MOC DESIGNER

MOCs

Followers

Likes

A Festive Evening - Diorama (Andor Season 2)

Padme's Funeral / Casket

Pikmin 4 - Spectralids, Honeywisp, and Leaves

Improved ARC-170 75402

Pikmin 4 - Bulborb

Jabba's Trophy Wall (Han in Carbonite) - Diorama

MGSV - Fulton Extraction

Upgraded Desert Skiff

Jabba's Throne

Better Sarlacc Pit - 75396 mod

Droid Bartender Attachment (R2D2 on Sail Barge)

Pikmin 4 - Dwarf Bulborbs and Dweevils

Pikmin 4 - Bugs and Pellets

Pikmin 4 - Blowhogs

Pikmin 4 - New Enemies Pack

Minifig Scale Droideka

Helldivers 2 - Automaton Forces

Pikmin 4 - Oatchi and Moss

MGSV - Skull Face's Speech

Larger Coruscant Guard Gunship - 2013 Scale

Death Stranding - Lion BT Boss Fight

The Child - Diorama (The Mandalorian Season 1)

Duel Of The Fates - Diorama (Episode 1 The Phantom Menace)

Kamino Barracks / 99's Sacrifice - Diorama (The Clone Wars Season 3)

Kamino Training - Diorama (The Clone Wars and Bad Batch)

Umbara - Diorama (The Clone Wars Season 4)

A Distant Echo - Diorama (The Clone Wars Season 7)

Time

Resource usage

Browser timing

SQL queries from 1 connection

Log messages