Changeset View
Changeset View
Standalone View
Standalone View
branches/5.2.x/core/kernel/application.php
Show First 20 Lines • Show All 1252 Lines • ▼ Show 20 Line(s) | |||||
$this->_updateAverageStatistics($data, 'SqlCount', $query_statistics['count']); | $this->_updateAverageStatistics($data, 'SqlCount', $query_statistics['count']); | ||||
$data['Hits']++; | $data['Hits']++; | ||||
$data['LastHit'] = adodb_mktime(); | $data['LastHit'] = adodb_mktime(); | ||||
$this->Conn->doUpdate($data, TABLE_PREFIX . 'StatisticsCapture', 'StatisticsId = ' . $data['StatisticsId']); | $this->Conn->doUpdate($data, TABLE_PREFIX . 'StatisticsCapture', 'StatisticsId = ' . $data['StatisticsId']); | ||||
} | } | ||||
else { | else { | ||||
$data = array(); | |||||
$data['ScriptTimeMin'] = $data['ScriptTimeAvg'] = $data['ScriptTimeMax'] = $script_time; | $data['ScriptTimeMin'] = $data['ScriptTimeAvg'] = $data['ScriptTimeMax'] = $script_time; | ||||
$data['SqlTimeMin'] = $data['SqlTimeAvg'] = $data['SqlTimeMax'] = $query_statistics['time']; | $data['SqlTimeMin'] = $data['SqlTimeAvg'] = $data['SqlTimeMax'] = $query_statistics['time']; | ||||
$data['SqlCountMin'] = $data['SqlCountAvg'] = $data['SqlCountMax'] = $query_statistics['count']; | $data['SqlCountMin'] = $data['SqlCountAvg'] = $data['SqlCountMax'] = $query_statistics['count']; | ||||
$data['TemplateName'] = $this->GetVar('t'); | $data['TemplateName'] = $this->GetVar('t'); | ||||
$data['Hits'] = 1; | $data['Hits'] = 1; | ||||
$data['LastHit'] = adodb_mktime(); | $data['LastHit'] = adodb_mktime(); | ||||
$this->Conn->doInsert($data, TABLE_PREFIX . 'StatisticsCapture'); | $this->Conn->doInsert($data, TABLE_PREFIX . 'StatisticsCapture'); | ||||
} | } | ||||
Show All 34 Lines | |||||
$query_crc = kUtil::crc32($slow_sql); | $query_crc = kUtil::crc32($slow_sql); | ||||
$sql = 'SELECT * | $sql = 'SELECT * | ||||
FROM ' . TABLE_PREFIX . 'SlowSqlCapture | FROM ' . TABLE_PREFIX . 'SlowSqlCapture | ||||
WHERE QueryCrc = ' . $query_crc; | WHERE QueryCrc = ' . $query_crc; | ||||
$data = $this->Conn->Query($sql, null, true); | $data = $this->Conn->Query($sql, null, true); | ||||
if ( $data ) { | if ( $data ) { | ||||
$data = array_shift($data); // Because "Query" method (supports $no_debug) is used instead of "GetRow". | |||||
$this->_updateAverageStatistics($data, 'Time', $time); | $this->_updateAverageStatistics($data, 'Time', $time); | ||||
$template_names = explode(',', $data['TemplateNames']); | $template_names = explode(',', $data['TemplateNames']); | ||||
array_push($template_names, $this->GetVar('t')); | array_push($template_names, $this->GetVar('t')); | ||||
$data['TemplateNames'] = implode(',', array_unique($template_names)); | $data['TemplateNames'] = implode(',', array_unique($template_names)); | ||||
$data['Hits']++; | $data['Hits']++; | ||||
$data['LastHit'] = adodb_mktime(); | $data['LastHit'] = adodb_mktime(); | ||||
$this->Conn->doUpdate($data, TABLE_PREFIX . 'SlowSqlCapture', 'CaptureId = ' . $data['CaptureId']); | $this->Conn->doUpdate($data, TABLE_PREFIX . 'SlowSqlCapture', 'CaptureId = ' . $data['CaptureId']); | ||||
} | } | ||||
else { | else { | ||||
$data = array(); | |||||
$data['TimeMin'] = $data['TimeAvg'] = $data['TimeMax'] = $time; | $data['TimeMin'] = $data['TimeAvg'] = $data['TimeMax'] = $time; | ||||
$data['SqlQuery'] = $slow_sql; | $data['SqlQuery'] = $slow_sql; | ||||
$data['QueryCrc'] = $query_crc; | $data['QueryCrc'] = $query_crc; | ||||
$data['TemplateNames'] = $this->GetVar('t'); | $data['TemplateNames'] = $this->GetVar('t'); | ||||
$data['Hits'] = 1; | $data['Hits'] = 1; | ||||
$data['LastHit'] = adodb_mktime(); | $data['LastHit'] = adodb_mktime(); | ||||
$this->Conn->doInsert($data, TABLE_PREFIX . 'SlowSqlCapture'); | $this->Conn->doInsert($data, TABLE_PREFIX . 'SlowSqlCapture'); | ||||
▲ Show 20 Lines • Show All 1808 Lines • Show Last 20 Lines |