Отладочная информация:
Время генерации страницы:
Time: 0,099 sec.
QUERY STRING:
lang=&link=market/chillery/chiller_mdv_mgbi_f30_wsn1/
Шаблон страницы:
_index1.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM era_rus_pages USE INDEX (PRIMARY) WHERE id = 302
[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 era_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , era_rus_pages_blocks as pb , era_rus_pages_templates as pt , modules as m WHERE p.id = 302
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='era' 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`era_rus_catalog_products` P INNER JOIN `era_rus_catalog_categories` C ON P.category_id=C.id HAVING prod_alias='chiller_mdv_mgbi_f30_wsn1' AND ctgr_alias='chillery'
[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.seo_title,
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 era_rus_catalog_products a
INNER JOIN era_rus_catalog_categories c ON a.category_id = c.id
LEFT JOIN era_rus_catalog_ptypes b ON a.ptype_id = b.id
LEFT JOIN era_rus_catalog_groups d ON d.id = a.group_id
WHERE a.id = 514
[5] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 110
[6] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[7] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 110
[8] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[9] => SELECT *, if(alias is not null and alias!='', alias, id) as ctgr_alias FROM era_rus_catalog_categories WHERE id=0
[10] => SELECT id, parent_id, title, clevel, rank, if(alias is not null and alias!='', alias, id) as alias FROM era_rus_catalog_categories AS C WHERE C.active=1 AND id != 133 ORDER BY clevel, rank
[11] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 84
[12] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[13] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 108
[14] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[15] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 166
[16] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[17] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 109
[18] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[19] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 85
[20] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[21] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 165
[22] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 85
[23] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 88
[24] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 85
[25] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 110
[26] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[27] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 167
[28] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[29] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 110
[30] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[31] => SELECT PT.*, P.search, P.range, P.ord FROM era_rus_catalog_properties_table AS PT LEFT JOIN era_rus_catalog_properties AS P ON P.group_id=17 AND P.property_id=PT.id WHERE P.property_id IS NOT NULL ORDER BY P.ord
[32] => SELECT * FROM era_rus_catalog_property_values WHERE product_id=514
[33] => 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 era_rus_catalog_concerned_products AS C INNER JOIN era_rus_catalog_products AS P ON C.concrn_id = P.id INNER JOIN era_rus_catalog_categories CT ON CT.id=P.category_id LEFT JOIN era_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id WHERE C.type=0 AND C.prod_id = 514 AND P.active ORDER BY P.rank
[34] => 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 era_rus_catalog_concerned_products AS C INNER JOIN era_rus_catalog_products AS P ON C.concrn_id = P.id INNER JOIN era_rus_catalog_categories CT ON CT.id=P.category_id LEFT JOIN era_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id WHERE C.type=1 AND C.prod_id = 514 AND P.active ORDER BY P.rank
[35] => UPDATE era_rus_catalog_products SET hits=IF(hits > 0, hits + 1, 1) WHERE id='514'
[36] => 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 era_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 = 110 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
[37] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE alias = 'chillery'
[38] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[39] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE alias = 'chillery'
[40] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[41] => SELECT id, img, preview, rank FROM era_rus_catalog_img WHERE prod_id=514 ORDER BY rank, img
[42] => SELECT prop_val_id FROM era_rus_catalog_order_prop_val WHERE prod_id=514
[43] => SELECT PT.* FROM era_rus_catalog_properties 
