LEGO PART 51 Technic Panel Dome 6 x 6 x 5 2/3 | Rebrickable

This part may not exist in real life. Please use a specific mold or print variation instead.

Element

LDraw

Photo

to your account to add or reply to comments.

Help Guide - Buying LEGO Parts

Include BrickLink Stores

Include BrickOwl Stores

Include Independent Stores

Include Stores from all Regions (Default: US)

Include Used/2nd Hand Parts

Create an account to change the default filters used.

See all related parts via Search

Prints:

51

Category	Technic Panels
Year	Unused
Material	Plastic
Num Sets	0
Num Set Parts	0
Num MOCs	0
Num MOC Parts	0

Submit Photo

External Sites

This part is known differently at other sites:

LEGO	51
BrickLink	51
BrickOwl	51
Brickset	51
LDraw	32272

Feb. 17, 2021, 1:32 p.m. by TobyMac

July 24, 2025, 1:07 p.m. by Jimboblimb

Search Change Log for 51

Pin Female 2200

DJDT

Time

Resource usage

Resource	Value
User CPU time	288.438 msec
System CPU time	0.000 msec
Total CPU time	288.438 msec
Elapsed time	312.636 msec
Context switches	91 voluntary, 4 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 25.16 ms (42 queries including 25 similar and 12 duplicates )

Query Timeline Time (ms) Action

SELECT "lego_part"."id",
       "lego_part"."part_num",
       "lego_part"."name",
       "lego_part"."part_cat_id",
       "lego_part"."notes",
       "lego_part"."is_active",
       "lego_part"."search_vector",
       "lego_part"."ldraw_part_id",
       "lego_part"."bricklink_part_id",
       "lego_part"."ignore_color_errors",
       "lego_part"."part_material_id",
       "lego_part"."is_bricklink_minifig",
       "lego_part"."is_bricklink_book",
       "lego_part"."is_bricklink_gear",
       "lego_part"."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partmaterial"."id",
       "lego_partmaterial"."name",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_part"
INNER JOIN "lego_partcategory"
    ON ("lego_part"."part_cat_id" = "lego_partcategory"."id")
INNER JOIN "lego_partmaterial"
    ON ("lego_part"."part_material_id" = "lego_partmaterial"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON ("lego_part"."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON ("lego_part"."id" = "lego_partstats"."part_id")
WHERE "lego_part"."part_num" = '51'
LIMIT 21SELECT ••• FROM "lego_part" INNER JOIN "lego_partcategory" ON ("lego_part"."part_cat_id" = "lego_partcategory"."id") INNER JOIN "lego_partmaterial" ON ("lego_part"."part_material_id" = "lego_partmaterial"."id") LEFT OUTER JOIN "lego_partoverlay" ON ("lego_part"."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") WHERE "lego_part"."part_num" = '51' LIMIT 21

2 similar queries. Duplicated 2 times.

0.67

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(122)
  part = get_or_none(Part.all_objects, part_num=slug1)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

SELECT "lego_element"."id",
       "lego_element"."part_id",
       "lego_element"."color_id",
       "lego_element"."element_id",
       "lego_element"."design_id",
       "lego_element"."descr",
       "lego_element"."color_descr",
       "lego_element"."last_download_attempt",
       "lego_element"."num_download_attempts",
       "lego_element"."is_export_id",
       "lego_element"."is_active"
  FROM "lego_element"
INNER JOIN "lego_color"
    ON ("lego_element"."color_id" = "lego_color"."id")
WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (14601))
ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASCSELECT ••• FROM "lego_element" INNER JOIN "lego_color" ON ("lego_element"."color_id" = "lego_color"."id") WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (14601)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC

2 similar queries. Duplicated 2 times.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(122)
  part = get_or_none(Part.all_objects, part_num=slug1)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

SELECT "lego_partcolorstats"."id",
       "lego_partcolorstats"."part_id",
       "lego_partcolorstats"."color_id",
       "lego_partcolorstats"."num_sets",
       "lego_partcolorstats"."num_mocs",
       "lego_partcolorstats"."num_set_parts",
       "lego_partcolorstats"."num_moc_parts",
       "lego_partcolorstats"."y1",
       "lego_partcolorstats"."y2",
       "lego_partcolorstats"."is_dirty",
       "lego_partcolorstats"."ignore_color_errors"
  FROM "lego_partcolorstats"
WHERE "lego_partcolorstats"."part_id" IN (14601)SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (14601)

2 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(122)
  part = get_or_none(Part.all_objects, part_num=slug1)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

SELECT "lego_partcost"."id",
       "lego_partcost"."part_id",
       "lego_partcost"."color_id",
       "lego_partcost"."is_used",
       "lego_partcost"."cost_avg",
       "lego_partcost"."cost_min",
       "lego_partcost"."cost_max",
       "lego_partcost"."cost_count"
  FROM "lego_partcost"
WHERE "lego_partcost"."part_id" IN (14601)SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (14601)

2 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(122)
  part = get_or_none(Part.all_objects, part_num=slug1)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

2 similar queries. Duplicated 2 times.

0.08

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(122)
  part = get_or_none(Part.all_objects, part_num=slug1)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

2 similar queries. Duplicated 2 times.

0.35

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(362)
  part = get_object_or_404(Part.all_objects, part_num=part_num)

2 similar queries. Duplicated 2 times.

0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(362)
  part = get_object_or_404(Part.all_objects, part_num=part_num)

2 similar queries. Duplicated 2 times.

0.07

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(362)
  part = get_object_or_404(Part.all_objects, part_num=part_num)

2 similar queries. Duplicated 2 times.

0.06

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(362)
  part = get_object_or_404(Part.all_objects, part_num=part_num)

2 similar queries. Duplicated 2 times.

0.06

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(362)
  part = get_object_or_404(Part.all_objects, part_num=part_num)

SELECT "lego_partcolorstats"."id",
       "lego_partcolorstats"."part_id",
       "lego_partcolorstats"."color_id",
       "lego_partcolorstats"."num_sets",
       "lego_partcolorstats"."num_mocs",
       "lego_partcolorstats"."num_set_parts",
       "lego_partcolorstats"."num_moc_parts",
       "lego_partcolorstats"."y1",
       "lego_partcolorstats"."y2",
       "lego_partcolorstats"."is_dirty",
       "lego_partcolorstats"."ignore_color_errors"
  FROM "lego_partcolorstats"
WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."part_id" = 14601)
ORDER BY "lego_partcolorstats"."num_set_parts" DESC
LIMIT 1SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."part_id" = 14601) ORDER BY "lego_partcolorstats"."num_set_parts" DESC LIMIT 1

