I'm runing this plugin on my own server and, this query is causing resource problems on my machine. is there any more current version of the plugin or some way to reduce resource utilization?
Query:
SELECT SQL_CALC_FOUND_ROWS ztqa_posts.ID FROM ztqa_posts LEFT JOIN ztqa_postmeta ON ( ztqa_posts.ID = ztqa_postmeta.post_id ) LEFT JOIN ztqa_postmeta AS mt1 ON (ztqa_posts.ID = mt1.post_id AND mt1.meta_key = '_pos' ) WHERE 1=1 AND ( ( ztqa_postmeta.meta_key = '_pos' AND ztqa_postmeta.meta_value = '0' ) OR mt1.post_id IS NULL ) AND ztqa_posts.post_type = 'shop_order' AND ((ztqa_posts.post_status = 'wc-pending' OR ztqa_posts.post_status = 'wc-processing' OR ztqa_posts.post_status = 'wc-on-hold' OR ztqa_posts.post_status = 'wc-completed' OR ztqa_posts.post_status = 'wc-cancelled' OR ztqa_posts.post_status = 'wc-refunded' OR ztqa_posts.post_status = 'wc-failed')) GROUP BY ztqa_posts.ID ORDER BY ztqa_posts.post_date DESC LIMIT 0, 20
Hello,
I'm runing this plugin on my own server and, this query is causing resource problems on my machine. is there any more current version of the plugin or some way to reduce resource utilization?
Query:
SELECT SQL_CALC_FOUND_ROWS ztqa_posts.ID FROM ztqa_posts LEFT JOIN ztqa_postmeta ON ( ztqa_posts.ID = ztqa_postmeta.post_id ) LEFT JOIN ztqa_postmeta AS mt1 ON (ztqa_posts.ID = mt1.post_id AND mt1.meta_key = '_pos' ) WHERE 1=1 AND ( ( ztqa_postmeta.meta_key = '_pos' AND ztqa_postmeta.meta_value = '0' ) OR mt1.post_id IS NULL ) AND ztqa_posts.post_type = 'shop_order' AND ((ztqa_posts.post_status = 'wc-pending' OR ztqa_posts.post_status = 'wc-processing' OR ztqa_posts.post_status = 'wc-on-hold' OR ztqa_posts.post_status = 'wc-completed' OR ztqa_posts.post_status = 'wc-cancelled' OR ztqa_posts.post_status = 'wc-refunded' OR ztqa_posts.post_status = 'wc-failed')) GROUP BY ztqa_posts.ID ORDER BY ztqa_posts.post_date DESC LIMIT 0, 20
Regards, DS