******************** Script profiler ********************
Total time: 0.096508
Total SQL time: 0.099025
SQL count: 51 (selects: 44 | executes: 20)
Peak memory usage: 4M
Memory limit: 1G

1. role.get [CRoleHelper.php:167]

Parameters:
Array
(
    [output] => Array
        (
            [0] => roleid
            [1] => name
            [2] => type
        )

    [selectRules] => Array
        (
            [0] => ui
            [1] => ui.default_access
            [2] => modules
            [3] => modules.default_access
            [4] => api.access
            [5] => api.mode
            [6] => api
            [7] => actions
            [8] => actions.default_access
        )

    [roleids] => 3
)
Result:
Array
(
    [0] => Array
        (
            [roleid] => 3
            [name] => Super admin role
            [type] => 3
            [rules] => Array
                (
                    [ui] => Array
                        (
                            [0] => Array
                                (
                                    [name] => inventory.hosts
                                    [status] => 1
                                )

                            [1] => Array
                                (
                                    [name] => inventory.overview
                                    [status] => 1
                                )

                            [2] => Array
                                (
                                    [name] => monitoring.dashboard
                                    [status] => 1
                                )

                            [3] => Array
                                (
                                    [name] => monitoring.hosts
                                    [status] => 1
                                )

                            [4] => Array
                                (
                                    [name] => monitoring.latest_data
                                    [status] => 1
                                )

                            [5] => Array
                                (
                                    [name] => monitoring.maps
                                    [status] => 1
                                )

                            [6] => Array
                                (
                                    [name] => monitoring.problems
                                    [status] => 1
                                )

                            [7] => Array
                                (
                                    [name] => reports.availability_report
                                    [status] => 1
                                )

                            [8] => Array
                                (
                                    [name] => reports.top_triggers
                                    [status] => 1
                                )

                            [9] => Array
                                (
                                    [name] => services.services
                                    [status] => 1
                                )

                            [10] => Array
                                (
                                    [name] => services.sla_report
                                    [status] => 1
                                )

                            [11] => Array
                                (
                                    [name] => configuration.actions
                                    [status] => 1
                                )

                            [12] => Array
                                (
                                    [name] => configuration.discovery
                                    [status] => 1
                                )

                            [13] => Array
                                (
                                    [name] => configuration.host_groups
                                    [status] => 1
                                )

                            [14] => Array
                                (
                                    [name] => configuration.hosts
                                    [status] => 1
                                )

                            [15] => Array
                                (
                                    [name] => configuration.maintenance
                                    [status] => 1
                                )

                            [16] => Array
                                (
                                    [name] => configuration.templates
                                    [status] => 1
                                )

                            [17] => Array
                                (
                                    [name] => monitoring.discovery
                                    [status] => 1
                                )

                            [18] => Array
                                (
                                    [name] => reports.notifications
                                    [status] => 1
                                )

                            [19] => Array
                                (
                                    [name] => reports.scheduled_reports
                                    [status] => 1
                                )

                            [20] => Array
                                (
                                    [name] => services.actions
                                    [status] => 1
                                )

                            [21] => Array
                                (
                                    [name] => services.sla
                                    [status] => 1
                                )

                            [22] => Array
                                (
                                    [name] => administration.authentication
                                    [status] => 1
                                )

                            [23] => Array
                                (
                                    [name] => administration.general
                                    [status] => 1
                                )

                            [24] => Array
                                (
                                    [name] => administration.media_types
                                    [status] => 1
                                )

                            [25] => Array
                                (
                                    [name] => administration.proxies
                                    [status] => 1
                                )

                            [26] => Array
                                (
                                    [name] => administration.queue
                                    [status] => 1
                                )

                            [27] => Array
                                (
                                    [name] => administration.scripts
                                    [status] => 1
                                )

                            [28] => Array
                                (
                                    [name] => administration.user_groups
                                    [status] => 1
                                )

                            [29] => Array
                                (
                                    [name] => administration.user_roles
                                    [status] => 1
                                )

                            [30] => Array
                                (
                                    [name] => administration.users
                                    [status] => 1
                                )

                            [31] => Array
                                (
                                    [name] => configuration.event_correlation
                                    [status] => 1
                                )

                            [32] => Array
                                (
                                    [name] => reports.action_log
                                    [status] => 1
                                )

                            [33] => Array
                                (
                                    [name] => reports.audit
                                    [status] => 1
                                )

                            [34] => Array
                                (
                                    [name] => reports.system_info
                                    [status] => 1
                                )

                        )

                    [ui.default_access] => 1
                    [modules] => Array
                        (
                        )

                    [modules.default_access] => 1
                    [api.access] => 1
                    [api.mode] => 0
                    [api] => Array
                        (
                        )

                    [actions] => Array
                        (
                            [0] => Array
                                (
                                    [name] => edit_dashboards
                                    [status] => 1
                                )

                            [1] => Array
                                (
                                    [name] => edit_maps
                                    [status] => 1
                                )

                            [2] => Array
                                (
                                    [name] => acknowledge_problems
                                    [status] => 1
                                )

                            [3] => Array
                                (
                                    [name] => close_problems
                                    [status] => 1
                                )

                            [4] => Array
                                (
                                    [name] => change_severity
                                    [status] => 1
                                )

                            [5] => Array
                                (
                                    [name] => add_problem_comments
                                    [status] => 1
                                )

                            [6] => Array
                                (
                                    [name] => execute_scripts
                                    [status] => 1
                                )

                            [7] => Array
                                (
                                    [name] => manage_api_tokens
                                    [status] => 1
                                )

                            [8] => Array
                                (
                                    [name] => edit_maintenance
                                    [status] => 1
                                )

                            [9] => Array
                                (
                                    [name] => manage_scheduled_reports
                                    [status] => 1
                                )

                            [10] => Array
                                (
                                    [name] => manage_sla
                                    [status] => 1
                                )

                        )

                    [actions.default_access] => 1
                )

        )

)

