LEGO Color 61 - Chrome Blue

LEGO part element render in color 61 - Chrome Blue

LEGO part LDraw render in color 61 - Chrome Blue

LEGO part photo in color 61 - Chrome Blue

Element

LDraw

Photo

6C96BF

Total quantity used in all Sets:	26
Number of Parts in all Sets:	16
Number of Sets:	5
First Seen:	1998
Last Seen:	2006

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

System	ID	Name(s)
BrickLink	52	Chrome Blue
BrickOwl	112	Chrome Blue
Peeron		chromeblue
LDraw	61	Chrome_Blue

DJDT

Time

Resource usage

Resource	Value
User CPU time	33.652 msec
System CPU time	2.854 msec
Total CPU time	36.506 msec
Elapsed time	39.601 msec
Context switches	22 voluntary, 47 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

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

0.25

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(18)
  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 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"."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(20)
  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" 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 (147)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC

0.62

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(20)
  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.48

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(20)
  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(20)
  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.26

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(20)
  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" = 61 AND "lego_partcolorstats"."num_sets" > 0)SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."color_id" = 61 AND "lego_partcolorstats"."num_sets" > 0)

0.29

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/colors.py in color_details(25)
  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(134)
  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 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21

0.19

Connection: default

Transaction status: Idle

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

/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_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" = 61SELECT ••• FROM "lego_colormap" WHERE "lego_colormap"."color_id" = 61

0.15

Connection: default

Transaction status: Idle

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

81	`<th>Name(s)</th>`
82	`</tr>`
83	`</thead>`
84	`{% for m in color.mappings.all %}`
85	`<tr title="Export: {{ m.is_export_id }} Import: {{ m.is_import_id }}">`
86	`<td>{{ m.get_ext_system_display }}</td>`
87	`<td>{{ m.ext_id\|default:'' }}</td>`
88	`<td>{% for d in m.ext_descr %}{{ d }}<br>{% endfor %}</td>`

/home/nathan/rb/site/lego/templates/colors/color_details.html

Log messages

No messages logged.