Долгие запросы MySql

/system/controllers/comments/model.php => 260 => modelComments->getCommentsCount()
SELECT COUNT( i.id ) AS COUNT
FROM cms_comments i
WHERE (i.is_approved <> '1') AND (i.is_deleted IS NULL)
Время выполнения 15.47301 секунд
/system/controllers/comments/model.php => 296 => modelComments->getComments()
SELECT i.*, r.score AS is_rated, u.nickname AS user_nickname, u.avatar AS user_avatar
FROM cms_comments i
LEFT JOIN cms_users AS u ON u.id = i.user_id
LEFT JOIN cms_comments_rating AS r ON r.comment_id = i.id AND r.user_id='86'
WHERE (i.is_approved <> '1') AND (i.is_deleted IS NULL)
ORDER BY i.date_pub DESC
LIMIT 0, 20
Время выполнения 15.01130 секунд

/system/controllers/content/model.php => 2251 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) AS COUNT
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
INNER JOIN cms_con_anec_cats_bind AS b FORCE INDEX (item_id) ON b.item_id = i.id
INNER JOIN cms_con_anec_cats AS c ON c.id = b.category_id
WHERE (c.ns_left >= '2') AND (c.ns_right <= '3') AND (i.rating > '-20') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
Время выполнения 1.73513 секунд
/system/controllers/content/model.php => 2312 => modelContent->getContentItems()
SELECT i.*, u.nickname AS user_nickname, f.title AS folder_title
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
INNER JOIN cms_con_anec_cats_bind AS b FORCE INDEX (item_id) ON b.item_id = i.id
INNER JOIN cms_con_anec_cats AS c ON c.id = b.category_id
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 (c.ns_left >= '2') AND (c.ns_right <= '3') AND (i.rating > '-20') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub DESC
LIMIT 0, 30
Время выполнения 3.65383 секунд

/system/controllers/comments/model.php => 260 => modelComments->getCommentsCount()
SELECT COUNT( i.id ) AS COUNT
FROM cms_comments i
WHERE (i.is_approved <> '1') AND (i.is_deleted IS NULL)
Время выполнения 6.17670 секунд
/system/controllers/comments/model.php => 296 => modelComments->getComments()
SELECT i.*, r.score AS is_rated, u.nickname AS user_nickname, u.avatar AS user_avatar
FROM cms_comments i
LEFT JOIN cms_users AS u ON u.id = i.user_id
LEFT JOIN cms_comments_rating AS r ON r.comment_id = i.id AND r.user_id='86'
WHERE (i.is_approved <> '1') AND (i.is_deleted IS NULL)
ORDER BY i.date_pub DESC
LIMIT 0, 20
Время выполнения 13.72876 секунд

/system/controllers/content/model.php => 2251 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) AS COUNT
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
INNER JOIN cms_con_anec_cats_bind AS b FORCE INDEX (item_id) ON b.item_id = i.id
INNER JOIN cms_con_anec_cats AS c ON c.id = b.category_id
WHERE (c.ns_left >= '2') AND (c.ns_right <= '3') AND (i.rating > '-20') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
Время выполнения 1.79360 секунд
/system/controllers/content/model.php => 2312 => modelContent->getContentItems()
SELECT i.*, u.nickname AS user_nickname, f.title AS folder_title
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
INNER JOIN cms_con_anec_cats_bind AS b FORCE INDEX (item_id) ON b.item_id = i.id
INNER JOIN cms_con_anec_cats AS c ON c.id = b.category_id
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 (c.ns_left >= '2') AND (c.ns_right <= '3') AND (i.rating > '-20') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub DESC
LIMIT 0, 30
Время выполнения 7.23022 секунд

/system/controllers/content/model.php => 2251 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) AS COUNT
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
WHERE (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
Время выполнения 1.87533 секунд
/system/controllers/content/model.php => 2312 => modelContent->getContentItems()
SELECT i.*, u.nickname AS user_nickname, f.title AS folder_title
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
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 (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub DESC
LIMIT 0, 30
Время выполнения 2.18498 секунд

/system/controllers/content/model.php => 2251 => modelContent->getContentItemsCount()
SELECT COUNT( i.id ) AS COUNT
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
WHERE (i.is_parent_hidden IS NULL) AND (i.rating > '-20') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
Время выполнения 1.69741 секунд
/system/controllers/content/model.php => 2312 => modelContent->getContentItems()
SELECT i.*, u.nickname AS user_nickname, f.title AS folder_title
FROM cms_con_anec i
FORCE INDEX FOR ORDER BY (date_pub)
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 (i.is_parent_hidden IS NULL) AND (i.rating > '-20') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub DESC
LIMIT 0, 30
Время выполнения 1.71915 секунд