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.