Лучшая покупка

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

Array
(
    [0] => SELECT permission_type FROM www_rus_pages USE INDEX (PRIMARY) WHERE id = 279
    [1] => SELECT pb.*, pb.id as block_id, m.name, m.title, m.id as mod_id, p.usr_group_id, number_of_fields, 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  www_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , www_rus_pages_blocks as pb , www_rus_pages_templates as pt , modules as m  WHERE p.id = 279 
						  			 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 block_rank
    [2] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
    [3] => show columns from `www_rus_catalog_categories`
    [4] => show columns from `www_rus_catalog_products`
    [5] => select id, parent_id, if(alias is not null,alias,id) as path from `www_rus_catalog_categories` having path IN ('boats','skaut') order by clevel
    [6] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(83)
    [7] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(64)
    [8] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(1)
    [9] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(0)
    [10] => SELECT *
											FROM www_rus_catalog_categories
											WHERE id = 83
											ORDER BY rank
    [11] => SELECT id, title, description, img
                               FROM www_rus_catalog_categories
                               WHERE parent_id = 83 AND active = 1
                               ORDER BY rank
    [12] => SELECT DISTINCT P.id, product_title, product_inf, product_description, image_middle, image_big,
                               price_1, price_2, price_3, price_4, price_5, currency, novelty, product_availability,
							   group_title, ptype_name, PT.link as ptype_link
                               FROM www_rus_catalog_products AS P
                               LEFT JOIN www_rus_catalog_groups AS G ON P.group_id = G.id
                               LEFT JOIN www_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id
                               WHERE category_id = 83 AND P.active = 1
                               ORDER BY P.rank, ptype_id LIMIT 0, 20
    [13] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_products where id = 183
    [14] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
							WHERE active = 1
							GROUP BY rank
							ORDER BY rank
    [15] => SELECT p.*, pt.ptype_name, pt.link as ptype_link
					FROM www_rus_catalog_products p
						LEFT JOIN www_rus_catalog_ptypes pt ON p.ptype_id = pt.id
                    WHERE category_id  = 83 AND active = 1 AND leader
                    ORDER BY rank DESC LIMIT 0,20
    [16] => SELECT rank, sum(percent) value FROM www_rus_shop_taxes
							WHERE active = 1
							GROUP BY rank
							ORDER BY rank
    [17] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
    [18] => SELECT p.*, pt.ptype_name, pt.link as ptype_link
					FROM www_rus_catalog_products p
						LEFT JOIN www_rus_catalog_ptypes pt ON p.ptype_id = pt.id
                    WHERE category_id  != 83 AND active = 1 AND leader
                    ORDER BY rank DESC LIMIT 0,2
    [19] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
    [20] => SELECT C.id, C.parent_id, C.title, C.clevel, C.rank, COUNT(P.id) as cnt FROM www_rus_catalog_categories AS C
			   LEFT JOIN www_rus_catalog_categories AS C1 ON ( C1.cleft >=  C.cleft AND C1.cright <=  C.cright)
			   LEFT JOIN www_rus_catalog_products AS P ON category_id=C1.id AND P.active=1 WHERE C.active=1
			   GROUP BY C.id ORDER BY C.rank, C.id
    [21] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(65)
    [22] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(79)
    [23] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(85)
    [24] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(67)
    [25] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(81)
    [26] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(68)
    [27] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(1)
    [28] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(0)
    [29] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(71)
    [30] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(69)
    [31] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(1)
    [32] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(0)
    [33] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(72)
    [34] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(73)
    [35] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(74)
    [36] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(75)
    [37] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(76)
    [38] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(77)
    [39] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from www_rus_catalog_categories where id in(78)
    [40] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
    [41] => SELECT *
						FROM www_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
    [42] => SELECT id, parent_id, title, address
											FROM www_rus_pages USE INDEX (index_3)
											WHERE parent_id IN (218,257,208,290,139,206,255,198,269,266,267,265,268,297,284,264,263,262,261,260,259,258,256,295,280,278,277,276,275,274,273,293,292,291,279,212,296,201,285,283,286,287,289,281,282,288,294,229) AND
												  active = 1
											ORDER BY id
    [43] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=279
    [44] => SELECT parent_id FROM www_rus_pages WHERE id=279
    [45] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
    [46] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
    [47] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
    [48] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
    [49] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=139
    [50] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
    [51] => SELECT id, parent_id, title, address
											FROM www_rus_pages USE INDEX (index_3)
											WHERE parent_id IN (218,257,208,290,139,206,255,198,269,266,267,265,268,297,284,264,263,262,261,260,259,258,256,295,280,278,277,276,275,274,273,293,292,291,279,212,296,201,285,283,286,287,289,281,282,288,294,229) AND
												  active = 1
											ORDER BY id
    [52] => SELECT id FROM www_rus_pages WHERE parent_id='0' AND id=279
    [53] => SELECT parent_id FROM www_rus_pages WHERE id=279
    [54] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
    [55] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
    [56] => SELECT permission_type FROM www_rus_pages USE INDEX (PRIMARY) WHERE id = 279
    [57] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='www' AND S.id = site_id AND M.id=module_id AND active
)

Array
(
)

Array
(
    [1233] => $PAGE["modules"]["catalog"] = new Catalog('assortment', '/catalog/catsearch/?', Array
(
    [1] => 
    [2] => all
    [3] => all
    [4] => 279
    [5] => 
)
)
    [1230] => $PAGE["modules"]["catalog"]->Catalog('showleaders', '/catalog/?', Array
(
    [1] => 2
    [2] => all
    [3] => 
    [4] => 279
    [5] => 
)
)
    [1231] => $PAGE["modules"]["catalog"]->Catalog('showtree', '/catalog/?', Array
(
    [1] => 
    [2] => 
    [3] => 1
    [4] => 279
    [5] => 
)
)
    [-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
    [4] => 279
)
)
    [-2] => $PAGE["modules"]["pages"]->Pages('showsubmenu', '', Array
(
    [4] => 279
)
)
    [-10] => $PAGE["modules"]["pages"]->Pages('showchilds', '', Array
(
    [4] => 279
)
)
    [-3] => $PAGE["modules"]["pages"]->Pages('showheadtitle', '', Array
(
    [4] => 279
)
)
    [-4] => $PAGE["modules"]["pages"]->Pages('showpath', '', Array
(
    [4] => 279
)
)
)

Array
(
    [session_cur_site_id] => 1
    [session_cur_lang_id] => 1
    [catalog_rates] => Array
        (
            [USD/USD] => 1
            [RUR/RUR] => 1
            [USD/RUR] => 28.4356
            [RUR/USD] => 0.0351671847965
            [EUR/EUR] => 1
            [EUR/RUR] => 39.3151
            [RUR/EUR] => 0.0254355196858
            [EUR/USD] => 1.3826
            [USD/EUR] => 0.723274989151
        )

)