76900 Muscle Redefined

MOC-145531 • 242 parts

76900 Muscle Redefined

MOC-145531 • 242 parts • Speed Champions

Download the free Building Instructions for this MOC:

April 16, 2023, 7:20 p.m.

1.9 MB

April 16, 2023, 7:20 p.m.

7.1 MB

Help Guide - BI File Types

and build this MOC!

Alt This MOC can be built using only the parts from LEGO set 76900-1 Koenigsegg Jesko !

Want to see more MOCS like this? Create an account to find MOCs you can build from the parts you already own

FOLLOWERS

852

LIKES

83

Disclaimer

You are free to showcase this MOC,
but if you do, please link back to the source.
Thank you!

All of my SC Mocs are made from the cars alone.

No extra parts and no extra accesories (finnishline etc) are used

I never liked how flimsy the spoiler was on my original muscle MOC so I redid it after some time, I just forgot to update it. But since I also did other adjustments later I felt better to make a new post of it.

Same specs as before, just way better looking and sturdier.

Enjoy!
Stickered parts are not included in inventory list as I use my custom created parts

This MOC is an Alt Alternate Build of the following: Compare MOC-145531 to 76900-1

Koenigsegg Jesko

76900-1

(283 parts)

Speed Champions 2021

See the Parts in this MOC

to your account to add or reply to comments.

1 year, 6 months ago Chookitybuilder Level 9

I can't really see where that 1x2 slope is going at the final step

2 years ago BuilderBoy14 Level 4

Hi and thanks for the nice MOC !!!
Reguards from Germany!
- 2 years ago Schwimpy Level 18 Designed this MOC
  
  Hi and thank you for your comment!
  
  // Sweden.

2 years, 9 months ago 758411 (deleted) Level 0

<deleted>

2 years, 9 months ago speed_champ_fan Level 13 MOC Designer

this is why schwimpy best designer, he update his mistakes
- 2 years, 9 months ago Schwimpy Level 18 Designed this MOC
  
  :)
- 2 years, 9 months ago TheCarologist Level 17
  
  I 100% agree, he's also listening to our demands, for example, I am grateful to him for the Koenigsegg Regera that he made for me. Thx 1000!

Rebrickable does not sell LEGO Parts.

We provide links to third-party stores that sell LEGO products. If you use these stores, you are not buying from Rebrickable. Click the button below to search the stores.

Help Guide - Buying LEGO Parts

FOLLOWERS

852

LIKES

83

Build this MOC

You have

? %

of the parts to build this MOC

Create an account and enter your LEGO collection to find out if you can build this MOC!

2,000

April 16, 2023, 7:21 p.m. by Schwimpy

Oct. 15, 2025, 7:44 a.m. by Schwimpy

See Change Log for MOC-145531

DJDT

Time

Resource usage

Resource	Value
User CPU time	324.734 msec
System CPU time	9.818 msec
Total CPU time	334.552 msec
Elapsed time	360.808 msec
Context switches	144 voluntary, 26 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 27.46 ms (61 queries including 41 similar and 25 duplicates )

Query Timeline Time (ms) Action

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

10.70

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/./lego/views/mocs.py in moc_details(423)
  moc = Moc.all_objects.select_related('designer', 'stats').get(set_num=set_num)

SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
       "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug"
  FROM "taggit_tag"
INNER JOIN "taggit_taggeditem"
    ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
INNER JOIN "django_content_type"
    ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (169543))SELECT ••• FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (169543))

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/./lego/views/mocs.py in moc_details(423)
  moc = Moc.all_objects.select_related('designer', 'stats').get(set_num=set_num)

SELECT "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"
  FROM "lego_inventory"
WHERE ("lego_inventory"."set_id" = 169543 AND "lego_inventory"."version" = 1)
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."set_id" = 169543 AND "lego_inventory"."version" = 1) LIMIT 21

0.21

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/./lego/views/mocs.py in moc_details(523)
  inventory = get_object_or_404(Inventory.all_objects, set=moc, version=inventory_version)

