Profile db queries

index.php

Mage::run($mageRunCode, $mageRunType);
//Insert code after Mage run
/** @var $profiler Zend_Db_Profiler */
$profiler = Mage::getSingleton('core/resource')->getConnection()->getProfiler();
$log = date('Y-m-d_H:i:s') . uniqid();
Mage::log('Total queries: ' . count($profiler->getQueryProfiles()), null, $log);
Mage::log('Total sec: ' . $profiler->getTotalElapsedSecs(), null, $log);
foreach ($profiler->getQueryProfiles() as $query) {
    /** @var $query Zend_Db_Profiler_Query */
    Mage::log($query->getElapsedSecs() . "\n" .$query->getQuery() . "\n" . print_r($query->getQueryParams(), 1), null, $log);
}

local.xml

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