mysql- sql查询 效率正常吗

Question

以下是sql：

 SELECT u.id,u.orgcode,u.name,u.slaveuser,COUNT(*) 
              FROM wx_xx_user u 
              INNER JOIN wx_xx_wlzy w ON u.id=w.publisherid
              INNER JOIN wx_xx_wlzycomment wc ON w.id = wc.wlzyid 
                INNER JOIN wx_xx_org org ON u.orgcode=org.orgcode
              WHERE  w.state = 2 AND w.wlzytype = 5 AND wc.state =0 AND u.issuperadmin!=1 
                    AND u.slaveuser IS NOT NULL AND u.slaveuser!='' AND org.autologin=1
              GROUP BY u.id

explain结果：

数据量：wx_xx_wlzy 62W，wx_xx_wlzycomment 13W，wx_xx_user 38W
查询时间：2.9S， 还能再优化吗

Answer 1

目前看来，效率还算正常。