SELECT "lego_changelog"."id",
       "lego_changelog"."timestamp",
       "lego_changelog"."user_id",
       "lego_changelog"."model",
       "lego_changelog"."instance_id",
       "lego_changelog"."set_num",
       "lego_changelog"."part_num",
       "lego_changelog"."old_value",
       "lego_changelog"."new_value"
  FROM "lego_changelog"
WHERE "lego_changelog"."set_num" = 'MOC-145531'
ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'MOC-145531' ORDER BY "lego_changelog"."timestamp" DESC

1.57

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/./lego/views/mocs.py in moc_details(538)
  changes = moc.get_change_summary()

/home/nathan/rb/site/./lego/models/sets.py in get_change_summary(1121)
  changes = ChangeLog.get_changes(set_num=self.set_num)

/home/nathan/rb/site/./lego/models/changes.py in get_changes(276)
  if len(changes) > 0:

SELECT "lego_mocinstructions"."id",
       "lego_mocinstructions"."moc_id",
       "lego_mocinstructions"."uploaded",
       "lego_mocinstructions"."file_size",
       "lego_mocinstructions"."to_be_uploaded",
       "lego_mocinstructions"."s3file_id",
       "lego_files_s3file"."id",
       "lego_files_s3file"."file_size",
       "lego_files_s3file"."last_modified",
       "lego_files_s3file"."aws_mi_file",
       "lego_files_s3file"."linode_si_file",
       "lego_files_s3file"."linode_mi_file",
       "lego_files_s3file"."linode_media_file"
  FROM "lego_mocinstructions"
  LEFT OUTER JOIN "lego_files_s3file"
    ON ("lego_mocinstructions"."s3file_id" = "lego_files_s3file"."id")
WHERE "lego_mocinstructions"."moc_id" = 169543SELECT ••• FROM "lego_mocinstructions" LEFT OUTER JOIN "lego_files_s3file" ON ("lego_mocinstructions"."s3file_id" = "lego_files_s3file"."id") WHERE "lego_mocinstructions"."moc_id" = 169543

0.69

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/./lego/views/mocs.py in moc_details(548)
  context['bi_files'] = MocInstructions.get_moc_files(moc)

/home/nathan/rb/site/./lego/models/mocs.py in get_moc_files(2066)
  files = sorted(files, key=lambda x: str(x.file))

SELECT COUNT(*) AS "__count"
FROM "django_comments"
WHERE ("django_comments"."content_type_id" = 31 AND NOT "django_comments"."is_removed" AND "django_comments"."object_pk" = '169543')SELECT ••• FROM "django_comments" WHERE ("django_comments"."content_type_id" = 31 AND NOT "django_comments"."is_removed" AND "django_comments"."object_pk" = '169543')

0.40

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/./lego/views/mocs.py in moc_details(637)
  context['num_comments'] = Comment.objects.filter(object_pk=moc.id, content_type=ContentType.objects.get_for_model(moc), is_removed=False).count()

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.19

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

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

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

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

SELECT COUNT(*) AS "__count"
FROM "lego_inventory"
WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 169543)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 169543)

2 similar queries. Duplicated 2 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in get_num_inventories(981)
  return Inventory.objects.filter(set=self).count()

16	`<div class="mb-10">`
17	`<span>{{ moc.set_num }}</span>`
18	`•`
19	`<span><a href="#parts_scroll" title="See the parts in this MOC's inventory">{{ moc.num_parts }} parts{% if moc.get_num_inventories > 1 %} <span class="label label-primary">v{{ inventory.version }}</span>{% endif %}</a></span>`
20	`</div>`
21
22	`</div>`
23

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top.html

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."moc_id" = 169543
ORDER BY "lego_mocimage"."is_primary" DESC, "lego_mocimage"."id" ASCSELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."moc_id" = 169543 ORDER BY "lego_mocimage"."is_primary" DESC, "lego_mocimage"."id" ASC

3 similar queries. Duplicated 3 times.

0.21

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

