Class yii\debug\panels\DbPanel

                public function calculateTimings()
{
    if ($this->_timings === null) {
        $this->_timings = Yii::getLogger()->calculateTimings(isset($this->data['messages']) ? $this->data['messages'] : $this->getProfileLogs());
        // Parse aliases
        $ignoredPathsInBacktrace = array_map(
            function($path) {
                return Yii::getAlias($path);
            },
            $this->ignoredPathsInBacktrace
        );
        // Generate hash for caller
        $hashAlgo = in_array('xxh3', hash_algos()) ? 'xxh3' : 'crc32';
        foreach ($this->_timings as &$timing) {
            if ($ignoredPathsInBacktrace) {
                foreach ($timing['trace'] as $index => $trace) {
                    foreach ($ignoredPathsInBacktrace as $ignoredPathInBacktrace) {
                        if (isset($trace['file']) && strpos($trace['file'], $ignoredPathInBacktrace) === 0) {
                            unset($timing['trace'][$index]);
                        }
                    }
                }
            }
            $timing['traceHash'] = hash($hashAlgo, json_encode($timing['trace']));
        }
    }
    return $this->_timings;
}

            

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

            

                public function countCallerCals()
{
    $query = ArrayHelper::getColumn($this->calculateTimings(), 'traceHash');
    return array_count_values($query);
}

            

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

            

                public function generateQueryCallersDataProvider($modelData)
{
    $callers = [];
    foreach ($modelData as $data) {
        if (!array_key_exists($data['traceHash'], $callers)) {
            $callers[$data['traceHash']] = [
                'trace' => $data['trace'],
                'numCalls' => 0,
                'totalDuration' => 0,
                'queries' => []
            ];
        }
        $callers[$data['traceHash']]['numCalls'] += 1;
        $callers[$data['traceHash']]['totalDuration'] += $data['duration'];
        $callers[$data['traceHash']]['queries'][] = [
            'timestamp' => $data['timestamp'],
            'duration' => $data['duration'],
            'query' => $data['query'],
            'type' => $data['type'],
            'seq' => $data['seq'],
        ];
    }
    return new ArrayDataProvider([
        'allModels' => $callers,
        'pagination' => false,
        'sort' => [
            'attributes' => ['numCalls', 'totalDuration'],
            'defaultOrder' => ['numCalls' => SORT_DESC],
        ],
    ]);
}

            

                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();
    $queryDataProvider = $searchModel->search($models);
    $queryDataProvider->getSort()->defaultOrder = $this->defaultOrder;
    $sumDuplicates = $this->sumDuplicateQueries($models);
    $callerDataProvider = $this->generateQueryCallersDataProvider($models);
    return Yii::$app->view->render('panels/db/detail', [
        'panel' => $this,
        'queryDataProvider' => $queryDataProvider,
        'callerDataProvider' => $callerDataProvider,
        'searchModel' => $searchModel,
        'hasExplain' => $this->hasExplain(),
        'sumDuplicates' => $sumDuplicates,
    ]);
}

            

                public function getExcessiveCallers()
{
    if ($this->excessiveCallerThreshold === null) {
        return [];
    }
    return array_filter(
        $this->countCallerCals(),
        function ($count) {
            return $count >= $this->excessiveCallerThreshold;
        }
    );
}

            

                public function getExcessiveCallersCount()
{
    return count($this->getExcessiveCallers());
}

            

                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'],
                'traceHash' => $dbTiming['traceHash'],
                'timestamp' => ($dbTiming['timestamp'] * 1000), // in milliseconds
                'seq' => $seq,
                'duplicate' => $duplicates[$dbTiming['info']],
            ];
        }
    }
    return $this->_models;
}

            

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

            

                public function getProfileLogs()
{
    if ($this->_profileLogs === null) {
        $this->_profileLogs = $this->getLogMessages(Logger::LEVEL_PROFILE, $this->dbEventNames);
    }
    return $this->_profileLogs;
}

            

                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';
    $excessiveCallerCount = $this->getExcessiveCallersCount();
    return Yii::$app->view->render('panels/db/summary', [
        'timings' => $this->calculateTimings(),
        'panel' => $this,
        'queryCount' => $queryCount,
        'queryTime' => $queryTime,
        'excessiveCallerCount' => $excessiveCallerCount,
    ]);
}

            

                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 isNumberOfCallsExcessive($numCalls)
{
    return (($this->excessiveCallerThreshold !== null) && ($numCalls > $this->excessiveCallerThreshold));
}

            

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

            

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

            

                public function sumDuplicateQueries($modelData)
{
    $numDuplicates = 0;
    foreach ($modelData as $data) {
        if ($data['duplicate'] > 1) {
            $numDuplicates++;
        }
    }
    return $numDuplicates;
}