LEGO Instructions - 60421-1 Robot World Roller-Coaster Park

DJDT

Time

Resource usage

Resource	Value
User CPU time	53.089 msec
System CPU time	0.991 msec
Total CPU time	54.080 msec
Elapsed time	64.712 msec
Context switches	12 voluntary, 22 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 10.81 ms (6 queries including 2 similar )

Query Timeline Time (ms) Action

SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_set"."baseset_ptr_id",
       "lego_set"."start_date",
       "lego_set"."end_date",
       "lego_theme"."id",
       "lego_theme"."parent_id",
       "lego_theme"."name",
       "lego_theme"."slug",
       "lego_theme"."set_count",
       "lego_theme"."t1_id",
       "lego_theme"."t1_name",
       "lego_theme"."t2_name",
       "lego_theme"."t3_name",
       "lego_theme"."lego_blurb",
       "lego_theme"."banner_img",
       "lego_theme"."descr",
       T4."id",
       T4."parent_id",
       T4."name",
       T4."slug",
       T4."set_count",
       T4."t1_id",
       T4."t1_name",
       T4."t2_name",
       T4."t3_name",
       T4."lego_blurb",
       T4."banner_img",
       T4."descr",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       "lego_setstatstotal"."set_id",
       "lego_setstatstotal"."hits",
       "lego_setstatstotal"."builds",
       "lego_setstatstotal"."likes",
       "lego_setstatstotal"."bi_downloads",
       "lego_setstatstotal"."featured_hits",
       "lego_setstatstotal"."user_hits"
  FROM "lego_set"
INNER JOIN "lego_baseset"
    ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id")
INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T4
    ON ("lego_theme"."parent_id" = T4."id")
  LEFT OUTER JOIN "lego_theme" T5
    ON (T4."parent_id" = T5."id")
  LEFT OUTER JOIN "lego_setstatstotal"
    ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_num" = '60421-1')
LIMIT 21SELECT ••• FROM "lego_set" INNER JOIN "lego_baseset" ON ("lego_set"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T4 ON ("lego_theme"."parent_id" = T4."id") LEFT OUTER JOIN "lego_theme" T5 ON (T4."parent_id" = T5."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_baseset"."set_num" = '60421-1') LIMIT 21

0.90

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in instructions(1099)
  set = get_or_none(Set.objects, set_num=set_num)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
       "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug"
  FROM "taggit_tag"
INNER JOIN "taggit_taggeditem"
    ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
INNER JOIN "django_content_type"
    ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'set' AND "taggit_taggeditem"."object_id" IN (218316))SELECT ••• FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'set' AND "taggit_taggeditem"."object_id" IN (218316))

8.94

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in instructions(1099)
  set = get_or_none(Set.objects, set_num=set_num)

/home/nathan/rb/site/./rb/utils.py in get_or_none(605)
  return manager.get(**kwargs)

SELECT "lego_setinstructions"."id",
       "lego_setinstructions"."set_id",
       "lego_setinstructions"."timestamp",
       "lego_setinstructions"."descr",
       "lego_setinstructions"."file_size",
       "lego_setinstructions"."preview_img",
       "lego_setinstructions"."is_alt",
       "lego_setinstructions"."lego_url",
       "lego_setinstructions"."file_id"
  FROM "lego_setinstructions"
WHERE "lego_setinstructions"."set_id" = 218316
ORDER BY "lego_setinstructions"."descr" ASCSELECT ••• FROM "lego_setinstructions" WHERE "lego_setinstructions"."set_id" = 218316 ORDER BY "lego_setinstructions"."descr" ASC

0.32

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in instructions(1104)
  bi_list_html = render_to_string('sets/includes/render_set_bi_list.html', {'set': set}, request=request)

