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