25	`<div class="alert alert-danger"><h4><i class="fa fa-warning"></i> This MOC is disabled.</h4></div>`
26	`{% endif %}`
27
28	`{% if moc.use_fake_image %}`
29
30	`{% thumbs moc.use_fake_image.img_dir settings.THUMBS_OPTIONS_MOC_TILE as thumb_img %}`
31	`{% thumbs_encoded moc.use_fake_image.img_dir settings.THUMBS_OPTIONS_MOC_MAIN_PREVIEW as preview_img %}`
32	`{% thumbs moc.use_fake_image.img_dir settings.THUMBS_OPTIONS_MOC_MAIN get_real_dims=1 as first_image %}`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top.html

3 similar queries. Duplicated 3 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

42	`data-directionNav="true" data-controlsContainer="#slider_controls">`
43	`{# adding display-flex puts images side-by-side so when flexslider is initialising it doesn't stack them vertically briefly which screws up CLS #}`
44	`<ul class="slides display-flex">`
45	`{% for image in moc.moc_images.all %}`
46	`{% if forloop.counter <= 12 %}`
47	`{% thumbs image.img_dir settings.THUMBS_OPTIONS_MOC_TILE as thumb_img %}`
48	`{% if forloop.counter == 1 %}`
49	`{% thumbs_encoded image.img_dir settings.THUMBS_OPTIONS_MOC_MAIN_PREVIEW as preview_img %}`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top.html

3 similar queries. Duplicated 3 times.

0.21

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

74	`</ul>`
75	`</div>`
76	`{# pre-create controls div so we can size column height without CLS impact and prevents flicker #}`
77	`<div class="flexslider-controls-container {% if moc.moc_images.all\|length > 6 %}flexslider-controls-container-2rows{% endif %}">`
78	`<div id="slider_controls" class="flexslider-mocs text-center"></div>`
79	`</div>`
80
81	`{% else %}`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top.html

2 similar queries. Duplicated 2 times.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in get_num_inventories(981)
  return Inventory.objects.filter(set=self).count()

16	`<div class=" mb-30">`
17	`<span>{{ set.set_num }}</span>`
18	`•`
19	`<span><a href="#parts_scroll" title="See the parts in this MOC's inventory">{{ set.num_parts }} parts{% if set.get_num_inventories > 1 %} <span class="label label-primary">v{{ inventory.version }}</span>{% endif %}</a></span>`
20	`•`
21	`<span><a href="{% url 'browse_mocs' %}?theme={{ set.theme_id }}" title="Find other MOCs in this theme">{{ set.theme.get_full_name }}</a></span>`
22	`</div>`
23	`</div>`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top_buy.html

SELECT "blog_article"."id",
       "blog_article"."title",
       "blog_article"."author_id",
       "blog_article"."published_date",
       "blog_article"."is_active",
       "blog_article"."body",
       "blog_article"."meta_description",
       "blog_article"."meta_img",
       "blog_article"."slug",
       "blog_article"."category_id",
       "blog_article"."ads",
       "blog_article"."show_ads_for_set_num",
       "blog_article"."review_for_set_num",
       "blog_article"."status",
       "blog_article"."scheduled_net",
       "blog_article"."ready_for_review_date",
       "blog_article"."is_sensitive",
       "blog_article"."search_vector"
  FROM "blog_article"
WHERE ("blog_article"."is_active" AND "blog_article"."review_for_set_num"::text LIKE '%MOC-145531%')
ORDER BY "blog_article"."published_date" ASCSELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."review_for_set_num"::text LIKE '%MOC-145531%') ORDER BY "blog_article"."published_date" ASC

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in get_set_review(1393)
  for review in reviews:

22	`</div>`
23	`</div>`
24
25	`{% with moc.get_set_review as review %}`
26	`{% if review %}`
27	`<div class="text-center">`
28	`<a href="{{ review.get_absolute_url }}"><i class="fa fa-star"></i> See our Review of this MOC</a>`
29	`</div>`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top_buy.html

SELECT "lego_mocinstructions"."id",
       "lego_mocinstructions"."moc_id",
       "lego_mocinstructions"."uploaded",
       "lego_mocinstructions"."file_size",
       "lego_mocinstructions"."to_be_uploaded",
       "lego_mocinstructions"."s3file_id"
  FROM "lego_mocinstructions"
