LEGO SET fig-013312 - Arbalest Knight

This figure appears in the following Sets:

Hero with Frog and Slime
Hero with Frog and Slime
662412-1
(15 parts)
Minecraft 2024
x1
The Deep Dark Battle
The Deep Dark Battle
21246-1
(584 parts)
Minecraft 2023
x1

fig-013312

Name Arbalest Knight
Inventory 3 parts
Found In 2 sets
LOTR Rivendell

Submit Photo

External Sites

This Minifig is known differently at other sites:

BrickLink min149
BrickOwl 555762
Brickset min149
1,100
Jan. 1, 2023, 8:02 p.m. by jaredhinton
June 8, 2023, 6:42 p.m. by jaredhinton
See Change Log for fig-013312

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.
Create an account to change the default filters used.
Go to your Wishlists
Go to your Wanted Lists

Waiting for Inventory to load

DJDT

Time

Resource usage

Resource Value
User CPU time 468.698 msec
System CPU time 0.731 msec
Total CPU time 469.429 msec
Elapsed time 622.096 msec
Context switches 130 voluntary, 3 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 151.36 ms (66 queries including 44 similar and 13 duplicates )
Query Timeline Time (ms) Action
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_figure"."baseset_ptr_id"
  FROM "lego_figure"
 INNER JOIN "lego_baseset"
    ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_baseset"."set_num" = 'fig-013312'
 LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-013312' LIMIT 21
2 similar queries. Duplicated 2 times. 		8.76

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(100)
  figure = get_or_none(Figure.all_objects, set_num=slug1)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)
SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_figure"."baseset_ptr_id"
  FROM "lego_figure"
 INNER JOIN "lego_baseset"
    ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_baseset"."set_num" = 'fig-013312'
 LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-013312' LIMIT 21
2 similar queries. Duplicated 2 times. 		0.19

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(272)
  figure = Figure.all_objects.get(set_num=set_num)
SELECT "lego_inventory"."id",
       "lego_inventory"."set_id",
       "lego_inventory"."version",
       "lego_inventory"."name",
       "lego_inventory"."is_active",
       "lego_inventory"."num_parts",
       "lego_inventory"."num_versions"
  FROM "lego_inventory"
 WHERE "lego_inventory"."id" = 160541
 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 160541 LIMIT 21
 0.12

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(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-013312'
 ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE "lego_changelog"."set_num" = 'fig-013312' ORDER BY "lego_changelog"."timestamp" DESC
 0.77

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./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" = 157216
 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 157216 LIMIT 21
 0.11

Connection: default

Transaction status: In transaction

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

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

/usr/lib/python3.10/contextlib.py in inner(79)
  return func(*args, **kwds)

/home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36)
  .__get__(instance, instance_type)
UPDATE "lego_setstatstotal"
   SET "hits" = 1178,
       "builds" = 1,
       "likes" = 0,
       "bi_downloads" = 0,
       "featured_hits" = 0,
       "user_hits" = 0
 WHERE "lego_setstatstotal"."set_id" = 157216UPDATE "lego_setstatstotal" SET "hits" = 1178, "builds" = 1, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatstotal"."set_id" = 157216
 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()

/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" = 157216)
 LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-01-22'::date AND "lego_setstatshistory"."set_id" = 157216) LIMIT 21
 0.29

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_x4"SAVEPOINT "s135227521288000_x4"
 0.03

Connection: default

Transaction status: In transaction

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

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

/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
  SetStatsHistory.inc_hits(self.set)

/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2587)
  self, created = cls.objects.get_or_create(set=set, day=timezone.now())
INSERT INTO "lego_setstatshistory" ("set_id", "day", "hits", "builds", "likes", "bi_downloads", "featured_hits", "user_hits")
VALUES (157216, '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 (157216, '2026-01-22'::date, 0, 0, 0, 0, 0, 0) RETURNING "lego_setstatshistory"."id"
 0.32

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_x4"RELEASE SAVEPOINT "s135227521288000_x4"
 0.03

Connection: default

Transaction status: In transaction

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

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

/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
  SetStatsHistory.inc_hits(self.set)

/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2587)
  self, created = cls.objects.get_or_create(set=set, day=timezone.now())
UPDATE "lego_setstatshistory"
   SET "set_id" = 157216,
       "day" = '2026-01-22'::date,
       "hits" = 1,
       "builds" = 0,
       "likes" = 0,
       "bi_downloads" = 0,
       "featured_hits" = 0,
       "user_hits" = 0
 WHERE "lego_setstatshistory"."id" = 140924310UPDATE "lego_setstatshistory" SET "set_id" = 157216, "day" = '2026-01-22'::date, "hits" = 1, "builds" = 0, "likes" = 0, "bi_downloads" = 0, "featured_hits" = 0, "user_hits" = 0 WHERE "lego_setstatshistory"."id" = 140924310
 0.09

