Ris

// Получаем количество и список записей
        $total = !empty($this->count) ? $this->count : $this->model->getCommentsCount();
		if (strpos($_SERVER['REQUEST_URI'], 'comments/all') && $this->cms_user->id) {$this->model->limit($perpage)->join .= ("JOIN (SELECT id FROM cms_comments WHERE is_deleted IS NULL ORDER BY id DESC LIMIT ".($page - 1)*$perpage.", $perpage) c ON c.id = i.id ");}
        if (!$this->cms_user->id){$this->model->limit($perpage)->join .= ("JOIN (SELECT id FROM cms_comments WHERE is_private = '0' AND is_deleted IS NULL AND is_approved = '1' ORDER BY id DESC LIMIT ".($page - 1)*$perpage.", $perpage) c ON c.id = i.id ");}		
        $items = $this->model->getComments();

/system/controllers/comments/model.php => 297 => modelComments->getComments()
SELECT i.*, r.score AS `is_rated`, u.nickname AS `user_nickname`, u.is_deleted AS `user_is_deleted`, u.avatar AS `user_avatar`, IF(online.date_created IS NOT NULL AND TIMESTAMPDIFF(SECOND, online.date_created, NOW()) <= 180, 1, 0) AS `is_online`
FROM cms_comments i
JOIN (SELECT id FROM cms_comments WHERE is_deleted IS NULL ORDER BY id DESC LIMIT 1048480, 20) c ON c.id = i.id LEFT JOIN cms_users AS u ON u.id = i.user_id
LEFT JOIN cms_sessions_online AS online ON online.user_id = u.id
LEFT JOIN cms_comments_rating AS r ON r.comment_id = i.id AND r.user_id='86'
WHERE (i.is_deleted IS NULL) AND (i.is_approved = '1')
ORDER BY i.date_pub DESC
LIMIT 20
Время выполнения 1.91492 секунд

/system/controllers/comments/model.php => 297 => modelComments->getComments()
SELECT i.*, r.score AS `is_rated`, u.nickname AS `user_nickname`, u.is_deleted AS `user_is_deleted`, u.avatar AS `user_avatar`, IF(online.date_created IS NOT NULL AND TIMESTAMPDIFF(SECOND, online.date_created, NOW()) <= 180, 1, 0) AS `is_online`
FROM cms_comments i
LEFT JOIN cms_users AS u ON u.id = i.user_id
LEFT JOIN cms_sessions_online AS online ON online.user_id = u.id
LEFT JOIN cms_comments_rating AS r ON r.comment_id = i.id AND r.user_id='86'
WHERE (i.is_deleted IS NULL) AND (i.is_approved = '1')
ORDER BY i.date_pub DESC
LIMIT 1048500, 20
Время выполнения 53.05825 секунд

/system/controllers/comments/model.php => 261 => modelComments->getCommentsCount()
SELECT COUNT(*) AS COUNT
FROM cms_comments i
WHERE (i.is_deleted IS NULL) AND (i.is_approved = '1')
Время выполнения 0.37463 секунд
/system/controllers/comments/model.php => 297 => modelComments->getComments()
SELECT i.*, r.score AS `is_rated`, u.nickname AS `user_nickname`, u.is_deleted AS `user_is_deleted`, u.avatar AS `user_avatar`, IF(online.date_created IS NOT NULL AND TIMESTAMPDIFF(SECOND, online.date_created, NOW()) <= 180, 1, 0) AS `is_online`
FROM cms_comments i
JOIN (SELECT id FROM cms_comments WHERE is_deleted IS NULL ORDER BY id DESC LIMIT 1048500, 20) c ON c.id = i.id LEFT JOIN cms_users AS u ON u.id = i.user_id
LEFT JOIN cms_sessions_online AS online ON online.user_id = u.id
LEFT JOIN cms_comments_rating AS r ON r.comment_id = i.id AND r.user_id='86'
WHERE (i.is_deleted IS NULL) AND (i.is_approved = '1')
ORDER BY i.date_pub DESC
LIMIT 20
Время выполнения 54.50465 секунд