******************** Script profiler ********************
Total time: 202.612771
Total SQL time: 202.289437
SQL count: 97 (selects: 96 | executes: 1)
Peak memory usage: 14M
Memory limit: 128M


SQL (0.001343): ALTER SESSION SET NLS_NUMERIC_CHARACTERS='. '
zabbix.php:21 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:116

SQL (0.01211): SELECT table_name FROM user_tables WHERE table_name='DBVERSION'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → OracleDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/OracleDbBackend.php:33

SQL (0.001537): SELECT dv.mandatory,dv.optional FROM dbversion dv
zabbix.php:21 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in include/classes/db/DbBackend.php:46

SQL (0.001257): SELECT NULL FROM config c
zabbix.php:21 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkConfig() → DBselect() in include/classes/db/DbBackend.php:62

SQL (0.001722): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='23810ce4a76ff1b6f9ca75d9547d35ab' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1471962357 OR u.autologout=0)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1197

SQL (0.001605): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='52' AND g.usrgrpid=ug.usrgrpid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1230

SQL (0.001796): 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='52'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1254

SQL (0.001584): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='52' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1262

SQL (0.002224): SELECT p.* FROM profiles p WHERE p.userid=52 ORDER BY p.userid,p.profileid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetIssuesView->doAction() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:42

SQL (0.002409): SELECT c.* FROM config c
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetIssuesView->doAction() → select_config() → DBselect() in include/profiles.inc.php:33

SQL (0.001213): SELECT usrgrpid FROM users_groups WHERE userid='52'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:304

SQL (88.935793): SELECT * FROM (SELECT   t.triggerid,t.expression,t.description,t.url,t.priority,t.lastchange,t.comments,t.error,t.state 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 IN ('13','25') 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 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.priority IN ('2','3','4','5') AND t.value='1' AND t.flags IN ('0','4') ORDER BY t.lastchange DESC) WHERE rownum BETWEEN 0 AND 40
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:987

SQL (0.63126): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND (d.triggerid_down BETWEEN '42880' AND '42885' OR d.triggerid_down IN ('30149','38032','42887','42888','42889','42890','77541','88222','88245','88248'))
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1835

SQL (0.058435): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down='42883'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1835

SQL (0.001856): SELECT t.triggerid FROM triggers t,functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status=1 OR h.status=1 OR t.status=1) AND t.triggerid='42883'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1876

SQL (0.002032): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN ('30149','38032','42883','77541','88222','88245','88248') AND f.itemid=i.itemid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:325

SQL (0.029681): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid IN ('10298','10981','11143','11193','11775','11997') AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.003365): SELECT e.objectid,e.ns,e.eventid,e.acknowledged,e.clock FROM events e JOIN (SELECT e2.source,e2.object,e2.objectid,MAX(clock) AS clock FROM events e2 WHERE e2.source=0 AND e2.object=0 AND e2.objectid IN ('30149','38032','42883','77541','88222','88245','88248') GROUP BY e2.source,e2.object,e2.objectid) e3 ON e3.source=e.source AND e3.object=e.object AND e3.objectid=e.objectid AND e3.clock=e.clock
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → DBselect() in include/classes/api/services/CTrigger.php:1709

SQL (112.245468): SELECT   COUNT(DISTINCT t.triggerid) AS rowscount 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 IN ('13','25') 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 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.priority IN ('2','3','4','5') AND t.value='1' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → DBselect() in include/classes/api/services/CTrigger.php:425

SQL (0.018152): SELECT   e.eventid FROM events e WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE e.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND e.eventid IN ('46401939','55353114','57425918','57804982','58017575','58018167','58018215') AND e.object='0' AND e.source='0'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.014283): SELECT  DISTINCT  a.*,u.alias,u.name,u.surname FROM acknowledges a,users u WHERE a.eventid IN ('46401939','55353114','57425918','57804982','58017575','58018167','58018215') AND a.userid=u.userid ORDER BY a.clock DESC
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:581

SQL (0.002279): SELECT a.eventid,a.mediatypeid,a.userid,a.clock,a.message,a.status,a.alerttype,a.error FROM alerts a WHERE a.eventid IN ('46401939','55353114','57425918','57804982','58017575','58018167','58018215') AND a.alerttype IN (0,1) ORDER BY a.alertid DESC
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → makeEventsActions() → DBselect() in include/actions.inc.php:1245

SQL (0.002956): SELECT  DISTINCT  u.userid,u.alias,u.name,u.surname FROM users u,users_groups ug WHERE u.userid=ug.userid AND ug.usrgrpid IN ( SELECT uug.usrgrpid FROM users_groups uug WHERE uug.userid=52) AND u.userid IN ('42','110')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → makeEventsActions() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->get() → DBselect() in include/classes/api/services/CUser.php:165

