simple mysql profiler with built-in mysql tool

mysql_profiler.php

<?php
mysql_query("set profiling_history_size=100");
mysql_query("set profiling=1");
 
#
# your queries here
#
 
$rs = mysql_query("show profiles");
while($rd = mysql_fetch_object($rs))
{
    echo $rd->Query_ID.' - '.round($rd->Duration,4) * 1000 .' ms - '.$rd->Query.'<br />';
}
?>