What does this request do?

Question

MySQL

SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id
I was told that it exceeded the number of database queries.

Answer 1

Selects all blog posts along with metadata from the database.

Answer 2

Maybe it makes sense to somehow limit it?

Answer 3

There was a similar situation. We had such a situation due to the fact that the request shoveled a bunch of records. Check how many records this query iterates over with Explain.
Just write the word Explain before the request.
For example via PhpMyAdmin. And the server will give you statistics on request.
indexes on certain columns helped us