Support » Plugin: WooCommerce » Every product being queried by WP_Term_Query->get_terms() on every page load

  • Resolved natlia

    (@natlia)


    Hello,
    My site really getting slowed with slow queries. I check via Query Monitor and my product page has about 1300 queries. I have about 370 products, PHP 7.1, CDN, VPS host, all images compressed, WP Rocket.
    Every product being queried by WP_Term_Query->get_terms() on every page load

    WP_Term_Query->get_terms() has 684 queries

    WHERE tt.taxonomy IN pa_select – 54 Queries

    WHERE tt.taxonomy IN (‘product_shipping_class’) – 166 Queries

    WHERE tt.taxonomy IN (‘product_visibility’) – 160 Queries

    WHERE tt.taxonomy IN (‘product_cat’) – 164 Queries

    WHERE tt.taxonomy IN (‘product_tag’) – 159 Queries

    Any advice, please?
    Thank you!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there!

    I took a look at a single product page on my own test site with Query Monitor and I’m seeing 48 total queries:
    http://cld.wthms.co/HfXmQI

    This kind of problem is usually caused by another plugin, or a conflict with your theme and another plugin.

    The best way to determine if the issue is being caused by a theme and/or plugin is to temporarily switch your theme to Storefront and disable all plugins except for WooCommerce.

    If that resolves the issue, then one-by-one you can switch back your theme and re-enable your plugins, testing in between, until you find the one causing the conflict.

    Plugin Support dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hi @natlia

    We haven’t heard back from you in a while, did you get to the bottom of this? You can see where the queries are coming from and dig into it that way.

    I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thanks,

    I have the same issue even though I don’t have any products in my front page I get 200+ queries. Do you have a solution on this?

    Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    @fylpa – please do create your own thread so we can best help you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Every product being queried by WP_Term_Query->get_terms() on every page load’ is closed to new replies.