SELECT "lego_part"."id", "lego_part"."part_num", "lego_part"."name", "lego_part"."part_cat_id", "lego_part"."notes", "lego_part"."is_active", "lego_part"."search_vector", "lego_part"."ldraw_part_id", "lego_part"."bricklink_part_id", "lego_part"."ignore_color_errors", "lego_part"."part_material_id", "lego_part"."is_bricklink_minifig", "lego_part"."is_bricklink_book", "lego_part"."is_bricklink_gear", "lego_part"."show_generic_part_msg", "lego_partcategory"."id", "lego_partcategory"."name", "lego_partcategory"."part_count", "lego_partcategory"."img", "lego_partcategory"."slug", "lego_partmaterial"."id", "lego_partmaterial"."name", "lego_partoverlay"."part_id", "lego_partoverlay"."length", "lego_partstats"."part_id", "lego_partstats"."num_sets", "lego_partstats"."num_mocs", "lego_partstats"."num_set_parts", "lego_partstats"."num_moc_parts", "lego_partstats"."y1", "lego_partstats"."y2", "lego_partstats"."is_dirty" FROM "lego_part" INNER JOIN "lego_partcategory" ON ("lego_part"."part_cat_id" = "lego_partcategory"."id") INNER JOIN "lego_partmaterial" ON ("lego_part"."part_material_id" = "lego_partmaterial"."id") LEFT OUTER JOIN "lego_partoverlay" ON ("lego_part"."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") WHERE ("lego_part"."is_active" AND "lego_part"."part_num" IN ('3003', '3069bpr0023', '3069bpr0085', '3069bpr0049', '3069bpr0043', '4085a', '4085b', '4085c', '48183', '4859', '3878', '970c01', '973c28h01', '3626b'))SELECT ••• FROM "lego_part" INNER JOIN "lego_partcategory" ON ("lego_part"."part_cat_id" = "lego_partcategory"."id") INNER JOIN "lego_partmaterial" ON ("lego_part"."part_material_id" = "lego_partmaterial"."id") LEFT OUTER JOIN "lego_partoverlay" ON ("lego_part"."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") WHERE ("lego_part"."is_active" AND "lego_part"."part_num" IN ('3003', '3069bpr0023', '3069bpr0085', '3069bpr0049', '3069bpr0043', '4085a', '4085b', '4085c', '48183', '4859', '3878', '970c01', '973c28h01', '3626b'))
9.81
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/build.py in build_search(218)
context['build_form_parts'] = {p.part_num: p for p in build_form_parts}
SELECT "lego_element"."id", "lego_element"."part_id", "lego_element"."color_id", "lego_element"."element_id", "lego_element"."design_id", "lego_element"."descr", "lego_element"."color_descr", "lego_element"."last_download_attempt", "lego_element"."num_download_attempts", "lego_element"."is_export_id", "lego_element"."is_active" FROM "lego_element" INNER JOIN "lego_color" ON ("lego_element"."color_id" = "lego_color"."id") WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASCSELECT ••• FROM "lego_element" INNER JOIN "lego_color" ON ("lego_element"."color_id" = "lego_color"."id") WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC
1.38
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/build.py in build_search(218)
context['build_form_parts'] = {p.part_num: p for p in build_form_parts}
SELECT "lego_partcolorstats"."id", "lego_partcolorstats"."part_id", "lego_partcolorstats"."color_id", "lego_partcolorstats"."num_sets", "lego_partcolorstats"."num_mocs", "lego_partcolorstats"."num_set_parts", "lego_partcolorstats"."num_moc_parts", "lego_partcolorstats"."y1", "lego_partcolorstats"."y2", "lego_partcolorstats"."is_dirty", "lego_partcolorstats"."ignore_color_errors" FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480)SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480)
1.60
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/build.py in build_search(218)
context['build_form_parts'] = {p.part_num: p for p in build_form_parts}
SELECT "lego_partcost"."id", "lego_partcost"."part_id", "lego_partcost"."color_id", "lego_partcost"."is_used", "lego_partcost"."cost_avg", "lego_partcost"."cost_min", "lego_partcost"."cost_max", "lego_partcost"."cost_count" FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480)SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480)
2.16
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/build.py in build_search(218)
context['build_form_parts'] = {p.part_num: p for p in build_form_parts}
SELECT "lego_partphoto"."id", "lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480))SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (3071, 24387, 6484, 11413, 11752, 8747, 10821, 22867, 4798, 2347, 6472, 13702, 147, 7480))
2.01
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/build.py in build_search(218)
context['build_form_parts'] = {p.part_num: p for p in build_form_parts}
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/build.py in build_search(241)
return render(request, 'lego/build_search.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>
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" ISNULL ORDER BY "lego_theme"."name" ASCSELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id") WHERE "lego_theme"."parent_id" ISNULLORDER BY "lego_theme"."name" ASC
0.66
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/build.py in build_search(241)
return render(request, 'lego/build_search.html', context)/home/nathan/rb/site/./lego/templatetags/sets/themes.py in render_root_themes_select(10)
themes = Theme.get_root_themes()/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_root_themes(308)
return list(themes)
13
<div class="form-group row">
14
<label for="theme" class="control-label col-md-3">Filter on Theme</label>
US