Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-07T01:10:28.707Z
Answers.Text: 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.
Answers.UserDisplayName: Paul
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-07T01:53:13.573Z
Answers.Text: Well, Craft does need to run a few queries to operate. :)
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-04T18:11:41.773Z
Answers.LastActivityDate: 2016-03-04T18:11:41.773Z
Answers.UserDisplayName: Brad Bell
Body: <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>
  
Tags: <database><queries><devmode>
Title: Queries in devMode
ThreadText: # 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 username_1. 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. :)  
  
  ---
  
  