<?php /** * @link http://www.yiiframework.com/ * @copyright Copyright (c) 2008 Yii Software LLC * @license http://www.yiiframework.com/license/ */ namespace yii\debug\panels; use yii\debug\Panel; use yii\helpers\ArrayHelper; use yii\log\Logger; use yii\helpers\Html; /** * Debugger panel that collects and displays database queries performed. * * @author Qiang Xue <qiang.xue@gmail.com> * @since 2.0 */ class DbPanel extends Panel { public function getName() { return 'Database'; } public function getSummary() { $timings = $this->calculateTimings(); $queryCount = count($timings); $queryTime = 0; foreach ($timings as $timing) { $queryTime += $timing[3]; } $queryTime = number_format($queryTime * 1000) . ' ms'; $url = $this->getUrl(); $output = <<<EOD <div class="yii-debug-toolbar-block"> <a href="$url" title="Executed $queryCount database queries which took $queryTime."> DB <span class="label">$queryCount</span> <span class="label">$queryTime</span> </a> </div> EOD; return $queryCount > 0 ? $output : ''; } public function getDetail() { $timings = $this->calculateTimings(); ArrayHelper::multisort($timings, 3, true); $rows = array(); foreach ($timings as $timing) { $duration = sprintf('%.1f ms', $timing[3] * 1000); $procedure = Html::encode($timing[1]); $traces = $timing[4]; if (!empty($traces)) { $procedure .= Html::ul($traces, array( 'class' => 'trace', 'item' => function ($trace) { return "<li>{$trace['file']}({$trace['line']})</li>"; }, )); } $rows[] = "<tr><td style=\"width: 80px;\">$duration</td><td>$procedure</td>"; } $rows = implode("\n", $rows); return <<<EOD <h1>Database Queries</h1> <table class="table table-condensed table-bordered table-striped table-hover" style="table-layout: fixed;"> <thead> <tr> <th style="width: 80px;">Time</th> <th>Query</th> </tr> </thead> <tbody> $rows </tbody> </table> EOD; } private $_timings; protected function calculateTimings() { if ($this->_timings !== null) { return $this->_timings; } $messages = $this->data['messages']; $timings = array(); $stack = array(); foreach ($messages as $i => $log) { list($token, $level, $category, $timestamp) = $log; $log[5] = $i; if ($level == Logger::LEVEL_PROFILE_BEGIN) { $stack[] = $log; } elseif ($level == Logger::LEVEL_PROFILE_END) { if (($last = array_pop($stack)) !== null && $last[0] === $token) { $timings[$last[5]] = array(count($stack), $token, $last[3], $timestamp - $last[3], $last[4]); } } } $now = microtime(true); while (($last = array_pop($stack)) !== null) { $delta = $now - $last[3]; $timings[$last[5]] = array(count($stack), $last[0], $last[2], $delta, $last[4]); } ksort($timings); return $this->_timings = $timings; } public function save() { $target = $this->module->logTarget; $messages = $target->filterMessages($target->messages, Logger::LEVEL_PROFILE, array('yii\db\Command::queryInternal')); return array( 'messages' => $messages, ); } }