Help|Get support|Print|Profile|Debug|Logout
Monitoring	Inventory	Reports	Configuration	Administration
Host groups  |  Templates  |  Hosts  |  Maintenance  |  Actions  |  Screens  |  Slide shows  |  Maps  |  Discovery  |  IT services

History:	 Configuration of hosts » Custom graphs » Dashboard » Configuration of user groups » Configuration of hosts
Details
	ERROR: Cannot add host

    Created: Application "CPU" on "example_host".
    Created: Application "Filesystems" on "example_host".
    Created: Application "General" on "example_host".
    Created: Application "Memory" on "example_host".
    Created: Application "Network interfaces" on "example_host".
    Created: Application "OS" on "example_host".
    Created: Application "Performance" on "example_host".
    Created: Application "Processes" on "example_host".
    Created: Application "Zabbix agent" on "example_host".
    Created: Discovery rule "Network interface discovery" on "example_host".
    Created: Discovery rule "Mounted filesystem discovery" on "example_host".
    Undefined offset: 23169 [hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:624]
    Undefined offset: 23170 [hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:624]
    Undefined offset: 23164 [hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:624]
    Undefined offset: 23165 [hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:624]
    Undefined offset: 23167 [hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:624]
    Undefined offset: 23168 [hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:624]
    Field "parent_itemid" cannot be set to NULL. [hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DB::checkValueTypes() → DB::exception() in /var/www/zabbix/include/classes/db/DB.php:323]

CONFIGURATION OF HOSTS


    Host
    Templates
    IPMI
    Macros
    Host inventory

    Linked templates
    Name	Action
    Template OS Windows


Link new templates


******************** Script profiler ********************
Total time: 0.07421
Total SQL time: 0.029262
SQL count: 120 (selects: 76 | executes: 44)
Peak memory usage: 6.75M
Memory limit: 128M

1. hostgroup.isWritable [hosts.php:119]
Parameters:

Array
(
    [0] => 17
)

	Result:

1

2. host.create [hosts.php:504]
Parameters:

Array
(
    [host] => example_host
    [name] =>
    [status] => 0
    [description] =>
    [proxy_hostid] => 0
    [ipmi_authtype] => -1
    [ipmi_privilege] => 2
    [ipmi_username] =>
    [ipmi_password] =>
    [groups] => Array
        (
            [0] => Array
                (
                    [groupid] => 17
                )

        )

    [templates] => Array
        (
            [0] => Array
                (
                    [templateid] => 10081
                )

        )

    [interfaces] => Array
        (
            [1] => Array
                (
                    [type] => 1
                    [ip] => 127.0.0.1
                    [dns] =>
                    [useip] => 1
                    [port] => 10050
                    [bulk] => 1
                    [main] => 1
                )

        )

    [macros] => Array
        (
        )

    [inventory_mode] => -1
    [inventory] => Array
        (
        )

)

	Result:

3. hostgroup.get [CPageFilter.php:390]
Parameters:

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

    [preservekeys] => 1
    [sortfield] => Array
        (
            [0] => name
        )

    [real_hosts] => 1
    [editable] => 1
)

	Result:

Array
(
    [22] => Array
        (
            [groupid] => 22
            [name] => <redacted>
        )

    [23] => Array
        (
            [groupid] => 23
            [name] => <redacted>
        )

    [13] => Array
        (
            [groupid] => 13
            [name] => <redacted>
        )

    [10] => Array
        (
            [groupid] => 10
            [name] => <redacted>
        )

    [11] => Array
        (
            [groupid] => 11
            [name] => <redacted>
        )

    [12] => Array
        (
            [groupid] => 12
            [name] => <redacted>
        )

    [21] => Array
        (
            [groupid] => 21
            [name] => <redacted>
        )

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

    [14] => Array
        (
            [groupid] => 14
            [name] => <redacted>
        )

    [15] => Array
        (
            [groupid] => 15
            [name] => PROXMOX-Guests
        )

    [16] => Array
        (
            [groupid] => 16
            [name] => PROXMOX-Nodes
        )

    [9] => Array
        (
            [groupid] => 9
            [name] => RouterBoards
        )

    [24] => Array
        (
            [groupid] => 24
            [name] => <redacted>
        )

    [19] => Array
        (
            [groupid] => 19
            [name] => <redacted>
        )

    [20] => Array
        (
            [groupid] => 20
            [name] => WLAN Access Points
        )

    [17] => Array
        (
            [groupid] => 17
            [name] => Windows Servers
        )

    [18] => Array
        (
            [groupid] => 18
            [name] => Zabbix Proxies
        )

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

)

