Changeset 769 for trunk/includes/Database.php

Timestamp:

Jan 31, 2014, 12:23:31 AM (10 years ago)

Author:

chronos

Message:

• Added: Log query duration to sql log file.

File:

• trunk/includes/Database.php (modified) (1 diff)

trunk/includes/Database.php

@@ -63 +63 @@
   function query($Query)
   {
-        if($this->ShowSQLQuery == true) $QueryStartTime = microtime();
+        if(($this->ShowSQLQuery == true) or ($this->LogSQLQuery == true)) $QueryStartTime = microtime();
     $this->LastQuery = $Query;
-    if($this->LogSQLQuery == true)
-      file_put_contents($this->LogFile, $Query."\n", FILE_APPEND);
     $Result = new DatabaseResult();
     $Result->PDOStatement = $this->PDO->query($Query);
+    if(($this->ShowSQLQuery == true) or ($this->LogSQLQuery == true)) 
+      $Duration = ' ; '.(microtime() - $QueryStartTime). ' s';
+    if($this->LogSQLQuery == true)
+      file_put_contents($this->LogFile, $Query.$Duration."\n", FILE_APPEND);
     if($this->ShowSQLQuery == true)
-    { 
-        $Duration = ' ; '.(microtime() - $QueryStartTime). ' s';
       echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.$Duration.'</div>'."\n");
-    }
     if($Result->PDOStatement)
     {