Get WordPress SQL query details

When I debug WordPress, getting SQL query details is useful in some situations.

In the WordPress plugin repo, we can find some nice debug plugins to get query details. Also, we can use default WordPress options to get query details.

First, we need to add a definition in our wp-config.php.

define('SAVEQUERIES', true);

The SAVEQUERIES definition saves the database queries to an array and we can use that array to analyze those queries.

The array is stored in the global $wpdb->queries.

Print last SQL query string

$wpdb->last_query

Print last SQL query result

$wpdb->last_result

Print last SQL query Error

$wpdb->last_error

Recent Posts

1. Automating Code Linting with GitHub Actions for WordPress Plugins
2. Comprehensive Guide to Linting PHP, JavaScript, and CSS in WordPress Plugins Using Composer
3. The Ultimate Guide to Indexing in Database Design
4. Understanding 'update_meta_cache' in WordPress - When to Use It, When Not to, and Its Impact on Database Queries
5. A Guide to Configuring JavaScript and SCSS Paths in WordPress Plugins with @wordpress/scripts

This article was published on March 23, 2019

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.