4. hostgroup.get [configuration.host.edit.php:211]
Parameters:

Array
(
    [editable] => 1
    [output] => extend
    [preservekeys] => 1
)

	Result:

Array
(
    [1] => Array
        (
            [groupid] => 1
            [name] => Templates
            [internal] => 0
            [flags] => 0
        )

    [2] => Array
        (
            [groupid] => 2
            [name] => Linux Servers
            [internal] => 0
            [flags] => 0
        )

    [4] => Array
        (
            [groupid] => 4
            [name] => Zabbix Servers
            [internal] => 0
            [flags] => 0
        )

    [5] => Array
        (
            [groupid] => 5
            [name] => Discovered hosts
            [internal] => 1
            [flags] => 0
        )

    [6] => Array
        (
            [groupid] => 6
            [name] => Virtual machines
            [internal] => 0
            [flags] => 0
        )

    [7] => Array
        (
            [groupid] => 7
            [name] => Hypervisors
            [internal] => 0
            [flags] => 0
        )

    [8] => Array
        (
            [groupid] => 8
            [name] => ESXi
            [internal] => 0
            [flags] => 0
        )

    [9] => Array
        (
            [groupid] => 9
            [name] => RouterBoards
            [internal] => 0
            [flags] => 0
        )

    [10] => Array
        (
            [groupid] => 10
            [name] => Hetzner Servers
            [internal] => 0
            [flags] => 0
        )

    [11] => Array
        (
            [groupid] => 11
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [12] => Array
        (
            [groupid] => 12
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [13] => Array
        (
            [groupid] => 13
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [14] => Array
        (
            [groupid] => 14
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [15] => Array
        (
            [groupid] => 15
            [name] => PROXMOX-Guests
            [internal] => 0
            [flags] => 0
        )

    [16] => Array
        (
            [groupid] => 16
            [name] => PROXMOX-Nodes
            [internal] => 0
            [flags] => 0
        )

    [17] => Array
        (
            [groupid] => 17
            [name] => Windows Servers
            [internal] => 0
            [flags] => 0
        )

    [18] => Array
        (
            [groupid] => 18
            [name] => Zabbix Proxies
            [internal] => 0
            [flags] => 0
        )

    [19] => Array
        (
            [groupid] => 19
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [20] => Array
        (
            [groupid] => 20
            [name] => WLAN Access Points
            [internal] => 0
            [flags] => 0
        )

    [21] => Array
        (
            [groupid] => 21
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [22] => Array
        (
            [groupid] => 22
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [23] => Array
        (
            [groupid] => 23
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

    [24] => Array
        (
            [groupid] => 24
            [name] => <redacted>
            [internal] => 0
            [flags] => 0
        )

)

5. proxy.get [configuration.host.edit.php:439]
Parameters:

Array
(
    [output] => extend
)

	Result:

Array
(
    [0] => Array
        (
            [proxy_hostid] => 0
            [host] => <redacted>
            [status] => 5
            [disable_until] => 0
            [error] =>
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 1445438176
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] =>
            [ipmi_password] =>
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] =>
            [snmp_error] =>
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] =>
            [name] =>
            [flags] => 0
            [templateid] => 0
            [description] =>
            [proxyid] => 10105
        )

    [1] => Array
        (
            [proxy_hostid] => 0
            [host] => <redacted>
            [status] => 5
            [disable_until] => 0
            [error] =>
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 1449045861
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] =>
            [ipmi_password] =>
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] =>
            [snmp_error] =>
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] =>
            [name] =>
            [flags] => 0
            [templateid] => 0
            [description] =>
            [proxyid] => 10106
        )

    [2] => Array
        (
            [proxy_hostid] => 0
            [host] => <redacted>
            [status] => 5
            [disable_until] => 0
            [error] =>
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 1449045860
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] =>
            [ipmi_password] =>
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] =>
            [snmp_error] =>
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] =>
            [name] =>
            [flags] => 0
            [templateid] => 0
            [description] =>
            [proxyid] => 10114
        )

    [3] => Array
        (
            [proxy_hostid] => 0
            [host] => <redacted>
            [status] => 5
            [disable_until] => 0
            [error] =>
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 0
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] =>
            [ipmi_password] =>
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] =>
            [snmp_error] =>
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] =>
            [name] =>
            [flags] => 0
            [templateid] => 0
            [description] =>
            [proxyid] => 10184
        )

    [4] => Array
        (
            [proxy_hostid] => 0
            [host] => <redacted>
            [status] => 5
            [disable_until] => 0
            [error] =>
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 1449045847
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] =>
            [ipmi_password] =>
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] =>
            [snmp_error] =>
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] =>
            [name] =>
            [flags] => 0
            [templateid] => 0
            [description] =>
            [proxyid] => 10185
        )

    [5] => Array
        (
            [proxy_hostid] => 0
            [host] => <redacted>
            [status] => 5
            [disable_until] => 0
            [error] =>
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 1449045856
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] =>
            [ipmi_password] =>
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] =>
            [snmp_error] =>
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] =>
            [name] =>
            [flags] => 0
            [templateid] => 0
            [description] =>
            [proxyid] => 10188
        )

    [6] => Array
        (
            [proxy_hostid] => 0
            [host] => <redacted>
            [status] => 5
            [disable_until] => 0
            [error] =>
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 1449045840
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] =>
            [ipmi_password] =>
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] =>
            [snmp_error] =>
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] =>
            [name] =>
            [flags] => 0
            [templateid] => 0
            [description] =>
            [proxyid] => 10193
        )

)