2. settings.get [CSettingsHelper.php:108]

Parameters:
Array
(
    [output] => extend
)
Result:
Array
(
    [default_theme] => dark-theme
    [search_limit] => 10000
    [max_in_table] => 50
    [server_check_interval] => 10
    [work_period] => 1-5,09:00-18:00
    [show_technical_errors] => 0
    [history_period] => 24h
    [period_default] => 1h
    [max_period] => 2y
    [severity_color_0] => 97AAB3
    [severity_color_1] => 7499FF
    [severity_color_2] => FFC859
    [severity_color_3] => FFA059
    [severity_color_4] => E97659
    [severity_color_5] => E45959
    [severity_name_0] => Not classified
    [severity_name_1] => Information
    [severity_name_2] => Warning
    [severity_name_3] => Average
    [severity_name_4] => High
    [severity_name_5] => Disaster
    [custom_color] => 0
    [ok_period] => 5m
    [blink_period] => 2m
    [problem_unack_color] => CC0000
    [problem_ack_color] => CC0000
    [ok_unack_color] => 009900
    [ok_ack_color] => 009900
    [problem_unack_style] => 1
    [problem_ack_style] => 1
    [ok_unack_style] => 1
    [ok_ack_style] => 1
    [discovery_groupid] => 5
    [default_inventory_mode] => 1
    [alert_usrgrpid] => 7
    [snmptrap_logging] => 1
    [default_lang] => en_US
    [default_timezone] => Europe/Madrid
    [login_attempts] => 5
    [login_block] => 60m
    [validate_uri_schemes] => 1
    [uri_valid_schemes] => http,https
    [x_frame_options] => SAMEORIGIN
    [iframe_sandboxing_enabled] => 1
    [iframe_sandboxing_exceptions] => 
    [max_overview_table_size] => 50
    [connect_timeout] => 10s
    [socket_timeout] => 10s
    [media_type_test_timeout] => 65s
    [script_timeout] => 60s
    [item_test_timeout] => 120s
    [url] => https://zabbix.adamo.es/
    [report_test_timeout] => 60s
    [auditlog_enabled] => 1
    [ha_failover_delay] => 1m
    [geomaps_tile_provider] => OpenStreetMap.Mapnik
    [geomaps_tile_url] => 
    [geomaps_max_zoom] => 0
    [geomaps_attribution] => 
)

3. graph.get [graphs.php:145]

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

    [graphids] => 375264
    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [graphid] => 375264
        )

)

4. host.get [graphs.php:465]

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

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

    [editable] => 1
    [preservekeys] => 1
)
Result:
Array
(
    [10378] => Array
        (
            [hostid] => 10378
            [name] => cant-hazas-ayun-cs-20
        )

)

5. graph.get [graphs.php:521]

Parameters:
Array
(
    [output] => extend
    [selectHosts] => Array
        (
            [0] => hostid
        )

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

    [selectGraphDiscovery] => Array
        (
            [0] => parent_graphid
        )

)
Result:
Array
(
    [0] => Array
        (
            [graphid] => 375264
            [name] => 40GE0/0/1 Rx Power
            [width] => 900
            [height] => 200
            [yaxismin] => 0
            [yaxismax] => 100
            [templateid] => 0
            [show_work_period] => 1
            [show_triggers] => 1
            [graphtype] => 0
            [show_legend] => 1
            [show_3d] => 0
            [percent_left] => 0
            [percent_right] => 0
            [ymin_type] => 0
            [ymax_type] => 0
            [ymin_itemid] => 0
            [ymax_itemid] => 0
            [flags] => 4
            [uuid] => 
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10378
                        )

                )

            [discoveryRule] => Array
                (
                    [itemid] => 3173783
                    [name] => Entity Discovery
                )

            [graphDiscovery] => Array
                (
                    [parent_graphid] => 375233
                )

        )

)

6. graphitem.get [graphs.php:570]

Parameters:
Array
(
    [output] => Array
        (
            [0] => gitemid
            [1] => graphid
            [2] => itemid
            [3] => type
            [4] => drawtype
            [5] => yaxisside
            [6] => calc_fnc
            [7] => color
            [8] => sortorder
        )

    [graphids] => 375264
    [sortfield] => gitemid
)
Result:
Array
(
    [0] => Array
        (
            [gitemid] => 1530075
            [graphid] => 375264
            [itemid] => 3173987
            [type] => 0
            [drawtype] => 0
            [yaxisside] => 0
            [calc_fnc] => 2
            [color] => FF0000
            [sortorder] => 0
        )

    [1] => Array
        (
            [gitemid] => 1530076
            [graphid] => 375264
            [itemid] => 3173992
            [type] => 0
            [drawtype] => 0
            [yaxisside] => 0
            [calc_fnc] => 2
            [color] => FF8000
            [sortorder] => 1
        )

    [2] => Array
        (
            [gitemid] => 1530077
            [graphid] => 375264
            [itemid] => 3173982
            [type] => 0
            [drawtype] => 0
            [yaxisside] => 0
            [calc_fnc] => 2
            [color] => 00FF00
            [sortorder] => 2
        )

    [3] => Array
        (
            [gitemid] => 1530078
            [graphid] => 375264
            [itemid] => 3174002
            [type] => 0
            [drawtype] => 0
            [yaxisside] => 0
            [calc_fnc] => 2
            [color] => FF8000
            [sortorder] => 3
        )

    [4] => Array
        (
            [gitemid] => 1530079
            [graphid] => 375264
            [itemid] => 3173997
            [type] => 0
            [drawtype] => 0
            [yaxisside] => 0
            [calc_fnc] => 2
            [color] => FF0000
            [sortorder] => 4
        )

)

7. item.get [graphs.php:644]

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

    [selectHosts] => Array
        (
            [0] => hostid
            [1] => name
        )

    [itemids] => Array
        (
            [0] => 3173987
            [1] => 3173992
            [2] => 3173982
            [3] => 3174002
            [4] => 3173997
        )

    [filter] => Array
        (
            [flags] => Array
                (
                    [0] => 0
                    [1] => 2
                    [2] => 4
                )

        )

    [webitems] => 1
    [preservekeys] => 1
)
Result:
Array
(
    [3173982] => Array
        (
            [itemid] => 3173982
            [hostid] => 10378
            [name] => 40GE0/0/1: Rx Power
            [flags] => 4
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10378
                            [name] => cant-hazas-ayun-cs-20
                        )

                )

        )

    [3173987] => Array
        (
            [itemid] => 3173987
            [hostid] => 10378
            [name] => 40GE0/0/1: Rx High Threshold
            [flags] => 4
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10378
                            [name] => cant-hazas-ayun-cs-20
                        )

                )

        )

    [3173992] => Array
        (
            [itemid] => 3173992
            [hostid] => 10378
            [name] => 40GE0/0/1: Rx High Warning
            [flags] => 4
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10378
                            [name] => cant-hazas-ayun-cs-20
                        )

                )

        )

    [3173997] => Array
        (
            [itemid] => 3173997
            [hostid] => 10378
            [name] => 40GE0/0/1: Rx Low Threshold
            [flags] => 4
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10378
                            [name] => cant-hazas-ayun-cs-20
                        )

                )

        )

    [3174002] => Array
        (
            [itemid] => 3174002
            [hostid] => 10378
            [name] => 40GE0/0/1: Rx Low Warning
            [flags] => 4
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10378
                            [name] => cant-hazas-ayun-cs-20
                        )

                )

        )

)

8. host.get [html.inc.php:241]

Parameters:
Array
(
    [output] => Array
        (
            [0] => hostid
            [1] => status
            [2] => name
            [3] => maintenance_status
            [4] => flags
        )

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

    [selectInterfaces] => Array
        (
            [0] => type
            [1] => useip
            [2] => ip
            [3] => dns
            [4] => port
            [5] => version
            [6] => details
            [7] => available
            [8] => error
        )

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

    [editable] => 1
    [selectItems] => count
    [selectTriggers] => count
    [selectGraphs] => count
    [selectDiscoveries] => count
    [selectHttpTests] => count
)
Result:
Array
(
    [0] => Array
        (
            [hostid] => 10378
            [status] => 0
            [name] => cant-hazas-ayun-cs-20
            [maintenance_status] => 0
            [flags] => 0
            [items] => 483
            [discoveries] => 9
            [triggers] => 176
            [graphs] => 78
            [httpTests] => 0
            [interfaces] => Array
                (
                    [0] => Array
                        (
                            [type] => 2
                            [useip] => 1
                            [ip] => 10.100.39.48
                            [dns] => 
                            [port] => 161
                            [available] => 1
                            [error] => 
                            [details] => Array
                                (
                                    [version] => 2
                                    [bulk] => 0
                                    [community] => {$SNMP_COMMUNITY}
                                )

                        )

                )

            [hostDiscovery] => Array
                (
                )

        )

)


SQL (0.008035): COMMIT
graphs.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:179

SQL (0.001364): BEGIN
graphs.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.00127): SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid='3'
graphs.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → DBselect() in include/classes/api/services/CRole.php:98

SQL (0.001266): SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=3
graphs.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:1062

SQL (0.001217): SELECT md.moduleid FROM module md WHERE md.status=1
graphs.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → CRole->getRelatedModulesRules() → CRole::getEnabledModuleIds() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77

SQL (0.001337): COMMIT
graphs.php:22 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.001452): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path
graphs.php:22 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77

SQL (0.001199): SELECT NULL FROM users u WHERE u.userid=67 FOR UPDATE
graphs.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:36

SQL (0.001074): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.sidebar.mode'
graphs.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179

SQL (0.000839): BEGIN
graphs.php:31 → require_once() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.002532): SELECT c.configid,c.default_theme,c.search_limit,c.max_in_table,c.server_check_interval,c.work_period,c.show_technical_errors,c.history_period,c.period_default,c.max_period,c.severity_color_0,c.severity_color_1,c.severity_color_2,c.severity_color_3,c.severity_color_4,c.severity_color_5,c.severity_name_0,c.severity_name_1,c.severity_name_2,c.severity_name_3,c.severity_name_4,c.severity_name_5,c.custom_color,c.ok_period,c.blink_period,c.problem_unack_color,c.problem_ack_color,c.ok_unack_color,c.ok_ack_color,c.problem_unack_style,c.problem_ack_style,c.ok_unack_style,c.ok_ack_style,c.discovery_groupid,c.default_inventory_mode,c.alert_usrgrpid,c.snmptrap_logging,c.default_lang,c.default_timezone,c.login_attempts,c.login_block,c.validate_uri_schemes,c.uri_valid_schemes,c.x_frame_options,c.iframe_sandboxing_enabled,c.iframe_sandboxing_exceptions,c.max_overview_table_size,c.connect_timeout,c.socket_timeout,c.media_type_test_timeout,c.script_timeout,c.item_test_timeout,c.url,c.report_test_timeout,c.auditlog_enabled,c.ha_failover_delay,c.geomaps_tile_provider,c.geomaps_tile_url,c.geomaps_max_zoom,c.geomaps_attribution FROM config c
graphs.php:31 → require_once() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:74

SQL (0.000999): COMMIT
graphs.php:31 → require_once() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.001054): BEGIN
graphs.php:145 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.001386): SELECT g.graphid FROM graphs g WHERE g.graphid=375264 AND g.flags IN (0,4)
graphs.php:145 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:262

SQL (0.002066): COMMIT
graphs.php:145 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.001383): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.hosts.graphs.php.sort'
graphs.php:412 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179

SQL (0.001832): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.hosts.graphs.php.sortorder'
graphs.php:413 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179

SQL (0.001415): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.hosts.graphs.filter_groupids'
graphs.php:443 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179

SQL (0.001591): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.hosts.graphs.filter_hostids'
graphs.php:444 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179

SQL (0.001): BEGIN
graphs.php:465 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.001372): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10378 AND h.status IN (0,1)
graphs.php:465 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168

SQL (0.001405): COMMIT
graphs.php:465 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.001506): BEGIN
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.001955): SELECT g.* FROM graphs g WHERE g.graphid=375264 AND g.flags IN (0,4)
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:262

SQL (0.001803): SELECT gi.graphid,i.hostid FROM graphs_items gi,items i WHERE gi.graphid=375264 AND gi.itemid=i.itemid
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → CGraph->addRelatedObjects() → CGraphGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CGraphGeneral.php:395

SQL (0.001447): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10378 AND h.status IN (0,1,3)
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → CGraph->addRelatedObjects() → CGraphGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168

SQL (0.00163): SELECT id.parent_itemid,gd.graphid FROM graph_discovery gd,item_discovery id,graphs_items gi,items i WHERE gd.graphid=375264 AND gd.parent_graphid=gi.graphid AND gi.itemid=id.itemid AND id.parent_itemid=i.itemid AND i.flags=1
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → CGraph->addRelatedObjects() → DBselect() in include/classes/api/services/CGraph.php:373

SQL (0.001076): SELECT i.itemid,i.name FROM items i WHERE i.flags=1 AND i.itemid=3173783
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → CGraph->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:278

SQL (0.001141): SELECT t.graphid,t.parent_graphid FROM graph_discovery t WHERE t.graphid=375264
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → CGraph->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:353

SQL (0.000877): COMMIT
graphs.php:521 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.00087): BEGIN
graphs.php:570 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.00154): SELECT DISTINCT gi.gitemid,gi.graphid,gi.itemid,gi.type,gi.drawtype,gi.yaxisside,gi.calc_fnc,gi.color,gi.sortorder FROM graphs_items gi,graphs g WHERE gi.graphid=g.graphid AND g.graphid=375264 ORDER BY gi.gitemid
graphs.php:570 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraphItem->get() → DBselect() in include/classes/api/services/CGraphItem.php:116

SQL (0.001299): COMMIT
graphs.php:570 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.000967): BEGIN
graphs.php:644 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.001116): SELECT i.itemid,i.hostid,i.name,i.flags FROM items i WHERE i.itemid IN (3173982,3173987,3173992,3173997,3174002) AND i.flags IN (0,2,4)
graphs.php:644 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:394

SQL (0.001469): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10378 AND h.status IN (0,1,3)
graphs.php:644 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168

SQL (0.00097): COMMIT
graphs.php:644 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.00122): SELECT h.status FROM hosts h WHERE h.hostid='10378'
graphs.php:718 → isTemplate() → DBselect() in include/hosts.inc.php:733

SQL (0.001152): BEGIN
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125

SQL (0.001574): SELECT h.hostid,h.status,h.name,h.maintenance_status,h.flags FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10378 AND h.status IN (0,1)
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168

SQL (0.00586): SELECT COUNT(*) AS rowscount,i.hostid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=10378 GROUP BY i.hostid
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → 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:394

SQL (0.004639): SELECT COUNT(*) AS rowscount,i.hostid FROM items i WHERE i.flags=1 AND i.hostid=10378 GROUP BY i.hostid
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → 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:278

SQL (0.010782): SELECT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid=10378 AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN (0,4) GROUP BY i.hostid
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → 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:450

SQL (0.006697): SELECT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid=10378 AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN (0,4) GROUP BY i.hostid
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → 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:262

SQL (0.0016): SELECT COUNT(*) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid=10378 GROUP BY ht.hostid
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → 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:211

SQL (0.001435): SELECT hi.interfaceid,hi.type,hi.useip,hi.ip,hi.dns,hi.port,hi.available,hi.error,hi.hostid,COALESCE(his.version,2) AS version,COALESCE(his.bulk,1) AS bulk,COALESCE(his.community,'') AS community,COALESCE(his.securityname,'') AS securityname,COALESCE(his.securitylevel,0) AS securitylevel,COALESCE(his.authpassphrase,'') AS authpassphrase,COALESCE(his.privpassphrase,'') AS privpassphrase,COALESCE(his.authprotocol,0) AS authprotocol,COALESCE(his.privprotocol,0) AS privprotocol,COALESCE(his.contextname,'') AS contextname FROM interface hi LEFT JOIN interface_snmp his ON hi.interfaceid=his.interfaceid WHERE hi.hostid=10378
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:174

SQL (0.001111): SELECT t.hostid,t.ts_delete FROM host_discovery t WHERE t.hostid=10378
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:353

SQL (0.001065): COMMIT
graphs.php:721 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179

SQL (0.001655): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.login.attempt.failed'
graphs.php:721 → CView->getOutput() → include() → CWidget->show() → CWidget->toString() → get_prepared_messages() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179

SQL (0.001719): SELECT * FROM graph_theme WHERE theme='dark-theme'
graphs.php:721 → CView->getOutput() → include() → getUserGraphTheme() → DB::find() → DBselect() in include/classes/db/DB.php:542

SQL (0.001762): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 AND idx='web.paging.lastpage'
graphs.php:845 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179