EDIT MODE

Rebrickable has ran a monthly raffle for pro plan members since 2018 giving away over $7000 worth of LEGO. It's a great opportunity to support Rebrickable and get some free LEGO. If you didn't know about the raffle you can read about it here.

We wanted to build on the raffle in a way that better represents Rebrickable. We are a MOC building site and want to encourage that in the LEGO community. We will be doing this by running MOC Designer Quarterly Competitions AND MOC Designer Monthly Draws. We want to see your creativity, joining in can win you some great prizes.

The monthly Pro-Plan raffle isn't going away, so for those of you who don't have the confidence to build a MOC you can still win a prize by being a Pro-Plan member.

The Competitions

Quarterly Competitions - MOC Designer Quarterly Competition

Each quarter the competition will have different criteria. Whether it's Robot Apocalypse, Beach Day, reimagine a plane of the future, whatever we come up with we want you to build it. We are aiming to encourage everyone to be involved at some point but also wanted each competition to offer a unique challenge too. To enter a MOC must have the specific competition's Tag on it which will be announced with the competition's blog announcement. The following may change as competitions evolve but here is a rough guide for the types of competitions we will be running in the first year.

  • A random draw contest for Pro and Designer Plan users.
  • A large MOC (2000+ parts) random draw contest.
  • A User judged contest.
  • An Admin judged contest.

Monthly Competitions - MOC Designer Monthly Draw

No content criteria but a MOC does have to use at least 150 parts. Publish a MOC in that month (Midnight on the first day of the month thru 11:59 on the last day of the month UTC) and tag it using the month and year and you will be entered into the draw. For example for May's competition you need to tag it "MOC Competition - May 2023" as a single tag, with the month fully spelt out. If you tag it incorrectly you will not be entered into the draw. You do also have to meet all the general qualification rules below though.

Qualification

In order for your MOC to qualify for a competition it has to meet several criteria.

  1. It must meet the competition's specifically designated requirements. For MOC Designer Monthly Draws this is just publish a MOC in that month. For MOC Designer Quarterly Competitions, the criteria will be announced in a blog post before the start date for the contest.
  2. It must only be a MOC published within the contest dates. Existing MOCs are not eligible.
  3. MOC entries must meet all the regular rules for submitting a MOC on Rebrickable. If your MOC is found to be breaking any of Rebrickable's rules it will be disqualified.
  4. You must be in good standing with Rebrickable. Any overdue balances at the end of the competition or draw entry period will forfeit any entries.
  5. Sorry, MOCs that can be easily generated using software are excluded from competitions. This means no mosaics/pixel art.

Both Free MOCs and Premium MOCs will qualify unless the competition's specific rules state otherwise. Unfortunately admin team members are not eligible to enter competitions.

Prizes

The MOC Designer Monthly Draw will win you $100 to purchase LEGO, MOCs, parts, whatever you desire. You will only be eligible to win at most once every 12 months.

The MOC Designer Quarterly Competitions will have larger prizes that will be announced with the competition announcement blog post.

For those keeping track you now have 3 ways to win: Pro-Plan Monthly Raffle, MOC Designer Monthly Draw, and the MOC Designer Quarterly Competition.

Ready...Get Set...

MOC Designer Monthly Draws are beginning immediately. Any MOCs published from UTC midnight May 1st will qualify so make sure you go back and add the tag MOC Competition - May 2023. Any MOCs published and tagged until UTC 11:59pm May 31st will be entered into the draw.

MOC Designer Quarterly Competitions will begin July 1st. We will publish the blog post with all the competition details early June to give you some time to design something.

We can't wait to see what you all come up with. Wishing you all good luck and great designing.

...GO!

Update: 05/21/2023

As was bound to be the case Users have a way of thinking of things we overlooked. MOC Bundles do not qualify for any competitions. We have had some people publish a bundle of their existing MOCs that originally fell outside the dates for the current competition. Bundling existing MOCs does not count as a newly published MOC. A bundle of MOCs that are not already on Rebrickable (color variation bundles for example) are ok.

It's also worth noting inactive MOCs do not qualify for competitions either. 

