Blog

Review: MOC-130818 Galaxy Mech Miner

July 3, 2023
Reviews
Chricki
8 Comments
7300 views

After finishing the Galaxy Explorer I was looking for an alternate build. Because the set is quite popular, already a lot of you shared their use of the donor set. Clearly most of those builds are space theme related and mainly spaceships. One very nice looking Star Wars-build first caught my eye.

Review: 10497-1 Galaxy Explorer

June 15, 2023
Reviews
Chricki
35 Comments
11600 views

Along with the celebration of 90th anniversary LEGO redesigned a classic space set from 1979: the Galaxy Explorer (497) [USA release] or Space Cruiser with Moonbase (928) [European release].

Moc-Review: MOC-135072 - 75257 Modification "THE FALCON"

April 11, 2023
Reviews
Chricki
42 Comments
39300 views

The LEGO builds from the 'Star Wars' theme (sets and MOCs) are the reason my dark ages ended about 3 years ago. My son started building LEGO around that time and I had and still have fun doing this with him. But then at first some fantastic star wars micro builds and later on the larger sets caught my eye and I decided to start collecting and building LEGO again for myself.

Series
Popular

Designer Spotlights

Into the Archives

Mini MOC Madness

Is This LEGO?

Rebricksberg

New Set Releases

Tips & Useful Info

The Good, The Bad, & The Ugly

Review: 42674 - Comic Book and Game Store

Sept. 22, 2025
Chricki

[April Fools] LEGO to limit set sizes in 2026

April 1, 2025
icedragonj

New Summer 2025 Sets

May 2, 2025
TobyMac

RebrickMat - It's Back!

April 26, 2025
Nathan

Review: 76974-1 - Brick-Built Mosasaurus Boat Mission

Nov. 5, 2025
TobyMac

New Sets for Winter 2026

Dec. 2, 2025
TobyMac

Designer Spotlight: Wurger Bricks

Sept. 3, 2025
Nathan

Rebrickable 2025 Top 10 Sets

Dec. 30, 2025
jaredhinton

MOC Review: GLaDOS - Portal 2 by Coosey_Goosey

Sept. 28, 2025
icedragonj

Review: 40805 - Arcade Machine

Oct. 5, 2025
Chricki

DJDT

Time

Resource usage

Resource	Value
User CPU time	129.871 msec
System CPU time	3.103 msec
Total CPU time	132.974 msec
Elapsed time	151.876 msec
Context switches	105 voluntary, 1 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 20.18 ms (34 queries including 30 similar and 12 duplicates )

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('Chricki'))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('Chricki'))

8.76

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",
       "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

8 similar queries.

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(50)
  {'name': 'Designer Spotlights', 'tag': 'designer-spotlight', 'article': Article.objects.get(id=646)},

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"
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

8 similar queries.

0.22

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",
       "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

8 similar queries.

0.30

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",
       "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

8 similar queries.

0.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(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",
       "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

8 similar queries.

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(54)
  {'name': 'Rebricksberg', 'tag': 'rebricksberg', 'article': Article.objects.get(id=279)},

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"
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

8 similar queries.

0.27

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",
       "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

8 similar queries.

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(56)
  {'name': 'Tips & Useful Info', 'tag': 'tips', 'article': Article.objects.get(id=462)},

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"
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

8 similar queries.

0.12

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 "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.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/./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)

340
341	`<body class="{% block body-class %}{{ request.user.get_body_classes }}{% endblock body-class %}">`
342
343	`{% site_message %}`
344	`<div id="wrapper" class="{% block wrapper_class %}{% endblock wrapper_class %} {% if request.user.is_anonymous %}{% else %}{{ request.user.get_personalisation_options.max_width }}{% endif %}">`
345
346
347	`<div id="topBar" class="hidden-sm hidden-xs">`

/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.19

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)

412	`</a>`
413	`</li>`
414	`<li class="hidden-xs">`
415	`{% geo_currency request.user %}`
416	`</li>`
417	`{% comment %}`
418	`<li class="hidden-xs hidden-sm">`
419	`<a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>`

/home/nathan/rb/site/rb/templates/rb/base_root.html

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('Chricki'))
ORDER BY "blog_article"."published_date" DESC
LIMIT 3
OFFSET 40SELECT ••• 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('Chricki')) ORDER BY "blog_article"."published_date" DESC LIMIT 3 OFFSET 40

0.64

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,

