Where is this query?

Question

This query given below appears alot in my slow-query log. Can someone please tell me where can I find this query ? that will help me try to modify it

SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%true%') OR (wp_posts.post_content LIKE '%true%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment', 'slideshow') AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;

Answer 1

This looks like a query generated as part of the search facility within Wordpress. For example, a visitor has been to your site and typed the word 'true' into your search box.

If you have a large number of posts/pages/etc in your Wordpress installation, then the only way you could optimise this query is to use fulltext indexing. This would mean actually changing the functionality of the search facility within the Wordpress core. I'm not too hot on fulltext indexing within MySQL unfortunately, else I would be able to offer more help.

This might be a good starting point though: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html