filter = $filter ? (int) $filter : \DibiEvent::QUERY; $this->explain = $explain; } public function register(\DibiConnection $connection) { Tracy\Debugger::getBar()->addPanel($this); Tracy\Debugger::getBlueScreen()->addPanel(array(__CLASS__, 'renderException')); $connection->onEvent[] = array($this, 'logEvent'); } /** * After event notification. * @return void */ public function logEvent(\DibiEvent $event) { if (($event->type & $this->filter) === 0) { return; } $this->events[] = $event; } /** * Returns blue-screen custom tab. * @return mixed */ public static function renderException($e) { if ($e instanceof \DibiException && $e->getSql()) { return array( 'tab' => 'SQL', 'panel' => dibi::dump($e->getSql(), TRUE), ); } } /** * Returns HTML code for custom tab. (Tracy\IBarPanel) * @return mixed */ public function getTab() { $totalTime = 0; foreach ($this->events as $event) { $totalTime += $event->time; } return '' . count($this->events) . ' queries' . ($totalTime ? sprintf(' / %0.1f ms', $totalTime * 1000) : '') . ''; } /** * Returns HTML code for custom panel. (Tracy\IBarPanel) * @return mixed */ public function getPanel() { $totalTime = $s = NULL; $h = 'htmlSpecialChars'; foreach ($this->events as $event) { $totalTime += $event->time; $explain = NULL; // EXPLAIN is called here to work SELECT FOUND_ROWS() if ($this->explain && $event->type === \DibiEvent::SELECT) { try { $backup = array($event->connection->onEvent, dibi::$numOfQueries, dibi::$totalTime); $event->connection->onEvent = NULL; $cmd = is_string($this->explain) ? $this->explain : ($event->connection->getConfig('driver') === 'oracle' ? 'EXPLAIN PLAN' : 'EXPLAIN'); $explain = dibi::dump($event->connection->nativeQuery("$cmd $event->sql"), TRUE); } catch (\DibiException $e) {} list($event->connection->onEvent, dibi::$numOfQueries, dibi::$totalTime) = $backup; } $s .= '' . sprintf('%0.3f', $event->time * 1000); if ($explain) { static $counter; $counter++; $s .= "
explain"; } $s .= '' . dibi::dump(strlen($event->sql) > self::$maxLength ? substr($event->sql, 0, self::$maxLength) . '...' : $event->sql, TRUE); if ($explain) { $s .= "
{$explain}
"; } if ($event->source) { $s .= Tracy\Helpers::editorLink($event->source[0], $event->source[1]);//->class('tracy-DibiProfiler-source'); } $s .= "{$event->count}{$h($event->connection->getConfig('driver') . '/' . $event->connection->getConfig('name'))}"; } return empty($this->events) ? '' : '

Queries: ' . count($this->events) . ($totalTime === NULL ? '' : sprintf(', time: %0.3f ms', $totalTime * 1000)) . '

' . $s . '
Time msSQL StatementRowsConnection
'; } }