Rebrickable is under constant change. To keep you up to date it is time for another admin news article. The period between these can vary depending on the amount of news we have to bring. The blogs are all tagged so you can easily find others in the series.
Phishing Attempt
On 8th October Rebrickable was subjected to a Phishing attempt.
What have fish got to do with LEGO?
Phishing is a term used to describe an attempt by someone to impersonate a person or business you recognise, and trick you into revealing personal information such as passwords or banking details.
So, what happened?
A large number of accounts (175) were used to send private messages to 4717 Rebrickable users. Depending on the user's notification settings many of these would have also triggered an email to be sent to the user. These messages were trying to impersonate Rebrickable admins, stating that your account was suspended and you needed to verify your identity with credit card information to get it reactivated. They had links to a number of identical sites that were impersonating Rebrickable and asked for the user to enter financial information such as credit card details.
Most of the accounts used were created specifically for this scam, some of them created many years ago. However, there were also 47 regular user accounts accessed by the scammer (via correct password logins) which were used to send messages. For these 47 breached accounts, their passwords were likely reused from other sites which were leaked over the years.
There is no indication that data from Rebrickable, such as passwords were hacked.
This is what the scammer's site looked like if you clicked the link they sent you. You could even chat with the scammer.
How did Rebrickable Respond?
Here is a timeline of events (in Brisbane +10 timezone since that's where Nathan lives).
8th October
00:19
First scammer message sent
01:18
We started to get Support Requests raised alerting us to spammers. The admin team started muting and banning accounts.
02:37
The admin team realised it is more than just a few spammer accounts (which is part of normal day-to-day operations) and decided to wake up Nathan.
02:46
Site-wide message added warning on a scam in progress + spam filters updated to reject new messages from the scammer.
02:53
Nathan took site offline to be able to properly assess the situation (and make some coffee).
03:07
Site restored with inbox and ability to send private messages completely disabled.
04:58
Discovered the scammer's site DNS was served by Cloudflare so submitted an abuse report to them for one of the URLs in the message (at this time, did not realise multiple URLs were being used).
05:06
Cloudflare marked the site as a probable phishing attempt warning away anyone who visited, and reported the scam to the site's hosting provider.
06:49
All accounts involved in the sending of the messages have now been banned, or muted for those with breached accounts. All usernames/emails that were modified during the attack were changed back.
07:50
Relevant private messages were deleted.
08:32
Identified 47 compromised accounts, reset their passwords and force logged out any active sessions. 124 other accounts that had new suspicious logons detected recently also had their passwords scrambled. Notifications were sent to all 171 affected users.
09:45
Messages sent to 4717 users who received the scammer message.
10:15
Removed site-wide alert message.
10:40
Re-enabled inbox, but sending of private messages still disabled.
9th October
07:45
Realised Cloudflare only took down one of the 15 URLs used in the messages. Submitted abuse reports for the other 14. Unfortunately, they didn't action these as quickly as the first one.
10th October
05:20
Cloudflare responded to indicate the URLs were no longer available. A check showed the site was fully down this time. Either by the scammer themselves, or their hosting provider taking action from the initial abuse report.
10:39
Private messaging re-enabled and first batch of changes deployed - login verification system, minimum levels required to use external URLs or send to multiple recipients, a new auto-muting system.
11:00 - 17:00
Lots of tweaks and fixes to the new changes... sorry, it was a big change rushed through in a short timeframe.
11th October
10:45
Replaced login confirmation email links with a 6-digit code instead.
ongoing
Tweaks to spam, monitoring and moderation tools.
So a huge thank you to everyone who recognised the problem and reported the scammer, and of course the admin team for their quick work in containing the problem. While almost 5000 users received the message, it could have been a much bigger problem if it was left to run longer.
Do I need to do anything?
If you clicked the link AND entered financial information into the fake site, you should immediately contact your bank to get the card cancelled and inform them of the situation. We are not currently aware of anyone losing money from this. If you clicked the link but then thought this looks a bit fishy... and didn't enter any information, there is no need to worry.
If you use a common password on Rebrickable as well as other sites, please reset your password and choose something unique. If you strugle to remember so many unique passwords consider using a password manager. Unique passwords make it much harder for scammers like this to access your accounts.
How can I tell if something is a scam?
There are a lot of things that made this attempt look suspicious. Most accounts on Rebrickable are free, we will never ask you to pay in order to get access to your account. We will never ask for bank details to verify your identity.
The users that the message came from had strange names such as BrickBot07 or Brickable_sup8 or VerificationBot22. We have only one bot account: Rebrickable, which is used to send all of the automated messages and is identified with the blue Bot badge in messages. Other messages from real admins will also have a red badge indicating their role.
The PMs were also often sent to multiple users at once, which makes it more likely to be a scam.
Scammers will often use a sense of urgency to drive you to panic and make decisions more quickly. Always take time to ask yourself: Is this expected? Am I sure this is legitimate? If unsure you can always send us a support request.
More info can be found in this thread on the forums. If you have questions please ask them there.
A summary of what has changed as a result
New login confirmation system - you will be emailed a 6-digit code to enter when logging in from a new location, new device, haven't logged in for a while, and various other criteria that raises flags.
New anti-spam measures - you may no longer send messages containing external URLs or to multiple recpients unless you are a decently high Level.
Other monitoring and logging improvements behind the scenes to aid in investigations and alerting to potential problems.
RebrickMat is Smaller?
For those who might not have the room (or budget!) for a full size RebrickMat, it now has a smaller cousin. The RebrickPad comes in three prints to choose from - Beams, Studs, and Colors.
These make great Christmas gifts (hint hint)! There are also bundle discounts, you can find the details in our Merch store.
RebrickMat Affiliate Program
We now have an Affiliate Program available specifically for the RebrickMat. Sorry, nothing to do with MOCs yet - consider this a practice run for when we get around to that!
If you are a Youtuber, Tiktoker, blogger, or other content creator that maybe already uses our RebrickMat in their build videos - this is for you. Earn 5% of any RebrickMat sales you can send our way if you meet the criteria. See Affiliate Program for more details and apply if you are interested.
Rules Updates - Mosaics, Light Effects, and Unreleased Sets
Rules for MOC submissions are constantly being tweaked as we discover new fringe cases that were never before encountered. Please be aware of these Rules updates for MOC submissions.
Mosaics
For a while now we only allow pixal art mosaic MOCs as free. We have seen a rise in very large computer generated mosaics being submitted. You need to be the designer of the MOC to submit it to Rebrickable. If you are simply running an image through a mosaic generator, you did not design it, the software did, so you can't submit it as a MOC. You can share these types of designs on your workbench only. We still accept some mosaic MOCs if you designed it yourself, but please make your design input clear in your submission, or we may ask for further clarification.
Light Effects
We are seeing an increase in users submitting MOCs with light effects in the main image, such as headlights on cars set to glow when doing the studio renders. LEGO does have light bricks, so if a builder sees glowing parts in the main image, they may expect the build to actually light up. We are now requesting if you use light effects in your images, you need to clearly state in your description if the model actually lights up or not, and have at least one image without the light effect (which doesn't have to be the main image). We will not enforce this retroactively, but still encourage users to fix existing MOCs on a voluntary basis.
Unreleased Sets
As we are a Recognised LEGO Online Community (RLOC) we need to follow some guidelines from LEGO, this includes not publishing leaks. We are seeing some sets getting their instructions and parts lists leaked early, and proactive MOC designers submitting alternate builds and modifications before the set is released. We do not have an inventory in the set until after it is released so can't verify any alternate builds until then.
You cannot release alternate builds before the set. This means you cannot call it an alternate build in the description or title until after the set is released, we would recommend you do not post it at all until after the set is released.
For modifications, if it is a modification that is designed to sit alongside the set, you can still post this before the release. If it is a modification which needs to list parts from the set, as you are modifying the set itself, you cannot list this until after the set is released.
Please report any NEW MOCs you see breaking these rules so we can educate the designers on these updates.
Also please welcome bloco_de_ideias, 603bricks and Porsche96 who are new MOC approvers and assisting the team in keeping the MOC submission queue under control. There have still been some long wait times, and we appreciate your patience.
New Help Pages
Rebrickable has some new help pages!
No Color/Any Color
In the help forums many people were unaware of this feature for tagging internal parts which can be any colour, so there is now a help page on it.
YouTube Takedowns
Some users have had their MOCs stolen and posted on YouTube, so we have documented the takedown proceedure. Please let us know if you have experience with this or any other info we should include.
Finding MOCs
We have had pages on finding parts and sets for a while, there is now one for finding MOCs.
Over the last few months, we have focused on backend performance and stability improvements. With the rise of AI bots, the site is getting hit harder and harder by bots and scrapers in their ever growing need for data to feed their AIs. Along with the continued increase in site usage, it's a constant effort to keep the site running.
There have still been some enhancements for you to enjoy though:
You can now use # in comments/messages to prefix a set/part/MOC/fig number and turn it into a linked popup of that items details, eg #75419-1 etc.
Tags now show the number of times it has been used when you are adding them. So please take care to not duplicate tags, and only chose the one with the larger number if there are two equivalent tags.
A new login confirmation system has been added. Whereas before you would get an email notifying you of a suspicious login, now you need to confirm that login by entering a code.
Changes to the anti-spam system such as preventing linking to external URLs for low-level users.
As usual, there have been hundreds of fixes and small improvements made in the last few months. Check out the commit log to see the wonderfully detailed log of every change made.
That is all for this admin update, feel free to ask us questions in the comments!
default
1002.52 ms (40 queries
including 31 similar
and 6 duplicates
)
Query
Timeline
Time (ms)
Action
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" = 858) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 858) LIMIT 21
9 similar queries.
0.39
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(119)
article = get_object_or_404(Article, id=article_id)
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", (SIMILARITY("blog_article"."title", 'News from the Admins - October 2025') + SIMILARITY("blog_article"."body", 'Rebrickable is under constant change. To keep you up to date it is time for another admin news article. The period between these can vary depending on the amount of news we have to bring. The blogs are all tagged so you can easily find others in the series.
Phishing Attempt
On 8th October Rebrickable was subjected to a Phishing attempt.
What have fish got to do with LEGO?
Phishing is a term used to describe an attempt by someone to impersonate a person or business you recognise, and trick you into revealing personal information such as passwords or banking details.
So, what happened?
A large number of accounts (175) were used to send private messages to 4717 Rebrickable users. Depending on the user''s notification settings many of these would have also triggered an email to be sent to the user. These messages were trying to impersonate Rebrickable admins, stating that your account was suspended and you needed to verify your identity with credit card information to get it reactivated. They had links to a number of identical sites that were impersonating Rebrickable and asked for the user to enter financial information such as credit card details.
Most of the accounts used were created specifically for this scam, some of them created many years ago. However, there were also 47 regular user accounts accessed by the scammer (via correct password logins) which were used to send messages. For these 47 breached accounts, their passwords were likely reused from other sites which were leaked over the years.
There is no indication that data from Rebrickable, such as passwords were hacked.
This is what the scammer''s site looked like if you clicked the link they sent you. You could even chat with the scammer.
How did Rebrickable Respond?
Here is a timeline of events (in Brisbane +10 timezone since that''s where Nathan lives).
8th October
00:19
First scammer message sent
01:18
We started to get Support Requests raised alerting us to spammers. The admin team started muting and banning accounts.
02:37
The admin team realised it is more than just a few spammer accounts (which is part of normal day-to-day operations) and decided to wake up Nathan.
02:46
Site-wide message added warning on a scam in progress + spam filters updated to reject new messages from the scammer.
02:53
Nathan took site offline to be able to properly assess the situation (and make some coffee).
03:07
Site restored with inbox and ability to send private messages completely disabled.
04:58
Discovered the scammer''s site DNS was served by Cloudflare so submitted an abuse report to them for one of the URLs in the message (at this time, did not realise multiple URLs were being used).
05:06
Cloudflare marked the site as a probable phishing attempt warning away anyone who visited, and reported the scam to the site''s hosting provider.
06:49
All accounts involved in the sending of the messages have now been banned, or muted for those with breached accounts. All usernames/emails that were modified during the attack were changed back.
07:50
Relevant private messages were deleted.
08:32
Identified 47 compromised accounts, reset their passwords and force logged out any active sessions. 124 other accounts that had new suspicious logons detected recently also had their passwords scrambled. Notifications were sent to all 171 affected users.
09:45
Messages sent to 4717 users who received the scammer message.
10:15
Removed site-wide alert message.
10:40
Re-enabled inbox, but sending of private messages still disabled.
9th October
07:45
Realised Cloudflare only took down one of the 15 URLs used in the messages. Submitted abuse reports for the other 14. Unfortunately, they didn''t action these as quickly as the first one.
10th October
05:20
Cloudflare responded to indicate the URLs were no longer available. A check showed the site was fully down this time. Either by the scammer themselves, or their hosting provider taking action from the initial abuse report.
10:39
Private messaging re-enabled and first batch of changes deployed - login verification system, minimum levels required to use external URLs or send to multiple recipients, a new auto-muting system.
11:00 - 17:00
Lots of tweaks and fixes to the new changes... sorry, it was a big change rushed through in a short timeframe.
11th October
10:45
Replaced login confirmation email links with a 6-digit code instead.
ongoing
Tweaks to spam, monitoring and moderation tools.
So a huge thank you to everyone who recognised the problem and reported the scammer, and of course the admin team for their quick work in containing the problem. While almost 5000 users received the message, it could have been a much bigger problem if it was left to run longer.
Do I need to do anything?
If you clicked the link AND entered financial information into the fake site, you should immediately contact your bank to get the card cancelled and inform them of the situation. We are not currently aware of anyone losing money from this. If you clicked the link but then thought this looks a bit fishy... and didn''t enter any information, there is no need to worry.
If you use a common password on Rebrickable as well as other sites, please reset your password and choose something unique. If you strugle to remember so many unique passwords consider using a password manager. Unique passwords make it much harder for scammers like this to access your accounts.
How can I tell if something is a scam?
There are a lot of things that made this attempt look suspicious. Most accounts on Rebrickable are free, we will never ask you to pay in order to get access to your account. We will never ask for bank details to verify your identity.
The users that the message came from had strange names such as BrickBot07 or Brickable_sup8 or VerificationBot22. We have only one bot account: Rebrickable, which is used to send all of the automated messages and is identified with the blue Bot badge in messages. Other messages from real admins will also have a red badge indicating their role.
')) AS "similarity", "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 "blog_article" LEFT OUTER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") WHERE ("blog_article"."is_active" AND "blog_article"."published_date" > '2023-11-16T23:59:53.907175+00:00'::timestamptz ANDNOT ("blog_article"."id" = 858)) ORDER BY 19 DESC, "blog_article"."published_date" DESC LIMIT 15SELECT "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", (SIMILARITY("blog_article"."title", 'News from the Admins - October 2025') + SIMILARITY("blog_article"."body", 'Rebrickable is under constant change. To keep you up to date it is time for another admin news article. The period between these can vary depending on the amount of news we have to bring. The blogs are all tagged so you can easily find others in the series.
Phishing Attempt
On 8th October Rebrickable was subjected to a Phishing attempt.
What have fish got to do with LEGO?
Phishing is a term used to describe an attempt by someone to impersonate a person or business you recognise, and trick you into revealing personal information such as passwords or banking details.
So, what happened?
A large number of accounts (175) were used to send private messages to 4717 Rebrickable users. Depending on the user''s notification settings many of these would have also triggered an email to be sent to the user. These messages were trying to impersonate Rebrickable admins, stating that your account was suspended and you needed to verify your identity with credit card information to get it reactivated. They had links to a number of identical sites that were impersonating Rebrickable and asked for the user to enter financial information such as credit card details.
Most of the accounts used were created specifically for this scam, some of them created many years ago. However, there were also 47 regular user accounts accessed by the scammer (via correct password logins) which were used to send messages. For these 47 breached accounts, their passwords were likely reused from other sites which were leaked over the years.
There is no indication that data from Rebrickable, such as passwords were hacked.
This is what the scammer''s site looked like if you clicked the link they sent you. You could even chat with the scammer.
How did Rebrickable Respond?
Here is a timeline of events (in Brisbane +10 timezone since that''s where Nathan lives).
8th October
00:19
First scammer message sent
01:18
We started to get Support Requests raised alerting us to spammers. The admin team started muting and banning accounts.
02:37
The admin team realised it is more than just a few spammer accounts (which is part of normal day-to-day operations) and decided to wake up Nathan.
02:46
Site-wide message added warning on a scam in progress + spam filters updated to reject new messages from the scammer.
02:53
Nathan took site offline to be able to properly assess the situation (and make some coffee).
03:07
Site restored with inbox and ability to send private messages completely disabled.
04:58
Discovered the scammer''s site DNS was served by Cloudflare so submitted an abuse report to them for one of the URLs in the message (at this time, did not realise multiple URLs were being used).
05:06
Cloudflare marked the site as a probable phishing attempt warning away anyone who visited, and reported the scam to the site''s hosting provider.
06:49
All accounts involved in the sending of the messages have now been banned, or muted for those with breached accounts. All usernames/emails that were modified during the attack were changed back.
07:50
Relevant private messages were deleted.
08:32
Identified 47 compromised accounts, reset their passwords and force logged out any active sessions. 124 other accounts that had new suspicious logons detected recently also had their passwords scrambled. Notifications were sent to all 171 affected users.
09:45
Messages sent to 4717 users who received the scammer message.
10:15
Removed site-wide alert message.
10:40
Re-enabled inbox, but sending of private messages still disabled.
9th October
07:45
Realised Cloudflare only took down one of the 15 URLs used in the messages. Submitted abuse reports for the other 14. Unfortunately, they didn''t action these as quickly as the first one.
10th October
05:20
Cloudflare responded to indicate the URLs were no longer available. A check showed the site was fully down this time. Either by the scammer themselves, or their hosting provider taking action from the initial abuse report.
10:39
Private messaging re-enabled and first batch of changes deployed - login verification system, minimum levels required to use external URLs or send to multiple recipients, a new auto-muting system.
11:00 - 17:00
Lots of tweaks and fixes to the new changes... sorry, it was a big change rushed through in a short timeframe.
11th October
10:45
Replaced login confirmation email links with a 6-digit code instead.
ongoing
Tweaks to spam, monitoring and moderation tools.
So a huge thank you to everyone who recognised the problem and reported the scammer, and of course the admin team for their quick work in containing the problem. While almost 5000 users received the message, it could have been a much bigger problem if it was left to run longer.
Do I need to do anything?
If you clicked the link AND entered financial information into the fake site, you should immediately contact your bank to get the card cancelled and inform them of the situation. We are not currently aware of anyone losing money from this. If you clicked the link but then thought this looks a bit fishy... and didn''t enter any information, there is no need to worry.
If you use a common password on Rebrickable as well as other sites, please reset your password and choose something unique. If you strugle to remember so many unique passwords consider using a password manager. Unique passwords make it much harder for scammers like this to access your accounts.
How can I tell if something is a scam?
There are a lot of things that made this attempt look suspicious. Most accounts on Rebrickable are free, we will never ask you to pay in order to get access to your account. We will never ask for bank details to verify your identity.
The users that the message came from had strange names such as BrickBot07 or Brickable_sup8 or VerificationBot22. We have only one bot account: Rebrickable, which is used to send all of the automated messages and is identified with the blue Bot badge in messages. Other messages from real admins will also have a red badge indicating their role.
')) AS "similarity", "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 "blog_article" LEFT OUTER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") WHERE ("blog_article"."is_active" AND "blog_article"."published_date" > '2023-11-16T23:59:53.907175+00:00'::timestamptz ANDNOT ("blog_article"."id" = 858)) ORDER BY 19 DESC, "blog_article"."published_date" DESCLIMIT 15
952.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(148)
related_articles = article.get_related_articles(num_sidebar_posts)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./blog/models.py in get_related_articles(289)
return list(Article.objects.select_related('author').filter(published_date__gt=timezone.now()-timedelta(days=365*3)).annotate(similarity=TrigramSimilarity('title', self.title)+TrigramSimilarity('body', body)).exclude(id=self.id).order_by('-similarity', '-published_date')[:num])
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", "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 "blog_article" LEFT OUTER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") LEFT OUTER JOIN "blog_articlestats" ON ("blog_article"."id" = "blog_articlestats"."article_id") WHERE ("blog_article"."is_active" AND "blog_article"."published_date" > '2025-11-15T23:59:54.862664+00:00'::timestamptz) ORDER BY "blog_articlestats"."hits" DESC LIMIT 15SELECT ••• FROM "blog_article" LEFT OUTER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") LEFT OUTER JOIN "blog_articlestats" ON ("blog_article"."id" = "blog_articlestats"."article_id") WHERE ("blog_article"."is_active" AND "blog_article"."published_date" > '2025-11-15T23:59:54.862664+00:00'::timestamptz) ORDER BY "blog_articlestats"."hits" DESCLIMIT 15
2.76
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(149)
popular_articles = Article.get_popular_articles(num_sidebar_posts)/home/nathan/rb/site/./cache/utils.py in cache_wrapper(101)
caches[cache_key].set(method_key, result, seconds)/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/hash.py in set(344)
return self._run_cmd("set", key, False, *args, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/hash.py in _run_cmd(322)
return self._safely_run_func(client, func, default_val, *args, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/hash.py in _safely_run_func(211)
result = func(*args, **kwargs)/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/base.py in set(1424)
return client.set(key, value, expire=expire, noreply=noreply, flags=flags)/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/base.py in set(475)
return self._store_cmd(b"set", {key: value}, expire, noreply, flags=flags)[key]/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/base.py in _store_cmd(1196)
data, data_flags = self.serde.serialize(key, data)/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/serde.py in serialize(119)
return self._serialize_func(key, value)/home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/serde.py in _python_memcache_serializer(58)
pickler.dump(value)
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
9 similar queries.
0.21
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
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" = 720) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 720) LIMIT 21
9 similar queries.
0.33
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(51)
{'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" = 605) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 605) LIMIT 21
9 similar queries.
0.22
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(52)
{'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
9 similar queries.
0.29
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(53)
{'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
9 similar queries.
0.24
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(54)
{'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" = 462) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 462) LIMIT 21
9 similar queries.
0.25
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(55)
{'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" = 279) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 279) LIMIT 21
9 similar queries.
0.21
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(56)
{'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" = 249) LIMIT 21SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 249) LIMIT 21
9 similar queries.
0.17
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
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 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('designer-spotlight'))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('designer-spotlight'))
8 similar queries.
2.70
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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('sets'))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('sets'))
8 similar queries.
2.29
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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('into-the-archives'))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('into-the-archives'))
8 similar queries.
2.22
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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('mini-moc-madness'))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('mini-moc-madness'))
8 similar queries.
2.20
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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('is-this-lego'))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('is-this-lego'))
8 similar queries.
2.30
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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('tips'))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('tips'))
8 similar queries.
2.23
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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('rebricksberg'))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('rebricksberg'))
8 similar queries.
2.23
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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('good-bad-ugly'))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('good-bad-ugly'))
8 similar queries.
2.22
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(150)
article_series_images = get_series()/home/nathan/rb/site/./blog/views.py in get_series(60)
s['num_posts'] = Article.objects.filter(tags__slug__iexact=s['tag']).count()
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"."published_date" = '2025-10-21T00:00:00.067572+00:00'::timestamptz AND "blog_article"."id" > 858) OR "blog_article"."published_date" > '2025-10-21T00:00:00.067572+00:00'::timestamptz)) ORDER BY "blog_article"."published_date" ASC, "blog_article"."id" ASC LIMIT 1SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND (("blog_article"."published_date" = '2025-10-21T00:00:00.067572+00:00'::timestamptz AND "blog_article"."id" > 858) OR "blog_article"."published_date" > '2025-10-21T00:00:00.067572+00:00'::timestamptz)) ORDER BY "blog_article"."published_date" ASC, "blog_article"."id" ASCLIMIT 1
0.57
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(155)
article.next = Article.get_next_by_published_date(article)/usr/lib/python3.10/functools.py in _method(388)
return self.func(cls_or_self, *self.args, *args, **keywords)
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"."published_date" = '2025-10-21T00:00:00.067572+00:00'::timestamptz AND "blog_article"."id" < 858) OR "blog_article"."published_date" < '2025-10-21T00:00:00.067572+00:00'::timestamptz)) ORDER BY "blog_article"."published_date" DESC, "blog_article"."id" DESC LIMIT 1SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND (("blog_article"."published_date" = '2025-10-21T00:00:00.067572+00:00'::timestamptz AND "blog_article"."id" < 858) OR "blog_article"."published_date" < '2025-10-21T00:00:00.067572+00:00'::timestamptz)) ORDER BY "blog_article"."published_date" DESC, "blog_article"."id" DESCLIMIT 1
0.45
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(159)
article.prev = Article.get_previous_by_published_date(article)/usr/lib/python3.10/functools.py in _method(388)
return self.func(cls_or_self, *self.args, *args, **keywords)
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" = 159879 LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 159879 LIMIT 21
0.13
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)
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_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
geo_data = user.geo.get_user_currency()/home/nathan/rb/site/./geo/geo.py in get_user_currency(253)
country = Country.objects.get(iso=country_code)
74
</a>
75
</li>
76
<li>
77
{% geo_currency request.user %}
78
</li>
79
{% comment %}
80
<li class="hidden-xs hidden-sm">
81
<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>
SELECT "blog_articlecategory"."id", "blog_articlecategory"."name" FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 3 LIMIT 21SELECT ••• FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 3 LIMIT 21
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)
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" = 'icedragonj' LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'icedragonj' LIMIT 21
2 similar queries.
Duplicated 2 times.
0.13
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/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)
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" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESCLIMIT 1
2 similar queries.
Duplicated 2 times.
0.12
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/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]
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" = '858' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" ANDNOT "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" = '858' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" ANDNOT "django_comments"."is_removed")
2 similar queries.
Duplicated 2 times.
11.18
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/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()
SELECT "blog_articlestats"."article_id", "blog_articlestats"."hits" FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 858 LIMIT 21SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 858 LIMIT 21
0.11
Connection: default
Transaction status: In transaction
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/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)
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" = 'icedragonj' LIMIT 21SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'icedragonj' LIMIT 21
2 similar queries.
Duplicated 2 times.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/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)
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" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESCLIMIT 1
2 similar queries.
Duplicated 2 times.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/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]
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" = '858' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" ANDNOT "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" = '858' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" ANDNOT "django_comments"."is_removed")
2 similar queries.
Duplicated 2 times.
0.28
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/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()
SELECTDISTINCT "taggit_tag"."id", "taggit_tag"."name", "taggit_tag"."slug", COUNT("blog_article"."id") AS "count" FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") LEFT OUTER JOIN "blog_article" ON ("taggit_taggeditem"."object_id" = "blog_article"."id" AND ("taggit_taggeditem"."content_type_id" = 12)) INNER JOIN "taggit_taggeditem" T5 ON ("taggit_tag"."id" = T5."tag_id") INNER JOIN "blog_article" T6 ON (T5."object_id" = T6."id" AND (T5."content_type_id" = 12)) WHERE ("django_content_type"."app_label" = 'blog' AND "django_content_type"."model" = 'article' AND T6."id" = 858) GROUP BY "taggit_tag"."id"SELECT ••• FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") LEFT OUTER JOIN "blog_article" ON ("taggit_taggeditem"."object_id" = "blog_article"."id" AND ("taggit_taggeditem"."content_type_id" = 12)) INNER JOIN "taggit_taggeditem" T5 ON ("taggit_tag"."id" = T5."tag_id") INNER JOIN "blog_article" T6 ON (T5."object_id" = T6."id" AND (T5."content_type_id" = 12)) WHERE ("django_content_type"."app_label" = 'blog' AND "django_content_type"."model" = 'article' AND T6."id" = 858) GROUP BY "taggit_tag"."id"
0.82
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)
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-11-15T23:59:54.933056+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.933136+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.933038+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.933264+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-15T23:59:54.933056+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.933136+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.933038+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.933264+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
3.30
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
265
<h4 class="hidden-xs">TAGS</h4>
266
{% include 'blog/includes/render_tags.html' %}
267
268
{% render_banner 262 350 2 %}
269
270
{% include '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-11-15T23:59:54.933056+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.933136+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.933038+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.933264+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-11-15T23:59:54.933056+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.933136+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.933038+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.933264+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
4 similar queries.
1.74
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
265
<h4 class="hidden-xs">TAGS</h4>
266
{% include 'blog/includes/render_tags.html' %}
267
268
{% render_banner 262 350 2 %}
269
270
{% include '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-11-15T23:59:54.943667+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.943759+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.943652+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.943884+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-15T23:59:54.943667+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.943759+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.943652+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.943884+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
1.56
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
37
{% include 'blog/includes/render_posts_preview.html' with article=related_article %}
38
</div>
39
{% endfor %}
40
{% render_banner 262 600 5 %}
41
</div>
42
{% endif %}
43
<div id="tab_series" class="tab-pane {% if not related_articles %}active{% endif %}" role="tabpanel">
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-11-15T23:59:54.943667+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.943759+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.943652+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.943884+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-11-15T23:59:54.943667+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.943759+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.943652+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.943884+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
4 similar queries.
1.28
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
37
{% include 'blog/includes/render_posts_preview.html' with article=related_article %}
38
</div>
39
{% endfor %}
40
{% render_banner 262 600 5 %}
41
</div>
42
{% endif %}
43
<div id="tab_series" class="tab-pane {% if not related_articles %}active{% endif %}" role="tabpanel">
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-11-15T23:59:54.948790+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.948858+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.948779+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.948981+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-15T23:59:54.948790+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.948858+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.948779+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.948981+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
1.21
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
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-11-15T23:59:54.948790+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.948858+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.948779+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.948981+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-11-15T23:59:54.948790+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.948858+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.948779+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.948981+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
4 similar queries.
1.16
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
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-11-15T23:59:54.955339+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.955407+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.955328+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.955524+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-15T23:59:54.955339+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.955407+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.955328+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.955524+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
1.27
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(291)
if not banners:
74
{% include 'blog/includes/render_posts_preview.html' with article=popular_article %}
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-11-15T23:59:54.955339+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.955407+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.955328+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.955524+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-11-15T23:59:54.955339+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-15T23:59:54.955407+00:00'::timestamptz OR "ads_banner"."end_date" ISNULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-15T23:59:54.955328+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" ISNULLOR "ads_banner"."end_date" > '2026-11-15T23:59:54.955524+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASCLIMIT 1
4 similar queries.
1.19
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./blog/views.py in blog_article_w_slug(236)
return blog_article(request, article_id)/home/nathan/rb/site/./blog/views.py in blog_article(213)
return cached_blog_article(request, article.id)/home/nathan/rb/site/./rb/views/decorators/auth.py in wrapper(169)
result = view_func(request, *args, **kwargs)/home/nathan/rb/site/./blog/views.py in cached_blog_article(209)
return render(request, 'blog/blog_article.html', context)/home/nathan/rb/site/./ads/templatetags/ads/drawing.py in render_banner(298)
banner = banners.order_by('-area', '?')[0]
74
{% include 'blog/includes/render_posts_preview.html' with article=popular_article %}