| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/11584/cwd/html/egp/vendor/yiisoft/yii2-debug/src/views/default/panels/db/ |
Upload File : |
<?php
use yii\debug\DbAsset;
use yii\grid\GridView;
use yii\helpers\Html;
use yii\web\View;
/* @var $panel yii\debug\panels\DbPanel */
/* @var $searchModel yii\debug\models\search\Db */
/* @var $dataProvider yii\data\ArrayDataProvider */
/* @var $hasExplain bool */
/* @var $sumDuplicates int */
/* @var $this View */
echo Html::tag('h1', $panel->getName() . ' Queries');
if (Yii::$app->log->traceLevel < 1) {
echo "<div class=\"callout callout-warning\">Check application configuration section [log] for <b>traceLevel</b></div>";
}
if ($sumDuplicates === 1) {
echo "<p><b>$sumDuplicates</b> duplicated query found.</p>";
} elseif ($sumDuplicates > 1) {
echo "<p><b>$sumDuplicates</b> duplicated queries found.</p>";
}
echo GridView::widget([
'dataProvider' => $dataProvider,
'id' => 'db-panel-detailed-grid',
'options' => ['class' => 'detail-grid-view table-responsive'],
'filterModel' => $searchModel,
'filterUrl' => $panel->getUrl(),
'pager' => [
'linkContainerOptions' => [
'class' => 'page-item'
],
'linkOptions' => [
'class' => 'page-link'
],
'disabledListItemSubTagOptions' => [
'tag' => 'a',
'href' => 'javascript:;',
'tabindex' => '-1',
'class' => 'page-link'
]
],
'columns' => [
[
'attribute' => 'seq',
'label' => 'Time',
'value' => function ($data) {
$timeInSeconds = $data['timestamp'] / 1000;
$millisecondsDiff = (int)(($timeInSeconds - (int)$timeInSeconds) * 1000);
return date('H:i:s.', $timeInSeconds) . sprintf('%03d', $millisecondsDiff);
},
'headerOptions' => [
'class' => 'sort-numerical'
]
],
[
'attribute' => 'duration',
'value' => function ($data) {
return sprintf('%.1f ms', $data['duration']);
},
'options' => [
'width' => '10%',
],
'headerOptions' => [
'class' => 'sort-numerical'
]
],
[
'attribute' => 'type',
'value' => function ($data) {
return Html::encode($data['type']);
},
'filter' => $panel->getTypes(),
],
[
'attribute' => 'duplicate',
'label' => 'Duplicated',
'options' => [
'width' => '5%',
],
'headerOptions' => [
'class' => 'sort-numerical'
]
],
[
'attribute' => 'query',
'value' => function ($data) use ($hasExplain, $panel) {
$query = Html::tag('div', Html::encode($data['query']));
if (!empty($data['trace'])) {
$query .= Html::ul($data['trace'], [
'class' => 'trace',
'item' => function ($trace) use ($panel) {
return '<li>' . $panel->getTraceLine($trace) . '</li>';
},
]);
}
if ($hasExplain && $panel::canBeExplained($data['type'])) {
$query .= Html::tag('p', '', ['class' => 'db-explain-text']);
$query .= Html::tag(
'div',
Html::a(
'[+] Explain',
['db-explain', 'seq' => $data['seq'], 'tag' => Yii::$app->controller->summary['tag']]
),
['class' => 'db-explain']
);
}
return $query;
},
'format' => 'raw',
'options' => [
'width' => '60%',
],
]
],
]);
if ($hasExplain) {
DbAsset::register($this);
echo Html::tag(
'div',
Html::a('[+] Explain all', 'javascript:;'),
['id' => 'db-explain-all']
);
}