I didn't do a birthday post in August this year, instead I decided to switch to calendar year annual updates. Rebrickable's third year saw lots of user growth, lots of new functionality, and lots of data improvements.
Rebrickable actually turned 2 years old last month, and I completely forgot about it :) The site has continued to grow and has had many great changes made in the last year.
This image is a shot of my analytics page for those interested in this stuff.
| Resource | Value |
|---|---|
| User CPU time | 121.561 msec |
| System CPU time | 0.287 msec |
| Total CPU time | 121.848 msec |
| Elapsed time | 150.993 msec |
| Context switches | 76 voluntary, 1 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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('traffic'))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('traffic')) |
5.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(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.36 | ||||||||||||||||||||
|
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.23 | ||||||||||||||||||||
|
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.28 | ||||||||||||||||||||
|
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.21 | ||||||||||||||||||||
|
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.17 | ||||||||||||||||||||
|
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.28 | ||||||||||||||||||||
|
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.21 | ||||||||||||||||||||
|
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 "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.11 | ||||||||||||||||||||
|
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_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.14 | ||||||||||||||||||||
|
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('traffic')) ORDER BY "blog_article"."published_date" DESC LIMIT 2 OFFSET 10SELECT ••• 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('traffic')) ORDER BY "blog_article"."published_date" DESC LIMIT 2 OFFSET 10 |
12.23 | ||||||||||||||||||||
|
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",
2 similar queries.
Duplicated 2 times.
"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.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/blog/templates/blog/includes/render_article_horizontal.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
2 similar queries.
Duplicated 2 times.
"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",
2 similar queries.
Duplicated 2 times.
"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.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/./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",
2 similar queries.
Duplicated 2 times.
"blog_articlecategory"."name" FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 5 LIMIT 21SELECT ••• FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 5 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
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"
2 similar queries.
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" = '74' 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" = '74' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
0.23 | ||||||||||||||||||||
|
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",
2 similar queries.
"blog_articlestats"."hits" FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 74 LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 74 LIMIT 21 |
0.11 | ||||||||||||||||||||
|
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 "auth_user"."id",
2 similar queries.
Duplicated 2 times.
"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.08 | ||||||||||||||||||||
|
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",
2 similar queries.
Duplicated 2 times.
"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.08 | ||||||||||||||||||||
|
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",
2 similar queries.
Duplicated 2 times.
"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.07 | ||||||||||||||||||||
|
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",
2 similar queries.
Duplicated 2 times.
"blog_articlecategory"."name" FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 5 LIMIT 21SELECT ••• FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 5 LIMIT 21 |
0.06 | ||||||||||||||||||||
|
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"
2 similar queries.
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" = '17' 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" = '17' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
2.95 | ||||||||||||||||||||
|
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",
2 similar queries.
"blog_articlestats"."hits" FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 17 LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 17 LIMIT 21 |
0.09 | ||||||||||||||||||||
|
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-23T19:30:34.188447+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.188517+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.188433+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.188635+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T19:30:34.188447+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.188517+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.188433+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.188635+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
2.07 | ||||||||||||||||||||
|
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-23T19:30:34.188447+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.188517+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.188433+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.188635+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-23T19:30:34.188447+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.188517+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.188433+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.188635+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.25 | ||||||||||||||||||||
|
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-23T19:30:34.196108+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.196171+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.196096+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.196285+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-23T19:30:34.196108+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.196171+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.196096+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.196285+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') |
1.47 | ||||||||||||||||||||
|
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-23T19:30:34.196108+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.196171+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.196096+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.196285+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-23T19:30:34.196108+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-23T19:30:34.196171+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-23T19:30:34.196096+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-23T19:30:34.196285+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1 |
1.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(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
