******************** Script profiler ******************** Total time: 0.07649 Total SQL time: 0.011135 SQL count: 27 (selects: 16 | executes: 11) Peak memory usage: 14.25M Memory limit: 128M 1. user->checkAuthentication [class.cwebuser.php:80] Parameters: 628f6ed6c1165c90054cf10b489e57fa Result: Array ( [userid] => 3 [alias] => tester [name] => nikolas [surname] => cage [url] => [autologin] => 1 [autologout] => 0 [lang] => en_GB [refresh] => 30 [type] => 2 [theme] => default [attempt_failed] => 0 [attempt_ip] => [attempt_clock] => 0 [rows_per_page] => 50 [debug_mode] => 1 [userip] => 192.168.56.1 [node] => Array ( [name] => - unknown - [nodeid] => 0 ) [sessionid] => 628f6ed6c1165c90054cf10b489e57fa [gui_access] => 0 ) 2. map->get [sysmaps.php:272] Parameters: Array ( [editable] => 1 [output] => Array ( [0] => sysmapid [1] => name [2] => width [3] => height ) [sortfield] => name [sortorder] => DESC [limit] => 1001 ) Result: Array ( [0] => Array ( [urls] => Array ( [0] => Array ( [sysmapurlid] => 1 [name] => yandex [url] => http://yandex.ru [elementtype] => 3 ) [1] => Array ( [sysmapurlid] => 2 [name] => Zabbix [url] => http://zabbix.com [elementtype] => 1 ) ) [sysmapid] => 2 [name] => http://yandex.ru [width] => 800 [height] => 600 ) [1] => Array ( [urls] => Array ( [0] => Array ( [sysmapurlid] => 3 [name] => haha [url] => http://mysqlpercomanceblog.com:80 [elementtype] => 0 ) ) [sysmapid] => 3 [name] => http://mysq.org.com:6546 [width] => 800 [height] => 600 ) [2] => Array ( [urls] => Array ( [0] => Array ( [sysmapurlid] => 4 [name] => ba [url] => http://112912:775 [elementtype] => 2 ) [1] => Array ( [sysmapurlid] => 5 [name] => coco [url] => ftp://miriri.yandex.ru [elementtype] => 0 ) ) ) ) SQL (0.000359): SET NAMES utf8 require_once() -> DBconnect() -> DBexecute() SQL (0.000274): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid require_once() -> DBselect() SQL (0.000337): begin require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000763): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='628f6ed6c1165c90054cf10b489e57fa' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1367604209) OR (u.autologout=0)) AND u.userid BETWEEN 000000000000000 AND 099999999999999 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect() SQL (0.000218): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> check_perm2system() -> DBselect() SQL (0.000464): UPDATE sessions SET lastaccess=1367604209 WHERE userid=3 AND sessionid='628f6ed6c1165c90054cf10b489e57fa' require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBexecute() SQL (0.000159): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect() SQL (0.000197): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid=3 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect() SQL (0.00019): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect() SQL (0.000661): commit require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.00029): SELECT p.* FROM profiles p WHERE p.userid=3 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid require_once() -> zbx_construct_menu() -> CProfile::update() -> CProfile::init() -> DBselect() SQL (0.000263): SELECT c.* FROM config c WHERE c.configid BETWEEN 000000000000000 AND 099999999999999 require_once() -> select_config() -> DBselect() SQL (0.000409): SELECT uh.title1,uh.url1,uh.title2,uh.url2,uh.title3,uh.url3,uh.title4,uh.url4,uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=3 require_once() -> get_user_history() -> DBselect() SQL (0.00036): begin CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000254): commit CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000191): begin CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000774): SELECT s.sysmapid,s.name,s.width,s.height FROM sysmaps s WHERE s.sysmapid BETWEEN 000000000000000 AND 099999999999999 ORDER BY s.name DESC LIMIT 1001 OFFSET 0 CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> DBselect() SQL (0.00063): SELECT slt.triggerid,sl.sysmapid FROM sysmaps_link_triggers slt,sysmaps_links sl WHERE sl.sysmapid IN ('4','1','2','3') AND sl.linkid=slt.linkid CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> DBselect() SQL (0.00078): SELECT se.* FROM sysmaps_elements se WHERE se.sysmapid IN ('4','1','2','3') CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> DBselect() SQL (0.000235): SELECT usrgrpid FROM users_groups WHERE userid=3 CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> CHost->get() -> getUserGroupsByUserId() -> DBselect() SQL (0.000231): SELECT h.hostid FROM hosts h WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='13' WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>=3) AND h.hostid='10084' AND h.status IN (0,1) CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> CHost->get() -> DBselect() SQL (0.000515): SELECT su.* FROM sysmap_url su WHERE su.sysmapid IN ('4','1','2','3') CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> DBselect() SQL (0.000219): commit CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000355): SELECT uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=3 require_once() -> add_user_history() -> DBselect() SQL (0.000342): begin require_once() -> CProfile::flush() -> DBstart() -> DBexecute() SQL (0.000991): UPDATE profiles SET value_str='DESC', type=3 WHERE userid=3 AND idx='web.sysmaps.php.sortorder' AND profileid BETWEEN 000000000000000 AND 099999999999999 require_once() -> CProfile::flush() -> CProfile::updateDB() -> DBexecute() SQL (0.000674): commit require_once() -> CProfile::flush() -> DBend() -> DBcommit() -> DBexecute()