MySQL, Query, Optimization, Web Performance, Database.
many times. This type of execution is inefficient. Subquery conversion to join query advantages: 1, the subquery does not need to be executed many times 2, the optimizer can choose different methods and connection order according to the information 3, The join condition of the subquery, and the