一条统计代码慢查询了

SELECT COUNT(userId) AS userNum,
       CASE 
       WHEN recordTotalCount<10 THEN 'lessThan10'
			 WHEN recordTotalCount>=10 AND recordTotalCount<15 THEN '10More'
			 WHEN recordTotalCount>=15 AND recordTotalCount<20 THEN '15More'
			 WHEN recordTotalCount>=20 AND recordTotalCount<25 THEN '20More'
			 WHEN recordTotalCount>=25 AND recordTotalCount<30 THEN '25More'
			 WHEN recordTotalCount>=30 AND recordTotalCount<35 THEN '30More'
			 WHEN recordTotalCount>=35 AND recordTotalCount<40 THEN '35More'
			 WHEN recordTotalCount>=40 THEN '40More'
       END AS levelstr
FROM t_user_day_record_total
GROUP BY levelstr

上面的mysql里执行的时候会慢查询，希望有大神可以指教优化点。

1.分成一条条的sql语句不同条件是可以的。

2.其他等