Здравствуйте, у меня та же самая проблема, тормозит вот этот запрос в woocommerce:
SELECT wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2
ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1
AND wp_posts.post_parent = 0
AND ( ( wp_postmeta.meta_key = '_visibility'
AND wp_postmeta.meta_value IN ('visible','catalog') )
AND ( mt1.meta_key = '_price'
AND CAST(mt1.meta_value AS DECIMAL) > '0' )
AND ( mt2.meta_key = '_stock_status'
AND mt2.meta_value = 'instock' ) )
AND wp_posts.post_type = 'product'
AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY RAND()
LIMIT 0, 5
Подскажите где и как его уменьшить?