Woocommerce slow query
-
Hi, my on my store I’m using Query Monitor and on product pages it shows over 100 slow queries. And because of that my load time are over 30 seconds or more. I asked my hosting provider (A2 Hosting) about it and they confirmed that there is no problem on their side and this may be plugin problem. The queries that are slow looks like this:
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN (‘product_shipping_class’)
AND tr.object_id IN (878)
ORDER BY t.name ASCand
SELECT DISTINCT t.*, tt.*, tm.meta_value
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id
LEFT JOIN wp_termmeta AS tm
ON (t.term_id = tm.term_id
AND tm.meta_key = ‘order’)
WHERE tt.taxonomy IN (‘product_cat’)
AND tr.object_id IN (828)
ORDER BY tm.meta_value+0 ASC, t.name ASCand both are called by:
WP_Term_Query->get_terms()
wp-includes/class-wp-term-query.php:695I’m adding some images maybe it helps:
https://prntscr.com/fnxujj
https://prntscr.com/fnxuv0
https://prntscr.com/fnxvne
https://prntscr.com/fnxvxc
https://prntscr.com/fnxz57
https://prntscr.com/fnxzbdWordpress version: 4.8
Woocommerce version: 3.0.9
Active plugins: 19
Products: 55
PHP version: 7.0
Server cores: 2 x 2.1Ghz
RAM: 1 GB
Theme: FlatsomeMaybe anyone had similar problem and know any possible solution to fix it. This is the first time when I ask something so if anyone needs any more information I will try to provide it.
- The topic ‘Woocommerce slow query’ is closed to new replies.