WHERE "lego_mocinstructions"."moc_id" = 169543SELECT ••• FROM "lego_mocinstructions" WHERE "lego_mocinstructions"."moc_id" = 169543

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/models/mocs.py in get_bi_type_help_msg(606)
  if len(bi_files) > 1:

119	`{% elif not moc.is_for_sale and bi_files %}`
120	`<p>Download the free Building Instructions for this MOC:</p>`
121	`{% include "mocs/includes/render_moc_bi_files_sidebar.html" %}`
122	`{{ moc.get_bi_type_help_msg }}`
123	`{% comment %}`
124	`{% if bi_files\|length == 1 and bi_files.0.is_studio %}`
125	`<p>This file requires <a href="https://studio.bricklink.com/v2/build/studio.page">BrickLink Studio</a> to open. See our <a href="/help/guide-to-stud-io/">Guide to using Studio</a>.</p>`
126	`{% elif bi_files\|length == 1 and bi_files.0.is_ldd %}`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top_buy.html

SELECT 1 AS "a"
FROM "lego_mocswitherrors"
WHERE "lego_mocswitherrors"."moc_id" = 169543
LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE "lego_mocswitherrors"."moc_id" = 169543 LIMIT 1

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/models/mocs.py in is_alternate(204)
  if not self.is_pending and MocsWithErrors.objects.filter(moc=self).exists():

153
154	`</div>`
155	`<div class="p-10"> {# aligned to bottom via flex-grow in above div #}`
156	`{% if moc.is_alternate and moc.parent_set_1 and not moc.parent_set_2 %}`
157	`<div class="display-flex">`
158	`<div class="flex-1">`
159	`<span class="label label-altbuild size-10"><i class="fa fa-fw fa-retweet text-white"></i> Alt</span>`
160	`This MOC can be built using only the parts from LEGO set <a href="{{ moc.parent_set_1.get_absolute_url }}#alt_builds">{{ moc.parent_set_1 }}</a> !`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top_buy.html

SELECT "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"
  FROM "lego_setphoto"
WHERE "lego_setphoto"."id" = 88049
LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 88049 LIMIT 21

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(751)
  file_dir = self.primary_photo.get_img_dir()

161	`</div>`
162	`<div class="">`
163	`{% with settings.THUMBS_OPTIONS_SET_MAIN_SM as tn_options %}`
164	`{% thumbs moc.parent_set_1.img_dir tn_options as img %}`
165	`<a href="{{ moc.parent_set_1.get_absolute_url }}#alt_builds">`
166	`<img class="img-responsive" src="{% cachebuster img.url %}" width="{{ img.width }}" height="{{ img.height }}">`
167	`</a>`
168	`{% endwith %}`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top_buy.html

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(751)
  file_dir = self.primary_photo.get_img_dir()

/home/nathan/rb/site/./lego/models/sets.py in get_img_dir(3133)
  return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')

161	`</div>`
162	`<div class="">`
163	`{% with settings.THUMBS_OPTIONS_SET_MAIN_SM as tn_options %}`
164	`{% thumbs moc.parent_set_1.img_dir tn_options as img %}`
165	`<a href="{{ moc.parent_set_1.get_absolute_url }}#alt_builds">`
166	`<img class="img-responsive" src="{% cachebuster img.url %}" width="{{ img.width }}" height="{{ img.height }}">`
167	`</a>`
168	`{% endwith %}`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_top_buy.html

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

4 similar queries. Duplicated 4 times.

1.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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

9	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
10	`</a>`
11	`{% else %}`
12	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
13	`{% endif %}`
14	`{% if request.user.is_authenticated %}`
15	`{# designer_follow_btn is a class because it can appear twice on a moc (info tab on mobile) #}`
16	`<div class="designer_follow_btn_{{ set.designer.id }}">`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_likes_follows.html

4 similar queries. Duplicated 4 times.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

9	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
10	`</a>`
11	`{% else %}`
12	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
13	`{% endif %}`
14	`{% if request.user.is_authenticated %}`
15	`{# designer_follow_btn is a class because it can appear twice on a moc (info tab on mobile) #}`
16	`<div class="designer_follow_btn_{{ set.designer.id }}">`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_likes_follows.html

