Please note that BrickLink and Brickowl list this Minifigure with the complete Backpack. These parts are additional assembly that doesn't require the separation of the Minifigure and thus do not qualify to be listed under the Minifigures entry on Rebrickable. Please check import/exports for discrepancies.
default
390.65 ms (158 queries
including 136 similar
and 41 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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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-005607' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-005607' LIMIT 21
2 similar queries.
Duplicated 2 times.
8.85
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(100)
figure = get_or_none(Figure.all_objects, set_num=slug1)/home/nathan/rb/site/./rb/utils.py in get_or_none(734)
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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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-005607' LIMIT 21SELECT ••• FROM "lego_figure" INNER JOIN "lego_baseset" ON ("lego_figure"."baseset_ptr_id" = "lego_baseset"."id") WHERE "lego_baseset"."set_num" = 'fig-005607' LIMIT 21
2 similar queries.
Duplicated 2 times.
0.30
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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" = 57706 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 57706 LIMIT 21
11 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(293)
inventory = figure.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
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-005607' ANDNOT ("lego_changelog"."model" = 'PendingMoc')) ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE ("lego_changelog"."set_num" = 'fig-005607' ANDNOT ("lego_changelog"."model" = 'PendingMoc')) ORDER BY "lego_changelog"."timestamp" DESC
1.37
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./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(1169)
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" = 56737 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 56737 LIMIT 21
11 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(298)
figure.stats.inc_hits()/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)
/home/nathan/rb/site/./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(2713)
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-11-16'::date AND "lego_setstatshistory"."set_id" = 56737) LIMIT 21SELECT ••• FROM "lego_setstatshistory" WHERE ("lego_setstatshistory"."day" = '2026-11-16'::date AND "lego_setstatshistory"."set_id" = 56737) LIMIT 21
0.23
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(298)
figure.stats.inc_hits()/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2714)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2663)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./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(2714)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2663)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./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(2714)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2663)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./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(2714)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2663)
self, created = cls.objects.get_or_create(set=set, day=timezone.now())
/home/nathan/rb/site/./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(2714)
SetStatsHistory.inc_hits(self.set)/home/nathan/rb/site/./lego/models/sets.py in inc_hits(2665)
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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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" = 56737 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" = 56737 AND "lego_baseset"."set_type" = 'Set') ORDER BY "lego_baseset"."name" ASC
0.93
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./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" = 42612) LIMIT 21SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."id" = 42612) 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(328)
s.inventory = get_or_none(Inventory.objects, id=s.inventory2)/home/nathan/rb/site/./rb/utils.py in get_or_none(734)
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" = 696 LIMIT 21SELECT ••• FROM "lego_theme" WHERE "lego_theme"."id" = 696 LIMIT 21
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(331)
context['similar_sets'] = figure.get_similar_sets(10)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_similar_sets(1401)
""", {'theme': self.theme.name,
SELECTDISTINCT "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" = 56737) 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" = 56737) GROUP BY "taggit_tag"."id"
2 similar queries.
Duplicated 2 times.
61.22
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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(1403)
'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", 'AIM Agent with Neck Bracket')*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", 'Super Heroes Marvel')/3
+ similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2
+ similarity(substr("lego_baseset"."descr",0,100), 'Please note that BrickLink and Brickowl list this Minifigure with the complete Backpack. These parts') ) * 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) % 'AIM Agent with Neck Bracket 696')
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", 'AIM Agent with Neck Bracket')*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", 'Super Heroes Marvel')/3
+ similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2
+ similarity(substr("lego_baseset"."descr",0,100), 'Please note that BrickLink and Brickowl list this Minifigure with the complete Backpack. These parts') ) * 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" = trueAND ((lego_baseset.name || ' ' || lego_baseset.theme_id::text) % 'AIM Agent with Neck Bracket 696')
ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESCLIMIT 10
66.72
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(331)
context['similar_sets'] = figure.get_similar_sets(10)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./lego/models/sets.py in get_similar_sets(1412)
qs = list(qs)
SELECTDISTINCT "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" = 56737) 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" = 56737) GROUP BY "taggit_tag"."id"
2 similar queries.
Duplicated 2 times.
57.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(1403)
'tag_ids': ' '.join(str(t.id) for t in self.get_tags() if t.id != 4), # 4 == moc
set pg_trgm.similarity_threshold = 0.1; SELECT "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id",
"lego_baseset"."num_parts", "lego_baseset"."is_active", "lego_baseset"."is_accessory",
"lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt",
"lego_baseset"."last_modified_by_id", "lego_baseset"."set_type", "lego_baseset"."primary_photo_id",
"lego_setstatstotal"."likes",
lego_theme.name as theme_name, lego_theme.parent_id as theme_parent,
lego_baseset.id,
(SIMILARITY ("lego_baseset"."name", 'AIM Agent with Neck Bracket')*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", 'Super Heroes Marvel')/3
+ similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2
+ similarity(substr("lego_baseset"."descr",0,100), 'Please note that BrickLink and Brickowl list this Minifigure with the complete Backpack. These parts') ) * 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) % 'AIM Agent with Neck Bracket 696')
ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESC LIMIT 10
set pg_trgm.similarity_threshold = 0.1;
SELECT "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id",
"lego_baseset"."num_parts", "lego_baseset"."is_active", "lego_baseset"."is_accessory",
"lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt",
"lego_baseset"."last_modified_by_id", "lego_baseset"."set_type", "lego_baseset"."primary_photo_id",
"lego_setstatstotal"."likes",
lego_theme.name as theme_name, lego_theme.parent_id as theme_parent,
lego_baseset.id,
(SIMILARITY ("lego_baseset"."name", 'AIM Agent with Neck Bracket')*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", 'Super Heroes Marvel')/3
+ similarity(coalesce("lego_theme"."parent_id",0)::text, '0')/2
+ similarity(substr("lego_baseset"."descr",0,100), 'Please note that BrickLink and Brickowl list this Minifigure with the complete Backpack. These parts') ) * 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" = trueAND ((lego_baseset.name || ' ' || lego_baseset.theme_id::text) % 'AIM Agent with Neck Bracket 696')
ORDER BY "similarity" DESC, "lego_setstatstotal"."likes" DESC, "lego_baseset"."num_parts" DESCLIMIT 10
159.92
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./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(1412)
qs = list(qs)
SELECT COUNT(*) AS "__count" FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 56737)SELECT ••• FROM "lego_setphoto" WHERE (NOT "lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 56737)
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" = 56737SELECT ••• FROM "lego_setmap" WHERE "lego_setmap"."set_id" = 56737
0.41
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./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(2058)
for set_map in SetMap.objects.filter(set=self):
/home/nathan/rb/site/./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(2062)
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(3055)
if self.set.is_figure:
/home/nathan/rb/site/./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(2062)
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(3065)
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" = 120545 LIMIT 21SELECT ••• FROM "lego_setphoto" WHERE "lego_setphoto"."id" = 120545 LIMIT 21
2 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/models/sets.py in img_dir(785)
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 }}
/home/nathan/rb/site/./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(785)
file_dir = self.primary_photo.get_img_dir()/home/nathan/rb/site/./lego/models/sets.py in get_img_dir(3210)
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 }}
SELECT "rb_sitesettings"."id", "rb_sitesettings"."name", "rb_sitesettings"."value" FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21SELECT ••• FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./rb/templatetags/rb_settings.py in site_message(147)
message = SiteSettings.get_site_message()/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./rb/models/site.py in get_site_message(24)
setting = cls.objects.get(name=SiteSettings.SITE_MESSAGE)
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.16
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./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(253)
country = Country.objects.get(iso=country_code)
74
</a>
75
</li>
76
<li>
77
{% geo_currency request.user %}
78
</li>
79
{% comment %}
80
<li class="hidden-xs hidden-sm">
81
<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>
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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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" AS "inventory__set_id" FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 56737) 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" = 56737) AND "lego_baseset"."set_type" = 'Set')
2 similar queries.
Duplicated 2 times.
0.74
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./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:
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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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" AS "inventory__set_id" FROM "lego_invset" U0 INNER JOIN "lego_inventory" U2 ON (U0."inventory_id" = U2."id") WHERE U0."inv_set_id" = 56737) 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" = 56737) AND "lego_baseset"."set_type" = 'Set')
2 similar queries.
Duplicated 2 times.
0.59
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/models/figures.py in get_theme(106)
if parents:
SELECT COUNT(*) AS "__count" FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 56737)SELECT ••• FROM "lego_setphoto" WHERE ("lego_setphoto"."is_active" AND "lego_setphoto"."set_id" = 56737)
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)
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 #}
SELECT COUNT(*) AS "__count" FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 56737)SELECT ••• FROM "lego_inventory" WHERE ("lego_inventory"."is_active" AND "lego_inventory"."set_id" = 56737)
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/models/sets.py in get_num_inventories(1028)
return Inventory.objects.filter(set=self).count()
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-005607%') 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-005607%') 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(1444)
for review in reviews:
120
{% endif %}
121
</table>
122
123
{% with set.get_set_review as review %}
124
{% if review %}
125
<p>See our review:</p>
126
{% include 'blog/includes/render_posts_preview.html' with article=review %}
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-11-16T00:28:20.119092+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.119175+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.119076+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.119306+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:28:20.119092+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.119175+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.119076+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.119306+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries.
2.91
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./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:
193
{% endcache %}
194
195
{# cant include banner in cache as it's region specific #}
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-11-16T00:28:20.119092+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.119175+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.119076+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.119306+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-11-16T00:28:20.119092+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.119175+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.119076+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.119306+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
3 similar queries.
2.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/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
193
{% endcache %}
194
195
{# cant include banner in cache as it's region specific #}
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"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_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."active_change_dt", T3."active_change_by_id", T3."last_checked_for_bi", T3."descr", T3."primary_photo_id", T3."primary_moc_image_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" = 56737 OR "lego_setrelationship"."set_child_id" = 56737))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" = 56737 OR "lego_setrelationship"."set_child_id" = 56737))
0.72
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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(1906)
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(1453)
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(3301)
if len(starting_rels) == 0:
SELECT "lego_setrelationship"."id", "lego_setrelationship"."set_parent_id", "lego_setrelationship"."set_child_id", "lego_setrelationship"."rel_type", T3."id", T3."set_num", T3."name", T3."year", T3."theme_id", T3."set_type", T3."num_parts", T3."default_inventory_id", T3."is_active", T3."is_accessory", T3."added_dt", T3."added_by_id", T3."last_modified_dt", T3."last_modified_by_id", T3."active_change_dt", T3."active_change_by_id", T3."last_checked_for_bi", T3."descr", T3."primary_photo_id", T3."primary_moc_image_id", T3."is_gear", T3."is_book", T3."search_vector", T3."mfhash_vector" FROM "lego_setrelationship" INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."set_parent_id" = 56737 AND "lego_setrelationship"."rel_type" = 'C')SELECT ••• FROM "lego_setrelationship" INNER JOIN "lego_baseset" T3 ON ("lego_setrelationship"."set_child_id" = T3."id") WHERE ("lego_setrelationship"."set_parent_id" = 56737 AND "lego_setrelationship"."rel_type" = 'C')
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 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(1906)
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(1453)
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(3312)
sets = [r.set_child for r in rels]
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-11-16T00:28:20.142593+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.142665+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.142579+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.142790+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:28:20.142593+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.142665+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.142579+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.142790+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries.
2.19
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
193
{% endcache %}
194
195
{# cant include banner in cache as it's region specific #}
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-11-16T00:28:20.142593+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.142665+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.142579+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.142790+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-11-16T00:28:20.142593+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.142665+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.142579+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.142790+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
3 similar queries.
3.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/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
193
{% endcache %}
194
195
{# cant include banner in cache as it's region specific #}
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 225787 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 225787 LIMIT 21
11 similar queries.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 221852 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 221852 LIMIT 21
11 similar queries.
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(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 163432 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 163432 LIMIT 21
10 similar queries.
0.14
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 LIMIT 21
10 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 221852 LIMIT 21
20 similar queries.
Duplicated 2 times.
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(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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 163432 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 163432 LIMIT 21
10 similar queries.
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(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21
10 similar queries.
Duplicated 5 times.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21
10 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21
20 similar queries.
Duplicated 2 times.
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(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 277570 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 277570 LIMIT 21
11 similar queries.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 273466 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 273466 LIMIT 21
11 similar queries.
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(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 1179396 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1179396 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(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21
10 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/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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 273466 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 1179396 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 1179396 LIMIT 21
10 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 7 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 7 LIMIT 21
10 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/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 LIMIT 21
20 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)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 281430 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 281430 LIMIT 21
11 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 277321 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 277321 LIMIT 21
11 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 552019 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 552019 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(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 LIMIT 21
10 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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 277321 LIMIT 21
20 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)/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 552019 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 552019 LIMIT 21
10 similar queries.
0.33
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(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 5 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 5 LIMIT 21
10 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/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 125625 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 125625 LIMIT 21
11 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 123051 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 123051 LIMIT 21
11 similar queries.
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(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 335559 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 335559 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(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 LIMIT 21
10 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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 123051 LIMIT 21
20 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)/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 335559 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 335559 LIMIT 21
10 similar queries.
0.21
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(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 5 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 5 LIMIT 21
10 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/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 LIMIT 21
20 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)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 168873 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 168873 LIMIT 21
11 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 165420 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 165420 LIMIT 21
11 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 815195 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 815195 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(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 LIMIT 21
10 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/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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 165420 LIMIT 21
20 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)/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 815195 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 815195 LIMIT 21
10 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 6 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 6 LIMIT 21
10 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/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT 1 AS "a" FROM "lego_mocswitherrors" WHERE ("lego_mocswitherrors"."error_type" = 'inventory' AND "lego_mocswitherrors"."moc_id" = 165420) LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE ("lego_mocswitherrors"."error_type" = 'inventory' AND "lego_mocswitherrors"."moc_id" = 165420) LIMIT 1
2 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/mocs.py in is_alternate(206)
if not self.is_pending and MocsWithErrors.objects.filter(moc=self, error_type='inventory').exists():
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21
10 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21
20 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)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 85983 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 85983 LIMIT 21
11 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 84206 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 84206 LIMIT 21
11 similar queries.
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(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 456724 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 456724 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(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21
10 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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 84206 LIMIT 21
20 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)/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 456724 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 456724 LIMIT 21
10 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 5 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 5 LIMIT 21
10 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/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21
10 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21
20 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)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 15517 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 15517 LIMIT 21
11 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(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 12368 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 12368 LIMIT 21
11 similar queries.
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(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 5624 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 5624 LIMIT 21
10 similar queries.
0.14
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21
10 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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12368 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 5624 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 5624 LIMIT 21
10 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21
10 similar queries.
Duplicated 5 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/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21
10 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/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21
20 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)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 70832 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 70832 LIMIT 21
11 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/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 69650 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 69650 LIMIT 21
11 similar queries.
0.14
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 161946 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 161946 LIMIT 21
10 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(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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21
10 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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69650 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 161946 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 161946 LIMIT 21
10 similar queries.
Duplicated 2 times.
0.18
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21
10 similar queries.
Duplicated 5 times.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21
10 similar queries.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 11299 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 11299 LIMIT 21
11 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 12403 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 12403 LIMIT 21
11 similar queries.
0.13
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 19510 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 19510 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(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21
10 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 12403 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 19510 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 19510 LIMIT 21
10 similar queries.
0.16
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(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21
10 similar queries.
Duplicated 5 times.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
SELECT 1 AS "a" FROM "lego_mocswitherrors" WHERE ("lego_mocswitherrors"."error_type" = 'inventory' AND "lego_mocswitherrors"."moc_id" = 12403) LIMIT 1SELECT ••• FROM "lego_mocswitherrors" WHERE ("lego_mocswitherrors"."error_type" = 'inventory' AND "lego_mocswitherrors"."moc_id" = 12403) LIMIT 1
2 similar queries.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/mocs.py in is_alternate(206)
if not self.is_pending and MocsWithErrors.objects.filter(moc=self, error_type='inventory').exists():
SELECT "lego_baseset"."id", "lego_baseset"."default_inventory_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 LIMIT 21
10 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 LIMIT 21
20 similar queries.
Duplicated 2 times.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
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" = 70835 LIMIT 21SELECT ••• FROM "lego_inventory" WHERE "lego_inventory"."id" = 70835 LIMIT 21
11 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(24)
inventory = set.get_default_inventory()/home/nathan/rb/site/./lego/models/sets.py in get_default_inventory(1018)
if self.default_inventory is not None:
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" = 69653 LIMIT 21SELECT ••• FROM "lego_setstatstotal" WHERE "lego_setstatstotal"."set_id" = 69653 LIMIT 21
11 similar queries.
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(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',/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)
/home/nathan/rb/site/./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 get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/sets.py in get_moc(870)
elif hasattr(self, 'moc'):
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
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" = 161946 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 161946 LIMIT 21
10 similar queries.
Duplicated 2 times.
0.16
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./lego/templatetags/sets/drawing.py in render_set(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in get_absolute_url(628)
return self.get_moc().get_absolute_url()/home/nathan/rb/site/./lego/models/mocs.py in get_absolute_url(840)
url = "/mocs/{0}/{1}/{2}/".format(self.set_num, parse.quote(self.designer.username, safe=''), slug)
41
{# cache 3600 'render_set_img_tn_2' set.id tn_options mtime set.get_absolute_url #} {# about 40ms for 50 images in debug, disabled as pending moc preview never works #}
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."primary_moc_image_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 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(32)
return render_to_string('sets/render_set.html',/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
img = self.primary_moc_image
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "lego_baseset"."id", "lego_baseset"."theme_id" FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 LIMIT 21SELECT ••• FROM "lego_baseset" WHERE "lego_baseset"."id" = 69653 LIMIT 21
20 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)/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(771)
img = self.primary_moc_image/home/nathan/rb/site/./lego/models/sets.py in __init__(563)
self.__original_theme_id = self.theme_id # Need actual value or changes can't be detected
42
{# Image #}
43
<div class="rb-card__image {% 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 %}
SELECT "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent" FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 161946 LIMIT 21SELECT ••• FROM "accounts_userplan" WHERE "accounts_userplan"."user_id" = 161946 LIMIT 21
10 similar queries.
Duplicated 2 times.
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(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',/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)
SELECT "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly" FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21SELECT ••• FROM "plans_plan" WHERE "plans_plan"."id" = 1 LIMIT 21
10 similar queries.
Duplicated 5 times.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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/./accounts/models/users.py in is_free(512)
return self.plan.is_free()
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-11-16T00:28:20.267588+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.267659+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.267570+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.267782+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:28:20.267588+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.267659+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.267570+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.267782+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
3 similar queries.
2.27
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(343)
return render(request, 'sets/set_details.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
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-11-16T00:28:20.267588+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.267659+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.267570+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.267782+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-11-16T00:28:20.267588+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:28:20.267659+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:28:20.267570+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-16T00:28:20.267782+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
3 similar queries.
2.04
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/figures.py in find_minifigs(102)
return figure_details(request, slug1)/home/nathan/rb/site/./lego/views/figures.py in figure_details(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]