Disclaimer: Rebrickable Competitions is not affiliated with nor endorsed by The LEGO Group or any competitions organized by them, including LEGO Ideas and Bricklink Designer Program. (© 2023 Rebrickable)

RebrickMat - LEGO Building Mat
LOTR Rivendell
DJDT

Time

Resource usage

Resource Value
User CPU time 232.222 msec
System CPU time 6.238 msec
Total CPU time 238.460 msec
Elapsed time 1249.311 msec
Context switches 197 voluntary, 17 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 1002.26 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" = 588)
 LIMIT
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 588) LIMIT 21
9 similar queries.
0.32

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", 'Introducing Design Competitions') + SIMILARITY("blog_article"."body", 'Rebrickable has ran a monthly raffle for pro plan members since 2018 giving away over $7000 worth of LEGO. It''s a great opportunity to support Rebrickable and get some free LEGO. If you didn''t know about the raffle you can read about it here. We wanted to build on the raffle in a way that better represents Rebrickable. We are a MOC building site and want to encourage that in the LEGO community. We will be doing this by running MOC Designer Quarterly Competitions AND MOC Designer Monthly Draws. We want to see your creativity, joining in can win you some great prizes. The monthly Pro-Plan raffle isn''t going away, so for those of you who don''t have the confidence to build a MOC you can still win a prize by being a Pro-Plan member. The Competitions Quarterly Competitions - MOC Designer Quarterly Competition Each quarter the competition will have different criteria. Whether it''s Robot Apocalypse, Beach Day, reimagine a plane of the future, whatever we come up with we want you to build it. We are aiming to encourage everyone to be involved at some point but also wanted each competition to offer a unique challenge too. To enter a MOC must have the specific competition''s Tag on it which will be announced with the competition''s blog announcement. The following may change as competitions evolve but here is a rough guide for the types of competitions we will be running in the first year. A random draw contest for Pro and Designer Plan users. A large MOC (2000+ parts) random draw contest. A User judged contest. An Admin judged contest. Monthly Competitions - MOC Designer Monthly Draw No content criteria but a MOC does have to use at least 150 parts. Publish a MOC in that month (Midnight on the first day of the month thru 11:59 on the last day of the month UTC) and tag it using the month and year and you will be entered into the draw. For example for May''s competition you need to tag it "MOC Competition - May 2023" as a single tag, with the month fully spelt out. If you tag it incorrectly you will not be entered into the draw. You do also have to meet all the general qualification rules below though. Qualification In order for your MOC to qualify for a competition it has to meet several criteria. It must meet the competition''s specifically designated requirements. For MOC Designer Monthly Draws this is just publish a MOC in that month. For MOC Designer Quarterly Competitions, the criteria will be announced in a blog post before the start date for the contest. It must only be a MOC published within the contest dates. Existing MOCs are not eligible. MOC entries must meet all the regular rules for submitting a MOC on Rebrickable. If your MOC is found to be breaking any of Rebrickable''s rules it will be disqualified. You must be in good standing with Rebrickable. Any overdue balances at the end of the competition or draw entry period will forfeit any entries. Sorry, MOCs that can be easily generated using software are excluded from competitions. This means no mosaics/pixel art. Both Free MOCs and Premium MOCs will qualify unless the competition''s specific rules state otherwise. Unfortunately admin team members are not eligible to enter competitions. Prizes The MOC Designer Monthly Draw will win you $100 to purchase LEGO, MOCs, parts, whatever you desire. You will only be eligible to win at most once every 12 months. The MOC Designer Quarterly Competitions will have larger prizes that will be announced with the competition announcement blog post. For those keeping track you now have 3 ways to win: Pro-Plan Monthly Raffle, MOC Designer Monthly Draw, and the MOC Designer Quarterly Competition. Ready...Get Set... MOC Designer Monthly Draws are beginning immediately. Any MOCs published from UTC midnight May 1st will qualify so make sure you go back and add the tag MOC Competition - May 2023. Any MOCs published and tagged until UTC 11:59pm May 31st will be entered into the draw. MOC Designer Quarterly Competitions will begin July 1st. We will publish the blog post with all the competition details early June to give you some time to design something. We can''t wait to see what you all come up with. Wishing you all good luck and great designing. ...GO! Update: 05/21/2023 As was bound to be the case Users have a way of thinking of things we overlooked. MOC Bundles do not qualify for any competitions. We have had some people publish a bundle of their existing MOCs that originally fell outside the dates for the current competition. Bundling existing MOCs does not count as a newly published MOC. A bundle of MOCs that are not already on Rebrickable (color variation bundles for example) are ok. It''s also worth noting inactive MOCs do not qualify for competitions either.  Disclaimer: Rebrickable Competitions is not affiliated with nor endorsed by The LEGO Group or any competitions organized by them, including LEGO Ideas and Bricklink Designer Program. (© 2023 Rebrickable)')) 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-17T00:00:36.186870+00:00'::timestamptz AND NOT ("blog_article"."id" = 588))
 ORDER BY