3 similar queries.

0.09

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(372)
  part.img_element = part.get_img_dir(force_use_element=True)

/home/nathan/rb/site/./lego/models/parts.py in get_img_dir(536)
  most_common_color_id = self.get_most_common_color()

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

/home/nathan/rb/site/./lego/models/parts.py in get_most_common_color(323)
  pcs = PartColorStats.objects.filter(part=self, num_sets__gt=0).order_by('-num_set_parts').first()

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type"
  FROM "lego_partrelationship"
WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'S')

0.09

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(375)
  part.meta_img = part.get_img_dir()

/home/nathan/rb/site/./lego/models/parts.py in get_img_dir(607)
  similar_part = self.get_similar_part()

/home/nathan/rb/site/./lego/models/parts.py in get_similar_part(352)
  if parent_rel:

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_child_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'B' AND NOT ("lego_partrelationship"."part_child_id" = 14601))
ORDER BY "lego_partstats"."num_sets" DESCSELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_child_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'B' AND NOT ("lego_partrelationship"."part_child_id" = 14601)) ORDER BY "lego_partstats"."num_sets" DESC

4 similar queries.

0.42

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(379)
  subparts = sorted(part.get_related_subparts_child(), key=lambda x: x.part_num)

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_subparts_child(768)
  return self.get_related_children(PartRelationship.REL_TYPE_SUBPART)

/home/nathan/rb/site/./lego/models/parts.py in get_related_children(743)
  return [p.part_child for p in parts]

SELECT "lego_partrelationshipflat"."part_id",
       "lego_partrelationshipflat"."a",
       "lego_partrelationshipflat"."m",
       "lego_partrelationshipflat"."p",
       "lego_partrelationshipflat"."am",
       "lego_partrelationshipflat"."ap",
       "lego_partrelationshipflat"."mp",
       "lego_partrelationshipflat"."amp"
  FROM "lego_partrelationshipflat"
WHERE ("lego_partrelationshipflat"."am" IS NOT NULL AND "lego_partrelationshipflat"."part_id" = 14601)
LIMIT 21SELECT ••• FROM "lego_partrelationshipflat" WHERE ("lego_partrelationshipflat"."am" IS NOT NULL AND "lego_partrelationshipflat"."part_id" = 14601) LIMIT 21

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(380)
  alts_molds = sorted(part.get_related_alts_and_molds(), key=lambda x: x.part_num)  # Follows nested alts/molds relationships

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_alts_and_molds(829)
  part_rel_flat = PartRelationshipFlat.objects.get(part=self, am__isnull=False)

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_child_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'P' AND NOT ("lego_partrelationship"."part_child_id" = 14601))
ORDER BY "lego_partstats"."num_sets" DESCSELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_child_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'P' AND NOT ("lego_partrelationship"."part_child_id" = 14601)) ORDER BY "lego_partstats"."num_sets" DESC

4 similar queries.

0.46

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(383)
  prints = sorted(part.get_related_prints_child(), key=lambda x: x.part_num)

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_prints_child(750)
  return self.get_related_children(PartRelationship.REL_TYPE_PRINT, limit=limit)

/home/nathan/rb/site/./lego/models/parts.py in get_related_children(743)
  return [p.part_child for p in parts]

SELECT "lego_element"."id",
       "lego_element"."part_id",
       "lego_element"."color_id",
       "lego_element"."element_id",
       "lego_element"."design_id",
       "lego_element"."descr",
       "lego_element"."color_descr",
       "lego_element"."last_download_attempt",
       "lego_element"."num_download_attempts",
       "lego_element"."is_export_id",
       "lego_element"."is_active"
  FROM "lego_element"