6. template.get [configuration.host.edit.php:721]
Parameters:

Array
(
    [templateids] => Array
        (
            [0] => 10081
        )

    [output] => Array
        (
            [0] => templateid
            [1] => name
        )

)

	Result:

Array
(
    [0] => Array
        (
            [templateid] => 10081
            [name] => Template OS Windows
        )

)


SQL (9.0E-5): SET NAMES utf8
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in /var/www/zabbix/include/db.inc.php:61


SQL (0.000325): SHOW TABLES LIKE 'dbversion'
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → MysqlDbBackend->checkDbVersionTable() → DBselect() in /var/www/zabbix/include/classes/db/MysqlDbBackend.php:32


SQL (7.5E-5): SELECT dv.mandatory,dv.optional FROM dbversion dv
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in /var/www/zabbix/include/classes/db/DbBackend.php:46


SQL (6.5E-5): BEGIN
hosts.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 /var/www/zabbix/include/db.inc.php:248


SQL (0.000253): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='554c7cd780e7926b6e35cb0d2ff56edc' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1449045863 OR u.autologout=0)
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in /var/www/zabbix/include/classes/api/services/CUser.php:1116


SQL (7.0E-5): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid='4' AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → check_perm2system() → DBselect() in /var/www/zabbix/include/perm.inc.php:75


SQL (0.000254): UPDATE sessions SET lastaccess=1449045863 WHERE userid='4' AND sessionid='554c7cd780e7926b6e35cb0d2ff56edc'
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBexecute() in /var/www/zabbix/include/classes/api/services/CUser.php:1141


SQL (6.8E-5): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='4' AND g.usrgrpid=ug.usrgrpid
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in /var/www/zabbix/include/classes/api/services/CUser.php:1149


SQL (6.9E-5): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid='4'
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in /var/www/zabbix/include/classes/api/services/CUser.php:1173


SQL (6.1E-5): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='4' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in /var/www/zabbix/include/classes/api/services/CUser.php:1181


SQL (0.000688): COMMIT
hosts.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 /var/www/zabbix/include/db.inc.php:309


SQL (0.00016): SELECT p.* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
hosts.php:41 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::init() → DBselect() in /var/www/zabbix/include/classes/user/CProfile.php:42


SQL (9.2E-5): SELECT c.* FROM config c
hosts.php:41 → require_once() → select_config() → DBselect() in /var/www/zabbix/include/profiles.inc.php:31


SQL (0.000111): SELECT uh.title1,uh.url1,uh.title2,uh.url2,uh.title3,uh.url3,uh.title4,uh.url4,uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=4
hosts.php:41 → require_once() → get_user_history() → DBselect() in /var/www/zabbix/include/profiles.inc.php:157


SQL (8.3E-5): BEGIN
hosts.php:119 → CFrontendApiWrapper->isWritable() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /var/www/zabbix/include/db.inc.php:248


SQL (0.000103): SELECT COUNT(DISTINCT g.groupid) AS rowscount FROM groups g WHERE g.groupid='17'
hosts.php:119 → CFrontendApiWrapper->isWritable() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->isWritable() → CHostGroup->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostGroup.php:337


SQL (7.0E-5): COMMIT
hosts.php:119 → CFrontendApiWrapper->isWritable() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /var/www/zabbix/include/db.inc.php:309


SQL (6.4E-5): BEGIN
hosts.php:373 → DBstart() → DBexecute() in /var/www/zabbix/include/db.inc.php:248


SQL (0.000203): SELECT g.* FROM groups g WHERE g.groupid='17'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->checkInput() → CHostGroup->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostGroup.php:337


SQL (0.000331): SELECT h.hostid,h.host,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.status IN (0,1) AND (h.host='example_host' OR h.name='example_host')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->checkInput() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.00029): SELECT h.hostid,h.host,h.name FROM hosts h WHERE h.status=3 AND (h.host='example_host' OR h.name='example_host')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->checkInput() → CTemplate->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CTemplate.php:261


SQL (0.000152): SELECT nextid FROM ids WHERE table_name='hosts' AND field_name='hostid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000154): UPDATE ids SET nextid=10209 WHERE table_name='hosts' AND field_name='hostid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000446): INSERT INTO hosts (host,name,status,description,proxy_hostid,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,hostid) VALUES ('example_host','example_host','0','',NULL,'-1','2','','','10209')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000138): SELECT nextid FROM ids WHERE table_name='hosts_groups' AND field_name='hostgroupid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.00013): UPDATE ids SET nextid=234 WHERE table_name='hosts_groups' AND field_name='hostgroupid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000564): INSERT INTO hosts_groups (hostid,groupid,hostgroupid) VALUES ('10209','17','234')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000333): SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10209' AND h.status IN (0,1,3)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHost->isWritable() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.00015): SELECT h.hostid,h.host FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10209' AND h.status IN (0,1)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostInterface->massAdd() → CHostInterface->create() → CHostInterface->checkInput() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000138): SELECT h.hostid,h.host FROM hosts h WHERE h.status IN (5,6) AND h.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostInterface->massAdd() → CHostInterface->create() → CHostInterface->checkInput() → CProxy->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CProxy.php:128


SQL (0.000149): SELECT h.hostid,h.host FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10209' AND h.status IN (0,1) AND h.flags='4' LIMIT 1 OFFSET 0
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostInterface->massAdd() → CHostInterface->create() → CHostInterface->checkInput() → CApiService->checkValidator() → CHostNormalValidator->validate() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000168): SELECT hi.interfaceid,hi.hostid,hi.main,hi.type FROM interface hi WHERE hi.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostInterface->massAdd() → CHostInterface->create() → CHostInterface->checkMainInterfacesOnCreate() → CHostInterface->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostInterface.php:160


SQL (0.000132): SELECT nextid FROM ids WHERE table_name='interface' AND field_name='interfaceid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostInterface->massAdd() → CHostInterface->create() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000133): UPDATE ids SET nextid=93 WHERE table_name='interface' AND field_name='interfaceid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostInterface->massAdd() → CHostInterface->create() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000319): INSERT INTO interface (type,ip,dns,useip,port,bulk,main,hostid,interfaceid) VALUES ('1','127.0.0.1','','1','10050','1','1','10209','93')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostInterface->massAdd() → CHostInterface->create() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000182): SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10209' AND h.status IN (0,1,3)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHost->isWritable() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000163): SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.status=3 AND h.hostid='10081'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → CTemplate->isReadable() → CTemplate->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CTemplate.php:261


SQL (0.000193): SELECT DISTINCT h.hostid,h.templateid FROM hosts h,hosts_templates ht WHERE h.status=3 AND ht.hostid='10209' AND h.hostid=ht.templateid
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → CTemplate->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CTemplate.php:261


SQL (0.000208): SELECT i.key_ FROM items i WHERE i.hostid='10081' GROUP BY i.key_ HAVING COUNT(i.itemid)>1
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostBase.php:77


SQL (0.000155): SELECT * FROM hosts_templates WHERE hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostBase.php:100


SQL (0.000891): SELECT DISTINCT t.* FROM triggers t,functions f,items i WHERE i.hostid='10081' AND f.itemid=i.itemid AND f.triggerid=t.triggerid
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → get_triggers_by_hostid() → DBselect() in /var/www/zabbix/include/triggers.inc.php:283


