Looking at your query, I see lots of stuff like wp_posts.post_content LIKE '%اهمية%'.
You should know that column LIKE '%matchstring%' is a notorious MySQL performance-killer. If you can change your operations to use column LIKE 'matchstring%' (with no leading %) this will get better.
Or, maybe it makes sense for you to adopt a search plugin like Relevanssi. (I don’t know if it works well for Arabic, but it does work well for Roman-alphabet languages.)
Related Posts:
- How to prevent execution of default query, while preserving ability to use WP_Query in template?
- Improve wp query perfomance on large db
- WordPress Query optimaization for slow query
- Return only Count from a wp_query request?
- Use REGEXP in WP_Query meta_query key
- Set Alias for meta_query arguments in get_posts()
- Order by DESC, ASC in custom WP_Query
- Get posts by menu ID
- Slow SQL_CALC_FOUND_ROWS Query
- SQL query equivalent to WP User Query
- What’s wrong with this WP query?
- Stop all SQL_CALC_FOUND_ROWS wordpress queries
- How to count post meta key values for all posts in database
- Group posts by meta_key
- How to search for posts IN OR title OR content OR author?
- WP_Query hit max joins… How else can I build a search function that uses custom fields?
- Would this post meta be better added to the post table rather than post_meta table
- Order By Multiple Meta Fields
- meta_query on a date range using an array of values
- How to speed up wp_query, took more 5s to run against 100k posts
- Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
- SQL User Query by Multiple Roles using PHP
- Get the Plugin Which Triggered a MySql Query in WordPress?
- What’s faster? One big query, or several smaller ones?
- Mysql query LIKE not working
- How to get posts on a specific date – WP Query
- Using WP_Query and WP_Meta_Query Outside of WordPress
- 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
- Single meta_query query using OR instead of AND in request’s WHERE statement
- why update and delete query not worked in custom table?
- How to use MySQL’s MATCH AGAINST in WP_Query?
- Database Queries Optimization with new WP_Query
- Slow WP_Query for custom post type
- Performance when getting post meta for post retrieved by meta value
- Hide Administrators From User List except current user (administrator)
- Add “Category” to Mysql Query
- How to optimize multiple WP_Query() calls on one page?
- Mysql query and order meta value
- Help with WP_Query – Too many mySQL queries
- Using hook to use DISTINCT in a wp_query
- pagination with ‘no_found_rows’ => true,
- How to show optimized list of posts with all their attachment images
- Order by summing multiple values
- Query posts without meta preload
- How to implement a new row_count method in WordPress?
- Wp query show post by author name or post title or post content
- Query most popular terms by taxonomy over 2 week period
- Which is faster wpdb & get_row or wp_query & ge_post_meta?
- how update data through ajax and jquery
- Meta Query doesn’t works as espected
- how to get Nearby zipcode
- How I can change the condition or compare operator for WP_Query in pre_get_posts
- Update query for wp_posts and wp_postmeta
- mysql query order by
- WP_Query with page_ids in arguments without a result
- Function to retrieve IDs of posts, cache results, and improve wp_query
- Query multiple meta key values for template
- get_var is neither a string, integer, or array …?
- Optimising WP_Query with ACF Fields
- SQL query injection with fifu image
- Why last row deleted when refresh page
- WP Query – grouping posts by same meta key, adding together values from another key
- Woocommerce Get Orders By Meta Value
- SQL to join u3g_users & u3g_meta_value with repeating data
- INNER JOIN custom tables – SQL Query
- use mysql variable in a $wpdb->query to reindex a column?
- One of two similar WP Query is very slow
- Fix wp_term_relationships slow query in get_posts
- Sorting query_posts() with a complex orderby filter
- Case insensitive ORDERBY in wpquery
- Query postmeta based on meta_value, return array of post_id
- Order Posts By Custom Field That is an array of objects
- Multiple wpostmeta.meta_key
- Slow query when selecting with large meta query or post__in
- WP_Query always returning the last custom post
- Optimize WP_Query
- Optimising amount of calls to custom fields
- ordering and optimizing functions
- Get a list of the last posts grouped by author and filtered by category
- How to count post meta key values for all posts in database
- meta_query dates from an array
- Different sql queries count indicator on the main page [closed]
- Parsing External Table Arguments
- How to add a custom field and incrementing value for all the published posts
- WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
- SQL query into to WP query
- Bulk delete comments, foreach loop
- WordPress – Optimize the Meta Query for 3 meta keys at a time
- WordPress altering my custom query, How to fix it?
- Get pagination working for custom loops within page templates
- how would i change post->ID to work correctly when querying pages?
- WP_Query Orderby meta_key and hide some meta_key
- Show X taxonomies of the latest published posts
- WordPress Query custom ordering by temporary variable
- Check the stored / cached WP_Query with transients on post change
- New template file does not load category-specific post
- How to create better WP_Query to look for date time which is anywhere between two meta values?
- Load WP Query with Ajax
- Wrap group of wp query posts to parent div by date/year