SELECT COUNT(*) AS "__count"
FROM "accounts_usersetphoto"
INNER JOIN "auth_user"
ON ("accounts_usersetphoto"."user_id" = "auth_user"."id")
WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."set_id" = 169543 AND "auth_user"."is_active")SELECT ••• FROM "accounts_usersetphoto" INNER JOIN "auth_user" ON ("accounts_usersetphoto"."user_id" = "auth_user"."id") WHERE ("accounts_usersetphoto"."is_active" AND "accounts_usersetphoto"."set_id" = 169543 AND "auth_user"."is_active")

0.82

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

43	`<li><a href="#tab_photos" data-toggle="tab">`
44	`<span class="hidden-xs">Photos</span>`
45	`<span class="visible-xs text-center"><i class="fa fa-lg fa-photo"></i></span>`
46	`<span class="badge badge-light hidden-xs">{{ user_set_photos.count }}</span>`
47	`</a></li>`
48	`{% if can_edit %}`
49	`<li><a href="#tab_admin" data-toggle="tab" class="text-red">`
50	`<span class="hidden-xs">Admin</span>`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_tabs.html

SELECT "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"
  FROM "lego_inventory"
WHERE "lego_inventory"."id" = 100260
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 100260 LIMIT 21

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
  inventory = set.get_default_inventory()

/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(971)
  if self.default_inventory is not None:

40	`{% if moc.is_alternate or moc.is_mod %}`
41	`<div class=" row row-condensed">`
42	`{% if moc.parent_set_1 %}`
43	`<div class="{{ moc.get_parent_set_col_size }} col-condensed">{% render_set moc.parent_set_1 inventory=moc.parent_inv_1 %}</div>`
44	`{% endif %}`
45	`{% if moc.parent_set_2 %}`
46	`<div class="{{ moc.get_parent_set_col_size }} col-condensed">{% render_set moc.parent_set_2 inventory=moc.parent_inv_2 %}</div>`
47	`{% endif %}`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_main_descr.html

SELECT "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"
  FROM "lego_theme"
