Slow query when joining wp_posts with a lookup-table?

It’s the order of your primary key declaration. If you’re always searching on place_id, declare that first, then post_id:

PRIMARY KEY (place_id, post_id)

Related Posts:

  1. How to display SQL query that ran in query?
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. WordPress creating excessive joins on meta_query with search
  6. cron job to auto delete posts of a specific post type older than x days
  7. Are database queries created using WordPress filters protected from SQL injection?
  8. Get posts by category with pure SQL query
  9. Custom query to get terms from post ids
  10. Get the timout value of a saved transient?
  11. What’s wrong with my $wpdb prepare?
  12. How do I see the mysql query generated by get_posts( $args )?
  13. sql select query in wordpress ‘page’ [closed]
  14. problem with sql query in wordpress plugin
  15. Attempt to improve WP search, can someone check my SQL query?
  16. wpdb query problem to access previous 3 days posts
  17. I can’t figure out what’s wrong with this statement. $wpdb->query update
  18. Custom Query – Based on user input
  19. how to insert missing tags into the posts through mySQL?
  20. $wpdb->prepare affecting the query?
  21. WordPress SQL search, how to handle SQL Injection?
  22. exclude pingbacks from wordpress SQL query
  23. prepare function sql safe method
  24. WordPress SQL query to tag all posts containing a specific word on title
  25. Select column name dynamically mySQL Query
  26. How do I query for posts by custom meta and those that have been stickied?
  27. Change pure SQL database query to WordPress post query?
  28. Cannot get sql request from Query object?
  29. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  30. Display data from phpMyAdmin with WordPress
  31. SQL to Query the db and return all posts and it’s metas
  32. SQL query to delete users with multiple meta keys and comments
  33. Nested select statements not working
  34. Speed up search query that searches in post meta?
  35. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  36. Fastest and most efficient SQL query to check if UID exists
  37. How to make MySQL search queries with quotes
  38. How i make a custom sql query for Woocommerce
  39. $wpdb query for price in custom field value
  40. Run an update query in a function
  41. How to display a specific category using a custom Query in WordPress?
  42. Wpdb generates too many queries
  43. learn to run wpdb class
  44. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  45. Where can I find the SQL to get the most used information by wordpress database?
  46. Custom Query for wp_posts using wp_postmeta
  47. 3 queries to update WordPress
  48. Get Terms by IDs with IDs order
  49. Slow wp_enqueue_media()
  50. Advanced Custom Fields – Query Efficiency
  51. How to tell if $query_var isset?
  52. Sorting Grids with Essential Grid and Events Manger
  53. The use of including upgrade.php when building custom queries
  54. Does meta_query work within get_posts array?
  55. How to show more than 5 posts?
  56. WordPress Find Duplicate Post By Content
  57. WP Query Sort by meta value (date)
  58. how to query multiple categories in wordpress?
  59. Disable the MySQL query in the main query
  60. Update slug (URL) of pending posts via phpMyAdmin
  61. How can I get the query that would be run for the archive page?
  62. Query metas (and not : query posts by metas)
  63. Select query for a login
  64. Get stock by custom meta field on all Woocommerce variable products
  65. where should I reset query after using get_results?
  66. Exclude featured image and custom field from this get_attachment query
  67. Form and custom query problem
  68. Export Specific User data without plugin
  69. How to write: $wpdb->update having WHERE NOT value pair in the array
  70. Exclude all sticky posts front page twenty twelve
  71. wpdb COALESCE won’t work
  72. get csv of users with user_meta
  73. Query does not return content
  74. Parse query filter in wordpress and relation
  75. get posts by tag to showing in a widget
  76. Mysql query not working on WordPress 4.2.2
  77. get_post_meta with WP_query
  78. How properly create a blog template for wordpress?
  79. Is there a way to add a link directly into this media query?
  80. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  81. SQL query – get a featured image’s alt / alternative text
  82. meta_query not working
  83. Customising the default wordpress search functionality
  84. Question about of query
  85. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  86. Modify behaviour of “s” parameter in wp_query
  87. Limiting a filtered query
  88. Archive query not working correctly
  89. Custom MySQL Query for Post and Post Meta
  90. very slow wordpress query with default query
  91. Custom Query problem access the values
  92. Set posts per page for parent category and it’s all children
  93. Exclude sticky posts from query
  94. Rewrite Query_Var URL Parameter with Slug
  95. How to query different categories on index?
  96. Can’t See Media Queries with Inspect Tool [closed]
  97. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  98. update $wpdb one query
  99. Admin Post List table Query filtering “WHERE” for custom post type
  100. How to use a dynamic term id for the query block