******************** Script profiler ********************
Total time: 0.085097
Total SQL time: 0.018344
SQL count: 83 (selects: 60 | executes: 32)
Peak memory usage: 8M
Memory limit: 128M

1. host.get [hosts.php:154]

Parameters:
Array
(
    [output] => Array
        (
        )

    [hostids] => 10417
    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [hostid] => 10417
        )

)

2. host.delete [hosts.php:823]

Parameters:
Array
(
    [0] => 10417
)
Result:

3. hostgroup.get [CPageFilter.php:371]

Parameters:
Array
(
    [output] => Array
        (
            [0] => groupid
            [1] => name
        )

    [preservekeys] => 1
    [real_hosts] => 1
    [editable] => 1
)
Result:
Array
(
    [32] => Array
        (
            [groupid] => 32
            [name] => ASUTP
        )

    [28] => Array
        (
            [groupid] => 28
            [name] => Database servers/SQL Server
        )

    [5] => Array
        (
            [groupid] => 5
            [name] => Discovered hosts
        )

    [40] => Array
        (
            [groupid] => 40
            [name] => Hardware
        )

    [7] => Array
        (
            [groupid] => 7
            [name] => Hypervisors
        )

    [31] => Array
        (
            [groupid] => 31
            [name] => Hypervisors/Clusters
        )

    [30] => Array
        (
            [groupid] => 30
            [name] => Hypervisors/Hosts
        )

    [2] => Array
        (
            [groupid] => 2
            [name] => Linux servers
        )

    [35] => Array
        (
            [groupid] => 35
            [name] => Mail servers
        )

    [36] => Array
        (
            [groupid] => 36
            [name] => Mail servers/Exchange
        )

    [24] => Array
        (
            [groupid] => 24
            [name] => Storages
        )

    [26] => Array
        (
            [groupid] => 26
            [name] => Terminal servers
        )

    [22] => Array
        (
            [groupid] => 22
            [name] => Web servers
        )

    [20] => Array
        (
            [groupid] => 20
            [name] => Windows hosts
        )

    [4] => Array
        (
            [groupid] => 4
            [name] => Zabbix servers
        )

    [37] => Array
        (
            [groupid] => 37
            [name] => АСОПРР
        )

    [38] => Array
        (
            [groupid] => 38
            [name] => ИАС ОРЭМ
        )

    [34] => Array
        (
            [groupid] => 34
            [name] => Инфраменеджер
        )

    [39] => Array
        (
            [groupid] => 39
            [name] => СЭД "Дело"
        )

)

4. hostgroup.get [hostgroups.inc.php:357]

Parameters:
Array
(
    [output] => Array
        (
            [0] => groupid
            [1] => name
        )

    [filter] => Array
        (
            [name] => Array
                (
                    [0] => Database servers
                )

        )

    [preservekeys] => 1
)
Result:
Array
(
    [27] => Array
        (
            [groupid] => 27
            [name] => Database servers
        )

)

5. host.get [hosts.php:1023]

Parameters:
Array
(
    [output] => Array
        (
            [0] => hostid
            [1] => proxy_hostid
            [2] => host
            [3] => name
            [4] => status
            [5] => ipmi_authtype
            [6] => ipmi_privilege
            [7] => ipmi_username
            [8] => ipmi_password
            [9] => flags
            [10] => description
            [11] => tls_connect
            [12] => tls_accept
            [13] => tls_issuer
            [14] => tls_subject
            [15] => tls_psk_identity
            [16] => tls_psk
            [17] => inventory_mode
        )

    [selectGroups] => Array
        (
            [0] => groupid
        )

    [selectParentTemplates] => Array
        (
            [0] => templateid
        )

    [selectMacros] => Array
        (
            [0] => hostmacroid
            [1] => macro
            [2] => value
            [3] => description
        )

    [selectDiscoveryRule] => Array
        (
            [0] => itemid
            [1] => name
        )

    [selectHostDiscovery] => Array
        (
            [0] => parent_hostid
        )

    [selectInventory] => extend
    [selectTags] => Array
        (
            [0] => tag
            [1] => value
        )

    [hostids] => Array
        (
            [0] => 10417
        )

)
Result:
Array
(
    [0] => Array
        (
            [hostid] => 10417
            [proxy_hostid] => 0
            [host] => sr-hq-003
            [name] => sr-hq-003
            [status] => 1
            [ipmi_authtype] => -1
            [ipmi_privilege] => 2
            [ipmi_username] => 
            [ipmi_password] => 
            [flags] => 0
            [description] => 
            [tls_connect] => 1
            [tls_accept] => 1
            [tls_issuer] => 
            [tls_subject] => 
            [tls_psk_identity] => 
            [tls_psk] => 
            [inventory_mode] => -1
            [groups] => Array
                (
                    [0] => Array
                        (
                            [groupid] => 2
                        )

                )

            [parentTemplates] => Array
                (
                )

            [macros] => Array
                (
                )

            [tags] => Array
                (
                )

            [inventory] => Array
                (
                )

            [discoveryRule] => Array
                (
                )

            [hostDiscovery] => Array
                (
                )

        )

)

