Помогите срочно! Проблема после миграции на 1.9

Время генерации страницы: 0.0500 сек.
Запросы к базе: 68
SET NAMES cp1251
SELECT * FROM cms_menu ORDER BY id ASC
SELECT id, title, link, config, internal, published, version, system FROM cms_components
SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id
SELECT u.*, g.is_admin is_admin, p.imageurl as imageurl
                   FROM cms_users u
				   INNER JOIN cms_user_groups g ON g.id = u.group_id
				   INNER JOIN cms_user_profiles p ON p.user_id = u.id
                   WHERE u.id='1' AND u.is_deleted = 0 AND u.is_locked = 0 LIMIT 1
SELECT 1 FROM cms_banlist WHERE ip = '178.214.34.164' AND status=1
DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)
SELECT id as getfield FROM cms_online WHERE sess_id = 'e8b619e23bd3bf0606874fd0035decee' AND ip = '178.214.34.164' LIMIT 1
UPDATE cms_online
                     SET lastdate = NOW(),
                         user_id = '1',
                         viewurl = '/'
                     WHERE (sess_id = 'e8b619e23bd3bf0606874fd0035decee' AND ip = '178.214.34.164')
SELECT id FROM cms_stats WHERE (ip = '178.214.34.164' AND page = '/')
SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'top' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'l_sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'header') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
 
            ORDER BY m.ordering ASC
SELECT id FROM cms_user_msg WHERE to_id = '1' AND to_del = 0 AND is_new = 1
SELECT id, seolink FROM cms_blogs WHERE owner="user" AND user_id = 1 ORDER BY owner LIMIT 1
SELECT c.id as id
                FROM cms_users u
				LEFT JOIN cms_user_groups g ON g.id = u.group_id
				LEFT JOIN cms_category c ON c.modgrp_id = g.id
                WHERE u.id = '1'
                LIMIT 1
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'topmenu') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
 
            ORDER BY m.ordering ASC
SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = '1' ORDER BY id ASC LIMIT 1
SELECT id as getfield FROM cms_menu WHERE parent_id=0 LIMIT 1
SELECT * FROM cms_menu WHERE id = 1 AND NSDiffer = ''
SELECT * FROM cms_menu WHERE NSLeft > 1 AND NSRight < 60 AND NSDiffer = '' ORDER BY NSLeft,ordering
SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
SELECT * FROM cms_filter_rules
SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'maintop1') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
 
            ORDER BY m.ordering ASC
SELECT * FROM cms_board_cats WHERE parent_id=0 ORDER BY id ASC LIMIT 1
UPDATE cms_board_items SET is_vip=0 WHERE DATE(vipdate) <= CURRENT_DATE
SELECT i.*, u.login, u.nickname, cat.title as cat_title, cat.obtypes
 
                FROM cms_board_items i
				 LEFT JOIN cms_users u ON u.id = i.user_id 
 INNER JOIN cms_board_cats cat ON cat.id = i.category_id
                WHERE i.published = 1
                       AND (i.category_id = '10')
 
 
 
 
                ORDER BY is_vip DESC, pubdate DESC
LIMIT 0, 15
SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
SELECT * FROM cms_filter_rules
SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
SELECT  p.title as title,
                        p.id as id,
                        p.seolink as seolink, 
                        b.title as blog,
                        b.owner as owner,
                        b.id as blog_id,
                        b.seolink as bloglink,
                        p.pubdate as fpubdate,
						b.user_id as uid,
                        IFNULL(r.total_rating, 0) as rating,
                        b.ownertype as ownertype,
                        u.id as author_id,
                        u.nickname as author,
                        up.imageurl as author_image,
                        u.is_deleted as author_deleted
				FROM cms_blog_posts p
				LEFT JOIN cms_blogs b ON b.id = p.blog_id
				LEFT JOIN cms_users u ON u.id = p.user_id				
				LEFT JOIN cms_user_profiles up ON up.user_id = p.user_id
                LEFT JOIN cms_ratings_total r ON r.item_id=p.id AND r.target='blogpost'
				WHERE p.published = 1 AND b.allow_who = 'all'
				ORDER BY p.id DESC
                LIMIT 30
SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '59' AND published = 1
SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '58' AND published = 1
SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '57' AND published = 1
SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '56' AND published = 1
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'maintop2') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
 
            ORDER BY m.ordering ASC
SELECT * FROM cms_board_cats WHERE parent_id=0 ORDER BY id ASC LIMIT 1
UPDATE cms_board_items SET is_vip=0 WHERE DATE(vipdate) <= CURRENT_DATE
SELECT i.*, u.login, u.nickname, cat.title as cat_title, cat.obtypes
 
                FROM cms_board_items i
				 LEFT JOIN cms_users u ON u.id = i.user_id 
 INNER JOIN cms_board_cats cat ON cat.id = i.category_id
                WHERE i.published = 1
                       AND (i.category_id = '9')
 
 
 
 
                ORDER BY is_vip DESC, pubdate DESC
LIMIT 0, 12
SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
SELECT * FROM cms_filter_rules
SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
SELECT c.id as id,
                       c.target as target,
                       c.target_id as target_id,
                       c.target_link as target_link, 
					   c.target_title,
                       c.content as content,
                       c.guestname,
                       c.pubdate as fpubdate,
                       IFNULL(c.user_id, 0) as user_id,
                       IFNULL(u.nickname, '') as author,
                       IFNULL(u.login, '') as author_login,
                       IFNULL(v.total_rating, 0) as rating
				FROM cms_comments c
				INNER JOIN cms_users u ON u.id = c.user_id OR c.guestname<>''
                LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
				WHERE c.published=1  AND c.target IN ('blog')
                GROUP BY c.id
                ORDER BY c.id DESC
                LIMIT 70
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'l_sidebar') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
 
            ORDER BY m.ordering ASC
SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
SELECT * FROM cms_filter_rules
SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
SELECT u.id, u.login, u.nickname, u.rating as rating, u.is_deleted, p.karma as karma, p.user_id, p.imageurl, u.status
				FROM cms_users u
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
				WHERE u.is_deleted = 0 AND u.is_locked = 0
				ORDER BY rating DESC

                    
        

                            

                    На машину и квартиру я заработал тут: http://clck.ru/1LXQk                
                                        

                                            

                                                                                        

        

                    
                            
            

    

                    
                0