******************** Script profiler ********************
Total time: 0.083476
Total SQL time: 0.036231
SQL count: 49 (selects: 39 | executes: 25)
Peak memory usage: 8M
Memory limit: 256M

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

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] => 1000
    [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] => 15m
    [blink_period] => 10m
    [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_GB
    [default_timezone] => system
    [login_attempts] => 5
    [login_block] => 30s
    [validate_uri_schemes] => 1
    [uri_valid_schemes] => http,https,ftp,file,mailto,tel,ssh
    [x_frame_options] => SAMEORIGIN
    [iframe_sandboxing_enabled] => 1
    [iframe_sandboxing_exceptions] => 
    [max_overview_table_size] => 50
    [connect_timeout] => 3s
    [socket_timeout] => 3s
    [media_type_test_timeout] => 65s
    [script_timeout] => 60s
    [item_test_timeout] => 60s
    [url] => 
    [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. discoveryrule.get [graphs.php:120]

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

    [itemids] => 260053
    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [itemid] => 260053
            [hostid] => 10252
        )

)

4. graphprototype.get [graphs.php:134]

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

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

)

5. graphprototype.get [graphs.php:525]

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

    [graphids] => 88399
)
Result:
Array
(
    [0] => Array
        (
            [graphid] => 88399
            [name] => [{#BATCHRCUSTDB}] BatchReport IN_QUEUE & IN_PROGRESS duration in hour
            [width] => 900
            [height] => 350
            [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] => 2
            [discover] => 0
            [uuid] => 149465bc426a48db924b4af664f859e5
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10252
                        )

                )

        )

)

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

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

    [graphids] => 88399
    [sortfield] => gitemid
)
Result:
Array
(
    [0] => Array
        (
            [gitemid] => 378416
            [graphid] => 88399
            [itemid] => 263536
            [type] => 0
            [drawtype] => 0
            [yaxisside] => 0
            [calc_fnc] => 7
            [color] => 80FF00
            [sortorder] => 0
        )

    [1] => Array
        (
            [gitemid] => 378417
            [graphid] => 88399
            [itemid] => 305982
            [type] => 0
            [drawtype] => 0
            [yaxisside] => 0
            [calc_fnc] => 7
            [color] => 00FFFF
            [sortorder] => 1
        )

)

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

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

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

    [itemids] => Array
        (
            [0] => 263536
            [1] => 305982
        )

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

        )

    [webitems] => 1
    [preservekeys] => 1
)
Result:
Array
(
    [263536] => Array
        (
            [itemid] => 263536
            [hostid] => 10252
            [name] => [{#BATCHRCUSTDIR}] BatchReport jobs IN_PROGRESS duration in hour(s)
            [flags] => 2
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10252
                            [name] => HLG Common
                        )

                )

        )

    [305982] => Array
        (
            [itemid] => 305982
            [hostid] => 10252
            [name] => [{#BATCHRCUSTDIR}] BatchReport jobs IN_QUEUE duration in hour(s)
            [flags] => 2
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10252
                            [name] => HLG Common
                        )

                )

        )

)

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

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

    [editable] => 1
)
Result:
Array
(
)

9. template.get [html.inc.php:227]

Parameters:
Array
(
    [output] => Array
        (
            [0] => templateid
            [1] => name
            [2] => flags
        )

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

    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [templateid] => 10252
            [name] => HLG Common
            [flags] => 0
        )

)

10. discoveryrule.get [html.inc.php:244]

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

    [selectItems] => count
    [selectTriggers] => count
    [selectGraphs] => count
    [selectHostPrototypes] => count
    [itemids] => Array
        (
            [0] => 260053
        )

    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [itemid] => 260053
            [name] => Common Batchreport discovery
            [items] => 24
            [triggers] => 10
            [graphs] => 4
            [hostPrototypes] => 0
        )

)


SQL (0.000244): 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:182

SQL (0.000133): 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:128

SQL (0.000239): 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.000725): 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:1043

SQL (0.000475): 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 (6.7E-5): 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:182

SQL (0.000357): 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.000357): SELECT NULL FROM users u WHERE u.userid=22 FOR UPDATE
graphs.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:37

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

SQL (8.1E-5): 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:128

SQL (0.000436): 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 (5.0E-5): 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:182

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

