Отладочная информация:
Время генерации страницы:
Time: 0,103 sec.
QUERY STRING:
lang=&link=catalog/&action=list_ptype&ptype=8
Шаблон страницы:
_index1.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM abo_rus_pages USE INDEX (PRIMARY) WHERE id = 139
[1] => SELECT id, language FROM sites_languages
[2] => 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 abo_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , abo_rus_pages_blocks as pb , abo_rus_pages_templates as pt , modules as m WHERE p.id = 139
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
[3] => SELECT id, language FROM sites_languages
[4] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='abo' AND S.id = site_id AND M.id=module_id AND active
[5] => SELECT * FROM abo_rus_catalog_ptypes WHERE id = 8
[6] => SELECT p.id, count(*)=1 AS dinamic_true, p.product_title, p.product_inf, p.image_middle, p.image_big,
product_code, p.product_availability, p.price_1, p.price_2, p.price_3, p.price_4, p.price_5, p.currency, p.rank,
p.active, if(p.alias is not null and p.alias!='', p.alias, p.id) as prod_alias,
if(c.alias is not null and c.alias!='', c.alias, c.id) as ctg_alias, ptype_name, ptype_id, pt.logo as ptype_logo, pt.link as ptype_link
FROM abo_rus_catalog_products p INNER JOIN abo_rus_catalog_categories c ON p.category_id=c.id LEFT JOIN abo_rus_catalog_ptypes AS pt ON p.ptype_id=pt.id WHERE p.active = 1 AND p.ptype_id=pt.id AND p.ptype_id=8 GROUP BY id HAVING count(*)=1 ORDER BY p.rank LIMIT 0, 20
[7] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[8] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[9] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[10] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[11] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[12] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[13] => SELECT prod_id, prop_val_id FROM abo_rus_catalog_order_prop_val WHERE prod_id IN (121,124)
[14] => SELECT p.id FROM abo_rus_catalog_products p INNER JOIN abo_rus_catalog_categories c ON p.category_id=c.id LEFT JOIN abo_rus_catalog_ptypes AS pt ON p.ptype_id=pt.id WHERE p.active = 1 AND p.ptype_id=pt.id AND p.ptype_id=8 GROUP BY id HAVING count(*)=1
[15] => SELECT *, if(alias is not null and alias!='', alias, id) as ctgr_alias FROM abo_rus_catalog_categories WHERE id=0
[16] => SELECT id, parent_id, title, clevel, rank, if(alias is not null and alias!='', alias, id) as alias FROM abo_rus_catalog_categories AS C WHERE C.active=1 ORDER BY clevel, rank
[17] => SELECT S.id FROM abo_rus_catalog_categories AS P INNER JOIN abo_rus_catalog_categories AS S ON S.cleft BETWEEN P.cleft AND P.cright WHERE P.id=75
[18] => 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, ptype_id, ptype_name, pt.link as ptype_link, pt.logo as ptype_logo
FROM abo_rus_catalog_products p INNER JOIN abo_rus_catalog_categories c ON c.id=p.category_id
LEFT JOIN abo_rus_catalog_ptypes pt ON p.ptype_id = pt.id
WHERE category_id IN (75, 75, 77, 78) AND p.active = 1 AND leader
ORDER BY p.rank DESC
[19] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[20] => SELECT rank, sum(percent) value FROM abo_rus_shop_taxes WHERE active = 1 GROUP BY rank ORDER BY rank
[21] => SELECT prod_id, prop_val_id FROM abo_rus_catalog_order_prop_val WHERE prod_id IN (111)
[22] => UPDATE core_users SET onsite=0 WHERE last_visit SELECT * FROM abo_rus_catalog_ptypes ORDER BY rank
[24] => SELECT * FROM abo_rus_catalog_groups ORDER BY group_title DESC
[25] => SELECT g.id, p.property_id FROM abo_rus_catalog_groups g
LEFT JOIN abo_rus_catalog_properties p ON g.id=p.group_id AND p.search=1
ORDER BY g.id, property_id
[26] => SELECT DISTINCT p.property_id, p.range, pt.property_title, pt.property_name, pt.property_prefix, pt.property_suffix, pt.type, pdv.value
FROM abo_rus_catalog_properties p
JOIN abo_rus_catalog_properties_table pt
LEFT JOIN abo_rus_catalog_properties_def_values pdv ON p.property_id = pdv.property_id
WHERE p.search = 1
AND p.property_id = pt.id
ORDER BY p.ord, pdv.value
[27] => 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 abo_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 35 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
[28] => SELECT id, title, commentable FROM abo_rus_articles WHERE id=35 AND commentable>0
[29] => SELECT * FROM abo_rus_comments_resource WHERE type=4 AND item_id=35
[30] => SELECT * FROM abo_rus_comments_resource WHERE type=4 AND item_id=35
[31] => UPDATE abo_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='35'
[32] => SELECT * FROM abo_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
[33] => SELECT id, parent_id, title, address
FROM abo_rus_pages USE INDEX (index_3)
WHERE parent_id IN (279,276,285,277,280,281,253,251,283,278) AND
active = 1
ORDER BY page_rank desc
[34] => SELECT * FROM abo_rus_pages_context_menu ORDER BY id
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[1338] => $PAGE["modules"]["catalog"] = new Catalog('list_ptype', '/catalog/?', Array
(
[1] =>
[2] => all
[3] => 1
[4] =>
[5] =>
[tpl] =>
)
), tpl - catalog_list_ptype.html
[1340] => $PAGE["modules"]["catalog"]->CatalogPrototype('showtree', '/catalog/?', Array
(
[1] =>
[2] => all
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - catalog_cat_tree.html
[1339] => $PAGE["modules"]["catalog"]->CatalogPrototype('showleaders', '/catalog/?', Array
(
[1] =>
[2] => 75
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - catalog_leaders.html
[497] => $PAGE["modules"]["siteusers"] = new Siteusers('loginform', '/siteusers/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - siteusers_loginform.html
[982] => $PAGE["modules"]["catalog"]->CatalogPrototype('showsearchform', '/catalog/?', Array
(
[1] => 5
[2] =>
[3] => all
[4] => stdClass Object
(
[name] => 1
[code] =>
[ptype] => 1
[price] => 1
[group] => 1
[availability] => 1
[sort] => 1
)
[5] =>
[tpl] =>
)
), tpl - catalog_searchform.html
[777] => $PAGE["modules"]["article"] = new Article('showarticle', '/catalog/?', Array
(
[1] => 35
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - article.html
[-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
)
), tpl - pages_menu.html
[-4] => $PAGE["modules"]["pages"]->PagesPrototype('showpath', '', Array
(
)
), tpl - pages_path.html
)
Переменные сессии:
Array
(
[session_cur_site_id] => 1
[session_cur_lang_id] => 1
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 30,0785
[RUR/USD] => 0,033246338746945
[EUR/EUR] => 1
[EUR/RUR] => 44,0259
[RUR/EUR] => 0,022713902498302
[EUR/USD] => 1,4637
[USD/EUR] => 0,68320010931202
)
)
Last-modified:
Fri, 19 Apr 2024 05:58:42
