Profile of Galloping

518,970 Parts

PRO

(2,066 awarded)

Bargain Hunter

Newton Aycliffe

There are 2 users from this location

TROPHY CASE

11

LEVEL

78.6% (139 points to next level)
Help Guide - Levels/Points

2,227

POINTS

2,490

VIEWS

USER RANKINGS

Points

#5,670

Profile Views

#449

User ID: 223057

Joined: Dec. 18, 2018, 7:18 p.m.

Most Liked MOCs See all MOCs by this designer

No MOCs have been published by this designer

Midas

Newton Aycliffe

There are 2 users from this location

TROPHY CASE

DJDT

Time

Resource usage

Resource	Value
User CPU time	732.063 msec
System CPU time	14.680 msec
Total CPU time	746.743 msec
Elapsed time	3612.537 msec
Context switches	360 voluntary, 29 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 2878.81 ms (62 queries including 37 similar and 32 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 "auth_user"."username" = 'Galloping')
LIMIT 21SELECT ••• FROM "auth_user" LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") WHERE ("auth_user"."is_active" AND "auth_user"."username" = 'Galloping') LIMIT 21

8.95

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(327)
  profile_user = get_object_or_404(ProxyUser, username=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 (223057)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 (223057)

2 similar queries. Duplicated 2 times.

0.14

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(327)
  profile_user = get_object_or_404(ProxyUser, username=username)

6 similar queries. Duplicated 6 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(343)
  context['designer_ga_tracking_id'] = profile_user.designer.get_ga_tracking_id()

SELECT "accounts_userprofilesection"."id",
       "accounts_userprofilesection"."user_id",
       "accounts_userprofilesection"."section",
       "accounts_userprofilesection"."order",
       "accounts_userprofilesection"."options"
  FROM "accounts_userprofilesection"
WHERE "accounts_userprofilesection"."user_id" = 223057
ORDER BY "accounts_userprofilesection"."order" ASCSELECT ••• FROM "accounts_userprofilesection" WHERE "accounts_userprofilesection"."user_id" = 223057 ORDER BY "accounts_userprofilesection"."order" ASC

0.23

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(351)
  if len(context['sections']) == 0:

1.91

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(357)
  context.update(section.get_context(request, profile_user))

/home/nathan/rb/site/./accounts/models/users.py in get_context(1984)
  mocs = Designer.get_liked_mocs(user.id, 6)

/home/nathan/rb/site/./lego/models/designers.py in get_liked_mocs(202)
  pop_mocs = list(qs[:limit])

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-15T23:56:22.737156+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-15T23:56:22.737153+00:00'::timestamptz AND (mocs @> ANY (ARRAY[[]]::jsonb[])))SELECT ••• FROM "lego_designerdiscount" WHERE ("lego_designerdiscount"."end_date" > '2026-11-15T23:56:22.737156+00:00'::timestamptz AND "lego_designerdiscount"."start_date" <= '2026-11-15T23:56:22.737153+00:00'::timestamptz AND (mocs @> ANY (ARRAY[[]]::jsonb[])))

0.44

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(357)
  context.update(section.get_context(request, profile_user))

/home/nathan/rb/site/./accounts/models/users.py in get_context(1990)
  Moc.attach_discount_to_mocs(mocs)

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

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(357)
  context.update(section.get_context(request, profile_user))

/home/nathan/rb/site/./accounts/models/users.py in get_context(2030)
  badges = UserBadge.objects.filter(user=self.user).order_by('badge__num_users')[:6]

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

9 similar queries. Duplicated 9 times.

0.31

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(357)
  context.update(section.get_context(request, profile_user))

/home/nathan/rb/site/./accounts/models/users.py in get_context(2032)
  is_public_badges = user.get_privacy_option('is_public_badges')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285)
  options = self.get_privacy_options()

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

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity",
       "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",
       "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 "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
INNER JOIN "auth_user"
    ON ("django_comments"."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")
  LEFT OUTER JOIN "accounts_userprofile"
    ON ("auth_user"."id" = "accounts_userprofile"."user_id")
WHERE (NOT "django_comments"."is_removed" AND "django_comments"."user_id" = 223057)
ORDER BY "django_comments"."submit_date" DESC
LIMIT 5SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") INNER JOIN "auth_user" ON ("django_comments"."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") LEFT OUTER JOIN "accounts_userprofile" ON ("auth_user"."id" = "accounts_userprofile"."user_id") WHERE (NOT "django_comments"."is_removed" AND "django_comments"."user_id" = 223057) ORDER BY "django_comments"."submit_date" DESC LIMIT 5

1.71

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(357)
  context.update(section.get_context(request, profile_user))

/home/nathan/rb/site/./accounts/models/users.py in get_context(1981)
  return {'comments': (comments, len(comments))}

2 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(357)
  context.update(section.get_context(request, profile_user))

/home/nathan/rb/site/./accounts/models/users.py in get_context(1981)
  return {'comments': (comments, len(comments))}

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

