Тяжёлые запросы к БД

 
system/controllers/content/model.php => 2211 => get()
SELECT i.*, u.nickname as user_nickname, f.title as folder_title
FROM cms_con_articles i
FORCE INDEX (date_pub)
INNER JOIN cms_tags_bind as t ON t.target_id = i.id AND t.target_subject = 'articles' AND t.target_controller = 'content'
INNER JOIN cms_users as u FORCE INDEX (PRIMARY) ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (t.tag_id = '5477') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 735, 15
Запрос занял 32.47264 секунд