Where is this query?

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

Related Posts:

  1. Nested meta_query with multiple relation keys
  2. numberposts? showposts? posts_per_page?
  3. How can I save an array from a random post sequence for later use?
  4. All-in-One Event Calendar: Custom Query – Getting each event Instance [closed]
  5. Is there an action/filter called when WP_Query->query is finished and assigns posts
  6. Limit search results to exact match
  7. Highlighting Sub topic in a post?
  8. Pagination Not working on Home Page with 2 Query
  9. Multiple keyword search
  10. Get number of comments after modifying comment query
  11. Show default content if custom WP_Query has no posts
  12. Include Sticky Posts with Custom Query
  13. $wpdb->insert inserting two rows in database
  14. Create unique page without header.php for json feed
  15. Sub-loop / nested loops Best Practices
  16. How to loop for every result found in the_content() when using the search query?
  17. Is there any advantage of using default WordPress Search instead of creating a custom one?
  18. Order By table field comment_status in WordPress > 4.0
  19. Clean up WordPress code that repeats
  20. How to optimize multiple WP_Query() calls on one page?
  21. Use post object from first query in second query
  22. Query to get siblings and parent page
  23. How to list custom fields as headers and list all pages sharing that custom field under it?
  24. Cutom wp_query for geolocation search, pagination not working
  25. Include data from custom table in WP_Query
  26. echo a specific meta_key queried through a custom post
  27. WP Group posts by year(desc) > month(desc) > date(asc)
  28. How to order posts on each different category?
  29. Get specific ACF key and value from all posts – no access to DB
  30. Orderby two meta fields not working
  31. Custom wp_query – I’m getting ‘all’ post, not the specific post in the query
  32. meta_query with array as value with multiple arrays
  33. Adding pagination to sub-wp_query within a singular post page
  34. Magazine style frontpage with multiple categories/loops and no duplicate posts
  35. How to make a query returning pages from multiple parents
  36. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  37. How to use wp query in my custom page without including header and footer in wordpress
  38. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  39. WP Query for all events prior to current date
  40. How to extend WP_query to a specific table?
  41. Display the search results like the original pages
  42. Multi line of $wpdb->query just run 1 time and end the loop right after
  43. Add to search posts query array with post IDS which will appear first
  44. Woocomerce – Order products by float attribute in archive pages
  45. Multiple values in WP_Query : category__and
  46. How to set up pagination for a custom loop on a global template (author.php, tag.php, archive.php?)
  47. Custom query using WP_Query is not working
  48. Limit the number of posts from a specific category on index.php
  49. Get the type of an advanced custom field (ACF) in a WP_Query loop [closed]
  50. Switched from query_posts to wp_query, pagination no longer working
  51. WP_Query breaks pagination
  52. Pagination problem with multiple loops on the same page
  53. shortcode with $atts with strange results
  54. I need to get all categories from a WP_Query
  55. $wp_query->found_posts; returns zero
  56. Rewrite URL custom search query
  57. How could i add username field in WooCommerce
  58. Posts with at least 3 tags of a list of tags
  59. Get post count of current loop when using multiple queries on one page
  60. Use WP_Query with a custom SQL query
  61. How to query for a week using key => value WP_Query argument notation?
  62. Pagination not working for Custom search form & custom result template
  63. How to use filter hook posts_join for querying taxonomy terms in posts_where?
  64. List taxonomy terms plus their latest post ordered by post date
  65. WordPress altering my custom query, How to fix it?
  66. Looping through tabular data
  67. Using next/previous_posts_link with customised search
  68. How to create/modfiy WP_Query to search in post title OR custom field?
  69. Display featured products through custom loop in WooCommerce 3 [closed]
  70. How to detect custom query inside `posts_where` hook?
  71. Is temporarily overwriting $wp_query a bad idea?
  72. Array Chunks and Inserting Varying HTML in WP_Query
  73. Filter user list that meta_value is empty
  74. Query wp_usermeta alongside wp_users
  75. How to output different posts per page?
  76. Multiple WP_Query loops with Pagination Not Working
  77. Modifying the Search Results
  78. WP_Query times out
  79. ACF – Get lowest & highest value from field
  80. What format does the meta_query TIME type require?
  81. Offset Page Loops and Pagination
  82. How to find a post id using the post_excerpt?
  83. wp_query add arguments using array_push if variable met
  84. tax_query: Order by slug?
  85. WP_Query date_query – Use unix timestamp?
  86. Comparing dates in custom field
  87. reducing the amount of wp_query calls
  88. WP_Query filter and order by meta ordering by wrong joined table
  89. WP_Query last five posts, simply ordered by meta_value
  90. WP_Query “OR”: Find posts by ID, Name or Post Title?
  91. Querying A Post That Includes Two Taxonomies Using JSON Rest API
  92. WP_Query condition affects posts_per_page count
  93. Order by title without taking into account ‘the’
  94. Set global $wp_query/$post variable for dynamic page generation
  95. Display tags with random thumbnail from selection of posts with that tag
  96. slow WP_Query for non-admin user
  97. Changing sort order for presentation by Jetpack infinite scroll
  98. How to search for posts given post_content AND post_excerpt using WP_Query?
  99. meta_value_num not ordering all items
  100. Meta Queries – should nesting work after WP 4.1?