19 DESC, "blog_article"."published_date" DESC
 LIMIT
15
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", 'Introducing Design Competitions') + SIMILARITY("blog_article"."body", 'Rebrickable has ran a monthly raffle for pro plan members since 2018 giving away over $7000 worth of LEGO. It''s a great opportunity to support Rebrickable and get some free LEGO. If you didn''t know about the raffle you can read about it here. We wanted to build on the raffle in a way that better represents Rebrickable. We are a MOC building site and want to encourage that in the LEGO community. We will be doing this by running MOC Designer Quarterly Competitions AND MOC Designer Monthly Draws. We want to see your creativity, joining in can win you some great prizes. The monthly Pro-Plan raffle isn''t going away, so for those of you who don''t have the confidence to build a MOC you can still win a prize by being a Pro-Plan member. The Competitions Quarterly Competitions - MOC Designer Quarterly Competition Each quarter the competition will have different criteria. Whether it''s Robot Apocalypse, Beach Day, reimagine a plane of the future, whatever we come up with we want you to build it. We are aiming to encourage everyone to be involved at some point but also wanted each competition to offer a unique challenge too. To enter a MOC must have the specific competition''s Tag on it which will be announced with the competition''s blog announcement. The following may change as competitions evolve but here is a rough guide for the types of competitions we will be running in the first year. A random draw contest for Pro and Designer Plan users. A large MOC (2000+ parts) random draw contest. A User judged contest. An Admin judged contest. Monthly Competitions - MOC Designer Monthly Draw No content criteria but a MOC does have to use at least 150 parts. Publish a MOC in that month (Midnight on the first day of the month thru 11:59 on the last day of the month UTC) and tag it using the month and year and you will be entered into the draw. For example for May''s competition you need to tag it "MOC Competition - May 2023" as a single tag, with the month fully spelt out. If you tag it incorrectly you will not be entered into the draw. You do also have to meet all the general qualification rules below though. Qualification In order for your MOC to qualify for a competition it has to meet several criteria. It must meet the competition''s specifically designated requirements. For MOC Designer Monthly Draws this is just publish a MOC in that month. For MOC Designer Quarterly Competitions, the criteria will be announced in a blog post before the start date for the contest. It must only be a MOC published within the contest dates. Existing MOCs are not eligible. MOC entries must meet all the regular rules for submitting a MOC on Rebrickable. If your MOC is found to be breaking any of Rebrickable''s rules it will be disqualified. You must be in good standing with Rebrickable. Any overdue balances at the end of the competition or draw entry period will forfeit any entries. Sorry, MOCs that can be easily generated using software are excluded from competitions. This means no mosaics/pixel art. Both Free MOCs and Premium MOCs will qualify unless the competition''s specific rules state otherwise. Unfortunately admin team members are not eligible to enter competitions. Prizes The MOC Designer Monthly Draw will win you $100 to purchase LEGO, MOCs, parts, whatever you desire. You will only be eligible to win at most once every 12 months. The MOC Designer Quarterly Competitions will have larger prizes that will be announced with the competition announcement blog post. For those keeping track you now have 3 ways to win: Pro-Plan Monthly Raffle, MOC Designer Monthly Draw, and the MOC Designer Quarterly Competition. Ready...Get Set... MOC Designer Monthly Draws are beginning immediately. Any MOCs published from UTC midnight May 1st will qualify so make sure you go back and add the tag MOC Competition - May 2023. Any MOCs published and tagged until UTC 11:59pm May 31st will be entered into the draw. MOC Designer Quarterly Competitions will begin July 1st. We will publish the blog post with all the competition details early June to give you some time to design something. We can''t wait to see what you all come up with. Wishing you all good luck and great designing. ...GO! Update: 05/21/2023 As was bound to be the case Users have a way of thinking of things we overlooked. MOC Bundles do not qualify for any competitions. We have had some people publish a bundle of their existing MOCs that originally fell outside the dates for the current competition. Bundling existing MOCs does not count as a newly published MOC. A bundle of MOCs that are not already on Rebrickable (color variation bundles for example) are ok. It''s also worth noting inactive MOCs do not qualify for competitions either.  Disclaimer: Rebrickable Competitions is not affiliated with nor endorsed by The LEGO Group or any competitions organized by them, including LEGO Ideas and Bricklink Designer Program. (© 2023 Rebrickable)')) 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-17T00:00:36.186870+00:00'::timestamptz AND NOT ("blog_article"."id" = 588)) ORDER BY 19 DESC, "blog_article"."published_date" DESC LIMIT 15
926.55

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-16T00:00:37.124411+00:00'::timestamptz)
 ORDER BY
