+
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.51
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.30
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.93
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.30
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" = 148275 LIMIT 21
0.15
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" = 245891 LIMIT 21
0.16
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" = 130127 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" = 147193 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" = 149131 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" = 245895 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" = 149141 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" = 245899 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" = 70460 LIMIT 21
0.16
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" = 70254 LIMIT 21
0.17
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" = 130390 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" = 171187 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()
/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" = 191 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()
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" = 26015 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" = 134657 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" = 196267 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" = 140411 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()
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" = 218935 LIMIT 21
0.15
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" = 131072 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" = 147146 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" = 123614 LIMIT 21
0.34
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" = 174365 LIMIT 21
0.16
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" = 148886 LIMIT 21
0.13
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" = 247068 LIMIT 21
0.13
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" = 133275 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" = 196153 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" = 150009 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()
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" = 247738 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" = 133614 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" = 196127 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" = 140879 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" = 219391 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" = 160817 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" = 291066 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" = 148304 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" = 245962 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" = 121790 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" = 171335 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" = 139843 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" = 218108 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" = 30881 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" = 19939 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" = 148257 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" = 245886 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" = 160973 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()
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" = 291389 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
US
