SQL (0.000156): SET NAMES utf8
dashboard.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in /usr/share/zabbix/include/db.inc.php:61


SQL (0.000584): SHOW TABLES LIKE 'dbversion'
dashboard.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → MysqlDbBackend->checkDbVersionTable() → DBselect() in /usr/share/zabbix/include/classes/db/MysqlDbBackend.php:32


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


SQL (0.000164): BEGIN
dashboard.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /usr/share/zabbix/include/db.inc.php:248


SQL (0.000181): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='a654f9271025dd5e9177ae44c7e1bd10' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1472501877 OR u.autologout=0)
dashboard.php:22 → 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 /usr/share/zabbix/include/classes/api/services/CUser.php:1116


SQL (0.000184): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='2' AND g.usrgrpid=ug.usrgrpid
dashboard.php:22 → 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 /usr/share/zabbix/include/classes/api/services/CUser.php:1149


SQL (0.000173): 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='2'
dashboard.php:22 → 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 /usr/share/zabbix/include/classes/api/services/CUser.php:1173


SQL (0.000159): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='2' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
dashboard.php:22 → 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 /usr/share/zabbix/include/classes/api/services/CUser.php:1181


SQL (0.000167): COMMIT
dashboard.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /usr/share/zabbix/include/db.inc.php:309


SQL (0.0002): SELECT p.* FROM profiles p WHERE p.userid=2 ORDER BY p.userid,p.profileid
dashboard.php:31 → require_once() → CProfile::get() → CProfile::init() → DBselect() in /usr/share/zabbix/include/classes/user/CProfile.php:42


SQL (0.000185): BEGIN
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /usr/share/zabbix/include/db.inc.php:248


SQL (0.00018): SELECT usrgrpid FROM users_groups WHERE userid='2'
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → getUserGroupsByUserId() → DBselect() in /usr/share/zabbix/include/perm.inc.php:304


SQL (0.003819): SELECT t.triggerid,t.state,t.error,t.url,t.expression,t.description,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='12' 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.value='1' AND t.flags IN ('0','4') ORDER BY t.lastchange DESC LIMIT 40 OFFSET 0
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/CApiService.php:984


SQL (0.00019): 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 IN ('13611','13699','13750','13751','13752')
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTrigger.php:1917


SQL (0.000192): 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 IN ('13751','13753')
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTrigger.php:1917


SQL (0.001258): 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 IN ('13751','13753')
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTrigger.php:1958


SQL (0.000199): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN ('13611','13699','13751','13752') AND f.itemid=i.itemid
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTriggerGeneral.php:322


SQL (0.000532): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid IN ('10111','10121','10124','10125') AND h.status IN (0,1,3)
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000187): 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 ('13611','13699','13751','13752') 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
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTrigger.php:1793


SQL (0.000155): COMMIT
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /usr/share/zabbix/include/db.inc.php:309


SQL (0.00017): BEGIN
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /usr/share/zabbix/include/db.inc.php:248


SQL (0.002964): 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='12' 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.value='1' AND t.flags IN ('0','4')
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → DBselect() in /usr/share/zabbix/include/classes/api/services/CTrigger.php:428


SQL (0.000156): COMMIT
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /usr/share/zabbix/include/db.inc.php:309


SQL (0.000195): BEGIN
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /usr/share/zabbix/include/db.inc.php:248


SQL (0.000898): 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='12' WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('10111','10121','10124','10125') AND h.status IN (0,1)
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in /usr/share/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000227): 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='12' 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='12' 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='12' 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 ('10111','10121','10124','10125') AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CGraph.php:296


SQL (0.000189): SELECT ht.* FROM hosts_templates ht WHERE hostid IN ('10111','10121','10124','10125')
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTemplateScreen.php:175


SQL (0.000198): SELECT ht.* FROM hosts_templates ht WHERE hostid IN ('10081','10106','10107','10122','10123')
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTemplateScreen.php:175


SQL (0.000165): SELECT ht.* FROM hosts_templates ht WHERE hostid='10050'
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTemplateScreen.php:175


SQL (0.000195): SELECT COUNT(DISTINCT s.screenid) AS rowscount,s.templateid FROM screens s WHERE s.templateid IS NOT NULL AND (s.templateid BETWEEN '10121' AND '10125' OR s.templateid IN ('10050','10081','10106','10107','10111')) GROUP BY s.templateid
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CTemplateScreen.php:208


SQL (0.000171): COMMIT
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /usr/share/zabbix/include/db.inc.php:309


SQL (0.000223): SELECT c.* FROM config c
dashboard.php:145 → make_latest_issues() → select_config() → DBselect() in /usr/share/zabbix/include/profiles.inc.php:31


SQL (0.000183): BEGIN
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->getScriptsByHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /usr/share/zabbix/include/db.inc.php:248


SQL (0.000218): 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='12' GROUP BY r.id HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hg.hostid IN ('10111','10121','10124','10125') AND hg.groupid=g.groupid
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CHostGroup.php:337


SQL (0.000189): SELECT s.* FROM scripts s WHERE (s.usrgrpid IS NULL OR s.usrgrpid='12') AND (s.groupid IS NULL OR EXISTS (SELECT NULL FROM rights r WHERE s.groupid=r.id AND r.groupid='12' GROUP BY r.id HAVING MIN(r.permission)>0)) AND (s.groupid IN ('9','11','20','21') OR s.groupid IS NULL) ORDER BY s.name
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CScript.php:161


SQL (0.000899): 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='12' WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN ('10111','10121','10124','10125') AND h.status IN (0,1)
dashboard.php:145 → 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 /usr/share/zabbix/include/classes/api/services/CHost.php:434

SQL (0.00016): COMMIT
dashboard.php:145 → make_latest_issues() → CFrontendApiWrapper->getScriptsByHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /usr/share/zabbix/include/db.inc.php:309