default
70.25 ms (24 queries
including 16 similar
)
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" = '2026' LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = '2026' LIMIT 21
8.65
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"."name" = 'Gear' 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"."name" = 'Gear' AND "lego_theme"."parent_id" ISNULL) LIMIT 21
0.28
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(48)
results = apply_set_filters(sets, params, user=request.user if request.user.is_authenticated else None)/home/nathan/rb/site/./lego/filters.py in apply_set_filters(566)
queryset_filter[set_model_prefix + 'theme_id__in'] = Theme.get_gear_themes()/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_gear_themes(395)
return cls.get_themes(Theme.THEME_GEAR, root_only=root_only)/home/nathan/rb/site/./lego/models/sets.py in get_themes(367)
root = cls.objects.get(name=theme_name, parent_id=None)
SELECT "lego_theme"."id" FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") WHERE ("lego_theme"."id" = 501 OR "lego_theme"."parent_id" = 501 OR T2."parent_id" = 501)SELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") WHERE ("lego_theme"."id" = 501 OR "lego_theme"."parent_id" = 501 OR T2."parent_id" = 501)
0.20
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(48)
results = apply_set_filters(sets, params, user=request.user if request.user.is_authenticated else None)/home/nathan/rb/site/./lego/filters.py in apply_set_filters(566)
queryset_filter[set_model_prefix + 'theme_id__in'] = Theme.get_gear_themes()/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_gear_themes(395)
return cls.get_themes(Theme.THEME_GEAR, root_only=root_only)/home/nathan/rb/site/./lego/models/sets.py in get_themes(370)
return list(root.get_child_themes().values_list('id', flat=True))
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"."year" IN (2026) 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"."year" IN (2026) 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
28.87
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 "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.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/./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 MAX("lego_baseset"."year") AS "year__max" FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."is_active"SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."is_active"
27.58
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_year_choices(1761)
max_year = Set.get_max_year()/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_max_year(1754)
return cls.objects.aggregate(Max('year'))['year__max']
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
0.56
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
1.43
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" = 303781)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303781)
8 similar queries.
0.14
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" = 303781 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303781 AND "lego_inventory"."version" = 1) LIMIT 21
8 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" = 303783)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303783)
8 similar queries.
0.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/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" = 303783 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303783 AND "lego_inventory"."version" = 1) LIMIT 21
8 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" = 303782)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303782)
8 similar queries.
0.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/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" = 303782 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303782 AND "lego_inventory"."version" = 1) LIMIT 21
8 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" = 296513)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296513)
8 similar queries.
0.18
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" = 296513 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296513 AND "lego_inventory"."version" = 1) LIMIT 21
8 similar queries.
0.15
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" = 296511)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296511)
8 similar queries.
0.28
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" = 296511 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296511 AND "lego_inventory"."version" = 1) LIMIT 21
8 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" = 296510)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296510)
8 similar queries.
0.17
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" = 296510 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296510 AND "lego_inventory"."version" = 1) LIMIT 21
8 similar queries.
0.14
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" = 303951)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303951)
8 similar queries.
0.17
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" = 303951 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 303951 AND "lego_inventory"."version" = 1) LIMIT 21
8 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(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" = 298754)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298754)
8 similar queries.
0.28
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" = 298754 AND "lego_inventory"."version" = 1) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 298754 AND "lego_inventory"."version" = 1) LIMIT 21
8 similar queries.
0.14
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
