select customer,count(1) c
from upv_1 forceindex(idx_created)where created between"2015-07-06"and"2015-07-07"groupby customer
having c >15orderby c desc
mysql强制使用索引例如: 强制使用 idx_created索引select customer,count(1) c from upv_1 force index(idx_created) where created between "2015-07-06" and "2015-07-07" group by customer having c > 15 order by c desc