Время генерации страницы: 0.4390 сек.
Запросы к базе: 79
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 id FROM cms_user_groups WHERE alias = 'guest'
DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)
SELECT id as getfield FROM cms_online WHERE sess_id = 'bb44685b8f414082abf05a715779fadd' AND ip = '38.107.179.211' LIMIT 1
INSERT INTO cms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('38.107.179.211', 'bb44685b8f414082abf05a715779fadd', NOW(), '0', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '/')
SELECT id as getfield FROM cms_map_cats WHERE parent_id=0 LIMIT 1
SELECT * FROM cms_map_cats WHERE id=1 ORDER BY id ASC LIMIT 1
SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                FROM cms_map_cats cat
                LEFT JOIN cms_map_items con ON con.category_id = cat.id AND con.published = 1
                WHERE (cat.parent_id=1) AND cat.published = 1
                GROUP BY cat.id
                ORDER BY title
SELECT con.id
                          FROM cms_map_items con, cms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 6 AND cat.NSRight <= 7) AND con.published = 1
SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                FROM cms_map_cats cat
                LEFT JOIN cms_map_items con ON con.category_id = cat.id AND con.published = 1
                WHERE (cat.parent_id=33) AND cat.published = 1
                GROUP BY cat.id
                ORDER BY title
SELECT con.id
                          FROM cms_map_items con, cms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 2 AND cat.NSRight <= 3) AND con.published = 1
SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                FROM cms_map_cats cat
                LEFT JOIN cms_map_items con ON con.category_id = cat.id AND con.published = 1
                WHERE (cat.parent_id=31) AND cat.published = 1
                GROUP BY cat.id
                ORDER BY title
SELECT con.id
                          FROM cms_map_items con, cms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 4 AND cat.NSRight <= 5) AND con.published = 1
SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                FROM cms_map_cats cat
                LEFT JOIN cms_map_items con ON con.category_id = cat.id AND con.published = 1
                WHERE (cat.parent_id=32) AND cat.published = 1
                GROUP BY cat.id
                ORDER BY title
SELECT  chars.id as id,
                                chars.published as published,
                                chars.title as title,
                                chars.fieldtype as fieldtype,
                                chars.fieldgroup as fieldgroup,
                                chars.is_compare as is_compare,
                                chars.is_filter as is_filter,
                                chars.is_filter_many as is_filter_many,
                                chars.`values` as `values`,
                                chars.bind_all as bind_all,
                                chars.ordering as ordering

                        FROM  cms_map_chars chars

                        WHERE  chars.bind_all = 1

                        ORDER BY chars.ordering ASC
SELECT  chars.id as id,
                            chars.published as published,
                            chars.title as title,
                            chars.fieldtype as fieldtype,                            
                            chars.fieldgroup as fieldgroup,
                            chars.is_compare as is_compare,
                            chars.is_filter as is_filter,
                            chars.is_filter_many as is_filter_many,
                            chars.`values` as `values`,
                            chars.bind_all as bind_all,
                            bind.ordering as ordering

                      FROM  cms_map_chars chars, cms_map_chars_bind bind

                     WHERE  bind.cat_id=1 AND
                            bind.char_id = chars.id

                    ORDER BY bind.ordering ASC
SELECT *
                 FROM cms_map_cats
                 WHERE parent_id > 0 AND published=1
                 ORDER BY NSLeft
SELECT  i.*, m.*, 
                        c.title as category,
                        DATE_FORMAT(i.pubdate, '%d.%m.%Y') as pubdate

                FROM    cms_map_cats c
                        , cms_map_items_cats ic, 
                        cms_map_markers m

                LEFT JOIN cms_map_items i      ON m.item_id = i.id

                WHERE   1=1
                        AND (ic.category_id = c.id AND ic.item_id = i.id)
                         AND (ic.category_id=1)
 AND (i.published=1)


                GROUP BY i.id
