MySQL, Query, Optimization, Web Performance, Database.
subquery, you can pull up the subquery to the parent layer. In the multi-table join query consider the connection cost and then choose. The query optimizer generally uses nested execution for subqueries, that is, performs a subquery for each row in the parent query, so that the subquery is executed