SQL (0.003235): SELECT i.itemid,i.hostid FROM items i WHERE i.flags=1 AND i.itemid=260053
graphs.php:120 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:276

SQL (8.6E-5): COMMIT
graphs.php:120 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182

SQL (7.3E-5): BEGIN
graphs.php:134 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128

SQL (0.001636): SELECT g.graphid FROM graphs g WHERE g.flags=2 AND g.graphid=88399
graphs.php:134 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraphPrototype->get() → DBselect() in include/classes/api/services/CGraphPrototype.php:267

SQL (7.8E-5): COMMIT
graphs.php:134 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182

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

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

SQL (6.7E-5): BEGIN
graphs.php:525 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128

SQL (0.000881): SELECT g.* FROM graphs g WHERE g.flags=2 AND g.graphid=88399
graphs.php:525 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraphPrototype->get() → DBselect() in include/classes/api/services/CGraphPrototype.php:267

SQL (0.00256): SELECT gi.graphid,i.hostid FROM graphs_items gi,items i WHERE gi.graphid=88399 AND gi.itemid=i.itemid
graphs.php:525 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraphPrototype->get() → CGraphPrototype->addRelatedObjects() → CGraphGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CGraphGeneral.php:411

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

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

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

SQL (0.000823): 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=88399 ORDER BY gi.gitemid
graphs.php:576 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraphItem->get() → DBselect() in include/classes/api/services/CGraphItem.php:116

SQL (6.4E-5): COMMIT
graphs.php:576 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182

SQL (5.5E-5): BEGIN
graphs.php:646 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128

SQL (0.000552): SELECT i.itemid,i.hostid,i.name,i.flags FROM items i WHERE i.itemid IN (263536,305982) AND i.flags IN (0,2,4)
graphs.php:646 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:392

SQL (0.00032): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10252 AND h.status IN (0,1,3)
graphs.php:646 → 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 (7.8E-5): COMMIT
graphs.php:646 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182

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

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

SQL (0.000568): SELECT h.hostid,h.status,h.name,h.maintenance_status,h.flags FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10252 AND h.status IN (0,1)
graphs.php:722 → 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.000105): COMMIT
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182

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

SQL (0.0004): SELECT h.hostid,h.templateid,h.name,h.flags FROM hosts h WHERE h.status=3 AND h.hostid=10252
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:262

SQL (9.7E-5): COMMIT
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:182

SQL (7.8E-5): BEGIN
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:128

SQL (0.000316): SELECT i.itemid,i.name FROM items i WHERE i.flags=1 AND i.itemid=260053
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:276

SQL (0.00543): SELECT COUNT(DISTINCT i.itemid) AS rowscount,id.parent_itemid FROM items i,item_discovery id WHERE i.flags=2 AND id.parent_itemid=260053 AND i.itemid=id.itemid GROUP BY id.parent_itemid
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CItemPrototype->get() → DBselect() in include/classes/api/services/CItemPrototype.php:274

SQL (0.005371): SELECT COUNT(DISTINCT t.triggerid) AS rowscount,id.parent_itemid FROM triggers t,functions f,item_discovery id WHERE t.flags=2 AND f.itemid=id.itemid AND f.triggerid=t.triggerid AND id.parent_itemid=260053 GROUP BY id.parent_itemid
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:367

SQL (0.002481): SELECT COUNT(DISTINCT g.graphid) AS rowscount,id.parent_itemid FROM graphs g,graphs_items gi,item_discovery id WHERE g.flags=2 AND gi.graphid=g.graphid AND gi.itemid=id.itemid AND id.parent_itemid=260053 GROUP BY id.parent_itemid
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CGraphPrototype->get() → DBselect() in include/classes/api/services/CGraphPrototype.php:267

SQL (0.00135): SELECT COUNT(DISTINCT h.hostid) AS rowscount,hd.parent_itemid FROM hosts h,host_discovery hd,items i,hosts ph WHERE h.flags=2 AND h.hostid=hd.hostid AND hd.parent_itemid=i.itemid AND i.hostid=ph.hostid AND ph.flags=0 AND hd.parent_itemid=260053 GROUP BY hd.parent_itemid
graphs.php:722 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CHostPrototype->get() → DBselect() in include/classes/api/services/CHostPrototype.php:91

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

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

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

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


Hide debug