SQL (0.005294): SELECT  DISTINCT  g.groupid FROM groups g,hosts_groups hg WHERE EXISTS (SELECT NULL FROM rights r WHERE g.groupid=r.id AND r.groupid IN ('13','25') GROUP BY r.id HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hg.hostid IN ('10298','10981','11143','11193','11775','11997') AND hg.groupid=g.groupid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->getScriptsByHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScript->getScriptsByHosts() → CScript->get() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:324

SQL (0.006265): SELECT   s.* FROM scripts s WHERE (s.usrgrpid IS NULL OR s.usrgrpid IN ('13','25')) AND (s.groupid IS NULL OR EXISTS (SELECT NULL FROM rights r WHERE s.groupid=r.id AND r.groupid IN ('13','25') GROUP BY r.id HAVING MIN(r.permission)>0)) AND (s.groupid IN ('13','22','33','48','55','59','60','66','69','93','149','168','169') OR s.groupid IS NULL) ORDER BY s.name
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->getScriptsByHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScript->getScriptsByHosts() → CScript->get() → DBselect() in include/classes/api/services/CScript.php:161

SQL (0.021651): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('10298','10981','11143','11193','11775','11997') AND h.status IN (0,1)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->getScriptsByHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CScript->getScriptsByHosts() → CScript->get() → CScript->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.019652): SELECT   h.hostid,h.name,h.status,h.maintenance_status,h.maintenance_type,h.maintenanceid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('10298','10981','11143','11193','11775','11997') AND h.status IN (0,1)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.054693): SELECT  DISTINCT  COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE g.graphid=gi.graphid AND gi.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 NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE g.ymin_type=2 AND g.ymin_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 NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE g.ymax_type=2 AND g.ymax_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 i.hostid IN ('10298','10981','11143','11193','11775','11997') AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:296

SQL (0.003415): SELECT ht.* FROM hosts_templates ht WHERE hostid IN ('10298','10981','11143','11193','11775','11997')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:175

SQL (0.003538): SELECT ht.* FROM hosts_templates ht WHERE hostid IN ('10567','10577','10594','11055','11089','11133','11198')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:175

SQL (0.002679): SELECT ht.* FROM hosts_templates ht WHERE hostid IN ('10567','10594','11174','13530','14218')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:175

SQL (0.002106): SELECT ht.* FROM hosts_templates ht WHERE hostid='13530'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:175

SQL (0.002963): SELECT   COUNT(DISTINCT s.screenid) AS rowscount,s.templateid FROM screens s WHERE s.templateid IS NOT NULL AND s.templateid IN ('10298','10567','10577','10594','10981','11055','11089','11133','11143','11174','11193','11198','11775','11997','13530','14218') GROUP BY s.templateid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:208

SQL (0.036769): SELECT m.maintenanceid FROM maintenances m WHERE NOT EXISTS (SELECT NULL FROM maintenances_hosts mh,hosts_groups hg LEFT JOIN rights r ON r.id=hg.groupid AND r.groupid IN ('13','25') WHERE m.maintenanceid=mh.maintenanceid AND mh.hostid=hg.hostid GROUP by mh.hostid HAVING MIN(r.permission) IS NULL OR MIN(r.permission)=0 OR MAX(r.permission)<'2') AND NOT EXISTS (SELECT NULL FROM maintenances_groups mg LEFT JOIN rights r ON r.id=mg.groupid AND r.groupid IN ('13','25') WHERE m.maintenanceid=mg.maintenanceid GROUP by mg.groupid HAVING MIN(r.permission) IS NULL OR MIN(r.permission)=0 OR MAX(r.permission)<'2') AND m.maintenanceid IN ('7384','7800','8409','8765')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMaintenance->get() → DBselect() in include/classes/api/services/CMaintenance.php:196

SQL (0.001752): SELECT   m.maintenanceid,m.name,m.description FROM maintenances m WHERE m.maintenanceid IN ('7384','7800','8409','8765')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CMaintenance->get() → DBselect() in include/classes/api/services/CMaintenance.php:227

SQL (0.005063): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='88248' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001947): SELECT * FROM (SELECT   e.* FROM events e WHERE e.objectid='88248' AND e.object='0' AND e.source='0' AND e.eventid<='58018215' ORDER BY e.clock DESC,e.eventid DESC) WHERE rownum BETWEEN 0 AND 20
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.00188): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid='58018215' GROUP BY a.eventid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:594

