今天和运维同学一块查找mysql慢查询日志,发现了如下一条sql:
SELECT sum(`android` + ios) total,pictureid,title,add_time FROM `juzi_access_statistic` LEFT JOIN juzi_news ON juzi_access_statistic.pictureid=juzi_news.id GROUP BY `pictureid` HAVING total >= 100000 AND pictureid >= 8092 AND title IS NOT NULL LIMIT 2;
该sql语句花费了 2.7s,那么总共多少条呢?
总共54万条记录,其实也不算太慢,但是我觉得应该有很大的优化空间。
一:先看一下表结构
CREATE TABL