City LEGO Sets from 2017

Showing 50 of 51 unique Sets
4 x 4 Response Unit
4 x 4 Response Unit
60165-1
(347 parts)
City > Coast Guard 2017
4x4 with Catamaran
4x4 with Catamaran
60149-1
(198 parts)
City 2017
ATV Arrest
ATV Arrest
60135-1
(47 parts)
City > Police 2017
ATV Race Team
ATV Race Team
60148-1
(239 parts)
City > Traffic 2017
Auto Transport Heist
Auto Transport Heist
60143-1
(403 parts)
City > Police 2017
Buggy
Buggy
60145-1 v2
(81 parts)
City > Off-Road 2017
Build My City Accessory Set
Build My City Accessory Set
40170-1
(102 parts)
City 2017
Bulldozer Break-In
Bulldozer Break-In
60140-1
(561 parts)
City > Police 2017
Bus Station
Bus Station
60154-1 v2
(337 parts)
City > Traffic 2017
Cargo Terminal
Cargo Terminal
60169-1
(740 parts)
City > Cargo 2017
City Jungle Explorer Kit
City Jungle Explorer Kit
40177-1
(40 parts)
City > Jungle 2017
City Playmat
City Playmat
853656-1
(105 parts)
City 2017
City Super Pack 3 in 1
City Super Pack 3 in 1
66550-1
(0 parts)
City > Police 2017
Coast Guard Head Quarters
Coast Guard Head Quarters
60167-1
(795 parts)
City > Coast Guard 2017
Coast Guard Starter Set
Coast Guard Starter Set
60163-1
(76 parts)
City > Coast Guard 2017
Diver and Shark
Diver and Shark
951703-1
(11 parts)
City > Harbor 2017
Dragster Transporter
Dragster Transporter
60151-1
(333 parts)
City 2017
Firefighter Fred
Firefighter Fred
951704-1
(21 parts)
City > Fire 2017
Fishing Boat
Fishing Boat
60147-1
(145 parts)
City > Harbor 2017
Heavy-Duty Rescue Helicopter
Heavy-Duty Rescue Helicopter
60166-1
(415 parts)
City > Coast Guard 2017
High-speed Chase
High-speed Chase
60138-1
(294 parts)
City > Police 2017
Holiday Co-pack
Holiday Co-pack
66580-1
(0 parts)
City 2017
Hot Rod
Hot Rod
30354-1
(38 parts)
City > Traffic 2017
Jungle Air Drop Helicopter
Jungle Air Drop Helicopter
60162-1
(1250 parts)
City > Jungle 2017
Jungle ATV
Jungle ATV
30355-1
(36 parts)
City > Jungle 2017
Jungle Buggy
Jungle Buggy
60156-1
(53 parts)
City > Jungle 2017
Jungle Cargo Helicopter
Jungle Cargo Helicopter
60158-1
(201 parts)
City > Jungle 2017
Jungle Exploration Site
Jungle Exploration Site
60161-1
(813 parts)
City > Jungle 2017
Jungle Halftrack Mission
Jungle Halftrack Mission
60159-1
(378 parts)
City > Jungle 2017
Jungle Mobile Lab
Jungle Mobile Lab
60160-1
(426 parts)
City > Jungle 2017
Jungle Starter Set
Jungle Starter Set
60157-1
(88 parts)
City > Jungle 2017
Mobile Command Center
Mobile Command Center
60139-1 v2
(374 parts)
City > Police 2017
Money Transporter
Money Transporter
60142-1
(138 parts)
City > Police 2017
People Pack - Fun At The Beach
People Pack - Fun At The Beach
60153-1
(169 parts)
City 2017
Pizza Van
Pizza Van
60150-1
(249 parts)
City > Traffic 2017
Police Car
Police Car
30352-1
(50 parts)
City > Police 2017
Police Helicopter
Police Helicopter
30351-1
(44 parts)
City > Police 2017
Policeman and Crook
Policeman and Crook
951701-1
(16 parts)
City > Police 2017
Police Road Block Mission
Police Road Block Mission
40175-1
(58 parts)
City > Police 2017
Police Starter Set
Police Starter Set
60136-1
(80 parts)
City > Police 2017
Police Station
Police Station
60141-1
(894 parts)
City > Police 2017
Race Plane
Race Plane
60144-1
(89 parts)
City > Airport 2017
Sailboat Rescue
Sailboat Rescue
60168-1
(196 parts)
City > Coast Guard 2017
Sea Rescue Plane
Sea Rescue Plane
60164-1
(141 parts)
City > Coast Guard 2017
Stunt Truck
Stunt Truck
60146-1
(91 parts)
City 2017
Summer Fun Kit
Summer Fun Kit
5005408-1
(0 parts)
City 2017
Sweeper & Excavator
Sweeper & Excavator
60152-1
(299 parts)
City > Construction 2017
Tow Truck Trouble
Tow Truck Trouble
60137-1
(144 parts)
City > Police 2017
Tractor
Tractor
30353-1
(47 parts)
City > Construction 2017
Ultimate LEGO City Hero Pack
Ultimate LEGO City Hero Pack
66559-1
(0 parts)
City 2017
DJDT

Time

Resource usage

Resource Value
User CPU time 492.262 msec
System CPU time 14.984 msec
Total CPU time 507.246 msec
Elapsed time 570.396 msec
Context switches 126 voluntary, 144 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 49.52 ms (9 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" = 'city'
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = 'city' LIMIT 21
 0.32

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" = 'city')
 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" = 'city') LIMIT 21
 0.28

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 (52) OR "lego_theme"."parent_id" IN (52) OR T3."parent_id" IN (52)) AND "lego_baseset"."year" IN (2017) 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 (52) OR "lego_theme"."parent_id" IN (52) OR T3."parent_id" IN (52)) AND "lego_baseset"."year" IN (2017) 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
 44.25

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

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

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

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

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in find_sets(307)
  return render(request, 'sets/find_sets.html', context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in render(204)
  c = self.get_render(context).flatten()

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in get_render(120)
  actual_form.form_html = helper.render_layout(

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/helper.py in render_layout(301)
  html = self.layout.render(form, self.form_style, context, template_pack=template_pack)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(135)
  return self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
  return "".join(

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
  render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
  return field.render(form, form_style, context, template_pack=template_pack)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
  fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
  return "".join(

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
  render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
  return field.render(form, form_style, context, template_pack=template_pack)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367)
  fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96)
  return "".join(

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97)
  render_field(field, form, form_style, context, template_pack=template_pack, **kwargs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66)
  return field.render(form, form_style, context, template_pack=template_pack)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(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.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(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.16

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.