6. hostinterface.get [hosts.php:1040]

Parameters:
Array
(
    [output] => Array
        (
            [0] => interfaceid
            [1] => main
            [2] => type
            [3] => useip
            [4] => ip
            [5] => dns
            [6] => port
            [7] => bulk
        )

    [selectItems] => Array
        (
            [0] => type
        )

    [hostids] => Array
        (
            [0] => 10417
        )

    [sortfield] => interfaceid
)
Result:
Array
(
    [0] => Array
        (
            [interfaceid] => 139
            [main] => 1
            [type] => 1
            [useip] => 1
            [ip] => 192.168.255.3
            [dns] => 
            [port] => 10050
            [bulk] => 1
            [items] => Array
                (
                    [0] => Array
                        (
                            [type] => 0
                        )

                )

        )

)

7. item.get [hosts.php:1147]

Parameters:
Array
(
    [output] => Array
        (
            [0] => inventory_link
            [1] => itemid
            [2] => hostid
            [3] => name
            [4] => key_
        )

    [hostids] => Array
        (
            [0] => 10417
        )

    [filter] => Array
        (
            [inventory_link] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                    [3] => 4
                    [4] => 5
                    [5] => 6
                    [6] => 7
                    [7] => 8
                    [8] => 9
                    [9] => 10
                    [10] => 11
                    [11] => 12
                    [12] => 13
                    [13] => 14
                    [14] => 15
                    [15] => 16
                    [16] => 17
                    [17] => 18
                    [18] => 19
                    [19] => 20
                    [20] => 21
                    [21] => 22
                    [22] => 23
                    [23] => 24
                    [24] => 25
                    [25] => 26
                    [26] => 27
                    [27] => 28
                    [28] => 29
                    [29] => 30
                    [30] => 31
                    [31] => 32
                    [32] => 33
                    [33] => 34
                    [34] => 35
                    [35] => 36
                    [36] => 37
                    [37] => 38
                    [38] => 39
                    [39] => 40
                    [40] => 41
                    [41] => 42
                    [42] => 43
                    [43] => 44
                    [44] => 45
                    [45] => 46
                    [46] => 47
                    [47] => 48
                    [48] => 49
                    [49] => 50
                    [50] => 51
                    [51] => 52
                    [52] => 53
                    [53] => 54
                    [54] => 55
                    [55] => 56
                    [56] => 57
                    [57] => 58
                    [58] => 59
                    [59] => 60
                    [60] => 61
                    [61] => 62
                    [62] => 63
                    [63] => 64
                    [64] => 65
                    [65] => 66
                    [66] => 67
                    [67] => 68
                    [68] => 69
                    [69] => 70
                )

        )

)
Result:
Array
(
)

8. proxy.get [hosts.php:1167]

Parameters:
Array
(
    [output] => Array
        (
            [0] => host
        )

    [preservekeys] => 1
)
Result:
Array
(
    [10399] => Array
        (
            [host] => zbx-kts-proxy
            [proxyid] => 10399
        )

    [10410] => Array
        (
            [host] => zbx-nkts-proxy
            [proxyid] => 10410
        )

    [10428] => Array
        (
            [host] => zbx-dmz-proxy
            [proxyid] => 10428
        )

)

9. hostgroup.get [hosts.php:1213]

Parameters:
Array
(
    [output] => Array
        (
            [0] => name
        )

    [groupids] => Array
        (
            [0] => 2
        )

    [preservekeys] => 1
)
Result:
Array
(
    [2] => Array
        (
            [groupid] => 2
            [name] => Linux servers
        )

)

10. host.get [html.inc.php:229]

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] => 10417
        )

    [editable] => 1
    [selectApplications] => count
    [selectItems] => count
    [selectTriggers] => count
    [selectGraphs] => count
    [selectDiscoveries] => count
    [selectHttpTests] => count
)
Result:
Array
(
    [0] => Array
        (
            [hostid] => 10417
            [status] => 1
            [proxy_hostid] => 0
            [name] => sr-hq-003
            [maintenance_status] => 0
            [flags] => 0
            [available] => 0
            [snmp_available] => 0
            [jmx_available] => 0
            [ipmi_available] => 0
            [error] => 
            [snmp_error] => 
            [jmx_error] => 
            [ipmi_error] => 
            [items] => 0
            [discoveries] => 0
            [triggers] => 0
            [graphs] => 0
            [httpTests] => 0
            [applications] => 0
            [hostDiscovery] => Array
                (
                )

        )

)


