******************** Script profiler ******************** Total time: 0.035899 Total SQL time: 0.012316 SQL count: 27 (selects: 24 | executes: 13) Peak memory usage: 6M 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] => Array ( [name] => dsAccessible ) [preservekeys] => 1 ) Result: Array ( ) 3. 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 ) ) SQL (0.003): 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.000447): 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.003516): 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.000481): 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.000218): 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.00012): 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.000161): 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.000102): 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.000151): 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.000151): 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.000194): 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.000167): 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.000211): 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.000171): 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.000571): 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 (6.7E-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.000627): 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 (5.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 (6.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.000806): SELECT i.itemid,i.hostid,i.value_type FROM items i WHERE i.flags IN (0,4) AND i.hostid=14294 AND ((UPPER(i.name) LIKE '%DSACCESSIBLE%' ESCAPE '!')) 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 (5.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 (8.4E-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.000199): 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 (5.3E-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.000235): 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.000172): 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.00024): 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