Slow Query
| Slow Database Queries (above 0.05s) | ||||
|---|---|---|---|---|
| Query | Caller | Component | Affected Rows | Time |
| 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
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