This is the query generated by the internal search function on WordPress.
It is criticised for being inefficient, and there are a few drop-in replacements available as plugins. You may be able to find something that helps you by doing more research around these. For example:
https://themeisle.com/blog/improve-internal-search-in-wordpress/
https://winningwp.com/best-wordpress-search-plugins/
I don’t have a specific recommendation to offer as I’m just digging into this myself, hence having to link elsewhere.
Related Posts:
- What is an efficient way to query based on post_meta?
- Filter WordPress posts by between parameter
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- Editing the default wordpress search
- Is it possible to query from external database? [duplicate]
- Include post content of linked posts in search
- List of ways to access WordPress database?
- How to extend WP_query to a specific table?
- Translating WP query into to SQL query
- Include post_status check within $wpdb query
- WP_Query with “post_title LIKE ‘something%'”?
- Can I force WP_Query to return no results?
- Post_count only shows the number of results per page
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Pagination with custom SQL query
- WP Query where title begins with a specific letter
- Whats the difference between post_limits and pre_get_posts?
- Search custom taxonomy term by name
- Using OR conditions in meta_query for query_posts argument
- Should I use Transients with W3 Total Cache APC Caching? [closed]
- Add indexing to meta_value in wp_postmeta
- Is it possible to wrap Geo Location search around WP_Query?
- Order Search Results Page by meta_value If no Value Return Remaining Results
- Getting wrong relationship value in $args in wp_Query?
- Get posts by menu ID
- Is it possible to select against a post’s parent’s fields with WP_Query?
- Tracing the life of a query
- Want to redirect if search query match exact title of any post
- Slow SQL_CALC_FOUND_ROWS Query
- Extending WP_Query — Optimise SQL query
- How to filter sql only for a specific post type
- How to make an activities stream mixing posts and comments?
- Pagination not working for Custom search form & custom result template
- How to support multiple search terms query within one process?
- SQL Statement generated by WP_Query not producing expected results
- Pagination broken when merging search results with additional WP_Query
- SQL query equivalent to WP User Query
- Custom search form with empty parameters
- How to search by title or tags exclusively?
- WordPress search exact match
- Pagination wont work with search results template [duplicate]
- Recommended way to drop a pending query (in pre_get_posts)?
- How do I search WordPress by different fields without a plugin?
- Multiple keyword search
- how to retrieve specific product attribute value in an sql query?
- Using next/previous_posts_link with customised search
- WordPress custom search form with pre_get_posts not work
- Search – Ajax – Alter Query Parameters with Pagination
- Add custom search results to main WP search [duplicate]
- WP_Query Performance Issues with meta_query
- Block search SQL from happening
- Multiple search queries on one page
- Should close $wpdb via $wpdb->close()
- tax_query shows no results if nothing is selected
- Get the post permalink within the loop but without additional DB query
- SQL User Query by Multiple Roles using PHP
- Advanced WP Query hogs the SQL server
- Retrieve featured image (thumbnail) url from multiple posts with one query
- SELECT * FROM $wpdb->posts WHERE ID > 160
- Searching through different categories on different pages code is not working
- WP Query search for attachments and their exact title
- WP_Query’s “request” SQL Query
- Including only current user’s posts in search
- Query post with meta_query where date is not in future
- is_search was called incorrectly
- What’s faster? One big query, or several smaller ones?
- How do I search inside specific taxonomies in WordPress
- Modifying the Search Results
- WP User Query get all authors with last name starting with specific letter
- How WordPress attaches its Featured Images with posts?
- Custom category search box for WordPress
- Select from wp_post and multiple meta_value from wp_postmeta
- Refine search results using WP_Query
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- Order by custom table and multiplication
- Search Posts with Custom Fields as query
- How to correctly pass values to wpdb->prepare()?
- Complex date range with WP_Query and BETWEEN
- Creating a custom search for a specific post type
- Sort users by “birthday” using WP_User_Query
- $wpdb select date range of posts
- Custom Search Result Page displaying only 1 result.
- How To Fix WP Query Returns Results But Shouldn’t?
- why update and delete query not worked in custom table?
- How to loop for every result found in the_content() when using the search query?
- List of the years with posts presented
- Assigning a meta_query value based on regexp to wp_query fails
- showing all search result in one template
- Querying on multiple taxonomies pulled from $_GET checkbox array not working?
- Is there any advantage of using default WordPress Search instead of creating a custom one?
- SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
- Slow WP_Query for custom post type
- WP_Query Not Recognizing Taxonomy Parameter in Custom Search
- Search pages that are a child of the current page
- Include tags in WP_Query
- Search for multiple tags?
- Complex WP SQL Query
- Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
- Custom Search Not Consistent with Results
- Optional Meta Query