This figure appears in the following Sets:
Arin's Battle Mech
Arin vs. Wolf Mask Guard
Same Character
These related Minifigs are the same character with different designs.
Waiting for Inventory to load
This figure appears in the following Sets:
These related Minifigs are the same character with different designs.
Waiting for Inventory to load
| Resource | Value |
|---|---|
| User CPU time | 492.343 msec |
| System CPU time | 4.883 msec |
| Total CPU time | 497.226 msec |
| Elapsed time | 643.538 msec |
| Context switches | 138 voluntary, 7 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"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_figure"."baseset_ptr_id" FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-014564' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-014564' LIMIT 21 |
8.79 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(100) figure = get_or_none(Figure.all_objects, set_num=slug1) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"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_figure"."baseset_ptr_id" FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-014564' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-014564' LIMIT 21 |
0.27 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(272) figure = Figure.all_objects.get(set_num=set_num) |
|||||||||||||||||||||
|
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" = 203892 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 203892 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(293) inventory = figure.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" = 'fig-014564' ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'fig-014564' ORDER BY "lego_changelog"."timestamp" DESC |
0.69 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(295) changes = figure.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" = 200147 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 200147 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.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) |
|||||||||||||||||||||
|
UPDATE "lego_setstatstotal"
SET "hits" = 721, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 200147UPDATE "lego_setstatstotal" SET "hits" = 721, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 200147 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.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-31'::date AND "lego_setstatshistory"."set_id" = 200147) LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-31'::date AND "lego_setstatshistory"."set_id" = 200147) LIMIT 21 |
0.28 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.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()) |
|||||||||||||||||||||
|
SAVEPOINT "s140577029269312_x57"SAVEPOINT "s140577029269312_x57"
|
0.03 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.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()) |
|||||||||||||||||||||
|
INSERT INTO "lego_setstatshistory" ("set_id", "day", "hits", "builds", "likes", "bi_downloads", "featured_hits", "user_hits")
VALUES (200147, '2026-01-31'::date, 0, 0, 0, 0, 0, 0) RETURNING "lego_setstatshistory"."id"INSERT INTO "lego_setstatshistory" ("set_id", "day", "hits", "builds", "likes", "bi_downloads", "featured_hits", "user_hits") VALUES (200147, '2026-01-31'::date, 0, 0, 0, 0, 0, 0) RETURNING "lego_setstatshistory"."id" |
0.25 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.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()) |
|||||||||||||||||||||
|
RELEASE SAVEPOINT "s140577029269312_x57"RELEASE SAVEPOINT "s140577029269312_x57"
|
0.03 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.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()) |
|||||||||||||||||||||
|
UPDATE "lego_setstatshistory"
SET "set_id" = 200147, "day" = '2026-01-31'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140927735UPDATE "lego_setstatshistory" SET "set_id" = 200147, "day" = '2026-01-31'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140927735 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.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_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" = 200147 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" = 200147 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC |
0.84 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(327) for s in context['parent_sets']: |
|||||||||||||||||||||
|
SELECT "lego_inventory"."id",
2 similar queries.
"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"."is_active" AND "lego_inventory"."id" = 199699) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 199699) LIMIT 21 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(328) s.inventory = get_or_none(Inventory.objects, id=s.inventory2) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT "lego_inventory"."id",
2 similar queries.
"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"."is_active" AND "lego_inventory"."id" = 233529) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 233529) LIMIT 21 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(328) s.inventory = get_or_none(Inventory.objects, id=s.inventory2) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
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" = 435 LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 435 LIMIT 21 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(331) context['similar_sets'] = figure.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, |
|||||||||||||||||||||
|
SELECT DISTINCT "taggit_tag"."id",
"taggit_tag"."name", "taggit_tag"."slug", COUNT("lego_figure"."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_figure" ON ("lego_baseset"."id" = "lego_figure"."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_figure" T8 ON (T7."id" = T8."baseset_ptr_id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'figure' AND T8."baseset_ptr_id" = 200147) 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_figure" ON ("lego_baseset"."id" = "lego_figure"."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_figure" T8 ON (T7."id" = T8."baseset_ptr_id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'figure' AND T8."baseset_ptr_id" = 200147) GROUP BY "taggit_tag"."id" |
57.58 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(331) context['similar_sets'] = figure.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", 'Arin Ninja Headwrap')*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 ),''), '970')*5 + similarity("lego_theme"."name", 'Ninjago')/3 + similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2 + similarity(substr("lego_baseset"."descr",0,100), '')) * 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) % 'Arin Ninja Headwrap 435') 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", 'Arin Ninja Headwrap')*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 ),''), '970')*5 + similarity("lego_theme"."name", 'Ninjago')/3 + similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2 + similarity(substr("lego_baseset"."descr",0,100), '')) * 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) % 'Arin Ninja Headwrap 435') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10 |
51.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(331) context['similar_sets'] = figure.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 COUNT(*) AS "__count"
FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 200147)SELECT ••• FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 200147) |
6.93 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(332) context['num_pending_photos'] = SetPhoto.all_objects.filter(is_active=False, set=figure).count() |
|||||||||||||||||||||
|
SELECT "lego_setmap"."id",
"lego_setmap"."set_id", "lego_setmap"."ext_system", "lego_setmap"."ext_id" FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 200147SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 200147 |
1.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(339) context['mappings'] = figure.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_baseset"."id",
5 similar queries.
Duplicated 3 times.
"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" = 200147 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 200147 LIMIT 21 |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(339) context['mappings'] = figure.get_ext_mappings() /home/nathan/rb/site/./lego/models/sets.py in get_ext_mappings(1992) mappings[set_map.get_ext_system_display()].append({'url': set_map.get_ext_exact_or_search_url(), /home/nathan/rb/site/./lego/models/sets.py in get_ext_exact_or_search_url(2989) if self.set.is_figure: |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
5 similar queries.
Duplicated 3 times.
"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" = 200147 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 200147 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(339) context['mappings'] = figure.get_ext_mappings() /home/nathan/rb/site/./lego/models/sets.py in get_ext_mappings(1992) mappings[set_map.get_ext_system_display()].append({'url': set_map.get_ext_exact_or_search_url(), /home/nathan/rb/site/./lego/models/sets.py in get_ext_exact_or_search_url(2979) if self.set.is_figure: |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
3 similar queries.
"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" = 135278 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 135278 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/templates/sets/set_details.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
5 similar queries.
Duplicated 3 times.
"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" = 200147 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 200147 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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')
/home/nathan/rb/site/lego/templates/sets/set_details.html |
|||||||||||||||||||||
|
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.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20) geo_data = user.geo.get_user_currency() /home/nathan/rb/site/./geo/geo.py in get_user_currency(252) country = Country.objects.get(iso=country_code)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"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"."id" IN (SELECT U2."set_id" FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 200147) AND "lego_baseset"."set_type" = 'Set')SELECT ••• 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"."id" IN (SELECT ••• FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 200147) AND "lego_baseset"."set_type" = 'Set') |
0.67 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/models/figures.py in get_theme(106) if parents:
/home/nathan/rb/site/lego/templates/sets/set_details.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"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"."id" IN (SELECT U2."set_id" FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 200147) AND "lego_baseset"."set_type" = 'Set')SELECT ••• 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"."id" IN (SELECT ••• FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 200147) AND "lego_baseset"."set_type" = 'Set') |
0.58 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/models/figures.py in get_theme(106) if parents:
/home/nathan/rb/site/lego/templates/sets/set_details.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 200147)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 200147) |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
2 similar queries.
Duplicated 2 times.
"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" = 200147) 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" = 200147) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASC |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html |
|||||||||||||||||||||
|
SELECT "lego_setphototype"."id",
"lego_setphototype"."name" FROM "lego_setphototype" WHERE "lego_setphototype"."id" = 11 LIMIT 21SELECT ••• FROM "lego_setphototype" WHERE "lego_setphototype"."id" = 11 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
2 similar queries.
Duplicated 2 times.
"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" = 200147) 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" = 200147) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASC |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
3 similar queries.
"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" = 133592 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 133592 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /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/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
5 similar queries.
"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" = 196122 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 196122 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /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')
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
3 similar queries.
"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" = 143289 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 143289 LIMIT 21 |
0.23 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /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/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
5 similar queries.
"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" = 229599 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 229599 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /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')
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 200147)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 200147) |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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()
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
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 '%fig-014564%') ORDER BY "blog_article"."published_date" ASCSELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."review_for_set_num"::text LIKE '%fig-014564%') ORDER BY "blog_article"."published_date" ASC |
0.31 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"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-31T15:46:32.059621+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.059701+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.059606+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.059840+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:46:32.059621+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.059701+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.059606+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.059840+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
2.61 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"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-31T15:46:32.059621+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.059701+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.059606+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.059840+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-31T15:46:32.059621+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.059701+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.059606+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.059840+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.37 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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]
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
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" = 200147 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 200147 LIMIT 21 |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
2 similar queries.
"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" FROM "auth_user" WHERE "auth_user"."id" = 17788 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 17788 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_change_summary.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
2 similar queries.
"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" FROM "auth_user" WHERE "auth_user"."id" = 1 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 1 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_change_summary.html |
|||||||||||||||||||||
|
SELECT "lego_setrelationship"."id",
"lego_setrelationship"."set_parent_id", "lego_setrelationship"."set_child_id", "lego_setrelationship"."rel_type", "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", 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" FROM "lego_setrelationship" INNER JOIN "lego_baseset" ON ("lego_setrelationship"."set_parent_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."rel_type" = 'C' AND ("lego_setrelationship"."set_parent_id" = 200147 OR "lego_setrelationship"."set_child_id" = 200147))SELECT ••• FROM "lego_setrelationship" INNER JOIN "lego_baseset" ON ("lego_setrelationship"."set_parent_id" = "lego_baseset"."id") INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."rel_type" = 'C' AND ("lego_setrelationship"."set_parent_id" = 200147 OR "lego_setrelationship"."set_child_id" = 200147)) |
0.43 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_related_sets_tab_html(278) return set.get_related_sets_tab_html(context['request'])[0] /home/nathan/rb/site/./lego/models/sets.py in get_related_sets_tab_html(1854) same_chars = self.get_related_sets(request.user, rel_type=SetRelationship.REL_TYPE_CHARACTER) /home/nathan/rb/site/./lego/models/sets.py in get_related_sets(1402) return SetRelationship.get_all_linked_sets(self, include_inactive=user.is_admin, rel_type=rel_type) /home/nathan/rb/site/./lego/models/sets.py in get_all_linked_sets(3224) if len(starting_rels) == 0:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_tabs.html |
|||||||||||||||||||||
|
SELECT "lego_setrelationship"."id",
"lego_setrelationship"."set_parent_id", "lego_setrelationship"."set_child_id", "lego_setrelationship"."rel_type", 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" FROM "lego_setrelationship" INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."set_parent_id" = 200147 AND "lego_setrelationship"."rel_type" = 'C')SELECT ••• FROM "lego_setrelationship" INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."set_parent_id" = 200147 AND "lego_setrelationship"."rel_type" = 'C') |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_related_sets_tab_html(278) return set.get_related_sets_tab_html(context['request'])[0] /home/nathan/rb/site/./lego/models/sets.py in get_related_sets_tab_html(1854) same_chars = self.get_related_sets(request.user, rel_type=SetRelationship.REL_TYPE_CHARACTER) /home/nathan/rb/site/./lego/models/sets.py in get_related_sets(1402) return SetRelationship.get_all_linked_sets(self, include_inactive=user.is_admin, rel_type=rel_type) /home/nathan/rb/site/./lego/models/sets.py in get_all_linked_sets(3235) sets = [r.set_child for r in rels]
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_tabs.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"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-31T15:46:32.081003+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.081068+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.080991+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.081187+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:46:32.081003+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.081068+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.080991+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.081187+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"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-31T15:46:32.081003+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.081068+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.080991+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.081187+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-31T15:46:32.081003+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.081068+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.080991+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.081187+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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]
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 186341 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 186341 LIMIT 21 |
0.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 765435 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 765435 LIMIT 21 |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 126633 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 126633 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 645673 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 645673 LIMIT 21 |
0.29 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 297389 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 297389 LIMIT 21 |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 913523 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 913523 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 96399 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 96399 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 257537 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 257537 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 296627 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 296627 LIMIT 21 |
0.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 378962 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 378962 LIMIT 21 |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 174934 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 174934 LIMIT 21 |
0.31 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 159879 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 159879 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 56535 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 56535 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 245170 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 245170 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 73371 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 73371 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 82556 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 82556 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 259677 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 259677 LIMIT 21 |
1.06 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1209276 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1209276 LIMIT 21 |
0.28 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
10 similar queries.
"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" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 195007 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 195007 LIMIT 21 |
0.31 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"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" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 474846 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 474846 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"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-31T15:46:32.110952+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.111012+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.110941+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.111130+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:46:32.110952+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.111012+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.110941+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.111130+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_bottom.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"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-31T15:46:32.110952+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.111012+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.110941+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.111130+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-31T15:46:32.110952+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:46:32.111012+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:46:32.110941+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:46:32.111130+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) 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]
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_bottom.html |
|||||||||||||||||||||
No messages logged.