LEGO part element render in color 216 - Rust
LEGO part LDraw render in color 216 - Rust
LEGO part photo in color 216 - Rust

Element

LDraw

Photo

B31004

Total quantity used in all Sets: 31
Number of Parts in all Sets: 17
Number of Sets: 12
First Seen: 1989
Last Seen: 2001

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

System Ext ID Name(s) Import? Export?
BrickLink 27 Rust
True True
BrickOwl 83 Rust
True True
LDraw 216 Rust
True True
Peeron rust
True True
DJDT

Time

Resource usage

Resource Value
User CPU time 50.560 msec
System CPU time 1.028 msec
Total CPU time 51.588 msec
Elapsed time 55.518 msec
Context switches 23 voluntary, 1 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

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

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

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

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.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_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.49

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

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

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

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

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.