******************** Script profiler ******************** Total time: 0.130968 Total SQL time: 0.096962 SQL count: 56 (selects: 47 | executes: 19) Peak memory usage: 4M Memory limit: 768M 1. host.get [CControllerLatest.php:101] Parameters: Array ( [output] => Array ( [0] => hostid [1] => name [2] => status ) [groupids] => [hostids] => Array ( [0] => 14294 ) [monitored_hosts] => 1 [preservekeys] => 1 ) Result: Array ( [14294] => Array ( [hostid] => 14294 [name] => HOSTNAME [status] => 0 ) ) 2. item.get [CControllerLatest.php:135] Parameters: Array ( [output] => Array ( [0] => itemid [1] => hostid [2] => value_type ) [hostids] => Array ( [0] => 14294 ) [applicationids] => [webitems] => 1 [filter] => Array ( [status] => Array ( [0] => 0 ) ) [search] => [preservekeys] => 1 ) Result: Array ( [765747] => Array ( [itemid] => 765747 [hostid] => 14294 [value_type] => 3 ) [765748] => Array ( [itemid] => 765748 [hostid] => 14294 [value_type] => 3 ) [765749] => Array ( [itemid] => 765749 [hostid] => 14294 [value_type] => 4 ) [765750] => Array ( [itemid] => 765750 [hostid] => 14294 [value_type] => 3 ) [765751] => Array ( [itemid] => 765751 [hostid] => 14294 [value_type] => 0 ) [765752] => Array ( [itemid] => 765752 [hostid] => 14294 [value_type] => 3 ) [765753] => Array ( [itemid] => 765753 [hostid] => 14294 [value_type] => 4 ) [765754] => Array ( [itemid] => 765754 [hostid] => 14294 [value_type] => 1 ) [765755] => Array ( [itemid] => 765755 [hostid] => 14294 [value_type] => 3 ) [765756] => Array ( [itemid] => 765756 [hostid] => 14294 [value_type] => 0 ) [765757] => Array ( [itemid] => 765757 [hostid] => 14294 [value_type] => 3 ) [765758] => Array ( [itemid] => 765758 [hostid] => 14294 [value_type] => 0 ) ) 3. item.get [CControllerLatest.php:161] Parameters: Array ( [output] => Array ( [0] => itemid [1] => type [2] => hostid [3] => name [4] => key_ [5] => delay [6] => history [7] => trends [8] => status [9] => value_type [10] => units [11] => valuemapid [12] => description [13] => state [14] => error ) [selectApplications] => Array ( [0] => applicationid ) [itemids] => Array ( [0] => 765747 [1] => 765748 [2] => 765749 [3] => 765750 [4] => 765751 [5] => 765752 [6] => 765753 [7] => 765754 [8] => 765755 [9] => 765756 [10] => 765757 [11] => 765758 ) [webitems] => 1 [preservekeys] => 1 ) Result: Array ( [765747] => Array ( [itemid] => 765747 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsAccessible] [delay] => 2m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 3 [units] => [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765748] => Array ( [itemid] => 765748 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsCapacity] [delay] => 30m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 3 [units] => B [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765749] => Array ( [itemid] => 765749 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsDevice] [delay] => 1h [history] => 90d [trends] => 0 [status] => 0 [value_type] => 4 [units] => [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765750] => Array ( [itemid] => 765750 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsFreeSpace] [delay] => 2m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 3 [units] => B [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765751] => Array ( [itemid] => 765751 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsFreeSpacePct] [delay] => 2m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 0 [units] => % [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765752] => Array ( [itemid] => 765752 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsHostCount] [delay] => 30m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 3 [units] => hosts [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765753] => Array ( [itemid] => 765753 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsHostList] [delay] => 30m [history] => 90d [trends] => 0 [status] => 0 [value_type] => 4 [units] => [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765754] => Array ( [itemid] => 765754 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsType] [delay] => 1h [history] => 90d [trends] => 0 [status] => 0 [value_type] => 1 [units] => [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765755] => Array ( [itemid] => 765755 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsUncommitted] [delay] => 5m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 3 [units] => B [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765756] => Array ( [itemid] => 765756 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},dsUncommittedPct] [delay] => 5m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 0 [units] => % [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765757] => Array ( [itemid] => 765757 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[dat,{HOST.HOST},readWrite.dsHostCountByAccess] [delay] => 30m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 3 [units] => hosts [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) [765758] => Array ( [itemid] => 765758 [type] => 10 [hostid] => 14294 [name] => $3 [key_] => VMW_datastores.sh[def,{HOST.HOST},dsFreeSpacePctLim] [delay] => 10m [history] => 90d [trends] => 365d [status] => 0 [value_type] => 0 [units] => % [valuemapid] => 0 [description] => [state] => 0 [error] => [applications] => Array ( [0] => Array ( [applicationid] => 22770 ) ) ) ) 4. application.get [CControllerLatest.php:172] Parameters: Array ( [output] => Array ( [0] => applicationid [1] => name ) [hostids] => Array ( [0] => 14294 ) [preservekeys] => 1 ) Result: Array ( [22770] => Array ( [applicationid] => 22770 [name] => VMW_VCenter_Datastores ) ) 5. host.get [CControllerLatest.php:265] Parameters: Array ( [output] => Array ( [0] => hostid [1] => name ) [hostids] => Array ( [0] => 14294 ) ) Result: Array ( [0] => Array ( [hostid] => 14294 [name] => HOSTNAME ) ) 6. item.get [CMacrosResolver.php:1522] Parameters: Array ( [output] => Array ( [0] => hostid [1] => interfaceid ) [itemids] => Array ( [0] => 765747 [1] => 765748 [2] => 765749 [3] => 765750 [4] => 765751 [5] => 765752 [6] => 765753 [7] => 765754 [8] => 765755 [9] => 765756 [10] => 765757 [11] => 765758 ) [webitems] => 1 [filter] => Array ( [flags] => ) [preservekeys] => 1 [selectHosts] => Array ( [0] => hostid [1] => host [2] => name ) ) Result: Array ( [765747] => Array ( [itemid] => 765747 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765748] => Array ( [itemid] => 765748 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765749] => Array ( [itemid] => 765749 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765750] => Array ( [itemid] => 765750 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765751] => Array ( [itemid] => 765751 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765752] => Array ( [itemid] => 765752 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765753] => Array ( [itemid] => 765753 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765754] => Array ( [itemid] => 765754 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765755] => Array ( [itemid] => 765755 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765756] => Array ( [itemid] => 765756 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765757] => Array ( [itemid] => 765757 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) [765758] => Array ( [itemid] => 765758 [hostid] => 14294 [interfaceid] => 34650 [hosts] => Array ( [0] => Array ( [hostid] => 14294 [host] => AMIX.77dec371-37bf0865 [name] => HOSTNAME ) ) ) ) SQL (0.001753): 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.000499): 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.003365): 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.000515): 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.000203): 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.00014): 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.000217): 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.000127): 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.000203): 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.000195): 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.000185): 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.00018): 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.000176): 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.000184): 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.000611): 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 (7.2E-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.00072): SELECT h.hostid,h.name,h.status FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=14294 AND h.status=0 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:1098 SQL (6.5E-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 (9.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.000621): SELECT i.itemid,i.hostid,i.value_type FROM items i WHERE i.flags IN (0,4) AND i.hostid=14294 AND i.status=0 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 (6.0E-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.014942): SELECT itemid FROM history_uint WHERE itemid IN (765747,765748,765750,765752,765755,765757) AND clock>1600352829 GROUP BY itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CHistoryManager->getItemsHavingValues() → CHistoryManager->getItemsHavingValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:78 SQL (0.010571): SELECT itemid FROM history_text WHERE itemid IN (765749,765753) AND clock>1600352829 GROUP BY itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CHistoryManager->getItemsHavingValues() → CHistoryManager->getItemsHavingValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:78 SQL (0.011141): SELECT itemid FROM history WHERE itemid IN (765751,765756,765758) AND clock>1600352829 GROUP BY itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CHistoryManager->getItemsHavingValues() → CHistoryManager->getItemsHavingValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:78 SQL (0.008004): SELECT itemid FROM history_str WHERE itemid=765754 AND clock>1600352829 GROUP BY itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->prepareData() → CHistoryManager->getItemsHavingValues() → CHistoryManager->getItemsHavingValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:78 SQL (6.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.000836): SELECT i.itemid,i.type,i.hostid,i.name,i.key_,i.delay,i.history,i.trends,i.status,i.value_type,i.units,i.valuemapid,i.description,ir.state,COALESCE(ir.error,'') AS error FROM items i LEFT JOIN item_rtdata ir ON i.itemid=ir.itemid WHERE i.flags IN (0,4) AND i.itemid IN (765747,765748,765749,765750,765751,765752,765753,765754,765755,765756,765757,765758) 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.000415): SELECT t.itemappid,t.itemid,t.applicationid FROM items_applications t WHERE t.itemid IN (765747,765748,765749,765750,765751,765752,765753,765754,765755,765756,765757,765758) 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.000358): SELECT a.applicationid FROM applications a WHERE a.applicationid=22770 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 (5.7E-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.3E-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.000186): SELECT a.applicationid,a.name FROM applications a WHERE a.hostid=14294 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 (4.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 (4.5E-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.000177): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=14294 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:1098 SQL (4.7E-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.0001): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CMacrosResolverHelper::resolveItemKeys() → CMacrosResolver->resolveItemKeys() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.000249): SELECT i.itemid,i.hostid,i.interfaceid FROM items i WHERE i.itemid IN (765747,765748,765749,765750,765751,765752,765753,765754,765755,765756,765757,765758) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → 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.000205): SELECT h.hostid,h.host,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=14294 AND h.status IN (0,1,3) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → 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:1098 SQL (5.3E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → 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.004102): SELECT * FROM history_uint h WHERE h.itemid='765747' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.002633): SELECT * FROM history_uint h WHERE h.itemid='765748' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.004738): SELECT * FROM history_text h WHERE h.itemid='765749' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.002734): SELECT * FROM history_uint h WHERE h.itemid='765750' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.004083): SELECT * FROM history h WHERE h.itemid='765751' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.002576): SELECT * FROM history_uint h WHERE h.itemid='765752' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.00248): SELECT * FROM history_text h WHERE h.itemid='765753' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.004357): SELECT * FROM history_str h WHERE h.itemid='765754' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.002659): SELECT * FROM history_uint h WHERE h.itemid='765755' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.002843): SELECT * FROM history h WHERE h.itemid='765756' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.00264): SELECT * FROM history_uint h WHERE h.itemid='765757' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.002607): SELECT * FROM history h WHERE h.itemid='765758' ORDER BY h.clock DESC LIMIT 3 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->extendData() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSql() → DBselect() in include/classes/api/managers/CHistoryManager.php:247 SQL (0.0002): 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() → CController->run() → CControllerLatestView->doAction() → CControllerLatest->addCollapsedDataFromProfile() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000177): 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.000175): 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.000228): 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