Class yii\debug\panels\DbPanel

                public function calculateTimings()
{
    if ($this->_timings === null) {
        $this->_timings = Yii::getLogger()->calculateTimings(isset($this->data['messages']) ? $this->data['messages'] : []);
    }
    return $this->_timings;
}

            

                public static function canBeExplained($type)
{
    return $type !== 'SHOW';
}

            

                public function countDuplicateQuery($timings)
{
    $query = ArrayHelper::getColumn($timings, 'info');
    return array_count_values($query);
}

            

                public function getDb()
{
    return Yii::$app->get($this->db);
}

            

                public function getDetail()
{
    $searchModel = new Db();
    if (!$searchModel->load(Yii::$app->request->getQueryParams())) {
        $searchModel->load($this->defaultFilter, '');
    }
    $models = $this->getModels();
    $dataProvider = $searchModel->search($models);
    $dataProvider->getSort()->defaultOrder = $this->defaultOrder;
    $sumDuplicates = $this->sumDuplicateQueries($models);
    return Yii::$app->view->render('panels/db/detail', [
        'panel' => $this,
        'dataProvider' => $dataProvider,
        'searchModel' => $searchModel,
        'hasExplain' => $this->hasExplain(),
        'sumDuplicates' => $sumDuplicates,
    ]);
}

            

                protected function getModels()
{
    if ($this->_models === null) {
        $this->_models = [];
        $timings = $this->calculateTimings();
        $duplicates = $this->countDuplicateQuery($timings);
        foreach ($timings as $seq => $dbTiming) {
            $this->_models[] = [
                'type' => $this->getQueryType($dbTiming['info']),
                'query' => $dbTiming['info'],
                'duration' => ($dbTiming['duration'] * 1000), // in milliseconds
                'trace' => $dbTiming['trace'],
                'timestamp' => ($dbTiming['timestamp'] * 1000), // in milliseconds
                'seq' => $seq,
                'duplicate' => $duplicates[$dbTiming['info']],
            ];
        }
    }
    return $this->_models;
}

            

                public function getName()
{
    return 'Database';
}

            

                public function getProfileLogs()
{
    $target = $this->module->logTarget;
    return $target->filterMessages($target->messages, Logger::LEVEL_PROFILE, ['yii\db\Command::query', 'yii\db\Command::execute']);
}

            

                protected function getQueryType($timing)
{
    $timing = ltrim($timing);
    preg_match('/^([a-zA-z]*)/', $timing, $matches);
    return count($matches) ? mb_strtoupper($matches[0], 'utf8') : '';
}

            

                public function getSummary()
{
    $timings = $this->calculateTimings();
    $queryCount = count($timings);
    $queryTime = number_format($this->getTotalQueryTime($timings) * 1000) . ' ms';
    return Yii::$app->view->render('panels/db/summary', [
        'timings' => $this->calculateTimings(),
        'panel' => $this,
        'queryCount' => $queryCount,
        'queryTime' => $queryTime,
    ]);
}

            

                public function getSummaryName()
{
    return 'DB';
}

            

                protected function getTotalQueryTime($timings)
{
    $queryTime = 0;
    foreach ($timings as $timing) {
        $queryTime += $timing['duration'];
    }
    return $queryTime;
}

            

                public function getTypes()
{
    return array_reduce(
        $this->_models,
        function ($result, $item) {
            $result[$item['type']] = $item['type'];
            return $result;
        },
        []
    );
}

            

                protected function hasExplain()
{
    $db = $this->getDb();
    if (!($db instanceof \yii\db\Connection)) {
        return false;
    }
    switch ($db->getDriverName()) {
        case 'mysql':
        case 'sqlite':
        case 'pgsql':
        case 'cubrid':
            return true;
        default:
            return false;
    }
}

            

                public function init()
{
    $this->actions['db-explain'] = [
        'class' => 'yii\\debug\\actions\\db\\ExplainAction',
        'panel' => $this,
    ];
}

            

                public function isEnabled()
{
    try {
        $this->getDb();
    } catch (InvalidConfigException $exception) {
        return false;
    }
    return parent::isEnabled();
}

            

                public function isQueryCountCritical($count)
{
    return (($this->criticalQueryThreshold !== null) && ($count > $this->criticalQueryThreshold));
}

            

                public function save()
{
    return ['messages' => $this->getProfileLogs()];
}

            

                public function sumDuplicateQueries($modelData)
{
    $numDuplicates = 0;
    $duplicates = ArrayHelper::getColumn($modelData, 'duplicate');
    foreach ($duplicates as $duplicate) {
        if ($duplicate > 1) {
            $numDuplicates++;
        }
    }
    return $numDuplicates;
}