Please I have a very slow query on my wordpress search, checking the processes it takes upto 40sec to execute using
SHOW FULL PROCESSLIST; below is a sample of query
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%Industreet%') OR (wp_posts.post_excerpt LIKE '%Industreet%') OR (wp_posts.post_content LIKE '%Industreet%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_title LIKE '%Industreet%' DESC, wp_posts.post_date DESC LIMIT 0, 25
I have tried my best to fix this, but nothing is working out. though I have a total post of 120k on my site. I really need help.
Thanks in advance