INNER JOIN "lego_color"
    ON ("lego_element"."color_id" = "lego_color"."id")
WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (22817, 8445))
ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASCSELECT ••• FROM "lego_element" INNER JOIN "lego_color" ON ("lego_element"."color_id" = "lego_color"."id") WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (22817, 8445)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC

0.21

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(383)
  prints = sorted(part.get_related_prints_child(), key=lambda x: x.part_num)

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_prints_child(750)
  return self.get_related_children(PartRelationship.REL_TYPE_PRINT, limit=limit)

/home/nathan/rb/site/./lego/models/parts.py in get_related_children(743)
  return [p.part_child for p in parts]

SELECT "lego_partcolorstats"."id",
       "lego_partcolorstats"."part_id",
       "lego_partcolorstats"."color_id",
       "lego_partcolorstats"."num_sets",
       "lego_partcolorstats"."num_mocs",
       "lego_partcolorstats"."num_set_parts",
       "lego_partcolorstats"."num_moc_parts",
       "lego_partcolorstats"."y1",
       "lego_partcolorstats"."y2",
       "lego_partcolorstats"."is_dirty",
       "lego_partcolorstats"."ignore_color_errors"
  FROM "lego_partcolorstats"
WHERE "lego_partcolorstats"."part_id" IN (22817, 8445)SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (22817, 8445)

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(383)
  prints = sorted(part.get_related_prints_child(), key=lambda x: x.part_num)

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_prints_child(750)
  return self.get_related_children(PartRelationship.REL_TYPE_PRINT, limit=limit)

/home/nathan/rb/site/./lego/models/parts.py in get_related_children(743)
  return [p.part_child for p in parts]

SELECT "lego_partcost"."id",
       "lego_partcost"."part_id",
       "lego_partcost"."color_id",
       "lego_partcost"."is_used",
       "lego_partcost"."cost_avg",
       "lego_partcost"."cost_min",
       "lego_partcost"."cost_max",
       "lego_partcost"."cost_count"
  FROM "lego_partcost"
WHERE "lego_partcost"."part_id" IN (22817, 8445)SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (22817, 8445)

0.08

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(383)
  prints = sorted(part.get_related_prints_child(), key=lambda x: x.part_num)

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_prints_child(750)
  return self.get_related_children(PartRelationship.REL_TYPE_PRINT, limit=limit)

/home/nathan/rb/site/./lego/models/parts.py in get_related_children(743)
  return [p.part_child for p in parts]

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_child_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'T' AND NOT ("lego_partrelationship"."part_child_id" = 14601))
ORDER BY "lego_partstats"."num_sets" DESCSELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_child_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'T' AND NOT ("lego_partrelationship"."part_child_id" = 14601)) ORDER BY "lego_partstats"."num_sets" DESC

4 similar queries.

0.41

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(384)
  patterns = sorted(part.get_related_patterns_child(), key=lambda x: x.part_num)

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_patterns_child(759)
  return self.get_related_children(PartRelationship.REL_TYPE_PATTERN, limit=limit)

/home/nathan/rb/site/./lego/models/parts.py in get_related_children(743)
  return [p.part_child for p in parts]

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_child_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'R' AND NOT ("lego_partrelationship"."part_child_id" = 14601))
ORDER BY "lego_partstats"."num_sets" DESCSELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_child_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_parent_id" = 14601 AND "lego_partrelationship"."rel_type" = 'R' AND NOT ("lego_partrelationship"."part_child_id" = 14601)) ORDER BY "lego_partstats"."num_sets" DESC

4 similar queries.

0.33

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(385)
  pairs = part.get_related_pairs()

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_pairs(854)
  children = self.get_related_children(PartRelationship.REL_TYPE_PAIR)

/home/nathan/rb/site/./lego/models/parts.py in get_related_children(743)
  return [p.part_child for p in parts]

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_parent_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'R' AND NOT ("lego_partrelationship"."part_parent_id" = 14601))
ORDER BY "lego_partstats"."num_sets" DESCSELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_parent_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'R' AND NOT ("lego_partrelationship"."part_parent_id" = 14601)) ORDER BY "lego_partstats"."num_sets" DESC

2 similar queries.

0.35

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(385)
  pairs = part.get_related_pairs()

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_pairs(855)
  parents = self.get_related_parents(PartRelationship.REL_TYPE_PAIR)

/home/nathan/rb/site/./lego/models/parts.py in get_related_parents(714)
  return [p.part_parent for p in parts]

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_parent_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'P')
LIMIT 1SELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_parent_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'P') LIMIT 1

2 similar queries.

0.44

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(386)
  print_of = part.get_related_prints_parent()

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_prints_parent(773)
  return self.get_related_parent(PartRelationship.REL_TYPE_PRINT, query_related=query_related)

/home/nathan/rb/site/./lego/models/parts.py in get_related_parent(727)
  return parents[0].part_parent

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_parent_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'T')
LIMIT 1SELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_parent_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'T') LIMIT 1

