如何知道一个PHP脚本完成了多少个mysql查询? [英] How to know how many mysql queries a php script has done?

问题描述

有没有办法知道在一个php脚本中已经启动了多少个mysql查询?以及这些查询多长时间了?

is there any way to know how many mysql queries has been launched in a php script ? and how long those queries were ?

谢谢.

推荐答案

基本上，您可以为MySQL查询创建处理程序函数，例如:

Basically you can make a handler function for your MySQL queries, like:

$mysql_queries_count = 0;
$mysql_queries_time = 0;

function _mysql_query($query) {
    global $mysql_queries_count, $mysql_queries_time;

    $start = microtime(true);
    $result = mysql_query($query);
    $mysql_queries_time += microtime(true) - $start;
    $mysql_queries_count++;

    return $result;
}

这样做，您必须用_mysql_query(替换代码中的所有mysql_query(，这在大多数文本编辑器中都可以轻松实现.

Doing so, you'll have to replace all mysql_query( in your code with _mysql_query(, which is easily doable in most text editors.

这篇关于如何知道一个PHP脚本完成了多少个mysql查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！