SQL (0.000297): SELECT DISTINCT h.host FROM trigger_depends td,functions f,items i,hosts h WHERE (td.triggerid_down IN ('13425','13428','13430','13431','13433','13435','13437','13438','13439','13516') AND f.triggerid=td.triggerid_up ) AND i.itemid=f.itemid AND h.hostid=i.hostid AND h.hostid!='10081' AND h.status=3
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostBase.php:135


SQL (0.00014): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10209' AND ht.templateid='10081'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostBase.php:152


SQL (0.000136): SELECT nextid FROM ids WHERE table_name='hosts_templates' AND field_name='hosttemplateid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000132): UPDATE ids SET nextid=186 WHERE table_name='hosts_templates' AND field_name='hosttemplateid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000194): INSERT INTO hosts_templates (hostid,templateid,hosttemplateid) VALUES ('10209','10081','186')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.00523): SELECT DISTINCT h.host FROM functions f,items i,triggers t,hosts h WHERE f.itemid=i.itemid AND f.triggerid=t.triggerid AND i.hostid=h.hostid AND h.status=3 AND NOT EXISTS (SELECT 1 FROM hosts_templates ht WHERE ht.templateid=i.hostid AND ht.hostid='10209') AND EXISTS (SELECT 1 FROM functions ff,items ii WHERE ff.itemid=ii.itemid AND ff.triggerid=t.triggerid AND ii.hostid='10081') LIMIT 1 OFFSET 0
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostBase.php:184


SQL (0.000409): SELECT ht.hostid,ht.templateid FROM hosts_templates ht,hosts h WHERE ht.hostid=h.hostid AND h.status IN(0,1,3)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CHostBase->link() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostBase.php:197


SQL (0.000181): SELECT a.applicationid,a.name,a.hostid FROM applications a WHERE a.hostid='10081'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → DBselect() in /var/www/zabbix/include/classes/api/managers/CApplicationManager.php:144


SQL (0.000181): SELECT ht.templateid,ht.hostid FROM hosts_templates ht WHERE ht.templateid='10081' AND ht.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->getChildHostsFromApplications() → DBselect() in /var/www/zabbix/include/classes/api/managers/CApplicationManager.php:403


SQL (0.000159): SELECT a.applicationid,a.name,a.hostid FROM applications a WHERE a.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->getApplicationMapsByHostIds() → DBselect() in /var/www/zabbix/include/classes/api/managers/CApplicationManager.php:537


SQL (0.000122): SELECT * FROM application_template at WHERE 1=0
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->getApplicationMapsByHostIds() → DBselect() in /var/www/zabbix/include/classes/api/managers/CApplicationManager.php:542


SQL (0.000158): SELECT nextid FROM ids WHERE table_name='applications' AND field_name='applicationid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->save() → CApplicationManager->create() → DB::insertBatch() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000163): UPDATE ids SET nextid=740 WHERE table_name='applications' AND field_name='applicationid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->save() → CApplicationManager->create() → DB::insertBatch() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000233): INSERT INTO applications (name,hostid,applicationid) VALUES ('CPU','10209','732'),('Filesystems','10209','733'),('General','10209','734'),('Memory','10209','735'),('Network interfaces','10209','736'),('OS','10209','737'),('Performance','10209','738'),('Processes','10209','739'),('Zabbix agent','10209','740')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->save() → CApplicationManager->create() → DB::insertBatch() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:487


SQL (0.000132): SELECT nextid FROM ids WHERE table_name='application_template' AND field_name='application_templateid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->save() → CApplicationManager->create() → DB::insertBatch() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000139): UPDATE ids SET nextid=323 WHERE table_name='application_template' AND field_name='application_templateid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->save() → CApplicationManager->create() → DB::insertBatch() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000219): INSERT INTO application_template (applicationid,templateid,application_templateid) VALUES ('732','325','315'),('733','322','316'),('734','319','317'),('735','328','318'),('736','330','319'),('737','323','320'),('738','320','321'),('739','324','322'),('740','329','323')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->save() → CApplicationManager->create() → DB::insertBatch() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:487


SQL (0.000185): SELECT a.name, h.name as hostname FROM applications a INNER JOIN hosts h ON h.hostid=a.hostid WHERE a.applicationid BETWEEN '732' AND '740'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->save() → CApplicationManager->create() → DBselect() in /var/www/zabbix/include/classes/api/managers/CApplicationManager.php:71


