Схемы к СМА

Отладочная информация:

Array
(
    [0] => SELECT permission_type FROM rems_rus_pages USE INDEX (PRIMARY) WHERE id = 205
    [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 = 205 
						  			 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 d.*, IF(d.owner_id = 0, 1 , 0) as is_owner,
					IF(d.owner_id = 0,
						d.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(d.rights & 0xF0) >> 4,
							d.rights & 0xF
						)
					) AS user_rights FROM rems_rus_documents_categories d LEFT JOIN core_users_groups ug  ON (ug.group_id = d.usr_group_id AND ug.user_id = 0)  WHERE id = 39 AND IF( d.owner_id = 0,
						d.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(d.rights & 0xF0) >> 4,
							d.rights & 0xF
						)
					) > 0
    [4] => SELECT count(*) as cnt FROM rems_rus_documents_products d INNER JOIN rems_rus_documents_categories c ON d.category_id=c.id LEFT JOIN core_users_groups ug  ON (ug.group_id = d.usr_group_id AND ug.user_id = 0)  WHERE d.active=1 AND c.active=1 AND !ISNULL(category_id)  AND category_id = 39 AND IF( d.owner_id = 0,
						d.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(d.rights & 0xF0) >> 4,
							d.rights & 0xF
						)
					) > 0
    [5] => SELECT d.*, DATE_FORMAT(d.added,'%d.%m.%Y %H:%i') as added, IF(d.owner_id = 0, 1 , 0) as is_owner,
					IF(d.owner_id = 0,
						d.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(d.rights & 0xF0) >> 4,
							d.rights & 0xF
						)
					) AS user_rights FROM rems_rus_documents_products d INNER JOIN rems_rus_documents_categories c ON d.category_id=c.id LEFT JOIN core_users_groups ug  ON (ug.group_id = d.usr_group_id AND ug.user_id = 0)  WHERE d.active=1 AND c.active=1 AND !ISNULL(category_id)  AND category_id = 39 AND IF( d.owner_id = 0,
						d.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(d.rights & 0xF0) >> 4,
							d.rights & 0xF
						)
					) > 0 ORDER BY added DESC LIMIT 0,15
    [6] => 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
    [7] => SELECT id,variant_text
					FROM rems_rus_poll_other_results
					WHERE poll_id=13
					ORDER BY variant_text
    [8] => UPDATE rems_rus_polls SET hits=IF(hits > 0, hits + 1, 1) WHERE id='0'
    [9] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592627 BETWEEN first_long_ip AND last_long_ip ORDER BY name
    [10] => 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-05-21' 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
    [11] => SELECT * FROM rems_rus_banners WHERE id=42
    [12] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 42
    [13] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592627 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 = 58 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2012-05-21' 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=47
    [16] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 47
    [17] => 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 = 126 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
    [18] => SELECT id, title, commentable FROM rems_rus_articles WHERE id=126 AND commentable>0
    [19] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=126
    [20] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='126'
    [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 = 108 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=108 AND commentable>0
    [23] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=108
    [24] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='108'
    [25] => 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
    [26] => SELECT id, title, commentable FROM rems_rus_articles WHERE id=34 AND commentable>0
    [27] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=34
    [28] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='34'
    [29] => UPDATE core_users SET onsite=0 WHERE last_visit SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592627 BETWEEN first_long_ip AND last_long_ip ORDER BY name
    [31] => 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-05-21' 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
    [32] => SELECT * FROM rems_rus_banners WHERE id=45
    [33] => UPDATE rems_rus_banners SET showing = showing + 1 WHERE id = 45
    [34] => SELECT S.id FROM rems_rus_catalog_categories AS P INNER JOIN rems_rus_catalog_categories AS S ON S.cleft BETWEEN P.cleft AND P.cright WHERE P.id=71
    [35] => SELECT p.*, pt.ptype_name, pt.link as ptype_link, if(c.alias is not null and c.alias!='', c.alias, c.id) as ctg_alias,
                    if(p.alias is not null and p.alias!='', p.alias, p.id) as prod_alias
					FROM rems_rus_catalog_products p INNER JOIN rems_rus_catalog_categories c ON c.id=p.category_id
						LEFT JOIN rems_rus_catalog_ptypes pt ON p.ptype_id = pt.id
                    WHERE category_id IN (71, 71) AND p.active = 1 AND leader
                    ORDER BY p.rank DESC LIMIT 0,1
    [36] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
    [37] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
    [38] => SELECT rank, sum(percent) value FROM rems_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
    [39] => SELECT prod_id, prop_val_id FROM rems_rus_catalog_order_prop_val WHERE prod_id IN (108)
    [40] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644592627 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-05-21' 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 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
    [45] => SELECT id, title, commentable FROM rems_rus_articles WHERE id=4 AND commentable>0
    [46] => SELECT * FROM rems_rus_comments_resource WHERE type=4 AND item_id=4
    [47] => UPDATE rems_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='4'
    [48] => 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
    [49] => 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,406,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,407,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,417,396,399,357,358,359,360,398,410,402,411,416,390,385,412,384,413,389,404,401,415,386,393,394,405,414,387,409,408,388,391,244,211,296,331,323,349,341,343,379,381,378,344,348) AND
												  active = 1
											ORDER BY page_rank desc
    [50] => 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,406,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,407,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,417,396,399,357,358,359,360,398,410,402,411,416,390,385,412,384,413,389,404,401,415,386,393,394,405,414,387,409,408,388,391,244,211,296,331,323,349,341,343,379,381,378,344,348) AND
												  active = 1
											ORDER BY page_rank desc
)

