MySQL查询用户每天的阅读量以及Using temporary; Using filesort

做后台需要得到用户每天在我们公司社区阅读文章的访问量，以及阅读量大于10的时间段（测试库数据量为5千多）

 select b.user_name,COUNT(a.info_id) as cou,DATE_FORMAT(a.create_time,'%y-%m-%d') as time,a.create_time,a.user_id from user_read_info a LEFT JOIN user b on a.user_id = b.id 
 GROUP BY a.user_id,DATE_FORMAT(a.create_time,'%y%m%d') 
 HAVING cou >10

查看一下运行情况（explain)：

EXPLAIN select b.user_name,COUNT(a.info_id) as cou,DATE_FORMAT(a.create_time,'%y-%m-%d') as time,a.create_time,a.user_id from user_read_info a LEFT JOIN user b on a.user_id = b.id 
 GROUP BY a.user_id,DATE_FORMAT(a.create_time,'%y%m%d') 
 HAVING cou >10</