.
Array
(
[0] => SELECT permission_type FROM abo_rus_pages USE INDEX (PRIMARY) WHERE id = 214
[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 = 214
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] => UPDATE core_users SET onsite=0 WHERE last_visit SELECT * FROM core_users WHERE username = 'ekpa'
[7] => SELECT * FROM core_users WHERE username = 'ekpa'
[8] => SELECT u.*, u.id as su_id, u.username as siteusername, GROUP_CONCAT(DISTINCT ug.group_id SEPARATOR ',') AS groups FROM core_users u LEFT JOIN core_users_groups ug ON ug.user_id = u.id WHERE u.id = 3 GROUP BY u.id
[9] => SELECT * FROM core_users_prop ORDER BY rank
[10] => SELECT * FROM core_users_prop ORDER BY rank
[11] => 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 abo_rus_gallery_categories AS C LEFT JOIN core_users_groups ug ON (ug.group_id = C.usr_group_id AND ug.user_id = 0) WHERE C.owner_id=3 AND IF( C.owner_id = 0,
C.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(C.rights & 0xF0) >> 4,
C.rights & 0xF
)
) > 0 ORDER BY idx
[12] => SELECT * FROM `user_work_resume` WHERE owner_id=3
[13] => SELECT v.id, IF(v.owner_id = 0, 1 , 0) as is_owner,
IF(v.owner_id = 0,
v.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(v.rights & 0xF0) >> 4,
v.rights & 0xF
)
) AS user_rights FROM user_work_vacancy AS v LEFT JOIN core_users_groups ug ON (ug.group_id = v.usr_group_id AND ug.user_id = 0) WHERE v.owner_id=3 AND v.active AND IF( v.owner_id = 0,
v.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(v.rights & 0xF0) >> 4,
v.rights & 0xF
)
) > 0 LIMIT 0,1
[14] => SELECT id FROM `user_friends_form` WHERE owner_id=3
[15] => SELECT id FROM abo_rus_blogs WHERE author_id=3 AND active LIMIT 1
[16] => SELECT siteuser_id FROM abo_rus_blogs_friends WHERE siteuser_id=3 LIMIT 1
[17] => 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 abo_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
[18] => UPDATE abo_rus_polls SET hits=IF(hits > 0, hits + 1, 1) WHERE id=''
[19] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 58770965 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[20] => 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 abo_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 = 47 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2024-04-18' 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
[21] => SELECT * FROM core_users WHERE username = 'ekpa'
[22] => SELECT * FROM core_users_prop ORDER BY rank
[23] => 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 abo_rus_gallery_categories AS C LEFT JOIN core_users_groups ug ON (ug.group_id = C.usr_group_id AND ug.user_id = 0) WHERE C.owner_id=3 AND IF( C.owner_id = 0,
C.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(C.rights & 0xF0) >> 4,
C.rights & 0xF
)
) > 0 ORDER BY idx
[24] => SELECT * FROM `user_work_resume` WHERE owner_id=3
[25] => SELECT v.id, IF(v.owner_id = 0, 1 , 0) as is_owner,
IF(v.owner_id = 0,
v.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(v.rights & 0xF0) >> 4,
v.rights & 0xF
)
) AS user_rights FROM user_work_vacancy AS v LEFT JOIN core_users_groups ug ON (ug.group_id = v.usr_group_id AND ug.user_id = 0) WHERE v.owner_id=3 AND v.active AND IF( v.owner_id = 0,
v.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(v.rights & 0xF0) >> 4,
v.rights & 0xF
)
) > 0 LIMIT 0,1
[26] => SELECT id FROM `user_friends_form` WHERE owner_id=3
[27] => SELECT id FROM abo_rus_blogs WHERE author_id=3 AND active LIMIT 1
[28] => SELECT siteuser_id FROM abo_rus_blogs_friends WHERE siteuser_id=3 LIMIT 1
[29] => SELECT username FROM core_users WHERE id=3
[30] => SELECT * FROM core_users u WHERE u.id=3
[31] => SELECT b.id,b.date AS _date,DATE_FORMAT(b.date,'%d %m %Y | %H:%i') as date,b.title,
b.announce,LENGTH(b.content) as content_length,b.author_id,
b.comments_type, b.preview,
u.email,u.username, count(c.id) as cnt_comments FROM abo_rus_blogs b
INNER JOIN core_users u ON b.author_id=u.id LEFT JOIN abo_rus_comments_resource r ON (r.item_id=b.id AND r.type=3) LEFT JOIN abo_rus_comments c ON c.resrc_id=r.id WHERE b.author_id=3 AND b.active=1 GROUP BY b.id
ORDER BY _date DESC LIMIT 0,1
[32] => SELECT username FROM core_users WHERE id=3
[33] => SELECT C.*, U.username, SUM(G.active) AS cnt, 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 abo_rus_gallery_categories AS C LEFT JOIN abo_rus_gallery AS G ON category_id=C.id LEFT JOIN core_users AS U ON C.owner_id=U.id LEFT JOIN core_users_groups ug ON (ug.group_id = C.usr_group_id AND ug.user_id = 0) WHERE C.active = 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 GROUP BY C.id ORDER BY idx
[34] => SELECT username FROM core_users WHERE id=3
[35] => SELECT u.id,u.username
FROM abo_rus_blogs_friends f, core_users u
WHERE f.siteuser_id=3 AND f.friend_id=u.id AND u.active
ORDER BY u.username
[36] => 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
[37] => SELECT id, title, commentable FROM abo_rus_articles WHERE id=35 AND commentable>0
[38] => SELECT * FROM abo_rus_comments_resource WHERE type=4 AND item_id=35
[39] => SELECT * FROM abo_rus_comments_resource WHERE type=4 AND item_id=35
[40] => UPDATE abo_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='35'
[41] => 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
[42] => 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
[43] => SELECT * FROM abo_rus_pages_context_menu ORDER BY id
)
Array ( )
Array
(
[605] => $PAGE["modules"]["siteusers"] = new Siteusers('welcome', '/siteusers/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - siteusers_userinfo.html
[1358] => $PAGE["modules"]["siteusers"]->SiteusersPrototype('loginform', '/siteusers/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - siteusers_loginform.html
[606] => $PAGE["modules"]["poll"] = new Poll('showpoll', '/poll-result/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - poll_show.html
[608] => $PAGE["modules"]["banners"] = new Banners('showbanner', '/banners/?', Array
(
[1] => 47
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - banners_showbanner.html
[1134] => $PAGE["modules"]["siteusers"]->SiteusersPrototype('usernav', '/siteusers/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - siteusers_usernav.html
[1130] => $PAGE["modules"]["blogs"] = new Blogs('lastuserblog', '/blogs/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - blogs_lastuserblog.html
[1131] => $PAGE["modules"]["gallery"] = new Gallery('userlist', '/gallery/?', Array
(
[1] => 3
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - gallery_usercategories.html
[1135] => $PAGE["modules"]["blogs"]->BlogsPrototype('friends', '/collaborator/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[tpl] =>
)
), tpl - blogs_friends.html
[1359] => $PAGE["modules"]["article"] = new Article('showarticle', '/siteusers/?', 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
)
)