Отладочная информация:
Время генерации страницы:
Time: 0.179 sec.
QUERY STRING:
lang=&link=catalog/catsearch/69/78
Шаблон страницы:
_index1.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM www_rus_pages USE INDEX (PRIMARY) WHERE id = 279
[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 www_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , www_rus_pages_blocks as pb , www_rus_pages_templates as pt , modules as m WHERE p.id = 279
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 block_rank
[2] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
[3] => show columns from `www_rus_catalog_categories`
[4] => show columns from `www_rus_catalog_products`
[5] => select id, parent_id, if(alias is not null,alias,id) as path from `www_rus_catalog_categories` having path IN ('69','78') order by clevel
[6] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(78)
[7] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(69)
[8] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(1)
[9] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(0)
[10] => SELECT *
FROM www_rus_catalog_categories
WHERE id = 78
ORDER BY rank
[11] => SELECT id, title, description, img
FROM www_rus_catalog_categories
WHERE parent_id = 78 AND active = 1
ORDER BY rank
[12] => SELECT DISTINCT P.id, product_title, product_inf, product_description, image_middle, image_big,
price_1, price_2, price_3, price_4, price_5, currency, novelty, product_availability,
group_title, ptype_name, PT.link as ptype_link
FROM www_rus_catalog_products AS P
LEFT JOIN www_rus_catalog_groups AS G ON P.group_id = G.id
LEFT JOIN www_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id
WHERE category_id = 78 AND P.active = 1
ORDER BY P.rank, ptype_id LIMIT 0, 20
[13] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 131
[14] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[15] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 132
[16] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[17] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 133
[18] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[19] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 134
[20] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[21] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 135
[22] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[23] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 137
[24] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[25] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 138
[26] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[27] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 139
[28] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[29] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 159
[30] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[31] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 160
[32] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[33] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 167
[34] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 174
[35] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 176
[36] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 178
[37] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[38] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 180
[39] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[40] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 181
[41] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[42] => SELECT p.*, pt.ptype_name, pt.link as ptype_link
FROM www_rus_catalog_products p
LEFT JOIN www_rus_catalog_ptypes pt ON p.ptype_id = pt.id
WHERE category_id = 78 AND active = 1 AND leader
ORDER BY rank DESC LIMIT 0,20
[43] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
[44] => SELECT p.*, pt.ptype_name, pt.link as ptype_link
FROM www_rus_catalog_products p
LEFT JOIN www_rus_catalog_ptypes pt ON p.ptype_id = pt.id
WHERE category_id != 78 AND active = 1 AND leader
ORDER BY rank DESC LIMIT 0,2
[45] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 183
[46] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(83)
[47] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(64)
[48] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(1)
[49] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(0)
[50] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[51] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
[52] => SELECT C.id, C.parent_id, C.title, C.clevel, C.rank, COUNT(P.id) as cnt FROM www_rus_catalog_categories AS C
LEFT JOIN www_rus_catalog_categories AS C1 ON ( C1.cleft >= C.cleft AND C1.cright <= C.cright)
LEFT JOIN www_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
[53] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(65)
[54] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(79)
[55] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(85)
[56] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(67)
[57] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(81)
[58] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(68)
[59] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(1)
[60] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(0)
[61] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(71)
[62] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(72)
[63] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(73)
[64] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(74)
[65] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(75)
[66] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(76)
[67] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(77)
[68] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
[69] => SELECT *
FROM www_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
[70] => SELECT id, parent_id, title, address
FROM www_rus_pages USE INDEX (index_3)
WHERE parent_id IN (218,257,208,290,139,206,255,198,269,266,267,265,268,297,284,264,263,262,261,260,259,258,256,295,280,278,277,276,275,274,273,293,292,291,279,212,296,201,285,283,286,287,289,281,282,288,294,229) AND
active = 1
ORDER BY id
[71] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=279
[72] => SELECT parent_id FROM www_rus_pages WHERE id=279
[73] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
[74] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
[75] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
[76] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
[77] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
[78] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
[79] => SELECT id, parent_id, title, address
FROM www_rus_pages USE INDEX (index_3)
WHERE parent_id IN (218,257,208,290,139,206,255,198,269,266,267,265,268,297,284,264,263,262,261,260,259,258,256,295,280,278,277,276,275,274,273,293,292,291,279,212,296,201,285,283,286,287,289,281,282,288,294,229) AND
active = 1
ORDER BY id
[80] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=279
[81] => SELECT parent_id FROM www_rus_pages WHERE id=279
[82] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
[83] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
[84] => SELECT permission_type FROM www_rus_pages USE INDEX (PRIMARY) WHERE id = 279
[85] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[1233] => $PAGE["modules"]["catalog"] = new Catalog('assortment', '/catalog/catsearch/?', Array
(
[1] =>
[2] => all
[3] => all
[4] => 279
[5] =>
)
)
[1230] => $PAGE["modules"]["catalog"]->Catalog('showleaders', '/catalog/?', Array
(
[1] => 2
[2] => all
[3] =>
[4] => 279
[5] =>
)
)
[1231] => $PAGE["modules"]["catalog"]->Catalog('showtree', '/catalog/?', Array
(
[1] =>
[2] =>
[3] => 1
[4] => 279
[5] =>
)
)
[-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
[4] => 279
)
)
[-2] => $PAGE["modules"]["pages"]->Pages('showsubmenu', '', Array
(
[4] => 279
)
)
[-10] => $PAGE["modules"]["pages"]->Pages('showchilds', '', Array
(
[4] => 279
)
)
[-3] => $PAGE["modules"]["pages"]->Pages('showheadtitle', '', Array
(
[4] => 279
)
)
[-4] => $PAGE["modules"]["pages"]->Pages('showpath', '', Array
(
[4] => 279
)
)
)
Переменные сессии:
Array
(
[session_cur_site_id] => 1
[session_cur_lang_id] => 1
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 28.4356
[RUR/USD] => 0.0351671847965
[EUR/EUR] => 1
[EUR/RUR] => 39.3151
[RUR/EUR] => 0.0254355196858
[EUR/USD] => 1.3826
[USD/EUR] => 0.723274989151
)
)
Last-modified:
Thu, 23 Feb 2012 09:11:25