"blog_articlestats"."hits" DESC
 LIMIT
15
SELECT ••• 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-16T00:00:37.124411+00:00'::timestamptz) ORDER BY "blog_articlestats"."hits" DESC LIMIT 15
2.61

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
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 646) 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(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
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 720) LIMIT 21
9 similar queries.
0.38

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
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 605) 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(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
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 705) LIMIT 21
9 similar queries.
0.31

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
21
SELECT ••• 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
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 462) 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(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
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 279) LIMIT 21
9 similar queries.
0.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(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
21
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND "blog_article"."id" = 249) LIMIT 21
9 similar queries.
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(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.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(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.32

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.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(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.34

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.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(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.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(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.26

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.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(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" = '2023-05-06T00:00:00.065825+00:00'::timestamptz AND "blog_article"."id" > 588) OR "blog_article"."published_date" > '2023-05-06T00:00:00.065825+00:00'::timestamptz))
 ORDER BY
"blog_article"."published_date" ASC, "blog_article"."id" ASC
 LIMIT
1
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND (("blog_article"."published_date" = '2023-05-06T00:00:00.065825+00:00'::timestamptz AND "blog_article"."id" > 588) OR "blog_article"."published_date" > '2023-05-06T00:00:00.065825+00:00'::timestamptz)) ORDER BY "blog_article"."published_date" ASC, "blog_article"."id" ASC LIMIT 1
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(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" = '2023-05-06T00:00:00.065825+00:00'::timestamptz AND "blog_article"."id" < 588) OR "blog_article"."published_date" < '2023-05-06T00:00:00.065825+00:00'::timestamptz))
 ORDER BY
"blog_article"."published_date" DESC, "blog_article"."id" DESC
 LIMIT
1
SELECT ••• FROM "blog_article" WHERE ("blog_article"."is_active" AND (("blog_article"."published_date" = '2023-05-06T00:00:00.065825+00:00'::timestamptz AND "blog_article"."id" < 588) OR "blog_article"."published_date" < '2023-05-06T00:00:00.065825+00:00'::timestamptz)) ORDER BY "blog_article"."published_date" DESC, "blog_article"."id" DESC LIMIT 1
0.47

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" = 83025
 LIMIT
21
SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 83025 LIMIT 21
0.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)

54 "dateModified": "{{ article.published_date|date:'c' }}",
55 "author": {
56 "@type": "Person",
57 "name": "{{ article.author.username }}"
58 },
59 "publisher": {
60 "@type": "Organization",
61 "name": "Rebrickable",

/home/nathan/rb/site/blog/templates/blog/blog_article.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
21
SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./blog/views.py in blog_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>

/home/nathan/rb/site/rb/templates/rb/includes/topbar.html

SELECT "blog_articlecategory"."id",
       "blog_articlecategory"."name"
  FROM
"blog_articlecategory"
 WHERE
"blog_articlecategory"."id" = 2
 LIMIT
21
SELECT ••• FROM "blog_articlecategory" WHERE "blog_articlecategory"."id" = 2 LIMIT 21
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)

18
19 {% block breadcrumbs %}
20 {% breadcrumb "Blog Posts" "blog_index" %}
21 {% breadcrumb article.category "blog_by_category" article.category %}
22 {% breadcrumb article.title "blog_article" article.id %}
23 {% endblock %}
24
25 {% block meta_description %}{{ article.meta_description }}{% endblock meta_description %}

/home/nathan/rb/site/blog/templates/blog/blog_article.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" = 'Jared_Wilhelm'
 LIMIT
21
SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'Jared_Wilhelm' 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)

92 <!--<div class="flex-row">
93 <div class="mr-10 hidden-xs" style="width: 50px">
94 <a href="{% url 'blog_by_author' article.author.username %}">
95 <img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">
96 </a>
97 </div>
98 <div class="flex-expand">
99 <div class="heading-title heading-border-bottom heading-color mb-10">

/home/nathan/rb/site/blog/templates/blog/blog_article.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" = 83025
 ORDER BY
"avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT
1
SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 83025 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 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]

92 <!--<div class="flex-row">
93 <div class="mr-10 hidden-xs" style="width: 50px">
94 <a href="{% url 'blog_by_author' article.author.username %}">
95 <img data-src="{% avatar_url article.author.username 75 %}" width="50px" height="50px">
96 </a>
97 </div>
98 <div class="flex-expand">
99 <div class="heading-title heading-border-bottom heading-color mb-10">

/home/nathan/rb/site/blog/templates/blog/blog_article.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" = '588' 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" = '588' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
2 similar queries. Duplicated 2 times.
15.63

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

24
25 <div class="rb-article-card__meta flex-right hidden-xs hidden-sm">
26 {% if full_layout %}
27 {% get_comment_count for article as num_comments %}
28 <div>
29 <a href="{% url 'blog_article_w_slug' article.id article.slug %}#comments">
30 <i class="fa fa-comment-o"></i>
31 {{ num_comments }}<span> 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" = 588
 LIMIT
21
SELECT ••• FROM "blog_articlestats" WHERE "blog_articlestats"."article_id" = 588 LIMIT 21
0.21

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)

33 </div>
34 {% endif %}
35
36 {% if article.stats.hits > 100 %}
37 <div>
38 <i class="fa fa-line-chart"></i>
39 <span>{{ article.stats.hits|floor_100 }} views</span>
40 </div>

/home/nathan/rb/site/blog/templates/blog/includes/render_article_byline.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" = 'Jared_Wilhelm'
 LIMIT
21
SELECT ••• FROM "auth_user" WHERE "auth_user"."username" = 'Jared_Wilhelm' LIMIT 21
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(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)

107 <div class="rb-article-card__top">
108 <span class="rb-article-card__avatar hidden-xs">
109 <a href="{% url 'blog_by_author' article.author.username %}">
110 <img data-src="{% avatar_url article.author.username 75 %}" width="50" height="50" alt="{{ article.author.username }}">
111 </a>
112 </span>
113
114 <h1 id="blog_title" class="rb-article-card__title rb-article-card__title--lg">

/home/nathan/rb/site/blog/templates/blog/blog_article.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" = 83025
 ORDER BY
"avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
 LIMIT
1
SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 83025 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1
2 similar queries. Duplicated 2 times.
0.09

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]

107 <div class="rb-article-card__top">
108 <span class="rb-article-card__avatar hidden-xs">
109 <a href="{% url 'blog_by_author' article.author.username %}">
110 <img data-src="{% avatar_url article.author.username 75 %}" width="50" height="50" alt="{{ article.author.username }}">
111 </a>
112 </span>
113
114 <h1 id="blog_title" class="rb-article-card__title rb-article-card__title--lg">

/home/nathan/rb/site/blog/templates/blog/blog_article.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" = '588' 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" = '588' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
2 similar queries. Duplicated 2 times.
0.35

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

24
25 <div class="rb-article-card__meta flex-right hidden-xs hidden-sm">
26 {% if full_layout %}
27 {% get_comment_count for article as num_comments %}
28 <div>
29 <a href="{% url 'blog_article_w_slug' article.id article.slug %}#comments">
30 <i class="fa fa-comment-o"></i>
31 {{ num_comments }}<span> Comment{{ num_comments|pluralize }}</span>

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

SELECT DISTINCT "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" = 588)
 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" = 588) GROUP BY "taggit_tag"."id"
