Exemple #1
0
function speedTrackExecuteQuery($query)
{
    global $mysqlSpeedString, $swMysqlSum, $mysqlSlowQuery;
    global $printMysqlSpeedString;
    if (!isset($mysqlSpeedString)) {
        $mysqlSpeedString = "";
    }
    if (!isset($printMysqlSpeedString)) {
        $printMysqlSpeedString = FALSE;
    }
    if (!isset($swMysqlSum)) {
        $swMysqlSum = 0;
    }
    if (!isset($mysqlSlowQuery)) {
        $mysqlSlowQuery = 1.0;
    }
    $sw = new Stopwatch();
    $sw->start();
    $result = mysql_query($query);
    $sw->stop();
    $ela = $sw->elapsed();
    $hh = (double) $sw->elapsed();
    $swMysqlSum += $hh;
    if ($hh > $mysqlSlowQuery) {
        $ela = "<font color='red'>{$ela}</font>";
    }
    if ($printMysqlSpeedString) {
        $mysqlSpeedString .= "<br>{$query} - <b>{$ela}</b>";
    }
    if (class_exists("mysqlspeed")) {
        writeMysqlSpeedRecord($query, $hh);
    }
    return $result;
}