LEGO SET fig-005775 - Danju, Wolf Pattern (Knights Kingdom II)

This figure appears in the following Sets:

Knights' Kingdom The Game

218158-1

(40 parts)

Castle > Knights Kingdom II 2006

Scorpion Prison Cave

8876-1

(279 parts)

Castle > Knights Kingdom II 2005

Vladek's Dark Fortress

8877-1 v1

(989 parts)

Castle > Knights Kingdom II 2005

Vladek's Dark Fortress

8877-1 v2

(989 parts)

Castle > Knights Kingdom II 2005

fig-005775

Name	Danju, Wolf Pattern (Knights Kingdom II)
Inventory	6 parts
Found In	4 sets

Build this Minifig

You have

? %

of the parts to build this Minifig

Create an account and enter your LEGO collection to find out if you can build this Minifig!

Submit Photo

External Sites

This Minifig is known differently at other sites:

BrickLink	cas269
BrickOwl	492556
Brickset	cas269

2,800

April 27, 2020, 7:36 p.m. by jaredhinton

Oct. 15, 2022, 5:15 p.m. by jaredhinton

See Change Log for fig-005775

Same Character

These related Minifigs are the same character with different designs.

Help Guide - Buying LEGO Parts

Already have some of the parts? Use the Build this Set page to only show the parts you are missing.

Include BrickLink Stores

Include BrickOwl Stores

Include Independent Stores

Include Stores from all Regions (Default: US)

Include Used/2nd Hand Parts

Create an account to change the default filters used.

Go to your Wishlists

Go to your Wanted Lists

Waiting for Inventory to load

fig-005775

Name	Danju, Wolf Pattern (Knights Kingdom II)
Inventory	6 parts
Found In	4 sets

Build this Minifig

You have

? %

of the parts to build this Minifig

Create an account and enter your LEGO collection to find out if you can build this Minifig!

Submit Photo

External Sites

This Minifig is known differently at other sites:

BrickLink	cas269
BrickOwl	492556
Brickset	cas269

2,800

April 27, 2020, 7:36 p.m. by jaredhinton

Oct. 15, 2022, 5:15 p.m. by jaredhinton

See Change Log for fig-005775

Other Sets/MOCs you might like

Sora Mosaic (Kingdom Hearts II)

Lion Knights (Kingdoms) Display with tile floor

Sora, Donald & Goofy (Kingdom Hearts II)

Watchtower of Axe Knight's Lost Kingdom

Pirate Ship Heartless (Kingdom Hearts II)

Sora's Drive Forms - Kingdom Hearts II

DJDT

Time

Resource usage

Resource	Value
User CPU time	490.738 msec
System CPU time	0.063 msec
Total CPU time	490.801 msec
Elapsed time	786.071 msec
Context switches	127 voluntary, 5 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 295.59 ms (71 queries including 50 similar and 21 duplicates )

Query Timeline Time (ms) Action

2 similar queries. Duplicated 2 times.

8.84

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)

2 similar queries. Duplicated 2 times.

0.23

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(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" = 57990
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 57990 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(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-005775'
ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'fig-005775' ORDER BY "lego_changelog"."timestamp" DESC

0.75

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" = 57016
LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 57016 LIMIT 21

0.12

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" = 2803,
       "builds" = 1,
       "likes" = 0,
       "bi_downloads" = 0,
       "featured_hits" = 0,
       "user_hits" = 0
WHERE "lego_setstatstotal"."set_id" = 57016UPDATE "lego_setstatstotal" SET "hits" = 2803, "builds" = 1, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 57016

0.13

Connection: default

Transaction status: In transaction

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(298)
  figure.stats.inc_hits()

/home/nathan/rb/site/./lego/models/sets.py in inc_hits(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" = 57016)
LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-22'::date AND "lego_setstatshistory"."set_id" = 57016) LIMIT 21

0.23

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_x14"SAVEPOINT "s135227521288000_x14"

0.04

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 (57016, '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 (57016, '2026-01-22'::date, 0, 0, 0, 0, 0, 0) RETURNING "lego_setstatshistory"."id"

0.24

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_x14"RELEASE SAVEPOINT "s135227521288000_x14"

0.04

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" = 57016,
       "day" = '2026-01-22'::date,
       "hits" = 1,
       "builds" = 0,
       "likes" = 0,
       "bi_downloads" = 0,
       "featured_hits" = 0,
       "user_hits" = 0
WHERE "lego_setstatshistory"."id" = 140924701UPDATE "lego_setstatshistory" SET "set_id" = 57016, "day" = '2026-01-22'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140924701

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(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" = 57016 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" = 57016 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC

0.83

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(327)
  for s in context['parent_sets']:

SELECT "lego_inventory"."id",
       "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" = 35230)
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 35230) LIMIT 21

4 similar queries.

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",
       "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" = 14732)
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 14732) LIMIT 21

4 similar queries.

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",
       "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" = 1625)
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 1625) LIMIT 21

