We are getting crushed this morning with some unusual queries based on post date that seem to be taking a long time:
# Time: 101018 13:04:15
# Query_time: 40 Lock_time: 0 Rows_sent: 1 Rows_examined: 15792
SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2006-09-12 00:00:00' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1;
Does anyone know what might be searching for a range of dates without an upper limit?