2 similar queries.

0.40

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(387)
  pattern_of = part.get_related_patterns_parent()

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_patterns_parent(778)
  return self.get_related_parent(PartRelationship.REL_TYPE_PATTERN)

/home/nathan/rb/site/./lego/models/parts.py in get_related_parent(727)
  return parents[0].part_parent

SELECT "lego_partrelationship"."id",
       "lego_partrelationship"."part_parent_id",
       "lego_partrelationship"."part_child_id",
       "lego_partrelationship"."rel_type",
       T3."id",
       T3."part_num",
       T3."name",
       T3."part_cat_id",
       T3."notes",
       T3."is_active",
       T3."search_vector",
       T3."ldraw_part_id",
       T3."bricklink_part_id",
       T3."ignore_color_errors",
       T3."part_material_id",
       T3."is_bricklink_minifig",
       T3."is_bricklink_book",
       T3."is_bricklink_gear",
       T3."show_generic_part_msg",
       "lego_partcategory"."id",
       "lego_partcategory"."name",
       "lego_partcategory"."part_count",
       "lego_partcategory"."img",
       "lego_partcategory"."slug",
       "lego_partoverlay"."part_id",
       "lego_partoverlay"."length",
       "lego_partstats"."part_id",
       "lego_partstats"."num_sets",
       "lego_partstats"."num_mocs",
       "lego_partstats"."num_set_parts",
       "lego_partstats"."num_moc_parts",
       "lego_partstats"."y1",
       "lego_partstats"."y2",
       "lego_partstats"."is_dirty"
  FROM "lego_partrelationship"
INNER JOIN "lego_part" T3
    ON ("lego_partrelationship"."part_parent_id" = T3."id")
INNER JOIN "lego_partcategory"
    ON (T3."part_cat_id" = "lego_partcategory"."id")
  LEFT OUTER JOIN "lego_partoverlay"
    ON (T3."id" = "lego_partoverlay"."part_id")
  LEFT OUTER JOIN "lego_partstats"
    ON (T3."id" = "lego_partstats"."part_id")
WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'B' AND NOT ("lego_partrelationship"."part_parent_id" = 14601))
ORDER BY "lego_partstats"."num_sets" DESCSELECT ••• FROM "lego_partrelationship" INNER JOIN "lego_part" T3 ON ("lego_partrelationship"."part_parent_id" = T3."id") INNER JOIN "lego_partcategory" ON (T3."part_cat_id" = "lego_partcategory"."id") LEFT OUTER JOIN "lego_partoverlay" ON (T3."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON (T3."id" = "lego_partstats"."part_id") WHERE ("lego_partrelationship"."part_child_id" = 14601 AND "lego_partrelationship"."rel_type" = 'B' AND NOT ("lego_partrelationship"."part_parent_id" = 14601)) ORDER BY "lego_partstats"."num_sets" DESC

2 similar queries.

0.32

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(388)
  subpart_of = part.get_related_subparts_parents()

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

/home/nathan/rb/site/./lego/models/parts.py in get_related_subparts_parents(801)
  return self.get_related_parents(PartRelationship.REL_TYPE_SUBPART)

/home/nathan/rb/site/./lego/models/parts.py in get_related_parents(714)
  return [p.part_parent for p in parts]

select lego_color.id,
       lego_color.id as color_id,
       name as color_name,
       rgb,
       sum(num_set_parts) as num_set_parts,
       sum(num_moc_parts) as num_moc_parts,
       sum(num_sets) as num_sets,
       sum(num_mocs) as num_mocs,
       min(y1) as y1,
       max(y2) as y2
  from lego_color
  left outer join lego_PartColorStats
    on lego_PartColorStats.color_id = lego_Color.id
   and lego_PartColorStats.part_id = 14601
where lego_color.id not in (-1)
group by 1,
       2,
       3,
       4 select lego_color.id, lego_color.id as color_id, name as color_name, rgb, sum(num_set_parts) as num_set_parts, sum(num_moc_parts) as num_moc_parts, sum(num_sets) as num_sets, sum(num_mocs) as num_mocs, min(y1) as y1, max(y2) as y2 from lego_color left outer join lego_PartColorStats on lego_PartColorStats.color_id = lego_Color.id and lego_PartColorStats.part_id = 14601 where lego_color.id not in (-1) group by 1, 2, 3, 4

0.36

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(418)
  context['part_colors'] = PartColorStats.get_all_color_stats_for_part(part.id)

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

/home/nathan/rb/site/./lego/models/parts.py in get_all_color_stats_for_part(1767)
  for stat in stats:

SELECT "lego_element"."id",
       "lego_element"."part_id",
       "lego_element"."color_id",
       "lego_element"."element_id",
       "lego_element"."design_id",
       "lego_element"."descr",
       "lego_element"."color_descr",
       "lego_element"."last_download_attempt",
       "lego_element"."num_download_attempts",
       "lego_element"."is_export_id",
       "lego_element"."is_active"
  FROM "lego_element"
INNER JOIN "lego_color"
    ON ("lego_element"."color_id" = "lego_color"."id")
WHERE ("lego_element"."is_active" AND "lego_element"."is_export_id" AND "lego_element"."part_id" = 14601)
ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASCSELECT ••• FROM "lego_element" INNER JOIN "lego_color" ON ("lego_element"."color_id" = "lego_color"."id") WHERE ("lego_element"."is_active" AND "lego_element"."is_export_id" AND "lego_element"."part_id" = 14601) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC

0.22

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(425)
  elements_map = {e.color_id: e for e in elements}

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"."instance_id" = 14601 AND "lego_changelog"."model" = 'Part')
ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE ("lego_changelog"."instance_id" = 14601 AND "lego_changelog"."model" = 'Part') ORDER BY "lego_changelog"."timestamp" DESC

9.43

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(598)
  changes = part.get_change_summary()

/home/nathan/rb/site/./lego/models/parts.py in get_change_summary(961)
  changes = ChangeLog.get_changes(part_id=self.id)

/home/nathan/rb/site/./lego/models/changes.py in get_changes(276)
  if len(changes) > 0:

SELECT "lego_partmap"."id",
       "lego_partmap"."part_id",
       "lego_partmap"."ext_system",
       "lego_partmap"."ext_id",
       "lego_partmap"."is_export_id",
       "lego_partmap"."is_import_id"
  FROM "lego_partmap"
WHERE "lego_partmap"."part_id" = 14601
ORDER BY "lego_partmap"."is_export_id" DESC, "lego_partmap"."ext_id" ASCSELECT ••• FROM "lego_partmap" WHERE "lego_partmap"."part_id" = 14601 ORDER BY "lego_partmap"."is_export_id" DESC, "lego_partmap"."ext_id" ASC

0.21

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(600)
  context['mappings'] = part.get_ext_mappings()

/home/nathan/rb/site/./lego/models/parts.py in get_ext_mappings(1165)
  for part_map in self.mappings.order_by('-is_export_id', 'ext_id'):  # export first

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/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

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

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

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

/home/nathan/rb/site/rb/templates/rb/base_root.html

SELECT "lego_partphoto"."id",
       "lego_partphoto"."part_id",
       "lego_partphoto"."color_id",
       "lego_partphoto"."submitted_by_id",
       "lego_partphoto"."image",
       "lego_partphoto"."timestamp",
       "lego_partphoto"."is_active",
       "lego_partphoto"."is_primary",
       "lego_color"."id",
       "lego_color"."name",
       "lego_color"."rgb",
       "lego_color"."is_trans",
       "lego_color"."fuzzy_color_id",
       "lego_color"."is_active",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined"
  FROM "lego_partphoto"
INNER JOIN "lego_color"
    ON ("lego_partphoto"."color_id" = "lego_color"."id")
INNER JOIN "auth_user"
    ON ("lego_partphoto"."submitted_by_id" = "auth_user"."id")
WHERE ("lego_partphoto"."is_active" AND NOT "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 14601)SELECT ••• FROM "lego_partphoto" INNER JOIN "lego_color" ON ("lego_partphoto"."color_id" = "lego_color"."id") INNER JOIN "auth_user" ON ("lego_partphoto"."submitted_by_id" = "auth_user"."id") WHERE ("lego_partphoto"."is_active" AND NOT "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 14601)

0.28

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

55
56	`{% include 'parts/includes/render_part_large_images.html' %}`
57
58	`{% if secondary_photos %}`
59	`<div class="clearfix">`
60	`<div class="pull-right">`
61	`There are <a href="#" class="js-toggle-field" data-field="#secondary_photos">`
62	`{{ secondary_photos.count }} more photos <i class="fa fa-chevron-down"></i></a> of this Part`

/home/nathan/rb/site/lego/templates/parts/part_details.html

SELECT COUNT(*) AS "__count"
FROM "threadedcomments_comment"
INNER JOIN "django_comments"
ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE ("django_comments"."content_type_id" = 43 AND "django_comments"."object_pk" = '14601' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 43 AND "django_comments"."object_pk" = '14601' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

2 similar queries. Duplicated 2 times.

0.22

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

198	`<section class="padding-xxs">`
199
200	`<ul class="nav nav-tabs nav-top-border">`
201	`{% get_comment_count for part as num_comments %}`
202	`<li><a href="#tab_comments" data-toggle="tab">Comments <span class="badge badge-light">{{ num_comments }}</span></a>`
203	`</li>`
204	`<li><a href="#tab_buy_parts" data-toggle="tab">Buy Part <span class="badge badge-light" id="buy_parts_count"></span></a></li>`
205	`<li class="active"><a href="#tab_rel_parts" data-toggle="tab">Related Parts <span class="badge badge-light" id="rel_parts_count">{{ part.related.total_rels }}</span></a></li>`

/home/nathan/rb/site/lego/templates/parts/part_details.html

SELECT "django_content_type"."id",
       "django_content_type"."app_label",
       "django_content_type"."model"
  FROM "django_content_type"
WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'part')
LIMIT 21SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'part') LIMIT 21

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(78)
  content_type = ContentType.objects.get(app_label=page_content_type.split('.')[0], model=page_content_type.split('.')[1])

