Latest data

HostNameLast checkLast valueChange
Specify some filter condition to see the values.
0 selected
******************** Script profiler ********************
Total time: 0.036582
Total SQL time: 0.025814
SQL count: 21 (selects: 20 | executes: 10)
Peak memory usage: 2M
Memory limit: 128M


SQL (0.000376): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
latest.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:107

SQL (0.000433): UPDATE ids SET nextid=2277957 WHERE table_name='auditlog' AND field_name='auditid'
latest.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:121

SQL (0.000291): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776049782','216.73.216.101','3','0','','2277957')
latest.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DBexecute() in include/classes/db/DB.php:467

SQL (0.008305): COMMIT
latest.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:291

SQL (0.000754): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.layout.mode'
latest.php:32 → CView::getLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000446): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.view.last'
latest.php:38 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00073): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
latest.php:38 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000527): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.filter.select'
latest.php:96 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00041): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.filter.show_without_data'
latest.php:97 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000366): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.filter.show_details'
latest.php:98 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000376): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.filter.application'
latest.php:99 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000587): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.filter.groupids'
latest.php:100 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000572): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.filter.hostids'
latest.php:101 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000386): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.php.sort'
latest.php:104 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000397): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.php.sortorder'
latest.php:105 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000613): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.filter.active'
latest.php:319 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000767): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
latest.php:796 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000118): BEGIN
latest.php:796 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000553): UPDATE profiles SET value_str='DESC', type=3 WHERE userid=2 AND idx='web.latest.php.sortorder' AND idx2='0'
latest.php:796 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.000262): UPDATE profiles SET value_str='latest.php', type=3 WHERE userid=2 AND idx='web.paging.lastpage' AND idx2='0'
latest.php:796 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.008545): COMMIT
latest.php:796 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291


Debug