******************** Script profiler ******************** Total time: 0.095444 Total SQL time: 0.016207 SQL count: 28 (selects: 17 | executes: 11) Peak memory usage: 8.5M Memory limit: 128M 1. httptest.get [httpdetails.php:71] Parameters: Array ( [output] => Array ( [0] => httptestid [1] => name [2] => hostid ) [httptestids] => 260 [preservekeys] => 1 ) Result: Array ( [260] => Array ( [httptestid] => 260 [name] => HTTP Main Page [hostid] => 12307 ) ) 2. httptest.get [CScreenHttpTestDetails.php:40] Parameters: Array ( [output] => Array ( [0] => httptestid [1] => name [2] => hostid ) [selectSteps] => Array ( [0] => httpstepid [1] => name [2] => no ) [httptestids] => 260 [preservekeys] => 1 ) Result: Array ( [260] => Array ( [httptestid] => 260 [name] => HTTP Main Page [hostid] => 12307 [steps] => Array ( [0] => Array ( [httpstepid] => 276 [name] => step_1 [no] => 1 ) ) ) ) SQL (0.000254): SET NAMES utf8 httpdetails.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DBexecute() in include/db.inc.php:63 SQL (0.000677): SHOW TABLES LIKE 'dbversion' httpdetails.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DbBackend->checkDbVersion() > MysqlDbBackend->checkDbVersionTable() > DBselect() in include/classes/db/MysqlDbBackend.php:32 SQL (0.000348): SELECT dv.mandatory,dv.optional FROM dbversion dv httpdetails.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DbBackend->checkDbVersion() > DBselect() in include/classes/db/DbBackend.php:46 SQL (0.000246): SELECT NULL FROM config c httpdetails.php:22 > require_once() > ZBase->run() > ZBase->initDB() > DBconnect() > DbBackend->checkConfig() > DBselect() in include/classes/db/DbBackend.php:62 SQL (0.000338): BEGIN httpdetails.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.000616): 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>1496294808 OR u.autologout=0) httpdetails.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.000479): 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 httpdetails.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.000354): UPDATE sessions SET lastaccess=1496294808 WHERE userid='45' AND sessionid='7ade57cd0657c83ff4fd9bedbd4e0b8d' httpdetails.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.000384): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='45' AND g.usrgrpid=ug.usrgrpid httpdetails.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.000355): 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' httpdetails.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.000355): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='45' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1 httpdetails.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.000266): COMMIT httpdetails.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.005876): SELECT p.* FROM profiles p WHERE p.userid=45 ORDER BY p.userid,p.profileid httpdetails.php:32 > require_once() > zbx_construct_menu() > CProfile::update() > CProfile::init() > DBselect() in include/classes/user/CProfile.php:42 SQL (0.000702): SELECT c.* FROM config c httpdetails.php:32 > require_once() > select_config() > DBselect() in include/profiles.inc.php:33 SQL (0.000349): BEGIN httpdetails.php:71 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000596): SELECT ht.httptestid,ht.name,ht.hostid FROM httptest ht WHERE ht.httptestid='260' httpdetails.php:71 > 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.000223): COMMIT httpdetails.php:71 > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000269): BEGIN httpdetails.php:96 > CScreenHttpTestDetails->get() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000357): SELECT ht.httptestid,ht.name,ht.hostid FROM httptest ht WHERE ht.httptestid='260' httpdetails.php:96 > CScreenHttpTestDetails->get() > 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.000485): SELECT t.httpstepid,t.name,t.no,t.httptestid FROM httpstep t httpdetails.php:96 > CScreenHttpTestDetails->get() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > call_user_func_array() > CHttpTest->get() > CHttpTest->addRelatedObjects() > CApiService->select() > DBselect() in include/classes/api/CApiService.php:350 SQL (0.000208): COMMIT httpdetails.php:96 > CScreenHttpTestDetails->get() > CFrontendApiWrapper->get() > CApiWrapper->__call() > CFrontendApiWrapper->callMethod() > CApiWrapper->callMethod() > CFrontendApiWrapper->callClientMethod() > CLocalApiClient->callMethod() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323 SQL (0.000514): 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='260' httpdetails.php:96 > CScreenHttpTestDetails->get() > CHttpTestManager->getLastData() > DBselect() in include/classes/api/managers/CHttpTestManager.php:1036 SQL (0.00036): SELECT i.value_type,i.valuemapid,i.units,i.itemid,hi.type,hs.httpstepid FROM items i,httpstepitem hi,httpstep hs WHERE hi.itemid=i.itemid AND hi.httpstepid=hs.httpstepid AND hs.httptestid='260' httpdetails.php:96 > CScreenHttpTestDetails->get() > DBselect() in include/classes/screens/CScreenHttpTestDetails.php:69 SQL (0.000558): SELECT i.itemid,i.value_type,i.history,i.trends FROM items i,httpstepitem hi,httpstep hs WHERE i.itemid=hi.itemid AND hi.httpstepid=hs.httpstepid AND hs.httptestid='260' httpdetails.php:127 > DBselect() in httpdetails.php:127 SQL (0.000235): SELECT MIN(h.clock) AS min_clock FROM () h httpdetails.php:129 > get_min_itemclock_by_itemid() > DBselect() in include/graphs.inc.php:242 SQL (0.000176): BEGIN httpdetails.php:217 > require_once() > DBstart() > DBexecute() in include/db.inc.php:262 SQL (0.000396): UPDATE profiles SET value_str='20170601092648', type=3 WHERE userid=45 AND idx='web.httptest.stime' AND idx2='260' httpdetails.php:217 > require_once() > CProfile::flush() > CProfile::updateDB() > DBexecute() in include/classes/user/CProfile.php:304 SQL (0.000231): COMMIT httpdetails.php:217 > require_once() > DBend() > DBcommit() > DBexecute() in include/db.inc.php:323