slow query – Search for Media Gallery

Time: 2016-12-30T16:28:07.386551Z
User@Host: info_234[info_234] @ localhost [] Id: 6390731
Query_time: 4.187182 Lock_time: 1.953823 Rows_sent: 40 Rows_examined: 644073

SET timestamp=1483115287;

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta AS sq1 ON ( wp_posts.ID = sq1.post_id AND sq1.meta_key = ‘_wp_attached_file’ ) WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%электр%’) OR (wp_posts.post_excerpt LIKE ‘%электр%’) OR (wp_posts.post_content LIKE ‘%электр%’) OR ( sq1.meta_value LIKE ‘%электр%’ ))) AND (wp_posts.post_mime_type LIKE ‘image/%’) AND wp_posts.post_type=”attachment” AND ((wp_posts.post_status=”inherit” OR wp_posts.post_status=”private”)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 40;

I can tell the SQL query executes for 644073 posts, and this is a biggie.
It explains half of your problem. Maybe in WordPress 4.7 added a search based on meta_value, and probably you have many meta values in your structure. It would be interesting to compare this vs. the query in WordPress 4.6.

What you may do is to modify the ajax_query_attachments_args hook to make your query run faster.

File: wp-admin/includes/ajax-actions.php
2409:   /**
2410:    * Filters the arguments passed to WP_Query during an Ajax
2411:    * call for querying attachments.
2412:    *
2413:    * @since 3.7.0
2414:    *
2415:    * @see WP_Query::parse_query()
2416:    *
2417:    * @param array $query An array of query variables.
2418:    */
2419:   $query = apply_filters( 'ajax_query_attachments_args', $query );
2420:   $query = new WP_Query( $query );

I feel this is a separate question, if you have any problems, just let me know.

Related Posts:

  1. Can I force WP_Query to return no results?
  2. Use the page slug in a WP_Query?
  3. paginate_links() adds empty href to first page and previous link
  4. Using OR conditions in meta_query for query_posts argument
  5. Get array of posts from the current archive page loop
  6. Get posts by menu ID
  7. count posts from custom taxonomy terms by year
  8. In loop: posts have thumbnail AND other variables
  9. How to grab metabox value in wp_query meta_query key
  10. Woocommerce query by price range and custom meta key
  11. Add and in the header while looping over custom query in page template
  12. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  13. Move posts to top of WP_Query if in certain Taxonomy?
  14. WP_query ‘orderby=none’ Problem
  15. Pagination not working on static page
  16. How can I create a WP_Query that returns posts where one meta_value
  17. ‘paged’ in wp_query doesn’t work
  18. Sorting meta_value as integer doesn’t work
  19. Get posts from the Main site to sub site – WordPress MultiSites Network
  20. Custom Field Query – Meta Value is Array
  21. Can certain (site-crashing) limitations on WP_Query in shortcode be overcome?
  22. Get array of current post term ID’s
  23. WP_Query for showing specific post by id
  24. Ordering by meta_value AND date NOT WORKING with wp_query
  25. Query by custom dates in UNIX Time
  26. Implementing an OR statement to wordpress wp_query
  27. Get List of all the Authors
  28. Minimize database queries to user tables?
  29. WP_Query returns more results than expected
  30. How to make Meta Query case sensitive?
  31. Populate tax_query terms parameter with post term
  32. Orderby the sum of several numeric custom meta fields
  33. unable to retrive parent page information
  34. Site not getting correct featured image from my query
  35. Using WP_Query within an mu-plugin
  36. wp_query ‘s’, search filter with pagination is not working
  37. Use more than one query, but prevent duplicates – at scale!
  38. WP Query related posts by tags
  39. How to add posts, manually, to a wp_query?
  40. wp_reset_postdata() does not work as expected
  41. Search Query for multiple categories using ‘OR’ but having certain categories be ‘AND’
  42. How to display an other custom post type in a different custom post type’s archive?
  43. Replacing raw database query to WP_Query
  44. Stale $GLOBALS[‘post’] after custom WP_Query empty result set bothers my template, whose fault is this?
  45. Need to convert string of term ids into comma separated integers for use in an arguments array
  46. How can I allow sticky posts but cap the query to 1 post?
  47. How do I get my custom query to work with search results after the first page?
  48. Problem with is_tax in WP_Query loop
  49. Need Sub-category with main Category
  50. Easy way to write complex queries in wordpress
  51. Error with function in functions.php?
  52. I am having problem sorting custom post type using WP_Query
  53. WP_Query and is_page_template() conditional
  54. difference between querying database and using the loop
  55. How to do logical OR in terms in WP Query?
  56. Slow Query On Search
  57. Loop posts based on permalink term
  58. Child pages not affected by orderby
  59. Write WP Query that selects posts that are part of the same two categories
  60. Error in meta_query not get result
  61. Custom wp_query – I’m getting ‘all’ post, not the specific post in the query
  62. How to get current page nearest parent id?
  63. Phpmyadmin – post editing
  64. wp Query Posts to display in Nivo Slider
  65. How to get only ONE category of “Portfolio” posts to display on main page rather than ALL categories?
  66. Query not sorting DESC
  67. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  68. Filter products on category AND tag
  69. Strange behaviour of hierarchical taxonomy archive
  70. meta_query – check for multiple meta values in key which holds an array of values
  71. How to sort wordpress posts already selected by WP_QUERY
  72. Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
  73. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  74. SEARCH QUERY PLEASE HELP | call_user_func_array() expects parameter 1 to be a valid callback php
  75. Set “editor” role to existing user
  76. how to get wp_query posts only first letter of alphabet A?
  77. Custom Post Type WP_Query with filters and search
  78. Merge wp-query and get_users
  79. WP_Query how to add a thumbnail to the first post from the last 5 posts?
  80. How order by works?
  81. Query by meta value (add a dropdown of all values)
  82. taxquery taxonomy get terms
  83. Calling a function with WP_Query only ever brings the first result
  84. get last child post by wp_query
  85. WP_Query don’t working with fixed post_id and term_taxonomy
  86. How To Query All Attachment Images Found In Post Galleries
  87. WordPress meta_query not working
  88. Create multiple sections for all categories and then queries all the posts for each of those categories
  89. Using orderby with 2 meta keys
  90. wp_query – Modify $query to include duplicate content
  91. $wp_query when new WP_Query
  92. Query to get all the posts of more than 2 meta_value having same meta_key?
  93. Unable to pass variable
  94. WP Query get posts by specific author IDs if one of several logged in authors
  95. Query specific number of posts for each post type in specific order
  96. Avoiding page loop
  97. how do I exclude child categories from a wp_query?
  98. How to display posts from a specific term first then another posts from another terms using tax_query
  99. Query All Posts: Either Display Most Recent or One with Particular ACF Value Chosen
  100. Display only posts with thumbnails