WHERE "lego_theme"."id" = 601
LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 601 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
  return render_to_string('sets/render_set.html',

136	`<small class="trunc pull-left width-80pct" title="Filter on theme: {{ set.theme.get_full_name }}"><a href="?{% url_replace 'theme' set.theme.id %}">{{ set.theme.get_full_name }}</a></small>`
137	`<small class="pull-right" title="Filter on year {{ set.year }}"><a href="?{% url_replace 'min_year' set.year 'max_year' set.year %}">{{ set.year }}</a></small>`
138	`{% else %}`
139	`<small class="trunc pull-left width-80pct" title="{{ set.theme.get_full_name }}">{{ set.theme.get_full_name }}</small>`
140	`<small class="pull-right" title="{{ set.year }}">{{ set.year }}</small>`
141	`{% endif %}`
142	`</div>`
143	`{% endif %}`

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

SELECT "django_content_type"."id",
       "django_content_type"."app_label",
       "django_content_type"."model"
  FROM "django_content_type"
WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc')
LIMIT 21SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc') LIMIT 21

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(78)
  content_type = ContentType.objects.get(app_label=page_content_type.split('.')[0], model=page_content_type.split('.')[1])

4	`{% load rb_comments_filters %}`
5
6	`<div id="comments-{{ page.id }}">`
7	`{% get_page_locked_status content_type page.id as is_page_locked %}`
8
9	`{% comment %}`
10	`Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.`
11	`Using fluent-comments to hide unused fields and do ajax add/reply comment.`

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

SELECT 1 AS "a"
FROM "rb_comments_pagelocked"
WHERE ("rb_comments_pagelocked"."content_type_id" = 31 AND "rb_comments_pagelocked"."object_id" = 169543)
LIMIT 1SELECT ••• FROM "rb_comments_pagelocked" WHERE ("rb_comments_pagelocked"."content_type_id" = 31 AND "rb_comments_pagelocked"."object_id" = 169543) LIMIT 1

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(79)
  is_locked = PageLocked.objects.filter(content_type=content_type, object_id=page_id).exists()

4	`{% load rb_comments_filters %}`
5
6	`<div id="comments-{{ page.id }}">`
7	`{% get_page_locked_status content_type page.id as is_page_locked %}`
8
9	`{% comment %}`
10	`Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.`
11	`Using fluent-comments to hide unused fields and do ajax add/reply comment.`

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

SELECT (SUBSTRING(tree_path, 1, 10)) AS "tree_path_root",
       "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")
  LEFT OUTER 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 ("django_comments"."content_type_id" = 31 AND "django_comments"."object_pk" = '169543' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASCSELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") LEFT OUTER 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 ("django_comments"."content_type_id" = 31 AND "django_comments"."object_pk" = '169543' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC

2.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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71)
  qs = self.get_queryset(context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_queryset(45)
  return qs[:50], len(qs)

14	`{% endcomment %}`
15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`

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

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 (564210, 996776, 340696, 758411, 650544, 679566)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 (564210, 996776, 340696, 758411, 650544, 679566)

2 similar queries. Duplicated 2 times.

0.15

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71)
  qs = self.get_queryset(context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_queryset(45)
  return qs[:50], len(qs)

14	`{% endcomment %}`
15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`

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

SELECT COUNT(*) AS "__count"
FROM "threadedcomments_comment"
INNER JOIN "django_comments"
ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE ("django_comments"."content_type_id" = 31 AND "django_comments"."object_pk" = '169543' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 31 AND "django_comments"."object_pk" = '169543' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

0.21

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`
22	`<div class="heading-title heading-border-bottom heading-color">`

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

SELECT (SUBSTRING(tree_path, 1, 10)) AS "tree_path_root",
       "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")
  LEFT OUTER 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 ("django_comments"."content_type_id" = 31 AND "django_comments"."object_pk" = '169543' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC
LIMIT 50SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") LEFT OUTER 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 ("django_comments"."content_type_id" = 31 AND "django_comments"."object_pk" = '169543' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC LIMIT 50

0.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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

89	`{% with cache_timeout=user.is_authenticated\|yesno:"0,300" %}`
90	`{% cache cache_timeout 'comments_list_v2' request.user.is_authenticated page.id request.GET.page request.GET.showmore num_comments %}`
91
92	`<div class="comments {% if not comment_list.0 %} empty{% endif %} mb-30">`
93	`{% if use_context %}`
94	`{# Flat list of comments #}`
95	`{% for comment in comment_list.0\|make_proxy_users %}`
96	`<ul class="comment list-unstyled comment-list-wrapper">`

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

2 similar queries. Duplicated 2 times.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

89	`{% with cache_timeout=user.is_authenticated\|yesno:"0,300" %}`
90	`{% cache cache_timeout 'comments_list_v2' request.user.is_authenticated page.id request.GET.page request.GET.showmore num_comments %}`
91
92	`<div class="comments {% if not comment_list.0 %} empty{% endif %} mb-30">`
93	`{% if use_context %}`
94	`{# Flat list of comments #}`
95	`{% for comment in comment_list.0\|make_proxy_users %}`
96	`<ul class="comment list-unstyled comment-list-wrapper">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.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" = 564210
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 564210 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

7 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.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="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 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

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

5 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

SELECT 1 AS "a"
FROM "accounts_mocpurchase"
WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 564210)
LIMIT 1SELECT ••• FROM "accounts_mocpurchase" WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 564210) LIMIT 1

7 similar queries.

0.22

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_verified_purchase(97)
  if user.has_purchased_moc(moc.id):

/home/nathan/rb/site/./accounts/models/user_extras.py in has_purchased_moc(1008)
  return MocPurchase.objects.filter(user=self, moc_id=moc_id).exists()

65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`
68	`{% get_verified_purchase comment.user page %}`
69	`{% endif %}`
70	`{% endif %}`
71	`</div>`
72

/home/nathan/rb/site/rb_comments/templates/comments/comment.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" = 996776
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 996776 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.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="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 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

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

5 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

SELECT 1 AS "a"
FROM "accounts_mocpurchase"
WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 996776)
LIMIT 1SELECT ••• FROM "accounts_mocpurchase" WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 996776) LIMIT 1

7 similar queries.

0.21

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_verified_purchase(97)
  if user.has_purchased_moc(moc.id):

/home/nathan/rb/site/./accounts/models/user_extras.py in has_purchased_moc(1008)
  return MocPurchase.objects.filter(user=self, moc_id=moc_id).exists()

65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`
68	`{% get_verified_purchase comment.user page %}`
69	`{% endif %}`
70	`{% endif %}`
71	`</div>`
72

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

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"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 508332
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 508332 LIMIT 21

3 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.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" = 340696
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 340696 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

7 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.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="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 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

SELECT 1 AS "a"
FROM "accounts_mocpurchase"
WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 340696)
LIMIT 1SELECT ••• FROM "accounts_mocpurchase" WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 340696) LIMIT 1

7 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_verified_purchase(97)
  if user.has_purchased_moc(moc.id):

/home/nathan/rb/site/./accounts/models/user_extras.py in has_purchased_moc(1008)
  return MocPurchase.objects.filter(user=self, moc_id=moc_id).exists()

65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`
68	`{% get_verified_purchase comment.user page %}`
69	`{% endif %}`
70	`{% endif %}`
71	`</div>`
72

/home/nathan/rb/site/rb_comments/templates/comments/comment.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" = 758411
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 758411 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.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="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 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

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

5 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

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

6 similar queries. Duplicated 2 times.

0.20

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

6 similar queries. Duplicated 2 times.

0.16

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

SELECT 1 AS "a"
FROM "accounts_mocpurchase"
WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 758411)
LIMIT 1SELECT ••• FROM "accounts_mocpurchase" WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 758411) LIMIT 1

