Log DB Queries for WordPress

log-db-queries-wordpress.php

<?php

namespace TenUp_QueryLog;

function log_queries( $query ) {
	if ( ! preg_match( '/^\s*(create|alter|truncate|drop|insert|delete|update|replace)\s/i', $query ) ) {
		return $query;
	}

	// Not interested in any operations with transients
	if ( false !== strpos( $query, 'transient_' ) ) {
		return $query;
	}

	error_log( $query . "\n", 3, WP_CONTENT_DIR . '/queries.log' );

	return $query;
}
add_filter( 'query', __NAMESPACE__ . '\log_queries' );