Array
(
)

Array
(
    [1536] => $PAGE["modules"]["documents"] = new DocumentsPrototype('assortment', '/downloads/?', Array
(
    [1] => 15
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - documents_assortment.html
    [534] => $PAGE["modules"]["poll"] = new PollPrototype('showpoll', '/poll-result/?', Array
(
    [1] => 
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - poll.html
    [1824] => $PAGE["modules"]["banners"] = new BannersPrototype('showbanner', '/downloads/?', Array
(
    [1] => 54
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - banners_flash.html
    [1825] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/downloads/?', Array
(
    [1] => 58
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - banners_flash.html
    [2789] => $PAGE["modules"]["article"] = new ArticlePrototype('showarticle', '/downloads/?', Array
(
    [1] => 126
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - article.html
    [2680] => $PAGE["modules"]["article"]->ArticlePrototype('showarticle', '/downloads/?', Array
(
    [1] => 108
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - article.html
    [2679] => $PAGE["modules"]["article"]->ArticlePrototype('showarticle', '/downloads/?', Array
(
    [1] => 34
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - article.html
    [788] => $PAGE["modules"]["siteusers"] = new SiteusersPrototype('loginform', '/community/?', Array
(
    [1] => 
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - siteusers_loginform.html
    [1828] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/downloads/?', Array
(
    [1] => 53
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - banners_flash.html
    [789] => $PAGE["modules"]["catalog"] = new CatalogPrototype('showleaders', '/catalog/?', Array
(
    [1] => 1
    [2] => 71
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - catalog_leaders.html
    [1829] => $PAGE["modules"]["banners"]->BannersPrototype('showbanner', '/downloads/?', Array
(
    [1] => 57
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - banners_flash.html
    [1298] => $PAGE["modules"]["article"]->ArticlePrototype('showarticle', '/downloads/?', 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
        )

    [catalog_last_viewed] => Array
        (
            [0] => 166
            [1] => 126
            [2] => 208
            [3] => 207
            [4] => 206
            [5] => 158
            [6] => 157
            [7] => 156
            [8] => 155
            [9] => 171
            [10] => 151
            [11] => 215
            [12] => 108
        )

)