Changeset 18990 for branches/camp/camp-2_5-D/data/class/SC_Query.php

Timestamp:

2010/11/06 20:27:45 (16 years ago)

Author:

uchida

Message:

execution time log.

File:

• branches/camp/camp-2_5-D/data/class/SC_Query.php (modified) (1 diff)

branches/camp/camp-2_5-D/data/class/SC_Query.php

@@ -775 +775 @@
      */
     function execute(&$sth, $arrVal = array()) {
+        $timeStart = SC_Utils_Ex::sfMicrotimeFloat();
         $affected =& $sth->execute($arrVal);
+
+        // 一定以上時間かかったSQLの場合、ログ出力する。
+        if(defined('SQL_QUERY_LOG_MODE') && SQL_QUERY_LOG_MODE == true) {
+            $timeEnd = SC_Utils_Ex::sfMicrotimeFloat();;
+            $timeExecTime = $timeEnd - $timeStart;
+            if(defined('SQL_QUERY_LOG_MIN_EXEC_TIME') && $timeExecTime >= (float)SQL_QUERY_LOG_MIN_EXEC_TIME) {
+                //$logMsg = sprintf("SQL_LOG [%.2fsec]\n%s", $timeExecTime, $this->getLastQuery(false));
+                $logMsg = sprintf("SQL_LOG [%.2fsec]\n%s", $timeExecTime, $sth->query);
+                GC_Utils_Ex::gfPrintLog($logMsg);
+            }
+        }
+
         if (PEAR::isError($affected)) {
             $sql = isset($sth->query) ? $sth->query : '';