[NSFW] The plugin creates queries that slow down wp
-
Hello! I use your woocommerce plugin together with the woodmart theme. I have a fairly large database, but before the last update, the admin panel worked quickly, now it works very slowly, I looked at slow queries with the help of the Query Monitor plugin and found queries for several seconds. From this, it became impossible to work with the admin panel. Please tell me how you can solve this problem
Here is one of 5 such requests, which takes almost 5 seconds:
SELECT mt_posts.ID FROM mt_posts LEFT JOIN mt_term_relationships ON (mt_posts.ID = mt_term_relationships.object_id) INNER JOIN mt_postmeta ON ( mt_posts.ID = mt_postmeta.post_id ) WHERE 1=1 AND ( mt_term_relationships.term_taxonomy_id IN (2,3,4,5) ) AND ( ( mt_postmeta.meta_key = '_virtual' AND mt_postmeta.meta_value = 'no' ) ) AND mt_posts.post_type = 'product' AND ((mt_posts.post_status = 'publish' OR mt_posts.post_status = 'draft' OR mt_posts.post_status = 'pending' OR mt_posts.post_status = 'private')) GROUP BY mt_posts.ID ORDER BY mt_posts.post_date DESC LIMIT 0, 1
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
- The topic ‘[NSFW] The plugin creates queries that slow down wp’ is closed to new replies.