7 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_verified_purchase(97)
  if user.has_purchased_moc(moc.id):

/home/nathan/rb/site/./accounts/models/user_extras.py in has_purchased_moc(1008)
  return MocPurchase.objects.filter(user=self, moc_id=moc_id).exists()

65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`
68	`{% get_verified_purchase comment.user page %}`
69	`{% endif %}`
70	`{% endif %}`
71	`</div>`
72

/home/nathan/rb/site/rb_comments/templates/comments/comment.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" = 650544
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 650544 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.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="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 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

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

5 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

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

6 similar queries. Duplicated 2 times.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

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

6 similar queries. Duplicated 2 times.

0.16

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

SELECT 1 AS "a"
FROM "accounts_mocpurchase"
WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 650544)
LIMIT 1SELECT ••• FROM "accounts_mocpurchase" WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 650544) LIMIT 1

7 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_verified_purchase(97)
  if user.has_purchased_moc(moc.id):

/home/nathan/rb/site/./accounts/models/user_extras.py in has_purchased_moc(1008)
  return MocPurchase.objects.filter(user=self, moc_id=moc_id).exists()

65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`
68	`{% get_verified_purchase comment.user page %}`
69	`{% endif %}`
70	`{% endif %}`
71	`</div>`
72

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

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"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 382831
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 382831 LIMIT 21

3 similar queries. Duplicated 2 times.

0.22

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.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" = 340696
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 340696 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

7 similar queries. Duplicated 2 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.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="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 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

SELECT 1 AS "a"
FROM "accounts_mocpurchase"
WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 340696)
LIMIT 1SELECT ••• FROM "accounts_mocpurchase" WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 340696) LIMIT 1

7 similar queries. Duplicated 2 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_verified_purchase(97)
  if user.has_purchased_moc(moc.id):

/home/nathan/rb/site/./accounts/models/user_extras.py in has_purchased_moc(1008)
  return MocPurchase.objects.filter(user=self, moc_id=moc_id).exists()

