This figure appears in the following Sets:
Lloyd's Mech Battle EVO
Lloyd vs. Bone Warrior
Zane's Ice Dragon Creature
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 | 410.433 msec |
| System CPU time | 1.682 msec |
| Total CPU time | 412.115 msec |
| Elapsed time | 542.491 msec |
| Context switches | 109 voluntary, 3 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-013417' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-013417' LIMIT 21 |
8.83 | ||||||||||||||||||||
|
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-013417' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-013417' 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(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" = 160789 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 160789 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-013417' ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'fig-013417' ORDER BY "lego_changelog"."timestamp" DESC |
0.86 | ||||||||||||||||||||
|
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" = 157460 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 157460 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
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" = 2083, "builds" = 4, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 157460UPDATE "lego_setstatstotal" SET "hits" = 2083, "builds" = 4, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 157460 |
0.11 | ||||||||||||||||||||
|
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" = 157460) LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-31'::date AND "lego_setstatshistory"."set_id" = 157460) LIMIT 21 |
0.27 | ||||||||||||||||||||
|
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_x59"SAVEPOINT "s140577029269312_x59"
|
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 (157460, '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 (157460, '2026-01-31'::date, 0, 0, 0, 0, 0, 0) RETURNING "lego_setstatshistory"."id" |
0.18 | ||||||||||||||||||||
|
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_x59"RELEASE SAVEPOINT "s140577029269312_x59"
|
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" = 157460, "day" = '2026-01-31'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140927953UPDATE "lego_setstatshistory" SET "set_id" = 157460, "day" = '2026-01-31'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140927953 |
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(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" = 157460 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" = 157460 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC |
0.87 | ||||||||||||||||||||
|
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",
3 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" = 150331) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 150331) 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(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",
3 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" = 180541) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 180541) LIMIT 21 |
0.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(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",
3 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" = 150336) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 150336) LIMIT 21 |
0.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(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.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(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" = 157460) 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" = 157460) GROUP BY "taggit_tag"."id" |
57.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(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", 'Bone Warrior')*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) % 'Bone Warrior 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", 'Bone Warrior')*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) % 'Bone Warrior 435') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10 |
45.35 | ||||||||||||||||||||
|
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" = 157460)SELECT ••• FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 157460) |
0.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(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" = 157460SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 157460 |
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(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",
6 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" = 157460 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 157460 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(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",
6 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" = 157460 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 157460 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",
4 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" = 116747 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 116747 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",
6 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" = 157460 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 157460 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/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.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/./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" = 157460) 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" = 157460) AND "lego_baseset"."set_type" = 'Set') |
0.87 | ||||||||||||||||||||
|
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" = 157460) 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" = 157460) AND "lego_baseset"."set_type" = 'Set') |
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(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" = 157460)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 157460) |
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_set_main_top.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
4 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" = 130337 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 130337 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/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",
6 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" = 147178 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 147178 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/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",
4 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" = 135999 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 135999 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/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",
6 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" = 176908 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 176908 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",
4 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" = 130316 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 130316 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(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",
6 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" = 147183 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 147183 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" = 157460)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 157460) |
0.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/./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-013417%') 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-013417%') ORDER BY "blog_article"."published_date" ASC |
0.33 | ||||||||||||||||||||
|
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-31T18:31:25.893354+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.893436+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.893341+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.893558+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T18:31:25.893354+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.893436+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.893341+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.893558+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
2.01 | ||||||||||||||||||||
|
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-31T18:31:25.893354+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.893436+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.893341+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.893558+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-31T18:31:25.893354+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.893436+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.893341+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.893558+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
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(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" = 157460 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 157460 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/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" = 83025 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 83025 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" = 157460 OR "lego_setrelationship"."set_child_id" = 157460))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" = 157460 OR "lego_setrelationship"."set_child_id" = 157460)) |
0.32 | ||||||||||||||||||||
|
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 (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-31T18:31:25.908924+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.908994+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.908913+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.909110+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T18:31:25.908924+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.908994+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.908913+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.909110+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.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/./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-31T18:31:25.908924+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.908994+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.908913+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.909110+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-31T18:31:25.908924+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.908994+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.908913+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.909110+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.32 | ||||||||||||||||||||
|
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" = 142594 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 142594 LIMIT 21 |
0.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(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" = 102913 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 102913 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" = 60676 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 60676 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" = 314295 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 314295 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/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" = 189609 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 189609 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" = 948392 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 948392 LIMIT 21 |
0.26 | ||||||||||||||||||||
|
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" = 228458 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 228458 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" = 417190 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 417190 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" = 66060 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 66060 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" = 351255 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 351255 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(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" = 159123 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 159123 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" = 796841 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 796841 LIMIT 21 |
0.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/./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" = 170868 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 170868 LIMIT 21 |
0.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(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" = 327259 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 327259 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" = 137720 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 137720 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/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" = 608227 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 608227 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/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" = 215773 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 215773 LIMIT 21 |
0.17 | ||||||||||||||||||||
|
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" = 13302 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 13302 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/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" = 72095 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 72095 LIMIT 21 |
0.17 | ||||||||||||||||||||
|
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" = 339723 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 339723 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/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-31T18:31:25.935574+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.935633+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.935564+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.935752+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T18:31:25.935574+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.935633+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.935564+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.935752+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.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(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-31T18:31:25.935574+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.935633+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.935564+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.935752+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-31T18:31:25.935574+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T18:31:25.935633+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T18:31:25.935564+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T18:31:25.935752+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.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/./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.