Element
LDraw
Photo
Element
LDraw
Photo
| Resource | Value |
|---|---|
| User CPU time | 49.762 msec |
| System CPU time | 1.039 msec |
| Total CPU time | 50.801 msec |
| Elapsed time | 52.735 msec |
| Context switches | 29 voluntary, 0 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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"."part_num" = '21' 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"."part_num" = '21' LIMIT 21 |
0.57 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(632) part = get_object_or_404(Part.all_objects, part_num=part_num) |
|||||||||||||||||||||
|
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 (4024)) 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 (4024)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(632) part = get_object_or_404(Part.all_objects, part_num=part_num) |
|||||||||||||||||||||
|
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 (4024)SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (4024) |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(632) part = get_object_or_404(Part.all_objects, part_num=part_num) |
|||||||||||||||||||||
|
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 (4024)SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (4024) |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(632) part = get_object_or_404(Part.all_objects, part_num=part_num) |
|||||||||||||||||||||
|
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 (4024))SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (4024)) |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(632) part = get_object_or_404(Part.all_objects, part_num=part_num) |
|||||||||||||||||||||
|
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 21SELECT ••• FROM "lego_color" WHERE ("lego_color"."is_active" AND "lego_color"."id" = 216) LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(637) color = get_object_or_404(Color, id=color_id) |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 4024 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 4024 AND "lego_partrelationship"."rel_type" = 'S') |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(645) part.meta_img = part.get_img_dir(color=color) /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(607) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(352) if parent_rel: |
|||||||||||||||||||||
|
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"."color_id" = 216 AND "lego_partcolorstats"."part_id" = 4024) LIMIT 21SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."color_id" = 216 AND "lego_partcolorstats"."part_id" = 4024) LIMIT 21 |
0.14 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(652) part_stat = get_or_none(PartColorStats.objects, part=part, color=color) /home/nathan/rb/site/./rb/utils.py in get_or_none(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT "lego_changelog"."id",
"lego_changelog"."timestamp", "lego_changelog"."user_id", "lego_changelog"."model", "lego_changelog"."instance_id", "lego_changelog"."set_num", "lego_changelog"."part_num", "lego_changelog"."old_value", "lego_changelog"."new_value" FROM "lego_changelog" WHERE ("lego_changelog"."instance_id" = 4024 AND "lego_changelog"."model" = 'Part') ORDER BY "lego_changelog"."timestamp" DESCSELECT ••• FROM "lego_changelog" WHERE ("lego_changelog"."instance_id" = 4024 AND "lego_changelog"."model" = 'Part') ORDER BY "lego_changelog"."timestamp" DESC |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(659) changes = part.get_change_summary() /home/nathan/rb/site/./lego/models/parts.py in get_change_summary(961) changes = ChangeLog.get_changes(part_id=self.id) /home/nathan/rb/site/./lego/models/changes.py in get_changes(276) if len(changes) > 0: |
|||||||||||||||||||||
|
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", "lego_color"."id", "lego_color"."name", "lego_color"."rgb", "lego_color"."is_trans", "lego_color"."fuzzy_color_id", "lego_color"."is_active", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "lego_partphoto" INNER JOIN "lego_color" ON ("lego_partphoto"."color_id" = "lego_color"."id") INNER JOIN "auth_user" ON ("lego_partphoto"."submitted_by_id" = "auth_user"."id") WHERE ("lego_partphoto"."color_id" = 216 AND "lego_partphoto"."part_id" = 4024) ORDER BY "lego_color"."name" ASCSELECT ••• FROM "lego_partphoto" INNER JOIN "lego_color" ON ("lego_partphoto"."color_id" = "lego_color"."id") INNER JOIN "auth_user" ON ("lego_partphoto"."submitted_by_id" = "auth_user"."id") WHERE ("lego_partphoto"."color_id" = 216 AND "lego_partphoto"."part_id" = 4024) ORDER BY "lego_color"."name" ASC |
0.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(661) part_photos_html = render_part_photos(request, part, color) /home/nathan/rb/site/./lego/views/parts.py in render_part_photos(682) for photo in all_photos: |
|||||||||||||||||||||
|
SELECT "rb_sitesettings"."id",
"rb_sitesettings"."name", "rb_sitesettings"."value" FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21SELECT ••• FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(673) return render(request, 'parts/part_color_details.html', context) /home/nathan/rb/site/./rb/templatetags/rb_settings.py in site_message(147) message = SiteSettings.get_site_message() /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./rb/models/site.py in get_site_message(24) setting = cls.objects.get(name=SiteSettings.SITE_MESSAGE)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
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.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(673) return render(request, 'parts/part_color_details.html', context) /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)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
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", "lego_color"."id", "lego_color"."name", "lego_color"."rgb", "lego_color"."is_trans", "lego_color"."fuzzy_color_id", "lego_color"."is_active", "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "lego_partphoto" INNER JOIN "lego_color" ON ("lego_partphoto"."color_id" = "lego_color"."id") INNER JOIN "auth_user" ON ("lego_partphoto"."submitted_by_id" = "auth_user"."id") WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."color_id" = 216 AND NOT "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 4024)SELECT ••• FROM "lego_partphoto" INNER JOIN "lego_color" ON ("lego_partphoto"."color_id" = "lego_color"."id") INNER JOIN "auth_user" ON ("lego_partphoto"."submitted_by_id" = "auth_user"."id") WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."color_id" = 216 AND NOT "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 4024) |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(673) return render(request, 'parts/part_color_details.html', context)
/home/nathan/rb/site/lego/templates/parts/part_color_details.html |
|||||||||||||||||||||
|
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"."color_id" = 216 AND "lego_element"."part_id" = 4024) 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"."color_id" = 216 AND "lego_element"."part_id" = 4024) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/venv_rb310/lib/python3.10/site-packages/ratelimit/decorators.py in _wrapped(30) return fn(*args, **kw) /home/nathan/rb/site/./lego/views/parts.py in part_color_details(673) return render(request, 'parts/part_color_details.html', context)
/home/nathan/rb/site/lego/templates/parts/part_color_details.html |
|||||||||||||||||||||
No messages logged.