26	`</div>`
27	`{% endif %}`
28
29	`{% for article in articles %}`
30	`<div class="mb-30">`
31	`<div class="">`
32	`{% include 'blog/includes/render_article_horizontal.html' %}`
33	`</div>`

/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" = 375158
LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 375158 LIMIT 21

3 similar queries. Duplicated 3 times.

0.11

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,

2
3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`

/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" = 'Chricki'
LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'Chricki' LIMIT 21

3 similar queries. Duplicated 3 times.

0.12

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)

3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`
10	`<div class="heading-title heading-border-bottom heading-color mb-6">`

/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" = 375158
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 375158 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

3 similar queries. Duplicated 3 times.

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]

3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`
10	`<div class="heading-title heading-border-bottom heading-color mb-6">`

/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

3 similar queries. Duplicated 3 times.

0.07

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,

6	`<span>{{ article.published_date\|date }}</span>`
7	`</li>`
8	`<li class="hidden-xs">`
9	`<a href="{% url 'blog_by_category' article.category %}">`
10	`<i class="fa fa-folder-open-o"></i>`
11	`<span>{{ article.category }}</span>`
12	`</a>`
13	`</li>`

/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" = '603' 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" = '603' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

3 similar queries.

0.26

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

18	`</a>`
19	`</li>`
20
21	`{% get_comment_count for article as num_comments %}`
22	`<li class="pull-right">`
23	`<a href="{% url 'blog_article_w_slug' article.id article.slug %}#comments">`
24	`<i class="fa fa-comment-o"></i>`
25	`{{ num_comments }}<span class="hidden-xs hidden-sm"> Comment{{ num_comments\|pluralize }}</span>`

/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" = 603
LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 603 LIMIT 21

3 similar queries.

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)

25	`{{ num_comments }}<span class="hidden-xs hidden-sm"> Comment{{ num_comments\|pluralize }}</span>`
26	`</a>`
27	`</li>`
28	`{% if article.stats.hits > 100 %}`
29	`<li class="pull-right hidden-xs hidden-sm">`
30	`<i class="fa fa-line-chart"></i>`
31	`<span>{{ article.stats.hits\|floor_100 }} views</span>`
32	`</li>`

/home/nathan/rb/site/blog/templates/blog/includes/render_article_byline.html

3 similar queries. Duplicated 3 times.

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,

2
3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`

/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" = 'Chricki'
LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'Chricki' LIMIT 21

3 similar queries. Duplicated 3 times.

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/./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)

3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`
10	`<div class="heading-title heading-border-bottom heading-color mb-6">`

/home/nathan/rb/site/blog/templates/blog/includes/render_article_horizontal.html

3 similar queries. Duplicated 3 times.

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/./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]

3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`
10	`<div class="heading-title heading-border-bottom heading-color mb-6">`

/home/nathan/rb/site/blog/templates/blog/includes/render_article_horizontal.html

3 similar queries. Duplicated 3 times.

0.06

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,

6	`<span>{{ article.published_date\|date }}</span>`
7	`</li>`
8	`<li class="hidden-xs">`
9	`<a href="{% url 'blog_by_category' article.category %}">`
10	`<i class="fa fa-folder-open-o"></i>`
11	`<span>{{ article.category }}</span>`
12	`</a>`
13	`</li>`

/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" = '598' 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" = '598' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

3 similar queries.

0.38

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

18	`</a>`
19	`</li>`
20
21	`{% get_comment_count for article as num_comments %}`
22	`<li class="pull-right">`
23	`<a href="{% url 'blog_article_w_slug' article.id article.slug %}#comments">`
24	`<i class="fa fa-comment-o"></i>`
25	`{{ num_comments }}<span class="hidden-xs hidden-sm"> Comment{{ num_comments\|pluralize }}</span>`

/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" = 598
LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 598 LIMIT 21

3 similar queries.

0.09

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)

25	`{{ num_comments }}<span class="hidden-xs hidden-sm"> Comment{{ num_comments\|pluralize }}</span>`
26	`</a>`
27	`</li>`
28	`{% if article.stats.hits > 100 %}`
29	`<li class="pull-right hidden-xs hidden-sm">`
30	`<i class="fa fa-line-chart"></i>`
31	`<span>{{ article.stats.hits\|floor_100 }} views</span>`
32	`</li>`

/home/nathan/rb/site/blog/templates/blog/includes/render_article_byline.html

3 similar queries. Duplicated 3 times.

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,

2
3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`

/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" = 'Chricki'
LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'Chricki' LIMIT 21

3 similar queries. Duplicated 3 times.

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/./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)

3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`
10	`<div class="heading-title heading-border-bottom heading-color mb-6">`

