Skip to content

Instantly share code, notes, and snippets.

@flayder
Created February 3, 2021 15:50
Show Gist options
  • Save flayder/93c72ac3a5082c57610d3a143c5a28a3 to your computer and use it in GitHub Desktop.
Save flayder/93c72ac3a5082c57610d3a143c5a28a3 to your computer and use it in GitHub Desktop.
define('SAVEQUERIES', true);
add_action('shutdown', 'sql_logger');
function sql_logger() {
global $wpdb;
$log_file = fopen(ABSPATH.'/sql_log.txt', 'a');
fwrite($log_file, "//////////////////////////////////////////\n\n" . date("F j, Y, g:i:s a")."\n");
foreach($wpdb->queries as $q) {
fwrite($log_file, $q[0] . " - ($q[1] s)" . "\n\n");
}
fclose($log_file);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment