Help|Get support|Print|Profile|Debug|Logout |
|
|
Dashboard | Overview | Web | Latest data | Triggers | Events | Graphs | Screens | Maps | Discovery | IT services Host groups | Templates | Hosts | Maintenance | Web | Actions | Screens | Slide shows | Maps | Discovery | IT services General | DM | Authentication | Users | Media types | Scripts | Audit | Queue | Notifications | Installation |
History: | Configuration of user groups » Dashboard » Configuration of user groups » Configuration of users » Dashboard |
PERSONAL DASHBOARD |
Status of Zabbix
******************** Script profiler ******************** Total time: 0.189394 Total SQL time: 0.085737 SQL count: 17 (selects: 13 | executes: 4) Peak memory usage: 11.75M Memory limit: 128M 1. user->checkAuthentication [class.cwebuser.php:80]
SQL (0.000423): SET NAMES utf8 require_once() -> DBconnect() -> DBexecute() SQL (0.000249): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid require_once() -> DBselect() SQL (0.004353): begin require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.021226): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='83e974be87f843f3882c622146682f7e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1378277964) 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.007835): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.002928): UPDATE sessions SET lastaccess=1378277964 WHERE userid=1 AND sessionid='83e974be87f843f3882c622146682f7e' require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBexecute() SQL (0.012764): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.000371): 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=1 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect() SQL (0.000247): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.015436): commit require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.010824): SELECT p.* FROM profiles p WHERE p.userid=1 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid require_once() -> CProfile::get() -> CProfile::init() -> DBselect() SQL (0.002826): SELECT COUNT(DISTINCT t.triggerid) AS cnt,t.status,t.value FROM triggers t INNER JOIN functions f ON t.triggerid=f.triggerid INNER JOIN items i ON f.itemid=i.itemid INNER JOIN hosts h ON i.hostid=h.hostid WHERE i.status=0 AND h.status=0 GROUP BY t.status,t.value make_status_of_zbx() -> get_status() -> DBselect() SQL (0.001799): SELECT COUNT(*) AS cnt,i.status FROM items i INNER JOIN hosts h ON i.hostid=h.hostid WHERE h.status=0 AND i.status IN ('0','1','3') GROUP BY i.status make_status_of_zbx() -> get_status() -> DBselect() SQL (0.000464): SELECT COUNT(*) AS cnt,h.status FROM hosts h WHERE h.status IN (0,1,3 ) GROUP BY h.status make_status_of_zbx() -> get_status() -> DBselect() SQL (0.000493): SELECT COUNT(*) AS usr_cnt FROM users u WHERE u.userid BETWEEN 000000000000000 AND 099999999999999 make_status_of_zbx() -> get_status() -> DBselect() SQL (0.002595): SELECT s.userid,s.status,MAX(s.lastaccess) AS lastaccess FROM sessions s WHERE s.userid BETWEEN 000000000000000 AND 099999999999999 AND s.status=0 GROUP BY s.userid,s.status make_status_of_zbx() -> get_status() -> DBselect() SQL (0.000904): SELECT SUM(1.0/i.delay) AS qps FROM items i,hosts h WHERE i.status=0 AND i.hostid=h.hostid AND h.status=0 AND i.delay<>0 make_status_of_zbx() -> get_status() -> DBselect() Updated: 08:59:24 System status
******************** Script profiler ******************** Total time: 0.290698 Total SQL time: 0.04955 SQL count: 33 (selects: 18 | executes: 15) Peak memory usage: 14.5M Memory limit: 128M 1. user->checkAuthentication [class.cwebuser.php:80]
2. hostgroup->get [blocks.inc.php:202]
3. trigger->get [blocks.inc.php:250]
4. event->get [blocks.inc.php:269]
SQL (0.007525): SET NAMES utf8 require_once() -> DBconnect() -> DBexecute() SQL (0.004453): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid require_once() -> DBselect() SQL (0.001535): begin require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.002553): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='83e974be87f843f3882c622146682f7e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1378277964) 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.000279): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.000359): 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=1 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect() SQL (0.002769): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.000305): commit require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000781): SELECT p.* FROM profiles p WHERE p.userid=1 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid require_once() -> CProfile::get() -> CProfile::init() -> DBselect() SQL (0.009044): SELECT c.* FROM config c WHERE c.configid BETWEEN 000000000000000 AND 099999999999999 make_system_status() -> getSeverityCaption() -> select_config() -> DBselect() SQL (0.000402): begin make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.002636): commit make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.010109): begin make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000465): SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg WHERE g.groupid=hg.groupid AND EXISTS (SELECT NULL FROM hosts h WHERE hg.hostid=h.hostid AND h.status=0) AND g.groupid BETWEEN 000000000000000 AND 099999999999999 make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHostGroup->get() -> DBselect() SQL (0.000242): commit make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000217): begin make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000212): commit make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.001296): begin make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000804): SELECT DISTINCT t.triggerid,t.value,t.lastchange,t.priority,t.value_flags,t.description,t.error, t.expression,hg.groupid FROM triggers t,functions f,items i,hosts_groups hg WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid IN ('10','11','6','9') AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') ORDER BY lastchange DESC,t.lastchange DESC make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> DBselect() SQL (0.000238): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_down IN ('14070','14147') AND d.triggerid_up=t.triggerid make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> DBselect() SQL (0.000248): SELECT DISTINCT h.hostid,h.name,f.triggerid FROM hosts h,functions f,items i WHERE f.triggerid='14070' AND h.hostid=i.hostid AND f.itemid=i.itemid AND h.status IN (0,1,3) make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> CHost->get() -> DBselect() SQL (0.000515): SELECT DISTINCT f.triggerid,f.functionid,n.ip,n.dns,n.type,n.useip FROM functions f INNER JOIN items i ON f.itemid=i.itemid INNER JOIN interface n ON i.hostid=n.hostid WHERE f.functionid='13546' AND n.main=1 make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> CTriggerHelper::batchExpandDescription() -> CTriggerDescription->batchExpand() -> CTriggerDescription->expandDescriptions() -> CTriggerDescription->expandIpMacros() -> DBselect() SQL (0.00023): commit make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000203): begin make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000201): commit make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000199): begin make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000429): SELECT e.* FROM events e WHERE e.objectid='14070' AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND e.object=0 AND e.value='1' AND e.value_changed='1' ORDER BY e.eventid DESC LIMIT 1 OFFSET 0 make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CEvent->get() -> DBselect() SQL (0.000244): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid='1364322' GROUP BY a.eventid make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CEvent->get() -> DBselect() SQL (0.000209): commit make_system_status() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.00022): SELECT COUNT(a.alertid) AS cnt_all FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) make_system_status() -> makeTriggersPopup() -> get_event_actions_status() -> DBselect() SQL (0.000197): SELECT COUNT(a.alertid) AS sent FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) AND a.status=1 make_system_status() -> makeTriggersPopup() -> get_event_actions_status() -> DBselect() SQL (0.000208): SELECT COUNT(a.alertid) AS inprogress FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) AND a.status=0 make_system_status() -> makeTriggersPopup() -> get_event_actions_status() -> DBselect() SQL (0.000223): SELECT COUNT(a.alertid) AS failed FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) AND a.status=2 make_system_status() -> makeTriggersPopup() -> get_event_actions_status() -> DBselect() Updated: 08:59:24 Host status
******************** Script profiler ******************** Total time: 0.261363 Total SQL time: 0.079639 SQL count: 25 (selects: 10 | executes: 15) Peak memory usage: 14M Memory limit: 128M 1. user->checkAuthentication [class.cwebuser.php:80]
2. hostgroup->get [blocks.inc.php:376]
3. host->get [blocks.inc.php:399]
4. trigger->get [blocks.inc.php:415]
SQL (0.000944): SET NAMES utf8 require_once() -> DBconnect() -> DBexecute() SQL (0.000553): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid require_once() -> DBselect() SQL (0.002904): begin require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000409): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='83e974be87f843f3882c622146682f7e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1378278024) 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.008714): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.00405): 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=1 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect() SQL (0.001789): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.002223): commit require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000572): SELECT p.* FROM profiles p WHERE p.userid=1 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid require_once() -> CProfile::get() -> CProfile::init() -> DBselect() SQL (0.000479): begin make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.015337): commit make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.014592): begin make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.00083): SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg WHERE g.groupid=hg.groupid AND EXISTS (SELECT NULL FROM hosts h WHERE hg.hostid=h.hostid AND h.status=0) AND g.groupid BETWEEN 000000000000000 AND 099999999999999 make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHostGroup->get() -> DBselect() SQL (0.000253): commit make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000384): begin make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000218): commit make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.008085): begin make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000755): SELECT DISTINCT h.hostid,h.name,hg.groupid FROM hosts h,hosts_groups hg WHERE hg.groupid IN ('10','11','6','9') AND hg.hostid=h.hostid AND h.status=0 make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> DBselect() SQL (0.000232): commit make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.002076): begin make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000196): commit make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.002909): begin make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000829): SELECT DISTINCT t.triggerid,t.priority,h.name AS hostname,h.host,h.hostid FROM triggers t,functions f,items i,hosts h WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND h.hostid=i.hostid AND t.triggerid BETWEEN 000000000000000 AND 099999999999999 make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> DBselect() SQL (0.009888): commit make_hoststat_summary() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000418): SELECT c.* FROM config c WHERE c.configid BETWEEN 000000000000000 AND 099999999999999 make_hoststat_summary() -> getSeverityCaption() -> select_config() -> DBselect() Updated: 09:00:24 | Last 20 issues
1 of 2 issues are shown ******************** Script profiler ******************** Total time: 0.347054 Total SQL time: 0.118291 SQL count: 60 (selects: 32 | executes: 28) Peak memory usage: 16.5M Memory limit: 128M 1. user->checkAuthentication [class.cwebuser.php:80]
2. trigger->get [blocks.inc.php:799]
3. trigger->get [blocks.inc.php:804]
4. host->get [blocks.inc.php:828]
5. script->getScriptsByHosts [blocks.inc.php:831]
6. event->get [blocks.inc.php:917]
7. event->get [events.inc.php:230]
SQL (0.000392): SET NAMES utf8 require_once() -> DBconnect() -> DBexecute() SQL (0.000236): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid require_once() -> DBselect() SQL (0.000295): begin require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.00536): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='83e974be87f843f3882c622146682f7e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1378278024) 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.000294): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.000438): UPDATE sessions SET lastaccess=1378278024 WHERE userid=1 AND sessionid='83e974be87f843f3882c622146682f7e' require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBexecute() SQL (0.000364): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.000294): 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=1 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect() SQL (0.010182): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.015882): commit require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.00563): SELECT p.* FROM profiles p WHERE p.userid=1 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid require_once() -> CProfile::get() -> CProfile::init() -> DBselect() SQL (0.00321): SELECT c.* FROM config c WHERE c.configid BETWEEN 000000000000000 AND 099999999999999 make_latest_issues() -> select_config() -> DBselect() SQL (0.000707): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.008941): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.003386): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.00664): SELECT t.triggerid,t.value_flags,t.error,t.url,t.expression,t.description,t.priority,t.type,t.lastchange FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') AND t.triggerid BETWEEN 000000000000000 AND 099999999999999 ORDER BY lastchange DESC,t.lastchange DESC make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> DBselect() SQL (0.00376): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_down IN ('14070','14147') AND d.triggerid_up=t.triggerid make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> DBselect() SQL (0.002201): SELECT DISTINCT h.hostid,h.name,f.triggerid FROM hosts h,functions f,items i WHERE f.triggerid='14070' AND h.hostid=i.hostid AND f.itemid=i.itemid AND h.status IN (0,1,3) make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> CHost->get() -> DBselect() SQL (0.000723): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.001031): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.0006): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000328): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.003206): SELECT COUNT(DISTINCT t.triggerid) as rowscount FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') AND t.triggerid BETWEEN 000000000000000 AND 099999999999999 make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> DBselect() SQL (0.003043): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000437): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000239): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000279): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000795): SELECT h.hostid,h.name,h.maintenance_status,h.maintenance_type,h.maintenanceid FROM hosts h WHERE h.hostid='10098' AND h.status IN (0,1) make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> DBselect() SQL (0.000285): SELECT hin.hostid, hin.hostid FROM host_inventory hin WHERE hin.hostid='10098' make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> DBselect() SQL (0.000924): SELECT ht.* FROM hosts_templates ht WHERE hostid='10098' make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CTemplateScreen->get() -> DBselect() SQL (0.000811): SELECT ht.* FROM hosts_templates ht WHERE hostid='10081' make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CTemplateScreen->get() -> DBselect() SQL (0.000341): SELECT ht.* FROM hosts_templates ht WHERE hostid='10050' make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CTemplateScreen->get() -> DBselect() SQL (0.000561): SELECT count(DISTINCT s.screenid) as rowscount,s.templateid FROM screens s WHERE s.screenid BETWEEN 000000000000000 AND 099999999999999 AND s.templateid IS NOT NULL AND s.templateid IN ('10098','10081','10050') GROUP BY s.templateid make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CTemplateScreen->get() -> DBselect() SQL (0.000209): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000191): begin make_latest_issues() -> CAPIObject->getScriptsByHosts() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000216): commit make_latest_issues() -> CAPIObject->getScriptsByHosts() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000247): begin make_latest_issues() -> CAPIObject->getScriptsByHosts() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000267): SELECT DISTINCT g.groupid,hg.hostid FROM groups g,hosts_groups hg WHERE hg.hostid='10098' AND hg.groupid=g.groupid make_latest_issues() -> CAPIObject->getScriptsByHosts() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CScript->getScriptsByHosts() -> CScript->get() -> CHostGroup->get() -> DBselect() SQL (0.001734): SELECT DISTINCT s.*,hg.hostid FROM scripts s,hosts_groups hg WHERE ((hg.groupid='6' AND hg.groupid=s.groupid) OR (s.groupid IS NULL AND scriptid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY s.name make_latest_issues() -> CAPIObject->getScriptsByHosts() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CScript->getScriptsByHosts() -> CScript->get() -> DBselect() SQL (0.000773): SELECT h.hostid FROM hosts h WHERE h.hostid='10098' AND h.status IN (0,1) make_latest_issues() -> CAPIObject->getScriptsByHosts() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CScript->getScriptsByHosts() -> CScript->get() -> CScript->addRelatedObjects() -> CHost->get() -> DBselect() SQL (0.000787): commit make_latest_issues() -> CAPIObject->getScriptsByHosts() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.006242): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.00798): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.008694): begin make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000877): SELECT e.* FROM events e WHERE e.objectid='14070' AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND e.object='0' AND e.value='1' AND e.value_changed='1' ORDER BY e.eventid DESC LIMIT 1 OFFSET 0 make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CEvent->get() -> DBselect() SQL (0.000248): SELECT a.*,u.alias FROM acknowledges a LEFT JOIN users u ON u.userid=a.userid WHERE a.eventid='1364322' ORDER BY a.clock DESC make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CEvent->get() -> DBselect() SQL (0.000217): commit make_latest_issues() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000574): SELECT DISTINCT f.triggerid,f.functionid,n.ip,n.dns,n.type,n.useip FROM functions f INNER JOIN items i ON f.itemid=i.itemid INNER JOIN interface n ON i.hostid=n.hostid WHERE f.functionid='13546' AND n.main=1 make_latest_issues() -> CEventHelper::expandDescription() -> CTriggerDescription->expand() -> CTriggerDescription->expandDescriptions() -> CTriggerDescription->expandIpMacros() -> DBselect() SQL (0.000233): SELECT COUNT(a.alertid) AS cnt FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) make_latest_issues() -> get_event_actions_stat_hints() -> DBselect() SQL (0.000211): SELECT COUNT(a.alertid) AS sent FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) AND a.status=1 make_latest_issues() -> get_event_actions_stat_hints() -> DBselect() SQL (0.001062): SELECT DISTINCT a.alertid,mt.description,u.alias,a.subject,a.message,a.sendto,a.status,a.retries,a.alerttype FROM events e,alerts a LEFT JOIN users u ON u.userid=a.userid LEFT JOIN media_type mt ON mt.mediatypeid=a.mediatypeid WHERE a.eventid=1364322 AND a.status=1 AND e.eventid=a.eventid AND a.alerttype IN (0,1) AND a.alertid BETWEEN 000000000000000 AND 099999999999999 ORDER BY a.alertid LIMIT 30 OFFSET 0 make_latest_issues() -> get_event_actions_stat_hints() -> get_actions_hint_by_eventid() -> DBselect() SQL (0.000257): SELECT COUNT(a.alertid) AS inprogress FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) AND a.status=0 make_latest_issues() -> get_event_actions_stat_hints() -> DBselect() SQL (0.000227): SELECT COUNT(a.alertid) AS failed FROM alerts a WHERE a.eventid=1364322 AND a.alerttype IN (0,1) AND a.status=2 make_latest_issues() -> get_event_actions_stat_hints() -> DBselect() SQL (0.002372): SELECT DISTINCT a.alertid,mt.description,u.alias,a.subject,a.message,a.sendto,a.status,a.retries,a.alerttype FROM events e,alerts a LEFT JOIN users u ON u.userid=a.userid LEFT JOIN media_type mt ON mt.mediatypeid=a.mediatypeid WHERE a.eventid=1364322 AND a.status=2 AND e.eventid=a.eventid AND a.alerttype IN (0,1) AND a.alertid BETWEEN 000000000000000 AND 099999999999999 ORDER BY a.alertid LIMIT 30 OFFSET 0 make_latest_issues() -> get_event_actions_stat_hints() -> get_actions_hint_by_eventid() -> DBselect() SQL (0.000812): begin make_latest_issues() -> make_popup_eventlist() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000375): commit make_latest_issues() -> make_popup_eventlist() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000373): begin make_latest_issues() -> make_popup_eventlist() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.000734): SELECT e.* FROM events e WHERE e.objectid='14070' AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND e.eventid<=1364322 AND e.object='0' AND e.value_changed='1' ORDER BY e.eventid DESC LIMIT 20 OFFSET 0 make_latest_issues() -> make_popup_eventlist() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CEvent->get() -> DBselect() SQL (0.00026): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid IN ('1364322','1296749','1296526','1267923','1267814','1195436','1195434','1195424','1195420','1171026','1171024','1171007','1171002','1170887','1170884','1140186','1140183','1140060','1140057','1139918') GROUP BY a.eventid make_latest_issues() -> make_popup_eventlist() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CEvent->get() -> DBselect() SQL (0.000304): commit make_latest_issues() -> make_popup_eventlist() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() Updated: 09:00:24 Web monitoring
******************** Script profiler ******************** Total time: 0.21285 Total SQL time: 0.029183 SQL count: 20 (selects: 9 | executes: 11) Peak memory usage: 13M Memory limit: 128M 1. user->checkAuthentication [class.cwebuser.php:80]
2. hostgroup->get [blocks.inc.php:974]
3. host->get [blocks.inc.php:994]
SQL (0.000365): SET NAMES utf8 require_once() -> DBconnect() -> DBexecute() SQL (0.00021): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid require_once() -> DBselect() SQL (0.000599): begin require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.006928): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='83e974be87f843f3882c622146682f7e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1378278024) 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.000358): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.000293): 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=1 require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect() SQL (0.00023): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=1 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.000227): commit require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.004889): SELECT p.* FROM profiles p WHERE p.userid=1 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid require_once() -> CProfile::get() -> CProfile::init() -> DBselect() SQL (0.00445): begin make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.001753): commit make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000677): begin make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.001076): SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg WHERE g.groupid=hg.groupid AND EXISTS (SELECT NULL FROM hosts h WHERE hg.hostid=h.hostid AND h.status=0) AND EXISTS (SELECT NULL FROM hosts h,applications a,httptest ht WHERE hg.hostid=h.hostid AND hg.hostid=a.hostid AND a.applicationid=ht.applicationid AND h.status=0 AND ht.status=0) AND g.groupid BETWEEN 000000000000000 AND 099999999999999 make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHostGroup->get() -> DBselect() SQL (0.000235): commit make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000223): begin make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.00068): commit make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.000524): begin make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute() SQL (0.001261): SELECT DISTINCT h.hostid FROM hosts h,hosts_groups hg WHERE hg.groupid='6' AND hg.hostid=h.hostid AND h.status=0 make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> DBselect() SQL (0.000285): commit make_webmon_overview() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute() SQL (0.00392): SELECT DISTINCT ht.httptestid,i.lastclock,i.lastvalue FROM items i,httptestitem hti,httptest ht,applications a,hosts_groups hg WHERE i.itemid=hti.itemid AND hti.httptestid=ht.httptestid AND ht.applicationid=a.applicationid AND a.hostid=hg.hostid AND hti.type=3 AND ht.status=0 AND hg.hostid IN ('10087','10088','10084','10093','10096','10097','10098','10099','10117','10118','10122') AND hg.groupid=6 make_webmon_overview() -> DBselect() Updated: 09:00:24 |
Parameters:83e974be87f843f3882c622146682f7e | Result:Array ( [userid] => 1 [alias] => Admin [name] => Zabbix [surname] => Administrator [url] => [autologin] => 1 [autologout] => 0 [lang] => en_GB [refresh] => 55 [type] => 3 [theme] => default [attempt_failed] => 0 [attempt_ip] => 10.242.2.10 [attempt_clock] => 1378113180 [rows_per_page] => 50 [debug_mode] => 1 [userip] => 192.168.5.246 [node] => Array ( [name] => - unknown - [nodeid] => 0 ) [sessionid] => 83e974be87f843f3882c622146682f7e [gui_access] => 0 ) |
Parameters:Array ( [sysmapids] => Array ( ) [output] => Array ( [0] => sysmapid [1] => name ) ) | Result:Array ( ) |
Zabbix 2.0.5 Copyright 2001-2012 by Zabbix SIA | | Connected as 'Admin' |