If you want to enable profiler, Here is the way
Admin Dashboard >> System >> Configuration >> Developer >> Debug >> Profiler
Open “index.php” file located at the MAGENTO_ROOT folder in editor and find the link of code #Varien_Profiler::enable();
. Uncomment this line and save like below
require_once $mageFilename;
Varien_Profiler::enable();
if (isset($_SERVER['MAGE_IS_DEVELOPER_MODE'])) {
Mage::setIsDeveloperMode(true);
}
Thats all, profiler has been enabled.

If you want to enable sql profiler, Here is the way
To enable sql profiling,
- you need to enable “Profiler” from admin
- Open the
local.xml
config file located in /app/etc/
folder and add the node <profiler>true</profiler>
Example :
<resources>
<db>
<table_prefix><![CDATA[]]></table_prefix>
</db>
<default_setup>
<connection>
<host><![CDATA[localhost]]></host>
<username><![CDATA[root]]></username>
<password><![CDATA[]]></password>
<dbname><![CDATA[magento_1_8_1_0]]></dbname>
<initStatements><![CDATA[SET NAMES utf8]]></initStatements>
<model><![CDATA[mysql4]]></model>
<type><![CDATA[pdo_mysql]]></type>
<pdoType><![CDATA[]]></pdoType>
<active>1</active>
<profiler>true</profiler>
</connection>
</default_setup>
</resources>
save the file and clear the cache.
