Log SQL queries from WordPress

log_query.php

<?php

 // in wordpress theme: functions.php add this in

function log_sql_queries($text_query){
	/* //Uncomment me if you want a lot of info about where the sql query comes from and what action started it off
	$traces = debug_backtrace();
	$i = 0;
	foreach ($traces as $tobj => $trace) {
		if($trace['function'] == 'do_action'){
			$args = $trace['args'];
		}
		error_log("TRACE:$i:"  . $trace['function'] . print_r($args,1));
		$i++;
	}
	*/
	error_log("INFO:SQL:" . $text_query);
	return $text_query;
}

add_filter( 'posts_request', 'log_sql_queries' );
//add_filter( 'query', 'log_sql_queries' ); //use this to see _everything_ , a lot of information including database selects that are likely served from the wp cache


?>