| Resource | Value |
|---|---|
| User CPU time | 153.978 msec |
| System CPU time | 3.802 msec |
| Total CPU time | 157.780 msec |
| Elapsed time | 190.757 msec |
| Context switches | 53 voluntary, 0 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| 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-art' LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = 'lego-art' LIMIT 21 |
0.28 | ||||||||||||||||||||
|
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" IS NULL AND "lego_theme"."slug" = 'lego-art') 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" IS NULL AND "lego_theme"."slug" = 'lego-art') 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 (709) OR "lego_theme"."parent_id" IN (709) OR T3."parent_id" IN (709)) AND "lego_baseset"."year" IN (2024) AND NOT ("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 (709) OR "lego_theme"."parent_id" IN (709) OR T3."parent_id" IN (709)) AND "lego_baseset"."year" IN (2024) AND NOT ("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 |
29.45 | ||||||||||||||||||||
|
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" = 709 AND "lego_theme"."parent_id" IS NULL) 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" = 709 AND "lego_theme"."parent_id" IS NULL) LIMIT 21 |
0.30 | ||||||||||||||||||||
|
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.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/./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)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
SELECT "lego_theme"."id",
2 similar queries.
Duplicated 2 times.
"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" IS NULL 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" IS NULL ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASC |
0.52 | ||||||||||||||||||||
|
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:
/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templates/bootstrap3/field.html |
|||||||||||||||||||||
|
SELECT "lego_theme"."id",
2 similar queries.
Duplicated 2 times.
"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" IS NULL 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" IS NULL ORDER BY "lego_theme"."t1_name" ASC, "lego_theme"."t2_name" ASC, "lego_theme"."t3_name" ASC |
0.50 | ||||||||||||||||||||
|
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",
2 similar queries.
Duplicated 2 times.
"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.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:
/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templates/bootstrap3/field.html |
|||||||||||||||||||||
|
SELECT "lego_theme"."id",
2 similar queries.
Duplicated 2 times.
"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.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/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: |
|||||||||||||||||||||
No messages logged.