Changeset 42789

Timestamp:

03/05/2018 10:53:40 PM (7 years ago)

Author:

johnbillion

Message:

Database: Add the query start time to logged query data.

This allows debugging plugins to plot the time at which queries were executed.

Props Rarst for initial patch.

Fixes #43315

File:

• trunk/src/wp-includes/wp-db.php (modified) (3 diffs)

trunk/src/wp-includes/wp-db.php

@@ -175 +175 @@
 
     /**
-     * Saved queries that were executed
+     * Log of queries that were executed, for debugging purposes.
      *
      * @since 1.5.0
-     * @var array
+     * @since 2.5.0 The third element in each query log was added to record the calling functions.
+     * @since 5.0.0 The fourth element in each query log was added to record the start time.
+     *
+     * @var array[] {
+     *     Array of queries that were executed.
+     *
+     *     @type array ...$0 {
+     *         Data for each query.
+     *
+     *         @type string $0 The query's SQL.
+     *         @type float  $1 Total time spent on the query, in seconds.
+     *         @type string $2 Comma separated list of the calling functions.
+     *         @type float  $3 Unix timestamp of the time at the start of the query.
+     *     }
+     * }
      */
     var $queries;
@@ -1987 +2001 @@
 
         if ( defined( 'SAVEQUERIES' ) && SAVEQUERIES ) {
-            $this->queries[] = array( $query, $this->timer_stop(), $this->get_caller() );
+            $this->queries[] = array(
+                $query,
+                $this->timer_stop(),
+                $this->get_caller(),
+                $this->time_start,
+            );
         }
     }
@@ -3494 +3513 @@
      * @since 2.5.0
      *
-     * @return string|array The name of the calling function
+     * @return string Comma separated list of the calling functions.
      */
     public function get_caller() {