21.63

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)

1 <div id="blog_tags" class="clearfix tags_list mb-30">
2 {% for tag in article.tags_w_count %}
3 <a href="{% url 'blog_by_tag' tag.slug %}" class="tag {% if request.user.is_blogger %}deltag{% endif %}">
4 <span class="txt">{{ tag.name }}</span>
5 <span class="num">
6 <span class="relative">

/home/nathan/rb/site/blog/templates/blog/includes/render_tags.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-16T00:00:37.225225+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.225370+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.225200+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.225563+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.225225+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.225370+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.225200+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.225563+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
2.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:

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' %}
271
272 <div class="mt-30">

/home/nathan/rb/site/blog/templates/blog/blog_article.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-16T00:00:37.225225+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.225370+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.225200+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.225563+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
 ORDER BY
1 DESC, RANDOM() ASC
 LIMIT
1
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.225225+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.225370+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 350 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.225200+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.225563+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1
4 similar queries.
2.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(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' %}
271
272 <div class="mt-30">

/home/nathan/rb/site/blog/templates/blog/blog_article.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-16T00:00:37.236196+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.236274+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.236183+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.236397+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.236196+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.236274+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.236183+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.236397+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
2.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/./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">
44 {% for series in article_series_images %}

/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-11-16T00:00:37.236196+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.236274+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.236183+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.236397+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
 ORDER BY
1 DESC, RANDOM() ASC
 LIMIT
1
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.236196+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.236274+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.236183+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.236397+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 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]

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">
44 {% for series in article_series_images %}

