1

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?

2

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.

2
  • 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
    Mar 7 '16 at 1:10
  • Well, Craft does need to run a few queries to operate. :)
    – Brad Bell
    Mar 7 '16 at 1:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.