how many queries and execution time

[nerf]

Hi, does anyone know the commands to display how many queries were executed and how long the execution time was ?

Yeah its for a PHP page.
Thanks

[ghurtado]

Yeah its for a PHP page.

Then you should probably have this question moved to the PHP forum.

In a nutshell, there isn't a single "command" to display the queries executed in one page, or the page execution time for that matter, you will have to build your application with some kind of logger that keeps track of every query generated so that it can be displayed at the end of the page. As far as the time that takes to render a page, try something like this

<?php
$time_start = microtime(true);

// your page contents go here

$time_end = microtime(true);
$time = $time_end - $time_start;
?>

(taken from http://us4.php.net/microtime)