+
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
89.18
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.78
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.26
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" = 128312 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" = 188314 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" = 101969 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" = 132868 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" = 101774 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" = 132892 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" = 152163 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" = 256873 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" = 11271 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" = 21959 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" = 122646 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" = 163963 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" = 102692 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" = 132900 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" = 15167 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" = 41980 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" = 134189 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" = 187170 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" = 122644 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" = 163965 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" = 75508 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" = 74306 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" = 122659 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" = 163966 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" = 122648 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" = 163964 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" = 161512 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" = 295392 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" = 83128 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" = 86182 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" = 11065 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" = 30547 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" = 21691 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" = 35107 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" = 76524 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" = 77836 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" = 165009 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" = 304180 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" = 4492 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" = 30072 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" = 10349 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" = 21809 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
