MySQL, Query, Optimization, Web Performance, Database.
the latter is a little bit faster, the difference is not big, because the two methods use the index in the query. 8. Conditional simplification and optimization 1, as much as possible where where, having (when there is no groupby and aggregate function), join-on conditions can be merged 2, remove