Оптимизация Slow Query

26.09.2017

SELECT DISTINCT node.nid AS nid, node.created AS node_created, node.title AS node_title,
node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node.sticky AS node_sticky
FROM node node
INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
WHERE (node.status = 1)AND (node.type IN ('video', 'text', 'photo'))
ORDER BY node_sticky DESC , node_created DESC
LIMIT 0 , 6

Доброго времени суток!
Есть такой mysql, время выполнения напрягает 800-1200ms
Что посоветуете?