******************** 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