SQL_CALC_FOUND_ROWS

• (MySQL)SQL_CALC_FOUND_ROWSを使う - 優柔不断なプログラマの日記

# Time: 120211 10:31:33
# User@Host: wordpress[wordpress] @ localhost []
# Query_time: 350.542989  Lock_time: 0.000108 Rows_sent: 20  Rows_examined: 46307
SET timestamp=1328923893;
SELECT SQL_CALC_FOUND_ROWS  wp_infrapp_posts.* FROM wp_infrapp_posts  WHERE 1=1  AND wp_infrapp_posts.post_type = 'post' AND (wp_infrapp_posts.post_status = 'publish' OR wp_infrapp_posts.post_status = 'future' OR wp_infrapp_posts.post_status = 'draft' OR wp_infrapp_posts.post_status = 'pending' OR wp_infrapp_posts.post_status = 'private')  ORDER BY wp_infrapp_posts.post_date DESC LIMIT 0, 20;