Using Query Monitor I was able to find the source of this query, it was from a plugin “starbox” which uses the query to fetch the last 3 posts from the author of a given post. Editing the plugin by commenting out the part it runs this query solved the issue.
Related Posts:
- Slow SQL_CALC_FOUND_ROWS Query
- Improve wp query perfomance on large db
- Which is faster wpdb & get_row or wp_query & ge_post_meta?
- Return only Count from a wp_query request?
- Use REGEXP in WP_Query meta_query key
- Order by DESC, ASC in custom WP_Query
- How to prevent execution of default query, while preserving ability to use WP_Query in template?
- Differences Between WP_Query() and get_posts() for Querying Posts?
- What is the most efficient way of querying posts based on visits and date for current day?
- Is it true $wpdb->get_results is faster than WP_Query in most cases?
- Get posts by menu ID
- get_the_title($postID) OR get_the_title()?
- SQL query equivalent to WP User Query
- What’s wrong with this WP query?
- How to count post meta key values for all posts in database
- Group posts by meta_key
- How to search for posts IN OR title OR content OR author?
- WP_Query hit max joins… How else can I build a search function that uses custom fields?
- Would this post meta be better added to the post table rather than post_meta table
- 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 Multiple Meta Fields
- meta_query on a date range using an array of values
- WP_Query Performance Issues with meta_query
- How to speed up wp_query, took more 5s to run against 100k posts
- SQL User Query by Multiple Roles using PHP
- WordPress Query is taking more then 20 second and stuck on creating index
- Too many posts cause slow load when paginating
- Get the Plugin Which Triggered a MySql Query in WordPress?
- Mysql query LIKE not working
- Using WP_Query and WP_Meta_Query Outside of WordPress
- WP_Query times out
- Looking for most performant way to execute several similar WP queries within shortcodes
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- Order by custom table and multiplication
- Single meta_query query using OR instead of AND in request’s WHERE statement
- reducing the amount of wp_query calls
- why update and delete query not worked in custom table?
- How to use MySQL’s MATCH AGAINST in WP_Query?
- Slow WP_Query for custom post type
- Performance when getting post meta for post retrieved by meta value
- Hide Administrators From User List except current user (administrator)
- Add “Category” to Mysql Query
- Mysql query and order meta value
- Help with WP_Query – Too many mySQL queries
- Using hook to use DISTINCT in a wp_query
- Fastest way of counting posts of a custom post type in a specific taxonomy term?
- Use more than one query, but prevent duplicates – at scale!
- pagination with ‘no_found_rows’ => true,
- Is it a good idea to improve meta query performance by adding tax query?
- Slow page loads due to WordPress Core Query
- Order by summing multiple values
- Display tags with random thumbnail from selection of posts with that tag
- Should wp_query automatic meta and term cache priming be used in an enviroment with an object caching
- Loop Performance > JSON files vs. WP_Query vs. REST API
- Wp query show post by author name or post title or post content
- How to increase load time of an archive/search page (WP_Query)
- Query most popular terms by taxonomy over 2 week period
- use of 10 new WP_Query : loading too slow (with url) [closed]
- how update data through ajax and jquery
- Meta Query doesn’t works as espected
- What is the best way (regarding performance) to set transients for logged in users?
- How I can change the condition or compare operator for WP_Query in pre_get_posts
- Update query for wp_posts and wp_postmeta
- mysql query order by
- WP_Query with page_ids in arguments without a result
- How to avoid filling up an array each time I run a WP_query?
- Query multiple meta key values for template
- Performance concerns: index.php vs taxonomy-$taxonomy.php
- Which is from this queries is more faster
- SQL query injection with fifu image
- Why last row deleted when refresh page
- WP Query – grouping posts by same meta key, adding together values from another key
- Woocommerce Get Orders By Meta Value
- SQL to join u3g_users & u3g_meta_value with repeating data
- INNER JOIN custom tables – SQL Query
- use mysql variable in a $wpdb->query to reindex a column?
- One of two similar WP Query is very slow
- Fix wp_term_relationships slow query in get_posts
- Unusual high query of user meta data
- WordPress Query optimaization for slow query
- update_post_meta performance in a loop woocommerce
- Sorting query_posts() with a complex orderby filter
- Case insensitive ORDERBY in wpquery
- WP_Term_Query->get_terms() very slow query for WordPress filter
- Query postmeta based on meta_value, return array of post_id
- Multiple wpostmeta.meta_key
- Showing the correct number of posts_per_page when avoiding the use of post__not_in
- Slow query when selecting with large meta query or post__in
- Website goes slow down after importing long database
- Optimising amount of calls to custom fields
- Get a list of the last posts grouped by author and filtered by category
- How to count post meta key values for all posts in database
- Post OrderBy slow performance
- Different sql queries count indicator on the main page [closed]
- Parsing External Table Arguments
- How to add a custom field and incrementing value for all the published posts
- WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
- SQL query into to WP query
- Bulk delete comments, foreach loop