65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`
68	`{% get_verified_purchase comment.user page %}`
69	`{% endif %}`
70	`{% endif %}`
71	`</div>`
72

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

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"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 382831
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 382831 LIMIT 21

3 similar queries. Duplicated 2 times.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.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" = 679566
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 679566 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

7 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.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="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 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

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

5 similar queries.

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

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

6 similar queries. Duplicated 2 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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

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

6 similar queries. Duplicated 2 times.

0.16

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

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

SELECT 1 AS "a"
FROM "accounts_mocpurchase"
WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 679566)
LIMIT 1SELECT ••• FROM "accounts_mocpurchase" WHERE ("accounts_mocpurchase"."is_active" AND "accounts_mocpurchase"."moc_id" = 169543 AND "accounts_mocpurchase"."user_id" = 679566) LIMIT 1

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_verified_purchase(97)
  if user.has_purchased_moc(moc.id):

/home/nathan/rb/site/./accounts/models/user_extras.py in has_purchased_moc(1008)
  return MocPurchase.objects.filter(user=self, moc_id=moc_id).exists()

65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`
68	`{% get_verified_purchase comment.user page %}`
69	`{% endif %}`
70	`{% endif %}`
71	`</div>`
72

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

4 similar queries. Duplicated 4 times.

0.54

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

9	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
10	`</a>`
11	`{% else %}`
12	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
13	`{% endif %}`
14	`{% if request.user.is_authenticated %}`
15	`{# designer_follow_btn is a class because it can appear twice on a moc (info tab on mobile) #}`
16	`<div class="designer_follow_btn_{{ set.designer.id }}">`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_likes_follows.html

4 similar queries. Duplicated 4 times.

0.20

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

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

9	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
10	`</a>`
11	`{% else %}`
12	`<h2 class="size-30 mt-0 mb-10 text-info num-followers" title="{{ set.designer.followers.count }}">{{ set.designer.get_num_followers_formatted }}</h2>`
13	`{% endif %}`
14	`{% if request.user.is_authenticated %}`
15	`{# designer_follow_btn is a class because it can appear twice on a moc (info tab on mobile) #}`
16	`<div class="designer_follow_btn_{{ set.designer.id }}">`

/home/nathan/rb/site/lego/templates/mocs/includes/render_moc_likes_follows.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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

5	`{% cache cache_timeout 'change_summary' user.is_authenticated set.id 'v3' %}`
6	`<div><small><i class="fa fa-fw fa-eye" title="Views"></i> {{ set.stats.hits\|default:0\|floor_100\|intcomma }}</small></div>`
7	`<div><small><i class="fa fa-fw fa-plus" title="Added"></i> {{ changes.added.timestamp }}`
8	`{% if changes.added.user %}by`
9	`<a href="{% url 'user_profile' changes.added.user.get_username %}">{{ changes.added.user.get_username }}</a>`
10	`{% endif %}</small></div>`
11	`<div><small><i class="fa fa-fw fa-edit" title="Updated"></i> {{ changes.updated.timestamp }}`
12	`{% if changes.updated.user %}by`

/home/nathan/rb/site/lego/templates/sets/includes/render_change_summary.html

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/./lego/views/mocs.py in moc_details(690)
  return render(request, 'mocs/moc_details.html', context)

9	`<a href="{% url 'user_profile' changes.added.user.get_username %}">{{ changes.added.user.get_username }}</a>`
10	`{% endif %}</small></div>`
11	`<div><small><i class="fa fa-fw fa-edit" title="Updated"></i> {{ changes.updated.timestamp }}`
12	`{% if changes.updated.user %}by`
13	`<a href="{% url 'user_profile' changes.updated.user.get_username %}">{{ changes.updated.user.get_username }}</a>`
14	`{% endif %}</small></div>`
15	`<div class="mb-10"><small><a href="{% url 'change_log' %}?search_id={{ set.set_num }}">See Change Log for {{ set.set_num }}</a></small></div>`
16	`{% if user.is_authenticated %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_change_summary.html

Log messages

No messages logged.

MOC - 76900 Muscle Redefined

76900 Muscle Redefined

76900 Muscle Redefined

FOLLOWERS

852

LIKES

83

Koenigsegg Jesko

Rebrickable does not sell LEGO Parts.

FOLLOWERS

852

LIKES

83

Build this MOC

? %

Time

Resource usage

Browser timing

SQL queries from 1 connection

Log messages