+
SELECT (select count(*) AS "num_alts", AND "lego_baseset"."id" IN (SELECT U0."parent_set_1_id" FROM "lego_moc" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") WHERE (U1."is_active" AND U1."is_active" AND U0."parent_type" = 'A')) AND "lego_baseset"."set_type" = 'Set')SELECT (select count(*) from lego_moc m join lego_baseset bs on bs.id=m.baseset_ptr_id
where m.parent_set_1_id=lego_set.baseset_ptr_id and parent_type='A' and is_active) AS "num_alts", "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_set"."baseset_ptr_id", "lego_set"."start_date", "lego_set"."end_date", "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_set" ON ("lego_baseset"."id" = "lego_set"."baseset_ptr_id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."id" IN (SELECT ••• FROM "lego_moc" U0 INNER JOIN "lego_baseset" U1 ON (U0."baseset_ptr_id" = U1."id") WHERE (U1."is_active" AND U1."is_active" AND U0."parent_type" = 'A')) AND "lego_baseset"."set_type" = 'Set')
240.59
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1021 )
for set in sets:
+
SELECT "countries_plus_country"."iso", SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.27
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.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_baseset"."id", AND "lego_moc"."parent_set_1_id" = 29889 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 29889 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
20.16
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 11409 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 11409 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
9.74
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 43495 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 43495 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
6.77
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 98333 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 98333 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
7.72
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 1287 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 1287 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
6.91
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 3100 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 3100 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
6.61
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 115915 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 115915 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
7.96
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 80217 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 80217 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
6.29
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 41817 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 41817 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
5.97
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
+
SELECT "lego_baseset"."id", AND "lego_moc"."parent_set_1_id" = 65390 AND "lego_moc"."parent_type" = 'A') DESC , "lego_setstatstotal"."hits" DESC SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T5 ON ("lego_theme"."parent_id" = T5."id") LEFT OUTER JOIN "lego_theme" T6 ON (T5."parent_id" = T6."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" = 65390 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC , "lego_setstatstotal"."hits" DESC LIMIT 12
6.54
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in alternate_builds (1063 )
return render(request, 'sets/alternate_builds.html', context)
45
</div>
46
<div class="col-xs-6 col-sm-9">
47
<div class="row">
48
{% for moc in set.mocs %}
49
<div class="col-xs-6 col-sm-3 col-md-2 col-condensed {% if forloop.counter > 4 %}hidden-xs {% endif %}{% if forloop.counter > 8 %}hidden-sm {% endif %}">
50
{# render_set_img moc tn_options=settings.THUMBS_OPTIONS_MOC_TILE #}
51
<a href="{{ moc.get_absolute_url }}">
52
{% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/lego/templates/sets/alternate_builds.html
US
![[Free] 76901 Toyota Supra mk4](https://cdn.dev.rebrickable.com/media/thumbs/mocs/moc-120249.jpg/200x160c.jpg?1769053484.2874165 "[Free] 76901 Toyota Supra mk4")
![[Free] 76901 Silvia S15 Nissan](https://cdn.dev.rebrickable.com/media/thumbs/mocs/moc-123285.jpg/200x160c.jpg?1769053484.2888303 "[Free] 76901 Silvia S15 Nissan")
