Town LEGO Sets

Showing 50 of 677 unique Sets
4WD Police Patrol
4WD Police Patrol
6471-1
(30 parts)
Town > City Center 2000
4-Wheelin' Truck
4-Wheelin' Truck
6641-1
(81 parts)
Town > Classic Town 1987
Action Pack
Action Pack
78579-2
(0 parts)
Town 1998
Action Pack (Target Exclusive)
Action Pack (Target Exclusive)
78579-1
(0 parts)
Town 1998
Aerial Acrobats
Aerial Acrobats
6345-1
(351 parts)
Town > Classic Town 1993
Aerial Recovery
Aerial Recovery
6462-1
(205 parts)
Town > Res-Q 1998
Aero Hawk
Aero Hawk
6536-1
(48 parts)
Town > Classic Town 1993
Aircraft
Aircraft
1774-1
(139 parts)
Town > Classic Town 1992
Aircraft and Boat
Aircraft and Boat
2769-1
(98 parts)
Town 1999
Aircraft and Ground Crew
Aircraft and Ground Crew
2532-1
(143 parts)
Town 1998
Aircraft and Ground Support Equipment and Vehicle
Aircraft and Ground Support Equipment and Vehicle
1818-1
(204 parts)
Town > Classic Town 1996
Air Patrol
Air Patrol
1068-1
(20 parts)
Town > Extreme Team 1999
Air Police
Air Police
1149-1
(24 parts)
Town > Town Jr. 2002
Airport
Airport
6392-1 v2
(538 parts)
Town > Classic Town 1985
Airport Container Truck
Airport Container Truck
1772-1
(80 parts)
Town > Classic Town 1992
Airport Security Squad
Airport Security Squad
1475-1
(128 parts)
Town > Classic Town 1991
Airport Shuttle
Airport Shuttle
6399-1 v2
(786 parts)
Town > Classic Town 1990
Airshow (Red Tiger)
Airshow (Red Tiger)
2774-1
(145 parts)
Town 1999
Amazon Crossing
Amazon Crossing
6490-1
(119 parts)
Town > Outback 1997
Ambulance
Ambulance
606-1
(26 parts)
Town > Classic Town 1978
Ambulance
Ambulance
6629-1
(39 parts)
Town > Classic Town 1981
Ambulance
Ambulance
6680-1
(63 parts)
Town > Classic Town 1981
Ambulance
Ambulance
6688-1
(72 parts)
Town > Classic Town 1985
Ambulance
Ambulance
6666-1
(79 parts)
Town > Classic Town 1994
ANWB Roadside Assistance Crew
ANWB Roadside Assistance Crew
2140-1
(264 parts)
Town > Classic Town 1996
Arctic Expedition
Arctic Expedition
6573-1
(121 parts)
Town > Arctic 2000
Armored Car Action
Armored Car Action
7033-1
(187 parts)
Town > World City 2003
Astronaut Figure
Astronaut Figure
6457-1
(18 parts)
Town > Space Port 1999
Auto Service Station
Auto Service Station
6363-1
(142 parts)
Town > Classic Town 1980
Auto Service Truck
Auto Service Truck
646-1
(43 parts)
Town > Classic Town 1979
Auto & Tire Repair
Auto & Tire Repair
6655-1
(58 parts)
Town > Classic Town 1984
Backhoe
Backhoe
6686-1 v2
(89 parts)
Town > Classic Town 1984
Backhoe
Backhoe
6662-1
(87 parts)
Town > Classic Town 1992
Baja Buggy
Baja Buggy
6518-1
(37 parts)
Town > Classic Town 1996
Beach Bandit
Beach Bandit
6534-1
(44 parts)
Town > Classic Town 1992
Beach Buggy
Beach Buggy
6437-1
(28 parts)
Town > City Center 1999
Beach Rescue Chopper
Beach Rescue Chopper
6342-1
(150 parts)
Town > Classic Town 1993
Big Rig Truck Stop
Big Rig Truck Stop
6393-1
(635 parts)
Town > Classic Town 1987
Biker Bob
Biker Bob
2584-1
(22 parts)
Town > Town Jr. 1998
Black Racer
Black Racer
1631-1
(23 parts)
Town > Classic Town 1990
Blaze Battler
Blaze Battler
6593-1 v2
(125 parts)
Town > Classic Town 1991
Blaze Brigade
Blaze Brigade
6554-1
(259 parts)
Town > Town Jr. 1997
Blaze Commander
Blaze Commander
6525-1 v2
(50 parts)
Town > Classic Town 1995
Blaze Responder
Blaze Responder
6429-1 v2
(46 parts)
Town > City Center 1999
Blizzard Blazer
Blizzard Blazer
6524-1
(50 parts)
Town > Classic Town 1988
Blue Racer
Blue Racer
1282-1
(23 parts)
Town > Race 2000
Blue Racer
Blue Racer
6618-1
(23 parts)
Town > Race 2000
Boat
Boat
2883-1
(30 parts)
Town > Classic Town 1997
Breakdown Assistance (ANWB Version)
Breakdown Assistance (ANWB Version)
1590-2
(263 parts)
Town > Classic Town 1982
Breakdown Assistance (TCS Version)
Breakdown Assistance (TCS Version)
1589-2
(263 parts)
Town > Classic Town 1986
DJDT

