Andrew Welch · Insights · #craftcms #cache #performance

Published , updated · 5 min read ·


Please consider 🎗 sponsoring me 🎗 to keep writing articles like this.

The Craft cache Tag In-Depth

Craft CMS has a {% cache %} tag that can help with per­for­mance, if used effec­tive­ly. Here’s how it works.

Update: This arti­cle has been updat­ed to cov­er both Craft CMS 2.x and Craft CMS 3.x

The {% cache %} tag avail­able in Craft CMS can help with per­for­mance, if you under­stand it and apply it cor­rect­ly. How­ev­er, as so elo­quent­ly stat­ed on the Craft CMS Tem­plat­ing Docs page:

If you’re suffering from abnormal page load times, you may be experiencing a suboptimal hosting environment. Please consult a specialist before trying {% cache %}. {% cache %} is not a substitute for fast database connections, efficient templates, or moderate query counts. Possible side effects include stale content, excessively long-running background tasks, stuck tasks, and in rare cases, death. Ask your hosting provider if {% cache %} is right for you.

In oth­er words, the {% cache %} tag is not some­thing you should use to mask per­for­mance prob­lems, be they from an ane­mic or poor­ly con­fig­ured serv­er, or tem­plates that are writ­ten inef­fi­cient­ly. You can’t just write hor­ri­bly inef­fi­cient tem­plates, slap them up on GoDad­dy shared host­ing, and expect to ​“solve” the per­for­mance prob­lems with the {% cache %} tag. We call that putting lip­stick on a pig.

How­ev­er, it can be an extreme­ly use­ful tool once you under­stand what it is, and how to uti­lize it.

Link Why Do We Cache?

The gen­er­al idea behind a cache is that we want to keep data that we access fre­quent­ly around in a for­mat that can quick­ly be retrieved. We do this in our dai­ly lives, too. When you wake up in the morn­ing and open up the med­i­cine cab­i­net, every­thing you need to get ready is right there wait­ing for you.

Imag­ine how much time it would take you to get ready in the morn­ing if your toi­letries were scat­tered all over your house, and you had to hunt for them every morning…

We are pre­flight­ing our morn­ing rou­tine by caching the stuff we need all in one place, so we can get our job of get­ting ready done efficiently.

And that’s exact­ly why we cache data on our com­put­ers as well. Rather than com­pute some insane­ly com­pli­cat­ed for­mu­la pulled from a mas­sive dataset each time a web­page is loaded, we can cache it. We cal­cu­late the result at a non-crit­i­cal time, and present this cached result to the user when they load the page.

Every­one’s happy.

Link What Exactly Does the {% cache %} Tag Do?

So now that we under­stand why we want to cache data, let’s have a look at exact­ly how the {% cache %} tag in Craft CMS works. Here’s a pret­ty stan­dard chunk of Twig code:

{% for entry in craft.entries.section('blog').relatedTo(someCategory) %}
    <article>
        <h1>{{ entry.title }}</h1>
        <p>{{ entry.summary }}</p>
        <img src="{{ entry.image.first().getUrl(myTransform) }}">
    </article>
{% endfor %}

This code gen­er­ates a num­ber of data­base queries to pull in all of our blog entries that are relat­ed to someCategory and then loops through and dis­plays them. The {{ entry.image.first().getUrl(myTransform) }} actu­al­ly gen­er­ates sev­er­al data­base queries each time through the loop, because Assets are rela­tions that need to be looked up, and it has to look up the Asset trans­form. This is called the N+1 query prob­lem, and it basi­cal­ly just means that the more entries we have, the slow­er things are gonna get.

Do we real­ly need to do all of these data­base queries every time some­one loads our web page? Nope. We only post a new blog entry once a week at best; there’s no rea­son to do all of these data­base queries every sin­gle time a page is loaded.

So instead, we can wrap it in a {% cache %} tag:

{% cache %}
    {% for entry in craft.entries.section('blog').relatedTo(someCategory) %}
        <article>
            <h1>{{ entry.title }}</h1>
            <p>{{ entry.summary }}</p>
            <img src="{{ entry.image.first().getUrl(myTransform) }}">
        </article>
    {% endfor %}
{% endcache %}

All that the {% cache %} tag does is cap­ture the parsed out­put of what­ev­er it’s wrapped around, and stores the result as text in the data­base. So instead of a bunch of queries for our entries, and a num­ber of queries for our entry.image.first().getUrl(myTransform) each time through the loop, we only end up with one query for our cached result.

This is why we want to use {% cache %} tags around blocks of Twig code that are either com­pute-inten­sive, or blocks of Twig code that gen­er­ate a large num­ber of data­base queries. If you just wrap plain old HTML text in {% cache %} tags, you won’t see any gains. It might even be ever so slight­ly slow­er, because we’ve added a data­base query where before there was none.

Tan­gent: Astute read­ers will note that the above exam­ple is a per­fect can­di­date for Eager Load­ing, but that’s beyond the scope of this article.

If you have devMode enabled, you can view your JavaScript Con­sole to see the num­ber of data­base queries exe­cut­ed on a page. Here’s what it looks like for this blog page you’re read­ing right now, with­out {% cache %} tags:

With­out {% cache %} tags

And here’s what the same blog page looks like with {% cache %} tags judi­cious­ly used:

With {% cache %} tags

We went from 102 data­base queries down to 43 data­base queries, and the time these queries took went from 1.84s down to just 0.49s! This is a huge gain, for very lit­tle work! And the num­ber of queries for the page with­out {% cache %} tags will keep going up as we add more blog entries, while the num­ber of queries for our cached page will stay con­stant. We have sub­sti­tut­ed many data­base queries for few­er, which results in bet­ter performance.

The key take-away here is that what the {% cache %} tag is doing is stor­ing the parsed out­put of the Twig code that’s inside of it. If you have Twig code such as {{ now|date("M d, Y") }} inside a {% cache %} tag, what’s saved in the cache is not the Twig code, but rather the parsed result (in this case, a date). So the date dis­played on the web­page is not going to change as long as the data is cached.

So if our code is:

{% cache %}
    {{ now|date("M d, Y") }}
{% endcache %}

What’s actu­al­ly saved in the data­base for this cached chunk of Twig code is just:

Nov 30, 2016

Tan­gent: The cacheDuration Gen­er­al Con­fig Set­ting deter­mines how long a tem­plate cache will be kept around. This set­ting defaults to P1D (1 day, or 24 hours), which means that your caches are going to be regen­er­at­ed every 24 hours. While this is a sen­si­ble default set­ting, it is a bit con­ser­v­a­tive, giv­en Craft’s auto­mat­ic cache break­ing. I typ­i­cal­ly set it to cacheDuration => false in my craft/config/general.php file, which means that the tem­plate caches nev­er expire on their own, they only are regen­er­at­ed when con­tent inside the {% cache %} tags changes. For a dis­cus­sion of how to use mul­ti-envi­ron­ment con­fig set­tings, check out the Mul­ti-Envi­ron­ment Con­fig for Craft CMS article.

