+
SELECT (coalesce((select 100 * (cost_avg - lego_storesetitem.cost_usd)/cost_avg from lego_setcost sc where sc.set_id=lego_storesetitem.set_id and not sc.is_used), 0)) AS "discount", select cost_avg from lego_setcost sc where sc.set_id=lego_storesetitem.set_id and not sc.is_used)) AS "cost_avg", NOT "lego_storesetitem"."is_used" AND "lego_baseset"."set_num"::text LIKE '%-1' AND "lego_store"."is_active" AND ("lego_store"."ships_to" @> '"ALL"' OR "lego_store"."ships_to" @> '"US"') AND "lego_baseset"."year" BETWEEN 2015 AND 3000) SELECT ••• FROM "lego_storesetitem" INNER JOIN "lego_baseset" ON ("lego_storesetitem"."set_id" = "lego_baseset"."id") INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."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") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_baseset"."set_num"::text LIKE '%-1' AND "lego_store"."is_active" AND ("lego_store"."ships_to" @> '"ALL"' OR "lego_store"."ships_to" @> '"US"') AND "lego_baseset"."year" BETWEEN 2015 AND 3000) LIMIT 10000
88.72
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (858 )
discounted_sets = sorted(discounted_sets, key=lambda x: (-x['discount'] if isinstance(x, dict) else -x.discount,
+
SELECT "countries_plus_country"."iso", SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.24
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (897 )
item.user_cost = request.user.geo.format_user_currency(item.cost, item.store.currency_code)
/home/nathan/rb/site/./geo/ geo.py in format_user_currency (287 )
price = self.to_user_currency(price, from_currency_code)
/home/nathan/rb/site/./geo/ geo.py in to_user_currency (263 )
user_currency = self.get_user_currency()
/home/nathan/rb/site/./geo/ geo.py in get_user_currency (252 )
country = Country.objects.get(iso=country_code)
+
SELECT "lego_theme"."id", SELECT ••• FROM "lego_theme" LEFT OUTER JOIN "lego_theme" T2 ON ("lego_theme"."parent_id" = T2."id") LEFT OUTER JOIN "lego_theme" T3 ON (T2."parent_id" = T3."id")
0.71
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (922 )
themes = sorted(Theme.objects.all(), key=lambda x: x.get_full_name())
+
SELECT "lego_store"."id", SELECT ••• FROM "lego_merchantstore" INNER JOIN "lego_store" ON ("lego_merchantstore"."store_ptr_id" = "lego_store"."id") WHERE "lego_store"."is_active"
0.23
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
20
<label class="size-12 mt-10">Store</label>
21
<select name="store" class="form-control select2">
22
<option value="">All Stores</option>
23
{% for store in merchants %}
24
<option value="{{ store.id }}" {% if params.store|to_int == store.id %}selected{% endif %}>
25
{{ store.name }}
26
</option>
27
{% endfor %}
/home/nathan/rb/site/lego/templates/lego/includes/buy_sets_form.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 140597 LIMIT 21
0.12
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 218318 LIMIT 21
0.12
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 134090 LIMIT 21
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 196605 LIMIT 21
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 133517 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 196097 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 130389 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 171186 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 137095 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 204859 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 125592 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 179819 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 131071 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 147148 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 149471 LIMIT 21
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 247439 LIMIT 21
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 131821 LIMIT 21
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 147127 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 133354 LIMIT 21
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 196048 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 130774 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 147077 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 145681 LIMIT 21
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 236750 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 4212 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 23360 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 130391 LIMIT 21
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 171188 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 139463 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 215367 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 129920 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 147115 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 136957 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 204679 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 146058 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 233795 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 144282 LIMIT 21
0.14
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 231562 LIMIT 21
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 138270 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 211188 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_setphoto"."id", SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 123296 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
+
SELECT "lego_baseset"."id", SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 170747 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
US
