Need help with indexes on 2 slow wordpress query
Try Below Index :

CREATE INDEX IDX_CMB ON wp_posts(ID,post_type,post_date);

Basically, this index will used for indexing GROUP BY clause WHERE clause, create this index &amp; check explain plan &amp; execution time.