/** * When destroyed, if SQL profiled enabled, logs the SQL profiling information */ public function recordProfiling() { if(is_null($this->connection)) { return; } // turn off the profiler so we don't profile the following queries self::$profiling = false; foreach($this->queriesProfiling as $query => $info) { $time = $info['sum_time_ms']; $count = $info['count']; $queryProfiling = "INSERT INTO ".Piwik_Common::prefixTable('log_profiling')." (query,count,sum_time_ms) VALUES (?,$count,$time) ON DUPLICATE KEY UPDATE count=count+$count,sum_time_ms=sum_time_ms+$time"; $this->query($queryProfiling,array($query)); } // turn back on profiling self::$profiling = true; }
/** * When destroyed, if SQL profiled enabled, logs the SQL profiling information */ public function recordProfiling() { if (is_null($this->connection)) { return; } // turn off the profiler so we don't profile the following queries self::$profiling = false; foreach ($this->queriesProfiling as $query => $info) { $time = round($info['sum_time_ms']); $count = $info['count']; try { $queryProfiling = "UPDATE " . Piwik_Common::prefixTable('log_profiling') . "\n\t\t\t\t\t\tSET count=count+?, sum_time_ms=sum_time_ms+?\n\t\t\t\t\t\tWHERE query=?"; $this->query($queryProfiling, array($count, $time, $query)); } catch (Exception $e) { $queryProfiling = "INSERT INTO " . Piwik_Common::prefixTable('log_profiling') . "\n\t\t\t\t\t\t\t(count,sum_time_ms,query) VALUES (?,?,?)"; $this->query($queryProfiling, array($count, $time, $query)); } } // turn back on profiling self::$profiling = true; }