Отладочная информация:
Время генерации страницы:
Time: 0.185 sec.
QUERY STRING:
lang=&link;=catalog/kupit_remen/1270j5.html
Шаблон страницы:
_index1.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM rems_rus_pages USE INDEX (PRIMARY) WHERE id = 139
[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 rems_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , rems_rus_pages_blocks as pb , rems_rus_pages_templates as pt , modules as m WHERE p.id = 139
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='rems' AND S.id = site_id AND M.id=module_id AND active
[3] => select P.id, if(P.alias is not null and P.alias!='',P.alias,P.id) AS prod_alias, if(C.alias is not null and C.alias!='',C.alias,C.id) AS ctgr_alias FROM`rems_rus_catalog_products` P INNER JOIN `rems_rus_catalog_categories` C ON P.category_id=C.id HAVING prod_alias='1270j5' AND ctgr_alias='kupit_remen'
[4] => SELECT a.id AS id,
a.category_id AS category_id,
a.group_id AS group_id,
a.ptype_id AS ptype_id,
a.product_code AS product_code,
a.product_title AS product_title,
a.product_inf AS product_inf,
a.product_description AS product_description,
a.currency AS currency,
a.price_1 AS price_1,
a.price_2 AS price_2,
a.price_3 AS price_3,
a.price_4 AS price_4,
a.price_5 AS price_5,
a.image_middle AS image_middle,
a.image_big AS image_big,
a.product_availability AS product_availability,
a.active AS active,
a.rank AS rank,
a.forum_theme AS forum_theme,
a.description AS description,
a.keywords AS keywords,
if(a.alias is not null and a.alias!='', a.alias, a.id) as product_alias,
b.ptype_name AS ptype_title,
b.link AS ptype_link,
c.title AS categ_title,
d.group_title AS prod_grp,
c.page_description AS ctg_description,
c.keywords AS ctg_keywords,
if(c.alias is not null and c.alias!='', c.alias, c.id) as ctg_alias
FROM rems_rus_catalog_products a
INNER JOIN rems_rus_catalog_categories c ON a.category_id = c.id
LEFT JOIN rems_rus_catalog_ptypes b ON a.ptype_id = b.id
LEFT JOIN rems_rus_catalog_groups d ON d.id = a.group_id
WHERE a.id = 126 AND a.active = 1
[5] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[6] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[7] => SELECT P.id, product_title, category_id, C.cleft, C.cright FROM rems_rus_catalog_products P INNER JOIN rems_rus_catalog_categories C ON category_id=C.id WHERE P.id=126
[8] => SELECT commentable FROM rems_rus_catalog_categories WHERE cleft<=7 AND cright>=8 AND commentable>0 ORDER BY cright LIMIT 1
[9] => SELECT * FROM rems_rus_comments_resource WHERE type=1 AND item_id=126
[10] => SELECT * FROM rems_rus_comments_resource WHERE type=1 AND item_id=126
[11] => UPDATE core_users SET last_visit=NOW(), onsite=0 WHERE last_visit SELECT v.property_id, v.value AS value, t.property_title AS title, t.property_name AS name, t.property_prefix AS prefix, t.property_suffix AS suffix
FROM rems_rus_catalog_products AS prod,
rems_rus_catalog_property_values AS v,
rems_rus_catalog_properties_table AS t,
rems_rus_catalog_properties AS p
WHERE prod.id=126 AND v.product_id = prod.id AND
v.property_id = t.id AND p.property_id=v.property_id
AND p.group_id=prod.group_id
ORDER BY p.ord
[13] => SELECT *
FROM rems_rus_catalog_property_images
WHERE product_id = 126 AND
img_type = 1
ORDER BY property_id, img_pos DESC
[14] => SELECT *
FROM rems_rus_catalog_property_images
WHERE product_id = 126 AND
img_type = 2
ORDER BY property_id, img_pos DESC
[15] => SELECT C.*, product_title, product_code, category_id, product_inf, currency, price_1, price_2, price_3, price_4, price_5, image_middle, image_big, product_availability, P.active, leader, novelty, ptype_name, PT.link AS ptype_link, if(P.alias is not null and P.alias!='', P.alias, P.id) as prod_alias, if(CT.alias is not null and CT.alias!='', CT.alias, CT.id) as ctg_alias FROM rems_rus_catalog_concerned_products AS C INNER JOIN rems_rus_catalog_products AS P ON C.concrn_id = P.id INNER JOIN rems_rus_catalog_categories CT ON CT.id=P.category_id LEFT JOIN rems_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id WHERE C.prod_id = 126 AND P.active ORDER BY P.rank
[16] => UPDATE rems_rus_catalog_products SET hits=IF(hits > 0, hits + 1, 1) WHERE id='126'
[17] => SELECT p.id, if(p.alias is not null and p.alias!='', p.alias, p.id) as alias, 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 rems_rus_catalog_products AS p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0) WHERE category_id = 68 AND active=1 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 rank, ptype_id
[18] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[19] => SELECT C.id, C.parent_id, C.title, C.clevel, C.rank, COUNT(P.id) as cnt, if(C.alias is not null and C.alias!='', C.alias, C.id) as alias FROM rems_rus_catalog_categories AS C
LEFT JOIN rems_rus_catalog_categories AS C1 ON ( C1.cleft >= C.cleft AND C1.cright <= C.cright)
LEFT JOIN rems_rus_catalog_products AS P ON category_id=C1.id AND P.active=1 WHERE C.active=1
GROUP BY C.id ORDER BY C.rank, C.id
[20] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[21] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 3438076626 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[22] => 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 rems_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 = 54 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2010-08-20' 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
[23] => SELECT * FROM rems_rus_banners WHERE id=42
[24] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 42
[25] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[26] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 3438076626 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[27] => 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 rems_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 = 58 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2010-08-20' 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
[28] => SELECT * FROM rems_rus_banners WHERE id=47
[29] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 47
[30] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[31] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[32] => SELECT * FROM rems_rus_catalog_ptypes ORDER BY id
[33] => SELECT * FROM rems_rus_catalog_groups
[34] => SELECT g.id, p.property_id FROM rems_rus_catalog_groups g
LEFT JOIN rems_rus_catalog_properties p ON g.id=p.group_id AND p.search=1
ORDER BY g.id, property_id
[35] => SELECT DISTINCT p.property_id, p.range, pt.property_title, pt.property_name, pt.property_prefix, pt.property_suffix, pt.type, pdv.value
FROM rems_rus_catalog_properties p
JOIN rems_rus_catalog_properties_table pt
LEFT JOIN rems_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
[36] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[37] => SELECT S.id FROM rems_rus_catalog_categories AS P INNER JOIN rems_rus_catalog_categories AS S ON S.cleft BETWEEN P.cleft AND P.cright WHERE P.id=126
[38] => 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 rems_rus_catalog_products p INNER JOIN rems_rus_catalog_categories c ON c.id=p.category_id
LEFT JOIN rems_rus_catalog_ptypes pt ON p.ptype_id = pt.id
WHERE 1 AND p.active = 1 AND leader
ORDER BY p.rank DESC LIMIT 0,3
[39] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[40] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[41] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[42] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[43] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[44] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[45] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[46] => 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 rems_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 4 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
[47] => SELECT id, title, commentable FROM rems_rus_articles WHERE id=4 AND commentable>0
[48] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=4
[49] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=4
[50] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='4'
[51] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[52] => SELECT *
FROM rems_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
[53] => SELECT id, parent_id, title, address
FROM rems_rus_pages USE INDEX (index_3)
WHERE parent_id IN (210,152,218,314,261,298,286,287,300,301,312,139,262,206,264,280,219,291,323,205,325,216,198,265,277,307,302,303,336,304,306,305,311,288,214,237,200,208,253,246,250,244,251,211,315,212,271,275,273,272,274,320,321,322,332,333,334,335,207,290,258,293,292,295,317,318,278,326,328,327,330,276,269,296,331) AND
active = 1
ORDER BY page_rank desc
[54] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[55] => SELECT id, parent_id, title, address
FROM rems_rus_pages USE INDEX (index_3)
WHERE parent_id IN (210,152,218,314,261,298,286,287,300,301,312,139,262,206,264,280,219,291,323,205,325,216,198,265,277,307,302,303,336,304,306,305,311,288,214,237,200,208,253,246,250,244,251,211,315,212,271,275,273,272,274,320,321,322,332,333,334,335,207,290,258,293,292,295,317,318,278,326,328,327,330,276,269,296,331) AND
active = 1
ORDER BY page_rank desc
[56] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[57] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
[58] => SELECT permission_type FROM rems_rus_pages USE INDEX (PRIMARY) WHERE id = 139
[59] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='rems' AND S.id = site_id AND M.id=module_id AND active
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[178] => $PAGE["modules"]["catalog"] = new Catalog('assortment', '/catalog/?', Array
(
[1] =>
[2] => 1
[3] => 1
[4] =>
[5] =>
)
)
[1041] => $PAGE["modules"]["catalog"]->Catalog('showtree', '/catalog/?', Array
(
[1] => 3
[2] => all
[3] => 1
[4] =>
[5] =>
)
)
[1719] => $PAGE["modules"]["banners"] = new Banners('showbanner', '/catalog/?', Array
(
[1] => 54
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[1703] => $PAGE["modules"]["banners"]->Banners('showbanner', '/catalog/?', Array
(
[1] => 58
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[497] => $PAGE["modules"]["siteusers"] = new Siteusers('loginform', '/community/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[2286] => $PAGE["modules"]["catalog"]->Catalog('showsearchform', '/catalog/?', Array
(
[1] => 3
[2] => 74
[3] => all
[4] =>
[5] =>
)
)
[2287] => $PAGE["modules"]["catalog"]->Catalog('showleaders', '/catalog/?', Array
(
[1] => 3
[2] => all
[3] =>
[4] =>
[5] =>
)
)
[777] => $PAGE["modules"]["article"] = new Article('showarticle', '/catalog/?', Array
(
[1] => 4
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
)
)
[-2] => $PAGE["modules"]["pages"]->Pages('showsubmenu', '', Array
(
)
)
[-10] => $PAGE["modules"]["pages"]->Pages('showchilds', '', Array
(
)
)
[-3] => $PAGE["modules"]["pages"]->Pages('showheadtitle', '', Array
(
)
)
[-4] => $PAGE["modules"]["pages"]->Pages('showpath', '', Array
(
)
)
)
Переменные сессии:
Array
(
[session_cur_site_id] => 2
[session_cur_lang_id] => 2
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 29.5764
[RUR/USD] => 0.0338107409962
[EUR/EUR] => 1
[EUR/RUR] => 39.7152
[RUR/EUR] => 0.025179276448312
[EUR/USD] => 1.3428
[USD/EUR] => 0.74471254095919
)
)
Last-modified:
Fri, 20 Aug 2010 07:08:37