100 busiest triggers

HostTriggerSeverityNumber of status changes
No data found.
******************** Script profiler ********************
Total time: 0.055037
Total SQL time: 0.046995
SQL count: 25 (selects: 20 | executes: 14)
Peak memory usage: 2M
Memory limit: 128M

1. trigger.get [toptriggers.php:174]

Parameters:
Array
(
    [output] => Array
        (
            [0] => triggerid
            [1] => description
            [2] => expression
            [3] => priority
            [4] => lastchange
        )

    [selectHosts] => Array
        (
            [0] => hostid
            [1] => status
            [2] => name
        )

    [triggerids] => Array
        (
        )

    [expandDescription] => 1
    [preservekeys] => 1
)
Result:
Array
(
)


2. host.get [toptriggers.php:196]

Parameters:
Array
(
    [output] => Array
        (
            [0] => hostid
            [1] => status
        )

    [hostids] => Array
        (
        )

    [preservekeys] => 1
)
Result:
Array
(
)



SQL (0.000366): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
toptriggers.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.000296): UPDATE ids SET nextid=2277945 WHERE table_name='auditlog' AND field_name='auditid'
toptriggers.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.000306): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776049583','216.73.216.101','3','0','','2277945')
toptriggers.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.009465): COMMIT
toptriggers.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.000656): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.reports.last'
toptriggers.php:29 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

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

SQL (0.000449): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.toptriggers.filter.severities'
toptriggers.php:83 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000587): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.toptriggers.filter.from'
toptriggers.php:84 → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000399): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.toptriggers.filter.to'
toptriggers.php:84 → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000384): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.toptriggers.filter.active'
toptriggers.php:85 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000399): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.toptriggers.filter.groupids'
toptriggers.php:90 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000369): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.toptriggers.filter.hostids'
toptriggers.php:98 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00033): SELECT usrgrpid FROM users_groups WHERE userid='2'
toptriggers.php:149 → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283

SQL (0.020998): SELECT e.objectid,count(distinct e.eventid) AS cnt_event FROM triggers t,events e WHERE t.triggerid=e.objectid AND e.source=0 AND e.object=0 AND e.clock>='1767200400' AND e.clock<='1776049583' AND t.priority IN (0,1,2,3,4,5) AND EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>0) AND t.flags IN (0,4) GROUP BY e.objectid ORDER BY cnt_event DESC LIMIT 100
toptriggers.php:168 → DBselect() in toptriggers.php:168

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

SQL (0.000364): SELECT t.triggerid,t.description,t.expression,t.priority,t.lastchange FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE t.triggerid=f.triggerid  AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND 1=0 AND t.flags IN (0,4)
toptriggers.php:174 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1068

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

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

SQL (0.000549): SELECT h.hostid,h.status FROM hosts h WHERE h.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND 1=0 AND h.status IN (0,1)
toptriggers.php:196 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:439

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

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

SQL (9.9E-5): BEGIN
toptriggers.php:206 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234

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

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

SQL (0.008923): COMMIT
toptriggers.php:206 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291


Debug