Connection: default

Transaction status: In transaction

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

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

/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2638)
  SetStatsHistory.inc_hits(self.set)

/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2589)
  self.save()
SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_inventory"."id" AS "inventory2",
       "lego_invset"."quantity" AS "quantity",
       "lego_theme"."id",
       "lego_theme"."parent_id",
       "lego_theme"."name",
       "lego_theme"."slug",
       "lego_theme"."set_count",
       "lego_theme"."t1_id",
       "lego_theme"."t1_name",
       "lego_theme"."t2_name",
       "lego_theme"."t3_name",
       "lego_theme"."lego_blurb",
       "lego_theme"."banner_img",
       "lego_theme"."descr",
       T6."id",
       T6."parent_id",
       T6."name",
       T6."slug",
       T6."set_count",
       T6."t1_id",
       T6."t1_name",
       T6."t2_name",
       T6."t3_name",
       T6."lego_blurb",
       T6."banner_img",
       T6."descr",
       T7."id",
       T7."parent_id",
       T7."name",
       T7."slug",
       T7."set_count",
       T7."t1_id",
       T7."t1_name",
       T7."t2_name",
       T7."t3_name",
       T7."lego_blurb",
       T7."banner_img",
       T7."descr",
       "lego_setstatstotal"."set_id",
       "lego_setstatstotal"."hits",
       "lego_setstatstotal"."builds",
       "lego_setstatstotal"."likes",
       "lego_setstatstotal"."bi_downloads",
       "lego_setstatstotal"."featured_hits",
       "lego_setstatstotal"."user_hits"
  FROM "lego_baseset"
 INNER JOIN "lego_inventory"
    ON ("lego_baseset"."id" = "lego_inventory"."set_id")
 INNER JOIN "lego_invset"
    ON ("lego_inventory"."id" = "lego_invset"."inventory_id")
 INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T6
    ON ("lego_theme"."parent_id" = T6."id")
  LEFT OUTER JOIN "lego_theme" T7
    ON (T6."parent_id" = T7."id")
  LEFT OUTER JOIN "lego_setstatstotal"
    ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
 WHERE ("lego_baseset"."is_active" AND "lego_inventory"."is_active" AND "lego_invset"."inv_set_id" = 157216 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" = 157216 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC
 0.97

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./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" = 246925)
 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 246925) LIMIT 21
2 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" = 157136)
 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 157136) LIMIT 21
2 similar queries. 		0.06

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(328)
  s.inventory = get_or_none(Inventory.objects, id=s.inventory2)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)
SELECT "lego_theme"."id",
       "lego_theme"."parent_id",
       "lego_theme"."name",
       "lego_theme"."slug",
       "lego_theme"."set_count",
       "lego_theme"."t1_id",
       "lego_theme"."t1_name",
       "lego_theme"."t2_name",
       "lego_theme"."t3_name",
       "lego_theme"."lego_blurb",
       "lego_theme"."banner_img",
       "lego_theme"."descr"
  FROM "lego_theme"
 WHERE "lego_theme"."id" = 577
 LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 577 LIMIT 21
 0.08

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(331)
  context['similar_sets'] = figure.get_similar_sets(10)

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

