我的SQL语句如下   日中三个表数据量分别为 1700 13000 34  这样查询要40秒才会出来结果(我远程连的服务器MYSQL)。 我表示压力很大。请大神给予指示,
 
 SELECT
        COUNT(adverId) visit,
        adverId,
        statId
        developersName,
        productsName  
    FROM
        tb_statistic_adver_visit v,
        (SELECT
            chid,
            uid,
            cpid 
        FROM
            tb_statistic_stat) s,
        (SELECT
            developersName,
            productsName,
            developersId,id 
        FROM
            tb_developers_service 
        WHERE
            1=1 
        GROUP BY
            developersId ) d 
    WHERE
        1=1  
        AND s.uid=v.statId 
       AND s.cpid=d.developersId  
    GROUP BY
        adverId