LEGO part element render in color 1039 - Modulex Clear
LEGO part LDraw render in color 1039 - Modulex Clear
LEGO part photo in color 1039 - Modulex Clear

Element

LDraw

Photo

FFFFFF

Total quantity used in all Sets: 1394
Number of Parts in all Sets: 71
Number of Sets: 71
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 149 Mx Clear
True True
BrickOwl 139 Modulex Clear
True True
LDraw 30000 Modulex_Clear
True True
DJDT

Time

Resource usage

Resource Value
User CPU time 52.646 msec
System CPU time 0.068 msec
Total CPU time 52.714 msec
Elapsed time 64.121 msec
Context switches 23 voluntary, 5 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

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

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

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

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

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

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

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

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

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

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.