******************** Script profiler ******************** Total time: 0.150792 Total SQL time: 0.030979 SQL count: 20 (selects: 21 | executes: 8) Peak memory usage: 4M 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] => 175752 ) [preservekeys] => 1 [templated] => [webitems] => 1 ) Result: Array ( [175752] => Array ( [itemid] => 175752 [key_] => vfs.fs.size[E:,total] [name] => E:: Total space [value_type] => 3 [hostid] => 10322 [valuemapid] => 0 [history] => 7d [trends] => 365d [hosts] => Array ( [0] => Array ( [hostid] => 10322 [name] => par-cic-01 ) ) ) ) 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] => 175752 ) [webitems] => 1 [preservekeys] => 1 ) Result: Array ( [175752] => Array ( [itemid] => 175752 [hostid] => 10322 [name] => E:: Total space [key_] => vfs.fs.size[E:,total] [value_type] => 3 [valuemapid] => 0 [history] => 7d [trends] => 365d [hosts] => Array ( [0] => Array ( [hostid] => 10322 [name] => par-cic-01 ) ) ) ) SQL (0.006972): 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:179 SQL (0.001495): 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.001207): SELECT NULL FROM users u WHERE u.userid=3 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.000988): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 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.001441): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.layout.mode' history.php:30 → CViewHelper::loadLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.00119): SELECT c.* FROM config c history.php:37 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33 SQL (0.001247): BEGIN history.php:76 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.001048): 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=175752 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:403 SQL (0.00128): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10322 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:1098 SQL (0.000907): COMMIT history.php:76 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00117): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.item.graph.filter.active' history.php:112 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.001317): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=3 AND p.idx='web.favorite.graphids' ORDER BY p.profileid history.php:127 → CView->getOutput() → include() → get_icon() → CFavorite::exists() → CFavorite::get() → DBselect() in include/classes/user/CFavorite.php:55 SQL (0.002425): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.item.graph.filter.from' history.php:127 → CView->getOutput() → include() → CScreenBuilder::getScreen() → CScreenHistory->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.002305): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.item.graph.filter.to' history.php:127 → CView->getOutput() → include() → CScreenBuilder::getScreen() → CScreenHistory->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.001081): BEGIN history.php:127 → CView->getOutput() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000934): 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=175752 history.php:127 → 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:403 SQL (0.001012): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10322 AND h.status IN (0,1,3) history.php:127 → 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:1098 SQL (0.000656): COMMIT history.php:127 → CView->getOutput() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.001226): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.login.attempt.failed' history.php:127 → CView->getOutput() → include() → CWidget->show() → CWidget->toString() → get_prepared_messages() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.001078): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.paging.lastpage' history.php:129 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180