[NSFW] The plugin creates queries that slow down wp

  • Resolved chingiz35

    (@chingiz35)


    2 years, 7 months ago

    Hello! I use your woocommerce plugin together with the woodmart theme. I have a fairly large database, but before the last update, the admin panel worked quickly, now it works very slowly, I looked at slow queries with the help of the Query Monitor plugin and found queries for several seconds. From this, it became impossible to work with the admin panel. Please tell me how you can solve this problem

    Here is one of 5 such requests, which takes almost 5 seconds:

    SELECT mt_posts.ID
FROM mt_posts
LEFT JOIN mt_term_relationships
ON (mt_posts.ID = mt_term_relationships.object_id)
INNER JOIN mt_postmeta
ON ( mt_posts.ID = mt_postmeta.post_id )
WHERE 1=1
AND ( mt_term_relationships.term_taxonomy_id IN (2,3,4,5) )
AND ( ( mt_postmeta.meta_key = '_virtual'
AND mt_postmeta.meta_value = 'no' ) )
AND mt_posts.post_type = 'product'
AND ((mt_posts.post_status = 'publish'
OR mt_posts.post_status = 'draft'
OR mt_posts.post_status = 'pending'
OR mt_posts.post_status = 'private'))
GROUP BY mt_posts.ID
ORDER BY mt_posts.post_date DESC
LIMIT 0, 1
    • This topic was modified 2 years, 7 months ago by chingiz35.
Viewing 3 replies - 1 through 3 (of 3 total)

  • Hey @chingiz35

    I understand that your admin panel has become slow after updating your WooCommerce.

    This kind of problem is usually caused by a conflict with your theme or with another plugin.
    ?
    The best way to determine this is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

    If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    You can test this out on a staging site using a plugin like WP Staging, without affecting the appearance of the front end.

    Thanks!

    Thread Starter chingiz35

    (@chingiz35)

    Thanks for the answer, I will try

    @chingiz35 Sounds good. Please feel to share your findings here once done.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[NSFW] The plugin creates queries that slow down wp’ is closed to new replies.