+
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.22
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.83
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.20
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" = 133896 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" = 196059 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" = 94141 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" = 102118 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" = 139850 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" = 218107 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" = 129510 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" = 193087 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" = 119526 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" = 167797 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" = 121709 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" = 171350 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" = 140814 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" = 218302 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" = 139885 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" = 218105 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" = 133287 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" = 196045 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" = 130435 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" = 170759 LIMIT 21
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)
/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" = 119522 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" = 167796 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" = 15006 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" = 26265 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" = 114433 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" = 154664 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" = 133041 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" = 193077 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" = 142222 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" = 224270 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" = 115937 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" = 157392 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" = 133978 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" = 196062 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" = 140042 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" = 217482 LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/ sets.py in buy_sets (931 )
return render(request, 'sets/buy_sets.html', context)
/home/nathan/rb/site/./lego/templatetags/sets/ drawing.py in render_set_img (65 )
return render_to_string('sets/render_set_img.html',
/home/nathan/rb/site/./lego/models/ sets.py in img_dir (751 )
file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/./lego/models/ sets.py in get_img_dir (3133 )
return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
1
<div class="text-center">
2
<a href="{{ set.get_absolute_url }}">
3
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir %}
4
</a>
5
</div>
6
/home/nathan/rb/site/lego/templates/sets/render_set_img.html
US
