SQL queries that crash my server

Good afternoon and thank you very much for this excellent plugin.
It is very useful, but we are noticing that every certain hour, every day, our database alerts an extreme use of cpu and sometimes crashes.
When I entered the time that start the problems in our store, I noticed that many of these sql querys are fired.

Example:

	
SELECT SQL_CALC_FOUND_ROWS wp6r_posts.ID FROM wp6r_posts LEFT JOIN wp6r_postmeta ON ( wp6r_posts.ID = wp6r_postmeta.post_id ) LEFT JOIN wp6r_postmeta AS mt1 ON ( wp6r_posts.ID = mt1.post_id ) LEFT JOIN wp6r_postmeta AS mt2 ON ( wp6r_posts.ID = mt2.post_id AND mt2.meta_key = '_thumbnail_id' ) LEFT JOIN wp6r_postmeta AS mt3 ON ( wp6r_posts.ID = mt3.post_id ) WHERE 1=1 AND ( wp6r_posts.ID NOT IN ( SELECT object_id FROM wp6r_term_relationships WHERE term_taxonomy_id IN (83) ) ) AND ( wp6r_postmeta.meta_key = 'total_sales' AND ( ( mt1.meta_key = '_thumbnail_id' OR mt2.post_id IS NULL ) AND ( ( mt3.meta_key = '_stock_status' AND mt3.meta_value = 'instock' ) OR ( mt3.meta_key = '_stock_status' AND mt3.meta_value = 'outofstock' ) ) ) ) AND ((wp6r_posts.post_type = 'product' AND (wp6r_posts.post_status = 'publish' OR wp6r_posts.post_status = 'acf-disabled' OR wp6r_posts.post_status = 'cwg_mailsent' OR wp6r_posts.post_status = 'cwg_mailnotsent' OR wp6r_posts.post_status = 'cwg_subscribed' OR wp6r_posts.post_status = 'cwg_unsubscribed' OR wp6r_posts.post_status = 'cwg_converted'))) GROUP BY wp6r_posts.ID ORDER BY wp6r_posts.menu_order ASC, wp6r_postmeta.meta_value+0 DESC, wp6r_posts.post_date DESC LIMIT 252, 12

They are several similar sql queries (+10 or more) and change in the last lines but all querying cwg_ plugin tables, for 10 or 20 minutes. It causes a trigger in the bandwidth as well. I wanted to know how we can do so that this does not happen and does not leave us without service the store.

Our store has 500 products

Thanks in advance

The page I need help with: [log in to see the link]