' . $NL;
$config = Zend_Registry::get('config');
if ($config->database->params->profiler) {
// Zend_Db
$db = Qs_Db::getInstance($config);
$profiler = $db->getProfiler();
$list = $profiler->getQueryProfiles();
$profilerHtml = '';
if (is_array($list) && !empty($list)) {
$maxQueryDuration = defined('MAX_QUERY_DURATION') && MAX_QUERY_DURATION ? MAX_QUERY_DURATION : 0.5;
$countHardQueries = 0;
$profilerHtml .= '
';
foreach ($list as $k => $v) {
/** @var $v Zend_Db_Profiler_Query */
$params = $v->getQueryParams();
$color = ($k % 2 == 0) ? 'white' : '#EFEFEF';
if ($v->getElapsedSecs() >= $maxQueryDuration) {
$countHardQueries++;
$color = '#FFAAAA';
}
$profilerHtml .= '';
$profilerHtml .= '| ' . ($k + 1) . ' | ';
$profilerHtml .= '' . number_format($v->getElapsedSecs(), 3, '.', ',') . ' sec | ';
$profilerHtml .= '';
$profilerHtml .= '';
$profilerHtml .= ' +'
. Qs_SqlFormatter::getHighlightedCode($v->getQuery())
. '
' . $NL
. 'params' . $NL
. '' . $NL
. ' ' . $NL . print_r($params, true) . ' ' . $NL
. ' |
' . $NL;
}
$profilerHtml .= '
';
$logHTML .= '
'
. '
' . $NL
. '
'
. 'DB PROFILER' . $NL
. '
' . $NL
. ($countHardQueries ? 'Hard Queries: ' . $countHardQueries . '
' : '')
. 'Total Number of Queries: ' . $profiler->getTotalNumQueries() . '
' . $NL
. 'Total Elapsed Seconds:
' . number_format($profiler->getTotalElapsedSecs(), 4, '.', '')
. '' . $NL
. '
' . $NL
. $profilerHtml . '
' . $NL . '
' . $NL;
}
}
if (!empty($debugList) || !empty($debugSessionErrorsCount)) {
$debugHtml = Qs\Html::renderTag('hr');
$text = 'PHP ERRORS: ' . count($debugList);
if (!empty($debugList)) {
$debugHtml .= Qs\Html::renderContainer('a', $text, [
'style' => 'color:black; background-color:white; text-align:left;',
'href' => '#',
'onclick' => 'var el = document.getElementById(\'debug_info\'); '
. 'el.style.display = (el.style.display == \'none\') ? \'\' : \'none\'; return false;',
]);
} else {
$debugHtml .= $text . ' ';
}
$debugHtml .= '/ ';
$debugHtml .= Qs\Html::renderContainer('a', $debugSessionErrorsCount, [
'href' => Qs_SiteMap::findFirst(null, ['type' => 'SystemLog_'], null, 'url') . '?idSession=' . session_id(),
'target' => '_blank',
'style' => 'color:red',
]);
$debugHtml = Qs\Html::renderContainer('div', $debugHtml, [
'style' => 'color:black; background-color:white; text-align:left;',
]);
if ($debugList) {
$phpErrorsHtml = '';
foreach ($debugList as $k => $v) {
$phpErrorsHtml .= ($k + 1) . ')
' . $v['errorType'] . ': '
. iconv('UTF-8', 'UTF-8', $v['message']) . ' '
. 'in the
' . $v['file'] . ' line
' . $v['line'] . '';
}
$debugHtml .= Qs\Html::renderContainer('div', $phpErrorsHtml, [
'id' => 'debug_info',
'style' => 'border:solid black 1px; padding:10px;',
]);
}
$logHTML .= $debugHtml;
}
// page items started
if (Zend_Registry::isRegistered('_pageItems')) {
$tableColumns = [
['name' => 'id', 'title' => 'ID', 'type' => 'text'],
['name' => 'groupName', 'title' => 'Group', 'type' => 'text'],
['name' => 'type', 'title' => 'Type', 'type' => 'text'],
['name' => 'executed', 'title' => 'Executed', 'type' => 'bool'],
['name' => 'config', 'title' => 'Config', 'type' => 'array'],
];
$pageItems = (array) Zend_Registry::get('_pageItems');
$logHTML .= '
' . $NL;
$logHTML .= 'PAGE ITEMS' . $NL;
$logHTML .= '
' . $NL;
$logHTML .= '';
foreach ($tableColumns as $column) {
$logHTML .= '| ' . htmlspecialchars($column['title']) . ' | ';
}
$logHTML .= '
' . $NL;
if (!empty($pageItems)) {
foreach ($pageItems as $i) {
$logHTML .= '' . $NL;
foreach ($tableColumns as $column) {
$value = ' ';
switch ($column['type']) {
case 'bool':
$value = (isset($i[$column['name']]) && $i[$column['name']]) ? 'Yes' : 'No';
break;
case 'array':
$value = (isset($i[$column['name']])) ? json_encode($i[$column['name']]) : ' ';
break;
case 'text':
// break omitted
default:
$value = (isset($i[$column['name']])) ? $i[$column['name']] : ' ';
}
$logHTML .= '| ' . htmlspecialchars($value) . ' | ';
}
$logHTML .= '
' . $NL;
}
} else {
$logHTML .= '| No items found |
' . $NL;
}
$logHTML .= '
' . $NL;
}
// page items finished
// side blocks started
if (Zend_Registry::isRegistered('_pageSideBlocks')) {
$sideBlocks = (array) Zend_Registry::get('_pageSideBlocks');
$logHTML .= '
' . $NL;
$logHTML .= 'SIDE BLOCKS' . $NL;
$logHTML .= '
' . $NL;
$logHTML .= '| ID | Type | Title | Pages | Link Type | Link URL |
|---|
' . $NL;
if (!empty($sideBlocks)) {
foreach ($sideBlocks as $b) {
$logHTML .= ''
. '| ' . $b['id'] . ' | '
. '' . ucfirst($b['blockType']) . ' | '
. '' . htmlspecialchars($b['title']) . ' | '
. '' . ucfirst($b['pageType']) . ' | '
. '' . ucfirst($b['linkType']) . ' | '
. '' . (($b['linkType'] == 'none') ? ' ' : htmlspecialchars($b['linkUrl'])) . ' | '
. '
' . $NL;
}
} else {
$logHTML .= '| No blocks found |
' . $NL;
}
$logHTML .= '
' . $NL;
}
// side blocks finished
$logHTML .= '
'
. '
SCRIPT DURATION: ' . number_format((microtime(true) - SCRIPT_START), 4, '.', '') . '
';
$logHTML .= '