| Server IP : 37.220.80.31 / Your IP : 3.146.176.172 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/main/lib/diag/ |
Upload File : |
<?php
namespace Bitrix\Main\Diag;
class SqlTrackerQuery implements \ArrayAccess
{
/** @var string */
protected $sql = "";
/** @var array|null */
protected $binds = null;
/** @var string */
protected $state = "";
/** @var string */
protected $node = "";
/** @var float */
protected $startTime = 0.0;
/** @var float */
protected $finishTime = 0.0;
/** @var float */
protected $time = 0.0;
/** @var array|null */
protected $trace = null;
/** @var SqlTracker */
protected $tracker;
/**
* @param SqlTracker $tracker This sql tracker.
*/
public function __construct(SqlTracker $tracker)
{
$this->tracker = $tracker;
}
/**
* Starts sql timer.
*
* @param string $sql Query text.
* @param array $binds Binded variables used with query.
*
* @return void
*/
public function startQuery($sql, array $binds = null)
{
$this->sql = $sql;
$this->binds = $binds;
$this->startTime = Helper::getCurrentMicrotime();
}
/**
* Ends sql timer.
*
* @param integer $skip How many backtrace skip. By default 3.
*
* @return void
*/
public function finishQuery($skip = 3)
{
$this->finishTime = Helper::getCurrentMicrotime();
$this->time = $this->finishTime - $this->startTime;
$this->trace = $this->filterTrace(Helper::getBackTrace($this->tracker->getDepthBackTrace(), null, $skip));
$this->tracker->addTime($this->time);
$this->tracker->writeFileLog($this->sql, $this->time, "", 4);
}
/**
* Resets sql timer start.
* combined with refinishQuery allows additional time to be included into execution.
*
* @return void
* @see \Bitrix\Main\Diag\SqlTrackerQuery::refinishQuery
*/
public function restartQuery()
{
$this->startTime = Helper::getCurrentMicrotime();
}
/**
* Finishes query timer one more time.
* Use with restartQuery.
*
* @return void
* @see \Bitrix\Main\Diag\SqlTrackerQuery::restartQuery
*/
public function refinishQuery()
{
$this->finishTime = Helper::getCurrentMicrotime();
$this->addTime($this->finishTime - $this->startTime);
}
/**
* Returns tracked sql text.
*
* @return string
*/
public function getSql()
{
return $this->sql;
}
/**
* Sets tracked sql text.
* Returns the object for call chaining.
*
* @param string $sql Sql text.
*
* @return \Bitrix\Main\Diag\SqlTrackerQuery
*/
public function setSql($sql)
{
$this->sql = (string)$sql;
return $this;
}
/**
* Returns sql binds used for query execution.
*
* @return array|null
*/
public function getBinds()
{
return $this->binds;
}
/**
* Sets tracked sql binds.
* Returns the object for call chaining.
*
* @param array $binds Sql binds.
*
* @return \Bitrix\Main\Diag\SqlTrackerQuery
*/
public function setBinds(array $binds)
{
$this->binds = $binds;
return $this;
}
/**
* Returns page state of the query.
*
* @return string
*/
public function getState()
{
return $this->state;
}
/**
* Sets tracked sql page state.
* Returns the object for call chaining.
*
* @param string $state Page state.
*
* @return \Bitrix\Main\Diag\SqlTrackerQuery
*/
public function setState($state)
{
$this->state = (string)$state;
return $this;
}
/**
* Returns sql connection node id of the query.
*
* @return string
*/
public function getNode()
{
return $this->node;
}
/**
* Sets tracked sql connection node id.
* Returns the object for call chaining.
*
* @param string $node Cluster node identifier.
*
* @return \Bitrix\Main\Diag\SqlTrackerQuery
*/
public function setNode($node)
{
$this->node = (string)$node;
return $this;
}
/**
* Returns sql execution time.
*
* @return float
*/
public function getTime()
{
return $this->time;
}
/**
* Sets tracked sql execution time.
* Returns the object for call chaining.
*
* @param float $time Sql execution time in seconds.
*
* @return \Bitrix\Main\Diag\SqlTrackerQuery
*/
public function setTime($time)
{
$this->tracker->addTime(-$this->time);
$this->time = (float)$time;
$this->tracker->addTime($this->time);
return $this;
}
/**
* Increments sql execution time.
*
* @param float $time Time in seconds to add.
*
* @return void
*/
public function addTime($time)
{
$time = (float)$time;
$this->time += $time;
$this->tracker->addTime($time);
}
/**
* Returns backtrace of the query.
*
* @return array|null
*/
public function getTrace()
{
return $this->trace;
}
/**
* Sets tracked sql backtrace.
* Returns the object for call chaining.
*
* @param array $trace Query backtrace.
*
* @return \Bitrix\Main\Diag\SqlTrackerQuery
*/
public function setTrace(array $trace)
{
$this->trace = $this->filterTrace($trace);
return $this;
}
/**
* Whether a offset exists.
* Part of ArrayAccess implementation made for backward compatibility.
*
* @param mixed $offset Array key.
*
* @return boolean
*/
public function offsetExists($offset)
{
switch ((string)$offset)
{
case "BX_STATE":
return true;
case "TIME":
return true;
case "QUERY":
return true;
case "TRACE":
return true;
case "NODE_ID":
return true;
default:
return false;
}
}
/**
* Offset to retrieve.
* Part of ArrayAccess implementation made for backward compatibility.
*
* @param mixed $offset Array key.
*
* @return mixed
*/
public function offsetGet($offset)
{
switch ($offset)
{
case "BX_STATE":
return $this->state;
case "TIME":
return $this->time;
case "QUERY":
return $this->sql;
case "TRACE":
return $this->trace;
case "NODE_ID":
return $this->node;
default:
return false;
}
}
/**
* Offset to set.
* Part of ArrayAccess implementation made for backward compatibility.
*
* @param mixed $offset Array key.
* @param mixed $value Array value.
*
* @return mixed
*/
public function offsetSet($offset, $value)
{
}
/**
* Offset to unset.
* Part of ArrayAccess implementation made for backward compatibility.
*
* @param mixed $offset Array key.
*
* @return mixed
*/
public function offsetUnset($offset)
{
}
/**
* Removes and formats memory consuming function arguments in the backtrace.
*
* @param array $trace Backtrace.
*
* @return array
*/
protected function filterTrace($trace)
{
$filtered = array();
foreach ($trace as $i => $tr)
{
$args = array();
if (!empty($tr["args"]) && is_array($tr["args"]))
{
foreach ($tr["args"] as $k1 => $v1)
{
if (is_array($v1))
{
foreach ($v1 as $k2 => $v2)
{
if (is_scalar($v2))
{
$args[$k1][$k2] = $v2;
}
elseif (is_object($v2))
{
$args[$k1][$k2] = get_class($v2);
}
else
{
$args[$k1][$k2] = gettype($v2);
}
}
}
else
{
if (is_scalar($v1))
{
$args[$k1] = $v1;
}
elseif (is_object($v1))
{
$args[$k1] = get_class($v1);
}
else
{
$args[$k1] = gettype($v1);
}
}
}
}
$filtered[] = [
"file" => $tr["file"],
"line" => $tr["line"],
"class" => $tr["class"],
"type" => $tr["type"],
"function" => $tr["function"],
"args" => $args,
];
}
return $filtered;
}
}