阅读背景:

mysql sql优化实例1(force index使用)

来源:互联网 

今天和运维同学一块查找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;SEL




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: