Очень долго грузятся комментарии - Общие вопросы

$where[] = 'c.lang = ' . $db->Quote(JCommentsMultilingual::getLanguage());

JOIN #__jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang

 AND c.lang = o.lang

$query = "SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar"
			. ", o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner"
			. " FROM #__jcomments AS c"
			. " JOIN #__jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang"
			. (count($joins)? ' ' . implode(' ', $joins) : '')
			. (count($where)? ' WHERE  ' . implode(' AND ', $where) : '')
			. " ORDER BY " . $orderBy
			;

$tag4 = JFactory::getLanguage()->getTag();
                if ($tag4 == 'ru-RU') {
                    $lang4 = 'ru-RU';
                    }
                else {
                    $lang4 = 'uk-UA';
                    }
		
		$query = "SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar"
			. ", o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner"
			. " FROM #__jcomments AS c"
			. " JOIN #__jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND o.lang = '$lang4'"
			. (count($joins)? ' ' . implode(' ', $joins) : '')
			. (count($where)? ' WHERE  ' . implode(' AND ', $where) : '')
			. " ORDER BY " . $orderBy
			;

$where[] = 'c.lang = ' . $db->Quote(JCommentsMultilingual::getLanguage());