getProfiler();
$totalTime = $profiler->getTotalElapsedSecs();
$queryCount = $profiler->getTotalNumQueries();
$Queries = $profiler->getQueryProfiles();
$longestTime = 0;
$longestQuery = null;
$queries = "";
if ($Queries) {
foreach ($Queries as $query) {
if ($query->getElapsedSecs() > $longestTime) {
$longestTime = $query->getElapsedSecs();
$longestQuery = $query->getQuery();
}
$queries .= 'Query length: ' . round($query->getElapsedSecs(), 3) . " sec.
n";
$queries .= "Query: n" . $query->getQuery() . "
n"; $queries .= "
n";
}
$queryOut = 'Executed ' . $queryCount . ' queries in ' . round($totalTime, 3) . ' sec.' . "
n";
$queryOut .= 'Average query length: ' . round(($totalTime / $queryCount), 3) . ' sec.' . "
n";
$queryOut .= 'Queries per second: ' . round(($queryCount / $totalTime),3) . "
n";
$queryOut .= 'Longest query length: ' . round($longestTime,3) . " sec.
n";
$queryOut .= "Longest query: n" . $longestQuery . "
n";
$queryOut .= "Queries: n" . $queries . "
n";
}
$out = '';
if (isset($queryOut)) {
$out .= $queryOut;
}
$out .= "
";
return $out;
}
}