<blockquote>
  <p>Should I panic or is this normal?</p>
</blockquote>

<p>Normal. Each of those <code>[trace]</code> and <code>[profile]</code> log entries will have a stack backtrace listed under them showing you exactly what led up to that query, if you're curious.  Usually the <code>SHOW FULL COLUMNS FROM</code> query is coming from an ActiveRecord when Yii queries to get metadata for the underlying table it represents.</p>

CC BY-SA 3.0
2016-03-07T01:10:28.707Z
Thanks Brad. I tried running an empty template and I still see the queries, so I won't worry about it too much. I also noticed there are 11 queries on an empty template but I guess this is normal as well.
Paul
CC BY-SA 3.0
2016-03-07T01:53:13.573Z
Well, Craft does need to run a few queries to operate. :)
Brad Bell
CC BY-SA 3.0
2016-03-04T18:11:41.773Z
2016-03-04T18:11:41.773Z
Brad Bell
<p>When I look at the console log when devMode is enabled, I notice there's a lot going on, and I'm not sure if what I'm seeing is normal or not.</p>

<p>There are dozens of</p>

<p><code>[trace][system.db.CDbCommand]\nQuerying SQL: SHOW FULL COLUMNS FROM</code></p>

<p>or:</p>

<p><code>[profile][system.db.CDbCommand.query] begin:system.db.CDbCommand.query(SELECT...</code></p>

<p>What worries me slightly is that there are mentions of ALL the fields in ALL the tables in my DB, even those not used in the current template/entry and with <code>{% cache %}</code> enabled.</p>

<p>Should I panic or is this normal?</p>

<database><queries><devmode>
Queries in devMode
# Queries in devMode

(Asked by: username_0 on 2016-03-04)

When I look at the console log when devMode is enabled, I notice there's a lot going on, and I'm not sure if what I'm seeing is normal or not.

There are dozens of

`[trace][system.db.CDbCommand]\nQuerying SQL: SHOW FULL COLUMNS FROM`

or:

`[profile][system.db.CDbCommand.query] begin:system.db.CDbCommand.query(SELECT...`

What worries me slightly is that there are mentions of ALL the fields in ALL the tables in my DB, even those not used in the current template/entry and with `{% cache %}` enabled.

Should I panic or is this normal?

**Tags:** database, queries, devmode

---

## 1 answers

### Answer by username_1 on 2016-03-04. Score: 2 | Accepted answer

> Should I panic or is this normal?

Normal. Each of those `[trace]` and `[profile]` log entries will have a stack backtrace listed under them showing you exactly what led up to that query, if you're curious. Usually the `SHOW FULL COLUMNS FROM` query is coming from an ActiveRecord when Yii queries to get metadata for the underlying table it represents.

> **Comments:**
> **username_0**: Thanks Brad. I tried running an empty template and I still see the queries, so I won't worry about it too much. I also noticed there are 11 queries on an empty template but I guess this is normal as well.  
> **username_1**: Well, Craft does need to run a few queries to operate. :)  

---

