******************** Script profiler ******************** Total time: 0.078908 Total SQL time: 0.014991 SQL count: 97 (selects: 76 | executes: 21) Peak memory usage: 14.25M Memory limit: 128M 1. host.get [items.php:225] Parameters: Array ( [output] => Array ( [0] => hostid [1] => status ) [hostids] => 10582 [templated_hosts] => 1 [editable] => 1 ) Result: Array ( [0] => Array ( [hostid] => 10582 [status] => 3 ) ) 2. item.get [items.php:897] Parameters: Array ( [output] => Array ( [0] => itemid [1] => flags [2] => type ) [itemids] => Array ( [79987] => 79987 ) [preservekeys] => 1 ) Result: Array ( [79987] => Array ( [itemid] => 79987 [flags] => 0 [type] => 18 ) ) 3. item.update [items.php:999] Parameters: Array ( [0] => Array ( [itemid] => 79987 [description] => asdf ) ) Result: Array ( [itemids] => Array ( [0] => 79987 ) ) 4. host.get [items.php:1300] Parameters: Array ( [output] => Array ( [0] => hostid ) [itemids] => Array ( [79987] => 79987 ) [selectInterfaces] => extend ) Result: Array ( ) 5. template.get [items.php:1312] Parameters: Array ( [output] => Array ( [0] => templateid ) [itemids] => Array ( [79987] => 79987 ) ) Result: Array ( [0] => Array ( [templateid] => 10582 ) ) 6. valuemap.get [items.php:1367] Parameters: Array ( [output] => Array ( [0] => valuemapid [1] => name ) ) Result: Array ( [0] => Array ( [valuemapid] => 61 [name] => AP MAC -> NAME ) [1] => Array ( [valuemapid] => 4 [name] => APC Battery Replacement Status ) [2] => Array ( [valuemapid] => 5 [name] => APC Battery Status ) [3] => Array ( [valuemapid] => 28 [name] => CISCO-ENVMON-MIB::CiscoEnvMonState ) [4] => Array ( [valuemapid] => 60 [name] => ciscoEnvMonState ) [5] => Array ( [valuemapid] => 55 [name] => CPQHLTH-MIB::cpqHeTemperatureLocale ) [6] => Array ( [valuemapid] => 56 [name] => CPQIDA-MIB::cpqDaCntlrModel ) [7] => Array ( [valuemapid] => 57 [name] => CPQIDA-MIB::cpqDaPhyDrvStatus ) [8] => Array ( [valuemapid] => 54 [name] => CPQSINFO-MIB::status ) [9] => Array ( [valuemapid] => 7 [name] => Dell Open Manage System Status ) [10] => Array ( [valuemapid] => 64 [name] => DELL-STORAGE-SC-MIB::scCtlrFanStatus ) [11] => Array ( [valuemapid] => 65 [name] => DELL-STORAGE-SC-MIB::scCtlrPowerStatus ) [12] => Array ( [valuemapid] => 66 [name] => DELL-STORAGE-SC-MIB::scCtlrStatus ) [13] => Array ( [valuemapid] => 67 [name] => DELL-STORAGE-SC-MIB::scDiskHealthy ) [14] => Array ( [valuemapid] => 68 [name] => DELL-STORAGE-SC-MIB::scDiskStatus ) [15] => Array ( [valuemapid] => 69 [name] => DELL-STORAGE-SC-MIB::scEnclFanStatus ) [16] => Array ( [valuemapid] => 70 [name] => DELL-STORAGE-SC-MIB::scEnclTempStatus ) [17] => Array ( [valuemapid] => 71 [name] => DELL-STORAGE-SC-MIB::scServerStatus ) [18] => Array ( [valuemapid] => 72 [name] => DELL-STORAGE-SC-MIB::scVolumeStatus ) [19] => Array ( [valuemapid] => 18 [name] => ENTITY-SENSORS-MIB::EntitySensorStatus ) [20] => Array ( [valuemapid] => 48 [name] => ENTITY-STATE-MIB::EntityOperState ) [21] => Array ( [valuemapid] => 33 [name] => EQUIPMENT-MIB::swFanStatus ) [22] => Array ( [valuemapid] => 34 [name] => EQUIPMENT-MIB::swPowerStatus ) [23] => Array ( [valuemapid] => 19 [name] => EtherLike-MIB::dot3StatsDuplexStatus ) [24] => Array ( [valuemapid] => 36 [name] => EXTREME-SYSTEM-MIB::extremeFanOperational ) [25] => Array ( [valuemapid] => 37 [name] => EXTREME-SYSTEM-MIB::extremeOverTemperatureAlarm ) [26] => Array ( [valuemapid] => 38 [name] => EXTREME-SYSTEM-MIB::extremePowerSupplyStatus ) [27] => Array ( [valuemapid] => 30 [name] => F10-S-SERIES-CHASSIS-MIB::chSysFanTrayOperStatus ) [28] => Array ( [valuemapid] => 31 [name] => F10-S-SERIES-CHASSIS-MIB::chSysPowerSupplyOperStatus ) [29] => Array ( [valuemapid] => 29 [name] => F10-S-SERIES-CHASSIS-MIB::extremeFanOperational ) [30] => Array ( [valuemapid] => 50 [name] => FASTPATH-BOXSERVICES-PRIVATE-MIB::boxServicesFanItemState ) [31] => Array ( [valuemapid] => 49 [name] => FASTPATH-BOXSERVICES-PRIVATE-MIB::boxServicesPowSupplyItemState ) [32] => Array ( [valuemapid] => 51 [name] => FASTPATH-BOXSERVICES-PRIVATE-MIB::boxServicesTempSensorState ) [33] => Array ( [valuemapid] => 74 [name] => FCMGMT-MIB::connUnitPortHWState ) [34] => Array ( [valuemapid] => 75 [name] => FCMGMT-MIB::connUnitPortState ) [35] => Array ( [valuemapid] => 79 [name] => FCMGMT-MIB::connUnitPortStatus ) [36] => Array ( [valuemapid] => 76 [name] => FCMGMT-MIB::connUnitSensorStatus ) [37] => Array ( [valuemapid] => 27 [name] => FOUNDRY-SN-AGENT-MIB::snChasFanOperStatus ) [38] => Array ( [valuemapid] => 26 [name] => FOUNDRY-SN-AGENT-MIB::snChasPwrSupplyOperStatus ) [39] => Array ( [valuemapid] => 39 [name] => HH3C-ENTITY-EXT-MIB::hh3cEntityExtErrorStatus ) [40] => Array ( [valuemapid] => 2 [name] => Host availability ) [41] => Array ( [valuemapid] => 6 [name] => HP Insight System Status ) [42] => Array ( [valuemapid] => 40 [name] => HP-ICF-CHASSIS::hpicfSensorStatus ) [43] => Array ( [valuemapid] => 17 [name] => HTTP response status code ) [44] => Array ( [valuemapid] => 41 [name] => HUAWEI-ENTITY-EXTENT-MIB::hwEntityFanState ) [45] => Array ( [valuemapid] => 42 [name] => ICS-CHASSIS-MIB::icsChassisFanOperStatus ) [46] => Array ( [valuemapid] => 44 [name] => ICS-CHASSIS-MIB::icsChassisPowerSupplyOperStatus ) [47] => Array ( [valuemapid] => 43 [name] => ICS-CHASSIS-MIB::icsChassisSensorSlotOperStatus ) [48] => Array ( [valuemapid] => 45 [name] => ICS-CHASSIS-MIB::icsChassisTemperatureStatus ) [49] => Array ( [valuemapid] => 73 [name] => IF-MIB::ifAdminStatus ) [50] => Array ( [valuemapid] => 20 [name] => IF-MIB::ifOperStatus ) [51] => Array ( [valuemapid] => 21 [name] => IF-MIB::ifType ) [52] => Array ( [valuemapid] => 58 [name] => IMM-MIB::systemHealthStat ) [53] => Array ( [valuemapid] => 47 [name] => JUNIPER-ALARM-MIB::jnxOperatingState ) [54] => Array ( [valuemapid] => 46 [name] => JUNIPER-ALARM-MIB::jnxRedAlarmState ) [55] => Array ( [valuemapid] => 14 [name] => Maintenance status ) [56] => Array ( [valuemapid] => 59 [name] => Mikrotik DHCP ) [57] => Array ( [valuemapid] => 81 [name] => MRO-Tek-MIB::sysFanSpeed ) [58] => Array ( [valuemapid] => 80 [name] => MRO-Tek-MIB::sysFanStatus ) [59] => Array ( [valuemapid] => 32 [name] => MY-SYSTEM-MIB::mySystemFanIsNormal ) [60] => Array ( [valuemapid] => 52 [name] => QTECH-MIB::sysFanStatus ) [61] => Array ( [valuemapid] => 53 [name] => QTECH-MIB::sysPowerStatus ) [62] => Array ( [valuemapid] => 1 [name] => Service state ) [63] => Array ( [valuemapid] => 9 [name] => SNMP device status (hrDeviceStatus) ) [64] => Array ( [valuemapid] => 11 [name] => SNMP interface status (ifAdminStatus) ) [65] => Array ( [valuemapid] => 8 [name] => SNMP interface status (ifOperStatus) ) [66] => Array ( [valuemapid] => 77 [name] => SW-MIB::swAdmStatus.0 ) [67] => Array ( [valuemapid] => 25 [name] => SW-MIB::swOperStatus ) [68] => Array ( [valuemapid] => 78 [name] => SW-MIB::swOperStatus.0 ) [69] => Array ( [valuemapid] => 24 [name] => SW-MIB::swSensorStatus ) [70] => Array ( [valuemapid] => 23 [name] => TIMETRA-CHASSIS-MIB::TmnxDeviceState ) [71] => Array ( [valuemapid] => 35 [name] => TruthValue ) [72] => Array ( [valuemapid] => 62 [name] => UPS Battery Status ) [73] => Array ( [valuemapid] => 63 [name] => UPS Output Source ) [74] => Array ( [valuemapid] => 15 [name] => Value cache operating mode ) [75] => Array ( [valuemapid] => 13 [name] => VMware status ) [76] => Array ( [valuemapid] => 12 [name] => VMware VirtualMachinePowerState ) [77] => Array ( [valuemapid] => 16 [name] => Windows service startup type ) [78] => Array ( [valuemapid] => 3 [name] => Windows service state ) [79] => Array ( [valuemapid] => 10 [name] => Zabbix agent ping status ) [80] => Array ( [valuemapid] => 22 [name] => zabbix.host.available ) ) 7. host.get [html.inc.php:237] 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] => 10582 ) [editable] => 1 [selectApplications] => count [selectItems] => count [selectTriggers] => count [selectGraphs] => count [selectDiscoveries] => count [selectHttpTests] => count ) Result: Array ( ) 8. template.get [html.inc.php:256] Parameters: Array ( [output] => Array ( [0] => templateid [1] => name [2] => flags ) [templateids] => Array ( [0] => 10582 ) [editable] => 1 [selectApplications] => count [selectItems] => count [selectTriggers] => count [selectGraphs] => count [selectScreens] => count [selectDiscoveries] => count [selectHttpTests] => count ) Result: Array ( [0] => Array ( [templateid] => 10582 [name] => dependent-item-mass-update [flags] => 0 [items] => 2 [discoveries] => 0 [triggers] => 0 [graphs] => 0 [httpTests] => 0 [applications] => 1 [screens] => 0 ) ) SQL (4.2E-5): SET NAMES utf8 items.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:63 SQL (0.000282): SHOW TABLES LIKE 'dbversion' items.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → MysqlDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/MysqlDbBackend.php:32 SQL (0.000168): SELECT dv.mandatory,dv.optional FROM dbversion dv items.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in include/classes/db/DbBackend.php:46 SQL (8.7E-5): SELECT NULL FROM config c items.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkConfig() → DBselect() in include/classes/db/DbBackend.php:62 SQL (0.000508): BEGIN items.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:234 SQL (0.000317): SELECT sessionid,userid,lastaccess FROM sessions WHERE sessionid='6c069f97a0cb910e3c3ce9daf67fc2a0' AND status=0 items.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() → DB::select() → DBselect() in include/classes/db/DB.php:918 SQL (0.000129): SELECT userid,alias,name,surname,url,autologin,autologout,lang,refresh,type,theme,attempt_failed,attempt_ip,attempt_clock,rows_per_page FROM users WHERE userid=1 items.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() → DB::select() → DBselect() in include/classes/db/DB.php:918 SQL (0.000189): SELECT g.debug_mode,g.users_status,g.gui_access FROM usrgrp g,users_groups ug WHERE g.usrgrpid=ug.usrgrpid AND ug.userid=1 items.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->getUserGroupsData() → DBselect() in include/classes/api/services/CUser.php:1576 SQL (0.000134): UPDATE sessions SET lastaccess='1526973751' WHERE sessionid='6c069f97a0cb910e3c3ce9daf67fc2a0' items.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() → DB::update() → DBexecute() in include/classes/db/DB.php:573 SQL (0.000656): COMMIT items.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:291 SQL (0.000187): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.menu.config.last' items.php:32 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000181): SELECT c.* FROM config c items.php:32 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33 SQL (0.000171): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.login.attempt.failed' items.php:32 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (8.2E-5): BEGIN items.php:225 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234 SQL (0.000145): SELECT h.hostid,h.status FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10582' AND h.status IN (0,1,3) items.php:225 → 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:429 SQL (4.0E-5): COMMIT items.php:225 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291 SQL (0.00015): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_groupid' items.php:340 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000142): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_hostid' items.php:341 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000184): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_application' items.php:342 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000133): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_name' items.php:343 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000168): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_type' items.php:344 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000134): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_key' items.php:345 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000133): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_snmp_community' items.php:346 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000154): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_snmpv3_securityname' items.php:347 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000133): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_snmp_oid' items.php:348 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000146): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_port' items.php:349 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000137): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_value_type' items.php:350 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000133): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_delay' items.php:351 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000132): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_history' items.php:352 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000152): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_trends' items.php:353 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000132): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_status' items.php:354 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000131): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_state' items.php:355 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000143): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_templated_items' items.php:356 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000128): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_with_triggers' items.php:357 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000148): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.filter_ipmi_sensor' items.php:358 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000145): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_apps' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000129): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_types' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000129): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_value_types' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000129): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_status' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000128): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_state' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000148): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_templated_items' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000133): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_with_triggers' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000136): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_hosts' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000133): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_interval' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000132): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_history' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (0.000153): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.items.subfilter_trends' items.php:368 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165 SQL (5.7E-5): BEGIN items.php:830 → DBstart() → DBexecute() in include/db.inc.php:234 SQL (0.00015): SELECT i.itemid,i.flags,i.type FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.itemid='79987' items.php:897 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000223): SELECT i.itemid,i.templateid,i.type,i.snmp_community,i.snmp_oid,i.hostid,i.name,i.description,i.key_,i.master_itemid,i.delay,i.history,i.trends,i.status,i.value_type,i.trapper_hosts,i.units,i.snmpv3_contextname,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authprotocol,i.snmpv3_authpassphrase,i.snmpv3_privprotocol,i.snmpv3_privpassphrase,i.formula,i.logtimefmt,i.valuemapid,i.params,i.ipmi_sensor,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.port,i.inventory_link,i.lifetime,i.jmx_endpoint FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.itemid='79987' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000124): SELECT h.hostid,h.status,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10582' AND h.status IN (0,1,3) items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:429 SQL (0.000158): SELECT a.applicationid,a.flags,a.hostid FROM applications a WHERE a.hostid='10582' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApplication->get() → DBselect() in include/classes/api/services/CApplication.php:204 SQL (0.000126): SELECT hi.interfaceid,hi.hostid,hi.type FROM interface hi WHERE hi.hostid='10582' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:155 SQL (0.000179): SELECT i.key_,h.host FROM items i,hosts h WHERE i.hostid=h.hostid AND ((i.hostid='10582' AND i.key_='first.dependent.item')) AND i.itemid!='79987' LIMIT 1 items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CItemGeneral->checkExistingItems() → DBselect() in include/classes/api/services/CItemGeneral.php:1389 SQL (0.000139): SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND h.hostid='10582' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:256 SQL (0.000122): SELECT t.hosttemplateid,t.templateid,t.hostid FROM hosts_templates t WHERE t.templateid='10582' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CTemplate->get() → CTemplate->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318 SQL (0.000118): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10583' AND h.status IN (0,1) items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CTemplate->get() → CTemplate->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:429 SQL (0.000192): SELECT i.itemid,i.type,i.key_,i.master_itemid,i.hostid FROM items i WHERE i.flags IN (0,4) AND i.hostid IN ('10582','10583') items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->checkInput() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000137): SELECT i.itemid,i.type,i.name,i.hostid,i.master_itemid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.itemid='79987' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->validateDependentItems() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000126): SELECT i.itemid,i.type,i.name,i.hostid,i.master_itemid FROM items i WHERE i.flags IN (0,4) AND i.itemid='79986' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->validateDependentItems() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000143): SELECT i.itemid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.master_itemid='79986' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->validateDependentItems() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000142): SELECT i.itemid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.master_itemid='79987' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItemGeneral->validateDependentItems() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000148): UPDATE items SET itemid='79987',description='asdf',hostid='10582',type='18',name='first item',key_='first.dependent.item',delay='0',trends='0' WHERE itemid='79987' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->updateReal() → DB::update() → DBexecute() in include/classes/db/DB.php:573 SQL (0.000251): SELECT DISTINCT h.hostid,h.host,h.status FROM hosts h,hosts_templates ht WHERE h.flags IN (0,4) AND ht.templateid='10582' AND h.hostid=ht.hostid AND h.status IN (0,1,3) items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:429 SQL (0.000129): SELECT t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='10583' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318 SQL (0.000128): SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND h.hostid='10582' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:256 SQL (0.000148): SELECT hi.interfaceid,hi.main,hi.type,hi.hostid FROM interface hi WHERE hi.hostid='10583' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:155 SQL (0.000184): SELECT i.itemid,i.hostid,i.type,i.key_,i.flags,i.templateid,i.master_itemid FROM items i WHERE i.templateid='79987' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->prepareInheritedItems() → DBselect() in include/classes/api/services/CItemGeneral.php:838 SQL (0.000136): UPDATE items SET itemid='79990',description='asdf',hostid='10583',type='18',name='first item',key_='first.dependent.item',delay='0',trends='0',templateid='79987' WHERE itemid='79990' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItem->updateReal() → DB::update() → DBexecute() in include/classes/db/DB.php:573 SQL (5.9E-5): SELECT itemid,key_,hostid FROM items WHERE itemid= items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->inheritDependentItems() → DB::select() → DBselect() in include/classes/db/DB.php:918 SQL (0.000133): SELECT itemid FROM items WHERE hostid=10583 items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->inheritDependentItems() → DB::select() → DBselect() in include/classes/db/DB.php:918 SQL (0.000144): UPDATE items SET master_itemid='79990' WHERE itemid='79990' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → CItemGeneral->inheritDependentItems() → DB::update() → DBexecute() in include/classes/db/DB.php:573 SQL (0.000137): SELECT i.itemid FROM items i,hosts h WHERE i.hostid=h.hostid AND i.itemid='79990' AND h.status='3' items.php:999 → CFrontendApiWrapper->update() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->update() → CItem->inherit() → DBselect() in include/classes/api/services/CItem.php:776 SQL (0.000815): ROLLBACK items.php:1006 → DBend() → DBrollback() → DBexecute() in include/db.inc.php:316 SQL (4.1E-5): BEGIN items.php:1300 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234 SQL (0.000159): SELECT DISTINCT h.hostid FROM hosts h,items i WHERE h.flags IN (0,4) AND i.itemid='79987' AND h.hostid=i.hostid AND h.status IN (0,1) items.php:1300 → 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:429 SQL (3.9E-5): COMMIT items.php:1300 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291 SQL (4.6E-5): BEGIN items.php:1312 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234 SQL (0.000134): SELECT DISTINCT h.hostid,h.templateid FROM hosts h,items i WHERE h.status=3 AND i.itemid='79987' AND h.hostid=i.hostid items.php:1312 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:256 SQL (4.0E-5): COMMIT items.php:1312 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291 SQL (4.2E-5): BEGIN items.php:1367 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234 SQL (0.000157): SELECT vm.valuemapid,vm.name FROM valuemaps vm items.php:1367 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CValueMap->get() → DBselect() in include/classes/api/services/CValueMap.php:60 SQL (5.5E-5): COMMIT items.php:1367 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291 SQL (4.3E-5): BEGIN items.php:1378 → 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:234 SQL (0.000146): 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='10582' AND h.status IN (0,1) items.php:1378 → 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:429 SQL (3.9E-5): COMMIT items.php:1378 → 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:291 SQL (3.5E-5): BEGIN items.php:1378 → 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:234 SQL (0.000127): SELECT h.hostid,h.templateid,h.name,h.flags FROM hosts h WHERE h.status=3 AND h.hostid='10582' items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:256 SQL (0.000204): 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='10582' GROUP BY i.hostid items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364 SQL (0.000196): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i WHERE i.flags=1 AND i.hostid='10582' GROUP BY i.hostid items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:223 SQL (0.00022): SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid='10582' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4') GROUP BY i.hostid items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTrigger->get() → DBselect() in include/classes/api/services/CTrigger.php:423 SQL (0.000216): SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid='10582' AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:290 SQL (0.000157): SELECT COUNT(DISTINCT ht.httptestid) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid='10582' GROUP BY ht.hostid items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHttpTest->get() → DBselect() in include/classes/api/services/CHttpTest.php:202 SQL (0.000168): SELECT COUNT(DISTINCT a.applicationid) AS rowscount,a.hostid FROM applications a WHERE a.hostid='10582' GROUP BY a.hostid items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApplication->get() → DBselect() in include/classes/api/services/CApplication.php:204 SQL (0.000131): SELECT ht.* FROM hosts_templates ht WHERE hostid='10582' items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:170 SQL (0.000148): SELECT COUNT(DISTINCT s.screenid) AS rowscount,s.templateid FROM screens s WHERE s.templateid IS NOT NULL AND s.templateid='10582' GROUP BY s.templateid items.php:1378 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → CTemplate->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:203 SQL (6.5E-5): COMMIT items.php:1378 → 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:291 SQL (0.000309): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.lastpage' items.php:1788 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165