Сообщить об ошибке

Объект: Магазин сантехники "Сантехкомплект"
Текст сообщения:

← оБЪБД

Время генерации страницы: 0.3128 сек.
Запросы к базе: 49
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 = 'a79bc89c9c70a37dd6ae6185d8f6d1c7' AND ip = '54.156.92.46' LIMIT 1

INSERT INTO icms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.156.92.46', 'a79bc89c9c70a37dd6ae6185d8f6d1c7', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/maps/abuse108.html')

SELECT id FROM icms_stats WHERE (ip = '54.156.92.46' AND page = '/maps/abuse108.html')

INSERT INTO icms_stats (ip, logdate, page, agent, refer) VALUES ('54.156.92.46', NOW(), '/maps/abuse108.html', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')

SELECT NSLeft, NSRight FROM icms_menu WHERE id = '47'

SELECT id, title, link, linktype
                           FROM icms_menu
                           WHERE NSLeft <= 6 AND NSRight >= 7 AND parent_id > 0
                           ORDER BY NSLeft

SELECT 1 FROM icms_map_abuses WHERE item_id='108' AND ip='54.156.92.46' LIMIT 1

SELECT i.*, 
                       DATE_FORMAT(i.pubdate, '%d.%m.%Y') as pubdate,
                       IFNULL(v.title, '') as vendor,
                       u.nickname as user_name,
                       u.login as user_login,
                       m.id as marker_id, 
                       m.addr_country,
                       m.addr_city,
                       m.addr_prefix,
                       m.addr_street,
                       m.addr_house,
                       m.addr_room,
                       m.lat,
                       m.lng
                FROM icms_map_items i
                LEFT JOIN icms_map_markers m ON i.id = m.item_id
                LEFT JOIN icms_map_vendors v ON i.vendor_id = v.id
                LEFT JOIN icms_users u ON i.user_id = u.id
                WHERE i.id = 108
                LIMIT 1

SELECT addr_country,
                       addr_city,
                       addr_prefix,
                       addr_street,
                       addr_house,
                       addr_room,
                       lat,
                       lng, 
                       id
                FROM icms_map_markers
                WHERE item_id = 108

SELECT n.*,
                          u.id as user_id
                   FROM icms_map_news n,
                        icms_map_items i,
                        icms_users u
                   WHERE n.item_id = i.id AND i.user_id = u.id AND n.item_id = '108'
                   ORDER BY n.pubdate DESC
                   LIMIT 15

SELECT n.*,
                          DATE_FORMAT(n.date_start, '%d.%m.%Y') as date_start,
                          DATE_FORMAT(n.date_end, '%d.%m.%Y') as date_end,
                          DATEDIFF(n.date_start, NOW()) as days_to_start,
                          DATEDIFF(n.date_end, NOW()) as days_to_end,
                          IFNULL(n.user_id, 0) as user_id,
                          IFNULL(u.login, '') as user_login,
                          IFNULL(u.nickname, '') as user_name
                   FROM icms_map_events n
                   LEFT JOIN icms_users u ON u.id = n.user_id
                   WHERE n.item_id = '108'
                   ORDER BY n.date_end ASC
                   LIMIT 15

SELECT 1 FROM icms_map_attend WHERE object_type='item' AND object_id='108' AND user_id='0' LIMIT 1

SELECT  u.nickname as nickname,
                        u.login as login,
                        p.gender as gender,
                        a.user_id as id

                FROM    icms_users u, icms_user_profiles p, icms_map_attend a

                WHERE   a.user_id = u.id AND p.user_id = u.id
                  AND   a.object_type = 'item' AND a.object_id = '108'

SELECT 1 FROM icms_map_abuses WHERE item_id='108' AND ip='54.156.92.46' LIMIT 1

SELECT * FROM icms_map_cats WHERE id=37 ORDER BY id ASC LIMIT 1

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='108'

SELECT 1 FROM icms_map_ratings WHERE item_id=108 AND user_id=0 LIMIT 1

SELECT cat.title as title, cat.seolink as seolink, ic.category_id as category_id
                           FROM icms_map_items_cats ic, icms_map_cats cat
                           WHERE ic.item_id=108 AND ic.category_id = cat.id

SELECT id, addr_country, addr_city, addr_street, addr_prefix, addr_house, addr_room, lat, lng
                     FROM icms_map_markers
                     WHERE item_id=108
                     ORDER BY addr_city, addr_street, addr_house

SELECT id, lat, lng FROM icms_map_markers WHERE item_id=108 AND addr_city = '' ORDER BY id ASC LIMIT 1

SELECT  chars.id as id,
                        chars.title as title,
                        chars.is_compare as is_compare,
                        chars.fieldtype as fieldtype,
                        chars.fieldgroup as fieldgroup,
                        val.val as value

                 FROM  icms_map_chars chars

                 LEFT JOIN icms_map_chars_bind bind ON bind.cat_id=37 AND bind.char_id = chars.id
                 LEFT JOIN icms_map_chars_val val ON val.char_id = chars.id AND val.item_id = 108

                 WHERE  ((bind.cat_id=37 AND bind.char_id = chars.id) OR (chars.bind_all=1))
                        AND chars.published = 1

                ORDER BY chars.fieldgroup DESC, bind.ordering ASC

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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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 = '47' 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