******************** Script profiler ******************** Total time: 0.008688 Total SQL time: 0.007667 SQL count: 25 (selects: 24 | executes: 10) Peak memory usage: 2M Memory limit: 128M 1. graph.get [CControllerChartsView.php:125] Parameters: Array ( [output] => Array ( [0] => name [1] => graphid ) [selectHosts] => Array ( [0] => name ) [graphids] => Array ( [0] => 838 ) ) Result: Array ( [0] => Array ( [graphid] => 838 [name] => Network traffic on ppp0 [hosts] => Array ( [0] => Array ( [hostid] => 10084 [name] => westogre ) ) ) ) 2. host.get [CControllerChartsView.php:147] Parameters: Array ( [output] => Array ( [0] => name [1] => hostid ) [hostids] => Array ( [0] => 10269 ) ) Result: Array ( [0] => Array ( [hostid] => 10269 [name] => dusty ) ) 3. graph.get [CControllerCharts.php:51] Parameters: Array ( [output] => Array ( ) [hostids] => Array ( [0] => 10269 ) [limit] => 20 [preservekeys] => 1 [graphids] => Array ( [0] => 838 ) ) Result: Array ( ) SQL (0.005014): 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:179 SQL (0.000191): 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.000107): SELECT NULL FROM users u WHERE u.userid=1 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.000178): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 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.000174): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.charts.filter.search_type' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000116): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.charts.filter.graphids' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000103): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.charts.filter.graph_patterns' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000117): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.charts.filter.hostids' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000109): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.charts.filter.from' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → updateTimeSelectorPeriod() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.000137): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.charts.filter.to' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → updateTimeSelectorPeriod() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (0.00016): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.charts.filter.active' zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:180 SQL (5.1E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (9.9E-5): SELECT g.graphid,g.name FROM graphs g WHERE g.graphid=838 AND g.flags IN (0,4) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:290 SQL (0.000136): SELECT gi.graphid,i.hostid FROM graphs_items gi,items i WHERE gi.graphid=838 AND gi.itemid=i.itemid zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → CGraph->addRelatedObjects() → CGraphGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CGraphGeneral.php:369 SQL (0.000101): 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) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → CGraph->addRelatedObjects() → CGraphGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1069 SQL (2.9E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.7E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (8.4E-5): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10269 AND h.status IN (0,1) zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1069 SQL (2.5E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.1E-5): BEGIN zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CControllerCharts->getGraphidsByHostids() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000222): SELECT DISTINCT g.graphid FROM graphs g,graphs_items gi,items i WHERE i.hostid=10269 AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.graphid=838 AND g.flags IN (0,4) LIMIT 20 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CControllerCharts->getGraphidsByHostids() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:290 SQL (3.4E-5): COMMIT zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerChartsView->doAction() → CControllerCharts->getGraphidsByHostids() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000121): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 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.000137): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 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.000174): SELECT c.* FROM config c zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → local_showHeader() → CPartial->getOutput() → include() → select_config() → DBselect() in include/profiles.inc.php:33