This figure appears in the following Sets:
Tournament of Elements
Tournament of Elements
Tournament of Elements
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 | 401.827 msec |
| System CPU time | 2.041 msec |
| Total CPU time | 403.868 msec |
| Elapsed time | 526.282 msec |
| Context switches | 132 voluntary, 1 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-010980' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-010980' LIMIT 21 |
8.85 | ||||||||||||||||||||
|
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-010980' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-010980' 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(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" = 85672 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 85672 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-010980' ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'fig-010980' ORDER BY "lego_changelog"."timestamp" DESC |
0.85 | ||||||||||||||||||||
|
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" = 83924 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 83924 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" = 2197, "builds" = 3, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 83924UPDATE "lego_setstatstotal" SET "hits" = 2197, "builds" = 3, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 83924 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.stats.inc_hits() /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" = 83924) LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-31'::date AND "lego_setstatshistory"."set_id" = 83924) 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_x62"SAVEPOINT "s140577029269312_x62"
|
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 (83924, '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 (83924, '2026-01-31'::date, 0, 0, 0, 0, 0, 0) RETURNING "lego_setstatshistory"."id" |
0.28 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.stats.inc_hits() /home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638) SetStatsHistory.inc_hits(self.set) /home/nathan/rb/site/./lego/models/sets.py in inc_hits(2587) self, created = cls.objects.get_or_create(set=set, day=timezone.now()) |
|||||||||||||||||||||
|
RELEASE SAVEPOINT "s140577029269312_x62"RELEASE SAVEPOINT "s140577029269312_x62"
|
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" = 83924, "day" = '2026-01-31'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140927742UPDATE "lego_setstatshistory" SET "set_id" = 83924, "day" = '2026-01-31'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140927742 |
0.13 | ||||||||||||||||||||
|
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" = 83924 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" = 83924 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC |
0.83 | ||||||||||||||||||||
|
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" = 87174) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 87174) 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" = 81569) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 81569) LIMIT 21 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(328) s.inventory = get_or_none(Inventory.objects, id=s.inventory2) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT "lego_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" = 176804) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 176804) 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" = 83924) 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" = 83924) GROUP BY "taggit_tag"."id" |
58.85 | ||||||||||||||||||||
|
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", 'Bolobo')*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) % 'Bolobo 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", 'Bolobo')*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) % 'Bolobo 435') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10 |
32.83 | ||||||||||||||||||||
|
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" = 83924)SELECT ••• FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 83924) |
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(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" = 83924SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 83924 |
0.34 | ||||||||||||||||||||
|
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" = 83924 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 83924 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(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_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" = 83924 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 83924 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(2989) 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" = 105136 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 105136 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" = 83924 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 83924 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(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.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/./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" = 83924) 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" = 83924) AND "lego_baseset"."set_type" = 'Set') |
0.67 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/models/figures.py in get_theme(106) if parents:
/home/nathan/rb/site/lego/templates/sets/set_details.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr", T4."id", T4."parent_id", T4."name", T4."slug", T4."set_count", T4."t1_id", T4."t1_name", T4."t2_name", T4."t3_name", T4."lego_blurb", T4."banner_img", T4."descr", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."id" IN (SELECT U2."set_id" FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 83924) 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" = 83924) AND "lego_baseset"."set_type" = 'Set') |
0.58 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/models/figures.py in get_theme(106) if parents:
/home/nathan/rb/site/lego/templates/sets/set_details.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 83924)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 83924) |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
4 similar queries.
Duplicated 3 times.
"lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 77923 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 77923 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.
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" = 80229 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 80229 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(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.
Duplicated 3 times.
"lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 77923 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 77923 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(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.
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" = 80229 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 80229 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(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.
Duplicated 3 times.
"lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 77923 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 77923 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(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.
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" = 80229 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 80229 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 COUNT(*) AS "__count"
FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 83924)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 83924) |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/models/sets.py in get_num_inventories(981) return Inventory.objects.filter(set=self).count()
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."review_for_set_num"::text LIKE '%fig-010980%') 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-010980%') ORDER BY "blog_article"."published_date" ASC |
0.27 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/models/sets.py in get_set_review(1393) for review in reviews:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.660966+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.661038+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.660952+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.661162+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.660966+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.661038+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.660952+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.661162+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.95 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.660966+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.661038+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.660952+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.661162+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.660966+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.661038+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.660952+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.661162+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.55 | ||||||||||||||||||||
|
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" = 83924 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 83924 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/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
2 similar queries.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 17788 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 17788 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_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" = 83924 OR "lego_setrelationship"."set_child_id" = 83924))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" = 83924 OR "lego_setrelationship"."set_child_id" = 83924)) |
0.36 | ||||||||||||||||||||
|
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-31T15:50:14.677147+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.677211+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.677137+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.677328+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.677147+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.677211+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.677137+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.677328+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.59 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.677147+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.677211+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.677137+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.677328+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.677147+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.677211+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.677137+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.677328+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.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/./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.30 | ||||||||||||||||||||
|
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.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/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" = 40676 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 40676 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" = 3084 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 3084 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/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" = 48204 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 48204 LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/sets.py in get_moc(830) elif hasattr(self, 'moc'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 111898 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 111898 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/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" = 131469 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 131469 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.
Duplicated 2 times.
"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" = 282050 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 282050 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" = 136081 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 136081 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" = 635748 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 635748 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" = 226194 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 226194 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/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" = 583074 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 583074 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(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" = 156282 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 156282 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/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" = 775578 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 775578 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" = 77466 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 77466 LIMIT 21 |
0.50 | ||||||||||||||||||||
|
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" = 354198 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 354198 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(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" = 39260 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 39260 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" = 291513 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 291513 LIMIT 21 |
0.24 | ||||||||||||||||||||
|
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" = 129470 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 129470 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.
Duplicated 2 times.
"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" = 282050 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 282050 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(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(766) url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.707676+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.707746+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.707664+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.707863+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.707676+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.707746+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.707664+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.707863+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.68 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_bottom.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.707676+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.707746+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.707664+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.707863+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T15:50:14.707676+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T15:50:14.707746+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-31T15:50:14.707664+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T15:50:14.707863+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(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.