• 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 ASC

    and

    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 ASC

    and both are called by:
    WP_Term_Query->get_terms()
    wp-includes/class-wp-term-query.php:695

    I’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/fnxzbd

    Wordpress 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: Flatsome

    Maybe 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.

Viewing 1 replies (of 1 total)
  • Too many plugins to think that they are really all useful.

    Not enough RAM on the server.

    Is you shop still slow with Storefront theme ?

Viewing 1 replies (of 1 total)
  • The topic ‘Woocommerce slow query’ is closed to new replies.