I’m sure there are more sophisticated ways to debug the queries, but I’m not aware of them. So usually when I need to debug WP queries I use either Query Monitor or Debug Bar (with Slow Actions addon) plugin, which can be found on the wordpress.org plugin repository. These plugins help you trace which functions / plugins are slowing the site down. At least for me these plugins have been great help.
I’m not affiliated to any of these plugins and my apologies for giving just a plugin recommendation answer.
Related Posts:
- Is it a good idea to improve meta query performance by adding tax query?
- Meta_query on same meta key, with diffrenct values
- query post by author gender
- How to do WP_User_Query for Nested Array value Inside Nested Array field
- Get all user with both meta_value
- Meta_query compare operator explanation
- meta_query with meta values as serialize arrays
- Nested meta_query with multiple relation keys
- meta_query ‘compare’ => ‘IN’ not working
- Use REGEXP in WP_Query meta_query key
- WP Query Args – Title or Meta Value
- Meta query with string starting like pattern
- compare meta_query in get_posts arguments
- How to query posts based on lat-lng coordinate as post meta?
- how to show posts that are missing a meta_value
- Set Alias for meta_query arguments in get_posts()
- Sorting: custom query with orderby meta_value_num THEN by title
- Display products from specific category in shop page
- How to Compare Two Meta Fields
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- Differences Between WP_Query() and get_posts() for Querying Posts?
- Does tax_query really beats meta_query in all situations?
- WP_Query with checkbox meta_query
- ACF Relationship Field Search Filtering [closed]
- Should I use Transients with W3 Total Cache APC Caching? [closed]
- What is the most efficient way of querying posts based on visits and date for current day?
- Add indexing to meta_value in wp_postmeta
- Is it possible to orderby multiple meta_keys when using meta_value_num?
- Custom WP_Query order by post_meta and (author) user_meta
- Query WooCommerce orders where meta data does not exist
- Getting attachments by meta value
- Query Multiple Post types each with own meta query
- Is it true $wpdb->get_results is faster than WP_Query in most cases?
- Execute a large WP_Query with many “AND” Meta_Queries?
- Getting all user metadata from user
- Query all posts where meta value is empty
- WP_Query min and max values
- Slow SQL_CALC_FOUND_ROWS Query
- ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
- WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
- Using custom meta_query with relation not working as expected
- Perform query with meta_value date
- querying with custom meta field with meta_query
- Order by two meta keys
- multiple meta key but get server load is very high
- Meta Query with date and time on the same Day before given time
- A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
- get_the_title($postID) OR get_the_title()?
- How to grab metabox value in wp_query meta_query key
- WP_Query meta_query where meta value ends in space
- Order by meta_value_num DESC and meta_value ASC on WP 4.0
- Finding all results from database within 500 miles of the given latitude and longitude [closed]
- Nested query inside Logical operator OR not working in meta_query
- Searching user meta using WP_User_Query
- Is “orderby” in WP Meta Query conflicting with Meta Query?
- Query by meta_key and order by meta_value_num return orderby date
- What is an efficient way to query based on post_meta?
- WP_Query not working as expected for attachments and custom meta_query
- SQL query equivalent to WP User Query
- datetime picker, timestamps and meta queries
- How do I create my own nested meta_query using posts_where / posts_join?
- Stop all SQL_CALC_FOUND_ROWS wordpress queries
- WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
- How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
- Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
- Wp_query order by multiple custom fields?
- How can I create a WP_Query that returns posts where one meta_value
- Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
- WordPress altering my custom query, How to fix it?
- WP Meta Query for some meta (array) values
- Exclude post on loop by multiple meta key value
- Sort users by meta_value_num
- Querying by taxonomy vs Querying by Custom fields Speed Comparison
- meta_query with array as value
- How to get sum of meta_values of a meta_key in wp_query according to conditions
- How to query ‘posts_per_page’ to display a different blog posts index template?
- Slow speed and high CPU usage for my code. How to improve it?
- Multiple queries on Home Page – page load/site speed issue
- Order by meta_key in custom post type doesn’t affect the query
- How to count data records in wordpress which have same meta_value in wp_postmeta table?
- How to create/modfiy WP_Query to search in post title OR custom field?
- Using WP Query to search within ALL keys in meta query
- Order By Multiple Meta Fields
- WP_Query Performance Issues with meta_query
- WP Query – Get WooCommerce Products with variation that is in stock
- Meta_query with or without value
- meta_key and meta_value not working together
- Query wp_usermeta alongside wp_users
- Use meta_query to display events by date in custom field
- Advanced WP Query hogs the SQL server
- Order posts by meta value and Date
- Query sticky posts with thumbnails
- Order WP Query posts by custom order calculated from post meta values
- Meta-value query
- How to get user_id from wordpress database inside ajax function?
- how to speed up a complex wp_query?
- Too many posts cause slow load when paginating
- Meta query field order together with post_date order causes posts without the meta field to be unordered
- Meta query with order by another custom field
- How to query for custom field within Gutenberg block from outside of that post? [closed]