Time it took to Execute Query

[codexx]

Just wondering if there is any sort of function that allows you to see how long it took for the mySQL queries on that page to execute?

[shaunrigby]

try takig the time before and after the query and minus time after from time before

[cmgmyr]

Add this to the top of the page:

<?php 
   $mtime = microtime(); 
   $mtime = explode(" ",$mtime); 
   $mtime = $mtime[1] + $mtime[0]; 
   $starttime = $mtime; 
?>

 

and this to the bottom:

<?php 
   $mtime = microtime(); 
   $mtime = explode(" ",$mtime); 
   $mtime = $mtime[1] + $mtime[0]; 
   $endtime = $mtime; 
   $totaltime = ($endtime - $starttime); 
   echo "This page was created in ".number_format($totaltime,6)." seconds"; 
?>