How to display all database queries made by Wordpress?
If you add define('SAVEQUERIES', true) to your configuration file, you can then list all the queries made for the current page by adding the following to your theme.
if (current_user_can('administrator')){ global $wpdb; echo "<pre>"; print_r($wpdb->queries); echo "</pre>";}See the documentation for more details: http://codex.wordpress.org/Editing_wp-config.php#Save_queries_for_analysis
or you can hook into posts_request. You can put the coe inside functions.php such as
add_filter('posts_request','debug_post_request'); // debugging sql query of a postfunction debug_post_request($sql_text) { $GLOBALS['debugku'] = $sql_text; //intercept and store the sql<br/> return $sql_text; }in your theme footer, you can use print_r like
print_r($GLOBALS['debugku']);
Use Query Monitor.
It's a free and open-source plugin where you can filter your queries in various contexts, such as:
- Which plugin called
- Queries that took the most time
- Duplicated queries
- You can filter by Select / Update / Insert / Delete
Among other things...
