******************** Script profiler ******************** Total time: 0.063313 Total SQL time: 0.029045 SQL count: 39 (selects: 32 | executes: 17) Peak memory usage: 8M Memory limit: 128M 1. host.get [CControllerLatest.php:86] Parameters: Array ( [output] => Array ( [0] => name [1] => hostid [2] => status ) [hostids] => Array ( [0] => 14562 ) [groupids] => [with_monitored_items] => 1 [sortfield] => host [limit] => 1001 [preservekeys] => 1 ) Result: Array ( [14562] => Array ( [hostid] => 14562 [name] => HOSTNAME [status] => 0 ) ) 2. item.get [CControllerLatest.php:117] Parameters: Array ( [hostids] => Array ( [0] => 14562 ) [output] => Array ( [0] => itemid [1] => name [2] => type [3] => value_type [4] => units [5] => hostid [6] => state [7] => valuemapid [8] => status [9] => error [10] => trends [11] => history [12] => delay [13] => key_ [14] => flags [15] => description ) [selectApplications] => Array ( [0] => applicationid ) [selectItemDiscovery] => Array ( [0] => ts_delete ) [applicationids] => [webitems] => 1 [filter] => Array ( [status] => Array ( [0] => 0 ) ) [limit] => 1001 [preservekeys] => 1 ) Result: Array ( [859966] => Array ( [itemid] => 859966 [name] => $3 [type] => 10 [value_type] => 3 [units] => [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 2m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsAccessible] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859967] => Array ( [itemid] => 859967 [name] => $3 [type] => 10 [value_type] => 3 [units] => B [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 30m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsCapacity] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859968] => Array ( [itemid] => 859968 [name] => $3 [type] => 10 [value_type] => 4 [units] => [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 0 [history] => 90d [delay] => 1h [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsDevice] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859969] => Array ( [itemid] => 859969 [name] => $3 [type] => 10 [value_type] => 3 [units] => B [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 2m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsFreeSpace] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859970] => Array ( [itemid] => 859970 [name] => $3 [type] => 10 [value_type] => 0 [units] => % [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 2m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsFreeSpacePct] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859971] => Array ( [itemid] => 859971 [name] => $3 [type] => 10 [value_type] => 3 [units] => hosts [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 30m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsHostCount] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859972] => Array ( [itemid] => 859972 [name] => $3 [type] => 10 [value_type] => 4 [units] => [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 0 [history] => 90d [delay] => 30m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsHostList] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859973] => Array ( [itemid] => 859973 [name] => $3 [type] => 10 [value_type] => 1 [units] => [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 0 [history] => 90d [delay] => 1h [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsType] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859974] => Array ( [itemid] => 859974 [name] => $3 [type] => 10 [value_type] => 3 [units] => B [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 5m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsUncommitted] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859975] => Array ( [itemid] => 859975 [name] => $3 [type] => 10 [value_type] => 0 [units] => % [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 5m [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsUncommittedPct] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859976] => Array ( [itemid] => 859976 [name] => $3 [type] => 10 [value_type] => 3 [units] => hosts [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 30m [key_] => VMW_datastores.sh[dat,{HOST.HOST},readWrite.dsHostCountByAccess] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) [859977] => Array ( [itemid] => 859977 [name] => $3 [type] => 10 [value_type] => 0 [units] => % [hostid] => 14562 [valuemapid] => 0 [status] => 0 [trends] => 365d [history] => 90d [delay] => 10m [key_] => VMW_datastores.sh[def,{HOST.HOST},dsFreeSpacePctLim] [flags] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 26717 ) ) [itemDiscovery] => Array ( ) ) ) 3. application.get [CControllerLatest.php:138] Parameters: Array ( [output] => Array ( [0] => applicationid [1] => hostid [2] => name ) [hostids] => Array ( [0] => 14562 ) [search] => Array ( [name] => ) [preservekeys] => 1 ) Result: Array ( [26717] => Array ( [applicationid] => 26717 [hostid] => 14562 [name] => VMW_VCenter_Datastores ) ) 4. item.get [CMacrosResolver.php:1485] Parameters: Array ( [output] => Array ( [0] => hostid [1] => interfaceid ) [itemids] => Array ( [0] => 859966 [1] => 859967 [2] => 859968 [3] => 859969 [4] => 859970 [5] => 859971 [6] => 859972 [7] => 859973 [8] => 859974 [9] => 859975 [10] => 859976 [11] => 859977 ) [webitems] => 1 [filter] => Array ( [flags] => ) [preservekeys] => 1 [selectHosts] => Array ( [0] => hostid [1] => host [2] => name ) ) Result: Array ( [859966] => Array ( [itemid] => 859966 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859967] => Array ( [itemid] => 859967 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859968] => Array ( [itemid] => 859968 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859969] => Array ( [itemid] => 859969 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859970] => Array ( [itemid] => 859970 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859971] => Array ( [itemid] => 859971 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859972] => Array ( [itemid] => 859972 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859973] => Array ( [itemid] => 859973 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859974] => Array ( [itemid] => 859974 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859975] => Array ( [itemid] => 859975 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859976] => Array ( [itemid] => 859976 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) [859977] => Array ( [itemid] => 859977 [hostid] => 14562 [interfaceid] => 34933 [hosts] => Array ( [0] => Array ( [hostid] => 14562 [host] => VCHNP.5f3bdea0-08692eca-9f34-e4434bc4c960 [name] => HOSTNAME ) ) ) ) 5. host.get [CControllerLatest.php:219] Parameters: Array ( [output] => Array ( [0] => hostid [1] => name ) [hostids] => Array ( [0] => 14562 ) ) Result: Array ( [0] => Array ( [hostid] => 14562 [name] => HOSTNAME ) ) SQL (0.000599): 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:182 SQL (0.000462): 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.000679): SELECT NULL FROM users u WHERE u.userid=92 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.00053): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 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.000205): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.filter.groupids' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::updateArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000118): DELETE FROM profiles WHERE idx='web.latest.filter.groupids' AND 1=0 AND userid='92' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::updateArray() → CProfile::delete() → CProfile::deleteValues() → DB::delete() → DBexecute() in include/classes/db/DB.php:879 SQL (0.000244): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.filter.hostids' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::updateArray() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000149): DELETE FROM profiles WHERE idx='web.latest.filter.hostids' AND 1=0 AND userid='92' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::updateArray() → CProfile::delete() → CProfile::deleteValues() → DB::delete() → DBexecute() in include/classes/db/DB.php:879 SQL (0.00018): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.filter.application' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000303): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.filter.select' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000167): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.filter.show_without_data' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000173): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.filter.show_details' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000179): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.sort' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000157): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.sortorder' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.00061): SELECT c.* FROM config c zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → select_config() → DBselect() in include/profiles.inc.php:33 SQL (0.000106): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.001789): SELECT h.hostid,h.name,h.status FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=14562 AND h.status IN (0,1) AND EXISTS (SELECT NULL FROM items i WHERE h.hostid=i.hostid AND i.flags IN (0,4) AND i.status=0) ORDER BY h.host LIMIT 1001 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1069 SQL (6.4E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182 SQL (0.000189): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.002004): SELECT DISTINCT i.itemid,i.name,i.type,i.value_type,i.units,i.hostid,i.valuemapid,i.status,i.trends,i.history,i.delay,i.key_,i.flags,i.description,ir.state,COALESCE(ir.error,'') AS error FROM items i LEFT JOIN item_rtdata ir ON ir.itemid=i.itemid WHERE i.flags IN (0,4) AND i.hostid=14562 AND i.status=0 LIMIT 1001 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392 SQL (0.000661): SELECT t.itemappid,t.itemid,t.applicationid FROM items_applications t WHERE t.itemid IN (859966,859967,859968,859969,859970,859971,859972,859973,859974,859975,859976,859977) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:317 SQL (0.000518): SELECT a.applicationid FROM applications a WHERE a.applicationid=26717 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CApplication->get() → DBselect() in include/classes/api/services/CApplication.php:204 SQL (0.000629): SELECT t.itemdiscoveryid,t.ts_delete,t.itemid FROM item_discovery t WHERE t.itemid IN (859966,859967,859968,859969,859970,859971,859972,859973,859974,859975,859976,859977) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350 SQL (7.8E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182 SQL (5.1E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.000264): SELECT a.applicationid,a.hostid,a.name FROM applications a WHERE a.hostid=14562 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CApplication->get() → DBselect() in include/classes/api/services/CApplication.php:204 SQL (5.9E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182 SQL (0.000107): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CMacrosResolverHelper::resolveItemKeys() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.000382): SELECT i.itemid,i.hostid,i.interfaceid FROM items i WHERE i.itemid IN (859966,859967,859968,859969,859970,859971,859972,859973,859974,859975,859976,859977) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CMacrosResolverHelper::resolveItemKeys() → 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.000249): SELECT h.hostid,h.host,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=14562 AND h.status IN (0,1,3) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CMacrosResolverHelper::resolveItemKeys() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1069 SQL (6.7E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CMacrosResolverHelper::resolveItemKeys() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182 SQL (0.015621): SELECT * FROM history_uint h WHERE h.itemid='859966' AND h.clock>1600353058 ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:187 SQL (8.0E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.000256): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=14562 AND h.status IN (0,1) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1069 SQL (6.6E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182 SQL (0.000255): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.filter.active' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000243): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 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.000286): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 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 SQL (0.000266): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=92 AND idx='web.latest.toggle' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CWidget->show() → CWidget->toString() → CTag->__construct() → CTag->addItem() → CObject->addItem() → CTag->addItem() → CObject->addItem() → unpack_object() → CPartial->getOutput() → include() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180