LEGO Brand Store LEGO Sets

Showing 50 of 436 unique Sets
100 LEGO Stores North America
100 LEGO Stores North America
100STORES-1
(5 parts)
LEGO Brand Store 2019
3D Easter Egg
3D Easter Egg
6562115-1
(41 parts)
LEGO Brand Store 2025
75th Anniversary Duck on Wheels
75th Anniversary Duck on Wheels
Duck75-1
(44 parts)
LEGO Brand Store 2007
85 Sky Tower
85 Sky Tower
6218490-1
(180 parts)
LEGO Brand Store > Cities of Wonders 2017
Acorn
Acorn
MMMB043-1
(26 parts)
LEGO Brand Store > Monthly Mini Model Build 2011
AFI Cotroceni Grand Opening
AFI Cotroceni Grand Opening
6570382-1
(0 parts)
LEGO Brand Store 2025
Aircraft
Aircraft
40102-1
(37 parts)
LEGO Brand Store > Monthly Mini Model Build 2014
Aircraft
Aircraft
3850009-1
(41 parts)
LEGO Brand Store > Pick A Model 2016
Alien and Space Dog
Alien and Space Dog
40126-1
(55 parts)
LEGO Brand Store > Monthly Mini Model Build 2015
Amsterdam Tile
Amsterdam Tile
6424711-1
(1 parts)
LEGO Brand Store 2022
Angler Fish
Angler Fish
40135-1
(29 parts)
LEGO Brand Store > Monthly Mini Model Build 2015
Anniversary Minifigure Pack
Anniversary Minifigure Pack
5007499-1
(8 parts)
LEGO Brand Store 2022
Anniversary Red Brick
Anniversary Red Brick
5007594-1
(73 parts)
LEGO Brand Store 2022
Apple
Apple
40215-1
(58 parts)
LEGO Brand Store > Monthly Mini Model Build 2016
Apple Tree
Apple Tree
40400-1
(37 parts)
LEGO Brand Store > Monthly Mini Model Build 2020
Arcade driving game
Arcade driving game
ARCADE-1
(32 parts)
LEGO Brand Store 2023
Art Deco Hotel
Art Deco Hotel
MIAMI-1
(142 parts)
LEGO Brand Store 2010
Barbecue
Barbecue
MMMB025-1
(21 parts)
LEGO Brand Store > Monthly Mini Model Build 2010
Barcelona Brand Store Opening Associate Figure
Barcelona Brand Store Opening Associate Figure
6384346-1
(129 parts)
LEGO Brand Store 2021
Barcelona Tile
Barcelona Tile
6431476-1
(1 parts)
LEGO Brand Store 2022
Barracuda Seas
Barracuda Seas
5007330-1
(0 parts)
LEGO Brand Store 2022
Batman & Robin
Batman & Robin
PAB4-1
(96 parts)
LEGO Brand Store > Pick A Model 2012
Battersea Power Station
Battersea Power Station
BATTERSEA-1
(45 parts)
LEGO Brand Store 2023
BBQ
BBQ
40282-1
(37 parts)
LEGO Brand Store > Monthly Mini Model Build 2018
Beaver
Beaver
3850016-1
(52 parts)
LEGO Brand Store > Pick A Model 2017
Bee
Bee
40211-1
(34 parts)
LEGO Brand Store > Monthly Mini Model Build 2016
Beijing Tile
Beijing Tile
6424708-1
(1 parts)
LEGO Brand Store 2022
Belfast Grand Opening
Belfast Grand Opening
5009417-1
(158 parts)
LEGO Brand Store 2025
Belgrade Grand Opening
Belgrade Grand Opening
6582904-1
(158 parts)
LEGO Brand Store 2025
Berlin Grand Opening
Berlin Grand Opening
5009508-1
(158 parts)
LEGO Brand Store 2025
Berlin Tile
Berlin Tile
6424712-1
(1 parts)
LEGO Brand Store 2022
Big Inauguration of LEGO Store in Stockholm!
Big Inauguration of LEGO Store in Stockholm!
STOCKHOLM-1
(13 parts)
LEGO Brand Store 2016
Big New Opening LEGO Store Berlin
Big New Opening LEGO Store Berlin
BERLIN-2
(0 parts)
LEGO Brand Store 2017
Big Opening Ceremony of LEGO Stores Donau Zentrum
Big Opening Ceremony of LEGO Stores Donau Zentrum
VIENNA-2
(17 parts)
LEGO Brand Store 2013
Big Opening Ceremony of LEGO Stores SCS
Big Opening Ceremony of LEGO Stores SCS
VIENNA-1
(17 parts)
LEGO Brand Store 2013
Billund Airport
Billund Airport
4000016-1
(281 parts)
LEGO Brand Store 2014
Billund Airport
Billund Airport
40199-1
(286 parts)
LEGO Brand Store 2018
Biplane
Biplane
3850004-1
(24 parts)
LEGO Brand Store > Pick A Model 2015
Bird
Bird
MMMB035-1
(31 parts)
LEGO Brand Store > Monthly Mini Model Build 2011
Birds
Birds
MMMB021-1
(25 parts)
LEGO Brand Store > Monthly Mini Model Build 2010
Black Friday 2019 Brick
Black Friday 2019 Brick
5006066-1
(1 parts)
LEGO Brand Store 2019
Black Friday 2019 Minifigure
Black Friday 2019 Minifigure
5006065-1
(3 parts)
LEGO Brand Store 2019
Bonn Brand Store Opening Associate Figure
Bonn Brand Store Opening Associate Figure
6399469-1
(129 parts)
LEGO Brand Store 2021
Book and Pencil Set
Book and Pencil Set
MMMB013-1
(24 parts)
LEGO Brand Store > Monthly Mini Model Build 2009
Boom Box
Boom Box
6575258-1
(34 parts)
LEGO Brand Store 2025
Boy with Backpack
Boy with Backpack
MMMB028-1
(41 parts)
LEGO Brand Store > Monthly Mini Model Build 2010
Brandenburg Tor
Brandenburg Tor
BRANDENBURGTOR-1
(34 parts)
LEGO Brand Store 2024
Brick Lab
Brick Lab
6385891-1
(0 parts)
LEGO Brand Store 2021
Brickley
Brickley
3300001-1
(197 parts)
LEGO Brand Store 2011
Bull
Bull
BULL-1
(64 parts)
LEGO Brand Store 2019
DJDT

