******************** Script profiler ******************** Total time: 0.096144 Total SQL time: 0.028508 SQL count: 52 (selects: 31 | executes: 21) Peak memory usage: 11.75M Memory limit: 128M 1. host.isWritable [httpconf.php:119] Parameters: Array ( [0] => 12307 ) Result: 1 2. hostgroup.get [CPageFilter.php:390] Parameters: Array ( [output] => Array ( [0] => groupid [1] => name ) [preservekeys] => 1 [editable] => 1 ) Result: Array ( [5] => Array ( [groupid] => 5 [name] => Discovered hosts ) [55] => Array ( [groupid] => 55 [name] => Hypervisors ) [14] => Array ( [groupid] => 14 [name] => Internet ) [1] => Array ( [groupid] => 1 [name] => Templates ) [56] => Array ( [groupid] => 56 [name] => Virtual machines ) [64] => Array ( [groupid] => 64 [name] => ÀÈÑ ÃÏÆÑ ) [62] => Array ( [groupid] => 62 [name] => ÃÀÑ Âûáîðû ) [9] => Array ( [groupid] => 9 [name] => ÎÏÑ ÌÎ ) [26] => Array ( [groupid] => 26 [name] => ÎÏÑ Ïðîêóðàòóðà ) [16] => Array ( [groupid] => 16 [name] => ÎÏÑ ÞÍÈÈÈÒ ) [45] => Array ( [groupid] => 45 [name] => ÎÏÑ ßäðî ) [46] => Array ( [groupid] => 46 [name] => ÏÇÈ ) [10] => Array ( [groupid] => 10 [name] => ÏÑÏÄ Äîñòóï ) [32] => Array ( [groupid] => 32 [name] => ÏÑÏÄ Äîñòóï ÅÄÄÑ ) [7] => Array ( [groupid] => 7 [name] => ÏÑÏÄ Äîñòóï ÌÎ ) [33] => Array ( [groupid] => 33 [name] => ÏÑÏÄ Äîñòóï Ïðîêóðàòóðà ) [13] => Array ( [groupid] => 13 [name] => ÏÑÏÄ ÑÇÄ ÄÔ ) [37] => Array ( [groupid] => 37 [name] => ÏÑÏÄ ÞÍÈÈÈÒ ) [11] => Array ( [groupid] => 11 [name] => ÏÑÏÄ ßäðî ) [31] => Array ( [groupid] => 31 [name] => ÏÑÏÄ ßäðî ÄÄÑ ) [43] => Array ( [groupid] => 43 [name] => ÏÑÏÄ ßäðî ÅÄÄÑ only ) [54] => Array ( [groupid] => 54 [name] => ÏÑÏÄ ßäðî ÆèëÑòðîéÍàäçîð ) [67] => Array ( [groupid] => 67 [name] => ÏÑÏÄ ßäðî ÌÎ IPT ÂÊÑ ) [8] => Array ( [groupid] => 8 [name] => ÏÑÏÄ ßäðî ÌÎ Óïðàâëåíèå ) [66] => Array ( [groupid] => 66 [name] => ÏÑÏÄ ßäðî ÌÎ Ôèçèêà ) [34] => Array ( [groupid] => 34 [name] => ÏÑÏÄ ßäðî Ïðîêóðàòóðà ) [15] => Array ( [groupid] => 15 [name] => ÏÑÑ IPT ) [39] => Array ( [groupid] => 39 [name] => ÏÑÑ ÁÓ ÈÊÒ ) [40] => Array ( [groupid] => 40 [name] => ÏÑÑ ÂÊÑ ) [50] => Array ( [groupid] => 50 [name] => ÏÑÑ ÄÝÑÇ ) [25] => Array ( [groupid] => 25 [name] => ÏÑÑ ÅÄÄÑ ) [21] => Array ( [groupid] => 21 [name] => ÏÑÑ ÊÑ Îà) [22] => Array ( [groupid] => 22 [name] => ÏÑÑ Ïðîêóðàòóðà ) [63] => Array ( [groupid] => 63 [name] => ÏÑÑ Ïðî÷åå ) [18] => Array ( [groupid] => 18 [name] => ÏÑÑ ÑÑÒÓ ) [41] => Array ( [groupid] => 41 [name] => ÏÑÑ ÒÀÑÖÎ ) [17] => Array ( [groupid] => 17 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ) [51] => Array ( [groupid] => 51 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ËÈÊÒ ) [19] => Array ( [groupid] => 19 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ËÑÈÒ ) [65] => Array ( [groupid] => 65 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ËÑÈÒ ADMHMAO ) [69] => Array ( [groupid] => 69 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ËÑÈÒ WWW Ñòîðîííèå ) [68] => Array ( [groupid] => 68 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ËÑÈÒ Òåëåìåäèöèíà ) [52] => Array ( [groupid] => 52 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ËÑÈÒ ÓÖ ) [47] => Array ( [groupid] => 47 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ËÝÒÎ ) [48] => Array ( [groupid] => 48 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ÖÄÇÇ ) [53] => Array ( [groupid] => 53 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ÖÈÎÑ ) [42] => Array ( [groupid] => 42 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ÖÈÒÎ ) [4] => Array ( [groupid] => 4 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ÖÈÒÎ Zabbix ) [49] => Array ( [groupid] => 49 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ÖÎÈ ) [44] => Array ( [groupid] => 44 [name] => ÏÑÑ ÞÍÈÈ ÈÒ ÖÒÇÈ ) [24] => Array ( [groupid] => 24 [name] => ÏÑÑ ÞÍÈÈÈÒ IPT Endpoints ) [6] => Array ( [groupid] => 6 [name] => ÏÑÓ ÞÍÈÈ ÈÒ ÖÈÒÎ ) [38] => Array ( [groupid] => 38 [name] => ÏÑÓ ÞÍÈÈ ÈÒ ÖÈÒÎ ÂÈÐÒ ) [61] => Array ( [groupid] => 61 [name] => Ñóðãóòñêèé òóá äèñïàíñåð ) ) 3. host.get [CPageFilter.php:446] Parameters: Array ( [output] => Array ( [0] => hostid ) [hostids] => 12307 [groupids] => Array ( [0] => 65 ) ) Result: Array ( [0] => Array ( [hostid] => 12307 ) ) 4. host.get [CPageFilter.php:559] Parameters: Array ( [output] => Array ( [0] => hostid [1] => name [2] => status ) [groupids] => Array ( [0] => 65 ) [editable] => 1 [templated_hosts] => 1 ) Result: Array ( [0] => Array ( [hostid] => 12323 [name] => depit.admhmao.ru _FROM_BARNAUL_ [status] => 0 ) [1] => Array ( [hostid] => 12317 [name] => depit.admhmao.ru _FROM_HM_ [status] => 0 ) [2] => Array ( [hostid] => 12306 [name] => mirror-dump-admhmao.ru [status] => 0 ) [3] => Array ( [hostid] => 12324 [name] => prod-01-app.admhmao.ru _FROM_DMZ_ [status] => 0 ) [4] => Array ( [hostid] => 12301 [name] => prod-01-app.admhmao.ru _FROM_VLAN12_ [status] => 0 ) [5] => Array ( [hostid] => 12322 [name] => www.admhmao.ru _FROM_BARNAUL_ [status] => 0 ) [6] => Array ( [hostid] => 12307 [name] => www.admhmao.ru _FROM_HM_ [status] => 0 ) ) 5. host.get [httpconf.php:652] Parameters: Array ( [hostids] => 12307 [output] => Array ( [0] => status ) ) Result: Array ( [0] => Array ( [hostid] => 12307 [status] => 0 ) ) 6. httptest.get [httpconf.php:675] Parameters: Array ( [editable] => 1 [output] => Array ( [0] => httptestid [1] => name ) [limit] => 1001 [hostids] => 12307 ) Result: Array ( [0] => Array ( [httptestid] => 260 [name] => HTTP Main Page ) [1] => Array ( [httptestid] => 299 [name] => HTTP Main Page 2 ) [2] => Array ( [httptestid] => 267 [name] => HTTP ÁÈÎÃÐÀÔÈß Page ) [3] => Array ( [httptestid] => 264 [name] => HTTP ÃÐÀÔÈÊ ÌÅÐÎÏÐÈßÒÈÉ Page ) [4] => Array ( [httptestid] => 265 [name] => HTTP ÄÅÏÀÐÒÀÌÅÍÒÛ Page ) [5] => Array ( [httptestid] => 261 [name] => HTTP ÎÁÙÈÅ ÑÂÅÄÅÍÈß Page ) [6] => Array ( [httptestid] => 266 [name] => HTTP ÏÐÀÂÎÂÛÅ ÀÊÒÛ Page ) [7] => Array ( [httptestid] => 262 [name] => HTTP ÑÈÌÂÎËÛ Page ) [8] => Array ( [httptestid] => 263 [name] => HTTP ÓÑÒÀ Page ) ) 7. host.get [html.inc.php:243] Parameters: Array ( [output] => Array ( [0] => hostid [1] => status [2] => proxy_hostid [3] => name [4] => maintenance_status [5] => flags [6] => available [7] => snmp_available [8] => jmx_available [9] => ipmi_available [10] => error [11] => snmp_error [12] => jmx_error [13] => ipmi_error ) [selectHostDiscovery] => Array ( [0] => ts_delete ) [hostids] => Array ( [0] => 12307 ) [editable] => 1 [selectApplications] => count [selectItems] => count [selectTriggers] => count [selectGraphs] => count [selectDiscoveries] => count [selectHttpTests] => count ) Result: Array ( [0] => Array ( [hostid] => 12307 [status] => 0 [proxy_hostid] => 0 [name] => www.admhmao.ru _FROM_HM_ [maintenance_status] => 0 [flags] => 0 [available] => 1 [snmp_available] => 0 [jmx_available] => 0 [ipmi_available] => 0 [error] => [snmp_error] => [jmx_error] => [ipmi_error] => [items] => 52 [discoveries] => 2 [triggers] => 39 [graphs] => 17 [httpTests] => 9 [applications] => 11 [hostDiscovery] => Array ( ) ) ) SQL (0.000186): SET NAMES utf8 httpconf.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DBexecute() in include/db.inc.php:63 SQL (0.000929): SHOW TABLES LIKE 'dbversion' httpconf.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DbBackend->checkDbVersion() > MysqlDbBackend->checkDbVersionTable() > DBselect() in include/classes/db/MysqlDbBackend.php:32 SQL (0.000347): SELECT dv.mandatory,dv.optional FROM dbversion dv httpconf.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DbBackend->checkDbVersion() > DBselect() in include/classes/db/DbBackend.php:46 SQL (0.000306): SELECT NULL FROM config c httpconf.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DbBackend->checkConfig() > DBselect() in include/classes/db/DbBackend.php:62 SQL (0.000322): BEGIN httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000479): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='7ade57cd0657c83ff4fd9bedbd4e0b8d' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1496294851 OR u.autologout=0) httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CUser->checkAuthentication() > DBselect() in include/classes/api/services/CUser.php:1196 SQL (0.000455): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid='45' AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0 httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CUser->checkAuthentication() > check_perm2system() > DBselect() in include/perm.inc.php:75 SQL (0.000423): UPDATE sessions SET lastaccess=1496294851 WHERE userid='45' AND sessionid='7ade57cd0657c83ff4fd9bedbd4e0b8d' httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CUser->checkAuthentication() > DBexecute() in include/classes/api/services/CUser.php:1221 SQL (0.00045): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='45' AND g.usrgrpid=ug.usrgrpid httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CUser->checkAuthentication() > DBselect() in include/classes/api/services/CUser.php:1229 SQL (0.000358): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid='45' httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CUser->checkAuthentication() > CUser->_getUserData() > DBselect() in include/classes/api/services/CUser.php:1253 SQL (0.000513): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='45' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1 httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CUser->checkAuthentication() > CUser->_getUserData() > DBselect() in include/classes/api/services/CUser.php:1261 SQL (0.000324): COMMIT httpconf.php:22 > require_once() > ZBase->run() > ZBase->authenticateUser() > CWebUser::checkAuthentication() > CFrontendApiWrapper->checkAuthentication() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.009319): SELECT p.* FROM profiles p WHERE p.userid=45 ORDER BY p.userid,p.profileid httpconf.php:31 > require_once() > zbx_construct_menu() > CProfile::update() > CProfile::init() > DBselect() in include/classes/user/CProfile.php:42 SQL (0.000585): SELECT c.* FROM config c httpconf.php:31 > require_once() > select_config() > DBselect() in include/profiles.inc.php:33 SQL (0.000198): BEGIN httpconf.php:119 > CFrontendApiWrapper->isWritable() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000391): SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='12307' AND h.status IN (0,1,3) httpconf.php:119 > CFrontendApiWrapper->isWritable() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->isWritable() > CHost->get() > DBselect() in include/classes/api/services/CHost.php:432 SQL (0.000189): COMMIT httpconf.php:119 > CFrontendApiWrapper->isWritable() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000205): BEGIN httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initGroups() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000384): SELECT g.groupid,g.name FROM groups g httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initGroups() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHostGroup->get() > DBselect() in include/classes/api/services/CHostGroup.php:318 SQL (0.000188): COMMIT httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initGroups() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000211): BEGIN httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initGroups() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000382): SELECT DISTINCT h.hostid FROM hosts h,hosts_groups hg WHERE h.flags IN (0,4) AND h.hostid='12307' AND hg.groupid='65' AND hg.hostid=h.hostid AND h.status IN (0,1) httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initGroups() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > DBselect() in include/classes/api/services/CHost.php:432 SQL (0.00017): COMMIT httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initGroups() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000157): BEGIN httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initHosts() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.0006): SELECT DISTINCT h.hostid,h.name,h.status FROM hosts h,hosts_groups hg WHERE h.flags IN (0,4) AND hg.groupid='65' AND hg.hostid=h.hostid AND h.status IN (0,1,3) httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initHosts() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > DBselect() in include/classes/api/services/CHost.php:432 SQL (0.000497): COMMIT httpconf.php:634 > CPageFilter->__construct() > CPageFilter->_initHosts() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000175): BEGIN httpconf.php:652 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000343): SELECT h.hostid,h.status FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='12307' AND h.status IN (0,1) httpconf.php:652 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > DBselect() in include/classes/api/services/CHost.php:432 SQL (0.000175): COMMIT httpconf.php:652 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.0002): BEGIN httpconf.php:675 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000349): SELECT ht.httptestid,ht.name FROM httptest ht WHERE ht.hostid='12307' LIMIT 1001 OFFSET 0 httpconf.php:675 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHttpTest->get() > DBselect() in include/classes/api/services/CHttpTest.php:201 SQL (0.000176): COMMIT httpconf.php:675 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000594): SELECT ht.httptestid,ht.name,ht.delay,ht.status,ht.hostid,ht.templateid,h.name AS hostname,ht.retries,ht.authentication,ht.http_proxy,a.applicationid,a.name AS application_name FROM httptest ht INNER JOIN hosts h ON h.hostid=ht.hostid LEFT JOIN applications a ON a.applicationid=ht.applicationid WHERE (ht.httptestid BETWEEN '260' AND '267' OR ht.httptestid='299') httpconf.php:684 > DBselect() in httpconf.php:684 SQL (0.000362): SELECT hti.httptestid,hti.type,i.itemid,i.value_type FROM httptestitem hti,items i WHERE hti.itemid=i.itemid AND hti.type IN (3,4) AND (hti.httptestid BETWEEN '260' AND '267' OR hti.httptestid='299') httpconf.php:699 > CHttpTestManager->getLastData() > DBselect() in include/classes/api/managers/CHttpTestManager.php:1036 SQL (0.000313): SELECT * FROM history_uint h WHERE h.itemid='263002' AND h.clock>1496208451 ORDER BY h.clock DESC LIMIT 1 OFFSET 0 httpconf.php:699 > CHttpTestManager->getLastData() > CHistoryManager->getLast() > DBselect() in include/classes/api/managers/CHistoryManager.php:46 SQL (0.000286): SELECT * FROM history_str h WHERE h.itemid='263003' AND h.clock>1496208451 ORDER BY h.clock DESC LIMIT 1 OFFSET 0 httpconf.php:699 > CHttpTestManager->getLastData() > CHistoryManager->getLast() > DBselect() in include/classes/api/managers/CHistoryManager.php:46 SQL (0.000289): SELECT hs.* FROM httpstep hs WHERE hs.httptestid='299' AND hs.no='0' httpconf.php:703 > get_httpstep_by_no() > DBselect() in include/httptest.inc.php:111 SQL (0.000308): SELECT hs.httptestid,COUNT(*) AS stepscnt FROM httpstep hs WHERE (hs.httptestid BETWEEN '260' AND '267' OR hs.httptestid='299') GROUP BY hs.httptestid httpconf.php:717 > DBselect() in httpconf.php:717 SQL (0.000225): SELECT ht.httptestid,ht.templateid,ht.hostid,h.name FROM httptest ht INNER JOIN hosts h ON h.hostid=ht.hostid WHERE 1=0 httpconf.php:724 > getHttpTestsParentTemplates() > DBselect() in include/httptest.inc.php:149 SQL (0.000212): BEGIN httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000296): SELECT h.hostid,h.status,h.proxy_hostid,h.name,h.maintenance_status,h.flags,h.available,h.snmp_available,h.jmx_available,h.ipmi_available,h.error,h.snmp_error,h.jmx_error,h.ipmi_error FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='12307' AND h.status IN (0,1) httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > DBselect() in include/classes/api/services/CHost.php:432 SQL (0.000924): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid='12307' GROUP BY i.hostid httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > CHost->addRelatedObjects() > CHostGeneral->addRelatedObjects() > CItem->get() > DBselect() in include/classes/api/services/CItem.php:353 SQL (0.000742): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i WHERE i.flags=1 AND i.hostid='12307' GROUP BY i.hostid httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > CHost->addRelatedObjects() > CHostGeneral->addRelatedObjects() > CDiscoveryRule->get() > DBselect() in include/classes/api/services/CDiscoveryRule.php:220 SQL (0.001101): SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid='12307' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4') GROUP BY i.hostid httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > CHost->addRelatedObjects() > CHostGeneral->addRelatedObjects() > CTrigger->get() > DBselect() in include/classes/api/services/CTrigger.php:424 SQL (0.001012): SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid='12307' AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > CHost->addRelatedObjects() > CHostGeneral->addRelatedObjects() > CGraph->get() > DBselect() in include/classes/api/services/CGraph.php:293 SQL (0.000314): SELECT COUNT(DISTINCT ht.httptestid) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid='12307' GROUP BY ht.hostid httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > CHost->addRelatedObjects() > CHostGeneral->addRelatedObjects() > CHttpTest->get() > DBselect() in include/classes/api/services/CHttpTest.php:201 SQL (0.000367): SELECT COUNT(DISTINCT a.applicationid) AS rowscount,a.hostid FROM applications a WHERE a.hostid='12307' GROUP BY a.hostid httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > CHost->addRelatedObjects() > CHostGeneral->addRelatedObjects() > CApplication->get() > DBselect() in include/classes/api/services/CApplication.php:207 SQL (0.000236): SELECT t.hostid,t.ts_delete FROM host_discovery t WHERE t.hostid='12307' httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHost->get() > CHost->addRelatedObjects() > CApiService->select() > DBselect() in include/classes/api/CApiService.php:350 SQL (0.000161): COMMIT httpconf.php:732 > CView->render() > include() > get_header_host_table() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000182): BEGIN httpconf.php:736 > require_once() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000379): UPDATE profiles SET value_str='httpconf.php', type=3 WHERE userid=45 AND idx='web.paging.lastpage' httpconf.php:736 > require_once() > CProfile::flush() > CProfile::updateDB() > DBexecute() in include/classes/user/CProfile.php:304 SQL (0.000219): COMMIT httpconf.php:736 > require_once() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323