MySQL 使用profile分析慢sql，group left join效率高于子查询

http://blog.csdn.net/mchdba/article/details/54380221

-----------------