This figure appears in the following Sets:
Heartlake City Candy Store
Heartlake City Preschool
Pet Adoption Day
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 | 451.208 msec |
| System CPU time | 8.943 msec |
| Total CPU time | 460.151 msec |
| Elapsed time | 618.804 msec |
| Context switches | 127 voluntary, 7 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_figure"."baseset_ptr_id" FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-014672' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-014672' LIMIT 21 |
0.43 | ||||||||||||||||||||
|
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-014672' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-014672' LIMIT 21 |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(272) figure = Figure.all_objects.get(set_num=set_num) |
|||||||||||||||||||||
|
SELECT "lego_inventory"."id",
"lego_inventory"."set_id", "lego_inventory"."version", "lego_inventory"."name", "lego_inventory"."is_active", "lego_inventory"."num_parts", "lego_inventory"."num_versions" FROM "lego_inventory" WHERE "lego_inventory"."id" = 204366 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 204366 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-014672' ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'fig-014672' ORDER BY "lego_changelog"."timestamp" DESC |
9.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(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" = 200622 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 200622 LIMIT 21 |
0.14 | ||||||||||||||||||||
|
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" = 566, "builds" = 1, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 200622UPDATE "lego_setstatstotal" SET "hits" = 566, "builds" = 1, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 200622 |
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-22'::date AND "lego_setstatshistory"."set_id" = 200622) LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-22'::date AND "lego_setstatshistory"."set_id" = 200622) LIMIT 21 |
0.22 | ||||||||||||||||||||
|
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 "s135227521288000_x34"SAVEPOINT "s135227521288000_x34"
|
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 (200622, '2026-01-22'::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 (200622, '2026-01-22'::date, 0, 0, 0, 0, 0, 0) RETURNING "lego_setstatshistory"."id" |
0.22 | ||||||||||||||||||||
|
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 "s135227521288000_x34"RELEASE SAVEPOINT "s135227521288000_x34"
|
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" = 200622, "day" = '2026-01-22'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140924463UPDATE "lego_setstatshistory" SET "set_id" = 200622, "day" = '2026-01-22'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140924463 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(298) figure.stats.inc_hits() /home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638) SetStatsHistory.inc_hits(self.set) /home/nathan/rb/site/./lego/models/sets.py in inc_hits(2589) self.save() |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_inventory"."id" AS "inventory2", "lego_invset"."quantity" AS "quantity", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T6."id", T6."parent_id", T6."name", T6."slug", T6."set_count", T6."t1_id", T6."t1_name", T6."t2_name", T6."t3_name", T6."lego_blurb", T6."banner_img", T6."descr", T7."id", T7."parent_id", T7."name", T7."slug", T7."set_count", T7."t1_id", T7."t1_name", T7."t2_name", T7."t3_name", T7."lego_blurb", T7."banner_img", T7."descr", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_baseset" INNER JOIN "lego_inventory" ON ("lego_baseset"."id" = "lego_inventory"."set_id") INNER JOIN "lego_invset" ON ("lego_inventory"."id" = "lego_invset"."inventory_id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T6 ON ("lego_theme"."parent_id" = T6."id") LEFT OUTER JOIN "lego_theme" T7 ON (T6."parent_id" = T7."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_inventory"."is_active" AND "lego_invset"."inv_set_id" = 200622 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" = 200622 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC |
0.99 | ||||||||||||||||||||
|
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" = 251402) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 251402) 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" = 222159) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 222159) LIMIT 21 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(328) s.inventory = get_or_none(Inventory.objects, id=s.inventory2) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT "lego_inventory"."id",
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" = 199740) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 199740) LIMIT 21 |
0.07 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(328) s.inventory = get_or_none(Inventory.objects, id=s.inventory2) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT "lego_theme"."id",
"lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr" FROM "lego_theme" WHERE "lego_theme"."id" = 494 LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 494 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",
2 similar queries.
Duplicated 2 times.
"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" = 200622) 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" = 200622) GROUP BY "taggit_tag"."id" |
1.94 | ||||||||||||||||||||
|
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", 'Alba Light Aqua Dress')*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 ),''), '17096')*5 + similarity("lego_theme"."name", 'Friends')/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) % 'Alba Light Aqua Dress 494') 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", 'Alba Light Aqua Dress')*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 ),''), '17096')*5 + similarity("lego_theme"."name", 'Friends')/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) % 'Alba Light Aqua Dress 494') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10 |
54.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(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 DISTINCT "taggit_tag"."id",
2 similar queries.
Duplicated 2 times.
"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" = 200622) 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" = 200622) GROUP BY "taggit_tag"."id" |
1.69 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(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.1; 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", 'Alba Light Aqua Dress')*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 ),''), '17096')*5 + similarity("lego_theme"."name", 'Friends')/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) % 'Alba Light Aqua Dress 494') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10 set pg_trgm.similarity_threshold = 0.1; 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", 'Alba Light Aqua Dress')*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 ),''), '17096')*5 + similarity("lego_theme"."name", 'Friends')/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) % 'Alba Light Aqua Dress 494') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10 |
76.31 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(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" = 200622)SELECT ••• FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 200622) |
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(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" = 200622SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 200622 |
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(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" = 200622 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 200622 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(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" = 200622 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 200622 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" = 141488 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 141488 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/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" = 200622 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 200622 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" = 200622) 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" = 200622) AND "lego_baseset"."set_type" = 'Set') |
0.87 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/models/figures.py in get_theme(106) if parents:
/home/nathan/rb/site/lego/templates/sets/set_details.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
2 similar queries.
Duplicated 2 times.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_theme"."id", "lego_theme"."parent_id", "lego_theme"."name", "lego_theme"."slug", "lego_theme"."set_count", "lego_theme"."t1_id", "lego_theme"."t1_name", "lego_theme"."t2_name", "lego_theme"."t3_name", "lego_theme"."lego_blurb", "lego_theme"."banner_img", "lego_theme"."descr", T3."id", T3."parent_id", T3."name", T3."slug", T3."set_count", T3."t1_id", T3."t1_name", T3."t2_name", T3."t3_name", T3."lego_blurb", T3."banner_img", T3."descr", T4."id", T4."parent_id", T4."name", T4."slug", T4."set_count", T4."t1_id", T4."t1_name", T4."t2_name", T4."t3_name", T4."lego_blurb", T4."banner_img", T4."descr", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_baseset" INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T3 ON ("lego_theme"."parent_id" = T3."id") LEFT OUTER JOIN "lego_theme" T4 ON (T3."parent_id" = T4."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."id" IN (SELECT U2."set_id" FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 200622) 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" = 200622) AND "lego_baseset"."set_type" = 'Set') |
0.56 | ||||||||||||||||||||
|
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" = 200622)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 200622) |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context)
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
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" = 149362 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 149362 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32) return render_to_string('sets/render_set.html', /home/nathan/rb/site/./lego/models/sets.py in img_dir(751) file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
6 similar queries.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 247402 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 247402 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32) return render_to_string('sets/render_set.html', /home/nathan/rb/site/./lego/models/sets.py in img_dir(751) file_dir = self.primary_photo.get_img_dir() /home/nathan/rb/site/./lego/models/sets.py in get_img_dir(3133) return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
4 similar queries.
"lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 140707 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 140707 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32) return render_to_string('sets/render_set.html', /home/nathan/rb/site/./lego/models/sets.py in img_dir(751) file_dir = self.primary_photo.get_img_dir()
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
6 similar queries.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 218238 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 218238 LIMIT 21 |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32) return render_to_string('sets/render_set.html', /home/nathan/rb/site/./lego/models/sets.py in img_dir(751) file_dir = self.primary_photo.get_img_dir() /home/nathan/rb/site/./lego/models/sets.py in get_img_dir(3133) return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
/home/nathan/rb/site/lego/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_setphoto"."id",
4 similar queries.
"lego_setphoto"."set_id", "lego_setphoto"."photo_type_id", "lego_setphoto"."submitted_by_id", "lego_setphoto"."timestamp", "lego_setphoto"."is_active", "lego_setphoto"."is_primary" FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 133175 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 133175 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/templates/sets/render_set.html |
|||||||||||||||||||||
|
SELECT "lego_baseset"."id",
6 similar queries.
"lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector" FROM "lego_baseset" WHERE "lego_baseset"."id" = 196163 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 196163 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 COUNT(*) AS "__count"
FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 200622)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 200622) |
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/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-014672%') 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-014672%') ORDER BY "blog_article"."published_date" ASC |
0.28 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/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-22T14:09:08.416370+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.416443+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.416355+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.416569+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T14:09:08.416370+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.416443+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.416355+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.416569+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
2.96 | ||||||||||||||||||||
|
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-22T14:09:08.416370+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.416443+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.416355+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.416569+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-22T14:09:08.416370+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.416443+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.416355+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.416569+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.70 | ||||||||||||||||||||
|
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" = 200622 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 200622 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/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.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 "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.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(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" = 200622 OR "lego_setrelationship"."set_child_id" = 200622))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" = 200622 OR "lego_setrelationship"."set_child_id" = 200622)) |
0.32 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_related_sets_tab_html(278) return set.get_related_sets_tab_html(context['request'])[0] /home/nathan/rb/site/./lego/models/sets.py in get_related_sets_tab_html(1854) same_chars = self.get_related_sets(request.user, rel_type=SetRelationship.REL_TYPE_CHARACTER) /home/nathan/rb/site/./lego/models/sets.py in get_related_sets(1402) return SetRelationship.get_all_linked_sets(self, include_inactive=user.is_admin, rel_type=rel_type) /home/nathan/rb/site/./lego/models/sets.py in get_all_linked_sets(3224) if len(starting_rels) == 0:
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_tabs.html |
|||||||||||||||||||||
|
SELECT "lego_setrelationship"."id",
"lego_setrelationship"."set_parent_id", "lego_setrelationship"."set_child_id", "lego_setrelationship"."rel_type", T3."id", T3."set_num", T3."name", T3."year", T3."theme_id", T3."set_type", T3."num_parts", T3."default_inventory_id", T3."is_active", T3."is_accessory", T3."added_dt", T3."added_by_id", T3."last_modified_dt", T3."last_modified_by_id", T3."last_checked_for_bi", T3."descr", T3."primary_photo_id", T3."is_gear", T3."is_book", T3."search_vector", T3."mfhash_vector" FROM "lego_setrelationship" INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."set_parent_id" = 200622 AND "lego_setrelationship"."rel_type" = 'C')SELECT ••• FROM "lego_setrelationship" INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."set_parent_id" = 200622 AND "lego_setrelationship"."rel_type" = 'C') |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in get_related_sets_tab_html(278) return set.get_related_sets_tab_html(context['request'])[0] /home/nathan/rb/site/./lego/models/sets.py in get_related_sets_tab_html(1854) same_chars = self.get_related_sets(request.user, rel_type=SetRelationship.REL_TYPE_CHARACTER) /home/nathan/rb/site/./lego/models/sets.py in get_related_sets(1402) return SetRelationship.get_all_linked_sets(self, include_inactive=user.is_admin, rel_type=rel_type) /home/nathan/rb/site/./lego/models/sets.py in get_all_linked_sets(3235) sets = [r.set_child for r in rels]
/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_tabs.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
3 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T14:09:08.438000+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.438069+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.437989+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.438186+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T14:09:08.438000+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.438069+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.437989+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.438186+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.35 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(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-22T14:09:08.438000+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.438069+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.437989+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.438186+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-22T14:09:08.438000+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.438069+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.437989+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.438186+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(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" = 12059 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 12059 LIMIT 21 |
0.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/sets.py in get_moc(830) elif hasattr(self, 'moc'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 6131 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 6131 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(765) 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" = 68963 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 68963 LIMIT 21 |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/sets.py in get_moc(830) elif hasattr(self, 'moc'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 377594 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 377594 LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765) 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" = 37862 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 37862 LIMIT 21 |
0.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/sets.py in get_moc(830) elif hasattr(self, 'moc'):
/home/nathan/rb/site/lego/templates/sets/render_set_related.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
10 similar queries.
"auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors" FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 285200 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 285200 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765) 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" = 245001 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 245001 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" = 755001 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 755001 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765) 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" = 125742 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 125742 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" = 125106 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 125106 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765) 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" = 178254 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 178254 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" = 775027 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 775027 LIMIT 21 |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765) 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" = 52728 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 52728 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" = 373985 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 373985 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(765) 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" = 162937 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 162937 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" = 531900 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 531900 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(765) 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" = 49435 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 49435 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" = 178000 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 178000 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(765) 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" = 58525 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 58525 LIMIT 21 |
0.28 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/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" = 77841 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 77841 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102) return figure_details(request, slug1) /home/nathan/rb/site/./lego/views/figures.py in figure_details(343) return render(request, 'sets/set_details.html', context) /home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18) return render_to_string('sets/render_set_related.html', /home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615) return self.get_moc().get_absolute_url() /home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765) 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-22T14:09:08.465909+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.465979+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.465897+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.466101+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T14:09:08.465909+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.465979+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.465897+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.466101+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.56 | ||||||||||||||||||||
|
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-22T14:09:08.465909+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.465979+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.465897+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.466101+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-22T14:09:08.465909+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T14:09:08.465979+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T14:09:08.465897+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T14:09:08.466101+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.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/./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.