+
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
99.79
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.26
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.92
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.22
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" = 156612 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" = 272916 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" = 21977 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" = 30294 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" = 134032 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" = 196081 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" = 155256 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" = 270866 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" = 77713 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" = 79009 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" = 148790 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" = 247371 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" = 88294 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" = 27892 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" = 133106 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" = 196075 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" = 18702 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" = 42157 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" = 133592 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" = 196122 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" = 134381 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" = 32802 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" = 134309 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" = 130912 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" = 139882 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" = 218039 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" = 155528 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" = 271062 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" = 126471 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" = 183041 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" = 16557 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" = 11237 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" = 89378 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" = 101963 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" = 158544 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" = 280746 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" = 16701 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" = 10483 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" = 155585 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" = 271073 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" = 156039 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" = 271046 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" = 141962 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" = 224868 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" = 95851 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" = 116509 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