SQL (0.00385): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='88245' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001977): SELECT * FROM (SELECT   e.* FROM events e WHERE e.objectid='88245' AND e.object='0' AND e.source='0' AND e.eventid<='58018167' ORDER BY e.clock DESC,e.eventid DESC) WHERE rownum BETWEEN 0 AND 20
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.001421): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid='58018167' GROUP BY a.eventid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:594

SQL (0.003203): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='88222' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.00189): SELECT * FROM (SELECT   e.* FROM events e WHERE e.objectid='88222' AND e.object='0' AND e.source='0' AND e.eventid<='58017575' ORDER BY e.clock DESC,e.eventid DESC) WHERE rownum BETWEEN 0 AND 20
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.001914): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid='58017575' GROUP BY a.eventid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:594

SQL (0.004321): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='30149' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001625): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='30149' AND f.itemid=i.itemid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:325

SQL (0.001371): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='11193' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.002986): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid='11193' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.001377): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='11193'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.004517): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('11089','11198')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.003438): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid='11193'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.003904): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('11089','11198') AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.00142): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid IN ('11089','11198')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.002215): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND 1=0
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.004017): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN ('11089','11198')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.002332): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='30149' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001969): SELECT * FROM (SELECT   e.* FROM events e WHERE e.objectid='30149' AND e.object='0' AND e.source='0' AND e.eventid<='57804982' ORDER BY e.clock DESC,e.eventid DESC) WHERE rownum BETWEEN 0 AND 20
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.004333): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid IN ('24758376','24763193','24763313','25606794','25606806','26901855','26901982','35161009','35176537','45730905','45731271','55855246','55865988','56373340','56374639','57425539','57786211','57799348','57804543','57804982') GROUP BY a.eventid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:594

SQL (0.003508): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='42883' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001361): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='42883' AND f.itemid=i.itemid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:325

SQL (0.001218): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='11193' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.002171): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid='11193' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.000946): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='11193'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.003042): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('11089','11198')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.002203): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid='11193'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.005431): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('11089','11198') AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.000964): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid IN ('11089','11198')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.000807): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND 1=0
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.002858): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN ('11089','11198')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.002482): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='42883' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001762): SELECT * FROM (SELECT   e.* FROM events e WHERE e.objectid='42883' AND e.object='0' AND e.source='0' AND e.eventid<='57425918' ORDER BY e.clock DESC,e.eventid DESC) WHERE rownum BETWEEN 0 AND 20
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.003035): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid IN ('26901967','27343695','27343706','34677673','34677919','35161042','35176741','40631697','40632008','41535477','41535740','42705893','42706119','45730845','45731532','55855641','55866379','56372688','56374928','57425918') GROUP BY a.eventid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:594

SQL (0.002563): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='38032' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001574): SELECT * FROM (SELECT   e.* FROM events e WHERE e.objectid='38032' AND e.object='0' AND e.source='0' AND e.eventid<='55353114' ORDER BY e.clock DESC,e.eventid DESC) WHERE rownum BETWEEN 0 AND 20
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.002137): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid IN ('17853246','26768421','26781035','26783253','53956472','54127347','54184455','55341039','55353114') GROUP BY a.eventid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:594

SQL (0.003041): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='77541' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001526): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='77541' AND f.itemid=i.itemid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:325

SQL (0.001573): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='11143' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.002964): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid='11143' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.001334): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='11143'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.002678): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid='11133'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.0032): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid='11143'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.008244): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid='11133' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.001317): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='11133'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.003346): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('10594','11174')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.002519): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid='11133'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.003168): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('10594','11174') AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.001343): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid IN ('10594','11174')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.002597): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid='13530'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.001536): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN ('10594','11174')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.002305): SELECT   h.hostid 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 IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid='13530' AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434

SQL (0.001401): SELECT   t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='13530'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318

SQL (0.001272): SELECT   h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND 1=0
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261

SQL (0.002544): SELECT   hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('13','25') WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid='13530'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212

SQL (0.002256): SELECT   t.triggerid 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 IN ('13','25') 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 t.triggerid='77541' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019

SQL (0.001532): SELECT * FROM (SELECT   e.* FROM events e WHERE e.objectid='77541' AND e.object='0' AND e.source='0' AND e.eventid<='46401939' ORDER BY e.clock DESC,e.eventid DESC) WHERE rownum BETWEEN 0 AND 20
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:317

SQL (0.001572): SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid FROM acknowledges a WHERE a.eventid='46401939' GROUP BY a.eventid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_latest_issues() → make_popup_eventlist() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → CEvent->addRelatedObjects() → DBselect() in include/classes/api/services/CEvent.php:594