Hi Tom,
After disabling the plugin the queries seemed to disappear, so we’re fairly sure these queries are coming from wpshowposts.
Any ideas on how we can reduce this mySQL usage? I’m also a bit confused as to what this query is doing, since it seems to be referencing all of the POST IDs exclusive to WP Show Posts.