LEGO Set Alternate Build MOCs

DJDT

Time

Resource usage

Resource	Value
User CPU time	1144.789 msec
System CPU time	33.635 msec
Total CPU time	1178.424 msec
Elapsed time	1776.456 msec
Context switches	1482 voluntary, 11 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 584.52 ms (132 queries including 130 similar )

Query Timeline Time (ms) Action

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_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."active_change_dt",
       T7."active_change_by_id",
       T7."last_checked_for_bi",
       T7."descr",
       T7."primary_photo_id",
       T7."primary_moc_image_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 U0."parent_set_1_id" AS "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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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."active_change_dt", T7."active_change_by_id", T7."last_checked_for_bi", T7."descr", T7."primary_photo_id", T7."primary_moc_image_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')

370.71

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1030)
  for set in sets:

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

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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(253)
  country = Country.objects.get(iso=country_code)

74	`</a>`
75	`</li>`
76	`<li>`
77	`{% geo_currency request.user %}`
78	`</li>`
79	`{% comment %}`
80	`<li class="hidden-xs hidden-sm">`
81	`<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/includes/topbar.html

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

58.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 358751
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 358751 LIMIT 21

120 similar queries.

0.40

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 332358
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 332358 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 317871
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 317871 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 347972
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 347972 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 349525
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 349525 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 321335
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 321335 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 23497
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 23497 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 24150
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 24150 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 340156
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 340156 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 10432
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 10432 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 2902
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 2902 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 324896
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 324896 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

33.03

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 378011
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 378011 LIMIT 21

120 similar queries.

0.28

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 356358
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 356358 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 358810
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 358810 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 26343
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 26343 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 291831
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 291831 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 363733
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 363733 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 278809
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 278809 LIMIT 21

120 similar queries.

0.22

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 221029
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 221029 LIMIT 21

120 similar queries.

0.21

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 366791
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 366791 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 323900
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 323900 LIMIT 21

120 similar queries.

0.22

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 548071
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 548071 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 339939
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 339939 LIMIT 21

120 similar queries.

0.22

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

16.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 8230
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 8230 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 2915
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 2915 LIMIT 21

120 similar queries.

0.07

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 326004
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 326004 LIMIT 21

120 similar queries.

0.21

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 286344
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 286344 LIMIT 21

120 similar queries.

0.21

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 172108
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 172108 LIMIT 21

120 similar queries.

0.22

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 38
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 38 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 327470
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 327470 LIMIT 21

120 similar queries.

0.21

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 20186
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 20186 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 9527
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 9527 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 7115
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 7115 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 5253
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 5253 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 6512
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 6512 LIMIT 21

120 similar queries.

0.22

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

7.70

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 319663
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 319663 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 320749
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 320749 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 319468
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 319468 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 320756
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 320756 LIMIT 21

120 similar queries.

0.09

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 319657
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 319657 LIMIT 21

120 similar queries.

0.09

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 332242
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 332242 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 320548
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 320548 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 322476
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 322476 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 319271
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 319271 LIMIT 21

120 similar queries.

0.17

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 320668
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 320668 LIMIT 21

120 similar queries.

0.18

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 320742
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 320742 LIMIT 21

120 similar queries.

0.19

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 319077
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 319077 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

17.60

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 245496
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 245496 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 232867
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 232867 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 204121
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 204121 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 3162
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 3162 LIMIT 21

120 similar queries.

0.19

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 164456
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 164456 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 249686
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 249686 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 136021
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 136021 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 2396
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 2396 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 253161
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 253161 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 182336
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 182336 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 1459
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1459 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 244367
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 244367 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

15.63

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 938
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 938 LIMIT 21

120 similar queries.

0.18

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 168197
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 168197 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 237613
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 237613 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 479152
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 479152 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 542209
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 542209 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 19321
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 19321 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 695806
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 695806 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 232762
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 232762 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 668994
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 668994 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 196948
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 196948 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 36155
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 36155 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 235297
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 235297 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

9.96

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 365238
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 365238 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 385702
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 385702 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 320483
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 320483 LIMIT 21

120 similar queries.

0.18

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 342373
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 342373 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 320515
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 320515 LIMIT 21

120 similar queries.

0.08

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 368554
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 368554 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 387869
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 387869 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 376191
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 376191 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 286782
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 286782 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 358465
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 358465 LIMIT 21

120 similar queries.

0.17

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 376459
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 376459 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 31582
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 31582 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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 12SELECT ••• 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

10 similar queries.

11.26

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 12961
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 12961 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 300996
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 300996 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 12548
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 12548 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 14792
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 14792 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 290012
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 290012 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 2693
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 2693 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 12941
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 12941 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 292225
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 292225 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 220412
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 220412 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 172
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 172 LIMIT 21

120 similar queries.

0.09

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 1329
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1329 LIMIT 21

120 similar queries.

0.10

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 288645
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 288645 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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" = 7463 AND "lego_moc"."parent_type" = 'A')
ORDER BY "lego_setstatstotal"."likes" DESC, "lego_setstatstotal"."hits" DESC
LIMIT 12SELECT ••• 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" = 7463 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC, "lego_setstatstotal"."hits" DESC LIMIT 12

10 similar queries.

7.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 49334
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 49334 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 62037
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 62037 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 57935
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 57935 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 196207
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 196207 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 37565
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 37565 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 60606
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 60606 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 219522
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 219522 LIMIT 21

120 similar queries.

0.10

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 29528
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 29528 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 192929
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 192929 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 68389
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 68389 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 34532
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 34532 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 219197
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 219197 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

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"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T3."id",
       T3."set_num",
       T3."name",
       T3."year",
       T3."theme_id",
       T3."set_type",
       T3."num_parts",
       T3."default_inventory_id",
       T3."is_active",
       T3."is_accessory",
       T3."added_dt",
       T3."added_by_id",
       T3."last_modified_dt",
       T3."last_modified_by_id",
       T3."active_change_dt",
       T3."active_change_by_id",
       T3."last_checked_for_bi",
       T3."descr",
       T3."primary_photo_id",
       T3."primary_moc_image_id",
       T3."is_gear",
       T3."is_book",
       T3."search_vector",
       T3."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_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" = 11213 AND "lego_moc"."parent_type" = 'A')
ORDER BY "lego_setstatstotal"."likes" DESC, "lego_setstatstotal"."hits" DESC
LIMIT 12SELECT ••• 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" = 11213 AND "lego_moc"."parent_type" = 'A') ORDER BY "lego_setstatstotal"."likes" DESC, "lego_setstatstotal"."hits" DESC LIMIT 12

10 similar queries.

10.44

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in alternate_builds(1072)
  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_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 336187
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 336187 LIMIT 21

120 similar queries.

0.25

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 11044
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 11044 LIMIT 21

120 similar queries.

0.16

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 5717
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 5717 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 24604
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 24604 LIMIT 21

120 similar queries.

0.17

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 2713
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 2713 LIMIT 21

120 similar queries.

0.09

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 16646
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 16646 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 4366
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 4366 LIMIT 21

120 similar queries.

0.17

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 7632
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 7632 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 9381
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 9381 LIMIT 21

120 similar queries.

0.17

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 7736
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 7736 LIMIT 21

120 similar queries.

0.23

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 503037
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 503037 LIMIT 21

120 similar queries.

0.26

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
WHERE "lego_mocimage"."id" = 18406
LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 18406 LIMIT 21

120 similar queries.

0.24

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image

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 %}`
53	`</a>`
54	`<small class="trunc">By <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></small>`
55	`</div>`
56	`{% endfor %}`

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

Log messages

No messages logged.

Alternate Builds

More Alternates

Deep Sea Creatures

Mighty Dinosaurs

Large Creative Brick Box

Snowspeeder

Toyota GR Supra

Majestic Tiger

Power Digger

Wild Lion

Mini Forklift

Medium Creative Brick Box

Time

Resource usage

Browser timing

SQL queries from 1 connection

Log messages