Отладочная информация:
Время генерации страницы:
Time: 0.237 sec.
QUERY STRING:
lang=&link=skidki/
Шаблон страницы:
_index1.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM rems_rus_pages USE INDEX (PRIMARY) WHERE id = 314
[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 rems_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , rems_rus_pages_blocks as pb , rems_rus_pages_templates as pt , modules as m WHERE p.id = 314
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='rems' AND S.id = site_id AND M.id=module_id AND active
[3] => 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 rems_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 80 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
[4] => SELECT id, title, commentable FROM rems_rus_articles WHERE id=80 AND commentable>0
[5] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=80
[6] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='80'
[7] => SELECT p.*, DATE_FORMAT(begin_date,'%d.%m.%Y') as begin_date, DATE_FORMAT(end_date,'%d.%m.%Y') as end_date, 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 rems_rus_polls p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0) WHERE begin_date <= CURDATE() AND end_date >= CURDATE() 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 RAND() LIMIT 0,1
[8] => SELECT id,variant_text
FROM rems_rus_poll_other_results
WHERE poll_id=13
ORDER BY variant_text
[9] => UPDATE rems_rus_polls SET hits=IF(hits > 0, hits + 1, 1) WHERE id='0'
[10] => REPLACE INTO rems_rus_forum_online_user (sid, vtime, forum_id, topic_id, user_id, username) VALUES ('b68dab0c1e7f1a8072026205ce86fa3a', NOW(), 0, 0, 0, '')
[11] => DELETE FROM rems_rus_forum_online_user WHERE vtime < DATE_SUB(NOW(), INTERVAL 30 MINUTE)
[12] => SELECT rems_rus_forum_posts.*,
rems_rus_forums.name as fname,
DATE_FORMAT(updated,'%d.%m.%Y %H:%i') as topic_updated
FROM rems_rus_forum_posts,
rems_rus_forums
WHERE topic_id = 0 AND
rems_rus_forum_posts.active = 1 AND
rems_rus_forums.id = forum_id AND
rems_rus_forums.active = 1
ORDER BY updated DESC
LIMIT 0,5
[13] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592625 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[14] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM rems_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 54 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2012-02-23' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[15] => SELECT * FROM rems_rus_banners WHERE id=42
[16] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 42
[17] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592625 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[18] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM rems_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 58 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2012-02-23' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[19] => SELECT * FROM rems_rus_banners WHERE id=47
[20] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 47
[21] => 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 rems_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 34 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
[22] => SELECT id, title, commentable FROM rems_rus_articles WHERE id=34 AND commentable>0
[23] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=34
[24] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='34'
[25] => UPDATE core_users SET onsite=0 WHERE last_visit 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 rems_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` = 2 AND IF( C.owner_id = 0,
C.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(C.rights & 0xF0) >> 4,
C.rights & 0xF
)
) > 0
[27] => SELECT count(*) as cnt FROM rems_rus_news_ctgr NC INNER JOIN rems_rus_news n ON NC.news_id=n.id LEFT JOIN rems_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 NC.ctgr_id =2 AND n.date <= NOW() AND n.active = 1 AND IF( n.owner_id = 0,
n.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(n.rights & 0xF0) >> 4,
n.rights & 0xF
)
) > 0
[28] => SELECT n.id, n.title, t.title as theme_title, n.announce, 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 rems_rus_news_ctgr NC INNER JOIN rems_rus_news n ON NC.news_id=n.id LEFT JOIN rems_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 NC.ctgr_id =2 AND n.date <= NOW() AND n.active = 1 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,3
[29] => SELECT C.id FROM rems_rus_news_ctgr NC INNER JOIN rems_rus_news_categories C ON C.id=NC.ctgr_id WHERE news_id IN (135,133,130) AND rss_auto_update AND (DATE_ADD(`rss_last_update`, INTERVAL `rss_update_interval` MINUTE) < NOW() OR `rss_last_update` IS NULL)
[30] => SELECT c.id, c.title, 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 rems_rus_subscription_categories c LEFT JOIN core_users_groups ug ON (ug.group_id = c.usr_group_id AND ug.user_id = 0) WHERE IF( c.owner_id = 0,
c.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(c.rights & 0xF0) >> 4,
c.rights & 0xF
)
) > 0
[31] => SELECT C.id, C.title, if(C.alias is not null and C.alias!='', C.alias, C.id) as alias, COUNT(P.id) as cnt FROM rems_rus_catalog_categories C INNER JOIN rems_rus_catalog_categories CH ON CH.cleft>=C.cleft AND CH.cright<=C.cright LEFT JOIN rems_rus_catalog_products P ON CH.id=P.category_id AND P.active WHERE C.parent_id=1 AND C.active=1 GROUP BY C.id ORDER BY C.rank
[32] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592625 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[33] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM rems_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 56 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2012-02-23' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[34] => SELECT * FROM rems_rus_banners WHERE id=50
[35] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 50
[36] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592625 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[37] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM rems_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 59 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2012-02-23' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[38] => SELECT * FROM rems_rus_banners WHERE id=49
[39] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 49
[40] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592625 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[41] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM rems_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 57 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2012-02-23' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[42] => SELECT * FROM rems_rus_banners WHERE id=46
[43] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 46
[44] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592625 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[45] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM rems_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 53 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2012-02-23' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[46] => SELECT * FROM rems_rus_banners WHERE id=45
[47] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 45
[48] => 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 rems_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 4 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
[49] => SELECT id, title, commentable FROM rems_rus_articles WHERE id=4 AND commentable>0
[50] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=4
[51] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='4'
[52] => SELECT * FROM rems_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
[53] => SELECT id, parent_id, title, address
FROM rems_rus_pages USE INDEX (index_3)
WHERE parent_id IN (210,152,218,314,261,298,286,403,287,300,301,312,139,262,206,264,280,219,291,205,325,216,242,198,265,277,307,302,303,365,337,366,336,304,306,305,370,311,288,338,289,372,395,214,237,200,208,253,251,212,315,346,271,275,273,272,274,320,321,322,332,333,334,335,339,342,347,362,369,375,376,377,340,392,400,207,290,258,293,292,295,317,318,380,382,345,278,383,326,328,327,330,363,364,368,276,269,351,354,352,353,355,356,396,399,357,358,359,360,398,402,384,385,390,401,386,387,388,389,391,393,394,244,211,296,331,323,349,341,343,379,381,378,344,348) AND
active = 1
ORDER BY page_rank desc
[54] => SELECT id, parent_id, title, address
FROM rems_rus_pages USE INDEX (index_3)
WHERE parent_id IN (210,152,218,314,261,298,286,403,287,300,301,312,139,262,206,264,280,219,291,205,325,216,242,198,265,277,307,302,303,365,337,366,336,304,306,305,370,311,288,338,289,372,395,214,237,200,208,253,251,212,315,346,271,275,273,272,274,320,321,322,332,333,334,335,339,342,347,362,369,375,376,377,340,392,400,207,290,258,293,292,295,317,318,380,382,345,278,383,326,328,327,330,363,364,368,276,269,351,354,352,353,355,356,396,399,357,358,359,360,398,402,384,385,390,401,386,387,388,389,391,393,394,244,211,296,331,323,349,341,343,379,381,378,344,348) AND
active = 1
ORDER BY page_rank desc
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[2565] => $PAGE["modules"]["article"] = new ArticlePrototype('showarticle', '/skidki/?', Array
(
[1] => 80
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - article.html
[2229] => $PAGE["modules"]["poll"] = new PollPrototype('showpoll', '/poll/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - poll.html
[2230] => $PAGE["modules"]["forum"] = new ForumPrototype('lasttopics', '/community/forum/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - forum_last_topics.html
[2231] => $PAGE["modules"]["banners"] = new BannersPrototype('showbanner', '/skidki/?', Array
(
[1] => 54
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_flash.html
[2232] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/skidki/?', Array
(
[1] => 58
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_flash.html
[2567] => $PAGE["modules"]["article"]->ArticlePrototype('showarticle', '/skidki/?', Array
(
[1] => 34
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - article.html
[2246] => $PAGE["modules"]["siteusers"] = new SiteusersPrototype('loginform', '/community/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - siteusers_loginform.html
[2235] => $PAGE["modules"]["news"] = new NewsPrototype('archive', '/news/?', Array
(
[1] => 2
[2] => 3
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - news_archive.html
[2236] => $PAGE["modules"]["subscription"] = new SubscriptionPrototype('subform', '/subscription/?', Array
(
[1] => all_cat
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - subscription.html
[2237] => $PAGE["modules"]["catalog"] = new CatalogPrototype('showcatmenu', '/catalog/?', Array
(
[1] => 3
[2] => 1
[3] => 1
[4] =>
[5] =>
[tpl] =>
)
), tpl - catalog_menu.html
[2238] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/skidki/?', Array
(
[1] => 56
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_flash.html
[2239] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/skidki/?', Array
(
[1] => 59
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_flash.html
[2240] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/skidki/?', Array
(
[1] => 57
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_flash.html
[2241] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/skidki/?', Array
(
[1] => 53
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_flash.html
[2242] => $PAGE["modules"]["article"]->ArticlePrototype('showarticle', '/skidki/?', Array
(
[1] => 4
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - article.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] => 2
[session_cur_lang_id] => 2
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 29.5764
[RUR/USD] => 0.0338107409962
[EUR/EUR] => 1
[EUR/RUR] => 39.7152
[RUR/EUR] => 0.025179276448312
[EUR/USD] => 1.3428
[USD/EUR] => 0.74471254095919
)
)
Last-modified:
Thu, 23 Feb 2012 10:35:52