Link Cache-Busters!

That brings up an inter­est­ing conun­drum. What hap­pens if some­one changes one of the blog entries that was inside of our {% cache %} tags? Craft is actu­al­ly pret­ty clever about it: it keeps track of any ele­ments (entries, assets, etc.) that are inside of your {% cache %} tags, and will mark the cache as being stale if they have changed. So it will auto­mat­i­cal­ly break the cache for you, caus­ing it to regen­er­ate and re-cache the data.

This is great, but we also have to do our jobs being smart about what we cache, and how we cache it. For exam­ple, a typ­i­cal blog page will have the blog entry itself, as well as a ​“blog archives” sec­tion that lists all of our old­er blog entries.

Now, we could just wrap the entire tem­plate in {% cache %} tags and call it a day. How­ev­er, think about what hap­pens when a new blog is pub­lished: it will inval­i­date every sin­gle blog page cache, because our archives changed with the addi­tion of a new blog post! This seems a bit sil­ly, because our oth­er blogs entries did­n’t change at all. All that changed was our blog archives sec­tion, to list the new blog entry.

If you think about it from an abstract point of view, we real­ly have two enti­ties we want to cache in this case:

  1. The blog entry itself
  2. The blog archives

Because they real­ly are inde­pen­dent of each oth­er. We might add a new blog post that would cause the blog archives to need to change, but this does­n’t affect our each blog entry.

Fur­ther, every sin­gle blog entry page is going to share the same exact blog archives sec­tion. So, we can do some­thing like this:

Link Craft 2.x Example

This is an exam­ple that cov­ers Craft 2.x specif­i­cal­ly; although most of the code is sim­i­lar for Craft 3.x, the way the default cache key is deter­mined is different.