SELECT id, marker FROM cms_map_cats
SELECT  DISTINCT i.id,
                        i.*,
                        m.addr_country,
                        m.addr_city,
                        m.addr_prefix,
                        m.addr_street,
                        m.addr_house,
                        m.addr_room,
                        m.addr_hash, 
                        c.title as category,
                        c.marker as marker,
                        c.zoom as zoom,
                        DATE_FORMAT(i.pubdate, '%d.%m.%Y') as pubdate,
                        IFNULL(v.title, '') as vendor,
                        IFNULL(v.id, 0) as vendor_id,
                        IFNULL(cm.item_id, 0) as is_in_compare
                        , ic.ordering as ordering

                FROM    cms_map_cats c
                        , cms_map_items_cats ic,
                        cms_map_markers m

                LEFT JOIN cms_map_items i      ON m.item_id = i.id
                LEFT JOIN cms_map_vendors v    ON i.vendor_id = v.id
                LEFT JOIN cms_map_compare cm   ON i.id = cm.item_id AND cm.session_id = 'bb44685b8f414082abf05a715779fadd'

                WHERE   i.published = 1
                        AND (ic.category_id = c.id AND ic.item_id = i.id)
                         AND (ic.category_id=1)
 AND (i.published=1)


                GROUP BY i.id

                ORDER BY ordering asc
LIMIT 0, 10
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.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'page_top_right') 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 *, 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 < 18 AND NSDiffer = '' ORDER BY NSLeft,ordering
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'maintop') 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  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 = '28' AND published = 1
SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '27' AND published = 1
SELECT NSLeft, NSRight FROM cms_category WHERE id='15' ORDER BY id ASC LIMIT 1
SELECT con.*,
                       con.pubdate as fdate,
                       u.nickname as author,
                       u.login as author_login
                       FROM cms_content con
				       LEFT JOIN cms_category cat ON cat.id = con.category_id
				       LEFT JOIN cms_users u ON u.id = con.user_id
                       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2012-05-21 11:22:35'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2012-05-21 11:22:35'))
                      AND (cat.NSLeft >= 14 AND cat.NSRight <= 15)
				ORDER BY con.pubdate DESC
				LIMIT 10
SELECT 1
					FROM cms_content con
					LEFT JOIN cms_category cat ON cat.id = con.category_id
					WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2012-05-21 11:22:35' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2012-05-21 11:22:35')) AND (cat.NSLeft >= 14 AND cat.NSRight <= 15)
SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'maintop_left' 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 = 'maintop_right' 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 = 'mainbottom') 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
SELECT access FROM cms_user_groups WHERE id = 8 LIMIT 1
SELECT access FROM cms_user_groups WHERE id = 8 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
                      

                                      

                ORDER BY is_vip DESC, pubdate DESC
LIMIT 0, 10
SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'module_last_articles' 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 = 'module_last_articles' 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 = 'module_last_post' 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 = 'module_last_forum' 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 = 'module_last_comments' 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 = 'module_last_articles') 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 FROM cms_category WHERE id='6' ORDER BY id ASC LIMIT 1
SELECT con.*,
                       con.pubdate as fdate,
                       u.nickname as author,
                       u.login as author_login
                       FROM cms_content con
				       LEFT JOIN cms_category cat ON cat.id = con.category_id
				       LEFT JOIN cms_users u ON u.id = con.user_id
                       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2012-05-21 11:22:35'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2012-05-21 11:22:35'))
                      AND (cat.NSLeft >= 4 AND cat.NSRight <= 13)
				ORDER BY con.pubdate DESC
				LIMIT 4
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'module_last_post') 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 *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'module_last_comments') 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 *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'module_last_forum') 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 *, m.id as mid, m.template as tpl
            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)
                  
            ORDER BY m.ordering ASC
SELECT id, marker FROM cms_map_cats
SELECT  DISTINCT i.id,
                        i.*,
                        m.addr_country,
                        m.addr_city,
                        m.addr_prefix,
                        m.addr_street,
                        m.addr_house,
                        m.addr_room,
                        m.addr_hash, 
                        c.title as category,
                        c.marker as marker,
                        c.zoom as zoom,
                        DATE_FORMAT(i.pubdate, '%d.%m.%Y') as pubdate,
                        IFNULL(v.title, '') as vendor,
                        IFNULL(v.id, 0) as vendor_id,
                        IFNULL(cm.item_id, 0) as is_in_compare
                        

                FROM    cms_map_cats c
                        ,
                        cms_map_markers m

                LEFT JOIN cms_map_items i      ON m.item_id = i.id
                LEFT JOIN cms_map_vendors v    ON i.vendor_id = v.id
                LEFT JOIN cms_map_compare cm   ON i.id = cm.item_id AND cm.session_id = 'bb44685b8f414082abf05a715779fadd'

                WHERE   i.published = 1
                        

                GROUP BY i.id

                ORDER BY i.rating desc
