/** * $viewType can be 'Select' or 'Explain' */ protected function getSqlUrl(Zend_Db_Profiler_Query $query, $viewType = self::SQL_SELECT_ACTION) { $queryType = $query->getQueryType(); if ($queryType == Zend_Db_Profiler::SELECT) { return Mage::getUrl('debug/index/' . $viewType, array('_query' => array('sql' => $query->getQuery(), 'params' => $query->getQueryParams()))); } else { return ''; } }
/** * Executes a prepared statement. * * @param array $params OPTIONAL Values to bind to parameter placeholders. * @return bool */ public function execute(array $params = null) { if ($this->_queryProfile) { if ($this->_queryProfile->hasEnded()) { $prof = $this->_adapter->getProfiler(); $q = $prof->queryClone($this->_queryProfile); $this->_queryProfile = $prof->getQueryProfile($q); } if ($params !== null) { foreach ($params as $param => $variable) { if (is_int($param)) { $param++; } $this->_queryProfile->bindParam($param, $variable); } } $this->_queryProfile->start(); } $retval = true; if ($params !== null) { $retval = $this->_execute($params); } else { $retval = $this->_execute(); } if ($this->_queryProfile) { $this->_queryProfile->end(); } return $retval; }
/** * Executes a prepared statement. * * @param array $params OPTIONAL Values to bind to parameter placeholders. * @return bool * @throws Zend_Db_Statement_Exception */ public function execute(array $params = array()) { if ($this->_queryProfile !== null) { $this->_queryProfile->bindParams($params); $this->_queryProfile->end(); } return true; }
public function __construct($query, $queryType) { parent::__construct($query, $queryType); $this->_backtrace = array(); foreach (debug_backtrace() as $bt) { if (!isset($bt['file'])) { continue; } $this->_backtrace[] = "{$bt['file']}:{$bt['line']}\n"; } }