LEGO Instructions - 40780-1 Birthday Cake | Rebrickable

DJDT

Time

Resource usage

Resource	Value
User CPU time	44.777 msec
System CPU time	0.130 msec
Total CPU time	44.907 msec
Elapsed time	55.073 msec
Context switches	13 voluntary, 0 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 10.28 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" = '40780-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" = '40780-1') LIMIT 21

0.81

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 (250546))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 (250546))

8.73

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" = 250546
ORDER BY "lego_setinstructions"."descr" ASCSELECT ••• FROM "lego_setinstructions" WHERE "lego_setinstructions"."set_id" = 250546 ORDER BY "lego_setinstructions"."descr" ASC

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)

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" = 742837
LIMIT 21SELECT ••• FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 742837 LIMIT 21

2 similar queries.

0.30

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" = 742838
LIMIT 21SELECT ••• FROM "lego_files_s3file" WHERE "lego_files_s3file"."id" = 742838 LIMIT 21

2 similar queries.

0.09

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

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.