LIMIT 0, 10
SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM cms_map_markers WHERE item_id=31
SELECT 1 FROM cms_comments WHERE target='mapitem' AND target_id='31'
SELECT 1 FROM cms_map_ratings WHERE item_id=31 AND user_id=0 LIMIT 1
SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM cms_map_markers WHERE item_id=32
SELECT 1 FROM cms_comments WHERE target='mapitem' AND target_id='32'
SELECT 1 FROM cms_map_ratings WHERE item_id=32 AND user_id=0 LIMIT 1
SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM cms_map_markers WHERE item_id=36
SELECT 1 FROM cms_comments WHERE target='mapitem' AND target_id='36'
SELECT 1 FROM cms_map_ratings WHERE item_id=36 AND user_id=0 LIMIT 1
SELECT  DISTINCT i.id,
                        i.*,
                        o.title as obj_title,
                        o.seolink as obj_seolink,
                        o.contacts as obj_contacts,
                        m.addr_city as obj_city,
                        m.addr_street as obj_street,
                        m.addr_prefix as obj_prefix,
                        m.addr_house as obj_house,
                        m.addr_room as obj_room

                FROM    cms_map_cats c,
                        
                        cms_map_news i

                LEFT JOIN cms_map_markers m ON i.item_id = m.item_id
                LEFT JOIN cms_map_items o ON i.item_id = o.id

                WHERE   1=1
                        

                GROUP BY i.id

                ORDER BY i.pubdate DESC
LIMIT 10
SELECT i.id,
                        i.seolink,
                        i.title,
                        i.pubdate as pubdate,
                        m.addr_country,
                        m.addr_city,
                        m.addr_prefix,
                        m.addr_street,
                        m.addr_house,
                        m.addr_room,
                        c.marker as marker
            FROM cms_map_items i
            LEFT JOIN cms_map_cats c ON c.id = i.category_id
            LEFT JOIN cms_map_markers m ON m.item_id = i.id
            WHERE i.published = 1 AND m.addr_city = ''
            ORDER BY i.pubdate desc
            LIMIT 0, 10
SELECT  DISTINCT i.id,
                        i.*,
                        o.title as obj_title,
                        o.seolink as obj_seolink,
                        m.addr_city as obj_city,
                        DATE_FORMAT(i.date_start, '%d.%m.%Y') as date_start,
                        DATE_FORMAT(i.date_end, '%d.%m.%Y') as date_end,
                        DATEDIFF(i.date_start, NOW()) as days_to_start,
                        DATEDIFF(i.date_end, NOW()) as days_to_end

                FROM    cms_map_cats c,
                        
                        cms_map_events i

                LEFT JOIN cms_map_markers m ON i.item_id = m.item_id
                LEFT JOIN cms_map_items o ON i.item_id = o.id
                        
                WHERE   ((date_start >= '2012-05-21 00:00:00' AND date_start <= '2013-05-21 23:59:59') OR
                        (date_end >= '2012-05-21 00:00:00' AND date_end <= '2013-05-21 23:59:59') OR
                        (date_start <= '2012-05-21 00:00:00' AND date_end >= '2013-05-21 23:59:59'))
                        

                GROUP BY i.id

                
LIMIT 10
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 
                LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
				WHERE c.published=1 AND c.is_hidden=0 AND c.target IN ('faq','catalog','boarditem','blog','article','palbum','photo','userphoto')
                GROUP BY c.id
                ORDER BY c.id DESC
                LIMIT 70
SELECT cat.*, COUNT(con.id) as content_count 
				FROM cms_category cat, cms_content con
				WHERE (cat.parent_id = 13 AND cat.id > 0) AND con.category_id = cat.id AND cat.published = 1
				GROUP BY con.category_id
				ORDER BY cat.title DESC
SELECT		        
				o.user_id as id,
				u.login,
				u.nickname,
				p.gender as gender
				FROM cms_online o
                LEFT JOIN cms_users u ON  u.id = o.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
				WHERE u.is_locked = 0 AND u.is_deleted = 0
                GROUP BY o.user_id
SELECT 1 FROM cms_online WHERE user_id = 0 OR user_id = ''
SELECT u.id as id, u.nickname as nickname, u.login as login, p.gender as gender
                FROM cms_users u
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                WHERE u.is_locked = 0 AND u.is_deleted = 0 AND DATE_FORMAT(u.logdate, '%Y-%m-%d')='2012-05-21'
                ORDER BY u.logdate DESC
SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'sidebar_left') 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 *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'sidebar_right') 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