4 similar queries.

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",
       "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" = 161063)
LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 161063) LIMIT 21

4 similar queries.

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_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" = 501
LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 501 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(331)
  context['similar_sets'] = figure.get_similar_sets(10)

/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
  result = method(instance, *args, **kwargs)

/home/nathan/rb/site/./lego/models/sets.py in get_similar_sets(1350)
  """, {'theme': self.theme.name,

SELECT DISTINCT "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug",
       COUNT("lego_figure"."baseset_ptr_id") AS "count"
  FROM "taggit_tag"
INNER JOIN "taggit_taggeditem"
    ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
INNER JOIN "django_content_type"
    ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
  LEFT OUTER JOIN "lego_baseset"
    ON ("taggit_taggeditem"."object_id" = "lego_baseset"."id" AND ("taggit_taggeditem"."content_type_id" IN (18,63,17,22,20,31,50,180)))
  LEFT OUTER JOIN "lego_figure"
    ON ("lego_baseset"."id" = "lego_figure"."baseset_ptr_id")
INNER JOIN "taggit_taggeditem" T6
    ON ("taggit_tag"."id" = T6."tag_id")
INNER JOIN "lego_baseset" T7
    ON (T6."object_id" = T7."id" AND (T6."content_type_id" IN (18,63,17,22,20,31,50,180)))
INNER JOIN "lego_figure" T8
    ON (T7."id" = T8."baseset_ptr_id")
WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'figure' AND T8."baseset_ptr_id" = 57016)
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" = 57016) GROUP BY "taggit_tag"."id"

2 similar queries. Duplicated 2 times.

54.72

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", 'Danju Wolf Pattern Knights Kingdom II')*5 + similarity(coalesce(( select string_agg(tag_id::text, ' ') as tags from taggit_taggeditem where content_type_id in (17,18,22,63,31,180) and object_id=lego_baseset.id ),''), '970')*5 + similarity("lego_theme"."name", 'Gear')/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) % 'Danju Wolf Pattern Knights Kingdom II 501')
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", 'Danju Wolf Pattern Knights Kingdom II')*5 + similarity(coalesce(( select string_agg(tag_id::text, ' ') as tags from taggit_taggeditem where content_type_id in (17,18,22,63,31,180) and object_id=lego_baseset.id ),''), '970')*5 + similarity("lego_theme"."name", 'Gear')/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) % 'Danju Wolf Pattern Knights Kingdom II 501') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10

65.04

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)

2 similar queries. Duplicated 2 times.

52.45

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", 'Danju Wolf Pattern Knights Kingdom II')*5 + similarity(coalesce(( select string_agg(tag_id::text, ' ') as tags from taggit_taggeditem where content_type_id in (17,18,22,63,31,180) and object_id=lego_baseset.id ),''), '970')*5 + similarity("lego_theme"."name", 'Gear')/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) % 'Danju Wolf Pattern Knights Kingdom II 501')
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", 'Danju Wolf Pattern Knights Kingdom II')*5 + similarity(coalesce(( select string_agg(tag_id::text, ' ') as tags from taggit_taggeditem where content_type_id in (17,18,22,63,31,180) and object_id=lego_baseset.id ),''), '970')*5 + similarity("lego_theme"."name", 'Gear')/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) % 'Danju Wolf Pattern Knights Kingdom II 501') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10

94.62

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" = 57016)SELECT ••• FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 57016)

0.25

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" = 57016SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 57016

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(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):

7 similar queries. Duplicated 3 times.

0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(339)
  context['mappings'] = figure.get_ext_mappings()

/home/nathan/rb/site/./lego/models/sets.py in get_ext_mappings(1992)
  mappings[set_map.get_ext_system_display()].append({'url': set_map.get_ext_exact_or_search_url(),

/home/nathan/rb/site/./lego/models/sets.py in get_ext_exact_or_search_url(2979)
  if self.set.is_figure:

7 similar queries. Duplicated 3 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(339)
  context['mappings'] = figure.get_ext_mappings()

/home/nathan/rb/site/./lego/models/sets.py in get_ext_mappings(1992)
  mappings[set_map.get_ext_system_display()].append({'url': set_map.get_ext_exact_or_search_url(),

/home/nathan/rb/site/./lego/models/sets.py in get_ext_exact_or_search_url(2989)
  if self.set.is_figure:

SELECT "lego_setphoto"."id",
       "lego_setphoto"."set_id",
       "lego_setphoto"."photo_type_id",
       "lego_setphoto"."submitted_by_id",
       "lego_setphoto"."timestamp",
       "lego_setphoto"."is_active",
       "lego_setphoto"."is_primary"
  FROM "lego_setphoto"
WHERE "lego_setphoto"."id" = 68688
LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 68688 LIMIT 21

5 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(751)
  file_dir = self.primary_photo.get_img_dir()

34	`{% block meta_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_description %}`
35	`{% block meta_og_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_og_description %}`
36	`{% block meta_image %}{% spaceless %}`
37	`{% if set.img_dir %}`
38	`{% thumbs set.img_dir settings.THUMBS_OPTIONS_SET_MAIN as img %}{{ img.url }}`
39	`{% endif %}`
40	`{% endspaceless %}{% endblock meta_image %}`
41

/home/nathan/rb/site/lego/templates/sets/set_details.html

7 similar queries. Duplicated 3 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(751)
  file_dir = self.primary_photo.get_img_dir()

/home/nathan/rb/site/./lego/models/sets.py in get_img_dir(3133)
  return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')

34	`{% block meta_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_description %}`
35	`{% block meta_og_description %}LEGO Set {{ set.set_num }} {{ set.name }} - building instructions and parts inventory.{% endblock meta_og_description %}`
36	`{% block meta_image %}{% spaceless %}`
37	`{% if set.img_dir %}`
38	`{% thumbs set.img_dir settings.THUMBS_OPTIONS_SET_MAIN as img %}{{ img.url }}`
39	`{% endif %}`
40	`{% endspaceless %}{% endblock meta_image %}`
41

/home/nathan/rb/site/lego/templates/sets/set_details.html

SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM "countries_plus_country"
WHERE "countries_plus_country"."iso" = 'US'
LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21

0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
  geo_data = user.geo.get_user_currency()

/home/nathan/rb/site/./geo/geo.py in get_user_currency(252)
  country = Country.objects.get(iso=country_code)

412	`</a>`
413	`</li>`
414	`<li class="hidden-xs">`
415	`{% geo_currency request.user %}`
416	`</li>`
417	`{% comment %}`
418	`<li class="hidden-xs hidden-sm">`
419	`<a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>`

/home/nathan/rb/site/rb/templates/rb/base_root.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_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" = 57016) 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" = 57016) AND "lego_baseset"."set_type" = 'Set')

2 similar queries. Duplicated 2 times.

0.76

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:

15	`{% block breadcrumbs %}`
16	`{% if set.is_figure %}`
17	`{% breadcrumb "LEGO Minifigs" "find_minifigs" %}`
18	`{% breadcrumb set.get_theme.t1_name "/minifigs/"\|addstr:set.get_theme.get_level_1_slug\|addstr:"/" %}`
19	`{% else %}`
20	`{% breadcrumb "LEGO Sets" "find_sets" %}`
21	`{% breadcrumb set.theme.t1_name "/sets/"\|addstr:set.theme.get_level_1_slug\|addstr:"/" %}`
22	`{% if set.theme.t2_name %}{% breadcrumb set.theme.t2_name "/sets/?theme="\|addstr:set.theme.get_level_2_id %}{% endif %}`

/home/nathan/rb/site/lego/templates/sets/set_details.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_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" = 57016) 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" = 57016) AND "lego_baseset"."set_type" = 'Set')

2 similar queries. Duplicated 2 times.

0.62

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:

15	`{% block breadcrumbs %}`
16	`{% if set.is_figure %}`
17	`{% breadcrumb "LEGO Minifigs" "find_minifigs" %}`
18	`{% breadcrumb set.get_theme.t1_name "/minifigs/"\|addstr:set.get_theme.get_level_1_slug\|addstr:"/" %}`
19	`{% else %}`
20	`{% breadcrumb "LEGO Sets" "find_sets" %}`
21	`{% breadcrumb set.theme.t1_name "/sets/"\|addstr:set.theme.get_level_1_slug\|addstr:"/" %}`
22	`{% if set.theme.t2_name %}{% breadcrumb set.theme.t2_name "/sets/?theme="\|addstr:set.theme.get_level_2_id %}{% endif %}`

/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" = 57016)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 57016)

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)

9
10	`{% if set.img_dir %}`
11	`{% if set.is_figure %}`
12	`{% if set.photos.count > 1 %}`
13	`{# Setup slider to move through multiple Set images #}`
14	`{# flexsliderX to avoid initialisation until we have loaded all images #}`
15	`<div class="row">`
16	`<div class="col-sm-6 col-sm-offset-3 pl-0 pr-0">`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html

SELECT "lego_setphoto"."id",
       "lego_setphoto"."set_id",
       "lego_setphoto"."photo_type_id",
       "lego_setphoto"."submitted_by_id",
       "lego_setphoto"."timestamp",
       "lego_setphoto"."is_active",
       "lego_setphoto"."is_primary"
  FROM "lego_setphoto"
WHERE "lego_setphoto"."id" = 17194
LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 17194 LIMIT 21

5 similar queries.

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()

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.html

7 similar queries.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
  return render_to_string('sets/render_set.html',

/home/nathan/rb/site/./lego/models/sets.py in img_dir(751)
  file_dir = self.primary_photo.get_img_dir()

/home/nathan/rb/site/./lego/models/sets.py in get_img_dir(3133)
  return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.html

SELECT "lego_setphoto"."id",
       "lego_setphoto"."set_id",
       "lego_setphoto"."photo_type_id",
       "lego_setphoto"."submitted_by_id",
       "lego_setphoto"."timestamp",
       "lego_setphoto"."is_active",
       "lego_setphoto"."is_primary"
  FROM "lego_setphoto"
WHERE "lego_setphoto"."id" = 120744
LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 120744 LIMIT 21

5 similar queries.

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()

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.html

7 similar queries.

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/models/sets.py in get_img_dir(3133)
  return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.html

SELECT "lego_setphoto"."id",
       "lego_setphoto"."set_id",
       "lego_setphoto"."photo_type_id",
       "lego_setphoto"."submitted_by_id",
       "lego_setphoto"."timestamp",
       "lego_setphoto"."is_active",
       "lego_setphoto"."is_primary"
  FROM "lego_setphoto"
WHERE "lego_setphoto"."id" = 5232
LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 5232 LIMIT 21

5 similar queries. Duplicated 2 times.

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()

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.html

7 similar queries. Duplicated 2 times.

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/models/sets.py in get_img_dir(3133)
  return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.html

SELECT "lego_setphoto"."id",
       "lego_setphoto"."set_id",
       "lego_setphoto"."photo_type_id",
       "lego_setphoto"."submitted_by_id",
       "lego_setphoto"."timestamp",
       "lego_setphoto"."is_active",
       "lego_setphoto"."is_primary"
  FROM "lego_setphoto"
WHERE "lego_setphoto"."id" = 5232
LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 5232 LIMIT 21

5 similar queries. Duplicated 2 times.

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()

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/render_set.html

7 similar queries. Duplicated 2 times.

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/models/sets.py in get_img_dir(3133)
  return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')

42	`{# Image #}`
43	`<div class="clearfix {% if set.is_figure %} js-hover-card{% endif %}" {% if set.is_figure %}data-hover="{% url 'minfig_hover' set.set_num %}"{% endif %}>`
44	`<a href="{{ set.get_absolute_url }}{% if inventory and not set.is_moc %}?inventory={{ inventory.version }}{% endif %}">`
45	`{% if not set.img_dir and set.is_figure %}`
46	`{% include 'lego/includes/render_set_img.html' with img_file='nil_mf.jpg' tn_options=tn_options %}`
47	`{% else %}`
48	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=tn_options %}`
49	`{% endif %}`

/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" = 57016)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 57016)

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in get_num_inventories(981)
  return Inventory.objects.filter(set=self).count()

67	`{% endif %}`
68	`<tr>`
69	`<td>Inventory</td>`
70	`<td><a href="#parts_scroll">{{ set.num_parts }} parts{% if set.get_num_inventories > 1 %} <span class="label label-primary">v{{ inventory.version }}</span>{% endif %}</a></td>`
71	`</tr>`
72	`{% if set.is_figure %}`
73	`<tr>`
74	`<td>Found In</td>`

/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-005775%')
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-005775%') ORDER BY "blog_article"."published_date" ASC

0.30

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/models/sets.py in get_set_review(1393)
  for review in reviews:

119	`{% endif %}`
120	`</table>`
121
122	`{% with set.get_set_review as review %}`
123	`{% if review %}`
124	`<p>See our review:</p>`
125	`{% include 'blog/includes/render_posts_preview.html' with article=review %}`
126	`{% endif %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html

SELECT (width*height) AS "area",
       "ads_banner"."id",
       "ads_banner"."width",
       "ads_banner"."height",
       "ads_banner"."start_date",
       "ads_banner"."end_date",
       "ads_banner"."country_code",
       "ads_banner"."html"
  FROM "ads_banner"
WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.933346+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.933418+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.933332+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.933541+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.933346+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.933418+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.933332+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.933541+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')

3 similar queries.

2.59

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
  if not banners:

192	`{% endcache %}`
193
194	`{# cant include banner in cache as it's region specific #}`
195	`{% render_banner 262 350 0 %}`
196
197	`{% cache cache_timeout 'set_sidebar_top_other_bit' user.is_authenticated set.id %}`
198	`{% if request.user.is_authenticated and not set.is_pending %}`
199	`{% if not set.is_figure %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html

SELECT (width*height) AS "area",
       "ads_banner"."id",
       "ads_banner"."width",
       "ads_banner"."height",
       "ads_banner"."start_date",
       "ads_banner"."end_date",
       "ads_banner"."country_code",
       "ads_banner"."html"
  FROM "ads_banner"
WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.933346+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.933418+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.933332+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.933541+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-22T18:39:34.933346+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.933418+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.933332+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.933541+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1

3 similar queries.

1.26

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
  banner = banners.order_by('-area', '?')[0]

192	`{% endcache %}`
193
194	`{# cant include banner in cache as it's region specific #}`
195	`{% render_banner 262 350 0 %}`
196
197	`{% cache cache_timeout 'set_sidebar_top_other_bit' user.is_authenticated set.id %}`
198	`{% if request.user.is_authenticated and not set.is_pending %}`
199	`{% if not set.is_figure %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html

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)

267	`<section class="padding-xxs">`
268	`<h4 class="text-center">External Sites</h4>`
269	`<table class="table">`
270	`<p>This {% if set.set %}Set{% else %}Minifig{% endif %} is known differently at other sites:</p>`
271	`{% for external_site, set_maps in mappings.items %}`
272	`<tr>`
273	`<td>{{ external_site }}</td>`
274	`<td>`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html

2 similar queries. Duplicated 2 times.

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)

5	`{% cache cache_timeout 'change_summary' user.is_authenticated set.id 'v3' %}`
6	`<div><small><i class="fa fa-fw fa-eye" title="Views"></i> {{ set.stats.hits\|default:0\|floor_100\|intcomma }}</small></div>`
7	`<div><small><i class="fa fa-fw fa-plus" title="Added"></i> {{ changes.added.timestamp }}`
8	`{% if changes.added.user %}by`
9	`<a href="{% url 'user_profile' changes.added.user.get_username %}">{{ changes.added.user.get_username }}</a>`
10	`{% endif %}</small></div>`
11	`<div><small><i class="fa fa-fw fa-edit" title="Updated"></i> {{ changes.updated.timestamp }}`
12	`{% if changes.updated.user %}by`

/home/nathan/rb/site/lego/templates/sets/includes/render_change_summary.html

2 similar queries. Duplicated 2 times.

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)

9	`<a href="{% url 'user_profile' changes.added.user.get_username %}">{{ changes.added.user.get_username }}</a>`
10	`{% endif %}</small></div>`
11	`<div><small><i class="fa fa-fw fa-edit" title="Updated"></i> {{ changes.updated.timestamp }}`
12	`{% if changes.updated.user %}by`
13	`<a href="{% url 'user_profile' changes.updated.user.get_username %}">{{ changes.updated.user.get_username }}</a>`
14	`{% endif %}</small></div>`
15	`<div class="mb-10"><small><a href="{% url 'change_log' %}?search_id={{ set.set_num }}">See Change Log for {{ set.set_num }}</a></small></div>`
16	`{% if user.is_authenticated %}`

/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" = 57016 OR "lego_setrelationship"."set_child_id" = 57016))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" = 57016 OR "lego_setrelationship"."set_child_id" = 57016))

0.45

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:

77	`<div class="tab-pane in" id="tab_rels">`
78	`<div id="rel_sets_list">`
79	`{% if is_crawler %}`
80	`{% get_related_sets_tab_html set %}`
81	`{% endif %}`
82	`</div>`
83	`</div>`
84	`{% else %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_tabs.html

SELECT (width*height) AS "area",
       "ads_banner"."id",
       "ads_banner"."width",
       "ads_banner"."height",
       "ads_banner"."start_date",
       "ads_banner"."end_date",
       "ads_banner"."country_code",
       "ads_banner"."html"
  FROM "ads_banner"
WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.949886+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.949957+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.949875+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.950077+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.949886+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.949957+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.949875+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.950077+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')

3 similar queries.

1.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
  if not banners:

192	`{% endcache %}`
193
194	`{# cant include banner in cache as it's region specific #}`
195	`{% render_banner 262 350 0 %}`
196
197	`{% cache cache_timeout 'set_sidebar_top_other_bit' user.is_authenticated set.id %}`
198	`{% if request.user.is_authenticated and not set.is_pending %}`
199	`{% if not set.is_figure %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html

SELECT (width*height) AS "area",
       "ads_banner"."id",
       "ads_banner"."width",
       "ads_banner"."height",
       "ads_banner"."start_date",
       "ads_banner"."end_date",
       "ads_banner"."country_code",
       "ads_banner"."html"
  FROM "ads_banner"
WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.949886+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.949957+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.949875+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.950077+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-22T18:39:34.949886+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.949957+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.949875+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.950077+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1

3 similar queries.

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]

192	`{% endcache %}`
193
194	`{# cant include banner in cache as it's region specific #}`
195	`{% render_banner 262 350 0 %}`
196
197	`{% cache cache_timeout 'set_sidebar_top_other_bit' user.is_authenticated set.id %}`
198	`{% if request.user.is_authenticated and not set.is_pending %}`
199	`{% if not set.is_figure %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_top.html

10 similar queries.

0.22

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
  elif hasattr(self, 'moc'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 948392
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 948392 LIMIT 21

10 similar queries. Duplicated 2 times.

0.24

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765)
  url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
  elif hasattr(self, 'moc'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 839407
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 839407 LIMIT 21

10 similar queries. Duplicated 4 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765)
  url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
  elif hasattr(self, 'moc'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 17262
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 17262 LIMIT 21

10 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765)
  url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

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'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 452667
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 452667 LIMIT 21

10 similar queries.

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)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
  elif hasattr(self, 'moc'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 839407
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 839407 LIMIT 21

10 similar queries. Duplicated 4 times.

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)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
  elif hasattr(self, 'moc'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 613685
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 613685 LIMIT 21

10 similar queries.

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)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

0.29

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
  elif hasattr(self, 'moc'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 1109650
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1109650 LIMIT 21

10 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(18)
  return render_to_string('sets/render_set_related.html',

/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(615)
  return self.get_moc().get_absolute_url()

/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765)
  url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

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'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries. Duplicated 2 times.

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)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

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'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 839407
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 839407 LIMIT 21

10 similar queries. Duplicated 4 times.

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)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

10 similar queries.

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'):

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 839407
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 839407 LIMIT 21

10 similar queries. Duplicated 4 times.

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)

2
3	`<div class="mb-20">`
4	`<div class="text-center">`
5	`<a href="{{ set.get_absolute_url }}">`
6	`{% include 'lego/includes/render_set_img.html' with img_file=set.img_dir tn_options=settings.THUMBS_OPTIONS_MOC_TILE %}`
7	`</a>`
8	`</div>`
9	`<h4 class="trunc mb-0" title="{{ set.name }}"><a href="{{ set.get_absolute_url }}">{{ set.name }}</a></h4>`

/home/nathan/rb/site/lego/templates/sets/render_set_related.html

SELECT (width*height) AS "area",
       "ads_banner"."id",
       "ads_banner"."width",
       "ads_banner"."height",
       "ads_banner"."start_date",
       "ads_banner"."end_date",
       "ads_banner"."country_code",
       "ads_banner"."html"
  FROM "ads_banner"
WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.978205+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.978269+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.978196+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.978388+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.978205+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.978269+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.978196+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.978388+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')

3 similar queries.

1.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/./ads/templatetags/ads/drawing.py in render_banner(291)
  if not banners:

20	`{% render_set related_set related=True %}`
21	`{% endfor %}`
22	`{% render_ad 'med_rect_btf' %}`
23	`{% render_banner 262 350 %}`
24	`<a href="{% url 'browse_mocs' %}"><button class="btn btn-default btn-block mt-10">Discover more MOCs!</button></a>`
25	`</section>`
26

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_bottom.html

SELECT (width*height) AS "area",
       "ads_banner"."id",
       "ads_banner"."width",
       "ads_banner"."height",
       "ads_banner"."start_date",
       "ads_banner"."end_date",
       "ads_banner"."country_code",
       "ads_banner"."html"
  FROM "ads_banner"
WHERE ("ads_banner"."start_date" < '2026-01-22T18:39:34.978205+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.978269+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.978196+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.978388+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-22T18:39:34.978205+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T18:39:34.978269+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T18:39:34.978196+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T18:39:34.978388+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1

3 similar queries.

1.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
  return figure_details(request, slug1)

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)

/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
  banner = banners.order_by('-area', '?')[0]

20	`{% render_set related_set related=True %}`
21	`{% endfor %}`
22	`{% render_ad 'med_rect_btf' %}`
23	`{% render_banner 262 350 %}`
24	`<a href="{% url 'browse_mocs' %}"><button class="btn btn-default btn-block mt-10">Discover more MOCs!</button></a>`
25	`</section>`
26

/home/nathan/rb/site/lego/templates/sets/includes/render_set_sidebar_bottom.html

Log messages

No messages logged.

LEGO SET fig-005775 - Danju, Wolf Pattern (Knights Kingdom II)

Knights' Kingdom The Game

Scorpion Prison Cave

Vladek's Dark Fortress

Vladek's Dark Fortress

fig-005775

Build this Minifig

? %

Submit Photo

External Sites

Same Character

fig-005775

Build this Minifig

? %

Submit Photo

External Sites

Brown Wolf - Warg

Sora Mosaic (Kingdom Hearts II)

Lion Knights (Kingdoms) Display with tile floor

🏰 MEDIEVAL KINGDOM 🏰

Sora, Donald & Goofy (Kingdom Hearts II)

Lion Knights' Kingdom

Watchtower of Axe Knight's Lost Kingdom

Gray Wolf - Warg

Pirate Ship Heartless (Kingdom Hearts II)

Sora's Drive Forms - Kingdom Hearts II

Time

Resource usage

Browser timing

SQL queries from 1 connection

Log messages