SQL (0.000101): COMMIT
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000331): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.menu.config.last'
hosts.php:30 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000311): SELECT c.* FROM config c
hosts.php:30 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33

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

SQL (7.1E-5): BEGIN
hosts.php:154 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000245): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10417 AND h.status IN (0,1)
hosts.php:154 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:470

SQL (8.1E-5): COMMIT
hosts.php:154 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000276): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter_ip'
hosts.php:212 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000267): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter_dns'
hosts.php:213 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000278): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter_host'
hosts.php:214 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000247): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter_templates'
hosts.php:215 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000265): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter_port'
hosts.php:216 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000272): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter_monitored_by'
hosts.php:217 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000246): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter_proxyids'
hosts.php:218 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000252): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter.evaltype'
hosts.php:219 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000244): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.hosts.filter.tags.tag'
hosts.php:223 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (6.3E-5): BEGIN
hosts.php:821 → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000232): SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10417 AND h.status IN (0,1)
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → CHost->validateDelete() → CHost->checkPermissions() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:470

SQL (0.000322): SELECT m.name FROM maintenances m WHERE NOT EXISTS (SELECT NULL FROM maintenances_hosts mh WHERE m.maintenanceid=mh.maintenanceid AND mh.hostid!=10417) AND NOT EXISTS (SELECT NULL FROM maintenances_groups mg WHERE m.maintenanceid=mg.maintenanceid)
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → CHost->validateDelete() → CHost->validateDeleteCheckMaintenances() → DBselect() in include/classes/api/services/CHost.php:1295

SQL (0.000259): SELECT i.itemid FROM items i WHERE i.flags=1 AND i.hostid=10417
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:251

SQL (0.000283): SELECT i.itemid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=10417
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392

SQL (0.000226): SELECT DISTINCT ht.* FROM httptest ht WHERE ht.hostid=10417
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → get_httptests_by_hostid() → DBselect() in include/httptest.inc.php:118

SQL (0.000353): DELETE FROM screens_items WHERE resourceid='10417' AND resourcetype='16'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.000181): DELETE FROM sysmaps_elements WHERE elementtype='0' AND elementid='10417'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.000221): SELECT DISTINCT actionid FROM conditions WHERE conditiontype=1 AND value='10417'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DBselect() in include/classes/api/services/CHost.php:1373

SQL (0.000246): SELECT DISTINCT o.actionid FROM operations o, opcommand_hst oh WHERE o.operationid=oh.operationid AND oh.hostid=10417
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DBselect() in include/classes/api/services/CHost.php:1383

SQL (0.000149): DELETE FROM conditions WHERE conditiontype='1' AND value='10417'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.000225): SELECT DISTINCT oh.operationid FROM opcommand_hst oh WHERE oh.hostid=10417
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DBselect() in include/classes/api/services/CHost.php:1408

SQL (0.000136): DELETE FROM opcommand_hst WHERE hostid='10417'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.000192): SELECT DISTINCT o.operationid FROM operations o WHERE 1=0 AND NOT EXISTS(SELECT oh.opcommand_hstid FROM opcommand_hst oh WHERE oh.operationid=o.operationid)
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DBselect() in include/classes/api/services/CHost.php:1423

SQL (0.000181): DELETE FROM operations WHERE 1=0
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.000211): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10417 AND h.status IN (0,1)
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:470

SQL (0.00016): DELETE FROM host_inventory WHERE hostid='10417'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.000198): DELETE FROM applications WHERE hostid='10417'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.001107): DELETE FROM hosts WHERE hostid='10417'
hosts.php:823 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.00016): ROLLBACK
hosts.php:824 → DBend() → DBrollback() → DBexecute() in include/db.inc.php:316

SQL (0.000309): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.config.groupid'
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000281): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.config.hostid'
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00026): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.config.graphid'
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (7.2E-5): BEGIN
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000829): SELECT g.groupid,g.name FROM hstgrp g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN (0,1) AND g.groupid=hg.groupid)
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:358

SQL (8.3E-5): COMMIT
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (6.6E-5): BEGIN
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_initGroups() → enrichParentGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000221): SELECT g.groupid,g.name FROM hstgrp g WHERE g.name='Database servers'
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_initGroups() → enrichParentGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:358

