default
36.77 ms (17 queries
including 12 similar
and 4 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" FROM "lego_baseset" WHERE "lego_baseset"."set_num" = 'lego-ideas-and-cuusoo' LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = 'lego-ideas-and-cuusoo' LIMIT 21
0.29
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(112)
baseset = get_or_none(BaseSet.all_objects, set_num=set_num)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
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", T2."id", T2."parent_id", T2."name", T2."slug", T2."set_count", T2."t1_id", T2."t1_name", T2."t2_name", T2."t3_name", T2."lego_blurb", T2."banner_img", T2."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr" FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE ("lego_theme"."parent_id" ISNULLAND "lego_theme"."slug" = 'lego-ideas-and-cuusoo') LIMIT 21SELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE ("lego_theme"."parent_id" ISNULLAND "lego_theme"."slug" = 'lego-ideas-and-cuusoo') LIMIT 21
0.26
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(130)
theme = get_or_none(Theme.objects, slug=slug, parent=None)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
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_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", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."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", "lego_inventory"."id", "lego_inventory"."set_id", "lego_inventory"."version", "lego_inventory"."name", "lego_inventory"."is_active", "lego_inventory"."num_parts", "lego_inventory"."num_versions", "lego_setphoto"."id", "lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary", T7."id", T7."set_num", T7."name", T7."year", T7."theme_id", T7."set_type", T7."num_parts", T7."default_inventory_id", T7."is_active", T7."is_accessory", T7."added_dt", T7."added_by_id", T7."last_modified_dt", T7."last_modified_by_id", T7."last_checked_for_bi", T7."descr", T7."primary_photo_id", T7."is_gear", T7."is_book", T7."search_vector", T7."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_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_inventory" ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id") LEFT OUTER JOIN "lego_setphoto" ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id") LEFT OUTER JOIN "lego_baseset" T7 ON ("lego_setphoto"."set_id" = T7."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_type" IN ('Set') AND ("lego_baseset"."theme_id" IN (576) OR "lego_theme"."parent_id" IN (576) OR T3."parent_id" IN (576)) AND "lego_baseset"."year" IN (2025) ANDNOT ("lego_baseset"."theme_id" IN (739, 777, 503, 730, 734, 737, 735, 736, 733, 741, 731, 732, 738, 742, 501, 740))) ORDER BY "lego_baseset"."name" ASC, "lego_baseset"."year" ASCSELECT ••• FROM "lego_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_inventory" ON ("lego_baseset"."default_inventory_id" = "lego_inventory"."id") LEFT OUTER JOIN "lego_setphoto" ON ("lego_baseset"."primary_photo_id" = "lego_setphoto"."id") LEFT OUTER JOIN "lego_baseset" T7 ON ("lego_setphoto"."set_id" = T7."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_type" IN ('Set') AND ("lego_baseset"."theme_id" IN (576) OR "lego_theme"."parent_id" IN (576) OR T3."parent_id" IN (576)) AND "lego_baseset"."year" IN (2025) ANDNOT ("lego_baseset"."theme_id" IN (739, 777, 503, 730, 734, 737, 735, 736, 733, 741, 731, 732, 738, 742, 501, 740))) ORDER BY "lego_baseset"."name" ASC, "lego_baseset"."year" ASC
30.88
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(148)
search_results = get_set_search(request, params)/home/nathan/rb/site/./lego/views/search.py in get_set_search(72)
results = sort_user_sets(request, results)/home/nathan/rb/site/./lego/filters.py in sort_user_sets(1523)
return SetSorter.sort_user_sets(user_sets, sort_by, sort_dir, group_by=group_by, group_by_db=group_by_db, set_prefix=set_prefix)/home/nathan/rb/site/./lego/constants/sets.py in sort_user_sets(73)
return list(sets.order_by(*order_by_fields))
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", T2."id", T2."parent_id", T2."name", T2."slug", T2."set_count", T2."t1_id", T2."t1_name", T2."t2_name", T2."t3_name", T2."lego_blurb", T2."banner_img", T2."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr" FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE ("lego_theme"."id" = 576 AND "lego_theme"."parent_id" ISNULL) LIMIT 21SELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE ("lego_theme"."id" = 576 AND "lego_theme"."parent_id" ISNULL) LIMIT 21
0.34
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(220)
theme = get_or_none(Theme.objects, id=int(params['top_theme']), parent__isnull=True)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
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.23
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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>
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", T2."id", T2."parent_id", T2."name", T2."slug", T2."set_count", T2."t1_id", T2."t1_name", T2."t2_name", T2."t3_name", T2."lego_blurb", T2."banner_img", T2."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr" FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE "lego_theme"."parent_id" ISNULL ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASCSELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE "lego_theme"."parent_id" ISNULLORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASC
2 similar queries.
Duplicated 2 times.
0.57
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.html', context)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in render(204)
c = self.get_render(context).flatten()/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in get_render(120)
actual_form.form_html = helper.render_layout(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/helper.py in render_layout(301)
html = self.layout.render(form, self.form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(135)
return self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(457)
return self.get_rendered_fields(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(139)
html = template.render(context)/home/nathan/rb/site/./lego/models/sets.py in get_all_sorted_choices(252)
for x in themes:
9
<div class="controls {% for offset in bootstrap_checkbox_offsets %}{{ offset }} {% endfor %}{{ field_class }}">
10
{% endif %}
11
{% endif %}
12
<{% if tag %}{{ tag }}{% else %}div{% endif %} id="div_{{ field.auto_id }}" {% if not field|is_checkbox %}class="form-group{% else %}class="checkbox{% endif %}{% if wrapper_class %} {{ wrapper_class }}{% endif %}{% if form_show_errors%}{% if field.errors %} has-error{% endif %}{% endif %}{% if field.css_classes %} {{ field.css_classes }}{% endif %}">
13
{% if field.label and not field|is_checkbox and form_show_labels %}
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", T2."id", T2."parent_id", T2."name", T2."slug", T2."set_count", T2."t1_id", T2."t1_name", T2."t2_name", T2."t3_name", T2."lego_blurb", T2."banner_img", T2."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr" FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE "lego_theme"."parent_id" ISNULL ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASCSELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE "lego_theme"."parent_id" ISNULLORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASC
2 similar queries.
Duplicated 2 times.
0.82
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.html', context)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in render(204)
c = self.get_render(context).flatten()/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in get_render(120)
actual_form.form_html = helper.render_layout(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/helper.py in render_layout(301)
html = self.layout.render(form, self.form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(135)
return self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(457)
return self.get_rendered_fields(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(139)
html = template.render(context)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_field.py in render(157)
return str(field)/home/nathan/rb/site/./lego/models/sets.py in get_all_sorted_choices(252)
for x in themes:
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", T2."id", T2."parent_id", T2."name", T2."slug", T2."set_count", T2."t1_id", T2."t1_name", T2."t2_name", T2."t3_name", T2."lego_blurb", T2."banner_img", T2."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr" FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASCSELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASC
2 similar queries.
Duplicated 2 times.
1.12
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.html', context)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in render(204)
c = self.get_render(context).flatten()/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in get_render(120)
actual_form.form_html = helper.render_layout(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/helper.py in render_layout(301)
html = self.layout.render(form, self.form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(135)
return self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(457)
return self.get_rendered_fields(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(139)
html = template.render(context)/home/nathan/rb/site/./lego/models/sets.py in get_all_sorted_choices(252)
for x in themes:
9
<div class="controls {% for offset in bootstrap_checkbox_offsets %}{{ offset }} {% endfor %}{{ field_class }}">
10
{% endif %}
11
{% endif %}
12
<{% if tag %}{{ tag }}{% else %}div{% endif %} id="div_{{ field.auto_id }}" {% if not field|is_checkbox %}class="form-group{% else %}class="checkbox{% endif %}{% if wrapper_class %} {{ wrapper_class }}{% endif %}{% if form_show_errors%}{% if field.errors %} has-error{% endif %}{% endif %}{% if field.css_classes %} {{ field.css_classes }}{% endif %}">
13
{% if field.label and not field|is_checkbox and form_show_labels %}
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", T2."id", T2."parent_id", T2."name", T2."slug", T2."set_count", T2."t1_id", T2."t1_name", T2."t2_name", T2."t3_name", T2."lego_blurb", T2."banner_img", T2."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr" FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASCSELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASC
2 similar queries.
Duplicated 2 times.
0.95
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.html', context)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in render(204)
c = self.get_render(context).flatten()/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in get_render(120)
actual_form.form_html = helper.render_layout(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/helper.py in render_layout(301)
html = self.layout.render(form, self.form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(135)
return self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
return field.render(form, form_style, context, template_pack=template_pack)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(457)
return self.get_rendered_fields(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
return "".join(/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(139)
html = template.render(context)/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_field.py in render(157)
return str(field)/home/nathan/rb/site/./lego/models/sets.py in get_all_sorted_choices(252)
for x in themes:
SELECT MAX("lego_inventory"."version") AS "version__max" FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 290261)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 290261)
4 similar queries.
0.26
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(989)
inv_version = self.inventory_set.aggregate(Max('version'))['version__max']
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
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"."is_active" AND "lego_inventory"."set_id" = 290261 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 290261 AND "lego_inventory"."version" = 1) LIMIT 21
4 similar queries.
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(991)
return self.inventory_set.get(version=inv_version)
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
SELECT MAX("lego_inventory"."version") AS "version__max" FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 291206)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 291206)
4 similar queries.
0.37
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(989)
inv_version = self.inventory_set.aggregate(Max('version'))['version__max']
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
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"."is_active" AND "lego_inventory"."set_id" = 291206 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 291206 AND "lego_inventory"."version" = 1) LIMIT 21
4 similar queries.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(991)
return self.inventory_set.get(version=inv_version)
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
SELECT MAX("lego_inventory"."version") AS "version__max" FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298600)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298600)
4 similar queries.
0.20
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(989)
inv_version = self.inventory_set.aggregate(Max('version'))['version__max']
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
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"."is_active" AND "lego_inventory"."set_id" = 298600 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298600 AND "lego_inventory"."version" = 1) LIMIT 21
4 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(991)
return self.inventory_set.get(version=inv_version)
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
SELECT MAX("lego_inventory"."version") AS "version__max" FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298582)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298582)
4 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(989)
inv_version = self.inventory_set.aggregate(Max('version'))['version__max']
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
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"."is_active" AND "lego_inventory"."set_id" = 298582 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298582 AND "lego_inventory"."version" = 1) LIMIT 21
4 similar queries.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
return render(request, 'sets/find_sets.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(977)
return self.get_latest_active_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(991)
return self.inventory_set.get(version=inv_version)
40
{% render_ignored_set list_set %}
41
{% elif type == 'set' %}
42
{# if set.inventory is set, will show that specific inventory #}
{% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
US
