Phantom II

MOC-232852 • 160 parts

Phantom II

MOC-232852 • 160 parts • Star Wars

Download the free Building Instructions for this MOC:

Aug. 26, 2025, 1:41 a.m.

3.5 MB

and build this MOC!

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

FOLLOWERS

472

LIKES

54

This is a modification of the Phantom II from 75357 Ghost & Phantom II. The engines are now the right color, the bottom is now sloped, and the side panels are less fragile. Hera fits inside, but the window can't be put down all the way. Jacen fits fine. Minifigure parts are not included in the inventory.
The additional parts needed are:
Light Bluish Gray: 1x 3795
Dark Bluish Gray: 1x 43713, 2x 80796
White: 1x 65429, 1x 65426, 1x 41682, 1x 87087, 2x 3023, 1x 11211, 2x 3386, 4x 36841, 2x 3710, 2x 3623, 2x 63864, 2x 3024, 4x 54200, 2x 3665
Translucent Yellow: 2x 3069b

I also made some modifications and upgrades to the Ghost, as can be seen in my video. (This MOC is only the parts to modify the Phantom II, and not the Ghost).

This MOC is a Modification of the following: Compare MOC-232852 to 75357-1

Ghost & Phantom II

75357-1

(1394 parts)

Star Wars 2023

See the Parts in this MOC

to your account to add or reply to comments.

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

472

LIKES

54

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!

300

Aug. 30, 2025, 3:21 a.m. by icedragonj

Sept. 18, 2025, 10:08 p.m. by Sir BuildsALot

See Change Log for MOC-232852

DJDT

Time

Resource usage

Resource	Value
User CPU time	325.577 msec
System CPU time	6.941 msec
Total CPU time	332.518 msec
Elapsed time	353.414 msec
Context switches	66 voluntary, 37 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 26.13 ms (31 queries including 11 similar and 9 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-232852'
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-232852' LIMIT 21

11.14

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./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 (289563))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 (289563))

5.31

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./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" = 289563 AND "lego_inventory"."version" = 1)
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."set_id" = 289563 AND "lego_inventory"."version" = 1) LIMIT 21

0.29

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-232852'
ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'MOC-232852' ORDER BY "lego_changelog"."timestamp" DESC

0.64

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" = 289563SELECT ••• FROM "lego_mocinstructions" LEFT OUTER JOIN "lego_files_s3file" ON ("lego_mocinstructions"."s3file_id" = "lego_files_s3file"."id") WHERE "lego_mocinstructions"."moc_id" = 289563

0.86

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./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" = '289563')SELECT ••• FROM "django_comments" WHERE ("django_comments"."content_type_id" = 31 AND NOT "django_comments"."is_removed" AND "django_comments"."object_pk" = '289563')

0.55

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.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/./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" = 289563)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 289563)

2 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/./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" = 289563
ORDER BY "lego_mocimage"."is_primary" DESC, "lego_mocimage"."id" ASCSELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."moc_id" = 289563 ORDER BY "lego_mocimage"."is_primary" DESC, "lego_mocimage"."id" ASC

3 similar queries. Duplicated 3 times.

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(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.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)

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

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-232852%')
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-232852%') ORDER BY "blog_article"."published_date" ASC

0.31

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./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" = 289563SELECT ••• FROM "lego_mocinstructions" WHERE "lego_mocinstructions"."moc_id" = 289563

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/./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 "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_files_s3file"
WHERE "lego_files_s3file"."id" = 673183
LIMIT 21SELECT ••• FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 673183 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/./lego/models/mocs.py in get_bi_type_help_msg(610)
  if bif.is_studio:

/home/nathan/rb/site/./lego/models/mocs.py in is_studio(2135)
  return self.file.name.lower().endswith('.io')

/home/nathan/rb/site/./lego/models/mocs.py in file(2034)
  if self.s3file:

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 COUNT(*) AS "__count"
FROM "lego_designerfollower"
WHERE "lego_designerfollower"."designer_id" = 741273SELECT ••• FROM "lego_designerfollower" WHERE "lego_designerfollower"."designer_id" = 741273

4 similar queries. Duplicated 4 times.

1.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)

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

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" = 289563 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" = 289563 AND "auth_user"."is_active")

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)

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

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/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_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" = 125444
LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 125444 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(32)
  return render_to_string('sets/render_set.html',

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

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

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

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/templatetags/sets/drawing.py in render_set(32)
  return render_to_string('sets/render_set.html',

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

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.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" = 158
LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 158 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/./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" = 289563)
LIMIT 1SELECT ••• FROM "rb_comments_pagelocked" WHERE ("rb_comments_pagelocked"."content_type_id" = 31 AND "rb_comments_pagelocked"."object_id" = 289563) 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" = '289563' 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" = '289563' 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

0.75

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" = '289563' 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" = '289563' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

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/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" = '289563' 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" = '289563' 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.85

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

4 similar queries. Duplicated 4 times.

0.32

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

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

2 similar queries.

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)

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

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

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

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 - Phantom II

Phantom II

Phantom II

FOLLOWERS

472

LIKES

54

Ghost & Phantom II

Rebrickable does not sell LEGO Parts.

FOLLOWERS

472

LIKES

54

Build this MOC

? %

Time

Resource usage

Browser timing

SQL queries from 1 connection

Log messages