LEGO part element render in color 1136 - Reddish Orange
LEGO part LDraw render in color 1136 - Reddish Orange
LEGO part photo in color 1136 - Reddish Orange

Element

LDraw

Photo

CA4C0B

Total quantity used in all Sets: 3873
Number of Parts in all Sets: 919
Number of Sets: 273
First Seen: 2001
Last Seen: 2026

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

System Ext ID Name(s) Import? Export?
BrickLink 167 Reddish Orange
True True
BrickOwl 241 Reddish Orange
True True
LDraw 402 Reddish_Orange
True True
LEGO 402 Red. Orange
True True
DJDT

Time

Resource usage

Resource Value
User CPU time 57.347 msec
System CPU time 1.027 msec
Total CPU time 58.374 msec
Elapsed time 69.487 msec
Context switches 24 voluntary, 10 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 3.02 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" = 1136)
 LIMIT
21
SELECT ••• FROM "lego_color" WHERE ("lego_color"."is_active" AND "lego_color"."id" = 1136) LIMIT 21
0.25

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
0.53

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.35

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.24

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.17

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" = 1136 AND "lego_partcolorstats"."num_sets" > 0)
SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."color_id" = 1136 AND "lego_partcolorstats"."num_sets" > 0)
0.63

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.15

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" = 1136
 ORDER BY
"lego_colormap"."ext_system" ASC, "lego_colormap"."ext_id" ASC
SELECT ••• FROM "lego_colormap" WHERE "lego_colormap"."color_id" = 1136 ORDER BY "lego_colormap"."ext_system" ASC, "lego_colormap"."ext_id" ASC
0.29

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.