This time, we're writing a review together. I'm Rienke, and together with Tobymac for over 20 years. Normally, I don't interfere with his LEGO hobby and Rebrickable work. To each his own. My passion is making clothing and other things on the sewing machine. (Quick plug for my Instagram) I do like LEGO, and I enjoy seeing Toby getting completely caught up in his passion.
| Resource | Value |
|---|---|
| User CPU time | 109.197 msec |
| System CPU time | 1.861 msec |
| Total CPU time | 111.058 msec |
| Elapsed time | 128.075 msec |
| Context switches | 64 voluntary, 4 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT COUNT(*) AS "__count"
FROM "blog_article" INNER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") WHERE ("blog_article"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('JESmamamaakt'))SELECT ••• FROM "blog_article" INNER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") WHERE ("blog_article"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('JESmamamaakt')) |
0.39 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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.34 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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.17 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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.28 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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.23 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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_author(245) return render_articles_list(request, articles, 10) /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.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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 "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") WHERE ("blog_article"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('JESmamamaakt')) ORDER BY "blog_article"."published_date" DESC LIMIT 1 OFFSET 20SELECT ••• FROM "blog_article" INNER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") WHERE ("blog_article"."is_active" AND UPPER("auth_user"."username"::text) = UPPER('JESmamamaakt')) ORDER BY "blog_article"."published_date" DESC LIMIT 1 OFFSET 20 |
8.85 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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" = 126407 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 126407 LIMIT 21 |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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" = 'JESmamamaakt' LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'JESmamamaakt' LIMIT 21 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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" = 126407 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 126407 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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" = 1 LIMIT 21SELECT ••• FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 1 LIMIT 21 |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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" = '517' 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" = '517' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
0.36 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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" = 517 LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 517 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: In transaction /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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-22T16:14:36.574065+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.574138+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.574052+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.574260+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T16:14:36.574065+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.574138+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.574052+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.574260+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
2.05 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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-22T16:14:36.574065+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.574138+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.574052+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.574260+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-22T16:14:36.574065+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.574138+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.574052+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.574260+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.24 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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-22T16:14:36.581426+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.581485+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.581417+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.581594+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-22T16:14:36.581426+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.581485+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.581417+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.581594+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.62 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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-22T16:14:36.581426+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.581485+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.581417+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.581594+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-22T16:14:36.581426+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-22T16:14:36.581485+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-22T16:14:36.581417+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-22T16:14:36.581594+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.13 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./blog/views.py in blog_by_author(245) return render_articles_list(request, articles, 10) /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
