Ris

 
# Query_time: 51.697987  Lock_time: 0.000473  Rows_sent: 20  Rows_examined: 1843896
SET TIMESTAMP=1520069949;
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='0'
WHERE (i.is_private = '0')  AND  (i.is_deleted IS NULL)  AND  (i.is_approved = '1')
ORDER BY i.date_pub DESC
LIMIT 922000, 20;

// Получаем количество и список записей
        $total = !empty($this->count) ? $this->count : $this->model->getCommentsCount();
		$this->model->limit($perpage)->join .= ("JOIN (SELECT id FROM cms_comments ORDER BY id DESC LIMIT ".($page-1)*$perpage.", $perpage ) c ON c.id = i.id ");
        $items = $this->model->getComments();

/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
JOIN (SELECT id FROM cms_comments ORDER BY id DESC LIMIT 958740, 20 ) c ON c.id = i.id 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_deleted IS NULL) AND (i.is_approved = '1')
ORDER BY i.date_pub DESC
LIMIT 20
Время выполнения 0.22628 секунд

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

<?php
 
	class onContentCommentsListWidgetFilter extends cmsAction {
 
		public function run($model){
 
			/*Если не главная страница*/
			if ($_SERVER['REQUEST_URI'] != '/'){
 
				 /* Получаем все типы контента*/
				$ctypes = implode('|', $this->model->getContentTypesNames());
 
				/* Получаем текущий тип контента */
				preg_match('/('.$ctypes.')/', $_SERVER['REQUEST_URI'], $matches); 
 
				/* Если тип контента опознан - фильтруем комментарии только из него */
				if (!empty($matches)){$model->filterEqual('target_subject', $matches[0]);} 
 
			}
 
			// Отправляем данные обратно в компонент
				return  $model;
 
		}
 
	}	

<?php
 
	class onContentCommentsListWidgetFilter extends cmsAction {
 
		public function run($model){
 
 
			$ctypes = implode('|', $this->model->getContentTypesNames()); /* Получаем все типы контента*/
 
			preg_match('/('.$ctypes.')/', $_SERVER['REQUEST_URI'], $matches); /* Получаем текущий тип контента */
 
			$model->filterEqual('target_subject', $matches ? $matches[0] : str_replace('content:', '', $this->cms_config->frontpage));
 
			// Отправляем данные обратно в компонент
			return  $model;
 
		}
 
	}