In my profile summary report (shown at the bottom of the page), I currently have all SQL statements and times shown.
Is it possible to add another column which shows where the SQL statement originated, so that I can find it and optimize it?
For example, a certain page currently has 40 SQL statements running, and I would like to optimize them. This means I have to go through a ton of code to hunt down the original just to find where/who created this statement.
Would be very useful to add a trace or something to this… or does it exist already?
If you have debugging turned on you should be able to see this already.
Before the begin/end of the profile you’re looking at should be the trace of the same sql statement - at the end of this it should show where it came from.
You should see something along the lines of the following:
in
/var/www/somesite.com/htdocs/protected/controllers/SomeController.php
(188)
in /var/www/somesite.com/htdocs/index.php (14)