MySQL, Query, Optimization, Web Performance, Database.
filter condition becomes the filter condition of the parent query to improve the efficiency. optimization: Subquery merges, if multiple subqueries, merge as much as possible. Subquery expansion, that is, pull-up into multi-table query (time guarantee equivalent change) Note: A subquery expansion