SQL (7.9E-5): COMMIT
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_initGroups() → enrichParentGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000286): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.latest.groupid'
hosts.php:896 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (8.3E-5): BEGIN
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.00029): SELECT DISTINCT h.hostid,h.proxy_hostid,h.host,h.name,h.status,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.flags,h.description,h.tls_connect,h.tls_accept,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk,COALESCE(hinv.inventory_mode,-1) AS inventory_mode FROM hosts h LEFT JOIN host_inventory hinv ON h.hostid=hinv.hostid WHERE h.flags IN (0,4) AND h.hostid=10417 AND h.status IN (0,1)
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:470

SQL (0.000206): SELECT t.hostgroupid,t.hostid,t.groupid FROM hosts_groups t WHERE t.hostid=10417
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:317

SQL (0.000173): SELECT g.groupid FROM hstgrp g WHERE g.groupid=2
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:358

SQL (0.000189): SELECT t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid=10417
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:317

SQL (0.000153): SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND 1=0
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:266

SQL (0.000214): SELECT hm.hostmacroid,hm.macro,hm.value,hm.description,hm.hostid FROM hostmacro hm WHERE hm.hostid=10417
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:211

SQL (0.000187): SELECT hosttagid,tag,value,hostid FROM host_tag WHERE hostid=10417
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CHostGeneral.php:957

SQL (0.000251): SELECT t.* FROM host_inventory t WHERE t.hostid=10417
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350

SQL (0.000185): SELECT hd.hostid,hd2.parent_itemid FROM host_discovery hd,host_discovery hd2 WHERE hd.hostid=10417 AND hd.parent_hostid=hd2.hostid
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → DBselect() in include/classes/api/services/CHost.php:1568

SQL (0.00024): SELECT i.itemid,i.name FROM items i WHERE i.flags=1 AND 1=0
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:251

SQL (0.000181): SELECT t.hostid,t.parent_hostid FROM host_discovery t WHERE t.hostid=10417
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350

SQL (9.6E-5): COMMIT
hosts.php:1023 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (7.1E-5): BEGIN
hosts.php:1040 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000247): SELECT hi.interfaceid,hi.main,hi.type,hi.useip,hi.ip,hi.dns,hi.port,hi.bulk FROM interface hi WHERE hi.hostid=10417 ORDER BY hi.interfaceid
hosts.php:1040 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:155

SQL (0.000247): SELECT i.itemid,i.type,i.interfaceid FROM items i WHERE i.type<>9 AND i.interfaceid=139
hosts.php:1040 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostInterface->get() → CHostInterface->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392

SQL (8.3E-5): COMMIT
hosts.php:1040 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (6.6E-5): BEGIN
hosts.php:1147 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000325): SELECT i.itemid,i.inventory_link,i.hostid,i.name,i.key_ FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=10417 AND i.inventory_link IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70)
hosts.php:1147 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392

SQL (7.9E-5): COMMIT
hosts.php:1147 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (7.2E-5): BEGIN
hosts.php:1167 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000259): SELECT h.hostid,h.host FROM hosts h WHERE h.status IN (5,6)
hosts.php:1167 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProxy->get() → DBselect() in include/classes/api/services/CProxy.php:124

SQL (8.0E-5): COMMIT
hosts.php:1167 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (6.6E-5): BEGIN
hosts.php:1213 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000167): SELECT g.groupid,g.name FROM hstgrp g WHERE g.groupid=2
hosts.php:1213 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:358

SQL (7.9E-5): COMMIT
hosts.php:1213 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (8.7E-5): BEGIN
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000236): 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=10417 AND h.status IN (0,1)
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:470

SQL (0.000305): SELECT DISTINCT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i LEFT JOIN item_rtdata ir ON ir.itemid=i.itemid WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=10417 GROUP BY i.hostid
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392

SQL (0.000303): SELECT DISTINCT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i LEFT JOIN item_rtdata ir ON ir.itemid=i.itemid WHERE i.flags=1 AND i.hostid=10417 GROUP BY i.hostid
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:251

SQL (0.000375): SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid=10417 AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN (0,4) GROUP BY i.hostid
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTrigger->get() → DBselect() in include/classes/api/services/CTrigger.php:452

SQL (0.000343): SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid=10417 AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN (0,4) GROUP BY i.hostid
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:290

SQL (0.000251): SELECT COUNT(DISTINCT ht.httptestid) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid=10417 GROUP BY ht.hostid
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHttpTest->get() → DBselect() in include/classes/api/services/CHttpTest.php:202

SQL (0.000259): SELECT COUNT(DISTINCT a.applicationid) AS rowscount,a.hostid FROM applications a WHERE a.hostid=10417 GROUP BY a.hostid
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApplication->get() → DBselect() in include/classes/api/services/CApplication.php:204

SQL (0.000165): SELECT t.hostid,t.ts_delete FROM host_discovery t WHERE t.hostid=10417
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350

SQL (9.5E-5): COMMIT
hosts.php:1452 → CView->render() → include() → get_header_host_table() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

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