/**
* it should adds content or set some properties on the debugbar
* to displays some contents.
* @param debugbarHTMLResponsePlugin $debugbar the debugbar
*/
function show($debugbar)
{
$info = new debugbarItemInfo('sqllog', 'SQL queries');
$messages = jLog::getMessages('sql');
$info->htmlLabel = '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAQAAAC1+jfqAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAEYSURBVBgZBcHPio5hGAfg6/2+R980k6wmJgsJ5U/ZOAqbSc2GnXOwUg7BESgLUeIQ1GSjLFnMwsKGGg1qxJRmPM97/1zXFAAAAEADdlfZzr26miup2svnelq7d2aYgt3rebl585wN6+K3I1/9fJe7O/uIePP2SypJkiRJ0vMhr55FLCA3zgIAOK9uQ4MS361ZOSX+OrTvkgINSjS/HIvhjxNNFGgQsbSmabohKDNoUGLohsls6BaiQIMSs2FYmnXdUsygQYmumy3Nhi6igwalDEOJEjPKP7CA2aFNK8Bkyy3fdNCg7r9/fW3jgpVJbDmy5+PB2IYp4MXFelQ7izPrhkPHB+P5/PjhD5gCgCenx+VR/dODEwD+A3T7nqbxwf1HAAAAAElFTkSuQmCC" alt="SQL queries" title="SQL queries"/> ';
if (!jLog::isPluginActivated('memory', 'sql')) {
$info->htmlLabel .= '?';
$info->label .= 'memory logger is not active';
} else {
$realCount = jLog::getMessagesCount('sql');
$currentCount = count($messages);
$info->htmlLabel .= $realCount;
if ($realCount) {
if ($realCount > $currentCount) {
$info->popupContent = '<p class="jxdb-msg-warning">Too many queries (' . $realCount . '). Only first ' . $currentCount . ' queries are shown.</p>';
}
$sqlDetailsContent = '<ul id="jxdb-sqllog" class="jxdb-list">';
$totalTime = 0;
foreach ($messages as $msg) {
if (get_class($msg) != 'jSQLLogMessage') {
continue;
}
$dao = $msg->getDao();
if ($dao) {
$m = 'DAO ' . $dao;
} else {
$m = substr($msg->getMessage(), 0, 50) . ' [...]';
}
$msgTime = $msg->getTime();
$totalTime += $msgTime;
$sqlDetailsContent .= '<li>
<h5><a href="#" onclick="jxdb.toggleDetails(this);return false;"><span>' . htmlspecialchars($m) . '</span></a></h5>
<div>
<p>Time: ' . $msgTime . 's</p>';
$sqlDetailsContent .= '<pre style="white-space:pre-wrap">' . htmlspecialchars($msg->getMessage()) . '</pre>';
if ($msg->getMessage() != $msg->originalQuery) {
$sqlDetailsContent .= '<p>Original query: </p><pre style="white-space:pre-wrap">' . htmlspecialchars($msg->originalQuery) . '</pre>';
}
$sqlDetailsContent .= $debugbar->formatTrace($msg->getTrace());
$sqlDetailsContent .= '</div></li>';
}
$sqlDetailsContent .= '</ul>';
$info->popupContent .= '<div>Total SQL time : ' . $totalTime . 's</div>';
$info->popupContent .= $sqlDetailsContent;
}
}
$debugbar->addInfo($info);
}
/**
* it should adds content or set some properties on the debugbar
* to displays some contents.
* @param debugbarHTMLResponsePlugin $debugbar the debugbar
*/
function show($debugbar)
{
$info = new debugbarItemInfo('sqllog', 'SQL queries');
$messages = jLog::getMessages('sql');
$info->htmlLabel = '<img src="data:image/png;base64,' . base64_encode(file_get_contents(__DIR__ . '/../../htmlresponse/debugbar/icons/database.png')) . '" alt="SQL queries" title="SQL queries"/> ';
if (!jLog::isPluginActivated('memory', 'sql')) {
$info->htmlLabel .= '?';
$info->label .= 'memory logger is not active';
} else {
$realCount = jLog::getMessagesCount('sql');
$currentCount = count($messages);
$info->htmlLabel .= $realCount;
if ($realCount) {
if ($realCount > $currentCount) {
$info->popupContent = '<p class="jxdb-msg-warning">Too many queries (' . $realCount . '). Only first ' . $currentCount . ' queries are shown.</p>';
}
$sqlDetailsContent = '<ul id="jxdb-sqllog" class="jxdb-list">';
$totalTime = 0;
foreach ($messages as $msg) {
if (get_class($msg) != 'jSQLLogMessage') {
continue;
}
$dao = $msg->getDao();
if ($dao) {
$m = 'DAO ' . $dao;
} else {
$m = substr($msg->getMessage(), 0, 50) . ' [...]';
}
$msgTime = $msg->getTime();
$totalTime += $msgTime;
$sqlDetailsContent .= '<li>
<h5><a href="#" onclick="jxdb.toggleDetails(this);return false;"><span>' . htmlspecialchars($m) . '</span></a></h5>
<div>
<p>Time: ' . $msgTime . 's</p>';
$sqlDetailsContent .= '<pre style="white-space:pre-wrap">' . htmlspecialchars($msg->getMessage()) . '</pre>';
if ($msg->getMessage() != $msg->originalQuery) {
$sqlDetailsContent .= '<p>Original query: </p><pre style="white-space:pre-wrap">' . htmlspecialchars($msg->originalQuery) . '</pre>';
}
$sqlDetailsContent .= $debugbar->formatTrace($msg->getTrace());
$sqlDetailsContent .= '</div></li>';
}
$sqlDetailsContent .= '</ul>';
$info->popupContent .= '<div>Total SQL time : ' . $totalTime . 's</div>';
$info->popupContent .= $sqlDetailsContent;
}
}
$debugbar->addInfo($info);
}
/**
* it should adds content or set some properties on the debugbar
* to displays some contents.
* @param debugbarHTMLResponsePlugin $debugbar the debugbar
*/
function show($debugbar)
{
$info = new debugbarItemInfo('sqllog', 'SQL queries');
$messages = jLog::getMessages('sql');
#expand $info->htmlLabel = '<img src="data:image/png;base64,__LOGOSQLLOG__" alt="SQL queries" title="SQL queries"/> ';
if (!jLog::isPluginActivated('memory', 'sql')) {
$info->htmlLabel .= '?';
$info->label .= 'memory logger is not active';
} else {
$realCount = jLog::getMessagesCount('sql');
$currentCount = count($messages);
$info->htmlLabel .= $realCount;
if ($realCount) {
if ($realCount > $currentCount) {
$info->popupContent = '<p class="jxdb-msg-warning">Too many queries (' . $realCount . '). Only first ' . $currentCount . ' queries are shown.</p>';
}
$info->popupContent .= '<ul id="jxdb-sqllog" class="jxdb-list">';
foreach ($messages as $msg) {
$dao = $msg->getDao();
if ($dao) {
$m = 'DAO ' . $dao;
} else {
$m = substr($msg->getMessage(), 0, 50) . ' [...]';
}
$info->popupContent .= '<li>
<h5><a href="#" onclick="jxdb.toggleDetails(this);return false;"><span>' . htmlspecialchars($m) . '</span></a></h5>
<div>
<p>Time: ' . $msg->getTime() . 's</p>';
$info->popupContent .= '<pre style="white-space:pre-wrap">' . htmlspecialchars($msg->getMessage()) . '</pre>';
$info->popupContent .= $debugbar->formatTrace($msg->getTrace());
$info->popupContent .= '</div></li>';
}
$info->popupContent .= '</ul>';
}
}
$debugbar->addInfo($info);
}