SQL (0.000136): SELECT ht.templateid,ht.hostid FROM hosts_templates ht WHERE ht.templateid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CApplicationManager->link() → CApplicationManager->inherit() → CApplicationManager->inherit() → CApplicationManager->getChildHostsFromApplications() → DBselect() in /var/www/zabbix/include/classes/api/managers/CApplicationManager.php:403


SQL (0.000334): SELECT i.itemid,i.type,i.snmp_community,i.snmp_oid,i.hostid,i.name,i.description,i.key_,i.delay,i.history,i.trends,i.status,i.value_type,i.trapper_hosts,i.units,i.multiplier,i.delta,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.delay_flex,i.params,i.ipmi_sensor,i.data_type,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.port,i.inventory_link,i.lifetime,i.evaltype FROM items i WHERE i.flags=1 AND i.hostid='10081'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CDiscoveryRule.php:222


SQL (0.000189): SELECT t.item_conditionid,t.macro,t.value,t.itemid,t.operator FROM item_condition t WHERE t.itemid IN ('23162','23163')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CApiService->select() → DBselect() in /var/www/zabbix/include/classes/api/CApiService.php:350


SQL (0.000173): SELECT DISTINCT h.hostid,h.host,h.status FROM hosts h,hosts_templates ht WHERE h.flags IN (0,4) AND h.hostid='10209' AND ht.templateid='10081' AND h.hostid=ht.hostid AND h.status IN (0,1,3)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000142): SELECT t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in /var/www/zabbix/include/classes/api/CApiService.php:318


SQL (0.000156): SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND h.hostid='10081'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CTemplate.php:261


SQL (0.000182): SELECT hi.* FROM interface hi WHERE hi.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostInterface->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostInterface.php:160


SQL (0.00032): SELECT i.itemid,i.type,i.key_,i.flags,i.templateid FROM items i WHERE i.type<>9 AND i.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CItemGeneral->prepareInheritedItems() → CItem->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CItem.php:355


SQL (0.000133): SELECT nextid FROM ids WHERE table_name='items' AND field_name='itemid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000129): UPDATE ids SET nextid=25018 WHERE table_name='items' AND field_name='itemid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000397): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,evaltype,itemid) VALUES ('0','','','10209','Network interface discovery','Discovery of network interfaces as defined in global regular expression \"Network interfaces for discovery\".','net.if.discovery','3600','90','365','0','4','','','0','0','','','0','0','','0','','',NULL,'','','','0','0','','','','','1','','0','30','93','23163','0','25017')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000209): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,evaltype,itemid) VALUES ('0','','','10209','Mounted filesystem discovery','Discovery of file systems of different types as defined in global regular expression \"File systems for discovery\".','vfs.fs.discovery','3600','90','365','0','4','','','0','0','','','0','0','','0','','',NULL,'','','','0','0','','','','','1','','0','30','93','23162','0','25018')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000128): SELECT nextid FROM ids WHERE table_name='item_condition' AND field_name='item_conditionid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000142): UPDATE ids SET nextid=56 WHERE table_name='item_condition' AND field_name='item_conditionid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000242): INSERT INTO item_condition (macro,value,operator,itemid,item_conditionid) VALUES ('{#IFNAME}','@Network interfaces for discovery','8','25017','55')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000113): INSERT INTO item_condition (macro,value,operator,itemid,item_conditionid) VALUES ('{#FSTYPE}','@File systems for discovery','8','25018','56')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → DB::save() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000235): SELECT i.itemid,i.key_,i.name,i.hostid FROM items i WHERE i.flags=1 AND i.itemid IN ('25017','25018')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → CDiscoveryRule->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CDiscoveryRule.php:222


SQL (0.000199): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10209' AND h.status IN (0,1,3)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->createReal() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000126): SELECT i.itemid,i.key_,i.name,i.evaltype,i.hostid FROM items i WHERE i.flags=1 AND 1=0
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->updateReal() → CDiscoveryRule->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CDiscoveryRule.php:222


SQL (0.000239): SELECT DISTINCT h.hostid,h.host,h.status FROM hosts h,hosts_templates ht WHERE h.flags IN (0,4) AND ht.templateid='10209' AND h.hostid=ht.hostid AND h.status IN (0,1,3)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CDiscoveryRule->syncTemplates() → CDiscoveryRule->inherit() → CDiscoveryRule->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000347): SELECT i.itemid,i.type,i.snmp_community,i.snmp_oid,i.hostid,i.name,i.description,i.key_,i.delay,i.history,i.trends,i.status,i.value_type,i.trapper_hosts,i.units,i.multiplier,i.delta,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.delay_flex,i.params,i.ipmi_sensor,i.data_type,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.port,i.inventory_link,i.lifetime FROM items i WHERE i.flags=2 AND i.hostid='10081'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:237


