SQL语句的执行顺序

select item1，Count(*) as total from table where item = {#item} group by item1 order by total desc limit 5;

from > where > group by > select >order by>limit

先 from 判断查询哪张表，再根据 where 查询字段条件，进行 group by 分组，进行select 汇总字段，对结果 order by 排序，最后进行 limit 分页