This set contains 10 (+1 spare) random Square Tiles out of 11 possible. These are not included in this inventory. A complete list with possible tiles can be found in set DOTS-MEGA-PACK-5. Here, you can select the tiles from your set, and add them to a part list.
This set was part of a VIP Sweepstakes Disney 100 Making Wonder Bundle that ran from April 30th thru May 29th 2023 for 50 VIP points per entry with one free entry.
default
229.29 ms (86 queries
including 57 similar
and 14 duplicates
)
Query
Timeline
Time (ms)
Action
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."set_num" = '41964-1' LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = '41964-1' LIMIT 21
2 similar queries.
Duplicated 2 times.
0.33
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(112)
baseset = get_or_none(BaseSet.all_objects, set_num=set_num)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."set_num" = '41964-1' LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."set_num" = '41964-1' LIMIT 21
2 similar queries.
Duplicated 2 times.
0.29
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(337)
baseset = BaseSet.all_objects.get(set_num=set_num)
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_set"."baseset_ptr_id", "lego_set"."start_date", "lego_set"."end_date" FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 139018 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 139018 LIMIT 21
4 similar queries.
Duplicated 2 times.
0.17
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(344)
set = baseset.get_child_instance()/home/nathan/rb/site/./lego/models/sets.py in get_child_instance(1666)
return self.set
SELECT "lego_inventory"."id", "lego_inventory"."set_id", "lego_inventory"."version", "lego_inventory"."name", "lego_inventory"."is_active", "lego_inventory"."num_parts", "lego_inventory"."num_versions" FROM "lego_inventory" WHERE "lego_inventory"."id" = 141867 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 141867 LIMIT 21
2 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(369)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(971)
if self.default_inventory is not None:
SELECT "lego_changelog"."id", "lego_changelog"."timestamp", "lego_changelog"."user_id", "lego_changelog"."model", "lego_changelog"."instance_id", "lego_changelog"."set_num", "lego_changelog"."part_num", "lego_changelog"."old_value", "lego_changelog"."new_value" FROM "lego_changelog" WHERE "lego_changelog"."set_num" = '41964-1' ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = '41964-1' ORDER BY "lego_changelog"."timestamp" DESC
13.35
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(381)
changes = set.get_change_summary()/home/nathan/rb/site/./lego/models/sets.py in get_change_summary(1121)
changes = ChangeLog.get_changes(set_num=self.set_num)/home/nathan/rb/site/./lego/models/changes.py in get_changes(276)
if len(changes) > 0:
SELECT "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 139018 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 139018 LIMIT 21
0.12
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(384)
set.stats.inc_hits()/usr/lib/python3.10/contextlib.py in inner(79)
return func(*args, **kwds)/home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36)
.__get__(instance, instance_type)
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(384)
set.stats.inc_hits()/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2637)
self.save()
SELECT "lego_setstatshistory"."id", "lego_setstatshistory"."set_id", "lego_setstatshistory"."day", "lego_setstatshistory"."hits", "lego_setstatshistory"."builds", "lego_setstatshistory"."likes", "lego_setstatshistory"."bi_downloads", "lego_setstatshistory"."featured_hits", "lego_setstatshistory"."user_hits" FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-22'::date AND "lego_setstatshistory"."set_id" = 139018) LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-22'::date AND "lego_setstatshistory"."set_id" = 139018) LIMIT 21
0.24
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(384)
set.stats.inc_hits()/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2587)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(384)
set.stats.inc_hits()/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2587)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(384)
set.stats.inc_hits()/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2587)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(384)
set.stats.inc_hits()/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2587)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(384)
set.stats.inc_hits()/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2589)
self.save()
SELECT "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr" FROM "lego_theme" WHERE "lego_theme"."id" = 688 LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 688 LIMIT 21
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(419)
context['similar_sets'] = set.get_similar_sets(10)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_similar_sets(1350)
""", {'theme': self.theme.name,
SELECTDISTINCT "taggit_tag"."id", "taggit_tag"."name", "taggit_tag"."slug", COUNT("lego_set"."baseset_ptr_id") AS "count" FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") LEFT OUTER JOIN "lego_baseset" ON ("taggit_taggeditem"."object_id" = "lego_baseset"."id" AND ("taggit_taggeditem"."content_type_id" IN (18,63,17,22,20,31,50,180))) LEFT OUTER JOIN "lego_set" ON ("lego_baseset"."id" = "lego_set"."baseset_ptr_id") INNER JOIN "taggit_taggeditem" T6 ON ("taggit_tag"."id" = T6."tag_id") INNER JOIN "lego_baseset" T7 ON (T6."object_id" = T7."id" AND (T6."content_type_id" IN (18,63,17,22,20,31,50,180))) INNER JOIN "lego_set" T8 ON (T7."id" = T8."baseset_ptr_id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'set' AND T8."baseset_ptr_id" = 139018) GROUP BY "taggit_tag"."id"SELECT ••• FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") LEFT OUTER JOIN "lego_baseset" ON ("taggit_taggeditem"."object_id" = "lego_baseset"."id" AND ("taggit_taggeditem"."content_type_id" IN (18,63,17,22,20,31,50,180))) LEFT OUTER JOIN "lego_set" ON ("lego_baseset"."id" = "lego_set"."baseset_ptr_id") INNER JOIN "taggit_taggeditem" T6 ON ("taggit_tag"."id" = T6."tag_id") INNER JOIN "lego_baseset" T7 ON (T6."object_id" = T7."id" AND (T6."content_type_id" IN (18,63,17,22,20,31,50,180))) INNER JOIN "lego_set" T8 ON (T7."id" = T8."baseset_ptr_id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'set' AND T8."baseset_ptr_id" = 139018) GROUP BY "taggit_tag"."id"
33.91
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(419)
context['similar_sets'] = set.get_similar_sets(10)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_similar_sets(1352)
'tag_ids': ' '.join(str(t.id) for t in self.get_tags() if t.id != 4), # 4 == moc
set pg_trgm.similarity_threshold = 0.2; SELECT "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id",
"lego_baseset"."num_parts", "lego_baseset"."is_active", "lego_baseset"."is_accessory",
"lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt",
"lego_baseset"."last_modified_by_id", "lego_baseset"."set_type", "lego_baseset"."primary_photo_id",
"lego_setstatstotal"."likes",
lego_theme.name as theme_name, lego_theme.parent_id as theme_parent,
lego_baseset.id,
(SIMILARITY ("lego_baseset"."name", 'Back To School Project Box')*5
+ similarity(coalesce(( select string_agg(tag_id::text, ' ') as tags from taggit_taggeditem where content_type_id in (17,18,22,63,31,180) and object_id=lego_baseset.id ),''), '23 446 697 698 4484 4844 6852 7468 23676 25934 57305')*5
+ similarity("lego_theme"."name", 'DOTS')/3
+ similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2
+ similarity(substr("lego_baseset"."descr",0,100), 'This set contains 10 (+1 spare) random Square Tiles out of 11 possible. These are not included in th')) * least(likes/hits::float, 0.002) as similarity
FROM lego_baseset
INNER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id")
WHERE "lego_setstatstotal"."likes" > 50
AND "lego_setstatstotal"."hits" > 0
AND "lego_baseset"."is_active" = true AND ((lego_baseset.name || ' ' || lego_baseset.theme_id::text) % 'Back To School Project Box 688')
ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10
set pg_trgm.similarity_threshold = 0.2;
SELECT "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id",
"lego_baseset"."num_parts", "lego_baseset"."is_active", "lego_baseset"."is_accessory",
"lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt",
"lego_baseset"."last_modified_by_id", "lego_baseset"."set_type", "lego_baseset"."primary_photo_id",
"lego_setstatstotal"."likes",
lego_theme.name as theme_name, lego_theme.parent_id as theme_parent,
lego_baseset.id,
(SIMILARITY ("lego_baseset"."name", 'Back To School Project Box')*5
+ similarity(coalesce(( select string_agg(tag_id::text, ' ') as tags from taggit_taggeditem where content_type_id in (17,18,22,63,31,180) and object_id=lego_baseset.id ),''), '23 446 697 698 4484 4844 6852 7468 23676 25934 57305')*5
+ similarity("lego_theme"."name", 'DOTS')/3
+ similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2
+ similarity(substr("lego_baseset"."descr",0,100), 'This set contains 10 (+1 spare) random Square Tiles out of 11 possible. These are not included in th')) * least(likes/hits::float, 0.002) as similarity
FROM lego_baseset
INNER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id")
WHERE "lego_setstatstotal"."likes" > 50
AND "lego_setstatstotal"."hits" > 0
AND "lego_baseset"."is_active" = trueAND ((lego_baseset.name || ' ' || lego_baseset.theme_id::text) % 'Back To School Project Box 688')
ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESCLIMIT 10
56.86
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(419)
context['similar_sets'] = set.get_similar_sets(10)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_similar_sets(1361)
qs = list(qs)
SELECT "lego_storesetitem"."id", "lego_storesetitem"."store_id", "lego_storesetitem"."is_used", "lego_storesetitem"."cost", "lego_storesetitem"."cost_usd", "lego_storesetitem"."sale_cost", "lego_storesetitem"."sku", "lego_storesetitem"."item_url", "lego_storesetitem"."quantity", "lego_storesetitem"."timestamp", "lego_storesetitem"."set_id", "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT U0."id" FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%linksynergy.com%'))))SELECT ••• FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT ••• FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%linksynergy.com%'))))
4 similar queries.
0.59
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(431)
for item in items:
SELECT "lego_storesetitem"."id", "lego_storesetitem"."store_id", "lego_storesetitem"."is_used", "lego_storesetitem"."cost", "lego_storesetitem"."cost_usd", "lego_storesetitem"."sale_cost", "lego_storesetitem"."sku", "lego_storesetitem"."item_url", "lego_storesetitem"."quantity", "lego_storesetitem"."timestamp", "lego_storesetitem"."set_id", "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT U0."id" FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%brickowl.com%'))))SELECT ••• FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT ••• FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%brickowl.com%'))))
4 similar queries.
0.35
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(431)
for item in items:
SELECT "countries_plus_country"."iso", "countries_plus_country"."iso3", "countries_plus_country"."iso_numeric", "countries_plus_country"."fips", "countries_plus_country"."name", "countries_plus_country"."capital", "countries_plus_country"."area", "countries_plus_country"."population", "countries_plus_country"."continent", "countries_plus_country"."tld", "countries_plus_country"."currency_code", "countries_plus_country"."currency_symbol", "countries_plus_country"."currency_name", "countries_plus_country"."phone", "countries_plus_country"."postal_code_format", "countries_plus_country"."postal_code_regex", "countries_plus_country"."languages", "countries_plus_country"."geonameid", "countries_plus_country"."neighbours", "countries_plus_country"."equivalent_fips_code" FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.15
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(443)
item.cost = user.geo.format_user_currency(item.cost or 0, 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_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 139018 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 139018 LIMIT 21
3 similar queries.
Duplicated 2 times.
0.13
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(447)
item.item_url = item.get_store_item_url()/home/nathan/rb/site/./lego/models/stores.py in get_store_item_url(401)
return self.store.store_url.split('?')[0] + '/search/store?utm_source=rebrickable&query=' + self.set.set_num
SELECT "lego_storesetitem"."id", "lego_storesetitem"."store_id", "lego_storesetitem"."is_used", "lego_storesetitem"."cost", "lego_storesetitem"."cost_usd", "lego_storesetitem"."sale_cost", "lego_storesetitem"."sku", "lego_storesetitem"."item_url", "lego_storesetitem"."quantity", "lego_storesetitem"."timestamp", "lego_storesetitem"."set_id", "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT U0."id" FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%bricklink.com%'))))SELECT ••• FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT ••• FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%bricklink.com%'))))
4 similar queries.
0.31
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(431)
for item in items:
SELECT "lego_storesetitem"."id", "lego_storesetitem"."store_id", "lego_storesetitem"."is_used", "lego_storesetitem"."cost", "lego_storesetitem"."cost_usd", "lego_storesetitem"."sale_cost", "lego_storesetitem"."sku", "lego_storesetitem"."item_url", "lego_storesetitem"."quantity", "lego_storesetitem"."timestamp", "lego_storesetitem"."set_id", "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT U0."id" FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%www.amazon.%'))))SELECT ••• FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" IN (SELECT ••• FROM "lego_store" U0 WHERE (U0."is_active" AND UPPER(U0."store_url"::text) LIKE UPPER('%www.amazon.%'))))
4 similar queries.
0.30
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(431)
for item in items:
SELECT "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_store" WHERE ("lego_store"."is_active" AND "lego_store"."country_code" = 'US' AND UPPER("lego_store"."store_url"::text) LIKE UPPER('%linksynergy.com%')) LIMIT 21SELECT ••• FROM "lego_store" WHERE ("lego_store"."is_active" AND "lego_store"."country_code" = 'US' AND UPPER("lego_store"."store_url"::text) LIKE UPPER('%linksynergy.com%')) LIMIT 21
2 similar queries.
Duplicated 2 times.
10.18
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(456)
res['img_link'] = MerchantStore.get_lego_link_for_user(user, set)/home/nathan/rb/site/./lego/models/stores.py in get_lego_link_for_user(274)
store = get_or_none(Store.objects, store_url__icontains='linksynergy.com', country_code=store_country)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
SELECT "lego_storesetitem"."id", "lego_storesetitem"."store_id", "lego_storesetitem"."is_used", "lego_storesetitem"."cost", "lego_storesetitem"."cost_usd", "lego_storesetitem"."sale_cost", "lego_storesetitem"."sku", "lego_storesetitem"."item_url", "lego_storesetitem"."quantity", "lego_storesetitem"."timestamp", "lego_storesetitem"."set_id", "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" = 17) ORDER BY "lego_storesetitem"."id" ASC LIMIT 1SELECT ••• FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" = 17) ORDER BY "lego_storesetitem"."id" ASCLIMIT 1
2 similar queries.
Duplicated 2 times.
0.16
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(456)
res['img_link'] = MerchantStore.get_lego_link_for_user(user, set)/home/nathan/rb/site/./lego/models/stores.py in get_lego_link_for_user(278)
item = StoreSetItem.objects.select_related('store').filter(store=store, set_id=set.id, is_used=False).first()
SELECT "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_store" WHERE ("lego_store"."is_active" AND "lego_store"."country_code" = 'US' AND UPPER("lego_store"."store_url"::text) LIKE UPPER('%linksynergy.com%')) LIMIT 21SELECT ••• FROM "lego_store" WHERE ("lego_store"."is_active" AND "lego_store"."country_code" = 'US' AND UPPER("lego_store"."store_url"::text) LIKE UPPER('%linksynergy.com%')) LIMIT 21
2 similar queries.
Duplicated 2 times.
8.82
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(456)
res['img_link'] = MerchantStore.get_lego_link_for_user(user, set)/home/nathan/rb/site/./lego/models/stores.py in get_lego_link_for_user(274)
store = get_or_none(Store.objects, store_url__icontains='linksynergy.com', country_code=store_country)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
SELECT "lego_storesetitem"."id", "lego_storesetitem"."store_id", "lego_storesetitem"."is_used", "lego_storesetitem"."cost", "lego_storesetitem"."cost_usd", "lego_storesetitem"."sale_cost", "lego_storesetitem"."sku", "lego_storesetitem"."item_url", "lego_storesetitem"."quantity", "lego_storesetitem"."timestamp", "lego_storesetitem"."set_id", "lego_store"."id", "lego_store"."name", "lego_store"."is_active", "lego_store"."store_url", "lego_store"."add_item_url", "lego_store"."feed_url", "lego_store"."tag_line", "lego_store"."currency_code", "lego_store"."country_code", "lego_store"."bricklink_sellername", "lego_store"."ships_to" FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" = 17) ORDER BY "lego_storesetitem"."id" ASC LIMIT 1SELECT ••• FROM "lego_storesetitem" INNER JOIN "lego_store" ON ("lego_storesetitem"."store_id" = "lego_store"."id") WHERE (NOT "lego_storesetitem"."is_used" AND "lego_storesetitem"."set_id" = 139018 AND "lego_storesetitem"."store_id" = 17) ORDER BY "lego_storesetitem"."id" ASCLIMIT 1
2 similar queries.
Duplicated 2 times.
0.15
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(421)
context['merchant_store_costs'] = get_merchant_stores_cost(request.user, set)/home/nathan/rb/site/./lego/buy/sets.py in get_merchant_stores_cost(456)
res['img_link'] = MerchantStore.get_lego_link_for_user(user, set)/home/nathan/rb/site/./lego/models/stores.py in get_lego_link_for_user(278)
item = StoreSetItem.objects.select_related('store').filter(store=store, set_id=set.id, is_used=False).first()
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_inventory"."id" AS "inventory2", "lego_invset"."quantity" AS "quantity", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T6."id", T6."parent_id", T6."name", T6."slug", T6."set_count", T6."t1_id", T6."t1_name", T6."t2_name", T6."t3_name", T6."lego_blurb", T6."banner_img", T6."descr", T7."id", T7."parent_id", T7."name", T7."slug", T7."set_count", T7."t1_id", T7."t1_name", T7."t2_name", T7."t3_name", T7."lego_blurb", T7."banner_img", T7."descr", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_baseset" INNER JOIN "lego_inventory" ON ("lego_baseset"."id" = "lego_inventory"."set_id") INNER JOIN "lego_invset" ON ("lego_inventory"."id" = "lego_invset"."inventory_id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T6 ON ("lego_theme"."parent_id" = T6."id") LEFT OUTER JOIN "lego_theme" T7 ON (T6."parent_id" = T7."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_inventory"."is_active" AND "lego_invset"."inv_set_id" = 139018 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASCSELECT ••• FROM "lego_baseset" INNER JOIN "lego_inventory" ON ("lego_baseset"."id" = "lego_inventory"."set_id") INNER JOIN "lego_invset" ON ("lego_inventory"."id" = "lego_invset"."inventory_id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T6 ON ("lego_theme"."parent_id" = T6."id") LEFT OUTER JOIN "lego_theme" T7 ON (T6."parent_id" = T7."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_inventory"."is_active" AND "lego_invset"."inv_set_id" = 139018 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC
0.79
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(430)
for s in context['parent_sets']:
SELECT "lego_setmap"."id", "lego_setmap"."set_id", "lego_setmap"."ext_system", "lego_setmap"."ext_id" FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 139018SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 139018
0.21
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(445)
context['mappings'] = set.get_ext_mappings()/home/nathan/rb/site/./lego/models/sets.py in get_ext_mappings(1988)
for set_map in SetMap.objects.filter(set=self):
SELECT "lego_setphoto"."id", "lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 104503 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 104503 LIMIT 21
2 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/models/sets.py in img_dir(751)
file_dir = self.primary_photo.get_img_dir()
34
{% block meta_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_description %}
35
{% block meta_og_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_og_description %}
36
{% block meta_image %}{% spaceless %}
37
{% if set.img_dir %}
38
{% thumbs set.img_dir settings.THUMBS_OPTIONS_SET_MAIN as img %}{{ img.url }}
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 139018 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 139018 LIMIT 21
3 similar queries.
Duplicated 2 times.
0.13
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/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')
34
{% block meta_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_description %}
35
{% block meta_og_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_og_description %}
36
{% block meta_image %}{% spaceless %}
37
{% if set.img_dir %}
38
{% thumbs set.img_dir settings.THUMBS_OPTIONS_SET_MAIN as img %}{{ img.url }}
SELECT COUNT(*) AS "__count" FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 139018)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 139018)
0.24
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)
73
74
{% else %}
75
76
{% if set.photos.count > 1 %}
77
{# Setup slider to move through multiple Set images #}
78
{# flexsliderX to avoid initialisation until we have loaded all images #}
79
<div class="row">
80
<div class="col-xs-12"> {# here so the nav arrows are positioned properly #}
SELECT "lego_setphoto"."id", "lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 139018) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASCSELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 139018) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASC
2 similar queries.
Duplicated 2 times.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)
SELECT "lego_setphototype"."id", "lego_setphototype"."name" FROM "lego_setphototype" WHERE "lego_setphototype"."id" = 3 LIMIT 21SELECT ••• FROM "lego_setphototype" WHERE "lego_setphototype"."id" = 3 LIMIT 21
0.16
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)
SELECT "lego_setphoto"."id", "lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 139018) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASCSELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 139018) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASC
2 similar queries.
Duplicated 2 times.
0.18
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)
115
</ul>
116
</div>
117
{# pre-create controls div so we can size column height without CLS impact and prevents flicker #}
118
<div class="flexslider-controls-container-sets {% if set.photos.all|length > 6 %}flexslider-controls-container-sets-2rows{% endif %}">
select prev_num, next_num from (
select set_num,
lag(set_num) over (order by theme_id, set_num) as prev_num,
lead(set_num) over (order by theme_id, set_num) as next_num
from (
select set_num, theme_id, nullif(regexp_replace(substring(set_num, 0, position('-' in set_num)), '[^0-9]', '', 'g'), '')::bigint as int_num
from lego_baseset
where set_type in ('Set')
) x
) y
where set_num = '41964-1'select prev_num, next_num from (
select set_num,
lag(set_num) over (order by theme_id, set_num) as prev_num,
lead(set_num) over (order by theme_id, set_num) as next_num
from (
select set_num, theme_id, nullif(regexp_replace(substring(set_num, 0, position('-' in set_num)), '[^0-9]', '', 'g'), '')::bigint as int_num
from lego_baseset
where set_type in ('Set')
) x
) y
where set_num = '41964-1'
76.76
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_next_prev_sets(601)
rows = run_sql(sql)/home/nathan/rb/site/./rb/utils.py in run_sql(664)
cursor.execute(sql, params)
12
<h3 class="text-center mb-0">
13
{{ set.set_num }}
14
</h3>
15
{% with set.get_next_prev_sets as next_prev_sets %}
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr", T4."id", T4."parent_id", T4."name", T4."slug", T4."set_count", T4."t1_id", T4."t1_name", T4."t2_name", T4."t3_name", T4."lego_blurb", T4."banner_img", T4."descr", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_num" = '41963-1') LIMIT 21SELECT ••• FROM "lego_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_num" = '41963-1') LIMIT 21
2 similar queries.
0.79
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_next_prev_sets(603)
return get_or_none(BaseSet.objects, set_num=prev_num), get_or_none(BaseSet.objects, set_num=next_num)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
12
<h3 class="text-center mb-0">
13
{{ set.set_num }}
14
</h3>
15
{% with set.get_next_prev_sets as next_prev_sets %}
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr", T4."id", T4."parent_id", T4."name", T4."slug", T4."set_count", T4."t1_id", T4."t1_name", T4."t2_name", T4."t3_name", T4."lego_blurb", T4."banner_img", T4."descr", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_num" = '5006272-1') LIMIT 21SELECT ••• FROM "lego_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_num" = '5006272-1') LIMIT 21
2 similar queries.
0.40
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_next_prev_sets(603)
return get_or_none(BaseSet.objects, set_num=prev_num), get_or_none(BaseSet.objects, set_num=next_num)/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
return manager.get(**kwargs)
12
<h3 class="text-center mb-0">
13
{{ set.set_num }}
14
</h3>
15
{% with set.get_next_prev_sets as next_prev_sets %}
SELECT COUNT(*) AS "__count" FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 139018)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 139018)
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/models/sets.py in get_num_inventories(981)
return Inventory.objects.filter(set=self).count()
SELECT "blog_article"."id", "blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."review_for_set_num"::text LIKE '%41964-1%') ORDER BY "blog_article"."published_date" ASCSELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."review_for_set_num"::text LIKE '%41964-1%') ORDER BY "blog_article"."published_date" ASC
0.28
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/models/sets.py in get_set_review(1393)
for review in reviews:
119
{% endif %}
120
</table>
121
122
{% with set.get_set_review as review %}
123
{% if review %}
124
<p>See our review:</p>
125
{% include 'blog/includes/render_posts_preview.html' with article=review %}
SELECT (width*height) AS "area", "ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.107536+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.107610+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.107521+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.107736+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.107536+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.107610+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.107521+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.107736+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries.
1.81
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
192
{% endcache %}
193
194
{# cant include banner in cache as it's region specific #}
SELECT (width*height) AS "area", "ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.107536+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.107610+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.107521+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.107736+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.107536+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.107610+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.107521+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.107736+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
3 similar queries.
1.19
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
192
{% endcache %}
193
194
{# cant include banner in cache as it's region specific #}
SELECT "django_content_type"."id", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'set') LIMIT 21SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'set') LIMIT 21
0.12
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(78)
content_type = ContentType.objects.get(app_label=page_content_type.split('.')[0], model=page_content_type.split('.')[1])
4
{% load rb_comments_filters %}
5
6
<div id="comments-{{ page.id }}">
7
{% get_page_locked_status content_type page.id as is_page_locked %}
8
9
{% comment %}
10
Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.
11
Using fluent-comments to hide unused fields and do ajax add/reply comment.
SELECT 1 AS "a" FROM "rb_comments_pagelocked" WHERE ("rb_comments_pagelocked"."content_type_id" = 63 AND "rb_comments_pagelocked"."object_id" = 139018) LIMIT 1SELECT ••• FROM "rb_comments_pagelocked" WHERE ("rb_comments_pagelocked"."content_type_id" = 63 AND "rb_comments_pagelocked"."object_id" = 139018) LIMIT 1
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(79)
is_locked = PageLocked.objects.filter(content_type=content_type, object_id=page_id).exists()
4
{% load rb_comments_filters %}
5
6
<div id="comments-{{ page.id }}">
7
{% get_page_locked_status content_type page.id as is_page_locked %}
8
9
{% comment %}
10
Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.
11
Using fluent-comments to hide unused fields and do ajax add/reply comment.
SELECT COUNT(*) AS "__count" FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 63 AND "django_comments"."object_pk" = '139018' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" ANDNOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 63 AND "django_comments"."object_pk" = '139018' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" ANDNOT "django_comments"."is_removed")
0.15
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
context[self.as_varname] = self.get_context_value_from_queryset(context, qs)/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
return qs.count()
15
{% if not comment_list %}
16
{# Get comments for a page #}
17
{% get_rb_comment_list for page as comment_list %}
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_moc"."baseset_ptr_id", "lego_moc"."designer_id", "lego_moc"."detail_url", "lego_moc"."gallery_url", "lego_moc"."bi_url", "lego_moc"."cad_url", "lego_moc"."video", "lego_moc"."bi_type", "lego_moc"."is_for_sale", "lego_moc"."is_hosted", "lego_moc"."cost", "lego_moc"."currency_id", "lego_moc"."parent_set_1_id", "lego_moc"."parent_set_2_id", "lego_moc"."parent_set_3_id", "lego_moc"."parent_set_4_id", "lego_moc"."parent_set_5_id", "lego_moc"."parent_inv_1_id", "lego_moc"."parent_inv_2_id", "lego_moc"."parent_inv_3_id", "lego_moc"."parent_inv_4_id", "lego_moc"."parent_inv_5_id", "lego_moc"."parent_type", "lego_moc"."is_allowed_premium", "lego_moc"."is_locked", "lego_moc"."last_social_post", "lego_moc"."is_review_requested", EXISTS( SELECT 1 AS "a" FROM "lego_mocswitherrors" U0 WHERE U0."moc_id" = ("lego_moc"."baseset_ptr_id") LIMIT 1 ) AS "errors_exists", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T6."id", T6."parent_id", T6."name", T6."slug", T6."set_count", T6."t1_id", T6."t1_name", T6."t2_name", T6."t3_name", T6."lego_blurb", T6."banner_img", T6."descr", T7."id", T7."parent_id", T7."name", T7."slug", T7."set_count", T7."t1_id", T7."t1_name", T7."t2_name", T7."t3_name", T7."lego_blurb", T7."banner_img", T7."descr", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent", "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly", T3."id", T3."set_num", T3."name", T3."year", T3."theme_id", T3."set_type", T3."num_parts", T3."default_inventory_id", T3."is_active", T3."is_accessory", T3."added_dt", T3."added_by_id", T3."last_modified_dt", T3."last_modified_by_id", T3."last_checked_for_bi", T3."descr", T3."primary_photo_id", T3."is_gear", T3."is_book", T3."search_vector", T3."mfhash_vector", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T6 ON ("lego_theme"."parent_id" = T6."id") LEFT OUTER JOIN "lego_theme" T7 ON (T6."parent_id" = T7."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" IN (139018, 146774) AND "lego_moc"."parent_set_2_id" ISNULLAND "lego_moc"."parent_type" = 'A' ANDNOT (EXISTS(SELECT 1 AS "a" FROM "lego_mocswitherrors" U0 WHERE U0."moc_id" = ("lego_moc"."baseset_ptr_id") LIMIT 1))) ORDER BY "lego_setstatstotal"."likes" DESCSELECT ••• FROM "lego_mocswitherrors" U0 WHERE U0."moc_id" = ("lego_moc"."baseset_ptr_id") LIMIT 1) AS "errors_exists", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T6."id", T6."parent_id", T6."name", T6."slug", T6."set_count", T6."t1_id", T6."t1_name", T6."t2_name", T6."t3_name", T6."lego_blurb", T6."banner_img", T6."descr", T7."id", T7."parent_id", T7."name", T7."slug", T7."set_count", T7."t1_id", T7."t1_name", T7."t2_name", T7."t3_name", T7."lego_blurb", T7."banner_img", T7."descr", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent", "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly", T3."id", T3."set_num", T3."name", T3."year", T3."theme_id", T3."set_type", T3."num_parts", T3."default_inventory_id", T3."is_active", T3."is_accessory", T3."added_dt", T3."added_by_id", T3."last_modified_dt", T3."last_modified_by_id", T3."last_checked_for_bi", T3."descr", T3."primary_photo_id", T3."is_gear", T3."is_book", T3."search_vector", T3."mfhash_vector", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T6 ON ("lego_theme"."parent_id" = T6."id") LEFT OUTER JOIN "lego_theme" T7 ON (T6."parent_id" = T7."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_1_id" IN (139018, 146774) AND "lego_moc"."parent_set_2_id" ISNULLAND "lego_moc"."parent_type" = 'A' ANDNOT (EXISTS(SELECT ••• FROM "lego_mocswitherrors" U0 WHERE U0."moc_id" = ("lego_moc"."baseset_ptr_id") LIMIT 1))) ORDER BY "lego_setstatstotal"."likes" DESC
1.73
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_alternate_builds_tab_html(283)
return set.get_alternate_builds_tab_html(context['request'])[0]/home/nathan/rb/site/./lego/models/sets.py in get_alternate_builds_tab_html(1820)
if len(alt_build) > 0:
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_moc"."baseset_ptr_id", "lego_moc"."designer_id", "lego_moc"."detail_url", "lego_moc"."gallery_url", "lego_moc"."bi_url", "lego_moc"."cad_url", "lego_moc"."video", "lego_moc"."bi_type", "lego_moc"."is_for_sale", "lego_moc"."is_hosted", "lego_moc"."cost", "lego_moc"."currency_id", "lego_moc"."parent_set_1_id", "lego_moc"."parent_set_2_id", "lego_moc"."parent_set_3_id", "lego_moc"."parent_set_4_id", "lego_moc"."parent_set_5_id", "lego_moc"."parent_inv_1_id", "lego_moc"."parent_inv_2_id", "lego_moc"."parent_inv_3_id", "lego_moc"."parent_inv_4_id", "lego_moc"."parent_inv_5_id", "lego_moc"."parent_type", "lego_moc"."is_allowed_premium", "lego_moc"."is_locked", "lego_moc"."last_social_post", "lego_moc"."is_review_requested", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T9."id", T9."parent_id", T9."name", T9."slug", T9."set_count", T9."t1_id", T9."t1_name", T9."t2_name", T9."t3_name", T9."lego_blurb", T9."banner_img", T9."descr", T10."id", T10."parent_id", T10."name", T10."slug", T10."set_count", T10."t1_id", T10."t1_name", T10."t2_name", T10."t3_name", T10."lego_blurb", T10."banner_img", T10."descr", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent", "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly", T4."id", T4."set_num", T4."name", T4."year", T4."theme_id", T4."set_type", T4."num_parts", T4."default_inventory_id", T4."is_active", T4."is_accessory", T4."added_dt", T4."added_by_id", T4."last_modified_dt", T4."last_modified_by_id", T4."last_checked_for_bi", T4."descr", T4."primary_photo_id", T4."is_gear", T4."is_book", T4."search_vector", T4."mfhash_vector", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") LEFT OUTER JOIN "lego_baseset" T4 ON ("lego_moc"."parent_set_1_id" = T4."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T9 ON ("lego_theme"."parent_id" = T9."id") LEFT OUTER JOIN "lego_theme" T10 ON (T9."parent_id" = T10."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_2_id" ISNOT NULLAND "lego_moc"."parent_type" = 'A' AND ("lego_moc"."parent_set_1_id" = 139018 OR "lego_moc"."parent_set_2_id" = 139018 OR "lego_moc"."parent_set_3_id" = 139018 OR "lego_moc"."parent_set_4_id" = 139018 OR "lego_moc"."parent_set_5_id" = 139018)) ORDER BY "lego_setstatstotal"."likes" DESCSELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") LEFT OUTER JOIN "lego_baseset" T4 ON ("lego_moc"."parent_set_1_id" = T4."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T9 ON ("lego_theme"."parent_id" = T9."id") LEFT OUTER JOIN "lego_theme" T10 ON (T9."parent_id" = T10."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_set_2_id" ISNOT NULLAND "lego_moc"."parent_type" = 'A' AND ("lego_moc"."parent_set_1_id" = 139018 OR "lego_moc"."parent_set_2_id" = 139018 OR "lego_moc"."parent_set_3_id" = 139018 OR "lego_moc"."parent_set_4_id" = 139018 OR "lego_moc"."parent_set_5_id" = 139018)) ORDER BY "lego_setstatstotal"."likes" DESC
1.32
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_alternate_builds_tab_html(283)
return set.get_alternate_builds_tab_html(context['request'])[0]/home/nathan/rb/site/./lego/models/sets.py in get_alternate_builds_tab_html(1822)
if len(partial_alt_build) > 0:
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_moc"."baseset_ptr_id", "lego_moc"."designer_id", "lego_moc"."detail_url", "lego_moc"."gallery_url", "lego_moc"."bi_url", "lego_moc"."cad_url", "lego_moc"."video", "lego_moc"."bi_type", "lego_moc"."is_for_sale", "lego_moc"."is_hosted", "lego_moc"."cost", "lego_moc"."currency_id", "lego_moc"."parent_set_1_id", "lego_moc"."parent_set_2_id", "lego_moc"."parent_set_3_id", "lego_moc"."parent_set_4_id", "lego_moc"."parent_set_5_id", "lego_moc"."parent_inv_1_id", "lego_moc"."parent_inv_2_id", "lego_moc"."parent_inv_3_id", "lego_moc"."parent_inv_4_id", "lego_moc"."parent_inv_5_id", "lego_moc"."parent_type", "lego_moc"."is_allowed_premium", "lego_moc"."is_locked", "lego_moc"."last_social_post", "lego_moc"."is_review_requested", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T9."id", T9."parent_id", T9."name", T9."slug", T9."set_count", T9."t1_id", T9."t1_name", T9."t2_name", T9."t3_name", T9."lego_blurb", T9."banner_img", T9."descr", T10."id", T10."parent_id", T10."name", T10."slug", T10."set_count", T10."t1_id", T10."t1_name", T10."t2_name", T10."t3_name", T10."lego_blurb", T10."banner_img", T10."descr", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent", "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly", T3."id", T3."set_num", T3."name", T3."year", T3."theme_id", T3."set_type", T3."num_parts", T3."default_inventory_id", T3."is_active", T3."is_accessory", T3."added_dt", T3."added_by_id", T3."last_modified_dt", T3."last_modified_by_id", T3."last_checked_for_bi", T3."descr", T3."primary_photo_id", T3."is_gear", T3."is_book", T3."search_vector", T3."mfhash_vector", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") LEFT OUTER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T9 ON ("lego_theme"."parent_id" = T9."id") LEFT OUTER JOIN "lego_theme" T10 ON (T9."parent_id" = T10."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_type" = 'M' AND ("lego_moc"."parent_set_1_id" = 139018 OR "lego_moc"."parent_set_2_id" = 139018 OR "lego_moc"."parent_set_3_id" = 139018 OR "lego_moc"."parent_set_4_id" = 139018 OR "lego_moc"."parent_set_5_id" = 139018)) ORDER BY "lego_setstatstotal"."likes" DESCSELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") LEFT OUTER JOIN "lego_baseset" T3 ON ("lego_moc"."parent_set_1_id" = T3."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T9 ON ("lego_theme"."parent_id" = T9."id") LEFT OUTER JOIN "lego_theme" T10 ON (T9."parent_id" = T10."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."parent_type" = 'M' AND ("lego_moc"."parent_set_1_id" = 139018 OR "lego_moc"."parent_set_2_id" = 139018 OR "lego_moc"."parent_set_3_id" = 139018 OR "lego_moc"."parent_set_4_id" = 139018 OR "lego_moc"."parent_set_5_id" = 139018)) ORDER BY "lego_setstatstotal"."likes" DESC
1.46
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_alternate_builds_tab_html(283)
return set.get_alternate_builds_tab_html(context['request'])[0]/home/nathan/rb/site/./lego/models/sets.py in get_alternate_builds_tab_html(1824)
if len(moc_mods) > 0:
SELECT "lego_inventory"."id", "lego_inventory"."set_id", "lego_inventory"."version", "lego_inventory"."name", "lego_inventory"."is_active", "lego_inventory"."num_parts", "lego_inventory"."num_versions" FROM "lego_inventory" WHERE "lego_inventory"."id" = 149924 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 149924 LIMIT 21
2 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_alternate_builds_tab_html(283)
return set.get_alternate_builds_tab_html(context['request'])[0]/home/nathan/rb/site/./lego/models/sets.py in get_alternate_builds_tab_html(1850)
html = render_to_string('sets/render_alt_build_list.html', context, request=request)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(971)
if self.default_inventory is not None:
14
{% include 'sets/render_set.html' with set=set title=set.name hide_details=True tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
15
</div>
16
{% else %}
17
<div class="col-xs-6 col-sm-4 col-md-3 col-condensed">{% render_set set tn_options=settings.THUMBS_OPTIONS_SET_TILE %}</div>
SELECT "lego_setphoto"."id", "lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 109862 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 109862 LIMIT 21
2 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_alternate_builds_tab_html(283)
return set.get_alternate_builds_tab_html(context['request'])[0]/home/nathan/rb/site/./lego/models/sets.py in get_alternate_builds_tab_html(1850)
html = render_to_string('sets/render_alt_build_list.html', context, request=request)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in img_dir(751)
file_dir = self.primary_photo.get_img_dir()
42
{# Image #}
43
<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>
44
<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">
45
{% if not set.img_dir and set.is_figure %}
46
{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}
47
{% else %}
48
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}
SELECT "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 146774 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 146774 LIMIT 21
3 similar queries.
0.12
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_alternate_builds_tab_html(283)
return set.get_alternate_builds_tab_html(context['request'])[0]/home/nathan/rb/site/./lego/models/sets.py in get_alternate_builds_tab_html(1850)
html = render_to_string('sets/render_alt_build_list.html', context, request=request)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.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')
42
{# Image #}
43
<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>
44
<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">
45
{% if not set.img_dir and set.is_figure %}
46
{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}
47
{% else %}
48
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}
SELECT "lego_setinstructions"."id", "lego_setinstructions"."set_id", "lego_setinstructions"."timestamp", "lego_setinstructions"."descr", "lego_setinstructions"."file_size", "lego_setinstructions"."preview_img", "lego_setinstructions"."is_alt", "lego_setinstructions"."lego_url", "lego_setinstructions"."file_id" FROM "lego_setinstructions" WHERE "lego_setinstructions"."set_id" = 139018 ORDER BY "lego_setinstructions"."descr" ASCSELECT ••• FROM "lego_setinstructions" WHERE "lego_setinstructions"."set_id" = 139018 ORDER BY "lego_setinstructions"."descr" ASC
0.22
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)
7
<p>The known <a href="{% url 'set_instructions' set.set_num %}">building instruction files for {{ set }}</a> are listed below.</p>
SELECT "lego_files_s3file"."id", "lego_files_s3file"."file_size", "lego_files_s3file"."last_modified", "lego_files_s3file"."aws_mi_file", "lego_files_s3file"."linode_si_file", "lego_files_s3file"."linode_mi_file", "lego_files_s3file"."linode_media_file" FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 185019 LIMIT 21SELECT ••• FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 185019 LIMIT 21
2 similar queries.
0.20
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/models/sets.py in get_download_url(3084)
if self.file:
SELECT "lego_files_s3file"."id", "lego_files_s3file"."file_size", "lego_files_s3file"."last_modified", "lego_files_s3file"."aws_mi_file", "lego_files_s3file"."linode_si_file", "lego_files_s3file"."linode_mi_file", "lego_files_s3file"."linode_media_file" FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 185021 LIMIT 21SELECT ••• FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 185021 LIMIT 21
2 similar queries.
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/models/sets.py in get_download_url(3084)
if self.file:
SELECT (width*height) AS "area", "ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.230007+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.230086+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.229990+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.230219+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.230007+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.230086+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.229990+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.230219+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries.
1.93
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
192
{% endcache %}
193
194
{# cant include banner in cache as it's region specific #}
SELECT (width*height) AS "area", "ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.230007+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.230086+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.229990+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.230219+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.230007+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.230086+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.229990+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.230219+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
3 similar queries.
1.22
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
192
{% endcache %}
193
194
{# cant include banner in cache as it's region specific #}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
return render_to_string('sets/render_set_related.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
elif hasattr(self, 'moc'):
2
3
<div class="mb-20">
4
<div class="text-center">
5
<a href="{{ set.get_absolute_url }}">
6
{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}
SELECT (width*height) AS "area", "ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.259602+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.259670+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.259589+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.259789+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.259602+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.259670+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.259589+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.259789+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries.
1.30
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
SELECT (width*height) AS "area", "ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.259602+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.259670+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.259589+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.259789+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T15:10:21.259602+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T15:10:21.259670+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T15:10:21.259589+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-01-22T15:10:21.259789+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
3 similar queries.
1.18
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/sets.py in find_sets(114)
return set_details(request, slug1)/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
return fn(*args, **kw)/home/nathan/rb/site/./lego/views/sets.py in set_details(449)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
US
