Total time: 168.724521 Total SQL time: 168.64566 SQL count: 303 (selects: 234 | executes: 78) Peak memory usage: 20M Memory limit: 128M 1. problem.get [CScreenProblem.php:133] ...omitted... SQL (0.018704): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.001139): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path zabbix.php:21 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:104 SQL (0.008288): SELECT NULL FROM users u WHERE u.userid=48 FOR UPDATE zabbix.php:21 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:38 SQL (0.009157): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.sidebar.mode' zabbix.php:21 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000601): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.sort' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.009078): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.sortorder' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000787): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.active' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.010124): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.groupids' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000828): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.hostids' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.006096): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.triggerids' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.003352): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.inventory.field' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.008066): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.tags.tag' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.001865): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.show' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.010029): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.application' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.006061): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.name' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.003862): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.severities' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.008037): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.age_state' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.001883): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.age' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.010157): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.evaltype' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.005969): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.show_tags' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.003864): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.tag_name_format' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.008038): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.tag_priority' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.00178): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.show_suppressed' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.010094): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.unacknowledged' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.005965): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.compact_view' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.003899): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.show_timeline' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.010024): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.details' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.009916): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.highlight_row' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.009993): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.problem.filter.show_opdata' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.001857): SELECT c.* FROM config c zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenBuilder::getScreen() → CScreenProblem->__construct() → select_config() → DBselect() in include/profiles.inc.php:33 SQL (0.007353): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.layout.mode' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CView->getLayoutMode() → CViewHelper::loadLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.003996): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.006888): SELECT usrgrpid FROM users_groups WHERE userid='48' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:261 SQL (0.00032): SELECT tag_filterid,groupid,tag,value FROM tag_filter WHERE usrgrpid IN (11,31) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CProblem::addTagFilterSqlParts() → CEvent::getTagFilters() → DB::select() → DBselect() in include/classes/db/DB.php:933 SQL (0.095934): SELECT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p WHERE p.source='0' AND p.object='0' AND 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 (11,31) WHERE p.objectid=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 event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1612340187) ORDER BY p.eventid DESC LIMIT 401 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → DBselect() in include/classes/api/services/CProblem.php:336 SQL (0.011474): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.010464): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.501988): SELECT t.triggerid,t.priority,t.opdata,t.expression,t.recovery_mode,t.recovery_expression,t.comments 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 (11,31) 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 IN (16517,29245,29258,29554,29556,29565,29584,29646,29650,29764,29796,29832,29848,29976,30008,30024,30042,30058,30074,30169,30195,30281,30297,30313,30329,30377,30661,30863,31095,31205,31207,31694,44131,65063,65084,65105,65126,65168,65189,65210,65231,65252,65480,65482,65519,66164,67587,67787,67835,67915,67947,67979,68027,75035,75288,75304,76846,76848,76862,76864,77364,77715,80282,82485,82488,83346,84596,86459,86702,86886,87481,87498,87499,87500,87501,87504,88148,88153,88166,88167,88168,88169,89932,90152,92646,99183,99185,99221,106200,114123,117309,117310,117311,117314,120007,120039,123703,124975,124977,124983,124987,124991,124995,125118,125123,125171,125174,126446,126551,126643,127152,127154,127157,127284,131770,133713,134237,139281,143956,143960,143961,145506,147721,148072,148125,149482,149793,150291,150872,151363,152843,153261,156410,156411,156412,156413,161641,161643,164306,164344,165848,167102,167103,168714,169573,170427,170663,170668,172117,172118,172120,172121,172658,175893,178391,178709,178716,178717,178718,178720,178733,178736,178743,179931,181083,181145,181153,181206,181241,183435,183436,183455,183456,183515,183516,183535,183536,183555,183556,183575,183576,183604,183628,183644,183854,183857,183859,183860,183861,183863,183864,183865,183866,184075,184076,184077,184082,184083,184084,184085,184086,184087,184088,184089,184092,184093,184301,184302,184303,184308,184309,184310,184311,184312,184313,184314,184315,184318,184319,184471,184472,184473,184474,184475,184476,184477,184478,184479,184480,184481,184482,184483,184486,184487,184605,184606,184607,184608,184609,184610,184611,184612,184613,184614,184615,184616,184617,184620,184621,184782,184785,184787,184788,184789,184791,184792,184793,184794,184938,184939,184940,184941,184942,185018,185019,185020,185021,185022,185032,185033,185034,185035,185036,185037,185038,185039,185040,185041,185042,185043,185044,185317,185368,185927,185956,186691) 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.flags IN (0,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1066 SQL (0.001029): 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 (16517,29245,29258,29554,29556,29565,29584,29646,29650,29764,29796,29832,29848,29976,30008,30024,30042,30058,30074,30169,30195,30281,30297,30313,30329,30377,30661,30863,31095,31205,31207,31694,44131,65063,65084,65105,65126,65168,65189,65210,65231,65252,65480,65482,65519,66164,67587,67787,67835,67915,67947,67979,68027,75288,75304,77364,77715,80282,82485,82488,83346,84596,86459,86702,86886,87481,87498,87499,87500,87501,87504,88148,88153,88166,88167,88168,88169,89932,90152,92646,99183,99185,99221,106200,114123,117309,117310,117311,117314,120007,120039,123703,124975,124977,124983,124987,124991,124995,125118,125123,125171,125174,126446,126551,126643,127152,127154,127157,127284,131770,133713,134237,139281,143956,143960,143961,145506,147721,148072,148125,149482,149793,150291,150872,151363,152843,153261,156410,156411,156412,156413,161641,161643,164344,165848,167102,167103,168714,169573,170427,170663,170668,172117,172118,172120,172121,172658,175893,178391,178709,178716,178717,178718,178720,178733,178736,178743,179931,181083,181145,181153,181206,181241,183435,183436,183455,183456,183515,183516,183535,183536,183555,183556,183575,183576,183604,183628,183644,183854,183857,183859,183860,183861,183863,183864,183865,183866,184075,184076,184077,184082,184083,184084,184085,184086,184087,184088,184089,184092,184093,184301,184302,184303,184308,184309,184310,184311,184312,184313,184314,184315,184318,184319,184471,184472,184473,184474,184475,184476,184477,184478,184479,184480,184481,184482,184483,184486,184487,184605,184606,184607,184608,184609,184610,184611,184612,184613,184614,184615,184616,184617,184620,184621,184782,184785,184787,184788,184789,184791,184792,184793,184794,184938,184939,184940,184941,184942,185018,185019,185020,185021,185022,185032,185033,185034,185035,185036,185037,185038,185039,185040,185041,185042,185043,185044,185368,186691) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1365 SQL (0.000438): 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 (29244,29256,29554,29563,29646,30167,31204,80281,82484,83345,143960,145505,150296,156414,156415,156416,156417,161645,161647,164341,165852,170668,176124,178414) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1365 SQL (0.000879): 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 (29244,29256,29554,29563,29646,30167,31204,80281,82484,83345,143960,145505,150296,156414,156415,156416,156417,161645,161647,164341,165852,170668,176124,178414) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1406 SQL (0.001892): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN (16517,29245,29258,29554,29565,29584,29646,29764,29796,29832,29848,29976,30008,30024,30042,30058,30074,30169,30195,30281,30297,30313,30329,30377,30661,30863,31095,31205,31207,31694,44131,65063,65084,65105,65126,65168,65189,65210,65231,65252,65480,65482,65519,66164,67587,67787,67835,67915,67947,67979,68027,75288,75304,77364,77715,80282,82485,82488,83346,84596,86459,86702,86886,87481,87498,87499,87500,87501,87504,88148,88153,88166,88167,88168,88169,89932,90152,92646,99183,99185,99221,106200,114123,117309,117310,117311,117314,120007,120039,123703,124975,124977,124983,124987,124991,124995,125118,125123,125171,125174,126446,126551,126643,127152,127154,127157,127284,131770,133713,134237,139281,143956,143960,145506,147721,148072,148125,149482,149793,150291,150872,151363,152843,153261,156410,156411,156412,156413,161641,161643,164344,165848,167102,167103,168714,169573,170427,170668,172117,172118,172120,172121,172658,175893,178391,178709,178716,178717,178718,178720,178733,178736,178743,179931,181083,181145,181153,181206,181241,183435,183436,183455,183456,183515,183516,183535,183536,183555,183556,183575,183576,183604,183628,183644,183854,183857,183859,183860,183861,183863,183864,183865,183866,184075,184076,184077,184082,184083,184084,184085,184086,184087,184088,184089,184092,184093,184301,184302,184303,184308,184309,184310,184311,184312,184313,184314,184315,184318,184319,184471,184472,184473,184474,184475,184476,184477,184478,184479,184480,184481,184482,184483,184486,184487,184605,184606,184607,184608,184609,184610,184611,184612,184613,184614,184615,184616,184617,184620,184621,184782,184785,184787,184788,184789,184791,184792,184793,184794,184938,184939,184940,184941,184942,185018,185019,185020,185021,185022,185032,185033,185034,185035,185036,185037,185038,185039,185040,185041,185042,185043,185044,185368,186691) AND f.itemid=i.itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:697 SQL (0.001108): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid IN (10355,10408,10409,10410,10411,10421,10422,10447,10454,10469,10493,10497,10500,10504,10506,10511,10513,10516,10519,10530,10532,10534,10535,10540,10541,10543,10545,10546,10547,10548,10549,10550,10553,10558,10559,10560,10561,10564,10572,10583,10593,10668,10669,10670,10671,10675,10676,10677,10681,10682,10696,10698,10707,10710,10713,10718,10720,10722,10725,10728,10732,10733,10742,10755,10765,10769,10772,10774,10775,10776,10780,10781,10784,10785,10786,10787,10806,10809,10819,10828,10829,10871,11566,11567,11591,11605,11606,11616,11620,11654,11655,11673,11678,11679,11680,11686,12198,12453,13325,13333,13372,13373,13380,13396,13415,13418,13452,13487,13511,13512,13513,13515,13523,13526,13538,13547,13567,13568,13588,13608,13609) AND h.status IN (0,1,3) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.001371): SELECT t.functionid,t.triggerid,t.itemid FROM functions t WHERE t.triggerid IN (16517,29245,29258,29554,29565,29584,29646,29764,29796,29832,29848,29976,30008,30024,30042,30058,30074,30169,30195,30281,30297,30313,30329,30377,30661,30863,31095,31205,31207,31694,44131,65063,65084,65105,65126,65168,65189,65210,65231,65252,65480,65482,65519,66164,67587,67787,67835,67915,67947,67979,68027,75288,75304,77364,77715,80282,82485,82488,83346,84596,86459,86702,86886,87481,87498,87499,87500,87501,87504,88148,88153,88166,88167,88168,88169,89932,90152,92646,99183,99185,99221,106200,114123,117309,117310,117311,117314,120007,120039,123703,124975,124977,124983,124987,124991,124995,125118,125123,125171,125174,126446,126551,126643,127152,127154,127157,127284,131770,133713,134237,139281,143956,143960,145506,147721,148072,148125,149482,149793,150291,150872,151363,152843,153261,156410,156411,156412,156413,161641,161643,164344,165848,167102,167103,168714,169573,170427,170668,172117,172118,172120,172121,172658,175893,178391,178709,178716,178717,178718,178720,178733,178736,178743,179931,181083,181145,181153,181206,181241,183435,183436,183455,183456,183515,183516,183535,183536,183555,183556,183575,183576,183604,183628,183644,183854,183857,183859,183860,183861,183863,183864,183865,183866,184075,184076,184077,184082,184083,184084,184085,184086,184087,184088,184089,184092,184093,184301,184302,184303,184308,184309,184310,184311,184312,184313,184314,184315,184318,184319,184471,184472,184473,184474,184475,184476,184477,184478,184479,184480,184481,184482,184483,184486,184487,184605,184606,184607,184608,184609,184610,184611,184612,184613,184614,184615,184616,184617,184620,184621,184782,184785,184787,184788,184789,184791,184792,184793,184794,184938,184939,184940,184941,184942,185018,185019,185020,185021,185022,185032,185033,185034,185035,185036,185037,185038,185039,185040,185041,185042,185043,185044,185368,186691) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:317 SQL (0.001278): SELECT i.itemid,i.hostid,i.name,i.key_,i.value_type,i.units,i.valuemapid FROM items i WHERE i.flags IN (0,4) AND i.itemid IN (29284,55265,55368,56049,56117,56299,56571,56842,56906,56974,57006,57262,57326,57358,57392,57424,57456,58029,58160,58326,58358,58390,58422,58518,58745,58809,58934,59794,59818,61460,93960,106863,133805,133846,133887,133928,134010,134051,134092,134133,134174,134788,134790,134866,136730,138523,138584,138682,138842,138906,138970,139066,150534,150566,155773,156454,159447,165429,165430,166476,168415,172483,172951,173281,174587,174604,174605,174606,174607,174610,175904,175909,175922,175923,175924,175925,179645,180101,184066,200847,200849,201112,217165,223819,223940,224061,236165,236166,236167,236170,243355,243419,248770,251396,251398,251404,251408,251412,251416,251636,251641,251689,251692,254508,254613,254705,255970,255972,255975,256333,266160,270175,271717,271718,271719,350168,353220,360237,360296,361638,361697,362104,362163,366519,366527,367110,367955,369493,370949,374852,374853,376339,376340,383091,383092,383093,383094,394184,394186,400733,404194,407237,407238,410749,412590,414179,414771,419907,419913,419921,419927,421006,432911,433142,433373,446579,446602,447307,447308,447349,447350,447355,447356,447361,447362,447373,447374,447451,447452,447469,447470,447511,447512,452637,452638,455089,455090,455254,455262,455270,455299,455306,455313,455442,455445,455509,460311,460312,460364,460365,460523,460524,460576,460577,460629,460630,460682,460683,460752,460760,460816,460824,460848,460856,463004,463007,463009,463010,463011,463013,463014,463015,463016,465594,465595,465596,465601,465602,465603,465604,465605,465606,465607,465608,465611,465612,468175,468176,468177,468182,468183,468184,468185,468186,468187,468188,468189,468192,468193,469216,469217,469218,469219,469220,469221,469222,469223,469224,469225,469226,469227,469228,469231,469232,471425,471426,471427,471428,471429,471430,471431,471432,471433,471434,471435,471436,471437,471440,471441,472545,472548,472550,472551,472552,472554,472555,472556,472557,474761,474762,474763,474764,474765,475660,475661,475662,475663,475664,475674,475675,475676,475677,475678,475679,475680,475681,475682,475683,475684,475685,475686,476701,476702,479551,479552) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392 SQL (0.000145): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000104): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000203): SELECT tag_filterid,groupid,tag,value FROM tag_filter WHERE usrgrpid IN (11,31) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CProblem::addTagFilterSqlParts() → CEvent::getTagFilters() → DB::select() → DBselect() in include/classes/db/DB.php:933 SQL (0.096939): SELECT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p WHERE p.source='0' AND p.object='0' AND 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 (11,31) WHERE p.objectid=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 event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1612340187) AND p.eventid<='171857266' ORDER BY p.eventid DESC LIMIT 401 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → DBselect() in include/classes/api/services/CProblem.php:336 SQL (0.010393): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.007134): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.501326): SELECT t.triggerid,t.priority,t.opdata,t.expression,t.recovery_mode,t.recovery_expression,t.comments 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 (11,31) 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 IN (16307,16319,16427,16478,16490,16514,18094,18097,18100,18103,18149,18307,29030,29068,29079,29103,29105,29119,29121,29388,29586,29780,29782,29798,29812,29850,29992,30197,30331,30379,31111,31113,31208,31509,31528,57654,57675,61038,61039,61044,61045,61052,61053,61054,61057,61058,61060,61061,61062,61065,61346,61347,61352,61354,61360,61361,61362,61363,61365,61366,61367,61368,61369,61370,64811,64832,64853,64874,64895,64916,64937,64958,64979,65000,65021,65042,65147,65441,65469,65508,73419,73420,73421,73422,73423,73424,75290,75297,75306,75313,77717,79843,81768,81774,82489,84924,85000,86121,86701,94952,94973,99043,104848,106223,106246,106272,106274,115752,115789,117017,117018,117167,117168,125121,125148,125195,125220,127294,127449,127453,130350,130369,130836,130855,130861,130864,130868,130870,130871,130873,130879,130880,130887,132573,133711,135175,137555,137556,140250,143953,144716,147909,148268,148269,148270,148274,148275,148276,148277,148302,148303,148304,148305,148308,148309,148310,148311,148312,148313,148314,148315,148316,148317,148318,148319,148320,148321,148322,148323,148324,148325,148326,148327,148328,148329,148330,148331,148332,148333,148334,148335,148336,148337,148338,148339,148340,148342,148343,148971,149407,149410,149411,149872,149895,149918,149941,149964,149987,150030,150648,150649,150650,150652,150669,150671,150707,150730,150776,150874,151342,151359,152023,152136,152186,152446,152605,152606,152607,152609,152610,152624,152639,152646,152647,152674,152689,152693,152766,152767,152769,152772,152773,152774,152776,153260,153572,155457,155459,157401,157402,157404,161007,161642,161644,163222,163224,163281,163282,163286,163287,163796,163927,164342,164731,164735,164756,164771,165765,165846,165847,165849,165932,165935,165936,166030,166031,168392,168393,168394,168395,168505,168911,169955,170070,170071,170072,170073,170081,170083,170084,170086,170087,170088,170089,170090,170091,170092,170093,170094,170095,170100,170101,170102,170103,170104,170105,170106,170107,170108,170109,170110,170111,170112,170113,170114,170115,170116,170117,170118,170119,170120,170121,170122,170123,170124,170125,170126,170127,170128,170129,170130,170131,170132,170133,170134,170135,170136,170137,170138,170139,170140,170143,170149,171103,171910,176113,176114,176117,176219,176223,176579,176921,177958,177959,177965,177966,178016,178017,178023,178024,178132) 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.flags IN (0,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1066 SQL (0.001754): 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 (16307,16319,16427,16478,16490,16514,18094,18097,18100,18103,18307,29030,29068,29079,29388,29586,29780,29782,29798,29812,29850,29992,30197,30331,30379,31208,31509,31528,57654,57675,61038,61039,61044,61045,61052,61053,61054,61057,61058,61060,61061,61062,61065,61346,61347,61352,61354,61360,61361,61362,61363,61365,61366,61367,61368,61369,61370,64811,64832,64853,64874,64895,64916,64937,64958,64979,65000,65021,65042,65147,65441,65469,65508,73419,73420,73421,73422,73423,73424,75290,75297,75306,75313,77717,79843,81768,81774,82489,84924,85000,86121,86701,94952,94973,99043,104848,106223,106246,106272,106274,115752,115789,117017,117018,117167,117168,125121,125148,125195,125220,127294,127449,127453,130350,130369,130836,130855,130861,130864,130868,130870,130871,130873,130879,130880,130887,132573,133711,135175,137555,137556,140250,143953,144716,147909,148268,148269,148270,148274,148275,148276,148277,148302,148303,148304,148305,148308,148309,148310,148311,148312,148313,148314,148315,148316,148317,148318,148319,148320,148321,148322,148323,148324,148325,148326,148327,148328,148329,148330,148331,148332,148333,148334,148335,148336,148337,148338,148339,148340,148342,148343,148971,149407,149410,149411,149872,149895,149918,149941,149964,149987,150030,150648,150649,150650,150652,150669,150671,150707,150730,150776,150874,151342,151359,152023,152136,152186,152446,152605,152606,152607,152609,152610,152624,152639,152646,152647,152674,152689,152693,152766,152767,152769,152772,152773,152774,152776,153260,153572,155457,155459,157401,157402,157404,161007,161642,161644,163222,163224,163281,163282,163286,163287,163927,164731,164735,165765,165846,165847,165849,165932,165935,165936,166030,166031,168392,168393,168394,168395,170070,170071,170072,170073,170081,170083,170084,170086,170087,170088,170089,170090,170091,170092,170093,170094,170095,170100,170101,170102,170103,170104,170105,170106,170107,170108,170109,170110,170111,170112,170113,170114,170115,170116,170117,170118,170119,170120,170121,170122,170123,170124,170125,170126,170127,170128,170129,170130,170131,170132,170133,170134,170135,170136,170137,170138,170139,170140,170143,170149,171103,171910,176113,176114,176117,176219,176223,176579,176921,177958,177959,177965,177966,178016,178017,178023,178024,178132) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1365 SQL (0.000545): 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 (18303,29077,29584,31207,73425,73426,73427,73428,73429,73430,79840,81768,82485,127450,127454,132572,133713,137557,137558,143956,151338,152693,152708,153261,153573,155461,155463,157407,157408,157410,161646,161648,165850,165851,165853) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1365 SQL (0.001208): 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 (18303,29077,29584,31207,73425,73426,73427,73428,73429,73430,79840,81768,82485,127450,127454,132572,133713,137557,137558,143956,151338,152693,152708,153261,153573,155461,155463,157407,157408,157410,161646,161648,165850,165851,165853) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1406 SQL (0.002683): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN (16307,16319,16427,16478,16490,16514,18094,18097,18100,18103,29030,29068,29079,29388,29780,29782,29798,29812,29850,29992,30197,30331,30379,31509,31528,57654,57675,61038,61039,61044,61045,61052,61053,61054,61057,61058,61060,61061,61062,61065,61346,61347,61352,61354,61360,61361,61362,61363,61365,61366,61367,61368,61369,61370,64811,64832,64853,64874,64895,64916,64937,64958,64979,65000,65021,65042,65147,65441,65469,65508,73419,73420,73421,73422,73423,73424,75290,75297,75306,75313,77717,79843,81768,84924,85000,86121,86701,94952,94973,99043,104848,106223,106246,106272,106274,115752,115789,117017,117018,117167,117168,125121,125148,125195,125220,127294,127449,127453,130350,130369,130836,130855,130861,130864,130868,130870,130871,130873,130879,130880,130887,132573,135175,137555,137556,140250,144716,147909,148268,148269,148270,148274,148275,148276,148277,148302,148303,148304,148305,148308,148309,148310,148311,148312,148313,148314,148315,148316,148317,148318,148319,148320,148321,148322,148323,148324,148325,148326,148327,148328,148329,148330,148331,148332,148333,148334,148335,148336,148337,148338,148339,148340,148342,148343,148971,149407,149410,149411,149872,149895,149918,149941,149964,149987,150030,150648,150649,150650,150652,150669,150671,150707,150730,150776,150874,151342,151359,152023,152136,152186,152446,152605,152606,152607,152609,152610,152624,152639,152646,152647,152689,152693,152766,152767,152769,152772,152773,152774,152776,153572,155457,155459,157401,157402,157404,161007,161642,161644,163222,163224,163281,163282,163286,163287,163927,164731,164735,165765,165846,165847,165849,165932,165935,165936,166030,166031,168392,168393,168394,168395,170070,170071,170072,170073,170081,170083,170084,170086,170087,170088,170089,170090,170091,170092,170093,170094,170095,170100,170101,170102,170103,170104,170105,170106,170107,170108,170109,170110,170111,170112,170113,170114,170115,170116,170117,170118,170119,170120,170121,170122,170123,170124,170125,170126,170127,170128,170129,170130,170131,170132,170133,170134,170135,170136,170137,170138,170139,170140,170143,170149,171103,171910,176113,176114,176117,176219,176223,176579,176921,177958,177959,177965,177966,178016,178017,178023,178024,178132) AND f.itemid=i.itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:697 SQL (0.000899): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid IN (10285,10289,10325,10342,10346,10354,10408,10409,10410,10411,10436,10437,10438,10439,10446,10447,10449,10450,10462,10468,10469,10488,10510,10516,10531,10532,10533,10535,10544,10553,10561,10564,10652,10653,10654,10655,10656,10657,10658,10659,10660,10661,10662,10663,10664,10665,10666,10667,10672,10694,10695,10697,10732,10733,10753,10772,10774,10782,10785,10809,11559,11592,11593,11594,11616,11618,11619,11620,11621,11622,11625,11627,11680,11686,11687,12161,12162,12486,12499,13333,13334,13361,13383,13384,13385,13386,13387,13388,13392,13393,13395,13396,13416,13422,13423,13453,13479,13568,13577,13578,13584,13588) AND h.status IN (0,1,3) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.001804): SELECT t.functionid,t.triggerid,t.itemid FROM functions t WHERE t.triggerid IN (16307,16319,16427,16478,16490,16514,18094,18097,18100,18103,29030,29068,29079,29388,29780,29782,29798,29812,29850,29992,30197,30331,30379,31509,31528,57654,57675,61038,61039,61044,61045,61052,61053,61054,61057,61058,61060,61061,61062,61065,61346,61347,61352,61354,61360,61361,61362,61363,61365,61366,61367,61368,61369,61370,64811,64832,64853,64874,64895,64916,64937,64958,64979,65000,65021,65042,65147,65441,65469,65508,73419,73420,73421,73422,73423,73424,75290,75297,75306,75313,77717,79843,81768,84924,85000,86121,86701,94952,94973,99043,104848,106223,106246,106272,106274,115752,115789,117017,117018,117167,117168,125121,125148,125195,125220,127294,127449,127453,130350,130369,130836,130855,130861,130864,130868,130870,130871,130873,130879,130880,130887,132573,135175,137555,137556,140250,144716,147909,148268,148269,148270,148274,148275,148276,148277,148302,148303,148304,148305,148308,148309,148310,148311,148312,148313,148314,148315,148316,148317,148318,148319,148320,148321,148322,148323,148324,148325,148326,148327,148328,148329,148330,148331,148332,148333,148334,148335,148336,148337,148338,148339,148340,148342,148343,148971,149407,149410,149411,149872,149895,149918,149941,149964,149987,150030,150648,150649,150650,150652,150669,150671,150707,150730,150776,150874,151342,151359,152023,152136,152186,152446,152605,152606,152607,152609,152610,152624,152639,152646,152647,152689,152693,152766,152767,152769,152772,152773,152774,152776,153572,155457,155459,157401,157402,157404,161007,161642,161644,163222,163224,163281,163282,163286,163287,163927,164731,164735,165765,165846,165847,165849,165932,165935,165936,166030,166031,168392,168393,168394,168395,170070,170071,170072,170073,170081,170083,170084,170086,170087,170088,170089,170090,170091,170092,170093,170094,170095,170100,170101,170102,170103,170104,170105,170106,170107,170108,170109,170110,170111,170112,170113,170114,170115,170116,170117,170118,170119,170120,170121,170122,170123,170124,170125,170126,170127,170128,170129,170130,170131,170132,170133,170134,170135,170136,170137,170138,170139,170140,170143,170149,171103,171910,176113,176114,176117,176219,176223,176579,176921,177958,177959,177965,177966,178016,178017,178023,178024,178132) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:317 SQL (0.001731): SELECT i.itemid,i.hostid,i.name,i.key_,i.value_type,i.units,i.valuemapid FROM items i WHERE i.flags IN (0,4) AND i.itemid IN (29074,29086,29194,29245,29257,29281,30952,30955,30958,30961,54606,54678,54738,55685,56874,56876,56908,56938,57008,57294,58162,58424,58520,61102,61138,115651,115692,124213,124214,124219,124220,124227,124228,124229,124232,124233,124235,124236,124237,124240,124880,124881,124886,124888,124894,124895,124896,124897,124899,124900,124901,124902,124903,124904,133313,133354,133395,133436,133477,133518,133559,133600,133641,133682,133723,133764,133969,134710,134773,134851,145846,145847,145848,145849,145850,145851,150536,150556,150568,150588,156456,158901,161242,168827,168972,171829,172950,191642,191683,200664,213516,217211,217257,217299,217301,229920,229989,232685,232686,233558,233559,251639,251666,251713,251738,256356,256978,256979,256980,256987,256988,256989,262985,263022,263950,263969,263975,263978,263982,263984,263985,263987,263993,263994,264001,267782,274201,280384,280385,311158,311166,351884,361359,361396,362805,362806,362807,362811,362812,362813,362814,362827,362828,362829,362833,362834,362835,362836,362861,362862,362863,362864,362867,362868,362869,362870,362871,362872,362873,362874,362875,362876,362877,362878,362879,362880,362881,362882,362883,362884,362885,362886,362887,362888,362889,362890,362891,362892,362893,362894,362895,362896,362897,362898,362899,362901,362902,362927,362928,362929,362930,362933,362934,362935,362936,362937,362938,362939,362940,362941,362942,362943,362944,362945,362946,362947,362948,362949,362950,362951,362952,362953,362954,362955,362956,362957,362958,362959,362960,362961,362962,362963,362964,362965,362967,362968,364764,366331,366332,366418,366419,366420,366421,367319,367367,367415,367463,367511,367559,367623,367631,368738,368739,368740,368742,368743,368744,368771,368772,368959,368960,368969,368970,369152,369200,369296,369495,370894,370935,372214,372510,372617,373045,373413,373414,373415,373417,373418,373432,373447,373454,373455,373552,373556,373571,374080,374081,374083,374086,374087,374088,374090,376988,376989,381056,381058,385194,385195,385197,392878,394185,394187,397534,397535,397538,397539,397623,397624,397625,397626,397645,397646,397647,397648,399523,402095,402104,403644,403645,404192,404193,404195,404270,404271,404275,404277,404278,404279,404571,404572,404573,404574,409507,409508,409509,409510,413218,413219,413220,413221,413229,413231,413232,413234,413235,413236,413237,413238,413239,413240,413241,413242,413243,413248,413249,413250,413251,413252,413253,413254,413262,413264,413265,413267,413268,413269,413270,413271,413272,413273,413274,413275,413276,413281,413282,413283,413284,413285,413286,413287,413288,413289,413290,413291,413292,413293,413294,413295,413296,413297,413298,413299,413300,413301,413302,413303,413304,413305,413306,413307,413308,413309,413310,413311,413312,413313,413314,413315,413316,413317,413318,413319,413320,413321,413322,413323,413324,413325,413326,413327,413328,413329,413330,413331,413332,413333,413334,413335,413336,413337,413338,413339,413340,413341,413342,413343,413344,413345,413346,413347,413348,413349,413350,413351,413352,413353,413354,413355,413356,413357,413358,413359,413362,413368,413408,413414,415790,419583,419584,433131,433132,433135,433237,433241,434375,435053,435054,445189,445190,445196,445197,445808,445809,445815,445816,446051) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392 SQL (0.000175): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000605): SELECT f.functionid,f.itemid,f.name,f.parameter FROM functions f WHERE f.functionid IN (51030,51111,51297,51473,51507,51539,51660,51746,51778,53133,53888,139691,194521,222307,245083,250913,250914,290574,292718,292719,292724,292725,307469,307470,307471,315545,315546,321237,321238,321243,321244,321245,321246) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:876 SQL (0.000793): SELECT i.itemid,i.hostid,i.key_,i.type,i.flags,i.status,ir.state,id.parent_itemid FROM items i LEFT JOIN item_rtdata ir ON i.itemid=ir.itemid LEFT JOIN item_discovery id ON i.itemid=id.itemid WHERE i.itemid IN (56117,56571,56974,57326,57392,57456,58160,58326,58390,58934,61460,172483,236165,270175,367110,374852,374853,407237,407238,414771,419921,419927,446579,446602,447307,447308,479551,479552) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:907 SQL (0.000383): SELECT h.hostid,h.host FROM hosts h WHERE h.hostid IN (10506,10519,10534,10545,10547,10549,10553,10558,10560,10572,10583,10742,10776,10784,10806,11616,12453,13373,13380,13418,13487,13588) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:918 SQL (0.000419): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000541): SELECT i.itemid,i.hostid,i.interfaceid FROM items i WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (11,31) WHERE i.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND i.itemid IN (447307,447308) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392 SQL (0.000123): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000312): SELECT i.hostid,i.interfaceid,i.ip,i.dns,i.useip,i.port,i.type,i.main FROM interface i WHERE i.hostid=13418 AND i.type IN (1,2,3,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → DBselect() in include/classes/macros/CMacrosResolver.php:1546 SQL (0.000138): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000331): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=13418 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000143): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000228): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=13418 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000117): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000392): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10001,13440) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000134): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000192): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10001,13440) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000101): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000348): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10050,10186) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (9.9E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000166): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10050,10186) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000128): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000372): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10784,13380,13588) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (9.8E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000211): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10784,13380,13588) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (8.9E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000353): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10248,13378,13414) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (9.7E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000223): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10248,13378,13414) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (9.8E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000507): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10183,10185,10190,10204,10485,10486,10487,13379) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000101): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000226): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10183,10185,10190,10204,10485,10486,10487,13379) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000275): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000321): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=10186 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000113): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00017): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=10186 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000108): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000304): SELECT gm.globalmacroid,gm.macro,gm.value,gm.type FROM globalmacro gm zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:183 SQL (0.000109): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000277): SELECT f.functionid,f.itemid FROM functions f WHERE f.functionid IN (250913,250914,307469,307470,307471,315545,315546,321237,321238) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::sortItemsByExpressionOrder() → CMacrosResolver->sortItemsByExpressionOrder() → DBselect() in include/classes/macros/CMacrosResolver.php:2624 SQL (0.000124): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.00044): SELECT i.itemid,i.hostid,i.interfaceid FROM items i WHERE EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (11,31) WHERE i.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND i.itemid IN (447307,447308) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392 SQL (0.00011): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000236): SELECT i.hostid,i.interfaceid,i.ip,i.dns,i.useip,i.port,i.type,i.main FROM interface i WHERE i.hostid=13418 AND i.type IN (1,2,3,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → DBselect() in include/classes/macros/CMacrosResolver.php:1546 SQL (9.6E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000283): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=13418 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000104): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000172): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=13418 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (8.2E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000331): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10001,13440) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (9.7E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000182): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10001,13440) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (9.4E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000335): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10050,10186) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.0001): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000168): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10050,10186) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveItemNames() → CMacrosResolver->resolveItemNames() → CMacrosResolver->resolveItemKeys() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000316): SELECT f.triggerid,f.functionid,i.itemid,i.hostid,i.name,i.key_,i.value_type,i.units,i.valuemapid FROM functions f JOIN items i ON f.itemid=i.itemid JOIN hosts h ON i.hostid=h.hostid WHERE f.functionid=245083 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:755 SQL (0.000661): SELECT MAX(h.clock) FROM history h WHERE h.itemid='367110' AND h.clock>1612253908 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000614): SELECT * FROM history h WHERE h.itemid='367110' AND h.clock='1612340010' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000269): SELECT f.triggerid,f.functionid,i.itemid,i.hostid,i.name,i.key_,i.value_type,i.units,i.valuemapid FROM functions f JOIN items i ON f.itemid=i.itemid JOIN hosts h ON i.hostid=h.hostid WHERE f.functionid=139691 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:755 SQL (0.000469): SELECT MAX(h.clock) FROM history h WHERE h.itemid='172483' AND h.clock>1612253908 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000452): SELECT * FROM history h WHERE h.itemid='172483' AND h.clock='1612340083' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000314): SELECT f.triggerid,f.functionid,i.itemid,i.hostid,i.name,i.key_,i.value_type,i.units,i.valuemapid FROM functions f JOIN items i ON f.itemid=i.itemid JOIN hosts h ON i.hostid=h.hostid WHERE f.functionid=307469 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:755 SQL (0.000468): SELECT MAX(h.clock) FROM history h WHERE h.itemid='446602' AND h.clock>1612253908 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000412): SELECT * FROM history h WHERE h.itemid='446602' AND h.clock='1612340002' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CMacrosResolverHelper::resolveTriggerDescription() → CMacrosResolverHelper::resolveTriggerDescriptions() → CMacrosResolver->resolveTriggerDescriptions() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000122): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CScreenProblem::getExDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000173): SELECT tag_filterid,groupid,tag,value FROM tag_filter WHERE usrgrpid IN (11,31) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CScreenProblem::getExDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CProblem::addTagFilterSqlParts() → CEvent::getTagFilters() → DB::select() → DBselect() in include/classes/db/DB.php:933 SQL (0.003616): SELECT p.eventid,p.r_eventid,p.r_clock,p.r_ns,p.correlationid,p.userid,p.acknowledged FROM problem p WHERE p.source='0' AND p.object='0' AND 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 (11,31) WHERE p.objectid=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 p.eventid IN (197949919,197956792,197962662,197987820,197993455,197998933,198003694,198004678,198047974,198053681,198056853,198062338,198112827,198112828,198114591,198299363,198435029,198440701,198482360,198487538,198513293,198552649,198557728,198591940,198593988,198597683,198597685,198597686,198597687,198597688,198597689,198597690,198597691,198597692,198600187,198610458,198615766,198622223,198680864,198685620,198712009,198712932,198718171,199019130,199024738,199030107,199074239,199075531,199096792,199096798) AND (p.r_eventid IS NULL OR p.r_clock>1612340188) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CScreenProblem::getExDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → DBselect() in include/classes/api/services/CProblem.php:336 SQL (0.00263): SELECT t.acknowledgeid,t.userid,t.clock,t.message,t.action,t.old_severity,t.new_severity,t.eventid FROM acknowledges t WHERE t.eventid IN (197949919,197956792,197962662,197987820,197993455,197998933,198003694,198004678,198047974,198053681,198056853,198062338,198112827,198112828,198114591,198299363,198435029,198440701,198482360,198487538,198513293,198552649,198557728,198591940,198593988,198597683,198597685,198597686,198597687,198597688,198597689,198597690,198597691,198597692,198600187,198610458,198615766,198622223,198680864,198685620,198712009,198712932,198718171,199019130,199024738,199030107,199074239,199075531,199096792,199096798) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CScreenProblem::getExDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CProblem->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350 SQL (0.002745): SELECT problemtagid,tag,value,eventid FROM problem_tag WHERE eventid IN (197949919,197956792,197962662,197987820,197993455,197998933,198003694,198004678,198047974,198053681,198056853,198062338,198112827,198112828,198114591,198299363,198435029,198440701,198482360,198487538,198513293,198552649,198557728,198591940,198593988,198597683,198597685,198597686,198597687,198597688,198597689,198597690,198597691,198597692,198600187,198610458,198615766,198622223,198680864,198685620,198712009,198712932,198718171,199019130,199024738,199030107,199074239,199075531,199096792,199096798) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CScreenProblem::getExDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CProblem->addRelatedObjects() → DBselect() in include/classes/api/services/CProblem.php:552 SQL (0.000436): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CScreenProblem::getExDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000166): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → getEventsActionsIconsData() → getEventsActions() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (167.090617): SELECT a.alertid,a.alerttype,a.clock,a.error,a.eventid,a.mediatypeid,a.retries,a.status,a.userid FROM alerts a WHERE EXISTS (SELECT NULL FROM events e,functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (11,31) WHERE a.eventid=e.eventid AND 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 EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND (a.userid IS NULL OR EXISTS (SELECT NULL FROM users_groups ug WHERE ug.userid=a.userid AND ug.usrgrpid IN (11,31))) AND a.eventid IN (197949919,197956792,197962662,197987820,197993455,197998933,198003694,198004678,198047974,198053681,198056853,198062338,198112827,198112828,198114591,198299363,198435029,198440701,198482360,198487538,198513293,198552649,198557728,198591940,198593988,198597683,198597685,198597686,198597687,198597688,198597689,198597690,198597691,198597692,198600187,198610458,198615766,198622223,198680864,198685620,198712009,198712932,198718171,199019130,199024738,199030107,199074239,199075531,199096792,199096798) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → getEventsActionsIconsData() → getEventsActions() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CAlert->get() → DBselect() in include/classes/api/services/CAlert.php:325 SQL (0.000302): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → getEventsActionsIconsData() → getEventsActions() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00014): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000476): 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=48) AND u.userid IN (3,25) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->get() → DBselect() in include/classes/api/services/CUser.php:171 SQL (0.000115): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00018): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000214): SELECT mt.mediatypeid,mt.name,mt.maxattempts FROM media_type mt WHERE mt.mediatypeid=1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMediatype->get() → DBselect() in include/classes/api/services/CMediatype.php:132 SQL (0.000121): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::makeData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000113): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.001751): 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 (11,31) 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 IN (29565,29646,29832,30008,30042,30074,30195,30281,30313,31095,31694,86459,117309,133713,149793,152843,167102,167103,170668,172118,172121,178391,178709,186691) AND t.flags IN (0,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.00046): SELECT td.triggerid_up,td.triggerid_down FROM trigger_depends td WHERE td.triggerid_down IN (29565,29646,29832,30008,30042,30074,30195,30281,30313,31095,31694,86459,117309,133713,149793,152843,167102,167103,170668,172118,172121,178391,178709,186691) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → DBselect() in include/classes/api/services/CTrigger.php:1163 SQL (0.000759): 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 (11,31) 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 IN (29563,178414) AND t.flags IN (0,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.000137): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000125): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggersHostsList() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.001566): SELECT h.hostid,h.name,h.maintenanceid,h.maintenance_status,h.maintenance_type 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 (11,31) WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid IN (10506,10519,10534,10545,10547,10549,10553,10558,10560,10572,10583,10742,10776,10784,10806,11616,12453,13373,13380,13418,13487,13588) AND h.status IN (0,1) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggersHostsList() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.000117): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggersHostsList() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000487): SELECT triggerid_down,triggerid_up FROM trigger_depends WHERE triggerid_up IN (29565,29646,29832,30008,30042,30074,30195,30281,30313,31095,31694,86459,117309,133713,149793,152843,167102,167103,170668,172118,172121,178391,178709,186691) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → DBselect() in include/triggers.inc.php:2499 SQL (0.000118): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000847): SELECT t.triggerid,t.expression,t.description 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 (11,31) 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 IN (29563,29567,29650,133711,170663,178414) AND t.flags IN (0,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.000141): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000342): SELECT f.functionid,i.hostid FROM functions f,items i WHERE f.itemid=i.itemid AND f.functionid IN (51028,51032,51115,222305,290569,307523) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:1026 SQL (0.000106): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000357): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=13588 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000111): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000248): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=13588 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000103): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000397): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=13414 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000113): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000223): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=13414 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000103): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000376): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10485,10486,10487) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.00012): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000195): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10485,10486,10487) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (9.9E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000526): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=10186 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000127): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00023): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=10186 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000118): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.00024): SELECT gm.globalmacroid,gm.macro,gm.value,gm.type FROM globalmacro gm zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:183 SQL (0.00013): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressions() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00039): SELECT f.triggerid,f.functionid,i.itemid,i.hostid,i.name,i.key_,i.value_type,i.units,i.valuemapid FROM functions f JOIN items i ON f.itemid=i.itemid JOIN hosts h ON i.hostid=h.hostid WHERE f.functionid=51032 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:755 SQL (0.000731): SELECT MAX(h.clock) FROM history h WHERE h.itemid='56117' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000578): SELECT * FROM history h WHERE h.itemid='56117' AND h.clock='1612340417' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getItemMacros() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000104): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000529): 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 (11,31) 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=178414 AND t.flags IN (0,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.000234): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid=178414 AND f.itemid=i.itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:697 SQL (0.000185): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=13588 AND h.status IN (0,1,3) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1098 SQL (0.000109): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.0001): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000759): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=13588 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000126): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000219): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=13588 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (9.6E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000373): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=13414 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000112): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000191): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=13414 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000104): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000395): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid IN (10485,10486,10487) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000115): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.0002): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10485,10486,10487) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (0.000106): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000309): SELECT hm.hostmacroid,hm.macro,hm.value,hm.type,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 (11,31) WHERE hm.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND hm.hostid=10186 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:197 SQL (0.000131): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000174): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=10186 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:1035 SQL (9.2E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000168): SELECT gm.globalmacroid,gm.macro,gm.value,gm.type FROM globalmacro gm zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:183 SQL (0.000111): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → getTriggerDependencies() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000959): SELECT MAX(h.clock) FROM history_str h WHERE h.itemid='447308' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000671): SELECT * FROM history_str h WHERE h.itemid='447308' AND h.clock='1612340078' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000561): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='447307' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000577): SELECT * FROM history_uint h WHERE h.itemid='447307' AND h.clock='1612340378' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000424): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='374852' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000412): SELECT * FROM history_uint h WHERE h.itemid='374852' AND h.clock='1612340363' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.00041): SELECT MAX(h.clock) FROM history_str h WHERE h.itemid='374853' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000402): SELECT * FROM history_str h WHERE h.itemid='374853' AND h.clock='1612340063' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000635): SELECT MAX(h.clock) FROM history h WHERE h.itemid='56571' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000489): SELECT * FROM history h WHERE h.itemid='56571' AND h.clock='1612340271' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000428): SELECT MAX(h.clock) FROM history h WHERE h.itemid='367110' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000446): SELECT * FROM history h WHERE h.itemid='367110' AND h.clock='1612340310' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000666): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000464): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000405): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000426): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000402): SELECT MAX(h.clock) FROM history h WHERE h.itemid='414771' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000463): SELECT * FROM history h WHERE h.itemid='414771' AND h.clock='1612340271' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000498): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000385): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000509): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000389): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000534): SELECT MAX(h.clock) FROM history h WHERE h.itemid='270175' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000426): SELECT * FROM history h WHERE h.itemid='270175' AND h.clock='1612340275' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000389): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000524): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000354): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000404): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000631): SELECT MAX(h.clock) FROM history_text h WHERE h.itemid='407238' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000487): SELECT * FROM history_text h WHERE h.itemid='407238' AND h.clock='1612273490' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000367): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.00038): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.00036): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000485): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000718): SELECT MAX(h.clock) FROM history h WHERE h.itemid='172483' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000461): SELECT * FROM history h WHERE h.itemid='172483' AND h.clock='1612340383' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000545): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='58934' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000384): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='58160' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000348): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='61460' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000399): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='57456' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000323): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='58390' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000325): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='57392' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000317): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='56974' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000576): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='58326' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000462): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='57326' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000345): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='236165' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000428): SELECT * FROM history_uint h WHERE h.itemid='236165' AND h.clock='1612340355' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000111): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000153): SELECT vm.valuemapid FROM valuemaps vm WHERE vm.valuemapid='88' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CValueMap->get() → DBselect() in include/classes/api/services/CValueMap.php:75 SQL (0.000178): SELECT t.mappingid,t.value,t.newvalue,t.valuemapid FROM mappings t WHERE t.valuemapid=88 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CValueMap->get() → CValueMap->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350 SQL (9.9E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00064): SELECT MAX(h.clock) FROM history_text h WHERE h.itemid='407237' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000488): SELECT * FROM history_text h WHERE h.itemid='407237' AND h.clock='1612268779' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000575): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000481): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000389): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000413): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000726): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='479551' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000598): SELECT * FROM history_uint h WHERE h.itemid='479551' AND h.clock='1612340209' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000581): SELECT MAX(h.clock) FROM history_str h WHERE h.itemid='479552' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000535): SELECT * FROM history_str h WHERE h.itemid='479552' AND h.clock='1612340209' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000478): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000444): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000484): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000403): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000451): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000426): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.00036): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000469): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000438): SELECT MAX(h.clock) FROM history h WHERE h.itemid='56117' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000372): SELECT * FROM history h WHERE h.itemid='56117' AND h.clock='1612340417' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.00047): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419921' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.00042): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000394): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000348): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.00038): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000334): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419921' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000325): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419921' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000366): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000391): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.00037): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000387): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000333): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000371): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000514): SELECT MAX(h.clock) FROM history h WHERE h.itemid='446602' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000459): SELECT * FROM history h WHERE h.itemid='446602' AND h.clock='1612340302' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000556): SELECT MAX(h.clock) FROM history_uint h WHERE h.itemid='446579' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000521): SELECT * FROM history_uint h WHERE h.itemid='446579' AND h.clock='1612340279' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000173): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000192): SELECT vm.valuemapid FROM valuemaps vm WHERE vm.valuemapid='18' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CValueMap->get() → DBselect() in include/classes/api/services/CValueMap.php:75 SQL (0.000227): SELECT t.mappingid,t.value,t.newvalue,t.valuemapid FROM mappings t WHERE t.valuemapid=18 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CValueMap->get() → CValueMap->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350 SQL (0.000138): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → formatHistoryValue() → applyValueMap() → getMappedValue() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000622): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000517): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000465): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000562): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000481): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000507): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000512): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000522): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000457): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000481): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000517): SELECT MAX(h.clock) FROM history_log h WHERE h.itemid='419927' AND h.clock>1612254075 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:215 SQL (0.000468): SELECT * FROM history_log h WHERE h.itemid='419927' AND h.clock='1612331322' ORDER BY h.ns DESC LIMIT 1 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getLatestValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:228 SQL (0.000274): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=48 AND idx='web.login.attempt.failed' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CWidget->show() → CWidget->toString() → get_prepared_messages() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180