So basically, I am working on a php project which is using Zend Framework 1. I had to profile all the queries for several pages to check whether the page being rendered were optimised.
So here’s how it was done:
First you need to install the Firebug extension for google chrome (I am using google chrome).
Secondly, use the Zend_Db_Profile_Firebug class.
$profiler = new Zend_Db_Profiler_Firebug(‘All DB Queries’);
The last line setups the profiler for a specific database if you have more than one database, else you could simply use getDb()->setProfiler($profiler);