SQL Calls

I check the sql logs and we’re getting a massive amount of traffic from fairly identical querys coming from Woocommerce. Those 3 queries run hundreds of time every second.

Each query takes around 0.08 seconds. But @ 250/sec this is possibly adding 20 seconds to the load time

FW:

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘product_brand’) AND t.slug IN (‘becton-dickinson’)
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘product_brand’) AND t.term_id IN ( 251 )
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (254)) AND wp_posts.post_type = ‘product’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC

Could you please help us in this.