Slow Query SQL_CALC_FOUND_ROWS

Hello,
in my site, i have query monitor which show slow query error in this query

SELECT SQL_CALC_FOUND_ROWS bzb_posts.ID
FROM bzb_posts
WHERE 1=1
AND bzb_posts.post_type = ‘shop_order’
AND ((bzb_posts.post_status = ‘wc-pending’
OR bzb_posts.post_status = ‘wc-processing’
OR bzb_posts.post_status = ‘wc-on-hold’
OR bzb_posts.post_status = ‘wc-completed’
OR bzb_posts.post_status = ‘wc-cancelled’
OR bzb_posts.post_status = ‘wc-refunded’
OR bzb_posts.post_status = ‘wc-failed’
OR bzb_posts.post_status = ‘wc-shipped’
OR bzb_posts.post_status = ‘wc-pre-ordered’))
ORDER BY bzb_posts.post_date DESC
LIMIT 0, 20`

caller

WP_Query->get_posts
WP_Query->query
WP->query_posts
WP->main
wp
wp_edit_posts_query
WP_Posts_List_Table->prepare_items

• This topic was modified 4 years, 8 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic