Время генерации страницы: 0.2927 сек.
Запросы к базе: 43
SET NAMES cp1251

SELECT * FROM icms_menu ORDER BY id ASC

SELECT id, title, link, config, internal, published, version, system FROM icms_components

SELECT p.id, p.plugin, p.config, e.event FROM icms_plugins p, icms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id

SELECT id FROM icms_user_groups WHERE alias = 'guest'

DELETE FROM icms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)

SELECT id as getfield FROM icms_online WHERE sess_id = '758edf90aa509e1140b6281f9988290b' AND ip = '54.80.93.234' LIMIT 1

INSERT INTO icms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.80.93.234', '758edf90aa509e1140b6281f9988290b', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/catalog/1021')

SELECT id FROM icms_stats WHERE (ip = '54.80.93.234' AND page = '/catalog/1021')

INSERT INTO icms_stats (ip, logdate, page, agent, refer) VALUES ('54.80.93.234', NOW(), '/catalog/1021', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')

SELECT * FROM icms_uc_cats WHERE id = 1021

SELECT id, title, NSLevel
                FROM icms_uc_cats
                WHERE NSLeft <= 37 AND NSRight >= 38 AND parent_id > 0
                ORDER BY NSLeft

SELECT cat.*
                FROM icms_uc_cats cat
                WHERE cat.parent_id = '1021' AND cat.published = 1
                ORDER BY cat.title

SELECT 1 FROM icms_uc_cart WHERE (user_id=0 AND session_id='758edf90aa509e1140b6281f9988290b')

SELECT i.* , IFNULL(AVG( r.points ), 0) AS rating, i.price as price
                        FROM icms_uc_items i 
                        LEFT JOIN icms_uc_ratings r ON r.item_id = i.id 
                        WHERE i.published = 1 AND (i.category_id = 1021 OR 1021=1014)
                        GROUP BY i.id ORDER BY pubdate desc

SELECT i.* , IFNULL(AVG( r.points ), 0) AS rating, i.price as price
                        FROM icms_uc_items i 
                        LEFT JOIN icms_uc_ratings r ON r.item_id = i.id 
                        WHERE i.published = 1 AND (i.category_id = 1021 OR 1021=1014)
                        GROUP BY i.id ORDER BY pubdate desc LIMIT 0, 21

SELECT login, nickname, id FROM icms_users WHERE id='43534' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=417

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 417
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1021 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 417 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'top' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'left' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'user1' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'user3' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'topmenu') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM icms_menu WHERE id = '0' ORDER BY id ASC LIMIT 1

SELECT id as getfield FROM icms_menu WHERE parent_id=0 LIMIT 1

SELECT * FROM icms_menu WHERE id = 1 AND NSDiffer = ''

SELECT * FROM icms_menu WHERE NSLeft > 1 AND NSRight < 28 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'top') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'maintop') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'mainbottom') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'footer1') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM icms_menu WHERE id = '0' ORDER BY id ASC LIMIT 1

SELECT id as getfield FROM icms_menu WHERE parent_id=0 LIMIT 1

SELECT * FROM icms_menu WHERE id = 1 AND NSDiffer = ''

SELECT * FROM icms_menu WHERE NSLeft > 1 AND NSRight < 28 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'footer2') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '0' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT * FROM icms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM icms_filter_rules

SELECT id as getfield FROM icms_content WHERE seolink='' LIMIT 1