How to display all current page queries in WordPress

In WordPress, queries are used to retrieve data from the database and display it on the website. By default, WordPress does not display the current page queries on the front end, but there are several ways to achieve this.

Another option is to add some custom code to your theme’s “wp-config.php” configuration file. The following code will display all queries run on the current page in a browser console log:

<?php
    define( 'SAVEQUERIES', true );
?>

All WordPress Queries in a List

Add the following code to your theme to get a list of all database queries done for the current page.

<?php
if( current_user_can( 'administrator' ) ) {
	global $wpdb;
	echo '<pre>';
	print_r( $wpdb->queries );
	echo '</pre>';
}
?>

When you set SAVEQUERIES to true, the wpdb global instance saves all database queries you make, enabling you to see how many inquiries each page request makes to the database as well as the SQL used.

<?php
	global $wpdb;
	var_dump($wpdb->num_queries , $wpdb->queries);
?>

You may also connect to “posts_request”. You may place the code in the “functions.php” file of your child theme.

<?php
add_filter( 'posts_request', 'cxc_debug_post_request_call_back' );
function cxc_debug_post_request_call_back( $sql_text ) {
	$GLOBALS['CXC_debug'] = $sql_text; 
	return $sql_text;
}
?>

You may use “print r” in your theme’s wp_footer to produce the results displayed below:

<?php
add_action( 'wp_footer', 'cxc_footer_debug_post_request_call_back' );
function cxc_footer_debug_post_request_call_back(){
	print_r( $GLOBALS['CXC_debug'] );
}
?>

Making Use of WP_Query

<?php
$query_args = array(
	//Wp query Arguments
);

//Wp Query Results Variable
$results = new WP_Query( $query_args );

//show the wp query on screen
echo $results->request;

?>

Conclusion

In conclusion, displaying all current page queries in WordPress can be done using various methods, enabling debugging mode in the wp-config.php file, or using the WP_Query() function in the theme files.

By displaying all current page queries, you can get a better understanding of how your WordPress site is functioning and identify any performance issues that need to be addressed.

Also read:

How to Embed Gravity Forms With or Without Shortcode in WordPress

FAQs