Enabling The Profiler

In index.php uncomment this line:
#Varien_Profiler::enable();

In the admin enable the profiler output:

Set System > Configuration > Advanced > Developer > Debug > Profiler to yes

To enable the Zend_Db profiler add the following node to your app/etc/local.xml file. It can be added into your database connection configuration. The output will also be displayed if the admin setting above is set to true.

<global>
    <resources>
        <default_setup>
            <connection>
                <profiler>true</profiler>
            </connection>
        </default_setup>
    </resources>
</global>