Take more time to execute the wp_query.
-
I have the following queries generated by wordpress.
SELECT geni596_posts.* FROM geni596_posts
INNER JOIN geni596_term_relationships ON (geni596_posts.ID = geni596_term_relationships.object_id)
INNER JOIN geni596_term_relationships AS tt1 ON (geni596_posts.ID = tt1.object_id)
INNER JOIN geni596_postmeta ON ( geni596_posts.ID = geni596_postmeta.post_id )
INNER JOIN geni596_postmeta AS mt1 ON ( geni596_posts.ID = mt1.post_id )
INNER JOIN geni596_postmeta AS mt2 ON ( geni596_posts.ID = mt2.post_id )
INNER JOIN geni596_postmeta AS mt3 ON ( geni596_posts.ID = mt3.post_id )
INNER JOIN geni596_postmeta AS mt4 ON ( geni596_posts.ID = mt4.post_id )
INNER JOIN geni596_postmeta AS mt5 ON ( geni596_posts.ID = mt5.post_id )
INNER JOIN geni596_postmeta AS mt6 ON ( geni596_posts.ID = mt6.post_id )
WHERE 1=1 AND ( geni596_term_relationships.term_taxonomy_id IN (39,45) AND tt1.term_taxonomy_id IN (31,38,39,40,45) ) AND geni596_posts.post_type = ‘product’ AND (geni596_posts.post_status = ‘publish’) AND ( geni596_postmeta.meta_key = ‘height’ AND ( ( ( ( mt1.meta_key = ‘height’ AND CAST(mt1.meta_value AS DECIMAL(10,3)) >= ‘7’ ) AND ( mt2.meta_key = ‘height’ AND CAST(mt2.meta_value AS DECIMAL(10,3)) <= ’12’ ) ) OR ( ( mt3.meta_key = ‘height’ AND CAST(mt3.meta_value AS DECIMAL(10,3)) >= ’12’ ) AND ( mt4.meta_key = ‘height’ AND CAST(mt4.meta_value AS DECIMAL(10,3)) <= ’17’ ) ) OR ( ( mt5.meta_key = ‘height’ AND CAST(mt5.meta_value AS DECIMAL(10,3)) >= ’17’ ) AND ( mt6.meta_key = ‘height’ AND CAST(mt6.meta_value AS DECIMAL(10,3)) <= ’22’ ) ) ) ) ) GROUP BY geni596_posts.ID ORDER BY geni596_postmeta.meta_value+0 ASCThe above query take more time to execute may be 1min or more than 1min sometime it hangs. Is there any solution for optimize this query.
- The topic ‘Take more time to execute the wp_query.’ is closed to new replies.