Support Center Visit Demo License manager Buy @ envato

Slow Query

FuturzFuturz
in WooCommerce
get_posts()" data-qm-time="0.0623059272766">
Slow Database Queries (above 0.05s)
QueryCallerComponentAffected RowsTime
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (65) )
AND ( ( wp_postmeta.meta_key = '_visibility'
AND CAST(wp_postmeta.meta_value AS CHAR) IN ('visible','catalog') ) )
AND wp_posts.post_type = 'product'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'wc-cancel-request'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC
LIMIT 0, 16

Comments

  • FuturzFuturz
    Slow Database Queries (above 0.05s)
    QueryCallerComponentAffected RowsTime
    SELECT t.*, tt.*, tm.*
    FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt
    ON t.term_id = tt.term_id
    LEFT JOIN wp_woocommerce_termmeta AS tm
    ON (t.term_id = tm.woocommerce_term_id
    AND tm.meta_key = 'order')
    WHERE
    tt.taxonomy IN ('category', 'post_tag', 'post_format', 'product_cat',
    'product_tag', 'product_shipping_class', 'pa_size-mojri',
    'pa_size-sherwani')
    ORDER BY tm.meta_value+0 ASC, t.name ASC
  • AlbertAlbert
    If queries are too slow in your opinion, you should send this request to WP developers and ask them why wp queries are so slow because theme does not have any impact on that queries.
    Learn more: Video Tutorials | How To | FAQ Vote on what comes next
Sign In or Register to comment.