Store DB queries throughout request

cac-query-log-json.php

<?php

add_action( 'muplugins_loaded', 'cac_temp_log_db_queries_as_json', 9999 );
add_action( 'plugins_loaded', 'cac_temp_log_db_queries_as_json', 9999 );
add_action( 'init', 'cac_temp_log_db_queries_as_json', 9999 );
add_action( 'shutdown', 'cac_temp_log_db_queries_as_json', 9999 );

/**
 * Log all database queries as lines of JSON.
 */
function cac_temp_log_db_queries_as_json() {
	global $wpdb;

	if ( defined( 'SAVEQUERIES' ) && SAVEQUERIES ) {
		$log_file = ABSPATH . '/wp-content/cac-query-log.json';
		$records  = '';

		$request_domain = $_SERVER['HTTP_HOST'];
		$request_uri    = $_SERVER['REQUEST_URI'];

		foreach( $wpdb->queries as $query ) {
			$records .= wp_json_encode(
				(object) array(
					'query' => $query[0],
					'time'  => $query[1],
					'call'  => $query[2],
					'domain' => $request_domain,
					'uri'    => $request_uri,
				)
			) . "\n";
		}

		file_put_contents( $log_file, $records, FILE_APPEND );

		// Clear global query data.
		$wpdb->queries = array();
	}
}

cac-query-log-text.php

<?php

add_action( 'muplugins_loaded', 'cac_temp_log_db_queries_as_text', 9999 );
add_action( 'plugins_loaded', 'cac_temp_log_db_queries_as_text', 9999 );
add_action( 'init', 'cac_temp_log_db_queries_as_text', 9999 );
add_action( 'shutdown', 'cac_temp_log_db_queries_as_text', 9999 );

/**
 * Log all database queries to pipe delimited lines in a text file.
 */
function cac_temp_log_db_queries_as_text() {
	global $wpdb;

	if ( defined( 'SAVEQUERIES' ) && SAVEQUERIES ) {
		$log_file = ABSPATH . '/wp-content/cac-query-log.txt';
		$records  = '';

		$request_domain = $_SERVER['HTTP_HOST'];
		$request_uri    = $_SERVER['REQUEST_URI'];

		foreach( $wpdb->queries as $query ) {
			$records .= sprintf(
				"%s | %s | %s | %s | %s\n",
				$query[0],
				$query[1],
				$query[2],
				$request_domain,
				$request_uri
			);
		}

		file_put_contents( $log_file, $records, FILE_APPEND );

		// Clear global query data.
		$wpdb->queries = array();
	}
}