Title: Slow Query SQL_CALC_FOUND_ROWS
Last modified: August 18, 2021

---

# Slow Query SQL_CALC_FOUND_ROWS

 *  [raniafathy651](https://wordpress.org/support/users/raniafathy651/)
 * (@raniafathy651)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/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, 10 months ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).
      Reason: Moved to Fixing WordPress, this is not an Everything else WordPress
      topic

Viewing 1 replies (of 1 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/slow-query-sql_calc_found_rows/#post-14791620)
 * That appears to be a query for WooCommerce orders. I suggest asking in the dedicated
   WooCommerce support forum for assistance. The expert users and devs there are
   in the best position to help you.
    [https://wordpress.org/support/plugin/woocommerce/](https://wordpress.org/support/plugin/woocommerce/)

Viewing 1 replies (of 1 total)

The topic ‘Slow Query SQL_CALC_FOUND_ROWS’ is closed to new replies.

## Tags

 * [slow query](https://wordpress.org/support/topic-tag/slow-query/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [4 years, 10 months ago](https://wordpress.org/support/topic/slow-query-sql_calc_found_rows/#post-14791620)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics