Отладочная информация:
Время генерации страницы:
Time: 0,283 sec. QUERY STRING:
lang=&link=catalog/pylesosy_dyson/pylesos_dyson_dc29_origin.html Шаблон страницы:
_index1.html SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM ok_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, pt.main_module , 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 ok_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , ok_rus_pages_blocks as pb , ok_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='ok' 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!='',LCASE(P.alias),P.id) AS prod_alias, if(C.alias is not null and C.alias!='',LCASE(C.alias),C.id) AS ctgr_alias FROM`ok_rus_catalog_products` P INNER JOIN `ok_rus_catalog_categories` C ON P.category_id=C.id HAVING prod_alias='pylesos_dyson_dc29_origin' AND ctgr_alias='pylesosy_dyson'
[4] => SELECT a.id AS id, a.category_id AS category_id, a.group_id AS group_id, a.alias, 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.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 ok_rus_catalog_products a INNER JOIN ok_rus_catalog_categories c ON a.category_id = c.id LEFT JOIN ok_rus_catalog_ptypes b ON a.ptype_id = b.id LEFT JOIN ok_rus_catalog_groups d ON d.id = a.group_id WHERE a.id = 5302
[5] => SELECT rank, sum(percent) value FROM ok_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[6] => SELECT PT.*, P.search, P.range, P.ord FROM ok_rus_catalog_properties_table AS PT LEFT JOIN ok_rus_catalog_properties AS P ON P.group_id=31 AND P.property_id=PT.id WHERE P.property_id IS NOT NULL ORDER BY P.ord
[7] => SELECT * FROM ok_rus_catalog_property_values WHERE product_id=5302
[8] => 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 ok_rus_catalog_concerned_products AS C INNER JOIN ok_rus_catalog_products AS P ON C.concrn_id = P.id INNER JOIN ok_rus_catalog_categories CT ON CT.id=P.category_id LEFT JOIN ok_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id WHERE C.type=0 AND C.prod_id = 5302 AND P.active ORDER BY P.rank
[9] => 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 ok_rus_catalog_concerned_products AS C INNER JOIN ok_rus_catalog_products AS P ON C.concrn_id = P.id INNER JOIN ok_rus_catalog_categories CT ON CT.id=P.category_id LEFT JOIN ok_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id WHERE C.type=1 AND C.prod_id = 5302 AND P.active ORDER BY P.rank
[10] => UPDATE ok_rus_catalog_products SET hits=IF(hits > 0, hits + 1, 1) WHERE id='5302'
[11] => 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 ok_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 = 123 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
[12] => SELECT id, img, preview, rank FROM ok_rus_catalog_img WHERE prod_id=5302 ORDER BY rank, img
[13] => SELECT prop_val_id FROM ok_rus_catalog_order_prop_val WHERE prod_id=5302
[14] => SELECT PT.* FROM ok_rus_catalog_properties_table PT INNER JOIN ok_rus_catalog_properties P ON PT.id=P.property_id WHERE P.group_id=31 AND 3=PT.type ORDER BY P.ord
[15] => SELECT id, title, if(alias is not null and alias!='', alias, id) as alias, 0 as cnt FROM ok_rus_catalog_categories WHERE parent_id=1 and active=1 ORDER BY rank
[16] => SELECT * FROM ok_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
[17] => SELECT id, parent_id, title, address FROM ok_rus_pages USE INDEX (index_3) WHERE parent_id IN (139,218,273,275,277,278,198) AND active = 1 ORDER BY page_rank desc
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[1484] => $PAGE["modules"]["catalog"] = new CatalogPrototype('showtree', '/catalog/?', Array
(
[1] =>
[2] => 1
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - catalog_product.html
[1339] => $PAGE["modules"]["catalog"]->CatalogPrototype('showcatmenu', '/catalog/?', Array
(
[1] =>
[2] => all
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - catalog_menu.html
[1486] => $PAGE["modules"]["catalog"]->CatalogPrototype('showsearchform', '/index/?', Array
(
[1] =>
[2] =>
[3] => all
[4] => stdClass Object
(
[name] => 1
[code] =>
[ptype] =>
[price] =>
[group] =>
[availability] =>
[sort] =>
)
[5] =>
[tpl] =>
)
), tpl - catalog_searchform.html
[-1] => $PAGE["modules"]["pages"] = new PagesPrototype('showmenu', '', Array
(
)
), tpl - pages_menu.html
[-2] => $PAGE["modules"]["pages"]->PagesPrototype('showsubmenu', '', Array
(
)
), tpl - pages_sub_menu.html
[-10] => $PAGE["modules"]["pages"]->PagesPrototype('showchilds', '', Array
(
)
)
[-3] => $PAGE["modules"]["pages"]->PagesPrototype('showheadtitle', '', Array
(
)
), tpl - pages_title.html
[-4] => $PAGE["modules"]["pages"]->PagesPrototype('showpath', '', Array
(
)
), tpl - pages_path.html
)
Переменные сессии:
Array
(
[session_cur_site_id] => 1
[session_cur_lang_id] => 1
[catalog_last_viewed] => Array
(
[0] => 5302
)
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 30,0785
[RUR/USD] => 0,033246338746945
[EUR/EUR] => 1
[EUR/RUR] => 44,0259
[RUR/EUR] => 0,022713902498302
[EUR/USD] => 1,4637
[USD/EUR] => 0,68320010931202
)
)
Last-modified:
Wed, 14 Aug 2013 23:24:35
|
|