Thread: Slow Mysql . Where to optimize classipress?

# Query_time: 30.707308  Lock_time: 0.000260 Rows_sent: 10  Rows_examined: 6401658
SET timestamp=1436509465;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships AS r ON (wp_posts.ID = r.object_id)  LEFT JOIN wp_term_taxonomy AS x ON (r.term_taxonomy_id = x.term_taxonomy_id)  AND (x.taxonomy = 'ad_tag' OR x.taxonomy = 'ad_cat' OR 1=1)  INNER JOIN wp_postmeta AS m ON (wp_posts.ID = m.post_id)  LEFT JOIN wp_terms AS t ON x.term_id = t.term_id  WHERE 1=1  AND (((wp_posts.post_title LIKE '%Boccia%') OR (wp_posts.post_content LIKE '%Boccia%') OR ((t.name LIKE '%Boccia%')) OR ((t.slug LIKE '%Boccia%')) OR ((m.meta_key = 'cp_price') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_street') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_city') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_state') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_country') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_zipcode') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_region') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_size') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_feedback') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_currency') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_enable_bid') AND (m.meta_value LIKE '%Boccia%')) OR ((m.meta_key = 'cp_sys_ad_conf_id') AND (m.meta_value LIKE '%Boccia%'))) AND ((wp_posts.post_title LIKE '%horloge%') OR (wp_posts.post_content LIKE '%horloge%') OR ((t.name LIKE '%horloge%')) OR ((t.slug LIKE '%horloge%')) OR ((m.meta_key = 'cp_price') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_street') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_city') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_state') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_country') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_zipcode') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_region') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_size') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_feedback') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_currency') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_enable_bid') AND (m.meta_value LIKE '%horloge%')) OR ((m.meta_key = 'cp_sys_ad_conf_id') AND (m.meta_value LIKE '%horloge%'))) OR (wp_posts.post_title LIKE '%Boccia horloge%') OR (wp_posts.post_content LIKE '%Boccia horloge%')) AND (wp_posts.post_status = 'publish')  AND (wp_posts.post_type IN ('ad_listing'))  GROUP BY wp_posts.ID ORDER BY (CASE WHEN wp_posts.post_title LIKE '%Boccia horloge%' THEN 1 WHEN wp_posts.post_title LIKE '%Boccia%' AND wp_posts.post_title LIKE '%horloge%' THEN 2 WHEN wp_posts.post_title LIKE '%Boccia%' OR wp_posts.post_title LIKE '%horloge%' THEN 3 WHEN wp_posts.post_content LIKE '%Boccia horloge%' THEN 4 ELSE 5 END), wp_posts.post_date DESC LIMIT 0, 10;