******************** Script profiler ******************** Total time: 0.027754 Total SQL time: 0.009353 SQL count: 20 (selects: 21 | executes: 9) Peak memory usage: 6M Memory limit: 128M 1. item.get [history.php:76] Parameters: Array ( [output] => Array ( [0] => itemid [1] => key_ [2] => name [3] => value_type [4] => hostid [5] => valuemapid [6] => history [7] => trends ) [selectHosts] => Array ( [0] => name ) [itemids] => Array ( [0] => 30320 ) [preservekeys] => 1 [templated] => [webitems] => 1 ) Result: Array ( [30320] => Array ( [itemid] => 30320 [key_] => system.cpu.switches [name] => Context switches per second [value_type] => 0 [hostid] => 10084 [valuemapid] => 0 [history] => 7d [trends] => 365d [hosts] => Array ( [0] => Array ( [hostid] => 10084 [name] => zabbix4 ) ) ) ) 2. item.get [CScreenHistory.php:131] Parameters: Array ( [output] => Array ( [0] => itemid [1] => hostid [2] => name [3] => key_ [4] => value_type [5] => valuemapid [6] => history [7] => trends ) [selectHosts] => Array ( [0] => name ) [itemids] => Array ( [0] => 30320 ) [webitems] => 1 [preservekeys] => 1 ) Result: Array ( [30320] => Array ( [itemid] => 30320 [hostid] => 10084 [name] => Context switches per second [key_] => system.cpu.switches [value_type] => 0 [valuemapid] => 0 [history] => 7d [trends] => 365d [hosts] => Array ( [0] => Array ( [hostid] => 10084 [name] => zabbix4 ) ) ) ) SQL (0.000513): COMMIT history.php:22 → 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.000563): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path history.php:22 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:104 SQL (0.000602): SELECT NULL FROM users u WHERE u.userid=1 FOR UPDATE history.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:38 SQL (0.000537): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.sidebar.mode' history.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000292): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.layout.mode' history.php:30 → CViewHelper::loadLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000565): SELECT c.* FROM config c history.php:37 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33 SQL (0.000271): BEGIN history.php:76 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.001958): SELECT DISTINCT i.itemid,i.key_,i.name,i.value_type,i.hostid,i.valuemapid,i.history,i.trends FROM items i,hosts h WHERE i.flags IN (0,4) AND i.itemid=30320 AND h.hostid=i.hostid AND h.status<>3 history.php:76 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392 SQL (0.000411): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10084 AND h.status IN (0,1,3) history.php:76 → 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 (0.000193): COMMIT history.php:76 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182 SQL (0.000402): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.item.graph.filter.active' history.php:111 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.00036): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.graphids' ORDER BY p.profileid history.php:126 → CView->getOutput() → include() → get_icon() → CFavorite::exists() → CFavorite::get() → DBselect() in include/classes/user/CFavorite.php:55 SQL (0.00035): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.item.graph.filter.from' history.php:126 → CView->getOutput() → include() → CScreenBuilder::getScreen() → CScreenHistory->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000318): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.item.graph.filter.to' history.php:126 → CView->getOutput() → include() → CScreenBuilder::getScreen() → CScreenHistory->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000528): BEGIN history.php:126 → CView->getOutput() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128 SQL (0.000387): SELECT i.itemid,i.hostid,i.name,i.key_,i.value_type,i.valuemapid,i.history,i.trends FROM items i WHERE i.flags IN (0,4) AND i.itemid=30320 history.php:126 → CView->getOutput() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392 SQL (0.000301): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10084 AND h.status IN (0,1,3) history.php:126 → CView->getOutput() → include() → CScreenHistory->get() → 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 (0.000203): COMMIT history.php:126 → CView->getOutput() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182 SQL (0.000311): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.login.attempt.failed' history.php:126 → CView->getOutput() → include() → CWidget->show() → CWidget->toString() → get_prepared_messages() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000288): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.lastpage' history.php:128 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180