Отладочная информация:
Время генерации страницы:
Time: 0,071 sec.
QUERY STRING:
lang=&link=novosti/&action=archive
Шаблон страницы:
_index1.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM era_rus_pages USE INDEX (PRIMARY) WHERE id = 282
[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 = 282
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 C.*, IF(C.owner_id = 0, 1 , 0) as is_owner,
IF(C.owner_id = 0,
C.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(C.rights & 0xF0) >> 4,
C.rights & 0xF
)
) AS user_rights FROM era_rus_news_categories AS C LEFT JOIN core_users_groups ug ON (ug.group_id = C.usr_group_id AND ug.user_id = 0) WHERE `id` = 9 AND IF( C.owner_id = 0,
C.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(C.rights & 0xF0) >> 4,
C.rights & 0xF
)
) > 0
[4] => SELECT count(*) as cnt FROM era_rus_news_ctgr NC INNER JOIN era_rus_news n ON NC.news_id=n.id LEFT JOIN era_rus_news_themes t ON n.theme_id = t.id LEFT JOIN core_users_groups ug ON (ug.group_id = n.usr_group_id AND ug.user_id = 0) WHERE n.date <= NOW() AND n.active = 1 AND NC.ctgr_id=9 AND IF( n.owner_id = 0,
n.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(n.rights & 0xF0) >> 4,
n.rights & 0xF
)
) > 0
[5] => SELECT n.id, n.title, t.title as theme_title, n.source, n.announce, tags, n.active, n.rss_link, n.announce_with_links, NOW() as d, DATE_FORMAT(date,'%d.%m.%Y') as news_date, n.img, IF(n.owner_id = 0, 1 , 0) as is_owner,
IF(n.owner_id = 0,
n.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(n.rights & 0xF0) >> 4,
n.rights & 0xF
)
) AS user_rights FROM era_rus_news_ctgr NC INNER JOIN era_rus_news n ON NC.news_id=n.id LEFT JOIN era_rus_news_themes t ON n.theme_id = t.id LEFT JOIN core_users_groups ug ON (ug.group_id = n.usr_group_id AND ug.user_id = 0) WHERE n.date <= NOW() AND n.active = 1 AND NC.ctgr_id=9 AND IF( n.owner_id = 0,
n.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(n.rights & 0xF0) >> 4,
n.rights & 0xF
)
) > 0 ORDER BY date DESC LIMIT 0,10
[6] => SELECT C.id FROM era_rus_news_ctgr NC INNER JOIN era_rus_news_categories C ON C.id=NC.ctgr_id WHERE news_id IN (311,310,309,308,307,306,305,304,303,302) AND rss_auto_update AND (DATE_ADD(`rss_last_update`, INTERVAL `rss_update_interval` MINUTE) < NOW() OR `rss_last_update` IS NULL)
[7] => 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
[8] => 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
[9] => 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
[10] => 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
[11] => 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
[12] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 84
[13] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[14] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 108
[15] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[16] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 166
[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 = 109
[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 = 85
[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 = 110
[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 = 167
[25] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[26] => 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
[27] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 84
[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 = 108
[30] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[31] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 166
[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 = 109
[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 = 85
[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 = 110
[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 = 167
[40] => SELECT alias, parent_id FROM era_rus_catalog_categories WHERE id = 1
[