/home/nathan/rb/site/blog/templates/blog/includes/render_article_horizontal.html

3 similar queries. Duplicated 3 times.

0.07

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]

3	`<div class="flex-row">`
4	`<div class="mr-10 hidden-xs" style="width: 50px">`
5	`<a href="{% url 'blog_by_author' article.author.username %}">`
6	`<img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">`
7	`</a>`
8	`</div>`
9	`<div class="flex-expand">`
10	`<div class="heading-title heading-border-bottom heading-color mb-6">`

/home/nathan/rb/site/blog/templates/blog/includes/render_article_horizontal.html

3 similar queries. Duplicated 3 times.

0.06

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,

6	`<span>{{ article.published_date\|date }}</span>`
7	`</li>`
8	`<li class="hidden-xs">`
9	`<a href="{% url 'blog_by_category' article.category %}">`
10	`<i class="fa fa-folder-open-o"></i>`
11	`<span>{{ article.category }}</span>`
12	`</a>`
13	`</li>`

/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" = '578' 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" = '578' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

3 similar queries.

0.58

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

18	`</a>`
19	`</li>`
20
21	`{% get_comment_count for article as num_comments %}`
22	`<li class="pull-right">`
23	`<a href="{% url 'blog_article_w_slug' article.id article.slug %}#comments">`
24	`<i class="fa fa-comment-o"></i>`
25	`{{ num_comments }}<span class="hidden-xs hidden-sm"> Comment{{ num_comments\|pluralize }}</span>`

/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" = 578
LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 578 LIMIT 21

3 similar queries.

0.09

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)

25	`{{ num_comments }}<span class="hidden-xs hidden-sm"> Comment{{ num_comments\|pluralize }}</span>`
26	`</a>`
27	`</li>`
28	`{% if article.stats.hits > 100 %}`
29	`<li class="pull-right hidden-xs hidden-sm">`
30	`<i class="fa fa-line-chart"></i>`
31	`<span>{{ article.stats.hits\|floor_100 }} views</span>`
32	`</li>`

/home/nathan/rb/site/blog/templates/blog/includes/render_article_byline.html

SELECT (width*height) AS "area",
       "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-31T17:28:16.181883+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.181954+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.181867+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.182078+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T17:28:16.181883+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.181954+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.181867+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.182078+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')

2 similar queries.

1.95

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:

55	`</div>`
56	`{% endfor %}`
57
58	`{% render_banner 262 600 5 %}`
59	`</div>`
60	`<div id="tab_popular" class="tab-pane">`
61	`{% for popular_article in popular_articles %}`
62	`<div class="mb-30">`

/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html

SELECT (width*height) AS "area",
       "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-31T17:28:16.181883+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.181954+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.181867+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.182078+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-31T17:28:16.181883+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.181954+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.181867+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.182078+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1

2 similar queries.

1.71

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]

55	`</div>`
56	`{% endfor %}`
57
58	`{% render_banner 262 600 5 %}`
59	`</div>`
60	`<div id="tab_popular" class="tab-pane">`
61	`{% for popular_article in popular_articles %}`
62	`<div class="mb-30">`

/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html

SELECT (width*height) AS "area",
       "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-31T17:28:16.189565+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.189626+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.189555+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.189746+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-01-31T17:28:16.189565+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.189626+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.189555+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.189746+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')

2 similar queries.

1.49

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:

63	`{% include 'blog/includes/render_posts_preview.html' with article=popular_article %}`
64	`</div>`
65	`{% endfor %}`
66	`{% render_banner 262 600 5 %}`
67	`</div>`
68	`</div>`
69	`</div>`
70

/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html

SELECT (width*height) AS "area",
       "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-31T17:28:16.189565+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.189626+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.189555+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.189746+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-31T17:28:16.189565+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-01-31T17:28:16.189626+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-01-31T17:28:16.189555+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-01-31T17:28:16.189746+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1

2 similar queries.

1.11

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]

63	`{% include 'blog/includes/render_posts_preview.html' with article=popular_article %}`
64	`</div>`
65	`{% endfor %}`
66	`{% render_banner 262 600 5 %}`
67	`</div>`
68	`</div>`
69	`</div>`
70

/home/nathan/rb/site/blog/templates/blog/includes/render_posts_preview_tabs.html

Log messages

No messages logged.

Time

Resource usage

Browser timing

SQL queries from 1 connection

Log messages