I have a very slow query in woocommerce.
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (116263,116253,116237,116197,116187,116177,116167,116157,116147,116137,116127,116117,116107,116097,116087,116079,116071,116063,116055,116047,116039,116031,116023,116015,116007,115999,115991,115983,115975,115967,115959,115951,115943,115935,115927,115919,115911,115903,115893,115883,115873,115863,115853,115843,115833,115825,115815,*****)
total rows 513394
component Plugin: woocommerce
Caller
- do_action('wp_loaded')
- wp-includes/plugin.php:453
- WC_Cart_Session->get_cart_from_session()
- wp-content/plugins/woocommerce/includes/class-wc-cart-session.php:95
- WC_Product->is_purchasable()
- wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-product.php:1458
- WC_Product->get_price()
- wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-product.php:275
- WC_Data->get_prop()
- wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-data.php:694 apply_filters('woocommerce_product_get_price')
time 1.0919
Is there a way to reduce query time?