<?php
/* @var $this yii\web\View */
use yii\widgets\Breadcrumbs;
use backend\models\Sql50Search;
use yii\widgets\LinkPager;
use yii\widgets\ActiveForm;
use yii\helpers\Html;
use dosamigos\datetimepicker\DateTimePicker;
$this->title = '每天前50条查询最久统计';
$params = \Yii::$app->request->get();
//处理时间
$accLogErr = new Sql50Search();
if (!empty($params['Sql50Search']['start_date'])) {
$accLogErr->sqlquerytime = $params['Sql50Search']['start_date'];
} else {
$params['Sql50Search']['start_date'] = date('Y-m-d 00:00:00');
$accLogErr->sqlquerytime = date("Y-m-d 00:00:00");
}
$thisDayErrorsLists = $accLogErr->search($params);
$pager = $thisDayErrorsLists->getPagination();
$datas = $thisDayErrorsLists->getModels();
$begin = $pager->page * $pager->pageSize + 1;
$end = $begin + $pager->pageSize - 1;
if ($begin > $end) {
$begin = $end;
}
?>
<div class="site-index">
<?php
echo Breadcrumbs::widget(['itemTemplate' => "<li><i>{link}</i></li>\n", 'links' => [['label' => '首页']]]);
<?php
/* @var $this yii\web\View */
use yii\widgets\Breadcrumbs;
use backend\models\Sql50Search;
use yii\widgets\LinkPager;
use yii\widgets\ActiveForm;
use yii\helpers\Html;
use backend\services\SqlTraceService;
use dosamigos\datetimepicker\DateTimePicker;
$this->title = '慢日志查询';
$params = \Yii::$app->request->get();
//为了保证实时数据，先统计一下当前最近10分钟的top50数据因为只有10分钟，所以统计会少很多时间
SqlTraceService::tofitTop50near10minute();
//处理时间
$accLogErr = new Sql50Search();
if (!empty($params['Sql50Search']['executedate'])) {
$accLogErr->executedate = $params['Sql50Search']['executedate'];
} else {
$params['Sql50Search']['executedate'] = date('Y-m-d 00:00:00');
$accLogErr->executedate = date("Y-m-d 00:00:00");
}
$thisDayErrorsLists = $accLogErr->search($params);
$pager = $thisDayErrorsLists->getPagination();
$datas = $thisDayErrorsLists->getModels();
$begin = $pager->page * $pager->pageSize + 1;
$end = $begin + $pager->pageSize - 1;
if ($begin > $end) {
$begin = $end;
}
?>
