Отладочная информация:
Время генерации страницы:
Time: 0,079 sec.
QUERY STRING:
lang=&link=market/&lang=rus&link=market&action=searchresult&sdata%5Bcnt%5D=10&sdata%5Bgroup_id%5D=0&sdata%5Bdynamic%5D%5B158%5D=AEG
Шаблон страницы:
_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='' AND ctgr_alias=''
[4] => select id, if(alias is not null and alias!='', alias, id) AS alias FROM`era_rus_catalog_categories` HAVING LCASE(alias)=''
[5] => select id, if(alias is not null and alias!='', alias, id) AS alias FROM`era_rus_catalog_categories` HAVING LCASE(alias)=''
[6] => SELECT p.id, count(*)=1 AS dinamic_true, p.product_title, p.product_inf, p.product_description, p.image_middle, p.image_big,
product_code, p.product_availability, p.price_1, p.price_2, p.price_3, p.price_4, p.price_5, p.currency, p.rank,
p.active, 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 ctg_alias, ptype_name, ptype_id
FROM era_rus_catalog_products p INNER JOIN era_rus_catalog_categories c ON p.category_id=c.id LEFT JOIN era_rus_catalog_ptypes AS pt ON p.ptype_id=pt.id, era_rus_catalog_property_values pv WHERE p.active = 1 AND p.id=pv.product_id AND ((pv.property_id = 158 AND pv.value LIKE "%AEG%")) GROUP BY id HAVING count(*)=1 ORDER BY p.rank LIMIT 0, 10
[7] => SELECT *, if(alias is not null and alias!='', alias, id) as ctgr_alias FROM era_rus_catalog_categories WHERE id=0
[8] => SELECT id, parent_id, group_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 C.group_id != 0 ORDER BY clevel, rank
[9] => 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 era_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 62 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
[10] => UPDATE era_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='62'
[11] => SELECT * FROM era_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
[12] => SELECT id, parent_id, title, address
FROM era_rus_pages USE INDEX (index_3)
WHERE parent_id IN (277,285,284,311,280,307,306) AND
active = 1
ORDER BY page_rank desc
[13] => SELECT * FROM era_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
[14] => SELECT id, parent_id, title, address
FROM era_rus_pages USE INDEX (index_3)
WHERE parent_id IN (277,285,284,311,280,307,306) AND
active = 1
ORDER BY page_rank desc
[15] => SELECT id, title, if(alias is not null and alias!='', alias, id) as alias, 0 as cnt FROM era_rus_catalog_categories WHERE parent_id=1 and active=1 ORDER BY rank
[16] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 84
[17] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[18] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 108
[19] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[20] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 166
[21] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[22] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 109
[23] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[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 = 1
[26] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 110
[27] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[28] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 167
[29] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[30] => SELECT id, title, img, description, if(alias is not null and alias!='', alias, id) as alias FROM era_rus_catalog_categories C WHERE active = 1 AND C.clevel = 1 ORDER BY C.rank
[31] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 84
[32] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[33] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 108
[34] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[35] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 166
[36] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[37] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 109
[38] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[39] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 85
[40] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[41] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 110
[42] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[43] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 167
[44] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[45] => 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
[46] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 84
[47] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[48] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 108
[49] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[50] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 166
[51] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[52] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 109
[53] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[54] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 85
[55] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[56] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 165
[57] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 85
[58] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 88
[59] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id