Отладочная информация:
Время генерации страницы:
Time: 0.067 sec.
QUERY STRING:
Шаблон страницы:
_index14.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM shop_rus_pages USE INDEX (PRIMARY) WHERE id = 1
[1] => SELECT pb.*, pb.id as block_id, m.name, m.title, m.id as mod_id, p.usr_group_id, number_of_fields, IF(p.owner_id = 0, 1 , 0) as is_owner,
IF(p.owner_id = 0,
p.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(p.rights & 0xF0) >> 4,
p.rights & 0xF
)
) AS user_rights FROM shop_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , shop_rus_pages_blocks as pb , shop_rus_pages_templates as pt , modules as m WHERE p.id = 1
AND p.tpl_id = pt.id AND p.id = pb.page_id
AND m.id = pb.module_id AND IF( p.owner_id = 0,
p.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(p.rights & 0xF0) >> 4,
p.rights & 0xF
)
) > 0 ORDER BY field_number, block_rank
[2] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[3] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644595570 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[4] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM shop_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 53 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2010-03-10' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[5] => SELECT * FROM shop_rus_banners WHERE id=34
[6] => UPDATE shop_rus_banners SET showing = showing + 1 WHERE id = 34
[7] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[8] => SELECT p.*, pt.ptype_name, pt.link as ptype_link, if(c.alias is not null and c.alias!='', c.alias, c.id) as ctg_alias,
if(p.alias is not null and p.alias!='', p.alias, p.id) as prod_alias
FROM shop_rus_catalog_products p INNER JOIN shop_rus_catalog_categories c ON c.id=p.category_id
LEFT JOIN shop_rus_catalog_ptypes pt ON p.ptype_id = pt.id
WHERE 1 AND p.active = 1 AND novelty
ORDER BY p.rank DESC
[9] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[10] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[11] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[12] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[13] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[14] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[15] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[16] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[17] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[18] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[19] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[20] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[21] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[22] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[23] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[24] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[25] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[26] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[27] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[28] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[29] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[30] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[31] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[32] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[33] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[34] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[35] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[36] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[37] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[38] => SELECT rank, sum(percent) value FROM shop_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[39] => SELECT prod_id, prop_val_id FROM shop_rus_catalog_order_prop_val WHERE prod_id IN (174,173,171,168,167,163,161,159,155,151,149,146,142,136,135)
[40] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[41] => SELECT a.*, IF(a.owner_id = 0, 1 , 0) as is_owner,
IF(a.owner_id = 0,
a.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(a.rights & 0xF0) >> 4,
a.rights & 0xF
)
) AS user_rights FROM shop_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 45 AND active=1 AND IF( a.owner_id = 0,
a.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(a.rights & 0xF0) >> 4,
a.rights & 0xF
)
) > 0
[42] => SELECT id, title, commentable FROM shop_rus_articles WHERE id=45 AND commentable>0
[43] => SELECT * FROM shop_rus_comments_resource WHERE type=4 AND item_id=45
[44] => SELECT * FROM shop_rus_comments_resource WHERE type=4 AND item_id=45
[45] => UPDATE shop_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='45'
[46] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[47] => UPDATE core_users SET onsite=0 WHERE last_visit SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[49] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644595570 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[50] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM shop_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 55 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2010-03-10' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[51] => SELECT * FROM shop_rus_banners WHERE id=32
[52] => UPDATE shop_rus_banners SET showing = showing + 1 WHERE id = 32
[53] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[54] => SELECT pcm.*, pcmi.page_id, p.id, p.title, p.address, p.link, p.img1, p.img2, p.img3
FROM shop_rus_pages_context_menu as pcm, shop_rus_pages_context_menu_items as pcmi, shop_rus_pages as p
WHERE pcm.id = 3 AND pcmi.menu_id = 3 AND p.id = pcmi.page_id AND p.active = 1
ORDER BY pcmi.item_rank
[55] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[56] => SELECT a.*, IF(a.owner_id = 0, 1 , 0) as is_owner,
IF(a.owner_id = 0,
a.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(a.rights & 0xF0) >> 4,
a.rights & 0xF
)
) AS user_rights FROM shop_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 48 AND active=1 AND IF( a.owner_id = 0,
a.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(a.rights & 0xF0) >> 4,
a.rights & 0xF
)
) > 0
[57] => SELECT id, title, commentable FROM shop_rus_articles WHERE id=48 AND commentable>0
[58] => SELECT * FROM shop_rus_comments_resource WHERE type=4 AND item_id=48
[59] => SELECT * FROM shop_rus_comments_resource WHERE type=4 AND item_id=48
[60] => UPDATE shop_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='48'
[61] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[62] => SELECT * FROM shop_rus_catalog_groups
[63] => SELECT g.id, p.property_id FROM shop_rus_catalog_groups g
LEFT JOIN shop_rus_catalog_properties p ON g.id=p.group_id AND p.search=1
ORDER BY g.id, property_id
[64] => SELECT DISTINCT p.property_id, p.range, pt.property_title, pt.property_name, pt.property_prefix, pt.property_suffix, pt.type, pdv.value
FROM shop_rus_catalog_properties p
JOIN shop_rus_catalog_properties_table pt
LEFT JOIN shop_rus_catalog_properties_def_values pdv ON p.property_id = pdv.property_id
WHERE p.search = 1
AND p.property_id = pt.id
ORDER BY p.ord, pdv.value
[65] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[66] => SELECT count(*) as cnt FROM shop_rus_news n LEFT JOIN shop_rus_news_themes t ON n.theme_id = t.id LEFT JOIN core_users_groups ug ON (ug.group_id = n.usr_group_id AND ug.user_id = 0) WHERE n.date <= NOW() AND n.active = 1 AND IF( n.owner_id = 0,
n.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(n.rights & 0xF0) >> 4,
n.rights & 0xF
)
) > 0
[67] => SELECT n.id, n.title, t.title as theme_title, n.announce, n.active, n.rss_link, n.announce_with_links, NOW() as d, DATE_FORMAT(date,'%d.%m.%Y') as news_date, n.img, IF(n.owner_id = 0, 1 , 0) as is_owner,
IF(n.owner_id = 0,
n.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(n.rights & 0xF0) >> 4,
n.rights & 0xF
)
) AS user_rights FROM shop_rus_news n LEFT JOIN shop_rus_news_themes t ON n.theme_id = t.id LEFT JOIN core_users_groups ug ON (ug.group_id = n.usr_group_id AND ug.user_id = 0) WHERE n.date <= NOW() AND n.active = 1 AND IF( n.owner_id = 0,
n.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(n.rights & 0xF0) >> 4,
n.rights & 0xF
)
) > 0 GROUP BY n.id ORDER BY date DESC LIMIT 0,10
[68] => SELECT C.id FROM shop_rus_news_ctgr NC INNER JOIN shop_rus_news_categories C ON C.id=NC.ctgr_id WHERE news_id IN (132,131,128) AND rss_auto_update AND (DATE_ADD(`rss_last_update`, INTERVAL `rss_update_interval` MINUTE) < NOW() OR `rss_last_update` IS NULL)
[69] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[70] => SELECT * FROM shop_rus_pages USE INDEX (index_2) WHERE ((parent_id = 0 OR branch!="" ) AND active = 1) OR is_default = 1 ORDER BY level, page_rank DESC
[71] => SELECT id, parent_id, title, address
FROM shop_rus_pages USE INDEX (index_3)
WHERE parent_id IN (218,139,259,266,277,198,210,152,267,271,260,261,263,272,265,209,278) AND
active = 1
ORDER BY page_rank desc
[72] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
[73] => SELECT permission_type FROM shop_rus_pages USE INDEX (PRIMARY) WHERE id = 1
[74] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='shop' AND S.id = site_id AND M.id=module_id AND active
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[1527] => $PAGE["modules"]["banners"] = new Banners('showbanner', '/index/?', Array
(
[1] => 53
[2] => 1
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_gif.html
[1531] => $PAGE["modules"]["catalog"] = new Catalog('novelties', '/catalog/?', Array
(
[1] =>
[2] => all
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - catalog_novelties.html
[1542] => $PAGE["modules"]["article"] = new Article('showarticle', '/index/?', Array
(
[1] => 45
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - article.html
[1459] => $PAGE["modules"]["siteusers"] = new Siteusers('loginform', '/siteusers/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - siteusers_loginform.html
[1485] => $PAGE["modules"]["banners"]->Banners('showbanner', '/index/?', Array
(
[1] => 55
[2] => 1
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_flash.html
[1363] => $PAGE["modules"]["pages"] = new Pages('cmenu', '/index/?', Array
(
[1] =>
[2] => 3
[3] =>
[4] =>
[5] =>
[tpl] => pages_cm_menu_shop.html
)
), tpl - pages_cm_menu_shop.html
[1547] => $PAGE["modules"]["article"]->Article('showarticle', '/index/?', Array
(
[1] => 48
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - article.html
[1492] => $PAGE["modules"]["catalog"]->Catalog('showsearchform', '/catalog/?', Array
(
[1] =>
[2] =>
[3] => all
[4] => stdClass Object
(
[name] =>
[code] =>
[ptype] =>
[price] =>
[group] => 1
[availability] =>
[sort] => 1
)
[5] =>
[tpl] =>
)
), tpl - catalog_searchform.html
[1544] => $PAGE["modules"]["news"] = new News('alist', '/about/news/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] => news_announces_block.html
)
), tpl - news_announces_block.html
[-1] => $PAGE["modules"]["pages"]->Pages('showmenu', '', Array
(
)
), tpl - pages_menu.html
[-3] => $PAGE["modules"]["pages"]->Pages('showheadtitle', '', Array
(
)
), tpl - pages_title.html
[-4] => $PAGE["modules"]["pages"]->Pages('showpath', '', Array
(
)
), tpl - pages_path.html
)
Переменные сессии:
Array
(
[session_cur_site_id] => 6
[session_cur_lang_id] => 6
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 30.0785
[RUR/USD] => 0.0332463387469
[EUR/EUR] => 1
[EUR/RUR] => 44.0259
[RUR/EUR] => 0.0227139024983
[EUR/USD] => 1.4637
[USD/EUR] => 0.683200109312
)
)
Last-modified:
Tue, 09 Mar 2010 22:39:28
