Magento 1 get profiler ordered by elapsed time

index.php

<?php

/*
* Don't forget that in order for profiler to work it has to be enabled, else you will get empty profiles.
*/

$profiler = Mage::getSingleton('core/resource')->getConnection('core_write')->getProfiler();
$queryProfiles = $profiler->getQueryProfiles();

$profiles = [];
foreach ($queryProfiles as $profile) {
    $tmp          = (array) $profile;
    $tmp['total'] = number_format($profile->getElapsedSecs(), 5);
    $profiles[]   = $tmp;
}
$total = array_column($profiles, 'total');
array_multisort($total, SORT_DESC, $profiles);


echo '<pre>';
print_r( $profiles );
echo '</pre>';