Красота

← оБЪБД

Время генерации страницы: 0.3429 сек.
Запросы к базе: 95
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 = '337156db3291bc31a1f87f693011b8b2' AND ip = '54.81.110.114' LIMIT 1

INSERT INTO icms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.81.110.114', '337156db3291bc31a1f87f693011b8b2', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/catalog/1006')

SELECT id FROM icms_stats WHERE (ip = '54.81.110.114' AND page = '/catalog/1006')

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

SELECT * FROM icms_uc_cats WHERE id = 1006

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

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

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 14 AND cat.NSRight <= 15) AND con.published = 1

SELECT 1 FROM icms_uc_cart WHERE (user_id=0 AND session_id='337156db3291bc31a1f87f693011b8b2')

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 = 1006 OR 1006=1014)
                        GROUP BY i.id ORDER BY pubdate desc

SELECT 1 FROM icms_uc_cats_access WHERE cat_id=1006 AND group_id=8 LIMIT 1

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 = 1006 OR 1006=1014)
                        GROUP BY i.id ORDER BY pubdate desc LIMIT 0, 21

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=317

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=319

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=393

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=377

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=304

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=320

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=316

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=309

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=308

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=306

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

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

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

SELECT login, nickname, id FROM icms_users WHERE id='279' 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=305

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

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

SELECT id FROM icms_uc_items WHERE id = 305 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