4	`{% load rb_comments_filters %}`
5
6	`<div id="comments-{{ page.id }}">`
7	`{% get_page_locked_status content_type page.id as is_page_locked %}`
8
9	`{% comment %}`
10	`Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.`
11	`Using fluent-comments to hide unused fields and do ajax add/reply comment.`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT 1 AS "a"
FROM "rb_comments_pagelocked"
WHERE ("rb_comments_pagelocked"."content_type_id" = 43 AND "rb_comments_pagelocked"."object_id" = 14601)
LIMIT 1SELECT ••• FROM "rb_comments_pagelocked" WHERE ("rb_comments_pagelocked"."content_type_id" = 43 AND "rb_comments_pagelocked"."object_id" = 14601) LIMIT 1

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(79)
  is_locked = PageLocked.objects.filter(content_type=content_type, object_id=page_id).exists()

4	`{% load rb_comments_filters %}`
5
6	`<div id="comments-{{ page.id }}">`
7	`{% get_page_locked_status content_type page.id as is_page_locked %}`
8
9	`{% comment %}`
10	`Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.`
11	`Using fluent-comments to hide unused fields and do ajax add/reply comment.`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT (SUBSTRING(tree_path, 1, 10)) AS "tree_path_root",
       "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity",
       "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",
       "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",
       "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",
       "accounts_userprofile"."user_id",
       "accounts_userprofile"."last_mod_inv",
       "accounts_userprofile"."last_activity",
       "accounts_userprofile"."last_ip",
       "accounts_userprofile"."last_country_id",
       "accounts_userprofile"."last_agent",
       "accounts_userprofile"."is_email_verified",
       "accounts_userprofile"."is_email_idle",
       "accounts_userprofile"."email_last_clicked",
       "accounts_userprofile"."api_token",
       "accounts_userprofile"."real_name",
       "accounts_userprofile"."location",
       "accounts_userprofile"."brickset_url",
       "accounts_userprofile"."mocpages_url",
       "accounts_userprofile"."flickr_url",
       "accounts_userprofile"."eurobricks_url",
       "accounts_userprofile"."youtube_url",
       "accounts_userprofile"."bricklink_url",
       "accounts_userprofile"."brickowl_url",
       "accounts_userprofile"."bricksafe_url",
       "accounts_userprofile"."website_url",
       "accounts_userprofile"."facebook_url",
       "accounts_userprofile"."twitter_url",
       "accounts_userprofile"."karma",
       "accounts_userprofile"."trophy_badge_id",
       "accounts_userprofile"."comments",
       "accounts_userprofile"."mfhash_vector",
       "accounts_userprofile"."is_muted",
       "accounts_userprofile"."is_banned",
       "accounts_userprofile"."is_suspected_pirate",
       "accounts_userprofile"."muted_until",
       "accounts_userprofile"."blocked_operations",
       "accounts_userprofile"."is_guest",
       "accounts_userprofile"."guest_token"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
  LEFT OUTER JOIN "auth_user"
    ON ("django_comments"."user_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
  LEFT OUTER JOIN "accounts_userprofile"
    ON ("auth_user"."id" = "accounts_userprofile"."user_id")
WHERE ("django_comments"."content_type_id" = 43 AND "django_comments"."object_pk" = '14601' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASCSELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") LEFT OUTER JOIN "auth_user" ON ("django_comments"."user_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "accounts_userprofile" ON ("auth_user"."id" = "accounts_userprofile"."user_id") WHERE ("django_comments"."content_type_id" = 43 AND "django_comments"."object_pk" = '14601' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC

0.86

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71)
  qs = self.get_queryset(context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_queryset(45)
  return qs[:50], len(qs)

14	`{% endcomment %}`
15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

2 similar queries. Duplicated 2 times.

0.21

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`
22	`<div class="heading-title heading-border-bottom heading-color">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT (SUBSTRING(tree_path, 1, 10)) AS "tree_path_root",
       "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity",
       "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",
       "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",
       "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",
       "accounts_userprofile"."user_id",
       "accounts_userprofile"."last_mod_inv",
       "accounts_userprofile"."last_activity",
       "accounts_userprofile"."last_ip",
       "accounts_userprofile"."last_country_id",
       "accounts_userprofile"."last_agent",
       "accounts_userprofile"."is_email_verified",
       "accounts_userprofile"."is_email_idle",
       "accounts_userprofile"."email_last_clicked",
       "accounts_userprofile"."api_token",
       "accounts_userprofile"."real_name",
       "accounts_userprofile"."location",
       "accounts_userprofile"."brickset_url",
       "accounts_userprofile"."mocpages_url",
       "accounts_userprofile"."flickr_url",
       "accounts_userprofile"."eurobricks_url",
       "accounts_userprofile"."youtube_url",
       "accounts_userprofile"."bricklink_url",
       "accounts_userprofile"."brickowl_url",
       "accounts_userprofile"."bricksafe_url",
       "accounts_userprofile"."website_url",
       "accounts_userprofile"."facebook_url",
       "accounts_userprofile"."twitter_url",
       "accounts_userprofile"."karma",
       "accounts_userprofile"."trophy_badge_id",
       "accounts_userprofile"."comments",
       "accounts_userprofile"."mfhash_vector",
       "accounts_userprofile"."is_muted",
       "accounts_userprofile"."is_banned",
       "accounts_userprofile"."is_suspected_pirate",
       "accounts_userprofile"."muted_until",
       "accounts_userprofile"."blocked_operations",
       "accounts_userprofile"."is_guest",
       "accounts_userprofile"."guest_token"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
  LEFT OUTER JOIN "auth_user"
    ON ("django_comments"."user_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
  LEFT OUTER JOIN "accounts_userprofile"
    ON ("auth_user"."id" = "accounts_userprofile"."user_id")
WHERE ("django_comments"."content_type_id" = 43 AND "django_comments"."object_pk" = '14601' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC
LIMIT 50SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") LEFT OUTER JOIN "auth_user" ON ("django_comments"."user_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "accounts_userprofile" ON ("auth_user"."id" = "accounts_userprofile"."user_id") WHERE ("django_comments"."content_type_id" = 43 AND "django_comments"."object_pk" = '14601' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC LIMIT 50

0.64

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

89	`{% with cache_timeout=user.is_authenticated\|yesno:"0,300" %}`
90	`{% cache cache_timeout 'comments_list_v2' request.user.is_authenticated page.id request.GET.page request.GET.showmore num_comments %}`
91
92	`<div class="comments {% if not comment_list.0 %} empty{% endif %} mb-30">`
93	`{% if use_context %}`
94	`{# Flat list of comments #}`
95	`{% for comment in comment_list.0\|make_proxy_users %}`
96	`<ul class="comment list-unstyled comment-list-wrapper">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "lego_partmap"."id",
       "lego_partmap"."part_id",
       "lego_partmap"."ext_system",
       "lego_partmap"."ext_id",
       "lego_partmap"."is_export_id",
       "lego_partmap"."is_import_id"
  FROM "lego_partmap"
WHERE ("lego_partmap"."ext_system" = 'BO' AND "lego_partmap"."is_export_id" AND "lego_partmap"."part_id" = 14601)
LIMIT 21SELECT ••• FROM "lego_partmap" WHERE ("lego_partmap"."ext_system" = 'BO' AND "lego_partmap"."is_export_id" AND "lego_partmap"."part_id" = 14601) LIMIT 21

0.20

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/rb/site/./lego/models/parts.py in get_brickowl_num(1025)
  return PartMap.part_to_brickowl_id(self.id)

/home/nathan/rb/site/./lego/models/parts.py in part_to_brickowl_id(2011)
  part_map = PartMap.objects.get(ext_system=rb.constants.systems.EXT_SYSTEM_BRICKOWL, part_id=part_id, is_export_id=True)

221
222	`<div class="row mt-10 mb-10">`
223	`<div class="col-md-6">`
224	`<a href="https://www.brickowl.com/search/catalog?query={{ part.get_brickowl_num }}&utm_source=rebrickable">`
225	`<button class="btn btn-default btn-block">`
226	`<img src="{% static 'img/sites/bo.png' %}" class="store-icon-sm"> Search BrickOwl`
227	`</button>`
228	`</a>`

/home/nathan/rb/site/lego/templates/parts/part_details.html

SELECT "lego_partcolorstats"."id",
       "lego_partcolorstats"."part_id",
       "lego_partcolorstats"."color_id",
       "lego_partcolorstats"."num_sets",
       "lego_partcolorstats"."num_mocs",
       "lego_partcolorstats"."num_set_parts",
       "lego_partcolorstats"."num_moc_parts",
       "lego_partcolorstats"."y1",
       "lego_partcolorstats"."y2",
       "lego_partcolorstats"."is_dirty",
       "lego_partcolorstats"."ignore_color_errors"
  FROM "lego_partcolorstats"
WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."part_id" = 22817)
ORDER BY "lego_partcolorstats"."num_set_parts" DESC
LIMIT 1SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."part_id" = 22817) ORDER BY "lego_partcolorstats"."num_set_parts" DESC LIMIT 1

3 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134)
  return mark_safe(render_part_wrapper(part, sub_text, request=context['request']))

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

/home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133)
  return _render_part_in_color(part, sub_text=sub_text, request=request)

/home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51)
  part_img = part.get_img_dir()

/home/nathan/rb/site/./lego/models/parts.py in get_img_dir(536)
  most_common_color_id = self.get_most_common_color()

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

/home/nathan/rb/site/./lego/models/parts.py in get_most_common_color(323)
  pcs = PartColorStats.objects.filter(part=self, num_sets__gt=0).order_by('-num_set_parts').first()

259	`</div>`
260	`<div class="col-md-10">`
261	`{% for rel_part in rel_parts.parts %}`
262	`{% render_part rel_part rel_part.get_part_years_html %}`
263	`{% endfor %}`
264	`</div>`
265	`</div>`
266	`{% endif %}`

/home/nathan/rb/site/lego/templates/parts/part_details.html

SELECT "lego_partcolorstats"."id",
       "lego_partcolorstats"."part_id",
       "lego_partcolorstats"."color_id",
       "lego_partcolorstats"."num_sets",
       "lego_partcolorstats"."num_mocs",
       "lego_partcolorstats"."num_set_parts",
       "lego_partcolorstats"."num_moc_parts",
       "lego_partcolorstats"."y1",
       "lego_partcolorstats"."y2",
       "lego_partcolorstats"."is_dirty",
       "lego_partcolorstats"."ignore_color_errors"
  FROM "lego_partcolorstats"
WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."part_id" = 8445)
ORDER BY "lego_partcolorstats"."num_set_parts" DESC
LIMIT 1SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."part_id" = 8445) ORDER BY "lego_partcolorstats"."num_set_parts" DESC LIMIT 1

3 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

/home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134)
  return mark_safe(render_part_wrapper(part, sub_text, request=context['request']))

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

/home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133)
  return _render_part_in_color(part, sub_text=sub_text, request=request)

/home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51)
  part_img = part.get_img_dir()

/home/nathan/rb/site/./lego/models/parts.py in get_img_dir(536)
  most_common_color_id = self.get_most_common_color()

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

/home/nathan/rb/site/./lego/models/parts.py in get_most_common_color(323)
  pcs = PartColorStats.objects.filter(part=self, num_sets__gt=0).order_by('-num_set_parts').first()

259	`</div>`
260	`<div class="col-md-10">`
261	`{% for rel_part in rel_parts.parts %}`
262	`{% render_part rel_part rel_part.get_part_years_html %}`
263	`{% endfor %}`
264	`</div>`
265	`</div>`
266	`{% endif %}`

/home/nathan/rb/site/lego/templates/parts/part_details.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined"
  FROM "auth_user"
WHERE "auth_user"."id" = 17788
LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 17788 LIMIT 21

2 similar queries.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

544	`<section class="padding-xxs">`
545	`<div>`
546	`<small><i class="fa fa-fw fa-plus" title="Added"></i> {{ changes.added.timestamp }}`
547	`{% if changes.added.user %}by`
548	`<a href="{% url 'user_profile' changes.added.user.get_username %}">{{ changes.added.user.get_username }}</a>`
549	`{% endif %}</small>`
550	`</div>`
551	`<div>`

/home/nathan/rb/site/lego/templates/parts/part_details.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined"
  FROM "auth_user"
WHERE "auth_user"."id" = 455348
LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 455348 LIMIT 21

2 similar queries.

0.08

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

550	`</div>`
551	`<div>`
552	`<small><i class="fa fa-fw fa-edit" title="Updated"></i> {{ changes.updated.timestamp }}`
553	`{% if changes.updated.user %}by`
554	`<a href="{% url 'user_profile' changes.updated.user.get_username %}">{{ changes.updated.user.get_username }}</a>`
555	`{% endif %}</small>`
556	`</div>`
557	`<div class="mb-10">`

/home/nathan/rb/site/lego/templates/parts/part_details.html

SELECT DISTINCT "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug",
       COUNT("lego_part"."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_part"
    ON ("taggit_taggeditem"."object_id" = "lego_part"."id" AND ("taggit_taggeditem"."content_type_id" IN (43,48)))
INNER JOIN "taggit_taggeditem" T5
    ON ("taggit_tag"."id" = T5."tag_id")
INNER JOIN "lego_part" T6
    ON (T5."object_id" = T6."id" AND (T5."content_type_id" IN (43,48)))
WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'part' AND T6."id" = 14601)
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_part" ON ("taggit_taggeditem"."object_id" = "lego_part"."id" AND ("taggit_taggeditem"."content_type_id" IN (43,48))) INNER JOIN "taggit_taggeditem" T5 ON ("taggit_tag"."id" = T5."tag_id") INNER JOIN "lego_part" T6 ON (T5."object_id" = T6."id" AND (T5."content_type_id" IN (43,48))) WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'part' AND T6."id" = 14601) GROUP BY "taggit_tag"."id"

6.02

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/parts.py in find_parts(124)
  return part_details(request, slug1)

/home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30)
  return fn(*args, **kw)

/home/nathan/rb/site/./lego/views/parts.py in part_details(609)
  return render(request, 'parts/part_details.html', context)

1	`{# Simon wanted the id=tags as an anchor for his links #}`
2	`<div class="clearfix anchor tags_list" id="{{ prefix }}tags">`
3	`{% for tag in tags %}`
4	`<a href="{% url 'find_parts' %}?tag={{ tag.id }}&show_unused=on&show_printed=on" class="tag {% if request.user.is_tagger %}deltag{% endif %}">`
5	`<span class="txt">{{ tag.name }}</span>`
6	`<span class="num">`
7	`<span class="relative">`

/home/nathan/rb/site/lego/templates/parts/includes/render_tags.html

Log messages

No messages logged.