Services

ServiceStatusReasonProblem timeSLA / Acceptable SLA
root
******************** Script profiler ********************
Total time: 0.061102
Total SQL time: 0.023199
SQL count: 19 (selects: 14 | executes: 14)
Peak memory usage: 4M
Memory limit: 128M

1. service.get [srv_status.php:102]

Parameters:
Array ( [output] => Array ( [0] => name [1] => serviceid [2] => showsla [3] => goodsla [4] => algorithm [5] => sortorder ) [selectParent] => Array ( [0] => serviceid ) [selectDependencies] => Array ( [0] => servicedownid [1] => soft [2] => linkid ) [selectTrigger] => Array ( [0] => description [1] => triggerid [2] => expression ) [preservekeys] => 1 )
Result:
Array ( )

2. service.getSla [srv_status.php:128]

Parameters:
Array ( [intervals] => Array ( [0] => Array ( [from] => 1775439244 [to] => 1776044044 ) ) )
Result:
Array ( )


SQL (0.000414): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
srv_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:107

SQL (0.000297): UPDATE ids SET nextid=2277729 WHERE table_name='auditlog' AND field_name='auditid'
srv_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:121

SQL (0.00029): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776044044','216.73.216.101','3','0','','2277729')
srv_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DBexecute() in include/classes/db/DB.php:467

SQL (0.007442): COMMIT
srv_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.00059): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.layout.mode'
srv_status.php:34 → CView::getLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000489): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.view.last'
srv_status.php:36 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000501): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
srv_status.php:36 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000182): BEGIN
srv_status.php:102 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.00015): SELECT usrgrpid FROM users_groups WHERE userid='2'
srv_status.php:102 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CService->get() → CApiService->createSelectQuery() → CApiService->createSelectQueryParts() → CService->applyQueryFilterOptions() → CService->addPermissionFilter() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283

SQL (0.001453): SELECT s.serviceid,s.name,s.showsla,s.goodsla,s.algorithm,s.sortorder,s.triggerid FROM services s WHERE (EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE s.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>0) OR s.triggerid IS NULL)
srv_status.php:102 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CService->get() → DBselect() in include/classes/api/services/CService.php:74

SQL (0.00015): COMMIT
srv_status.php:102 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000143): BEGIN
srv_status.php:128 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000826): SELECT s.serviceid,s.name,s.status,s.algorithm FROM services s WHERE (EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE s.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>0) OR s.triggerid IS NULL)
srv_status.php:128 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CService->getSla() → CService->get() → DBselect() in include/classes/api/services/CService.php:74

SQL (8.5E-5): COMMIT
srv_status.php:128 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000404): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
srv_status.php:185 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000116): BEGIN
srv_status.php:185 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.001179): UPDATE profiles SET value_str='srv_status.php', type=3 WHERE userid=2 AND idx='web.menu.view.last' AND idx2='0'
srv_status.php:185 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.000375): UPDATE profiles SET value_str='srv_status.php', type=3 WHERE userid=2 AND idx='web.paging.lastpage' AND idx2='0'
srv_status.php:185 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.008113): COMMIT
srv_status.php:185 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291


Debug