LEGO part element render in color 1022 - Modulex Buff
LEGO part LDraw render in color 1022 - Modulex Buff
LEGO part photo in color 1022 - Modulex Buff

Element

LDraw

Photo

DEC69C

Total quantity used in all Sets: 1626
Number of Parts in all Sets: 42
Number of Sets: 41
First Seen: 1963
Last Seen: 1963

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

System Ext ID Name(s) Import? Export?
BrickLink 133 Mx Buff
True True
BrickOwl 138 Modulex Buff
True True
LDraw 30005 Modulex_Buff
True True
DJDT

Time

Resource usage

Resource Value
User CPU time 54.467 msec
System CPU time 3.176 msec
Total CPU time 57.643 msec
Elapsed time 60.621 msec
Context switches 30 voluntary, 2 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

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

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

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

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

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

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

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.