How can I eliminate CakePHP's "SHOW FULL COLUMNS" queries?

Question

I realize that these might not necessarily be a huge performance issue, but I'd like to get rid of any unnecessary SHOW FULL COLUMNS FROM queries that Cake generates. I've tried using the Containable behavior, which I thought would stop Cake from looking at any associations that I haven't included in my find(), but I still see the SHOW FULL COLUMNS FROM queries in my SQL dump. I have also tried unbindModel(), but it has no effect.

I'm not an expert, and don't understand all the intricacies of Cake, so any help here would be greatly appreciated!

score 5 · Accepted Answer · answered Mar 15 '11 at 15:22

5

Doesn't it cache it when the debug level is set to 0?

answered Mar 15 '11 at 15:22

Evert

93,428
18
118
189

Yup, looks like Cake only uses these queries for debugging purposes and therefore, it goes away when debug is set to 0. Thanks! – Nick Mar 15 '11 at 15:29
Sorry for hijacking; but WHY does Cake do this? – Gerben Jacobs Apr 15 '11 at 12:36
I have the same problem, although the debug mode is 0, is there anything else that needs to be set? – Hristo Petev May 19 '14 at 08:28

How can I eliminate CakePHP's "SHOW FULL COLUMNS" queries?

1 Answers1