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
- Post_count only shows the number of results per page
- WP Query where title begins with a specific letter
- Whats the difference between post_limits and pre_get_posts?
- Order Search Results Page by meta_value If no Value Return Remaining Results
- Tracing the life of a query
- Pagination not working for Custom search form & custom result template
- Pagination broken when merging search results with additional WP_Query
- Multiple keyword search
- Using next/previous_posts_link with customised search
- Block search SQL from happening
- Get the post permalink within the loop but without additional DB query
- SELECT * FROM $wpdb->posts WHERE ID > 160
- WP Query search for attachments and their exact title
- Modifying the Search Results
- How WordPress attaches its Featured Images with posts?
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- Creating a custom search for a specific post type
- Custom Search Result Page displaying only 1 result.
- Is there any advantage of using default WordPress Search instead of creating a custom one?
- Search pages that are a child of the current page
- Include tags in WP_Query
- Search for multiple tags?
- Optional Meta Query
- How to use wp_query to post count by search term > group post count by date > convert to json. (ex. result 12-21-2020 – 343)
- Including metaboxes from custom post types in global search — continued
- Extend product search with meta in WooCommerce
- How to implement a new row_count method in WordPress?
- Woocommerce – Changing the order of the upsell products [closed]
- Query with search and subscribers only output
- Changing sort order for presentation by Jetpack infinite scroll
- Include data from custom table in WP_Query
- Modify Search Query if original Query gave no results
- Make a SQL query with wpdb in WordPress
- How do I amend wp_query before it is run/executed?
- Specify strict ‘order by’ in WordPress query
- How to set up hierarchical relationships without using plugins / meta query
- how to get Nearby zipcode
- Getting rid of unwanted nonSQL syntax characters when debugging a query
- Does WordPress have something like Drupal’s DB API?
- How to properly use AND / OR in custom search
- How to avoid bypass of search bar rules?
- Hide products in uncategorized category from search results
- How do you determine if a result in a search query is a post or a page?
- wp_query show all values
- Why having more than 10 clauses in WP_Query results in some outputs being dropped?
- WP Query – filtering terms with regex
- Function to retrieve IDs of posts, cache results, and improve wp_query
- Issue with data array format
- How to avoid filling up an array each time I run a WP_query?
- How to SQL query posts IDs by categories AND authors?
- Ignore image urls in wp_query search
- Search.php – return number of results but cannot loop through
- WordPress search WP_Query to cover multiple post types and their custom fields?
- SQL query injection with fifu image
- How to prevent WP_Query from filtering on ‘s’ but keep ‘s’ for other purposes?
- Add dynamic search to paginated WP_Query
- WP Query – grouping posts by same meta key, adding together values from another key
- Multiple WP_Query args combinations according to post type
- What is the equivalent WP_Query of a SQL Query?
- wp query search multi terms
- Display the search results like the original pages
- How to use jQuery validation to set the search bar to accept only a specific input?
- WP_Term_Query->get_terms() very slow query for WordPress filter
- Filtering posts for unique titles, only the most recent
- WordPress search page pagination displaying but not functional
- Slow wp_posts and wp_postmeta query using Advance Custom Fields
- How to search CPTs in draft using get_page_by_title()
- Limit default Search query to post_title
- Order & Orderby clause not working with custom query
- How can I modify standard search query to include also ACF custom fields values?
- Website goes slow down after importing long database
- WordPress WP_Query offset parameter not working with search parameter
- Need help setting up a search form for wordpress [duplicate]
- Custom WP_Query with SQL directives for getting posts by authors and terms
- orderby in WP_query doesn’t works
- Custom search: Search posts but display parent page in results
- Query posts by custom fields
- Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
- 294 Queries on Mainpage of WordPress
- Help with showing text when something is entered in my search bar
- Filtering product search results using tags
- SQL query into to WP query
- WordPress WP_Query Search (‘s’) With Multiple Search Terms
- Search query alteration not working for meta values
- Search results stuck on page 1
- Advanced Search – Is this possible?
- How to include custom fields in wordpress search
- Extend search query to search meta keys values based on search string
- AJAX multiple search boxes not merging with array merge
- How to make OR condition in WP_Query