Changeset View
Changeset View
Standalone View
Standalone View
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 | |||||