{# -- Our blog entry -- #}
{% cache globally using key craft.request.path %}
    <article>
        <h1>{{ entry.title }}</h1>
        <p>{{ entry.body }}</p>
        <img src="{{ entry.image.first().getUrl(myTransform) }}">
    </article>
{% endcache %}

{# -- Our blog archives -- #}
{% cache globally using key "blog-archives" %}
    <section>
        {% for blogArchive in craft.entries.section('blog') %}
            <h1>{{ blogArchive.title }}</h1>
            <p>{{ blogArchive.summary }}</p>
        {% endfor %}
    </section>
{% endcache %}

Here we have two sep­a­rate caches on one page. The first is for our actu­al blog entry; the sec­ond is a glob­al­ly cached out­put of our blog archives, stored in the data­base as blog-archives. This means that there is a unique cache of each blog entry, but a sin­gle glob­al­ly shared cache of our blog archives.

Which is great, because we don’t want every sin­gle blog page to have to be re-cached when­ev­er we add a new blog entry. It’ll just re-cache the blog archives cache, which all of our blog pages share.

You’ll also notice that instead of just using the {% cache %} tag on its own, we’re actu­al­ly using {% cache globally using key craft.request.path %}. We do this because the default behav­ior for the {% cache %} tag is to use the full path as a way of unique­ly iden­ti­fy­ing our cache (in addi­tion to a unique hash that Craft auto­mat­i­cal­ly gen­er­ates, so we can have more than one {% cache %} tag per page). This full path includes the query string, which is any­thing after the ? in a URI, e.g.: ?utm_source=GHDJ14J.

But we don’t real­ly want the query string to cause a new, unique cached item, oth­er­wise we could poten­tial­ly end up with hun­dreds or even thou­sands of entries in the craft_templatecaches data­base table. For instance, if we just use the {% cache %} tag on its own, a request to /blog and /blog?utm_source=F1GMAT refer to the same page, but would result in addi­tion­al craft_templatecaches entries.

If you end up with a large num­ber of entries in the craft_templatecaches data­base table, it can actu­al­ly hin­der per­for­mance rather than help it — which defeats the whole point of caching to begin with! Pix­el & Ton­ic is actu­al­ly chang­ing the default behav­ior of the {% cache %} tag in Craft 3 to not include the query string, for this very reason.

If you are using the Retour plu­g­in, and you are imple­ment­ing {% cache %} tags in your _layout.twig that oth­er tem­plates extend, you might con­sid­er using a pat­tern like this:

{% cache globally using key craft.request.path unless craft.retour.getHttpStatus != 200 %}

This will cause it to ignore the query string for the cache key, and also nev­er cache any­thing that’s not a 200 OK http sta­tus code. This is need­ed for prop­er error han­dling as described in the Han­dling Errors Grace­ful­ly in Craft CMS article.

Keep in mind that if you use {% cache globally using key craft.request.path %} you can only have one {% cache %} tag per page, because the unique key will be the craft.request.path. So if you require more than one {% cache %} tag on a page, add a descrip­tive name to the key to make it unique, such as {% cache globally using key "header-block" ~ craft.request.path %}.

Think about what is on your page, and how it might best be to cache it effectively.

Link Craft 3.x Example

This is an exam­ple that cov­ers Craft 3.x specif­i­cal­ly; although most of the code is sim­i­lar for Craft 2.x, the way the default cache key is deter­mined is different.

{# -- Our blog entry -- #}
{% cache %}
    <article>
        <h1>{{ entry.title }}</h1>
        <p>{{ entry.body }}</p>
        <img src="{{ entry.image.first().getUrl(myTransform) }}">
    </article>
{% endcache %}

{# -- Our blog archives -- #}
{% cache globally using key "blog-archives" %}
    <section>
        {% for blogArchive in craft.entries.section('blog') %}
            <h1>{{ blogArchive.title }}</h1>
            <p>{{ blogArchive.summary }}</p>
        {% endfor %}
    </section>
{% endcache %}

Here we have two sep­a­rate caches on one page. The first is for our actu­al blog entry; the sec­ond is a glob­al­ly cached out­put of our blog archives, stored in the data­base as blog-archives. This means that there is a unique cache of each blog entry, but a sin­gle glob­al­ly shared cache of our blog archives.

Which is great, because we don’t want every sin­gle blog page to have to be re-cached when­ev­er we add a new blog entry. It’ll just re-cache the blog archives cache, which all of our blog pages share.

You’ll also notice that unlike the Craft 2.x exam­ple, we’re just using the {% cache %} tag on its own. Pix­el & Ton­ic changed the default behav­ior of the {% cache %} tag in Craft 3 to not include the query string, so it saves us from hav­ing to do it on our own.

If you are using the Retour plu­g­in for Craft 3, and you are imple­ment­ing {% cache %} tags in your _layout.twig that oth­er tem­plates extend, you might con­sid­er using a pat­tern like this:

{% cache unless craft.retour.getHttpStatus != 200 %}

This will cause it to nev­er cache any­thing that’s not a 200 OK http sta­tus code. This is need­ed for prop­er error han­dling as described in the Han­dling Errors Grace­ful­ly in Craft CMS article.

Think about what is on your page, and how it might best be to cache it effectively.

Link Cache Exemptions

A rea­son­ably com­mon pat­tern is that you want to cache your entire web­page, but there are cer­tain excep­tions that you don’t want cached. Let’s call them cache exemp­tions.

For instance, you might want to cache all of you pages by putting a {% cache %} tag in your main layout.twig file, as men­tioned above. But we don’t want to cache pages with non-200 http sta­tus codes, and maybe we don’t want to cache cer­tain pages like search results pages, and so on.

A nice pat­tern you can use is some­thing like this:

CRAFT 2.x EXAMPLE:

{# ##### Craft 2.x Cache exemption ##### #}
{% set cacheExempt = false %}
{# Exempt certain pages #}
{% set cacheExemptSegments = [
    'dont-cache-me-bro',
] %}
{% if craft.request.getSegment(1) in cacheExemptSegments %}
    {% set cacheExempt = true %}
{% endif %}
{# Also exempt pages with non-200 OK status codes #}
{% if craft.retour.getHttpStatus != 200 %}
    {% set cacheExempt = true %}
{% endif %}
{# Add any cache exemption conditions #}
...

{% cache globally using key craft.request.path unless cacheExempt %}

CRAFT 3.x EXAMPLE:

{# ##### Craft 3.x Cache exemption ##### #}
{% set cacheExempt = false %}
{# Exempt certain pages #}
{% set cacheExemptSegments = [
    'dont-cache-me-bro',
] %}
{% if craft.app.request.getSegment(1) in cacheExemptSegments %}
    {% set cacheExempt = true %}
{% endif %}
{# Also exempt pages with non-200 OK status codes #}
{% if craft.retour.getHttpStatus != 200 %}
    {% set cacheExempt = true %}
{% endif %}
{# Add any cache exemption conditions #}
...

{% cache unless cacheExempt %}

Using this tech­nique, you can add as many pages as you like to the cacheExemptSegments array, and any request that match­es the first seg­ment won’t be cached. You can leave this code in with an emp­ty array to have it not exempt any pages by first seg­ment, to future-proof things in case you need to down the road.

You can then add any oth­er con­di­tions you might have, which makes this pat­tern exten­si­ble, and it also keeps your actu­al {% cache %} tag fair­ly clean.

Link A Peek Under the Hood

So let’s get down and dirty, and have a look at what the entries in the craft_templatecaches table actu­al­ly look like. Here’s the table schema for the craft_templatecaches table:

MariaDB [nystudio]> describe craft_templatecaches;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| id         | int(11)      | NO   | PRI | NULL    | auto_increment |
| cacheKey   | varchar(255) | NO   |     | NULL    |                |
| locale     | char(12)     | NO   | MUL | NULL    |                |
| path       | varchar(255) | YES  |     | NULL    |                |
| expiryDate | datetime     | NO   |     | NULL    |                |
| body       | mediumtext   | NO   |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

The cache entries are sen­si­bly done on a per-locale basis, and have a cacheKey and a path that unique­ly iden­ti­fy them. If we just use the reg­u­lar old {% cache %} tag for our pages, the data­base entries in the table might look some­thing like this:

MariaDB [nystudio]> select cacheKey,path from craft_templatecaches;
+--------------------------------------+--------------------------------------------------+
| cacheKey                             | path                                             |
+--------------------------------------+--------------------------------------------------+
| blog-archives                        | NULL                                             |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog                                        |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog/creating-optimized-images-in-craft-cms |
+--------------------------------------+--------------------------------------------------+

As you can see, Craft stores both a cacheKey and a path for each entry. These two in com­bi­na­tion are what describe a unique entry in the craft_templatecaches table. The cacheKey is what we asked it to be for our glob­al blog-archives, and is a ran­dom hash for places where we just used the reg­u­lar old {% cache %} tag.

If we instead use the {% cache globally using key craft.request.path %} pat­tern, our craft_templatecaches ends up look­ing like this:

MariaDB [nystudio]> select cacheKey,path from craft_templatecaches;
+---------------------------------------------+----------------+
| cacheKey                                    | path           |
+---------------------------------------------+----------------+
| blog-archives                               | NULL           |
| blog                                        | NULL           |
| blog/creating-optimized-images-in-craft-cms | NULL           |
+---------------------------------------------+----------------+

As you can see, it’s using the craft.request.path for the key, and there’s noth­ing stored in the path. If we don’t strip the query string out on Craft 2.x (this won’t be an issue on Craft 3.x) via {% cache globally using key craft.request.path %}, we could end up with a craft_templatecaches table that looks like this:

MariaDB [nystudio]> select cacheKey,path from craft_templatecaches;
+--------------------------------------+--------------------------------------------------+
| cacheKey                             | path                                             |
+--------------------------------------+--------------------------------------------------+
| blog-archives                        | NULL                                             |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog                                        |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog?utm_source=F1GMAT                      |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog?utm_source=ADG12F                      |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog?utm_source=GS13FA                      |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog?utm_source=SM66MS                      |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog?utm_source=CMBKA4                      |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog?utm_source=HGHAJ2                      |
| yYNGYDNbbsxeRCDCWhBqbmpHbN2NBELomimv | site:blog?utm_source=24GSJ2                      |
+--------------------------------------+--------------------------------------------------+

And on and on. We can end up with a ton of entries in the craft_templatecaches table that are real­ly the same thing, which can result in per­for­mance degra­da­tion, and the dread­ed hung Delet­ing Stale Tem­plate Caches task.

The same is true for the case where we {% cache %} things in our _layout.twig file, and our 404 tem­plate extends that _layout.twig: if we don’t exclude 404 Not Found http sta­tus codes, we’ll end up with a craft_templatecaches entry for every sin­gle 404 that hits our site. Every. Sin­gle. One.

And believe me, there are swarms of bots out there on the Inter­net that probe your web­sites every day look­ing for vul­ner­a­bil­i­ties that will gen­er­ate a mas­sive num­ber of 404 errors, and can cause seri­ous per­for­mance impli­ca­tions for your website.

So cache wisely.

Link But wait, there’s more!

We can go even fur­ther down the rab­bit hole. In addi­tion to the templatecaches table, Craft keeps track of some addi­tion­al infor­ma­tion for each cache entry.

To help with the auto­mat­ic cache break­ing, Craft also has a table called templatecacheelements that keeps track of any Ele­ments (Entries, Catagories, Assets, etc.) that are inside of a giv­en {% cache %} tag:

MariaDB [craft3]> select * from templatecacheelements;
+---------+-----------+
| cacheId | elementId |
+---------+-----------+
|       1 |         4 |
|       2 |        85 |
|       2 |        80 |
|       2 |        81 |
|       2 |        73 |
|       2 |        74 |
|       2 |         4 |
|       2 |        83 |
+---------+-----------+
8 rows in set (0.00 sec)

Note that there is a row for each templatecaches id. This is so that if an ele­ment inside of a {% cache %} tag is changed, Craft can automag­i­cal­ly break the cache. But note that it also means that if we have a whole lot of ele­ments inside of our {% cache %} tags, we can end up with a whole lot of rows in this table:

MariaDB [imawhale]> select * from craft_templatecacheelements;
+---------+-----------+
| cacheId | elementId |
+---------+-----------+
|   12160 |         2 |
|   12160 |       369 |
|   12160 |       370 |
|   12160 |        55 |
|   12160 |        57 |
|   12160 |        58 |
|   12160 |        56 |
|   12160 |        59 |
|   12160 |       297 |
|   12160 |       233 |
...
24647 rows in set (0.03 sec)

So if we have a web­site with 10,000 blog entries on it, and each blog has 10 ele­ments inside of the {% cache %} tag, that means we’ll end up with 10,000 rows in the templatecaches table, and 100,000 rows in the templatecacheelements table. For the blog alone.

Sim­i­lar­ly, there’s anoth­er table that Craft uses to keep track of Ele­ment Cri­te­ria (templatecachecriteria) for Craft 2.x, and Ele­ment Queries (templatecachequeries) for Craft 3.x.

CRAFT 2.x ELE­MENT CRITERIA:

MariaDB [imawhale]> select * from craft_templatecachecriteria;
+--------+---------+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id     | cacheId | type             | criteria                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
+--------+---------+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 113997 |   12160 | Entry            | {"ancestorDist":null,"ancestorOf":null,"archived":0,"dateCreated":null,"dateUpdated":null,"descendantDist":null,"descendantOf":null,"fixedOrder":0,"id":null,"indexBy":null,"level":null,"limit":100,"locale":"en","localeEnabled":1,"nextSiblingOf":null,"offset":0,"order":"lft, postDate desc","positionedAfter":null,"positionedBefore":null,"prevSiblingOf":null,"relatedTo":null,"ref":null,"search":null,"siblingOf":null,"slug":"twitch-nav","status":"live","title":null,"uri":null,"with":null,"childField":null,"childOf":null,"depth":null,"parentField":null,"parentOf":null,"after":null,"authorGroup":null,"authorGroupId":null,"authorId":null,"before":null,"editable":0,"expiryDate":null,"postDate":null,"section":"navigation","sectionId":null,"type":null}                                 |
| 113998 |   12160 | MatrixBlock      | {"ancestorDist":null,"ancestorOf":null,"archived":0,"dateCreated":null,"dateUpdated":null,"descendantDist":null,"descendantOf":null,"fixedOrder":0,"id":null,"indexBy":null,"level":null,"limit":100,"locale":"en","localeEnabled":1,"nextSiblingOf":null,"offset":0,"order":"matrixblocks.sortOrder","positionedAfter":null,"positionedBefore":null,"prevSiblingOf":null,"relatedTo":null,"ref":null,"search":null,"siblingOf":null,"slug":null,"status":"enabled","title":null,"uri":null,"with":null,"childField":null,"childOf":null,"depth":null,"parentField":null,"parentOf":null,"fieldId":"28","ownerId":"369","ownerLocale":null,"type":null}                                                                                                                                                          |
...
22745 rows in set (0.04 sec)

CRAFT 3.x ELE­MENT QUERIES:

MariaDB [craft3]> select * from templatecachequeries;
+----+---------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | cacheId | type                       | query                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
+----+---------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|  1 |       2 | craft\elements\Entry       | TzoyODoiY3JhZnRcZWxlbWVudHNcZGJcRW50cnlRdWVyeSI6NzA6e3M6ODoiZWRpdGFibGUiO2I6MDtzOjk6InNlY3Rpb25JZCI7YToxOntpOjA7czoxOiIzIjt9czo2OiJ0eXBlSWQiO047czo4OiJhdXRob3JJZCI7TjtzOjEzOiJhdXRob3JHcm91cElkIjtOO3M6ODoicG9zdERhdGUiO047czo2OiJiZWZvcmUiO047czo1OiJhZnRlciI7TjtzOjEwOiJleHBpcnlEYXRlIjtOO3M6MTc6IgAqAGRlZmF1bHRPcmRlckJ5IjthOjE6e3M6MTY6ImVudHJpZXMucG9zdERhdGUiO2k6Mzt9czoxMToiZWxlbWVudFR5cGUiO3M6MjA6ImNyYWZ0XGVsZW1lbnRzXEVudHJ5IjtzOjU6InF1ZXJ5IjtOO3M6ODoic3ViUXVlcnkiO047czoxMjoiY29udGVudFRhYmxlIjtzOjEyOiJ7eyVjb250ZW50fX0iO3M6MTI6ImN1c3RvbUZpZWxkcyI7TjtzOjk6ImluUmV2ZXJzZSI7YjowO3M6NzoiYXNBcnJheSI7YjowO3M6MjoiaWQiO047czozOiJ1aWQiO047czoxMDoiZml4ZWRPcmRlciI7YjowO3M6Njoic3RhdHVzIjthOjE6e2k6MDtzOjQ6ImxpdmUiO31zOjg6ImFyY2hpdmVkIjtiOjA7czoxMToiZGF0ZUNyZWF0ZWQiO047czoxMToiZGF0ZVVwZGF0ZWQiO047czo2OiJzaXRlSWQiO3M6MToiMSI7czoxNDoiZW5hYmxlZEZvclNpdGUiO2I6MTtzOjY6ImxlYXZlcyI7YjowO3M6OToicmVsYXRlZFRvIjtOO3M6NToidGl0bGUiO047czo0OiJzbHVnIjtOO3M6MzoidXJpIjtOO3M6Njoic2VhcmNoIjtOO3M6MzoicmVmIjtOO3M6NDoid2l0aCI7TjtzOjc6Im9yZGVyQnkiO2E6Mjp7czoyMToic3RydWN0dXJlZWxlbWVudHMubGZ0IjtpOjQ7czoxNjoiZW50cmllcy5wb3N0RGF0ZSI7aTozO31zOjEzOiJ3aXRoU3RydWN0dXJlIjtiOjE7czoxMToic3RydWN0dXJlSWQiO2I6MDtzOjU6ImxldmVsIjtOO3M6MTQ6Imhhc0Rlc2NlbmRhbnRzIjtOO3M6MTA6ImFuY2VzdG9yT2YiO047czoxMjoiYW5jZXN0b3JEaXN0IjtOO3M6MTI6ImRlc2NlbmRhbnRPZiI7TjtzOjE0OiJkZXNjZW5kYW50RGlzdCI7TjtzOjk6InNpYmxpbmdPZiI7TjtzOjEzOiJwcmV2U2libGluZ09mIjtOO3M6MTM6Im5leHRTaWJsaW5nT2YiO047czoxNjoicG9zaXRpb25lZEJlZm9yZSI7TjtzOjE1OiJwb3NpdGlvbmVkQWZ0ZXIiO047czozOToiAGNyYWZ0XGVsZW1lbnRzXGRiXEVsZW1lbnRRdWVyeQBfcmVzdWx0IjtOO3M6NDc6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3Jlc3VsdENyaXRlcmlhIjtOO3M6NDU6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3NlYXJjaFNjb3JlcyI7TjtzOjY6InNlbGVjdCI7YToxOntpOjA7czoyOiIqKiI7fXM6MTI6InNlbGVjdE9wdGlvbiI7TjtzOjg6ImRpc3RpbmN0IjtOO3M6NDoiZnJvbSI7TjtzOjc6Imdyb3VwQnkiO047czo0OiJqb2luIjtOO3M6NjoiaGF2aW5nIjtOO3M6NToidW5pb24iO047czo2OiJwYXJhbXMiO2E6MDp7fXM6MTg6InF1ZXJ5Q2FjaGVEdXJhdGlvbiI7TjtzOjIwOiJxdWVyeUNhY2hlRGVwZW5kZW5jeSI7TjtzOjI3OiIAeWlpXGJhc2VcQ29tcG9uZW50AF9ldmVudHMiO2E6MDp7fXM6MzU6IgB5aWlcYmFzZVxDb21wb25lbnQAX2V2ZW50V2lsZGNhcmRzIjthOjA6e31zOjMwOiIAeWlpXGJhc2VcQ29tcG9uZW50AF9iZWhhdmlvcnMiO2E6MTp7czoxMjoiY3VzdG9tRmllbGRzIjtPOjM2OiJjcmFmdFxiZWhhdmlvcnNcRWxlbWVudFF1ZXJ5QmVoYXZpb3IiOjE2OntzOjc6ImJsYWhTZW8iO047czoxMjoiaW1hZ2VDYXB0aW9uIjtOO3M6MTU6Im9wdGltaXplZEltYWdlcyI7TjtzOjc6InNlb0NyYXAiO047czo5OiJzb21lQXNzZXQiO047czoxMDoic29tZU1hdHJpeCI7TjtzOjEwOiJzb21lTnVtYmVyIjtOO3M6MTM6InNvbWVQbGFpblRleHQiO047czoxMDoic29tZVJlY2lwZSI7TjtzOjEyOiJzb21lUmljaFRleHQiO047czo4OiJzb21lVW5pdCI7TjtzOjU6InN0dWZmIjtOO3M6MTA6InRlc3RJTWFnZXMiO047czo0OiJ3b29mIjtOO3M6NTE6IgBjcmFmdFxiZWhhdmlvcnNcQ29udGVudEJlaGF2aW9yAF9jdXN0b21GaWVsZFZhbHVlcyI7YTowOnt9czo1OiJvd25lciI7cjoxO319czo1OiJ3aGVyZSI7TjtzOjU6ImxpbWl0IjtpOjIwO3M6Njoib2Zmc2V0IjtOO3M6NzoiaW5kZXhCeSI7TjtzOjE2OiJlbXVsYXRlRXhlY3V0aW9uIjtiOjA7fQ== |
|  2 |       2 | craft\elements\Asset       | TzoyODoiY3JhZnRcZWxlbWVudHNcZGJcQXNzZXRRdWVyeSI6NzE6e3M6ODoidm9sdW1lSWQiO047czo4OiJmb2xkZXJJZCI7TjtzOjg6ImZpbGVuYW1lIjtOO3M6NDoia2luZCI7TjtzOjU6IndpZHRoIjtOO3M6NjoiaGVpZ2h0IjtOO3M6NDoic2l6ZSI7TjtzOjEyOiJkYXRlTW9kaWZpZWQiO047czoxNzoiaW5jbHVkZVN1YmZvbGRlcnMiO2I6MDtzOjE0OiJ3aXRoVHJhbnNmb3JtcyI7TjtzOjExOiJlbGVtZW50VHlwZSI7czoyMDoiY3JhZnRcZWxlbWVudHNcQXNzZXQiO3M6NToicXVlcnkiO047czo4OiJzdWJRdWVyeSI7TjtzOjEyOiJjb250ZW50VGFibGUiO3M6MTI6Int7JWNvbnRlbnR9fSI7czoxMjoiY3VzdG9tRmllbGRzIjtOO3M6OToiaW5SZXZlcnNlIjtiOjA7czo3OiJhc0FycmF5IjtiOjA7czoyOiJpZCI7TjtzOjM6InVpZCI7TjtzOjEwOiJmaXhlZE9yZGVyIjtiOjA7czo2OiJzdGF0dXMiO2E6MTp7aTowO3M6NzoiZW5hYmxlZCI7fXM6ODoiYXJjaGl2ZWQiO2I6MDtzOjExOiJkYXRlQ3JlYXRlZCI7TjtzOjExOiJkYXRlVXBkYXRlZCI7TjtzOjY6InNpdGVJZCI7aToxO3M6MTQ6ImVuYWJsZWRGb3JTaXRlIjtiOjE7czo2OiJsZWF2ZXMiO2I6MDtzOjk6InJlbGF0ZWRUbyI7TjtzOjU6InRpdGxlIjtOO3M6NDoic2x1ZyI7TjtzOjM6InVyaSI7TjtzOjY6InNlYXJjaCI7TjtzOjM6InJlZiI7TjtzOjQ6IndpdGgiO047czo3OiJvcmRlckJ5IjthOjE6e3M6MTk6InJlbGF0aW9ucy5zb3J0T3JkZXIiO2k6NDt9czoxMzoid2l0aFN0cnVjdHVyZSI7TjtzOjExOiJzdHJ1Y3R1cmVJZCI7TjtzOjU6ImxldmVsIjtOO3M6MTQ6Imhhc0Rlc2NlbmRhbnRzIjtOO3M6MTA6ImFuY2VzdG9yT2YiO047czoxMjoiYW5jZXN0b3JEaXN0IjtOO3M6MTI6ImRlc2NlbmRhbnRPZiI7TjtzOjE0OiJkZXNjZW5kYW50RGlzdCI7TjtzOjk6InNpYmxpbmdPZiI7TjtzOjEzOiJwcmV2U2libGluZ09mIjtOO3M6MTM6Im5leHRTaWJsaW5nT2YiO047czoxNjoicG9zaXRpb25lZEJlZm9yZSI7TjtzOjE1OiJwb3NpdGlvbmVkQWZ0ZXIiO047czoxNzoiACoAZGVmYXVsdE9yZGVyQnkiO2E6MTp7czoyMDoiZWxlbWVudHMuZGF0ZUNyZWF0ZWQiO2k6Mzt9czozOToiAGNyYWZ0XGVsZW1lbnRzXGRiXEVsZW1lbnRRdWVyeQBfcmVzdWx0IjtOO3M6NDc6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3Jlc3VsdENyaXRlcmlhIjtOO3M6NDU6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3NlYXJjaFNjb3JlcyI7TjtzOjY6InNlbGVjdCI7YToxOntpOjA7czoyOiIqKiI7fXM6MTI6InNlbGVjdE9wdGlvbiI7TjtzOjg6ImRpc3RpbmN0IjtOO3M6NDoiZnJvbSI7TjtzOjc6Imdyb3VwQnkiO047czo0OiJqb2luIjthOjE6e2k6MDthOjM6e2k6MDtzOjEwOiJJTk5FUiBKT0lOIjtpOjE7czoyNDoie3slcmVsYXRpb25zfX0gcmVsYXRpb25zIjtpOjI7YTo0OntpOjA7czozOiJhbmQiO2k6MTtzOjQwOiJbW3JlbGF0aW9ucy50YXJnZXRJZF1dID0gW1tlbGVtZW50cy5pZF1dIjtpOjI7YToyOntzOjE4OiJyZWxhdGlvbnMuc291cmNlSWQiO3M6MToiNCI7czoxNzoicmVsYXRpb25zLmZpZWxkSWQiO3M6MToiMiI7fWk6MzthOjM6e2k6MDtzOjI6Im9yIjtpOjE7YToxOntzOjIyOiJyZWxhdGlvbnMuc291cmNlU2l0ZUlkIjtOO31pOjI7YToxOntzOjIyOiJyZWxhdGlvbnMuc291cmNlU2l0ZUlkIjtpOjE7fX19fX1zOjY6ImhhdmluZyI7TjtzOjU6InVuaW9uIjtOO3M6NjoicGFyYW1zIjthOjA6e31zOjE4OiJxdWVyeUNhY2hlRHVyYXRpb24iO047czoyMDoicXVlcnlDYWNoZURlcGVuZGVuY3kiO047czoyNzoiAHlpaVxiYXNlXENvbXBvbmVudABfZXZlbnRzIjthOjA6e31zOjM1OiIAeWlpXGJhc2VcQ29tcG9uZW50AF9ldmVudFdpbGRjYXJkcyI7YTowOnt9czozMDoiAHlpaVxiYXNlXENvbXBvbmVudABfYmVoYXZpb3JzIjthOjE6e3M6MTI6ImN1c3RvbUZpZWxkcyI7TzozNjoiY3JhZnRcYmVoYXZpb3JzXEVsZW1lbnRRdWVyeUJlaGF2aW9yIjoxNjp7czo3OiJibGFoU2VvIjtOO3M6MTI6ImltYWdlQ2FwdGlvbiI7TjtzOjE1OiJvcHRpbWl6ZWRJbWFnZXMiO047czo3OiJzZW9DcmFwIjtOO3M6OToic29tZUFzc2V0IjtOO3M6MTA6InNvbWVNYXRyaXgiO047czoxMDoic29tZU51bWJlciI7TjtzOjEzOiJzb21lUGxhaW5UZXh0IjtOO3M6MTA6InNvbWVSZWNpcGUiO047czoxMjoic29tZVJpY2hUZXh0IjtOO3M6ODoic29tZVVuaXQiO047czo1OiJzdHVmZiI7TjtzOjEwOiJ0ZXN0SU1hZ2VzIjtOO3M6NDoid29vZiI7TjtzOjUxOiIAY3JhZnRcYmVoYXZpb3JzXENvbnRlbnRCZWhhdmlvcgBfY3VzdG9tRmllbGRWYWx1ZXMiO2E6MDp7fXM6NToib3duZXIiO3I6MTt9fXM6NToid2hlcmUiO047czo1OiJsaW1pdCI7aToxO3M6Njoib2Zmc2V0IjtOO3M6NzoiaW5kZXhCeSI7TjtzOjE2OiJlbXVsYXRlRXhlY3V0aW9uIjtiOjA7fQ== |
|  3 |       2 | craft\elements\MatrixBlock | TzozNDoiY3JhZnRcZWxlbWVudHNcZGJcTWF0cml4QmxvY2tRdWVyeSI6NjU6e3M6NzoiZmllbGRJZCI7czoxOiI2IjtzOjc6Im93bmVySWQiO3M6MToiNCI7czoxMToib3duZXJTaXRlSWQiO047czo2OiJ0eXBlSWQiO047czoxMToiZWxlbWVudFR5cGUiO3M6MjY6ImNyYWZ0XGVsZW1lbnRzXE1hdHJpeEJsb2NrIjtzOjU6InF1ZXJ5IjtOO3M6ODoic3ViUXVlcnkiO047czoxMjoiY29udGVudFRhYmxlIjtzOjI5OiJ7eyVtYXRyaXhjb250ZW50X3NvbWVtYXRyaXh9fSI7czoxMjoiY3VzdG9tRmllbGRzIjtOO3M6OToiaW5SZXZlcnNlIjtiOjA7czo3OiJhc0FycmF5IjtiOjA7czoyOiJpZCI7TjtzOjM6InVpZCI7TjtzOjEwOiJmaXhlZE9yZGVyIjtiOjA7czo2OiJzdGF0dXMiO2E6MTp7aTowO3M6NzoiZW5hYmxlZCI7fXM6ODoiYXJjaGl2ZWQiO2I6MDtzOjExOiJkYXRlQ3JlYXRlZCI7TjtzOjExOiJkYXRlVXBkYXRlZCI7TjtzOjY6InNpdGVJZCI7aToxO3M6MTQ6ImVuYWJsZWRGb3JTaXRlIjtiOjE7czo2OiJsZWF2ZXMiO2I6MDtzOjk6InJlbGF0ZWRUbyI7TjtzOjU6InRpdGxlIjtOO3M6NDoic2x1ZyI7TjtzOjM6InVyaSI7TjtzOjY6InNlYXJjaCI7TjtzOjM6InJlZiI7TjtzOjQ6IndpdGgiO047czo3OiJvcmRlckJ5IjthOjE6e3M6MjI6Im1hdHJpeGJsb2Nrcy5zb3J0T3JkZXIiO2k6NDt9czoxMzoid2l0aFN0cnVjdHVyZSI7TjtzOjExOiJzdHJ1Y3R1cmVJZCI7TjtzOjU6ImxldmVsIjtOO3M6MTQ6Imhhc0Rlc2NlbmRhbnRzIjtOO3M6MTA6ImFuY2VzdG9yT2YiO047czoxMjoiYW5jZXN0b3JEaXN0IjtOO3M6MTI6ImRlc2NlbmRhbnRPZiI7TjtzOjE0OiJkZXNjZW5kYW50RGlzdCI7TjtzOjk6InNpYmxpbmdPZiI7TjtzOjEzOiJwcmV2U2libGluZ09mIjtOO3M6MTM6Im5leHRTaWJsaW5nT2YiO047czoxNjoicG9zaXRpb25lZEJlZm9yZSI7TjtzOjE1OiJwb3NpdGlvbmVkQWZ0ZXIiO047czoxNzoiACoAZGVmYXVsdE9yZGVyQnkiO2E6MTp7czoyMDoiZWxlbWVudHMuZGF0ZUNyZWF0ZWQiO2k6Mzt9czozOToiAGNyYWZ0XGVsZW1lbnRzXGRiXEVsZW1lbnRRdWVyeQBfcmVzdWx0IjtOO3M6NDc6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3Jlc3VsdENyaXRlcmlhIjtOO3M6NDU6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3NlYXJjaFNjb3JlcyI7TjtzOjY6InNlbGVjdCI7YToxOntpOjA7czoyOiIqKiI7fXM6MTI6InNlbGVjdE9wdGlvbiI7TjtzOjg6ImRpc3RpbmN0IjtOO3M6NDoiZnJvbSI7TjtzOjc6Imdyb3VwQnkiO047czo0OiJqb2luIjtOO3M6NjoiaGF2aW5nIjtOO3M6NToidW5pb24iO047czo2OiJwYXJhbXMiO2E6MDp7fXM6MTg6InF1ZXJ5Q2FjaGVEdXJhdGlvbiI7TjtzOjIwOiJxdWVyeUNhY2hlRGVwZW5kZW5jeSI7TjtzOjI3OiIAeWlpXGJhc2VcQ29tcG9uZW50AF9ldmVudHMiO2E6MDp7fXM6MzU6IgB5aWlcYmFzZVxDb21wb25lbnQAX2V2ZW50V2lsZGNhcmRzIjthOjA6e31zOjMwOiIAeWlpXGJhc2VcQ29tcG9uZW50AF9iZWhhdmlvcnMiO2E6MTp7czoxMjoiY3VzdG9tRmllbGRzIjtPOjM2OiJjcmFmdFxiZWhhdmlvcnNcRWxlbWVudFF1ZXJ5QmVoYXZpb3IiOjE2OntzOjc6ImJsYWhTZW8iO047czoxMjoiaW1hZ2VDYXB0aW9uIjtOO3M6MTU6Im9wdGltaXplZEltYWdlcyI7TjtzOjc6InNlb0NyYXAiO047czo5OiJzb21lQXNzZXQiO047czoxMDoic29tZU1hdHJpeCI7TjtzOjEwOiJzb21lTnVtYmVyIjtOO3M6MTM6InNvbWVQbGFpblRleHQiO047czoxMDoic29tZVJlY2lwZSI7TjtzOjEyOiJzb21lUmljaFRleHQiO047czo4OiJzb21lVW5pdCI7TjtzOjU6InN0dWZmIjtOO3M6MTA6InRlc3RJTWFnZXMiO047czo0OiJ3b29mIjtOO3M6NTE6IgBjcmFmdFxiZWhhdmlvcnNcQ29udGVudEJlaGF2aW9yAF9jdXN0b21GaWVsZFZhbHVlcyI7YTowOnt9czo1OiJvd25lciI7cjoxO319czo1OiJ3aGVyZSI7TjtzOjU6ImxpbWl0IjtOO3M6Njoib2Zmc2V0IjtOO3M6NzoiaW5kZXhCeSI7TjtzOjE2OiJlbXVsYXRlRXhlY3V0aW9uIjtiOjA7fQ== |
|  4 |       2 | craft\elements\Asset       | TzoyODoiY3JhZnRcZWxlbWVudHNcZGJcQXNzZXRRdWVyeSI6NzE6e3M6ODoidm9sdW1lSWQiO047czo4OiJmb2xkZXJJZCI7TjtzOjg6ImZpbGVuYW1lIjtOO3M6NDoia2luZCI7TjtzOjU6IndpZHRoIjtOO3M6NjoiaGVpZ2h0IjtOO3M6NDoic2l6ZSI7TjtzOjEyOiJkYXRlTW9kaWZpZWQiO047czoxNzoiaW5jbHVkZVN1YmZvbGRlcnMiO2I6MDtzOjE0OiJ3aXRoVHJhbnNmb3JtcyI7TjtzOjExOiJlbGVtZW50VHlwZSI7czoyMDoiY3JhZnRcZWxlbWVudHNcQXNzZXQiO3M6NToicXVlcnkiO047czo4OiJzdWJRdWVyeSI7TjtzOjEyOiJjb250ZW50VGFibGUiO3M6MTI6Int7JWNvbnRlbnR9fSI7czoxMjoiY3VzdG9tRmllbGRzIjtOO3M6OToiaW5SZXZlcnNlIjtiOjA7czo3OiJhc0FycmF5IjtiOjA7czoyOiJpZCI7TjtzOjM6InVpZCI7TjtzOjEwOiJmaXhlZE9yZGVyIjtiOjA7czo2OiJzdGF0dXMiO2E6MTp7aTowO3M6NzoiZW5hYmxlZCI7fXM6ODoiYXJjaGl2ZWQiO2I6MDtzOjExOiJkYXRlQ3JlYXRlZCI7TjtzOjExOiJkYXRlVXBkYXRlZCI7TjtzOjY6InNpdGVJZCI7aToxO3M6MTQ6ImVuYWJsZWRGb3JTaXRlIjtiOjE7czo2OiJsZWF2ZXMiO2I6MDtzOjk6InJlbGF0ZWRUbyI7TjtzOjU6InRpdGxlIjtOO3M6NDoic2x1ZyI7TjtzOjM6InVyaSI7TjtzOjY6InNlYXJjaCI7TjtzOjM6InJlZiI7TjtzOjQ6IndpdGgiO047czo3OiJvcmRlckJ5IjthOjE6e3M6MTk6InJlbGF0aW9ucy5zb3J0T3JkZXIiO2k6NDt9czoxMzoid2l0aFN0cnVjdHVyZSI7TjtzOjExOiJzdHJ1Y3R1cmVJZCI7TjtzOjU6ImxldmVsIjtOO3M6MTQ6Imhhc0Rlc2NlbmRhbnRzIjtOO3M6MTA6ImFuY2VzdG9yT2YiO047czoxMjoiYW5jZXN0b3JEaXN0IjtOO3M6MTI6ImRlc2NlbmRhbnRPZiI7TjtzOjE0OiJkZXNjZW5kYW50RGlzdCI7TjtzOjk6InNpYmxpbmdPZiI7TjtzOjEzOiJwcmV2U2libGluZ09mIjtOO3M6MTM6Im5leHRTaWJsaW5nT2YiO047czoxNjoicG9zaXRpb25lZEJlZm9yZSI7TjtzOjE1OiJwb3NpdGlvbmVkQWZ0ZXIiO047czoxNzoiACoAZGVmYXVsdE9yZGVyQnkiO2E6MTp7czoyMDoiZWxlbWVudHMuZGF0ZUNyZWF0ZWQiO2k6Mzt9czozOToiAGNyYWZ0XGVsZW1lbnRzXGRiXEVsZW1lbnRRdWVyeQBfcmVzdWx0IjtOO3M6NDc6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3Jlc3VsdENyaXRlcmlhIjtOO3M6NDU6IgBjcmFmdFxlbGVtZW50c1xkYlxFbGVtZW50UXVlcnkAX3NlYXJjaFNjb3JlcyI7TjtzOjY6InNlbGVjdCI7YToxOntpOjA7czoyOiIqKiI7fXM6MTI6InNlbGVjdE9wdGlvbiI7TjtzOjg6ImRpc3RpbmN0IjtOO3M6NDoiZnJvbSI7TjtzOjc6Imdyb3VwQnkiO047czo0OiJqb2luIjthOjE6e2k6MDthOjM6e2k6MDtzOjEwOiJJTk5FUiBKT0lOIjtpOjE7czoyNDoie3slcmVsYXRpb25zfX0gcmVsYXRpb25zIjtpOjI7YTo0OntpOjA7czozOiJhbmQiO2k6MTtzOjQwOiJbW3JlbGF0aW9ucy50YXJnZXRJZF1dID0gW1tlbGVtZW50cy5pZF1dIjtpOjI7YToyOntzOjE4OiJyZWxhdGlvbnMuc291cmNlSWQiO3M6MToiNCI7czoxNzoicmVsYXRpb25zLmZpZWxkSWQiO3M6MToiMiI7fWk6MzthOjM6e2k6MDtzOjI6Im9yIjtpOjE7YToxOntzOjIyOiJyZWxhdGlvbnMuc291cmNlU2l0ZUlkIjtOO31pOjI7YToxOntzOjIyOiJyZWxhdGlvbnMuc291cmNlU2l0ZUlkIjtpOjE7fX19fX1zOjY6ImhhdmluZyI7TjtzOjU6InVuaW9uIjtOO3M6NjoicGFyYW1zIjthOjA6e31zOjE4OiJxdWVyeUNhY2hlRHVyYXRpb24iO047czoyMDoicXVlcnlDYWNoZURlcGVuZGVuY3kiO047czoyNzoiAHlpaVxiYXNlXENvbXBvbmVudABfZXZlbnRzIjthOjA6e31zOjM1OiIAeWlpXGJhc2VcQ29tcG9uZW50AF9ldmVudFdpbGRjYXJkcyI7YTowOnt9czozMDoiAHlpaVxiYXNlXENvbXBvbmVudABfYmVoYXZpb3JzIjthOjE6e3M6MTI6ImN1c3RvbUZpZWxkcyI7TzozNjoiY3JhZnRcYmVoYXZpb3JzXEVsZW1lbnRRdWVyeUJlaGF2aW9yIjoxNjp7czo3OiJibGFoU2VvIjtOO3M6MTI6ImltYWdlQ2FwdGlvbiI7TjtzOjE1OiJvcHRpbWl6ZWRJbWFnZXMiO047czo3OiJzZW9DcmFwIjtOO3M6OToic29tZUFzc2V0IjtOO3M6MTA6InNvbWVNYXRyaXgiO047czoxMDoic29tZU51bWJlciI7TjtzOjEzOiJzb21lUGxhaW5UZXh0IjtOO3M6MTA6InNvbWVSZWNpcGUiO047czoxMjoic29tZVJpY2hUZXh0IjtOO3M6ODoic29tZVVuaXQiO047czo1OiJzdHVmZiI7TjtzOjEwOiJ0ZXN0SU1hZ2VzIjtOO3M6NDoid29vZiI7TjtzOjUxOiIAY3JhZnRcYmVoYXZpb3JzXENvbnRlbnRCZWhhdmlvcgBfY3VzdG9tRmllbGRWYWx1ZXMiO2E6MDp7fXM6NToib3duZXIiO3I6MTt9fXM6NToid2hlcmUiO047czo1OiJsaW1pdCI7aToxO3M6Njoib2Zmc2V0IjtpOjA7czo3OiJpbmRleEJ5IjtOO3M6MTY6ImVtdWxhdGVFeGVjdXRpb24iO2I6MDt9 |
+----+---------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)

Although the nomen­cla­ture is dif­fer­ent, the pur­pose is the same: to keep track of where you might have queries like {% craft.entries.section('blog').limit(20) %} in your templates.

This is so that if an ele­ment changes inside one of your queries that’s in a {% cache %} tag, the cache will be bust­ed to reflect the new data.

If you’re won­der­ing why the Craft 3.x query looks the way it does, it is because this is a seri­al­ized ver­sion of the bina­ry Query object.


Serialized Craft 3 Element Queries can be significantly larger than Craft 2.x Element Criteria

Again, note that if you have a whole lot of queries inside of your {% cache %} tags, you’re going to end up with a whole lot of rows in the database.

If we have a web­site with 10,000 blog entries on it, and each blog has 10 Ele­ment Queries inside of the {% cache %} tag, that means we’ll end up with 10,000 rows in the templatecaches table, and 100,000 rows in the templatecachequeries or templatecachecriteria tables. For the blog alone.

You can dis­able just the ele­ment query caching via the cacheEle­men­t­Queries gen­er­al con­fig setting.

Link Cache as Cache Can

The {% cache %} tag can do a whole lot more, which you can read up on at the Craft Tem­plat­ing Docs page. Hope­ful­ly this gen­tle intro­duc­tion got you think­ing about when and how to use it.

If you want the ulti­mate in cache-based per­for­mance, check out the Sta­t­ic Page Caching with Craft CMS article.