Time

Resource usage

Resource Value
User CPU time 416.599 msec
System CPU time 9.869 msec
Total CPU time 426.468 msec
Elapsed time 484.205 msec
Context switches 236 voluntary, 1 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 46.61 ms (10 queries including 4 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" = 'town'
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = 'town' 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" = 'town')
 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" = 'town') LIMIT 21
 0.25

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 (50) OR "lego_theme"."parent_id" IN (50) OR T3."parent_id" IN (50)) 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 (50) OR "lego_theme"."parent_id" IN (50) OR T3."parent_id" IN (50)) 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
 42.11

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" = 50 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" = 50 AND "lego_theme"."parent_id" IS NULL) LIMIT 21
 0.31

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 "rb_sitesettings"."id",
       "rb_sitesettings"."name",
       "rb_sitesettings"."value"
  FROM "rb_sitesettings"
 WHERE "rb_sitesettings"."name" = 'site_message'
 LIMIT 21SELECT ••• FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21
 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/./rb/templatetags/rb_settings.py in site_message(147)
  message = SiteSettings.get_site_message()

/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
  result = method(instance, *args, **kwargs)

/home/nathan/rb/site/./rb/models/site.py in get_site_message(24)
  setting = cls.objects.get(name=SiteSettings.SITE_MESSAGE)
340
341 <body class="{% block body-class %}{{ request.user.get_body_classes }}{% endblock body-class %}">
342
343 {% site_message %}
344 <div id="wrapper" class="{% block wrapper_class %}{% endblock wrapper_class %} {% if request.user.is_anonymous %}{% else %}{{ request.user.get_personalisation_options.max_width }}{% endif %}">
345
346
347 <div id="topBar" class="hidden-sm hidden-xs">

/home/nathan/rb/site/rb/templates/rb/base_root.html
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.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/./rb/templatetags/rb_geo.py in geo_currency(20)
  geo_data = user.geo.get_user_currency()

/home/nathan/rb/site/./geo/geo.py in get_user_currency(252)
  country = Country.objects.get(iso=country_code)
412 </a>
413 </li>
414 <li class="hidden-xs">
415 {% geo_currency request.user %}
416 </li>
417 {% comment %}
418 <li class="hidden-xs hidden-sm">
419 <a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>

/home/nathan/rb/site/rb/templates/rb/base_root.html
SELECT "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
2 similar queries. Duplicated 2 times. 		0.61

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 %}
14 <label for="{{ field.id_for_label }}" class="control-label {{ label_class }}{% if field.field.required %} requiredField{% endif %}">
15 {{ field.label|safe }}{% if field.field.required %}<span class="asteriskField">*</span>{% endif %}
16 </label>

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templates/bootstrap3/field.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
2 similar queries. Duplicated 2 times. 		0.71

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

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 %}
14 <label for="{{ field.id_for_label }}" class="control-label {{ label_class }}{% if field.field.required %} requiredField{% endif %}">
15 {{ field.label|safe }}{% if field.field.required %}<span class="asteriskField">*</span>{% endif %}
16 </label>

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templates/bootstrap3/field.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")
 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.02

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:

Log messages

No messages logged.