/home/nathan/rb/site/./lego/models/sets.py in get_similar_sets(1350)
  """, {'theme': self.theme.name,
SELECT DISTINCT "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug",
       COUNT("lego_figure"."baseset_ptr_id") AS "count"
  FROM "taggit_tag"
 INNER JOIN "taggit_taggeditem"
    ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
 INNER JOIN "django_content_type"
    ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
  LEFT OUTER JOIN "lego_baseset"
    ON ("taggit_taggeditem"."object_id" = "lego_baseset"."id" AND ("taggit_taggeditem"."content_type_id" IN (18,63,17,22,20,31,50,180)))
  LEFT OUTER JOIN "lego_figure"
    ON ("lego_baseset"."id" = "lego_figure"."baseset_ptr_id")
 INNER JOIN "taggit_taggeditem" T6
    ON ("taggit_tag"."id" = T6."tag_id")
 INNER JOIN "lego_baseset" T7
    ON (T6."object_id" = T7."id" AND (T6."content_type_id" IN (18,63,17,22,20,31,50,180)))
 INNER JOIN "lego_figure" T8
    ON (T7."id" = T8."baseset_ptr_id")
 WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'figure' AND T8."baseset_ptr_id" = 157216)
 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" = 157216) GROUP BY "taggit_tag"."id"
 55.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(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", 'Arbalest Knight')*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", 'Minecraft')/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) % 'Arbalest Knight 577')
 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", 'Arbalest Knight')*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", 'Minecraft')/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) % 'Arbalest Knight 577') ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10
67.05

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./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" = 157216)SELECT ••• FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 157216)
 0.27

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(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" = 157216SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 157216
 0.40

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/models/sets.py in get_ext_mappings(1988)
  for set_map in SetMap.objects.filter(set=self):
SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector"
  FROM "lego_baseset"
 WHERE "lego_baseset"."id" = 157216
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 157216 LIMIT 21
5 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(2979)
  if self.set.is_figure:
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"
  FROM "lego_baseset"
 WHERE "lego_baseset"."id" = 157216
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 157216 LIMIT 21
5 similar queries. Duplicated 3 times. 		0.09

Connection: default

Transaction status: Idle

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

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

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

/home/nathan/rb/site/./lego/models/sets.py in get_ext_exact_or_search_url(2989)
  if self.set.is_figure:
SELECT "lego_setphoto"."id",
       "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" = 123916
 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 123916 LIMIT 21
3 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(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
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"
  FROM "lego_baseset"
 WHERE "lego_baseset"."id" = 157216
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 157216 LIMIT 21
5 similar queries. Duplicated 3 times. 		0.09

Connection: default

Transaction status: Idle

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

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

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

/home/nathan/rb/site/./lego/models/sets.py in get_img_dir(3133)
  return os.path.join('sets', self.set.set_num.lower(), str(self.id) + '.jpg')
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.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/./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" = 157216) 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" = 157216) AND "lego_baseset"."set_type" = 'Set')
2 similar queries. Duplicated 2 times. 		1.20

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./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" = 157216) 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" = 157216) AND "lego_baseset"."set_type" = 'Set')
2 similar queries. Duplicated 2 times. 		0.67

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/models/figures.py in get_theme(106)
  if parents:
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" = 157216)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 157216)
 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)
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"."is_active" AND "lego_setphoto"."set_id" = 157216)
 ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASCSELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 157216) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASC
2 similar queries. Duplicated 2 times. 		0.09

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)
19 <div class="flexslider text-center" data-controlNav="thumbnails" data-pauseOnHover="true" data-directionNav="true"
20 data-controlsContainer="#slider_controls">
21 <ul class="slides display-flex">
22 {% for photo in set.photos.all %} {# primary sorted first #}
23 {% thumbs photo.get_img_dir settings.THUMBS_OPTIONS_FIGURE_TILE as tn_img %}
24 {% if forloop.counter == 1 %}
25 {% thumbs_encoded photo.get_img_dir settings.THUMBS_OPTIONS_SET_MAIN_PREVIEW as preview_img %}
26 {% thumbs photo.get_img_dir settings.THUMBS_OPTIONS_FIGURE_MAIN get_real_dims=1 as first_image %}

/home/nathan/rb/site/lego/templates/sets/includes/render_set_main_top.html
SELECT "lego_setphototype"."id",
       "lego_setphototype"."name"
  FROM "lego_setphototype"
 WHERE "lego_setphototype"."id" = 11
 LIMIT 21SELECT ••• FROM "lego_setphototype" WHERE "lego_setphototype"."id" = 11 LIMIT 21
 0.10

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)
28 <li data-thumb="{% cachebuster tn_img.url %}">
29 <a href="{{ merchant_store_costs.img_link|default:'' }}" target="_blank">
30 <img class="img-responsive" style="background-image:url('data:image;base64,{{ preview_img }}');background-size:contain;background-repeat:no-repeat"
31 title="LEGO Set {{ set }}{% if photo.photo_type %} ({{ photo.photo_type.name }}){% endif %}"
32 alt="LEGO Set {{ set }}{% if photo.photo_type %} ({{ photo.photo_type.name }}){% endif %}"
33 onload="this.style.backgroundImage=''" {# so transparent images dont have blurry bg #}
34 src="{% cachebuster first_image.url %}"
35 width="{{ first_image.width }}px" height="{{ first_image.height }}px">

/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"."is_active" AND "lego_setphoto"."set_id" = 157216)
 ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASCSELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 157216) ORDER BY "lego_setphoto"."is_primary" DESC, "lego_setphoto"."is_active" DESC, "lego_setphoto"."timestamp" ASC
2 similar queries. Duplicated 2 times. 		0.09

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)
52 </ul>
53 </div>
54 {# pre-create controls div so we can size column height without CLS impact and prevents flicker #}
55 <div class="flexslider-controls-container-sets {% if set.photos.all|length > 6 %}flexslider-controls-container-sets-2rows{% endif %}">
56 <div id="slider_controls" class="flexslider-figs text-center"></div>
57 </div>
58
59 </div>

/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" = 147316
 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 147316 LIMIT 21
3 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
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"
  FROM "lego_baseset"
 WHERE "lego_baseset"."id" = 242939
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 242939 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()

/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" = 132023
 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 132023 LIMIT 21
3 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()
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_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"
  FROM "lego_baseset"
 WHERE "lego_baseset"."id" = 153926
 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 153926 LIMIT 21
5 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(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" = 157216)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 157216)
 1.05

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./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-013312%')
 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-013312%') ORDER BY "blog_article"."published_date" ASC
 0.33

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/models/sets.py in get_set_review(1393)
  for review in reviews:
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-22T09:04:24.754333+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.754406+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.754319+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.754533+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T09:04:24.754333+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.754406+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.754319+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.754533+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries. 		1.82

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./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-22T09:04:24.754333+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.754406+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.754319+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.754533+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-22T09:04:24.754333+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.754406+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.754319+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.754533+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1
3 similar queries. 		1.27

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(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
SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_set"."baseset_ptr_id",
       "lego_set"."start_date",
       "lego_set"."end_date"
  FROM "lego_set"
 INNER JOIN "lego_baseset"
    ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_set"."baseset_ptr_id" = 157216
 LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_set"."baseset_ptr_id" = 157216 LIMIT 21
 0.13

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
  return render(request, 'sets/set_details.html', context)
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
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"
  FROM "auth_user"
 WHERE "auth_user"."id" = 83025
 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 83025 LIMIT 21
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)
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
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"
  FROM "auth_user"
 WHERE "auth_user"."id" = 83025
 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 83025 LIMIT 21
2 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)
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" = 157216 OR "lego_setrelationship"."set_child_id" = 157216))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" = 157216 OR "lego_setrelationship"."set_child_id" = 157216))
 0.31

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in 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-22T09:04:24.769846+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.769921+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.769835+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.770043+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T09:04:24.769846+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.769921+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.769835+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.770043+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries. 		1.31

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./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-22T09:04:24.769846+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.769921+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.769835+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.770043+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-22T09:04:24.769846+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.769921+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.769835+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.770043+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1
3 similar queries. 		1.12

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
  banner = banners.order_by('-area', '?')[0]
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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 257377
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 257377 LIMIT 21
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" = 639200
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 639200 LIMIT 21
10 similar queries. 		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(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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 108165
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 108165 LIMIT 21
10 similar queries. 		0.23

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(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" = 366293
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 366293 LIMIT 21
10 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(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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 90822
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 90822 LIMIT 21
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" = 485545
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 485545 LIMIT 21
10 similar queries. 		0.15

Connection: default

Transaction status: Idle

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

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

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

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

/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(765)
  url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 185959
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 185959 LIMIT 21
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" = 378294
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 378294 LIMIT 21
10 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(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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 48938
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 48938 LIMIT 21
10 similar queries. 		0.17

Connection: default

Transaction status: Idle

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

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

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

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

/home/nathan/rb/site/./lego/models/sets.py in get_moc(830)
  elif hasattr(self, 'moc'):
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" = 95169
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 95169 LIMIT 21
10 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(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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 79276
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 79276 LIMIT 21
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" = 314295
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 314295 LIMIT 21
10 similar queries. Duplicated 2 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(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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 85173
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 85173 LIMIT 21
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" = 314295
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 314295 LIMIT 21
10 similar queries. Duplicated 2 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
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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 107672
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 107672 LIMIT 21
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" = 475778
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 475778 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
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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 182523
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 182523 LIMIT 21
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" = 911512
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 911512 LIMIT 21
10 similar queries. 		0.21

Connection: default

Transaction status: Idle

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

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

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

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

/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(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 "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_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 WHERE "lego_moc"."baseset_ptr_id" = 246972
 LIMIT 21SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_moc"."baseset_ptr_id" = 246972 LIMIT 21
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" = 608227
 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 608227 LIMIT 21
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
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-22T09:04:24.798892+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.798962+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.798881+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.799081+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T09:04:24.798892+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.798962+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.798881+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.799081+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries. 		1.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/./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-22T09:04:24.798892+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.798962+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.798881+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.799081+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-22T09:04:24.798892+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T09:04:24.798962+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-01-22T09:04:24.798881+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T09:04:24.799081+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1
3 similar queries. 		1.12

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
  banner = banners.order_by('-area', '?')[0]
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.