Back in 2014, I met with LEGO to talk about Rebrickable and throw around some ideas for making something awesome together. The one thing that stood out for them was how Rebrickable highlights the value of alternate builds - i.e. MOCs that can be built from just a single official set. With the Rebrickable Build calculations making these MOCs stand out with 100% matching results, they have proven very popular among users.
| Resource | Value |
|---|---|
| User CPU time | 115.197 msec |
| System CPU time | 0.480 msec |
| Total CPU time | 115.677 msec |
| Elapsed time | 148.669 msec |
| Context switches | 71 voluntary, 0 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT "django_content_type"."id",
"django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'blog' AND "django_content_type"."model" = 'article') LIMIT 21SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'blog' AND "django_content_type"."model" = 'article') LIMIT 21 |
0.39 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(69) articles = paginator.get_page(request.GET.get('page', 1)) /home/nathan/rb/site/./digg_paginator/utils.py in get_page(274) return self.page(page) /home/nathan/rb/site/./digg_paginator/utils.py in page(199) page = super(DiggPaginator, self).page(number, *args, **kwargs) /home/nathan/rb/site/./digg_paginator/utils.py in page(47) return super(ExPaginator, self).page(number) /home/nathan/venv_rb310/lib/python3.10/site-packages/taggit/managers.py in _get_extra_restriction(730) content_type_ids = [ /home/nathan/venv_rb310/lib/python3.10/site-packages/taggit/managers.py in <listcomp>(731) ContentType.objects.get_for_model(subclass).pk |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "blog_article" INNER JOIN "taggit_taggeditem" ON ("blog_article"."id" = "taggit_taggeditem"."object_id" AND ("taggit_taggeditem"."content_type_id" = 12)) INNER JOIN "taggit_tag" ON ("taggit_taggeditem"."tag_id" = "taggit_tag"."id") WHERE ("blog_article"."is_active" AND UPPER("taggit_tag"."slug"::text) = UPPER('remake'))SELECT ••• FROM "blog_article" INNER JOIN "taggit_taggeditem" ON ("blog_article"."id" = "taggit_taggeditem"."object_id" AND ("taggit_taggeditem"."content_type_id" = 12)) INNER JOIN "taggit_tag" ON ("taggit_taggeditem"."tag_id" = "taggit_tag"."id") WHERE ("blog_article"."is_active" AND UPPER("taggit_tag"."slug"::text) = UPPER('remake')) |
8.74 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(69) articles = paginator.get_page(request.GET.get('page', 1)) /home/nathan/rb/site/./digg_paginator/utils.py in get_page(274) return self.page(page) /home/nathan/rb/site/./digg_paginator/utils.py in page(199) page = super(DiggPaginator, self).page(number, *args, **kwargs) /home/nathan/rb/site/./digg_paginator/utils.py in page(47) return super(ExPaginator, self).page(number) |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 646) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 646) LIMIT 21 |
0.35 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(50) {'name': 'Designer Spotlights', 'tag': 'designer-spotlight', 'article': Article.objects.get(id=646)}, |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 605) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 605) LIMIT 21 |
0.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(51) {'name': 'Into the Archives', 'tag': 'into-the-archives', 'article': Article.objects.get(id=605)}, |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 705) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 705) LIMIT 21 |
0.29 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(52) {'name': 'Mini MOC Madness', 'tag': 'mini-moc-madness', 'article': Article.objects.get(id=705)}, |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 616) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 616) LIMIT 21 |
0.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(53) {'name': 'Is This LEGO?', 'tag': 'is-this-lego', 'article': Article.objects.get(id=616)}, |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 279) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 279) LIMIT 21 |
0.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(54) {'name': 'Rebricksberg', 'tag': 'rebricksberg', 'article': Article.objects.get(id=279)}, |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 720) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 720) LIMIT 21 |
0.34 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(55) {'name': 'New Set Releases', 'tag': 'sets', 'article': Article.objects.get(id=720)}, |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 462) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 462) LIMIT 21 |
0.24 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(56) {'name': 'Tips & Useful Info', 'tag': 'tips', 'article': Article.objects.get(id=462)}, |
|||||||||||||||||||||
|
SELECT "blog_article"."id",
8 similar queries.
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 249) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 249) LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(72) article_series_images = get_series() /home/nathan/rb/site/./blog/views.py in get_series(57) {'name': 'The Good, The Bad, & The Ugly', 'tag': 'good-bad-ugly', 'article': Article.objects.get(id=249)} |
|||||||||||||||||||||
|
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.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /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 "blog_article"."id",
"blog_article"."title", "blog_article"."author_id", "blog_article"."published_date", "blog_article"."is_active", "blog_article"."body", "blog_article"."meta_description", "blog_article"."meta_img", "blog_article"."slug", "blog_article"."category_id", "blog_article"."ads", "blog_article"."show_ads_for_set_num", "blog_article"."review_for_set_num", "blog_article"."status", "blog_article"."scheduled_net", "blog_article"."ready_for_review_date", "blog_article"."is_sensitive", "blog_article"."search_vector" FROM "blog_article" INNER JOIN "taggit_taggeditem" ON ("blog_article"."id" = "taggit_taggeditem"."object_id" AND ("taggit_taggeditem"."content_type_id" = 12)) INNER JOIN "taggit_tag" ON ("taggit_taggeditem"."tag_id" = "taggit_tag"."id") WHERE ("blog_article"."is_active" AND UPPER("taggit_tag"."slug"::text) = UPPER('remake')) ORDER BY "blog_article"."published_date" DESC LIMIT 1SELECT ••• FROM "blog_article" INNER JOIN "taggit_taggeditem" ON ("blog_article"."id" = "taggit_taggeditem"."object_id" AND ("taggit_taggeditem"."content_type_id" = 12)) INNER JOIN "taggit_tag" ON ("taggit_taggeditem"."tag_id" = "taggit_tag"."id") WHERE ("blog_article"."is_active" AND UPPER("taggit_tag"."slug"::text) = UPPER('remake')) ORDER BY "blog_article"."published_date" DESC LIMIT 1 |
12.01 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag,
/home/nathan/rb/site/blog/templates/blog/blog_list.html |
|||||||||||||||||||||
|
SELECT "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 "auth_user" WHERE "auth_user"."id" = 2 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 2 LIMIT 21 |
0.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag,
/home/nathan/rb/site/blog/templates/blog/includes/render_article_horizontal.html |
|||||||||||||||||||||
|
SELECT "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 "auth_user" WHERE "auth_user"."username" = 'Nathan' LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'Nathan' LIMIT 21 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(112) user = get_user(user) /home/nathan/rb/site/./avatar/utils.py in get_user(33) return get_user_model().objects.get_by_natural_key(username)
/home/nathan/rb/site/blog/templates/blog/includes/render_article_horizontal.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 2 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 2 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33) avatar_url = provider.get_avatar_url(user, size) /home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48) avatar = get_primary_avatar(user, size) /home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120) avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]
/home/nathan/rb/site/blog/templates/blog/includes/render_article_horizontal.html |
|||||||||||||||||||||
|
SELECT "blog_articlecategory"."id",
"blog_articlecategory"."name" FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 3 LIMIT 21SELECT ••• FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 3 LIMIT 21 |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag,
/home/nathan/rb/site/blog/templates/blog/includes/render_article_byline.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 12 AND "django_comments"."object_pk" = '130' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 12 AND "django_comments"."object_pk" = '130' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
0.64 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72) context[self.as_varname] = self.get_context_value_from_queryset(context, qs) /home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116) return qs.count()
/home/nathan/rb/site/blog/templates/blog/includes/render_article_byline.html |
|||||||||||||||||||||
|
SELECT "blog_articlestats"."article_id",
"blog_articlestats"."hits" FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 130 LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 130 LIMIT 21 |
0.16 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /usr/lib/python3.10/contextlib.py in inner(79) return func(*args, **kwds) /home/nathan/venv_rb310/lib/python3.10/site-packages/annoying/fields.py in __get__(36) .__get__(instance, instance_type)
/home/nathan/rb/site/blog/templates/blog/includes/render_article_byline.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
2 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.270499+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.270586+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.270485+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.270775+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.270499+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.270586+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.270485+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.270775+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
4.64 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
2 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.270499+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.270586+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.270485+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.270775+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.270499+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.270586+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.270485+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.270775+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.58 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298) banner = banners.order_by('-area', '?')[0]
/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
2 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.281183+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.281251+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.281172+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.281370+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.281183+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.281251+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.281172+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.281370+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.76 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291) if not banners:
/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html |
|||||||||||||||||||||
|
SELECT (width*height) AS "area",
2 similar queries.
"ads_banner"."id", "ads_banner"."width", "ads_banner"."height", "ads_banner"."start_date", "ads_banner"."end_date", "ads_banner"."country_code", "ads_banner"."html" FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.281183+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.281251+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.281172+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.281370+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T10:07:35.281183+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T10:07:35.281251+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T10:07:35.281172+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T10:07:35.281370+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.12 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_tag(235) return render_articles_list(request, articles, 10, tag) /home/nathan/rb/site/./blog/views.py in render_articles_list(73) return render(request, 'blog/blog_list.html', {'articles': articles, 'drafts': drafts, 'tag': tag, /home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298) banner = banners.order_by('-area', '?')[0]
/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html |
|||||||||||||||||||||
No messages logged.
US
