US
Show Advanced Options
| Resource | Value |
|---|---|
| User CPU time | 115.099 msec |
| System CPU time | 3.953 msec |
| Total CPU time | 119.052 msec |
| Elapsed time | 203.173 msec |
| Context switches | 32 voluntary, 4 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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" |
36.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/sets.py in find_sets(203) context['themes'] = Theme.get_current_themes() /home/nathan/rb/site/./lego/models/sets.py in get_current_themes(422) 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'] |
|||||||||||||||||||||
|
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.22 | ||||||||||||||||||||
|
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",
"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.62 | ||||||||||||||||||||
|
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.60 | ||||||||||||||||||||
|
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 "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" IN (SELECT U2."t1_name" FROM "lego_set" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") INNER JOIN "lego_theme" U2 ON (U1."theme_id" = U2."id") WHERE (U1."is_active" AND U1."year" IN (2026, 2025))) AND "lego_theme"."parent_id" IS NULL AND "lego_theme"."t1_name" IN ('Architecture', 'Brickheadz', 'Botanicals', 'City', 'Classic', 'Creator', 'Disney', 'Dreamzzz', 'Friends', 'Harry Potter', 'Icons', 'Jurassic World', 'LEGO Ideas and CUUSOO', 'Minecraft', 'Monkie Kid', 'Ninjago', 'Sonic The Hedgehog', 'Speed Champions', 'Star Wars', 'Super Heroes DC', 'Super Heroes Marvel', 'Super Mario', 'Technic') AND "lego_theme"."t2_name" IS NULL) ORDER BY "lego_theme"."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"."name" IN (SELECT ••• FROM "lego_set" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") INNER JOIN "lego_theme" U2 ON (U1."theme_id" = U2."id") WHERE (U1."is_active" AND U1."year" IN (2026, 2025))) AND "lego_theme"."parent_id" IS NULL AND "lego_theme"."t1_name" IN ('Architecture', 'Brickheadz', 'Botanicals', 'City', 'Classic', 'Creator', 'Disney', 'Dreamzzz', 'Friends', 'Harry Potter', 'Icons', 'Jurassic World', 'LEGO Ideas and CUUSOO', 'Minecraft', 'Monkie Kid', 'Ninjago', 'Sonic The Hedgehog', 'Speed Champions', 'Star Wars', 'Super Heroes DC', 'Super Heroes Marvel', 'Super Mario', 'Technic') AND "lego_theme"."t2_name" IS NULL) ORDER BY "lego_theme"."name" ASC |
35.78 | ||||||||||||||||||||
|
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/templates/sets/find_sets.html |
|||||||||||||||||||||
No messages logged.
