Отладочная информация:
Время генерации страницы:
Time: 1.123 sec.
QUERY STRING:
lang=&link=catalog/
Шаблон страницы:
_index1.html
SQL-запросы на странице:
Array
(
[0] => SELECT permission_type FROM outin_rus_pages USE INDEX (PRIMARY) WHERE id = 139
[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 outin_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , outin_rus_pages_blocks as pb , outin_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 block_rank
[2] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' 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 outin_rus_articles a LEFT JOIN core_users_groups ug ON (ug.group_id = a.usr_group_id AND ug.user_id = 0) WHERE id = 124 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 outin_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='124'
[5] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[6] => UPDATE core_users SET last_visit=NOW(), onsite=0 WHERE last_visit SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[8] => show columns from `outin_rus_catalog_categories`
[9] => show columns from `outin_rus_catalog_products`
[10] => SELECT C.id, C.parent_id, C.title, C.clevel, C.rank, COUNT(P.id) as cnt FROM outin_rus_catalog_categories AS C
LEFT JOIN outin_rus_catalog_categories AS C1 ON ( C1.cleft >= C.cleft AND C1.cright <= C.cright)
LEFT JOIN outin_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
[11] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(59)
[12] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(55)
[13] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(1)
[14] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(0)
[15] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(60)
[16] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(61)
[17] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(62)
[18] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(63)
[19] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(57)
[20] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(56)
[21] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(1)
[22] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(0)
[23] => select id, parent_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_categories where id in(58)
[24] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[25] => SELECT * FROM outin_rus_catalog_categories WHERE clevel = 1 AND active = 1 ORDER BY rank
[26] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=55 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[27] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (55, 55, 59, 60, 61, 62, 63) AND active
[28] => SELECT id, title, description, img
FROM outin_rus_catalog_categories
WHERE parent_id = 55 AND active = 1
ORDER BY rank
[29] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=59 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[30] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (59, 59) AND active
[31] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=60 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[32] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (60, 60) AND active
[33] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=61 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[34] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (61, 61) AND active
[35] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=62 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[36] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (62, 62) AND active
[37] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=63 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[38] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (63, 63) AND active
[39] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=56 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[40] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (56, 56, 57, 58) AND active
[41] => SELECT id, title, description, img
FROM outin_rus_catalog_categories
WHERE parent_id = 56 AND active = 1
ORDER BY rank
[42] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=57 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[43] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (57, 57) AND active
[44] => SELECT CH.id FROM outin_rus_catalog_categories AS P, outin_rus_catalog_categories AS CH WHERE P.id=58 AND CH.cleft >= P.cleft AND CH.cright <= P.cright AND CH.active
[45] => SELECT COUNT(*) AS cnt FROM outin_rus_catalog_products WHERE category_id IN (58, 58) AND active
[46] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[47] => SELECT * FROM outin_rus_catalog_ptypes ORDER BY id
[48] => SELECT * FROM outin_rus_catalog_groups
[49] => SELECT g.id, p.property_id FROM outin_rus_catalog_groups g
LEFT JOIN outin_rus_catalog_properties p ON g.id=p.group_id AND p.search=1
ORDER BY g.id, property_id
[50] => SELECT DISTINCT p.property_id, p.range, pt.property_title, pt.property_name, pt.property_prefix, pt.property_suffix, pt.type, pdv.value
FROM outin_rus_catalog_properties p
JOIN outin_rus_catalog_properties_table pt
LEFT JOIN outin_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.property_id, pdv.value
[51] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[52] => SELECT p.*, pt.ptype_name, pt.link as ptype_link
FROM outin_rus_catalog_products p
LEFT JOIN outin_rus_catalog_ptypes pt ON p.ptype_id = pt.id
WHERE 1 AND active = 1 AND leader
ORDER BY rank DESC LIMIT 0,3
[53] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_products where id = 86
[54] => SELECT rank, sum(percent) value FROM outin_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[55] => SELECT rank, sum(percent) value FROM outin_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[56] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_products where id = 82
[57] => SELECT rank, sum(percent) value FROM outin_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[58] => SELECT rank, sum(percent) value FROM outin_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[59] => select id, category_id, if(alias is not null and alias!='',alias,id) as path from outin_rus_catalog_products where id = 55
[60] => SELECT rank, sum(percent) value FROM outin_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[61] => SELECT rank, sum(percent) value FROM outin_rus_shop_taxes
WHERE active = 1
GROUP BY rank
ORDER BY rank
[62] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[63] => SELECT *
FROM outin_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
[64] => SELECT id, parent_id, title, address
FROM outin_rus_pages USE INDEX (index_3)
WHERE parent_id IN (218,243,139,219,202,245,198,221,208,215,210,152,211,212,214,206,207,220,209,205,213,201,237,244,251,246,253,230,229) AND
active = 1
ORDER BY id
[65] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[66] => SELECT id, parent_id, title, address
FROM outin_rus_pages USE INDEX (index_3)
WHERE parent_id IN (218,243,139,219,202,245,198,221,208,215,210,152,211,212,214,206,207,220,209,205,213,201,237,244,251,246,253,230,229) AND
active = 1
ORDER BY id
[67] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[68] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[69] => SELECT permission_type FROM outin_rus_pages USE INDEX (PRIMARY) WHERE id = 139
[70] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
)
Cache: use_cache =
Array
(
)
Вызываемые функции:
Array
(
[777] => $PAGE["modules"]["article"] = new Article('showarticle', '/catalog/?', Array
(
[1] => 124
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[497] => $PAGE["modules"]["siteusers"] = new Siteusers('loginform', '/catalog/siteusers/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[980] => $PAGE["modules"]["catalog"] = new Catalog('showtree', '/catalog/?', Array
(
[1] =>
[2] =>
[3] => 1
[4] =>
[5] =>
)
)
[178] => $PAGE["modules"]["catalog"]->Catalog('showtoplevels', '/catalog/?', Array
(
[1] => 10
[2] => 55
[3] => 1
[4] =>
[5] =>
)
)
[982] => $PAGE["modules"]["catalog"]->Catalog('showsearchform', '/catalog/?', Array
(
[1] => 2
[2] => all
[3] => all
[4] =>
[5] =>
)
)
[1041] => $PAGE["modules"]["catalog"]->Catalog('showleaders', '/catalog/?', Array
(
[1] => 3
[2] => all
[3] =>
[4] =>
[5] =>
)
)
[-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
)
)
[-2] => $PAGE["modules"]["pages"]->Pages('showsubmenu', '', Array
(
)
)
[-10] => $PAGE["modules"]["pages"]->Pages('showchilds', '', Array
(
)
)
[-3] => $PAGE["modules"]["pages"]->Pages('showheadtitle', '', Array
(
)
)
[-4] => $PAGE["modules"]["pages"]->Pages('showpath', '', Array
(
)
)
)
Переменные сессии:
Array
(
[session_cur_site_id] => 1
[session_cur_lang_id] => 1
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 24.4389
[RUR/USD] => 0.040918371939817
[EUR/EUR] => 1
[EUR/RUR] => 36.0083
[RUR/EUR] => 0.027771374933002
[EUR/USD] => 1.4734
[USD/EUR] => 0.67870232116194
)
)
Last-modified:
Wed, 10 Mar 2010 23:41:09
