Индексы для таблиц в 1.8

 
# Time: 110628  9:27:03
# User@Host: dbu[dbu5] @  [192.168.5.74]
# Query_time: 3  Lock_time: 0  Rows_sent: 10  Rows_examined: 3528
SET timestamp=1309238823;
SELECT con.*,
                           DATE_FORMAT(con.pubdate, '%d-%m-%Y') as fpubdate,
                           DATE_FORMAT(con.pubdate, '%H:%i') as fpubtime,
                           u.nickname as author,
                           u.login as user_login,
                           cat.title as title_cat,
                           cat.seolink as seolink_cat,
                           p.imageurl as user_imageurl
                    FROM cms_content con
                         INNER JOIN cms_users u ON con.user_id = u.id
                         INNER JOIN cms_category cat ON con.category_id = cat.id
                         INNER JOIN cms_user_profiles p ON p.user_id = con.user_id
                    WHERE con.published = 1 AND con.is_arhive = 0 AND con.user_id = u.id
                          AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= NOW() AND con.pubdate <= NOW()))
                    ORDER BY con.pubdate DESC
                    LIMIT 0, 10;
 

 
EXPLAIN SELECT * 
FROM cms_content	 
 

EXPLAIN SELECT con.*,
                           DATE_FORMAT(con.pubdate, '%d-%m-%Y') as fpubdate,
                           DATE_FORMAT(con.pubdate, '%H:%i') as fpubtime,
                           u.nickname as author,
                           u.login as user_login,
                           cat.title as title_cat,
                           cat.seolink as seolink_cat,
                           p.imageurl as user_imageurl
                    FROM cms_content con
                         INNER JOIN cms_users u ON con.user_id = u.id
                         INNER JOIN cms_category cat ON con.category_id = cat.id
                         INNER JOIN cms_user_profiles p ON p.user_id = con.user_id
                    WHERE con.published = 1 AND con.is_arhive = 0 AND con.user_id = u.id
                          AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= NOW() AND con.pubdate <= NOW()))
                    ORDER BY con.pubdate DESC
                    LIMIT 0, 10;

ALTER TABLE `cms_user_profiles` ADD INDEX ( `user_id` );

ALTER TABLE `cms_content` ADD INDEX ( `user_id` );

ALTER TABLE `cms_content` ADD INDEX ( `category_id` );