Changeset 709

Timestamp:

Jan 5, 2014, 2:07:44 PM (11 years ago)

Author:

chronos

Message:

• Added: Print SQL per query duration in developer mode.

Location:

trunk/includes

Files:

• Database.php (modified) (1 diff)
• Version.php (modified) (1 diff)

trunk/includes/Database.php

@@ -64 +64 @@
   function query($Query)
   {
+        if($this->ShowSQLQuery == true) $QueryStartTime = microtime();
     $this->LastQuery = $Query;
-    if($this->ShowSQLQuery == true) 
-      echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.'</div>'."\n");
     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)
+    { 
+        $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)
     {

trunk/includes/Version.php

@@ -6 +6 @@
 // and system will need database update. 
 
-$Revision = 708; // Subversion revision
+$Revision = 709; // Subversion revision
 $DatabaseRevision = 695; // Database structure revision 
 $ReleaseTime = '2014-01-04';