left join 多导致 order by 时间字段查询慢问题（不走索引）

left join 多导致 order by 时间字段查询慢问题

    SELECT
    data_news.newsid,
    title,
    data_news.addtime AS addtime,
    data_news.author,
    GROUP_CONCAT( config_channel.`name` ) AS channelName,
    dns.count_collection AS countCollection,
    dns.count_forward AS countForward,
    dns.count_read AS countRead,
    dns.count_pinlun AS countPinlun,
    dns.count_praise AS countPraise 
FROM
    data_news
    LEFT JOIN data_news_static dns ON data_news.newsid = dns.news_id
     left  JOIN relation_newschannel ON relation_newschannel.newsid = data_news.newsid
     JOIN config_channel ON config_channel.id = relation_newschannel.channelid 
WHERE
    data_news.STATUS = 2 
GROUP BY
    data_news.newsid 
ORDER BY
    addtime DESC 
    LIMIT 10

此sql需要查询5秒钟

执行计划：

left join相关的表，对应字段也要加索引，要不然肯定慢呀