SQL (7.8E-5): SELECT t.itemappid,t.itemid,t.applicationid FROM items_applications t WHERE t.itemid IN ('23164','23165','23167','23168','23169','23170')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->get() → CItemPrototype->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in /var/www/zabbix/include/classes/api/CApiService.php:318


SQL (0.00015): SELECT a.applicationid FROM applications a WHERE a.applicationid IN ('322','330')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->get() → CItemPrototype->addRelatedObjects() → CApplication->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CApplication.php:212


SQL (0.000181): SELECT i.itemid AS ruleid,id.itemid,i.hostid FROM items i,item_discovery id WHERE i.templateid=id.parent_itemid AND id.itemid IN ('23164','23165','23167','23168','23169','23170')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → DBselect() in /var/www/zabbix/include/classes/api/services/CItemPrototype.php:601


SQL (0.000171): SELECT DISTINCT h.hostid,h.host,h.status FROM hosts h,hosts_templates ht WHERE h.flags IN (0,4) AND h.hostid='10209' AND ht.templateid='10081' AND h.hostid=ht.hostid AND h.status IN (0,1,3)
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHost.php:434


SQL (0.000143): SELECT t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in /var/www/zabbix/include/classes/api/CApiService.php:318


SQL (0.000147): SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND h.hostid='10081'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CTemplate.php:261


SQL (0.000223): SELECT hi.* FROM interface hi WHERE hi.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → CHost->get() → CHost->addRelatedObjects() → CHostInterface->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostInterface.php:160


SQL (0.000166): SELECT i.itemid,i.type,i.key_,i.flags,i.templateid FROM items i WHERE i.type<>9 AND i.hostid='10209'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → CItem->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CItem.php:355


SQL (0.000183): SELECT a1.applicationid AS dstappid,a2.applicationid AS srcappid FROM applications a1,applications a2 WHERE a1.name=a2.name AND a1.hostid='10209' AND a2.applicationid='330'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → get_same_applications_for_host() → DBselect() in /var/www/zabbix/include/items.inc.php:800


SQL (0.000211): SELECT a1.applicationid AS dstappid,a2.applicationid AS srcappid FROM applications a1,applications a2 WHERE a1.name=a2.name AND a1.hostid='10209' AND a2.applicationid='330'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → get_same_applications_for_host() → DBselect() in /var/www/zabbix/include/items.inc.php:800


SQL (0.0002): SELECT a1.applicationid AS dstappid,a2.applicationid AS srcappid FROM applications a1,applications a2 WHERE a1.name=a2.name AND a1.hostid='10209' AND a2.applicationid='322'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → get_same_applications_for_host() → DBselect() in /var/www/zabbix/include/items.inc.php:800


SQL (0.00019): SELECT a1.applicationid AS dstappid,a2.applicationid AS srcappid FROM applications a1,applications a2 WHERE a1.name=a2.name AND a1.hostid='10209' AND a2.applicationid='322'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → get_same_applications_for_host() → DBselect() in /var/www/zabbix/include/items.inc.php:800


SQL (0.000163): SELECT a1.applicationid AS dstappid,a2.applicationid AS srcappid FROM applications a1,applications a2 WHERE a1.name=a2.name AND a1.hostid='10209' AND a2.applicationid='322'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → get_same_applications_for_host() → DBselect() in /var/www/zabbix/include/items.inc.php:800


SQL (0.000143): SELECT a1.applicationid AS dstappid,a2.applicationid AS srcappid FROM applications a1,applications a2 WHERE a1.name=a2.name AND a1.hostid='10209' AND a2.applicationid='322'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemGeneral->prepareInheritedItems() → get_same_applications_for_host() → DBselect() in /var/www/zabbix/include/items.inc.php:800