/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-11-16T00:00:37.241792+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.241860+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.241781+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.241984+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.241792+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.241860+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.241781+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.241984+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
1.53

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:

66 </div>
67 {% endfor %}
68
69 {% render_banner 262 600 5 %}
70 </div>
71 <div id="tab_popular" class="tab-pane" role="tabpanel">
72 {% for popular_article in popular_articles %}
73 <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-11-16T00:00:37.241792+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.241860+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.241781+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.241984+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
 ORDER BY
1 DESC, RANDOM() ASC
 LIMIT
1
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.241792+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.241860+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.241781+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.241984+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1
4 similar queries.
1.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/./ads/templatetags/ads/drawing.py in render_banner(298)
  banner = banners.order_by('-area', '?')[0]

66 </div>
67 {% endfor %}
68
69 {% render_banner 262 600 5 %}
70 </div>
71 <div id="tab_popular" class="tab-pane" role="tabpanel">
72 {% for popular_article in popular_articles %}
73 <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-11-16T00:00:37.248946+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.249017+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.248930+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.249135+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.248946+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.249017+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.248930+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.249135+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
4 similar queries.
1.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(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 %}
75 </div>
76 {% endfor %}
77 {% render_banner 262 600 5 %}
78 </div>
79 </div>
80 </div>
81

/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-11-16T00:00:37.248946+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.249017+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.248930+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.249135+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US')
 ORDER BY
1 DESC, RANDOM() ASC
 LIMIT
1
SELECT ••• FROM "ads_banner" WHERE ("ads_banner"."start_date" < '2026-11-16T00:00:37.248946+00:00'::timestamptz AND ("ads_banner"."end_date" > '2026-11-16T00:00:37.249017+00:00'::timestamptz OR "ads_banner"."end_date" IS NULL) AND "ads_banner"."height" <= 600 AND "ads_banner"."start_date" < '2026-11-16T00:00:37.248930+00:00'::timestamptz AND "ads_banner"."width" <= 262 AND ("ads_banner"."end_date" IS NULL OR "ads_banner"."end_date" > '2026-11-16T00:00:37.249135+00:00'::timestamptz) AND "ads_banner"."country_code" = 'US') ORDER BY 1 DESC, RANDOM() ASC LIMIT 1
4 similar queries.
1.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/./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 %}
75 </div>
76 {% endfor %}
77 {% render_banner 262 600 5 %}
78 </div>
79 </div>
80 </div>
81

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

Log messages

No messages logged.