0.18

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(358)
  return render(request, 'accounts/user_profile.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 "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" = 223057
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 223057 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

7 similar queries. Duplicated 7 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

9 similar queries. Duplicated 9 times.

0.08

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

16	`<div class="container">`
17	`{% include 'accounts/includes/user_profile_mobile_menu.html' %}`
18	`<div class="row">`
19	`{% with profile_user.get_privacy_options as privacy_options %}`
20	`{% include "accounts/includes/user_profile_navbar.html" %}`
21
22	`<div class="col-lg-9 col-md-9 col-sm-8 mb-80">`
23

/home/nathan/rb/site/accounts/templates/accounts/user_profile.html

9 similar queries. Duplicated 9 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

11
12	`<!-- Left column - navigation -->`
13	`<div class="col-lg-3 col-md-3 col-sm-4 hidden-xs">`
14	`{% with profile_user.get_privacy_options as privacy_options %}`
15	`{% include 'accounts/includes/user_profile_navbar_card.html' %}`
16
17	`<div class="hidden-xs">`
18	`{% include 'accounts/includes/user_profile_navbar_location.html' %}`

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

9 similar queries. Duplicated 9 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

7 similar queries. Duplicated 7 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./accounts/views/profile.py in user_profile(358)
  return render(request, 'accounts/user_profile.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 "accounts_userstats"."id",
       "accounts_userstats"."user_id",
       "accounts_userstats"."num_profile_views",
       "accounts_userstats"."num_shopper_scans",
       "accounts_userstats"."total_is_stale",
       "accounts_userstats"."total_sets",
       "accounts_userstats"."total_loose_parts",
       "accounts_userstats"."total_lost_set_parts",
       "accounts_userstats"."total_figures",
       "accounts_userstats"."total_all_parts"
  FROM "accounts_userstats"
WHERE "accounts_userstats"."user_id" = 223057
LIMIT 21SELECT ••• FROM "accounts_userstats" WHERE "accounts_userstats"."user_id" = 223057 LIMIT 21

0.33

Connection: default

Transaction status: In transaction

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

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

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

SELECT SUM("accounts_userlostpart"."lost_quantity") AS "lost_quantity__sum"
FROM "accounts_userlostpart"
WHERE "accounts_userlostpart"."user_id" = 223057SELECT ••• FROM "accounts_userlostpart" WHERE "accounts_userlostpart"."user_id" = 223057

0.23

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(89)
  self.total_lost_set_parts = self.user.lost_parts.aggregate(Sum('lost_quantity'))['lost_quantity__sum'] or 0

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

SELECT SUM("accounts_userpart"."quantity") AS "quantity__sum"
FROM "accounts_userpart"
WHERE "accounts_userpart"."user_id" = 223057SELECT ••• FROM "accounts_userpart" WHERE "accounts_userpart"."user_id" = 223057

640.65

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(90)
  self.total_loose_parts = self.user.parts.aggregate(Sum('quantity'))['quantity__sum'] or 0

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

drop table if exists temp_lostsetparts_223057drop table if exists temp_lostsetparts_223057

0.13

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(91)
  self.total_all_parts = get_user_exact_parts_total(self.user)

/home/nathan/rb/site/./lego/build/build.py in get_user_exact_parts_total(628)
  sql = _get_user_myparts_sql(user, True, True, None, None, color_field, '', buildable_only=buildable_only, use_grouping=False, use_cached_data=False, build_options=build_options)

/home/nathan/rb/site/./lego/build/build.py in _get_user_myparts_sql(367)
  create_user_set_lost_parts_temp_table(user)

/home/nathan/rb/site/./lego/build/build.py in create_user_set_lost_parts_temp_table(209)
  run_dml(sql)

/home/nathan/rb/site/./rb/utils.py in run_dml(822)
  cursor.execute(sql, params)

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

create
temporary table temp_lostsetparts_223057 as select min(list_id) as list_id,
       s2.set_id,
       ip2.part_id,
       ip2.color_id,
       ip2.is_spare,
       lp.lost_quantity
  from accounts_userlostpart lp
  join lego_invpart ip2
    on ip2.id=lp.inv_part_id
  join accounts_userset s2
    on s2.inventory_id=ip2.inventory_id
   and s2.user_id=lp.user_id
where lp.user_id = 223057
   and lp.grandparent_inventory_id is null
group by 2,
       3,
       4,
       5,
       6 create temporary table temp_lostsetparts_223057 as select min(list_id) as list_id, s2.set_id, ip2.part_id, ip2.color_id, ip2.is_spare, lp.lost_quantity from accounts_userlostpart lp join lego_invpart ip2 on ip2.id=lp.inv_part_id join accounts_userset s2 on s2.inventory_id=ip2.inventory_id and s2.user_id=lp.user_id where lp.user_id = 223057 and lp.grandparent_inventory_id is null group by 2, 3, 4, 5, 6

6.65

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(91)
  self.total_all_parts = get_user_exact_parts_total(self.user)

/home/nathan/rb/site/./lego/build/build.py in get_user_exact_parts_total(628)
  sql = _get_user_myparts_sql(user, True, True, None, None, color_field, '', buildable_only=buildable_only, use_grouping=False, use_cached_data=False, build_options=build_options)

/home/nathan/rb/site/./lego/build/build.py in _get_user_myparts_sql(367)
  create_user_set_lost_parts_temp_table(user)

/home/nathan/rb/site/./lego/build/build.py in create_user_set_lost_parts_temp_table(219)
  run_dml(sql)

/home/nathan/rb/site/./rb/utils.py in run_dml(822)
  cursor.execute(sql, params)

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

create index temp_lostsetparts_223057_idx
on temp_lostsetparts_223057 (list_id, set_id)create index temp_lostsetparts_223057_idx on temp_lostsetparts_223057 (list_id, set_id)

2.34

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(91)
  self.total_all_parts = get_user_exact_parts_total(self.user)

/home/nathan/rb/site/./lego/build/build.py in get_user_exact_parts_total(628)
  sql = _get_user_myparts_sql(user, True, True, None, None, color_field, '', buildable_only=buildable_only, use_grouping=False, use_cached_data=False, build_options=build_options)

/home/nathan/rb/site/./lego/build/build.py in _get_user_myparts_sql(367)
  create_user_set_lost_parts_temp_table(user)

/home/nathan/rb/site/./lego/build/build.py in create_user_set_lost_parts_temp_table(222)
  run_dml(sql)

/home/nathan/rb/site/./rb/utils.py in run_dml(822)
  cursor.execute(sql, params)

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

   set local enable_gathermerge=off;WITH lostfigparts AS MATERIALIZED /* 223057 */ (
        select invset2.id as invset_id,
               ip2.part_id,
               ip2.color_id,
               lp.lost_quantity
          from accounts_userlostpart lp
          join lego_invpart ip2
            on ip2.id = lp.inv_part_id
          join lego_inventory si2
            on ip2.inventory_id = si2.id
          join lego_invset invset2
            on si2.set_id = invset2.inv_set_id
          join accounts_userset s2
            on s2.inventory_id = invset2.inventory_id
           and s2.user_id = lp.user_id
         where lp.user_id = 223057
           and invset2.inventory_id = lp.grandparent_inventory_id
       ), myparts /* _get_user_myparts_sql */ AS MATERIALIZED (
        SELECT p.part_id as part_group_id,
               color_id,
               quantity
          FROM (
                SELECT 0 as set_id,
                       0 as part_id,
                       0 as color_id,
                       0 as quantity
                 WHERE 1=2
             UNION ALL SELECT /* _get_user_set_parts_sql */ s.set_id,
                       ip.part_id,
                       c.id as color_id,
                       ip.quantity*s.quantity - coalesce(lp.lost_quantity,0) as quantity
                  FROM accounts_userset s
                  JOIN lego_invpart ip
                    on ip.inventory_id=s.inventory_id
                   and (s.include_spares or not ip.is_spare)
                  JOIN lego_color c
                    ON c.id = ip.color_id
                  LEFT OUTER JOIN temp_lostsetparts_223057 lp
                    ON lp.list_id=s.list_id
                   and lp.set_id=s.set_id
                   and lp.part_id=ip.part_id
                   and lp.color_id=ip.color_id
                   and lp.is_spare=ip.is_spare
                 WHERE s.user_id = 223057
             UNION ALL SELECT s.set_id,
                       ip.part_id,
                       c.id as color_id,
                       ip.quantity*s.quantity*invset.quantity - coalesce(lp.lost_quantity,0) as quantity
                  FROM accounts_userset s
                  JOIN lego_invset invset
                    ON invset.inventory_id=s.inventory_id
                  JOIN lego_inventory si
                    ON si.set_id=invset.inv_set_id
                   and si.version = (
                        select max(version)
                          from lego_inventory si2
                         where si.set_id=si2.set_id
                           and si2.is_active
                       )
                  JOIN lego_invpart ip
                    on ip.inventory_id=si.id
                   and (s.include_spares or not ip.is_spare)
                  JOIN lego_color c
                    ON c.id = ip.color_id
                  LEFT OUTER JOIN lostfigparts lp
                    on lp.invset_id=invset.id
                   and ip.part_id=lp.part_id
                   and ip.color_id=lp.color_id
                 WHERE s.user_id = 223057
             UNION ALL SELECT 0,
                       ip.part_id,
                       c.id as color_id,
                       ip.quantity
                  FROM accounts_userpartlist pl
                  JOIN accounts_userpart ip
                    on pl.user_id=ip.user_id
                   and pl.id=ip.list_id
                  JOIN lego_color c
                    ON c.id = ip.color_id
                 WHERE ip.user_id = 223057
               ) p
          LEFT OUTER JOIN lego_partrelationshipflat f
            on p.part_id=f.part_id
       ) SELECT /* get_user_exact_parts_total */ coalesce(sum(my.quantity),0) as quantity
  FROM myparts my
WHERE 1=1 set local enable_gathermerge=off;WITH lostfigparts AS MATERIALIZED /* 223057 */ ( select invset2.id as invset_id, ip2.part_id, ip2.color_id, lp.lost_quantity from accounts_userlostpart lp join lego_invpart ip2 on ip2.id = lp.inv_part_id join lego_inventory si2 on ip2.inventory_id = si2.id join lego_invset invset2 on si2.set_id = invset2.inv_set_id join accounts_userset s2 on s2.inventory_id = invset2.inventory_id and s2.user_id = lp.user_id where lp.user_id = 223057 and invset2.inventory_id = lp.grandparent_inventory_id ), myparts /* _get_user_myparts_sql */ AS MATERIALIZED ( SELECT ••• FROM ( SELECT 0 as set_id, 0 as part_id, 0 as color_id, 0 as quantity WHERE 1=2 UNION ALL SELECT /* _get_user_set_parts_sql */ s.set_id, ip.part_id, c.id as color_id, ip.quantity*s.quantity - coalesce(lp.lost_quantity,0) as quantity FROM accounts_userset s JOIN lego_invpart ip on ip.inventory_id=s.inventory_id and (s.include_spares or not ip.is_spare) JOIN lego_color c ON c.id = ip.color_id LEFT OUTER JOIN temp_lostsetparts_223057 lp ON lp.list_id=s.list_id and lp.set_id=s.set_id and lp.part_id=ip.part_id and lp.color_id=ip.color_id and lp.is_spare=ip.is_spare WHERE s.user_id = 223057 UNION ALL SELECT s.set_id, ip.part_id, c.id as color_id, ip.quantity*s.quantity*invset.quantity - coalesce(lp.lost_quantity,0) as quantity FROM accounts_userset s JOIN lego_invset invset ON invset.inventory_id=s.inventory_id JOIN lego_inventory si ON si.set_id=invset.inv_set_id and si.version = (select max(version) from lego_inventory si2 where si.set_id=si2.set_id and si2.is_active) JOIN lego_invpart ip on ip.inventory_id=si.id and (s.include_spares or not ip.is_spare) JOIN lego_color c ON c.id = ip.color_id LEFT OUTER JOIN lostfigparts lp on lp.invset_id=invset.id and ip.part_id=lp.part_id and ip.color_id=lp.color_id WHERE s.user_id = 223057 UNION ALL SELECT 0, ip.part_id, c.id as color_id, ip.quantity FROM accounts_userpartlist pl JOIN accounts_userpart ip on pl.user_id=ip.user_id and pl.id=ip.list_id JOIN lego_color c ON c.id = ip.color_id WHERE ip.user_id = 223057 ) p LEFT OUTER JOIN lego_partrelationshipflat f on p.part_id=f.part_id ) SELECT /* get_user_exact_parts_total */ coalesce(sum(my.quantity),0) as quantity FROM myparts my WHERE 1=1

2049.88

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(91)
  self.total_all_parts = get_user_exact_parts_total(self.user)

/home/nathan/rb/site/./lego/build/build.py in get_user_exact_parts_total(641)
  data = run_sql(sql, {'user_id': user.id})

/home/nathan/rb/site/./rb/utils.py in run_sql(793)
  cursor.execute(sql, params)

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

SELECT SUM("accounts_userset"."quantity") AS "quantity__sum"
  FROM "accounts_userset"
INNER JOIN "accounts_usersetlist"
    ON ("accounts_userset"."list_id" = "accounts_usersetlist"."id")
INNER JOIN "lego_baseset"
    ON ("accounts_userset"."set_id" = "lego_baseset"."id")
WHERE ("accounts_userset"."user_id" = 223057 AND "accounts_usersetlist"."user_id" = 223057 AND "lego_baseset"."set_type" IN ('Set', 'SubSet', 'BModel', 'MOC'))SELECT ••• FROM "accounts_userset" INNER JOIN "accounts_usersetlist" ON ("accounts_userset"."list_id" = "accounts_usersetlist"."id") INNER JOIN "lego_baseset" ON ("accounts_userset"."set_id" = "lego_baseset"."id") WHERE ("accounts_userset"."user_id" = 223057 AND "accounts_usersetlist"."user_id" = 223057 AND "lego_baseset"."set_type" IN ('Set', 'SubSet', 'BModel', 'MOC'))

5.68

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(92)
  num_sets = self.user.get_num_sets()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_sets(347)
  total_sets = self.sets.filter(set__set_type__in=set_types, list__user=self).aggregate(Sum('quantity'))['quantity__sum'] or 0

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

SELECT "accounts_userset"."id",
       "accounts_userset"."user_id",
       "accounts_userset"."list_id",
       "accounts_userset"."set_id",
       "accounts_userset"."inventory_id",
       "accounts_userset"."quantity",
       "accounts_userset"."include_spares",
       "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_usersetlist"."id",
       "accounts_usersetlist"."user_id",
       "accounts_usersetlist"."name",
       "accounts_usersetlist"."descr",
       "accounts_usersetlist"."is_buildable",
       "accounts_usersetlist"."num_sets",
       "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_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",
       T7."id",
       T7."parent_id",
       T7."name",
       T7."slug",
       T7."set_count",
       T7."t1_id",
       T7."t1_name",
       T7."t2_name",
       T7."t3_name",
       T7."lego_blurb",
       T7."banner_img",
       T7."descr",
       T8."id",
       T8."parent_id",
       T8."name",
       T8."slug",
       T8."set_count",
       T8."t1_id",
       T8."t1_name",
       T8."t2_name",
       T8."t3_name",
       T8."lego_blurb",
       T8."banner_img",
       T8."descr",
       "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",
       T10."id",
       T10."set_num",
       T10."name",
       T10."year",
       T10."theme_id",
       T10."set_type",
       T10."num_parts",
       T10."default_inventory_id",
       T10."is_active",
       T10."is_accessory",
       T10."added_dt",
       T10."added_by_id",
       T10."last_modified_dt",
       T10."last_modified_by_id",
       T10."active_change_dt",
       T10."active_change_by_id",
       T10."last_checked_for_bi",
       T10."descr",
       T10."primary_photo_id",
       T10."primary_moc_image_id",
       T10."is_gear",
       T10."is_book",
       T10."search_vector",
       T10."mfhash_vector",
       "accounts_usersetnote"."id",
       "accounts_usersetnote"."user_set_id",
       "accounts_usersetnote"."is_used",
       "accounts_usersetnote"."location",
       "accounts_usersetnote"."notes"
  FROM "accounts_userset"
INNER JOIN "auth_user"
    ON ("accounts_userset"."user_id" = "auth_user"."id")
INNER JOIN "accounts_usersetlist"
    ON ("accounts_userset"."list_id" = "accounts_usersetlist"."id")
INNER JOIN "lego_baseset"
    ON ("accounts_userset"."set_id" = "lego_baseset"."id")
INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T7
    ON ("lego_theme"."parent_id" = T7."id")
  LEFT OUTER JOIN "lego_theme" T8
    ON (T7."parent_id" = T8."id")
  LEFT OUTER JOIN "lego_setphoto"
    ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id")
  LEFT OUTER JOIN "lego_baseset" T10
    ON ("lego_setphoto"."set_id" = T10."id")
  LEFT OUTER JOIN "accounts_usersetnote"
    ON ("accounts_userset"."id" = "accounts_usersetnote"."user_set_id")
WHERE ("accounts_userset"."inventory_id" IN (SELECT U0."inventory_id" AS "inventory_id" FROM "lego_invset" U0 INNER JOIN "lego_baseset" U1 ON (U0."inv_set_id" = U1."id") WHERE U1."set_type" = 'Figure') AND "accounts_userset"."user_id" = 223057)SELECT ••• FROM "accounts_userset" INNER JOIN "auth_user" ON ("accounts_userset"."user_id" = "auth_user"."id") INNER JOIN "accounts_usersetlist" ON ("accounts_userset"."list_id" = "accounts_usersetlist"."id") INNER JOIN "lego_baseset" ON ("accounts_userset"."set_id" = "lego_baseset"."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T7 ON ("lego_theme"."parent_id" = T7."id") LEFT OUTER JOIN "lego_theme" T8 ON (T7."parent_id" = T8."id") LEFT OUTER JOIN "lego_setphoto" ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id") LEFT OUTER JOIN "lego_baseset" T10 ON ("lego_setphoto"."set_id" = T10."id") LEFT OUTER JOIN "accounts_usersetnote" ON ("accounts_userset"."id" = "accounts_usersetnote"."user_set_id") WHERE ("accounts_userset"."inventory_id" IN (SELECT ••• FROM "lego_invset" U0 INNER JOIN "lego_baseset" U1 ON (U0."inv_set_id" = U1."id") WHERE U1."set_type" = 'Figure') AND "accounts_userset"."user_id" = 223057)

12.35

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(94)
  inv_sets, user_sets = get_user_minifigs(self.user)

/home/nathan/rb/site/./lego/build/build.py in get_user_minifigs(786)
  for user_set in user_sets:

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

SELECT "lego_invset"."id",
       "lego_invset"."inventory_id",
       "lego_invset"."inv_set_id",
       "lego_invset"."quantity",
       "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_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",
       T4."id",
       T4."set_num",
       T4."name",
       T4."year",
       T4."theme_id",
       T4."set_type",
       T4."num_parts",
       T4."default_inventory_id",
       T4."is_active",
       T4."is_accessory",
       T4."added_dt",
       T4."added_by_id",
       T4."last_modified_dt",
       T4."last_modified_by_id",
       T4."active_change_dt",
       T4."active_change_by_id",
       T4."last_checked_for_bi",
       T4."descr",
       T4."primary_photo_id",
       T4."primary_moc_image_id",
       T4."is_gear",
       T4."is_book",
       T4."search_vector",
       T4."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",
       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",
       T7."id",
       T7."parent_id",
       T7."name",
       T7."slug",
       T7."set_count",
       T7."t1_id",
       T7."t1_name",
       T7."t2_name",
       T7."t3_name",
       T7."lego_blurb",
       T7."banner_img",
       T7."descr",
       "lego_set"."baseset_ptr_id",
       "lego_set"."start_date",
       "lego_set"."end_date"
  FROM "lego_invset"
INNER JOIN "lego_inventory"
    ON ("lego_invset"."inventory_id" = "lego_inventory"."id")
INNER JOIN "lego_baseset"
    ON ("lego_inventory"."set_id" = "lego_baseset"."id")
INNER JOIN "lego_baseset" T4
    ON ("lego_invset"."inv_set_id" = T4."id")
INNER JOIN "lego_theme"
    ON (T4."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T6
    ON ("lego_theme"."parent_id" = T6."id")
  LEFT OUTER JOIN "lego_theme" T7
    ON (T6."parent_id" = T7."id")
  LEFT OUTER JOIN "lego_set"
    ON (T4."id" = "lego_set"."baseset_ptr_id")
WHERE "lego_invset"."inventory_id" IN (
        SELECT V0."inventory_id" AS "inventory_id"
          FROM "accounts_userset" V0
         WHERE (V0."inventory_id" IN (SELECT U0."inventory_id" AS "inventory_id" FROM "lego_invset" U0 INNER JOIN "lego_baseset" U1 ON (U0."inv_set_id" = U1."id") WHERE U1."set_type" = 'Figure') AND V0."user_id" = 223057)
       )SELECT ••• FROM "lego_invset" INNER JOIN "lego_inventory" ON ("lego_invset"."inventory_id" = "lego_inventory"."id") INNER JOIN "lego_baseset" ON ("lego_inventory"."set_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T4 ON ("lego_invset"."inv_set_id" = T4."id") INNER JOIN "lego_theme" ON (T4."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T6 ON ("lego_theme"."parent_id" = T6."id") LEFT OUTER JOIN "lego_theme" T7 ON (T6."parent_id" = T7."id") LEFT OUTER JOIN "lego_set" ON (T4."id" = "lego_set"."baseset_ptr_id") WHERE "lego_invset"."inventory_id" IN (SELECT ••• FROM "accounts_userset" V0 WHERE (V0."inventory_id" IN (SELECT ••• FROM "lego_invset" U0 INNER JOIN "lego_baseset" U1 ON (U0."inv_set_id" = U1."id") WHERE U1."set_type" = 'Figure') AND V0."user_id" = 223057))

98.43

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(94)
  inv_sets, user_sets = get_user_minifigs(self.user)

/home/nathan/rb/site/./lego/build/build.py in get_user_minifigs(793)
  for fig in user_inv_sets:

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

SELECT "accounts_userset"."id",
       "accounts_userset"."user_id",
       "accounts_userset"."list_id",
       "accounts_userset"."set_id",
       "accounts_userset"."inventory_id",
       "accounts_userset"."quantity",
       "accounts_userset"."include_spares",
       "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_usersetlist"."id",
       "accounts_usersetlist"."user_id",
       "accounts_usersetlist"."name",
       "accounts_usersetlist"."descr",
       "accounts_usersetlist"."is_buildable",
       "accounts_usersetlist"."num_sets",
       "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_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",
       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",
       T7."id",
       T7."parent_id",
       T7."name",
       T7."slug",
       T7."set_count",
       T7."t1_id",
       T7."t1_name",
       T7."t2_name",
       T7."t3_name",
       T7."lego_blurb",
       T7."banner_img",
       T7."descr",
       "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",
       "accounts_usersetnote"."id",
       "accounts_usersetnote"."user_set_id",
       "accounts_usersetnote"."is_used",
       "accounts_usersetnote"."location",
       "accounts_usersetnote"."notes"
  FROM "accounts_userset"
INNER JOIN "lego_baseset"
    ON ("accounts_userset"."set_id" = "lego_baseset"."id")
INNER JOIN "auth_user"
    ON ("accounts_userset"."user_id" = "auth_user"."id")
INNER JOIN "accounts_usersetlist"
    ON ("accounts_userset"."list_id" = "accounts_usersetlist"."id")
INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T6
    ON ("lego_theme"."parent_id" = T6."id")
  LEFT OUTER JOIN "lego_theme" T7
    ON (T6."parent_id" = T7."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 "accounts_usersetnote"
    ON ("accounts_userset"."id" = "accounts_usersetnote"."user_set_id")
WHERE ("lego_baseset"."set_type" = 'Figure' AND "accounts_userset"."user_id" = 223057)SELECT ••• FROM "accounts_userset" INNER JOIN "lego_baseset" ON ("accounts_userset"."set_id" = "lego_baseset"."id") INNER JOIN "auth_user" ON ("accounts_userset"."user_id" = "auth_user"."id") INNER JOIN "accounts_usersetlist" ON ("accounts_userset"."list_id" = "accounts_usersetlist"."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T6 ON ("lego_theme"."parent_id" = T6."id") LEFT OUTER JOIN "lego_theme" T7 ON (T6."parent_id" = T7."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 "accounts_usersetnote" ON ("accounts_userset"."id" = "accounts_usersetnote"."user_set_id") WHERE ("lego_baseset"."set_type" = 'Figure' AND "accounts_userset"."user_id" = 223057)

28.76

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(95)
  self.total_figures = sum([s.quantity for s in inv_sets]) + sum([s.quantity for s in user_sets])

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."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_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" IN (57936, 60279, 55470, 56171, 50555, 62297, 60974, 55637, 50825, 63922, 58395, 56817, 62863, 57661, 61430, 50894, 61987, 62659, 51357, 54070, 64795, 53121, 54065, 50675, 60515, 51289, 51283, 54474, 50317, 55857, 51082, 51325, 51389, 55863, 51866, 50819, 51840, 60100, 54177, 52150, 62614, 50089, 51446, 63602, 50487, 55932, 64062, 58710, 51374, 60632, 49910, 50186, 58556, 74793, 58747, 58469, 50071, 61248, 51419, 59335, 58312, 60893, 54087, 56016, 60091, 54296, 60969, 59806, 63881, 62439, 49942, 157540, 131865, 51567, 131864, 57466, 54064, 60609, 57934, 83613, 50914, 50621, 60498, 51796, 56106, 62255, 61147, 63236, 50174, 50374, 54433, 73213, 52758, 53722, 53190, 60467, 53720, 53721, 58921, 51282, 53533, 72767, 60468, 58311, 58320, 58300, 56430, 57047, 51302, 50543, 51944, 51662, 55889, 58302, 56411, 60087, 55160, 64499, 52684, 52686, 55060, 58309, 56066, 53565, 53563, 53564, 49903, 119291, 58321, 57666, 57665, 51704, 50455, 50230, 57326, 53730, 50801, 50631, 57388, 55869, 53574, 55870, 56010, 53026, 52468, 55442, 54360, 54361, 50443, 54305, 50102, 51571, 51859, 49141, 51564, 57662, 57663, 64331, 50759, 51385, 50793, 49920, 64328, 61166, 61059, 52691, 54359, 56574, 57664, 52467, 51868, 66305, 50529, 51566, 53188, 51284, 64734, 50645, 50998, 51641, 56753, 63885, 167760, 167753, 51609, 157323, 53613, 200467, 50826, 49939, 200441, 200464, 200450, 51496, 50876, 200446, 200442, 200461, 50039, 60598, 56222, 51679, 50287, 57796, 50868, 64487, 61045, 57302, 51183, 64746, 53420, 62990, 64293, 54501, 54121, 50774, 51765, 59324, 50228, 55380, 50762, 57794, 49875, 57481, 54602, 51759, 51731, 55368, 61426, 53423, 54734, 51297, 58471, 53119, 59410, 64575, 51938, 63883, 61136, 56548, 51290, 50092, 54067, 56635, 51976, 50033, 51751, 51605, 50430, 57932, 51318, 51209, 50396, 50746, 63915, 57715, 63920, 54057, 54378, 60296, 50050, 63823, 61742, 50291, 61060, 60086, 50474, 50159, 57470, 54509, 62989, 54052, 55527, 55016, 53902, 55531, 52118, 54596, 57799, 54432, 52466, 54106, 49914, 51149, 55447, 61419, 63918, 54131, 50453, 50346, 59592, 64708, 55528, 51517, 200445, 200466, 200458, 58913, 200439, 200460, 54072, 61265, 54059, 59496, 57808, 61238, 58470, 50806, 51625, 62256, 50494, 49964, 64167, 64039, 59657, 60592, 60512, 50431, 49961, 54320, 50328, 57476, 51723, 58611, 52367, 64836, 50456, 55996, 56539, 61728, 58459, 58292, 58544, 53878, 58820, 64312, 61257, 49952, 53060, 54053, 55929, 55517, 54304, 57463, 55154, 59310, 50926, 60280, 52675, 57473, 55515, 53082, 57768, 55933, 58303, 55526, 50862, 62257, 57471, 57468, 55275, 57483, 58394, 55498, 50268, 60056, 62648, 57933, 64722, 58839, 128624, 51896, 60866, 57152, 62292, 59349, 64577, 50830, 50301, 52181, 63921, 64597, 53206, 157329, 60879, 61176, 60606, 57364, 53608, 61428, 50650, 55358, 57809, 61260, 49948, 50277, 57484, 63889, 64230, 53093, 58480, 63152, 61062, 61153, 52388, 57464, 51280, 50156, 51443, 53700, 57935, 57668, 61333, 60050, 64794, 52461, 64793, 64719, 64011, 50596, 50493, 52089, 51249, 56718, 53073, 50892, 55523, 57672, 56551, 49994, 59989, 57296, 51298, 55355, 62456, 64495, 61292, 55914, 54916, 50489, 50451, 51991, 64018, 64278, 50150, 58755, 50548, 54142, 50730, 51058, 58479, 53513, 55004, 64782, 57995, 63919, 61137, 64126, 50232, 52102, 58840, 64620, 64925, 60271, 58832, 113879, 113878, 51085, 51119, 50281, 50696, 53279, 53890, 55422, 51182, 63886, 58642, 55902, 57328, 59280, 51254, 99801, 50954, 50053, 50190, 57508, 60303, 54497, 50486, 58760, 58415, 51591, 55936, 52397, 136711, 54104, 60638, 50787, 55466, 59114, 59538, 50234, 50452, 54802, 58473, 53203, 59317, 55433, 51038, 49985, 55421, 54050, 57161, 64787, 50679, 57482, 54944, 64017, 64481, 53238, 56310, 50088, 57480, 53886, 56239, 62290, 53106, 54073, 60762, 62957, 61131, 51265, 52769, 64588, 55360, 52359, 64563, 65111, 51135, 64020, 53418, 54479, 58447, 58230, 57478, 54682, 50245, 61298, 58250, 59283, 56064, 57472, 58827, 50025, 56077, 58749, 58299, 58310, 58307, 62408, 61132, 60978, 60611, 64226, 50288, 51130, 54993, 51732, 58215, 51624, 65548, 55901, 52204, 58745, 53922, 54274, 59315, 58365, 64715, 58838, 149911, 54823, 59823, 53438, 51076, 50302, 50898, 56293, 58475, 58467, 58476, 58481, 58477, 50966, 58709, 57389, 50032, 51630, 60633, 63871, 53534, 58726, 58420, 60622, 57157, 55913, 57462, 55922, 58445, 50816, 52395, 50566, 51221, 56353, 49883, 51222, 58417, 79769, 51117, 53638, 58244, 58443, 54051, 58421, 50502, 52394, 58235, 58416, 58423, 64599, 61816, 145297, 54456, 51388, 54612, 56061, 59829, 50019, 58861, 52505, 57115, 52501, 55339, 50305, 54611, 51929, 51296, 51913, 52020, 58858, 52365, 52096, 60452, 50798, 119797, 57991, 65075, 56578, 57368, 58626, 55518, 50709, 50259, 53365, 51263, 50708, 61323, 54738, 54588, 51541, 49485, 64198, 51015, 60816, 52504, 52888, 63797, 58087, 119204, 56811, 56810, 59327, 58069, 59815, 51022, 50306, 56362, 57100, 50524, 64945, 64233, 61205, 53877, 56829, 56666, 56056, 63791, 52389, 56055, 61155, 52169, 54457, 64292, 58128, 56404, 60223, 50667, 56427, 52172, 57119, 58082, 50698, 52030, 65242, 58110, 58127, 52072, 58065, 58141, 58283, 59817, 52351, 52080, 56812, 169535, 61761, 49484, 64946, 56865, 59819, 54127, 51873, 51543, 52522, 65035, 51028, 59432, 58319, 61700, 50552, 49938, 119572, 50437, 51154, 53519, 185719, 51733, 50724, 56271, 51572, 56336, 64830, 49142, 52443, 52978, 53889, 62423, 50597, 57099, 60146, 50060, 57512, 52484, 58304, 64709, 56651, 50395, 56068, 64064, 74786, 56648, 56252, 60228, 52358, 53448, 56536, 56370, 51210, 55337, 64533, 64824, 54379, 51920, 61264, 52503, 55499, 64940, 55340, 59326, 49487, 51557, 61724, 58863, 51469, 51406, 52073, 119454, 64010, 54071, 58645, 50849, 63173, 60461, 51208, 64948, 58298, 50484, 63612, 50108, 63189, 52190, 53057, 52077, 53597, 50779, 51851, 61815, 157536, 55409, 50822, 50778, 51317, 51597, 51858, 51470, 57442, 56426, 51869, 51224, 58874, 51853, 50777, 51106, 50873, 54948, 55939, 51196, 51339, 58028, 58033, 58032, 58031, 50707, 58030, 58027, 58029, 97859, 58885, 56059, 50823, 71592, 142130, 50407, 50669, 56017, 62972, 50624, 54815, 58063, 51653, 50736, 51176, 62294, 61211, 56488, 56487, 50576, 56424, 50282, 50582, 50559, 51421, 56449, 61983, 50600, 49926, 63633, 50473, 51079, 53612, 50802, 50883, 57024, 50975, 56308, 51240, 63184, 56485, 51023, 50531, 87029, 51237, 63174, 49876, 58197, 63172, 60293, 58252, 62703, 145220, 185817, 82487, 56486, 58424, 56172, 56567, 64527, 50081, 51599, 50296, 63171, 64929, 50992, 63477, 63482, 61575, 57616, 58214, 145222, 209378, 56489, 61989, 51291, 61196, 55392, 56512, 50119, 131388, 58419, 50197, 55389, 56819, 51992, 58444, 50002, 185808, 55400, 51112, 63474, 56180, 64384, 136536, 56393, 82497, 100014, 56482, 51396, 50500, 59758, 56506, 57854, 56457, 61162, 57620, 126312, 61142, 145218, 126311, 56562, 56456, 61306, 55398, 70120, 60805, 61161, 51160, 51521, 145223, 49944, 51390, 136601, 131387, 58461, 56513, 51211, 58209, 61307, 57621, 58439, 100034, 100011, 63473, 63476, 49921, 50247, 61311, 56484, 185813, 51394, 145219, 57622, 57617, 57855, 61454, 60804, 56565, 63481, 126313, 136538, 60625, 56505, 145216, 51676, 185816, 123364, 56490, 50061, 55445, 58945, 57618, 57827, 185809, 100013, 51865, 63644, 56483, 136537, 50196, 51066, 63475, 59811, 56448, 51918, 51386, 103936, 60497, 56514, 60885, 51198, 50908, 51127, 56566, 51663, 51024, 58281, 57623, 56491, 59813, 185810, 53424, 63479, 56425, 55853, 60803, 49981, 126314, 136539, 51150, 97855, 51819, 51334, 50939, 50427, 59732, 53776, 100298, 59734, 58153, 60519, 119149, 100302, 61159, 64304, 100297, 59733, 55852, 55854, 108539, 51569, 51399, 62983, 171068, 157555, 171071, 51369, 51097, 56436, 50677, 51373, 51423, 57774, 57775, 57773, 57649, 50467, 57647, 50958, 51994, 58064, 55351, 57648, 57650, 49897, 51582)SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" IN (57936, 60279, 55470, 56171, 50555, 62297, 60974, 55637, 50825, 63922, 58395, 56817, 62863, 57661, 61430, 50894, 61987, 62659, 51357, 54070, 64795, 53121, 54065, 50675, 60515, 51289, 51283, 54474, 50317, 55857, 51082, 51325, 51389, 55863, 51866, 50819, 51840, 60100, 54177, 52150, 62614, 50089, 51446, 63602, 50487, 55932, 64062, 58710, 51374, 60632, 49910, 50186, 58556, 74793, 58747, 58469, 50071, 61248, 51419, 59335, 58312, 60893, 54087, 56016, 60091, 54296, 60969, 59806, 63881, 62439, 49942, 157540, 131865, 51567, 131864, 57466, 54064, 60609, 57934, 83613, 50914, 50621, 60498, 51796, 56106, 62255, 61147, 63236, 50174, 50374, 54433, 73213, 52758, 53722, 53190, 60467, 53720, 53721, 58921, 51282, 53533, 72767, 60468, 58311, 58320, 58300, 56430, 57047, 51302, 50543, 51944, 51662, 55889, 58302, 56411, 60087, 55160, 64499, 52684, 52686, 55060, 58309, 56066, 53565, 53563, 53564, 49903, 119291, 58321, 57666, 57665, 51704, 50455, 50230, 57326, 53730, 50801, 50631, 57388, 55869, 53574, 55870, 56010, 53026, 52468, 55442, 54360, 54361, 50443, 54305, 50102, 51571, 51859, 49141, 51564, 57662, 57663, 64331, 50759, 51385, 50793, 49920, 64328, 61166, 61059, 52691, 54359, 56574, 57664, 52467, 51868, 66305, 50529, 51566, 53188, 51284, 64734, 50645, 50998, 51641, 56753, 63885, 167760, 167753, 51609, 157323, 53613, 200467, 50826, 49939, 200441, 200464, 200450, 51496, 50876, 200446, 200442, 200461, 50039, 60598, 56222, 51679, 50287, 57796, 50868, 64487, 61045, 57302, 51183, 64746, 53420, 62990, 64293, 54501, 54121, 50774, 51765, 59324, 50228, 55380, 50762, 57794, 49875, 57481, 54602, 51759, 51731, 55368, 61426, 53423, 54734, 51297, 58471, 53119, 59410, 64575, 51938, 63883, 61136, 56548, 51290, 50092, 54067, 56635, 51976, 50033, 51751, 51605, 50430, 57932, 51318, 51209, 50396, 50746, 63915, 57715, 63920, 54057, 54378, 60296, 50050, 63823, 61742, 50291, 61060, 60086, 50474, 50159, 57470, 54509, 62989, 54052, 55527, 55016, 53902, 55531, 52118, 54596, 57799, 54432, 52466, 54106, 49914, 51149, 55447, 61419, 63918, 54131, 50453, 50346, 59592, 64708, 55528, 51517, 200445, 200466, 200458, 58913, 200439, 200460, 54072, 61265, 54059, 59496, 57808, 61238, 58470, 50806, 51625, 62256, 50494, 49964, 64167, 64039, 59657, 60592, 60512, 50431, 49961, 54320, 50328, 57476, 51723, 58611, 52367, 64836, 50456, 55996, 56539, 61728, 58459, 58292, 58544, 53878, 58820, 64312, 61257, 49952, 53060, 54053, 55929, 55517, 54304, 57463, 55154, 59310, 50926, 60280, 52675, 57473, 55515, 53082, 57768, 55933, 58303, 55526, 50862, 62257, 57471, 57468, 55275, 57483, 58394, 55498, 50268, 60056, 62648, 57933, 64722, 58839, 128624, 51896, 60866, 57152, 62292, 59349, 64577, 50830, 50301, 52181, 63921, 64597, 53206, 157329, 60879, 61176, 60606, 57364, 53608, 61428, 50650, 55358, 57809, 61260, 49948, 50277, 57484, 63889, 64230, 53093, 58480, 63152, 61062, 61153, 52388, 57464, 51280, 50156, 51443, 53700, 57935, 57668, 61333, 60050, 64794, 52461, 64793, 64719, 64011, 50596, 50493, 52089, 51249, 56718, 53073, 50892, 55523, 57672, 56551, 49994, 59989, 57296, 51298, 55355, 62456, 64495, 61292, 55914, 54916, 50489, 50451, 51991, 64018, 64278, 50150, 58755, 50548, 54142, 50730, 51058, 58479, 53513, 55004, 64782, 57995, 63919, 61137, 64126, 50232, 52102, 58840, 64620, 64925, 60271, 58832, 113879, 113878, 51085, 51119, 50281, 50696, 53279, 53890, 55422, 51182, 63886, 58642, 55902, 57328, 59280, 51254, 99801, 50954, 50053, 50190, 57508, 60303, 54497, 50486, 58760, 58415, 51591, 55936, 52397, 136711, 54104, 60638, 50787, 55466, 59114, 59538, 50234, 50452, 54802, 58473, 53203, 59317, 55433, 51038, 49985, 55421, 54050, 57161, 64787, 50679, 57482, 54944, 64017, 64481, 53238, 56310, 50088, 57480, 53886, 56239, 62290, 53106, 54073, 60762, 62957, 61131, 51265, 52769, 64588, 55360, 52359, 64563, 65111, 51135, 64020, 53418, 54479, 58447, 58230, 57478, 54682, 50245, 61298, 58250, 59283, 56064, 57472, 58827, 50025, 56077, 58749, 58299, 58310, 58307, 62408, 61132, 60978, 60611, 64226, 50288, 51130, 54993, 51732, 58215, 51624, 65548, 55901, 52204, 58745, 53922, 54274, 59315, 58365, 64715, 58838, 149911, 54823, 59823, 53438, 51076, 50302, 50898, 56293, 58475, 58467, 58476, 58481, 58477, 50966, 58709, 57389, 50032, 51630, 60633, 63871, 53534, 58726, 58420, 60622, 57157, 55913, 57462, 55922, 58445, 50816, 52395, 50566, 51221, 56353, 49883, 51222, 58417, 79769, 51117, 53638, 58244, 58443, 54051, 58421, 50502, 52394, 58235, 58416, 58423, 64599, 61816, 145297, 54456, 51388, 54612, 56061, 59829, 50019, 58861, 52505, 57115, 52501, 55339, 50305, 54611, 51929, 51296, 51913, 52020, 58858, 52365, 52096, 60452, 50798, 119797, 57991, 65075, 56578, 57368, 58626, 55518, 50709, 50259, 53365, 51263, 50708, 61323, 54738, 54588, 51541, 49485, 64198, 51015, 60816, 52504, 52888, 63797, 58087, 119204, 56811, 56810, 59327, 58069, 59815, 51022, 50306, 56362, 57100, 50524, 64945, 64233, 61205, 53877, 56829, 56666, 56056, 63791, 52389, 56055, 61155, 52169, 54457, 64292, 58128, 56404, 60223, 50667, 56427, 52172, 57119, 58082, 50698, 52030, 65242, 58110, 58127, 52072, 58065, 58141, 58283, 59817, 52351, 52080, 56812, 169535, 61761, 49484, 64946, 56865, 59819, 54127, 51873, 51543, 52522, 65035, 51028, 59432, 58319, 61700, 50552, 49938, 119572, 50437, 51154, 53519, 185719, 51733, 50724, 56271, 51572, 56336, 64830, 49142, 52443, 52978, 53889, 62423, 50597, 57099, 60146, 50060, 57512, 52484, 58304, 64709, 56651, 50395, 56068, 64064, 74786, 56648, 56252, 60228, 52358, 53448, 56536, 56370, 51210, 55337, 64533, 64824, 54379, 51920, 61264, 52503, 55499, 64940, 55340, 59326, 49487, 51557, 61724, 58863, 51469, 51406, 52073, 119454, 64010, 54071, 58645, 50849, 63173, 60461, 51208, 64948, 58298, 50484, 63612, 50108, 63189, 52190, 53057, 52077, 53597, 50779, 51851, 61815, 157536, 55409, 50822, 50778, 51317, 51597, 51858, 51470, 57442, 56426, 51869, 51224, 58874, 51853, 50777, 51106, 50873, 54948, 55939, 51196, 51339, 58028, 58033, 58032, 58031, 50707, 58030, 58027, 58029, 97859, 58885, 56059, 50823, 71592, 142130, 50407, 50669, 56017, 62972, 50624, 54815, 58063, 51653, 50736, 51176, 62294, 61211, 56488, 56487, 50576, 56424, 50282, 50582, 50559, 51421, 56449, 61983, 50600, 49926, 63633, 50473, 51079, 53612, 50802, 50883, 57024, 50975, 56308, 51240, 63184, 56485, 51023, 50531, 87029, 51237, 63174, 49876, 58197, 63172, 60293, 58252, 62703, 145220, 185817, 82487, 56486, 58424, 56172, 56567, 64527, 50081, 51599, 50296, 63171, 64929, 50992, 63477, 63482, 61575, 57616, 58214, 145222, 209378, 56489, 61989, 51291, 61196, 55392, 56512, 50119, 131388, 58419, 50197, 55389, 56819, 51992, 58444, 50002, 185808, 55400, 51112, 63474, 56180, 64384, 136536, 56393, 82497, 100014, 56482, 51396, 50500, 59758, 56506, 57854, 56457, 61162, 57620, 126312, 61142, 145218, 126311, 56562, 56456, 61306, 55398, 70120, 60805, 61161, 51160, 51521, 145223, 49944, 51390, 136601, 131387, 58461, 56513, 51211, 58209, 61307, 57621, 58439, 100034, 100011, 63473, 63476, 49921, 50247, 61311, 56484, 185813, 51394, 145219, 57622, 57617, 57855, 61454, 60804, 56565, 63481, 126313, 136538, 60625, 56505, 145216, 51676, 185816, 123364, 56490, 50061, 55445, 58945, 57618, 57827, 185809, 100013, 51865, 63644, 56483, 136537, 50196, 51066, 63475, 59811, 56448, 51918, 51386, 103936, 60497, 56514, 60885, 51198, 50908, 51127, 56566, 51663, 51024, 58281, 57623, 56491, 59813, 185810, 53424, 63479, 56425, 55853, 60803, 49981, 126314, 136539, 51150, 97855, 51819, 51334, 50939, 50427, 59732, 53776, 100298, 59734, 58153, 60519, 119149, 100302, 61159, 64304, 100297, 59733, 55852, 55854, 108539, 51569, 51399, 62983, 171068, 157555, 171071, 51369, 51097, 56436, 50677, 51373, 51423, 57774, 57775, 57773, 57649, 50467, 57647, 50958, 51994, 58064, 55351, 57648, 57650, 49897, 51582)

2.72

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(95)
  self.total_figures = sum([s.quantity for s in inv_sets]) + sum([s.quantity for s in user_sets])

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

UPDATE "accounts_userstats"
   SET "user_id" = 223057,
       "num_profile_views" = 2490,
       "num_shopper_scans" = 0,
       "total_is_stale" = false, "total_sets" = 326,
       "total_loose_parts" = 249178,
       "total_lost_set_parts" = 0,
       "total_figures" = 1374,
       "total_all_parts" = 518970
WHERE "accounts_userstats"."id" = 154369UPDATE "accounts_userstats" SET "user_id" = 223057, "num_profile_views" = 2490, "num_shopper_scans" = 0, "total_is_stale" = false, "total_sets" = 326, "total_loose_parts" = 249178, "total_lost_set_parts" = 0, "total_figures" = 1374, "total_all_parts" = 518970 WHERE "accounts_userstats"."id" = 154369

11.24

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_parts_summary(396)
  return self.stats.get_num_parts_summary()

/home/nathan/rb/site/./accounts/models/stats.py in get_num_parts_summary(108)
  self.recalculate_stats()

/home/nathan/rb/site/./accounts/models/stats.py in recalculate_stats(98)
  self.save()

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 %}`
32
33	`{% if request.user == profile_user or privacy_options.is_public_plan %}`
34	`{% if not profile_user.plan.plan.is_free %}`

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

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

0.14

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

0.16

Connection: default

Transaction status: In transaction

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

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

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

52	`{% endwith %}`
53	`{% endif %}`
54
55	`{% if profile_user.profile.trophy_badge.badge and privacy_options.is_public_badges %}`
56	`<a href="{% url 'badges' %}#{{ profile_user.profile.trophy_badge.badge.code }}">`
57	`<div class="text-center" style="margin:auto">`
58	`{% render_badge profile_user.profile.trophy_badge.badge %}`
59	`</div>`

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

SELECT "accounts_userbadge"."id",
       "accounts_userbadge"."user_id",
       "accounts_userbadge"."badge_id"
  FROM "accounts_userbadge"
WHERE "accounts_userbadge"."id" = 502292
LIMIT 21SELECT ••• FROM "accounts_userbadge" WHERE "accounts_userbadge"."id" = 502292 LIMIT 21

0.24

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

52	`{% endwith %}`
53	`{% endif %}`
54
55	`{% if profile_user.profile.trophy_badge.badge and privacy_options.is_public_badges %}`
56	`<a href="{% url 'badges' %}#{{ profile_user.profile.trophy_badge.badge.code }}">`
57	`<div class="text-center" style="margin:auto">`
58	`{% render_badge profile_user.profile.trophy_badge.badge %}`
59	`</div>`

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

SELECT "lego_badge"."id",
       "lego_badge"."code",
       "lego_badge"."level",
       "lego_badge"."name",
       "lego_badge"."descr",
       "lego_badge"."num_users"
  FROM "lego_badge"
WHERE "lego_badge"."id" = 62
LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 62 LIMIT 21

7 similar queries. Duplicated 2 times.

0.07

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

52	`{% endwith %}`
53	`{% endif %}`
54
55	`{% if profile_user.profile.trophy_badge.badge and privacy_options.is_public_badges %}`
56	`<a href="{% url 'badges' %}#{{ profile_user.profile.trophy_badge.badge.code }}">`
57	`<div class="text-center" style="margin:auto">`
58	`{% render_badge profile_user.profile.trophy_badge.badge %}`
59	`</div>`

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

SELECT COUNT(*) AS "__count"
FROM "accounts_userprofile"
WHERE UPPER("accounts_userprofile"."location"::text) = UPPER('Newton Aycliffe')SELECT ••• FROM "accounts_userprofile" WHERE UPPER("accounts_userprofile"."location"::text) = UPPER('Newton Aycliffe')

2 similar queries. Duplicated 2 times.

0.30

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_users_at_location(610)
  return UserProfile.objects.filter(location__iexact=self.profile.location).count()

5	`<div class="mb-30 border box-light">`
6	`<div class="box-inner">`
7	`<h4 class="mb-0"><i class="fa fa-globe"></i> {{ profile_user.profile.location }}</h4>`
8	`<p><small>There are {{ profile_user.get_num_users_at_location }} users from this location</small></p>`
9
10	`{% if profile_user.profile.website_url and profile_user.level >= settings.LEVEL_SHOW_PERSONAL_URL %}`
11	`<div class="trunc"><a href="{% get_external_url profile_user.profile.website_url 'action=ProfileLink&site=Personal'\|addstr:'&user='\|addstr:profile_user.id %}" target="_blank" rel="nofollow"><i class="fa fa-external-link"></i> {{ profile_user.profile.website_url }}</a></div>`
12	`{% endif %}`

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

SELECT COUNT(*) AS "__count"
FROM "accounts_usertrophy"
WHERE "accounts_usertrophy"."user_id" = 223057SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 223057

2 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

1	`{% if profile_user.trophies.count > 0 %}`
2	`<div class="mb-30 border box-light">`
3	`<div class="box-inner">`
4	`<h4><i class="fa fa-trophy"></i> TROPHY CASE</h4>`
5	`{% for trophy in profile_user.trophies.all %}`

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

SELECT "accounts_usertrophy"."id",
       "accounts_usertrophy"."user_id",
       "accounts_usertrophy"."link",
       "accounts_usertrophy"."title",
       "accounts_usertrophy"."img"
  FROM "accounts_usertrophy"
WHERE "accounts_usertrophy"."user_id" = 223057SELECT ••• FROM "accounts_usertrophy" WHERE "accounts_usertrophy"."user_id" = 223057

2 similar queries. Duplicated 2 times.

0.07

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

2	`<div class="mb-30 border box-light">`
3	`<div class="box-inner">`
4	`<h4><i class="fa fa-trophy"></i> TROPHY CASE</h4>`
5	`{% for trophy in profile_user.trophies.all %}`
6	`<div class="inline-block mr-10">`
7	`<a href="{{ trophy.link }}"><img src="{{ trophy.img }}?b" height="50px" title="{{ trophy.title }}"></a>`
8	`</div>`
9	`{% endfor %}`

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

SELECT "accounts_userrank"."user_id",
       "accounts_userrank"."rank_points",
       "accounts_userrank"."rank_parts",
       "accounts_userrank"."rank_views"
  FROM "accounts_userrank"
WHERE "accounts_userrank"."user_id" = 223057
LIMIT 21SELECT ••• FROM "accounts_userrank" WHERE "accounts_userrank"."user_id" = 223057 LIMIT 21

0.17

Connection: default

Transaction status: In transaction

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

142	`</div>`
143	`</div>`
144
145	`{% if profile_user.rank.rank_views > 0 or profile_user.rank.rank_points > 0 %}`
146	`<div class="box-inner mb-20 hidden-xs">`
147	`<h2><i class="fa fa-line-chart"></i> USER RANKINGS</h2>`
148	`{% if profile_user.rank.rank_points > 0 %}`
149	`<div class="row row-condensed" title="Number of Points (Rank 1 = highest)">`

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

SELECT "accounts_userbadge"."id",
       "accounts_userbadge"."user_id",
       "accounts_userbadge"."badge_id"
  FROM "accounts_userbadge"
INNER JOIN "lego_badge"
    ON ("accounts_userbadge"."badge_id" = "lego_badge"."id")
WHERE "accounts_userbadge"."user_id" = 223057
ORDER BY "lego_badge"."num_users" ASC
LIMIT 6SELECT ••• FROM "accounts_userbadge" INNER JOIN "lego_badge" ON ("accounts_userbadge"."badge_id" = "lego_badge"."id") WHERE "accounts_userbadge"."user_id" = 223057 ORDER BY "lego_badge"."num_users" ASC LIMIT 6

0.86

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

10	`{% include 'accounts/includes/user_profile_section_menu.html' %}`
11	`</div>`
12	`{% if is_public_badges %}`
13	`{% if best_badges\|length > 0 %}`
14	`<div class="row row-condensed">`
15	`{% for badge in best_badges %}`
16	`<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-sm hidden-xs{% endif %}">`
17	`<a href="{% url 'badges' %}#{{ badge.badge.code }}">`

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

7 similar queries. Duplicated 2 times.

0.09

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

14	`<div class="row row-condensed">`
15	`{% for badge in best_badges %}`
16	`<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-sm hidden-xs{% endif %}">`
17	`<a href="{% url 'badges' %}#{{ badge.badge.code }}">`
18	`{% render_badge badge.badge %}`
19	`</a>`
20	`</div>`
21	`{% endfor %}`

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

SELECT "lego_badge"."id",
       "lego_badge"."code",
       "lego_badge"."level",
       "lego_badge"."name",
       "lego_badge"."descr",
       "lego_badge"."num_users"
  FROM "lego_badge"
WHERE "lego_badge"."id" = 33
LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 33 LIMIT 21

7 similar queries.

0.09

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

14	`<div class="row row-condensed">`
15	`{% for badge in best_badges %}`
16	`<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-sm hidden-xs{% endif %}">`
17	`<a href="{% url 'badges' %}#{{ badge.badge.code }}">`
18	`{% render_badge badge.badge %}`
19	`</a>`
20	`</div>`
21	`{% endfor %}`

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

SELECT "lego_badge"."id",
       "lego_badge"."code",
       "lego_badge"."level",
       "lego_badge"."name",
       "lego_badge"."descr",
       "lego_badge"."num_users"
  FROM "lego_badge"
WHERE "lego_badge"."id" = 44
LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 44 LIMIT 21

7 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

14	`<div class="row row-condensed">`
15	`{% for badge in best_badges %}`
16	`<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-sm hidden-xs{% endif %}">`
17	`<a href="{% url 'badges' %}#{{ badge.badge.code }}">`
18	`{% render_badge badge.badge %}`
19	`</a>`
20	`</div>`
21	`{% endfor %}`

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

SELECT "lego_badge"."id",
       "lego_badge"."code",
       "lego_badge"."level",
       "lego_badge"."name",
       "lego_badge"."descr",
       "lego_badge"."num_users"
  FROM "lego_badge"
WHERE "lego_badge"."id" = 56
LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 56 LIMIT 21

7 similar queries.

0.09

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

14	`<div class="row row-condensed">`
15	`{% for badge in best_badges %}`
16	`<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-sm hidden-xs{% endif %}">`
17	`<a href="{% url 'badges' %}#{{ badge.badge.code }}">`
18	`{% render_badge badge.badge %}`
19	`</a>`
20	`</div>`
21	`{% endfor %}`

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

SELECT "lego_badge"."id",
       "lego_badge"."code",
       "lego_badge"."level",
       "lego_badge"."name",
       "lego_badge"."descr",
       "lego_badge"."num_users"
  FROM "lego_badge"
WHERE "lego_badge"."id" = 26
LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 26 LIMIT 21

7 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

14	`<div class="row row-condensed">`
15	`{% for badge in best_badges %}`
16	`<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-sm hidden-xs{% endif %}">`
17	`<a href="{% url 'badges' %}#{{ badge.badge.code }}">`
18	`{% render_badge badge.badge %}`
19	`</a>`
20	`</div>`
21	`{% endfor %}`

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

SELECT "lego_badge"."id",
       "lego_badge"."code",
       "lego_badge"."level",
       "lego_badge"."name",
       "lego_badge"."descr",
       "lego_badge"."num_users"
  FROM "lego_badge"
WHERE "lego_badge"."id" = 38
LIMIT 21SELECT ••• FROM "lego_badge" WHERE "lego_badge"."id" = 38 LIMIT 21

7 similar queries.

0.09

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

14	`<div class="row row-condensed">`
15	`{% for badge in best_badges %}`
16	`<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-sm hidden-xs{% endif %}">`
17	`<a href="{% url 'badges' %}#{{ badge.badge.code }}">`
18	`{% render_badge badge.badge %}`
19	`</a>`
20	`</div>`
21	`{% endfor %}`

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

7 similar queries. Duplicated 7 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="rb-comment__avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="rb-comment__avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="rb-comment__collapse-control js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

6 similar queries. Duplicated 6 times.

0.14

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

55	`<a href="/help/users-levels/">`
56	`<span class="rb-chip rb-chip--sm rb-chip--light" title="Based on {{ comment.user.points\|int_to_abbr }} points">Level {{ comment.user.level }}</span>`
57	`</a>`
58	`{% if comment.user.is_admin %}`
59	`<a href="{% url 'about' %}#roles" title="This user has an Administrator role"><span class="rb-chip rb-chip--sm rb-chip--danger">{{ comment.user.get_rolename.0 }}</span></a>`
60	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
61	`<span class="rb-chip rb-chip--sm rb-chip--premium" title="This user designed this MOC">Designed this MOC</span>`
62	`{% elif comment.user.get_rolename.0 %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

9 similar queries. Duplicated 9 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(670)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285)
  options = self.get_privacy_options()

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

63	`<span class="rb-chip rb-chip--sm rb-chip--info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
64	`{% endif %}`
65	`{% if not comment.user.plan.is_free %}`
66	`{% if comment.user.is_public_plan %}`
67	`{{ comment.user.get_plan_html }}`
68	`{% endif %}`
69	`{% endif %}`
70	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

7 similar queries. Duplicated 7 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="rb-comment__avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="rb-comment__avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="rb-comment__collapse-control js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

6 similar queries. Duplicated 6 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

55	`<a href="/help/users-levels/">`
56	`<span class="rb-chip rb-chip--sm rb-chip--light" title="Based on {{ comment.user.points\|int_to_abbr }} points">Level {{ comment.user.level }}</span>`
57	`</a>`
58	`{% if comment.user.is_admin %}`
59	`<a href="{% url 'about' %}#roles" title="This user has an Administrator role"><span class="rb-chip rb-chip--sm rb-chip--danger">{{ comment.user.get_rolename.0 }}</span></a>`
60	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
61	`<span class="rb-chip rb-chip--sm rb-chip--premium" title="This user designed this MOC">Designed this MOC</span>`
62	`{% elif comment.user.get_rolename.0 %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

9 similar queries. Duplicated 9 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(670)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285)
  options = self.get_privacy_options()

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

63	`<span class="rb-chip rb-chip--sm rb-chip--info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
64	`{% endif %}`
65	`{% if not comment.user.plan.is_free %}`
66	`{% if comment.user.is_public_plan %}`
67	`{{ comment.user.get_plan_html }}`
68	`{% endif %}`
69	`{% endif %}`
70	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

7 similar queries. Duplicated 7 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="rb-comment__avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="rb-comment__avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="rb-comment__collapse-control js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

6 similar queries. Duplicated 6 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

55	`<a href="/help/users-levels/">`
56	`<span class="rb-chip rb-chip--sm rb-chip--light" title="Based on {{ comment.user.points\|int_to_abbr }} points">Level {{ comment.user.level }}</span>`
57	`</a>`
58	`{% if comment.user.is_admin %}`
59	`<a href="{% url 'about' %}#roles" title="This user has an Administrator role"><span class="rb-chip rb-chip--sm rb-chip--danger">{{ comment.user.get_rolename.0 }}</span></a>`
60	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
61	`<span class="rb-chip rb-chip--sm rb-chip--premium" title="This user designed this MOC">Designed this MOC</span>`
62	`{% elif comment.user.get_rolename.0 %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

9 similar queries. Duplicated 9 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(670)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285)
  options = self.get_privacy_options()

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

63	`<span class="rb-chip rb-chip--sm rb-chip--info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
64	`{% endif %}`
65	`{% if not comment.user.plan.is_free %}`
66	`{% if comment.user.is_public_plan %}`
67	`{{ comment.user.get_plan_html }}`
68	`{% endif %}`
69	`{% endif %}`
70	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

7 similar queries. Duplicated 7 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="rb-comment__avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="rb-comment__avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="rb-comment__collapse-control js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

6 similar queries. Duplicated 6 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

55	`<a href="/help/users-levels/">`
56	`<span class="rb-chip rb-chip--sm rb-chip--light" title="Based on {{ comment.user.points\|int_to_abbr }} points">Level {{ comment.user.level }}</span>`
57	`</a>`
58	`{% if comment.user.is_admin %}`
59	`<a href="{% url 'about' %}#roles" title="This user has an Administrator role"><span class="rb-chip rb-chip--sm rb-chip--danger">{{ comment.user.get_rolename.0 }}</span></a>`
60	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
61	`<span class="rb-chip rb-chip--sm rb-chip--premium" title="This user designed this MOC">Designed this MOC</span>`
62	`{% elif comment.user.get_rolename.0 %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

9 similar queries. Duplicated 9 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(670)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285)
  options = self.get_privacy_options()

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

63	`<span class="rb-chip rb-chip--sm rb-chip--info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
64	`{% endif %}`
65	`{% if not comment.user.plan.is_free %}`
66	`{% if comment.user.is_public_plan %}`
67	`{{ comment.user.get_plan_html }}`
68	`{% endif %}`
69	`{% endif %}`
70	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

7 similar queries. Duplicated 7 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="rb-comment__avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="rb-comment__avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="rb-comment__collapse-control js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

6 similar queries. Duplicated 6 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

55	`<a href="/help/users-levels/">`
56	`<span class="rb-chip rb-chip--sm rb-chip--light" title="Based on {{ comment.user.points\|int_to_abbr }} points">Level {{ comment.user.level }}</span>`
57	`</a>`
58	`{% if comment.user.is_admin %}`
59	`<a href="{% url 'about' %}#roles" title="This user has an Administrator role"><span class="rb-chip rb-chip--sm rb-chip--danger">{{ comment.user.get_rolename.0 }}</span></a>`
60	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
61	`<span class="rb-chip rb-chip--sm rb-chip--premium" title="This user designed this MOC">Designed this MOC</span>`
62	`{% elif comment.user.get_rolename.0 %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

9 similar queries. Duplicated 9 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(670)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(285)
  options = self.get_privacy_options()

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

63	`<span class="rb-chip rb-chip--sm rb-chip--info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
64	`{% endif %}`
65	`{% if not comment.user.plan.is_free %}`
66	`{% if comment.user.is_public_plan %}`
67	`{{ comment.user.get_plan_html }}`
68	`{% endif %}`
69	`{% endif %}`
70	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

2 similar queries. Duplicated 2 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

/home/nathan/rb/site/./accounts/models/user_extras.py in get_num_users_at_location(610)
  return UserProfile.objects.filter(location__iexact=self.profile.location).count()

5	`<div class="mb-30 border box-light">`
6	`<div class="box-inner">`
7	`<h4 class="mb-0"><i class="fa fa-globe"></i> {{ profile_user.profile.location }}</h4>`
8	`<p><small>There are {{ profile_user.get_num_users_at_location }} users from this location</small></p>`
9
10	`{% if profile_user.profile.website_url and profile_user.level >= settings.LEVEL_SHOW_PERSONAL_URL %}`
11	`<div class="trunc"><a href="{% get_external_url profile_user.profile.website_url 'action=ProfileLink&site=Personal'\|addstr:'&user='\|addstr:profile_user.id %}" target="_blank" rel="nofollow"><i class="fa fa-external-link"></i> {{ profile_user.profile.website_url }}</a></div>`
12	`{% endif %}`

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

2 similar queries. Duplicated 2 times.

0.09

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

1	`{% if profile_user.trophies.count > 0 %}`
2	`<div class="mb-30 border box-light">`
3	`<div class="box-inner">`
4	`<h4><i class="fa fa-trophy"></i> TROPHY CASE</h4>`
5	`{% for trophy in profile_user.trophies.all %}`

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

2 similar queries. Duplicated 2 times.

0.09

Connection: default

Transaction status: Idle

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

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

2	`<div class="mb-30 border box-light">`
3	`<div class="box-inner">`
4	`<h4><i class="fa fa-trophy"></i> TROPHY CASE</h4>`
5	`{% for trophy in profile_user.trophies.all %}`
6	`<div class="inline-block mr-10">`
7	`<a href="{{ trophy.link }}"><img src="{{ trophy.img }}?b" height="50px" title="{{ trophy.title }}"></a>`
8	`</div>`
9	`{% endfor %}`

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

Log messages

No messages logged.

Galloping

518,970 Parts

Bargain Hunter

Newton Aycliffe

TROPHY CASE

11

LEVEL

2,227

POINTS

2,490

VIEWS

USER RANKINGS

Most Liked MOCs See all MOCs by this designer

Badges

Bargain Hunter

Following Designers

LEGO Parts Collector

Linked Brickset

MOC Lover

Midas

Recent Comments

Newton Aycliffe

TROPHY CASE

Time

Resource usage

Browser timing

SQL queries from 1 connection

Log messages