SQL (0.000148): SELECT nextid FROM ids WHERE table_name='items' AND field_name='itemid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000143): UPDATE ids SET nextid=25024 WHERE table_name='items' AND field_name='itemid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.000237): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10209','Incoming network traffic on $1','','net.if.in[{#IFNAME}]','60','7','365','0','3','','bps','1','1','','','0','0','','0','','8','',NULL,'','','','0','0','','','','','2','','0','30','93','23169','25019')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000193): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10209','Outgoing network traffic on $1','','net.if.out[{#IFNAME}]','60','7','365','0','3','','bps','1','1','','','0','0','','0','','8','',NULL,'','','','0','0','','','','','2','','0','30','93','23170','25020')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000193): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10209','Free disk space on $1','','vfs.fs.size[{#FSNAME},free]','60','7','365','0','3','','B','0','0','','','0','0','','0','','1','',NULL,'','','','0','0','','','','','2','','0','30','93','23164','25021')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000185): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10209','Free disk space on $1 (percentage)','','vfs.fs.size[{#FSNAME},pfree]','60','7','365','0','0','','%','0','0','','','0','0','','0','','1','',NULL,'','','','0','0','','','','','2','','0','30','93','23165','25022')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000311): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10209','Total disk space on $1','','vfs.fs.size[{#FSNAME},total]','3600','7','365','0','3','','B','0','0','','','0','0','','0','','1','',NULL,'','','','0','0','','','','','2','','0','30','93','23167','25023')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.00028): INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10209','Used disk space on $1','','vfs.fs.size[{#FSNAME},used]','60','7','365','0','3','','B','0','0','','','0','0','','0','','1','',NULL,'','','','0','0','','','','','2','','0','30','93','23168','25024')
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:440


SQL (0.000168): SELECT nextid FROM ids WHERE table_name='item_discovery' AND field_name='itemdiscoveryid' FOR UPDATE
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DB::reserveIds() → DBselect() in /var/www/zabbix/include/classes/db/DB.php:114


SQL (0.000471): UPDATE ids SET nextid=728 WHERE table_name='item_discovery' AND field_name='itemdiscoveryid'
hosts.php:504 → CFrontendApiWrapper->create() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->create() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CItemPrototype->syncTemplates() → CItemPrototype->inherit() → CItemPrototype->createReal() → DB::insert() → DB::reserveIds() → DBexecute() in /var/www/zabbix/include/classes/db/DB.php:128


SQL (0.001385): ROLLBACK
hosts.php:618 → DBend() → DBrollback() → DBexecute() in /var/www/zabbix/include/db.inc.php:338


SQL (6.2E-5): BEGIN
hosts.php:693 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /var/www/zabbix/include/db.inc.php:248


SQL (0.000607): SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg,hosts h WHERE hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status IN (0,1) ORDER BY g.name
hosts.php:693 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostGroup.php:337


SQL (7.9E-5): COMMIT
hosts.php:693 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /var/www/zabbix/include/db.inc.php:309


SQL (7.9E-5): BEGIN
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /var/www/zabbix/include/db.inc.php:248


SQL (7.4E-5): SELECT g.* FROM groups g
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CHostGroup.php:337


SQL (6.1E-5): COMMIT
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /var/www/zabbix/include/db.inc.php:309


SQL (7.6E-5): BEGIN
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /var/www/zabbix/include/db.inc.php:248


SQL (0.000379): SELECT h.* FROM hosts h WHERE h.status IN (5,6)
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CProxy->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CProxy.php:128


SQL (6.8E-5): COMMIT
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /var/www/zabbix/include/db.inc.php:309


SQL (6.8E-5): BEGIN
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in /var/www/zabbix/include/db.inc.php:248


SQL (0.000178): SELECT h.hostid,h.templateid,h.name FROM hosts h WHERE h.status=3 AND h.hostid='10081'
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → DBselect() in /var/www/zabbix/include/classes/api/services/CTemplate.php:261


SQL (9.2E-5): COMMIT
hosts.php:794 → CView->render() → include() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in /var/www/zabbix/include/db.inc.php:309


SQL (0.000115): BEGIN
hosts.php:1092 → require_once() → DBstart() → DBexecute() in /var/www/zabbix/include/db.inc.php:248


SQL (8.0E-5): SELECT uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=4
hosts.php:1092 → require_once() → addUserHistory() → DBselect() in /var/www/zabbix/include/profiles.inc.php:220


SQL (7.7E-5): COMMIT
hosts.php:1092 → require_once() → DBend() → DBcommit() → DBexecute() in /var/www/zabbix/include/db.inc.php:309



Zabbix 2.4.6 Copyright 2001-2015 by Zabbix SIA	  |  Connected as 'jr'