Отладочная информация:
Время генерации страницы:
Time: 0,175 sec.
QUERY STRING:
lang=&link=catalog/636/
Шаблон страницы:
_index46.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM gz_rus_pages USE INDEX (PRIMARY) WHERE id = 296
[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 gz_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , gz_rus_pages_blocks as pb , gz_rus_pages_templates as pt , modules as m WHERE p.id = 296
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='gz' 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 gz_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 76 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] => UPDATE gz_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='76'
[5] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='gz' AND S.id = site_id AND M.id=module_id AND active
[6] => SELECT id, title, if(alias is not null and alias!='', alias, id) as alias, 0 as cnt, img as ctg_img FROM gz_rus_catalog_categories WHERE parent_id=1 and active=1 ORDER BY rank
[7] => SELECT CH.id FROM gz_rus_catalog_categories AS P, gz_rus_catalog_categories AS CH WHERE P.id=36 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[8] => SELECT CH.id FROM gz_rus_catalog_categories AS P, gz_rus_catalog_categories AS CH WHERE P.id=6 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[9] => SELECT CH.id FROM gz_rus_catalog_categories AS P, gz_rus_catalog_categories AS CH WHERE P.id=16 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[10] => SELECT CH.id FROM gz_rus_catalog_categories AS P, gz_rus_catalog_categories AS CH WHERE P.id=26 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[11] => SELECT CH.id FROM gz_rus_catalog_categories AS P, gz_rus_catalog_categories AS CH WHERE P.id=46 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[12] => SELECT CH.id FROM gz_rus_catalog_categories AS P, gz_rus_catalog_categories AS CH WHERE P.id=56 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[13] => SELECT CH.id FROM gz_rus_catalog_categories AS P, gz_rus_catalog_categories AS CH WHERE P.id=66 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[14] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='gz' AND S.id = site_id AND M.id=module_id AND active
[15] => select id, if(alias is not null and alias!='', alias, id) AS alias FROM`gz_rus_catalog_categories` HAVING LCASE(alias)='636'
[16] => SELECT *, if(alias is not null and alias!='', alias, id) as ctgr_alias FROM gz_rus_catalog_categories WHERE id=636
[17] => SELECT id, title, description, img, if(alias is not null and alias!='', alias, id) as alias
FROM gz_rus_catalog_categories
WHERE parent_id = 636 AND active = 1
ORDER BY rank
[18] => 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,
if(alias is not null and alias!='', alias, P.id) as alias, group_title, ptype_name, PT.link as ptype_link
FROM gz_rus_catalog_products AS P
LEFT JOIN gz_rus_catalog_groups AS G ON P.group_id = G.id
LEFT JOIN gz_rus_catalog_ptypes AS PT ON P.ptype_id = PT.id
WHERE category_id = 636 AND P.active = 1
ORDER BY P.rank, ptype_id LIMIT 0,100
[19] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[20] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[21] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[22] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[23] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[24] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[25] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[26] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[27] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[28] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[29] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[30] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[31] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[32] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[33] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[34] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[35] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[36] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[37] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[38] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[39] => SELECT rank, sum(percent) value FROM gz_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[40] => SELECT prod_id, prop_val_id FROM gz_rus_catalog_order_prop_val WHERE prod_id IN (2346,2356,2366,2376,2386,2396,2406,2416,2426,2436,2446,2456,2466,2476,2486,2496,2506,2516,2526,2536,2546)
[41] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='gz' AND S.id = site_id AND M.id=module_id AND active
[42] => 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 gz_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` = 1 AND IF( C.owner_id = 0,
C.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(C.rights & 0xF0) >> 4,
C.rights & 0xF
)
) > 0
[43] => SELECT count(*) as cnt FROM gz_rus_news_ctgr NC INNER JOIN gz_rus_news n ON NC.news_id=n.id LEFT JOIN gz_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 =1 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
[44] => 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 gz_rus_news_ctgr NC INNER JOIN gz_rus_news n ON NC.news_id=n.id LEFT JOIN gz_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 =1 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,2
[45] => SELECT C.id FROM gz_rus_news_ctgr NC INNER JOIN gz_rus_news_categories C ON C.id=NC.ctgr_id WHERE news_id IN (474,473) AND rss_auto_update AND (DATE_ADD(`rss_last_update`, INTERVAL `rss_update_interval` MINUTE) < NOW() OR `rss_last_update` IS NULL)
[46] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='gz' AND S.id = site_id AND M.id=module_id AND active
[47] => SELECT * FROM gz_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
[48] => SELECT id, parent_id, title, address
FROM gz_rus_pages USE INDEX (index_3)
WHERE parent_id IN (286,296,406,596,336,587,316,526,536,546,436,446,589,466,476,486,496,556,566,366,591,592,586,577,578,595) AND
active = 1
ORDER BY parent_id, id
[49] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='gz' AND S.id = site_id AND M.id=module_id AND active
[50] => SELECT permission_type FROM gz_rus_pages USE INDEX (PRIMARY) WHERE id = 296
[51] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='gz' AND S.id = site_id AND M.id=module_id AND active
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[1886] => $PAGE["modules"]["article"] = new Article('showarticle', '/catalog/?', Array
(
[1] => 76
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[1546] => $PAGE["modules"]["catalog"] = new Catalog('showcatmenu', '/catalog/?', Array
(
[1] =>
[2] => all
[3] =>
[4] =>
[5] =>
)
)
[1536] => $PAGE["modules"]["catalog"]->Catalog('novelties', '/catalog/?', Array
(
[1] =>
[2] => all
[3] =>
[4] =>
[5] =>
)
)
[1406] => $PAGE["modules"]["news"] = new News('tlist_archive', '/news/?', Array
(
[1] => 1
[2] => 2
[3] =>
[4] =>
[5] =>
)
)
[-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
)
)
[-3] => $PAGE["modules"]["pages"]->Pages('showheadtitle', '', Array
(
)
)
[-4] => $PAGE["modules"]["pages"]->Pages('showpath', '', Array
(
)
)
)
Переменные сессии:
Array
(
[session_cur_site_id] => 6
[session_cur_lang_id] => 6
[catalog_rates] => Array
(
[USD/USD] => 1
[BYR/BYR] => 1
[USD/BYR] => 1
[BYR/USD] => 1
[EUR/EUR] => 1
[EUR/BYR] => 2
[BYR/EUR] => 0,5
[EUR/USD] => 1
[USD/EUR] => 1
)
)
Last-modified:
Sat, 07 Dec 2019 17:02:48