7	`<p>The known <a href="{% url 'set_instructions' set.set_num %}">building instruction files for {{ set }}</a> are listed below.</p>`
8
9	`<div class="display-flex">`
10	`{% for bi in set.instructions.all %}`
11	`<div class="xflex-1 xcol-sm-3 mb-10 min-height-250 p-10" style="width:25%">`
12	`<a href="{{ bi.get_download_url }}" target="_blank">`
13	`{% thumbs bi.get_preview_img settings.THUMBS_OPTIONS_SET_BI_TILE as img %}`
14	`<img class="img-responsive" {% if not part.no_lazy %}src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-{% endif %}src="{% cachebuster img.url %}" width="{{ img.width }}" height="{{ img.height }}" title="{{ bi.descr }}" alt="LEGO Building Instructions for {{ set }} - {{ bi.descr }}">`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_bi_list.html

SELECT "lego_files_s3file"."id",
       "lego_files_s3file"."file_size",
       "lego_files_s3file"."last_modified",
       "lego_files_s3file"."aws_mi_file",
       "lego_files_s3file"."linode_si_file",
       "lego_files_s3file"."linode_mi_file",
       "lego_files_s3file"."linode_media_file"
  FROM "lego_files_s3file"
WHERE "lego_files_s3file"."id" = 431702
LIMIT 21SELECT ••• FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 431702 LIMIT 21

2 similar queries.

0.22

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in instructions(1104)
  bi_list_html = render_to_string('sets/includes/render_set_bi_list.html', {'set': set}, request=request)

/home/nathan/rb/site/./lego/models/sets.py in get_download_url(3084)
  if self.file:

9	`<div class="display-flex">`
10	`{% for bi in set.instructions.all %}`
11	`<div class="xflex-1 xcol-sm-3 mb-10 min-height-250 p-10" style="width:25%">`
12	`<a href="{{ bi.get_download_url }}" target="_blank">`
13	`{% thumbs bi.get_preview_img settings.THUMBS_OPTIONS_SET_BI_TILE as img %}`
14	`<img class="img-responsive" {% if not part.no_lazy %}src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-{% endif %}src="{% cachebuster img.url %}" width="{{ img.width }}" height="{{ img.height }}" title="{{ bi.descr }}" alt="LEGO Building Instructions for {{ set }} - {{ bi.descr }}">`
15	`<br><span class="" title="{{ bi.descr }}">{{ bi.descr }}</span>`
16	`{% if bi.is_alt %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_bi_list.html

SELECT "lego_files_s3file"."id",
       "lego_files_s3file"."file_size",
       "lego_files_s3file"."last_modified",
       "lego_files_s3file"."aws_mi_file",
       "lego_files_s3file"."linode_si_file",
       "lego_files_s3file"."linode_mi_file",
       "lego_files_s3file"."linode_media_file"
  FROM "lego_files_s3file"
WHERE "lego_files_s3file"."id" = 431701
LIMIT 21SELECT ••• FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 431701 LIMIT 21

2 similar queries.

0.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in instructions(1104)
  bi_list_html = render_to_string('sets/includes/render_set_bi_list.html', {'set': set}, request=request)

/home/nathan/rb/site/./lego/models/sets.py in get_download_url(3084)
  if self.file:

9	`<div class="display-flex">`
10	`{% for bi in set.instructions.all %}`
11	`<div class="xflex-1 xcol-sm-3 mb-10 min-height-250 p-10" style="width:25%">`
12	`<a href="{{ bi.get_download_url }}" target="_blank">`
13	`{% thumbs bi.get_preview_img settings.THUMBS_OPTIONS_SET_BI_TILE as img %}`
14	`<img class="img-responsive" {% if not part.no_lazy %}src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-{% endif %}src="{% cachebuster img.url %}" width="{{ img.width }}" height="{{ img.height }}" title="{{ bi.descr }}" alt="LEGO Building Instructions for {{ set }} - {{ bi.descr }}">`
15	`<br><span class="" title="{{ bi.descr }}">{{ bi.descr }}</span>`
16	`{% if bi.is_alt %}`

/home/nathan/rb/site/lego/templates/sets/includes/render_set_bi_list.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.23

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/sets.py in instructions(1114)
  return render(request, 'sets/instructions.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)

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

Log messages

No messages logged.