One of two similar WP Query is very slow

It is likely there are very few rows WHERE
AND ( wp_posts.post_date >= ‘2019-09-04 21:45:00’ )
there are likely many thousands of rows WHERE
AND ( wp_posts.post_date < ‘2019-09-04 21:45:00’ )
and a table scan is required. EXPLAIN SELECT SQL_NO_CACHE remainder of query for each and examine results carefully. Post the TEXT RESULTS of EACH EXPLAIN SELECT SQL_NO_CACHE remainder of your query for our assistance in understanding what is going on.

Related Posts:

  1. Return only Count from a wp_query request?
  2. Use REGEXP in WP_Query meta_query key
  3. Order by DESC, ASC in custom WP_Query
  4. How to prevent execution of default query, while preserving ability to use WP_Query in template?
  5. Get posts by menu ID
  6. Slow SQL_CALC_FOUND_ROWS Query
  7. SQL query equivalent to WP User Query
  8. What’s wrong with this WP query?
  9. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  10. How to count post meta key values for all posts in database
  11. Group posts by meta_key
  12. How to search for posts IN OR title OR content OR author?
  13. WP_Query hit max joins… How else can I build a search function that uses custom fields?
  14. Would this post meta be better added to the post table rather than post_meta table
  15. Order By Multiple Meta Fields
  16. meta_query on a date range using an array of values
  17. How to speed up wp_query, took more 5s to run against 100k posts
  18. SQL User Query by Multiple Roles using PHP
  19. WordPress Query is taking more then 20 second and stuck on creating index
  20. Get the Plugin Which Triggered a MySql Query in WordPress?
  21. Mysql query LIKE not working
  22. How to get posts on a specific date – WP Query
  23. Using WP_Query and WP_Meta_Query Outside of WordPress
  24. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  25. Improve wp query perfomance on large db
  26. Order by custom table and multiplication
  27. Single meta_query query using OR instead of AND in request’s WHERE statement
  28. why update and delete query not worked in custom table?
  29. How to use MySQL’s MATCH AGAINST in WP_Query?
  30. Slow WP_Query for custom post type
  31. Performance when getting post meta for post retrieved by meta value
  32. Hide Administrators From User List except current user (administrator)
  33. Add “Category” to Mysql Query
  34. Mysql query and order meta value
  35. Help with WP_Query – Too many mySQL queries
  36. Using hook to use DISTINCT in a wp_query
  37. pagination with ‘no_found_rows’ => true,
  38. Order by summing multiple values
  39. How to implement a new row_count method in WordPress?
  40. Wp query show post by author name or post title or post content
  41. Query most popular terms by taxonomy over 2 week period
  42. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  43. how update data through ajax and jquery
  44. Meta Query doesn’t works as espected
  45. how to get Nearby zipcode
  46. How I can change the condition or compare operator for WP_Query in pre_get_posts
  47. Update query for wp_posts and wp_postmeta
  48. mysql query order by
  49. WP_Query with page_ids in arguments without a result
  50. Query multiple meta key values for template
  51. get_var is neither a string, integer, or array …?
  52. SQL query injection with fifu image
  53. Why last row deleted when refresh page
  54. WP Query – grouping posts by same meta key, adding together values from another key
  55. Woocommerce Get Orders By Meta Value
  56. SQL to join u3g_users & u3g_meta_value with repeating data
  57. INNER JOIN custom tables – SQL Query
  58. use mysql variable in a $wpdb->query to reindex a column?
  59. Fix wp_term_relationships slow query in get_posts
  60. WordPress Query optimaization for slow query
  61. Sorting query_posts() with a complex orderby filter
  62. Case insensitive ORDERBY in wpquery
  63. Query postmeta based on meta_value, return array of post_id
  64. Order Posts By Custom Field That is an array of objects
  65. Multiple wpostmeta.meta_key
  66. Slow query when selecting with large meta query or post__in
  67. WP_Query always returning the last custom post
  68. Get a list of the last posts grouped by author and filtered by category
  69. How to count post meta key values for all posts in database
  70. meta_query dates from an array
  71. Different sql queries count indicator on the main page [closed]
  72. Parsing External Table Arguments
  73. How to add a custom field and incrementing value for all the published posts
  74. WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
  75. SQL query into to WP query
  76. Bulk delete comments, foreach loop
  77. Multiple WP_Query loops with Pagination
  78. What is the most efficient way of querying posts based on visits and date for current day?
  79. WP_Query or get_posts?
  80. How do you query wordpress posts using a math formula between multiple meta field values?
  81. Ordering Posts Type A by Custom Fields of related Post Type B
  82. Query Posts depends on custom field inside repeater field using acf
  83. Query all published post AND attachment with specific mime type
  84. How to list custom fields as headers and list all pages sharing that custom field under it?
  85. Exclude current post from an array of posts?
  86. How to set an alternate posts_per_page value for default queries in different templates
  87. Query posts using less than
  88. Using WHERE on a WP_Query
  89. How to query for a page, get data, then query for child pages of that page
  90. How can I return only IDs from the `posts` REST endpoint?
  91. Query posts by post type, author and post meta
  92. Query a database based on form input then output to another page [closed]
  93. Query for getting posts with their custom fields data in WordPress
  94. I removed the “wp_rm_logs” table and am constantly getting this error
  95. How to set selected attribute on option after filter query?
  96. Loop the posts between two dates selected using jquery datepicker
  97. wordpress sorting using array merge by price in ascending order but price with 0 must be show last
  98. Remove divs and spans from post content
  99. Get all user with both meta_value
  100. List categories using WP_Query
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduedueduseduseduseduseduedusedu