Страшные запросы в базу данных

Время исполнения, секунд   - 60
Кол-во просмотренных строк - 200925
Запрос:
-------
SET timestamp=1386530763;
SELECT con.*,
                       con.pubdate as fpubdate,
					   cat.title as cat_title, cat.seolink as catseolink,
					   cat.showdesc,
                       u.nickname as author,
                       u.login as user_login,
		       cmm.count_com
                FROM cms_content con
				INNER JOIN cms_category cat ON cat.id = con.category_id
				LEFT JOIN cms_users u ON u.id = con.user_id
						 LEFT JOIN         
                ( 
                    SELECT target_id, COUNT(id) AS count_com
                    FROM cms_comments cmm
		    WHERE  target='article' AND published = 1
                    GROUP BY target_id 
                ) cmm ON cmm.target_id = con.id 
                WHERE con.is_arhive = 0
                       AND (cat.NSLeft >= '24' AND cat.NSRight <= '49'
AND cat.parent_id > 0)
 AND (con.showlatest = 1)
 AND (con.published = 1 AND con.pubdate <= '2013-12-08 21:26:56' AND
(con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2013-12-08 21:26:56')))
 
 
 
 
                ORDER BY con.pubdate DESC
LIMIT 0, 4;

$sql = "SELECT con.*,
                       con.pubdate as fpubdate,
					   cat.title as cat_title, cat.seolink as catseolink,
					   cat.showdesc,
                       u.nickname as author,
                       u.login as user_login,
		       cmm.count_com
                FROM cms_content con
				INNER JOIN cms_category cat ON cat.id = con.category_id
				LEFT JOIN cms_users u ON u.id = con.user_id
						 LEFT JOIN         
                ( 
                    SELECT target_id, COUNT(id) AS count_com
                    FROM cms_comments cmm
		    WHERE  target='article' AND published = 1
                    GROUP BY target_id 
                ) cmm ON cmm.target_id = con.id 
                WHERE con.is_arhive = 0
                      {$this->inDB->where}
 
                {$this->inDB->group_by}
 
                {$this->inDB->order_by}\n";
 
        if ($this->inDB->limit){
            $sql .= "LIMIT {$this->inDB->limit}";
        }