Time

Resource usage

Resource Value
User CPU time 403.947 msec
System CPU time 10.993 msec
Total CPU time 414.940 msec
Elapsed time 462.713 msec
Context switches 172 voluntary, 0 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 49.19 ms (11 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" = 'lego-brand-store'
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = 'lego-brand-store' LIMIT 21
 0.25

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-brand-store')
 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-brand-store') LIMIT 21
 0.32

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

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

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)
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.51

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

Connection: default

Transaction status: Idle

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

/home/nathan/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. 		0.98

Connection: default

Transaction status: Idle

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

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

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

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

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

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

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

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

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

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

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

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

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(457)
  return self.get_rendered_fields(

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

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

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(139)
  html = template.render(context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_field.py in render(157)
  return str(field)

/home/nathan/rb/site/./lego/models/sets.py in get_all_sorted_choices(252)
  for x in themes:
SELECT MAX("lego_inventory"."version") AS "version__max"
  FROM "lego_inventory"
 WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296226)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296226)
 0.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/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
  inventory = set.get_default_inventory()

/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(977)
  return self.get_latest_active_inventory()

/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(989)
  inv_version = self.inventory_set.aggregate(Max('version'))['version__max']
40 {% render_ignored_set list_set %}
41 {% elif type == 'set' %}
42 {# if set.inventory is set, will show that specific inventory #}
43 {% render_set list_set list_set.sub_text inventory=list_set.inventory %}
44 {% elif type == 'moc' %}
45 {# render_set list_set list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
46 {% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
47 {% elif type == 'figure' %}

/home/nathan/rb/site/lego/templates/sets/render_sets_list.html
SELECT "lego_inventory"."id",
       "lego_inventory"."set_id",
       "lego_inventory"."version",
       "lego_inventory"."name",
       "lego_inventory"."is_active",
       "lego_inventory"."num_parts",
       "lego_inventory"."num_versions"
  FROM "lego_inventory"
 WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296226 AND "lego_inventory"."version" = 1)
 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 296226 AND "lego_inventory"."version" = 1) LIMIT 21
 0.11

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
  inventory = set.get_default_inventory()

/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(977)
  return self.get_latest_active_inventory()

/home/nathan/rb/site/./lego/models/sets.py in get_latest_active_inventory(991)
  return self.inventory_set.get(version=inv_version)
40 {% render_ignored_set list_set %}
41 {% elif type == 'set' %}
42 {# if set.inventory is set, will show that specific inventory #}
43 {% render_set list_set list_set.sub_text inventory=list_set.inventory %}
44 {% elif type == 'moc' %}
45 {# render_set list_set list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
46 {% include 'sets/render_set.html' with set=list_set list_set=None title=set.name sub_text=list_set.sub_text tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
47 {% elif type == 'figure' %}

/home/nathan/rb/site/lego/templates/sets/render_sets_list.html

Log messages

No messages logged.