LEGO part element render in color 323 - Light Aqua
LEGO part LDraw render in color 323 - Light Aqua
LEGO part photo in color 323 - Light Aqua

Element

LDraw

Photo

ADC3C0

Total quantity used in all Sets: 10831
Number of Parts in all Sets: 3134
Number of Sets: 588
First Seen: 2011
Last Seen: 2026

This color is known at other sites according to the following mappings.

System Ext ID Name(s) Import? Export?
BrickLink 152 Light Aqua
True True
BrickOwl 62 Light Aqua
True True
LDraw 323 Light_Aqua
True True
LEGO 323 Aqua
True True
Peeron ltaqua
True True
DJDT

Time

Resource usage

Resource Value
User CPU time 54.154 msec
System CPU time 3.306 msec
Total CPU time 57.460 msec
Elapsed time 60.662 msec
Context switches 31 voluntary, 3 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 8.14 ms (9 queries )
Query Timeline Time (ms) Action
SELECT "lego_color"."id",
       "lego_color"."name",
       "lego_color"."rgb",
       "lego_color"."is_trans",
       "lego_color"."fuzzy_color_id",
       "lego_color"."is_active"
  FROM
"lego_color"
 WHERE
("lego_color"."is_active" AND "lego_color"."id" = 323)
 LIMIT
21
SELECT ••• FROM "lego_color" WHERE ("lego_color"."is_active" AND "lego_color"."id" = 323) LIMIT 21
0.32

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(19)
  color = get_object_or_404(Color, id=color_id)

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"."is_active" AND "lego_part"."part_num" = '3003')
 LIMIT
21
SELECT ••• 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"."is_active" AND "lego_part"."part_num" = '3003') LIMIT 21
4.98

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(21)
  part_3003 = Part.objects.get(part_num='3003')

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 (147))
 ORDER BY
"lego_color"."name" ASC, "lego_element"."element_id" ASC
SELECT ••• 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 (147)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC
0.41

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(21)
  part_3003 = Part.objects.get(part_num='3003')

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 (147)
SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (147)
0.28

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(21)
  part_3003 = Part.objects.get(part_num='3003')

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 (147)
SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (147)
0.21

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(21)
  part_3003 = Part.objects.get(part_num='3003')

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"
  FROM
"lego_partphoto"
 WHERE
("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (147))
SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (147))
0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(21)
  part_3003 = Part.objects.get(part_num='3003')

SELECT SUM("lego_partcolorstats"."num_set_parts") AS "num_set_parts__sum",
       SUM("lego_partcolorstats"."num_sets") AS "num_sets__sum",
       MIN("lego_partcolorstats"."y1") AS "y1__min",
       MAX("lego_partcolorstats"."y2") AS "y2__max",
       COUNT("lego_partcolorstats"."color_id") AS "color__count"
  FROM
"lego_partcolorstats"
 WHERE
("lego_partcolorstats"."color_id" = 323 AND "lego_partcolorstats"."num_sets" > 0)
SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."color_id" = 323 AND "lego_partcolorstats"."num_sets" > 0)
1.47

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(26)
  color.stats = color.get_color_stats()

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

/home/nathan/rb/site/./lego/models/colors.py in get_color_stats(135)
  aggregate(Sum('num_set_parts'), Sum('num_sets'), Min('y1'), Max('y2'), Count('color')))

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
21
SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(32)
  return render(request, 'colors/color_details.html', {'color': color, 'mappings': mappings, 'part_3003': part_3003, 'map_form': map_form})

/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>

/home/nathan/rb/site/rb/templates/rb/includes/topbar.html

SELECT "lego_colormap"."id",
       "lego_colormap"."color_id",
       "lego_colormap"."ext_system",
       "lego_colormap"."ext_id",
       "lego_colormap"."ext_descr",
       "lego_colormap"."is_export_id",
       "lego_colormap"."is_import_id"
  FROM
"lego_colormap"
 WHERE
"lego_colormap"."color_id" = 323
 ORDER BY
"lego_colormap"."ext_system" ASC, "lego_colormap"."ext_id" ASC
SELECT ••• FROM "lego_colormap" WHERE "lego_colormap"."color_id" = 323 ORDER BY "lego_colormap"."ext_system" ASC, "lego_colormap"."ext_id" ASC
0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(32)
  return render(request, 'colors/color_details.html', {'color': color, 'mappings': mappings, 'part_3003': part_3003, 'map_form': map_form})

9 {% if request.user.is_inv_admin %}<th></th>{% endif %}
10 </tr>
11 </thead>
12 {% for m in mappings.all %}
13 <tr title="Export: {{ m.is_export_id }} Import: {{ m.is_import_id }}">
14 <td>{{ m.get_ext_system_display }}</td>
15 <td>{{ m.ext_id|default:'' }}</td>
16 <td>{% for d in m.ext_descr %}{{ d }}<br>{% endfor %}</td>

/home/nathan/rb/site/lego/templates/colors/includes/color_mappings.html

Log messages

No messages logged.