******************** Script profiler ********************
Total time: 0.141503
Total SQL time: 0.078393
SQL count: 60 (selects: 47 | executes: 25)
Peak memory usage: 4M
Memory limit: 512M

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

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] => monitoring.dashboard
                                    [status] => 1
                                )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                            [27] => Array
                                (
                                    [name] => administration.authentication
                                    [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] => administration.media_types
                                    [status] => 1
                                )

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

                            [33] => Array
                                (
                                    [name] => administration.queue
                                    [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
                                )

                        )

                    [actions.default_access] => 1
                )

        )

)

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

Parameters:
Array
(
    [output] => extend
)
Result:
Array
(
    [default_theme] => blue-theme
    [search_limit] => 100000
    [max_in_table] => 10000
    [server_check_interval] => 10
    [work_period] => 1-5,06:00-18:00
    [show_technical_errors] => 1
    [history_period] => 24h
    [period_default] => 1h
    [max_period] => 31536000
    [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] => Niesklasyfikowane
    [severity_name_1] => Info
    [severity_name_2] => Warning
    [severity_name_3] => Average
    [severity_name_4] => High
    [severity_name_5] => Katastrofa
    [custom_color] => 0
    [ok_period] => 30m
    [blink_period] => 30m
    [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] => 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] => http://sgtseezabbix
    [report_test_timeout] => 60s
)

3. discoveryrule.get [trigger_prototypes.php:114]

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

    [itemids] => 448781
    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [itemid] => 448781
            [name] => Mounted filesystem discovery
            [hostid] => 11920
        )

)

4. triggerprototype.get [trigger_prototypes.php:126]

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

    [triggerids] => 150732
    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [triggerid] => 150732
        )

)

5. triggerprototype.get [trigger_prototypes.php:258]

Parameters:
Array
(
    [output] => Array
        (
            [0] => expression
            [1] => description
            [2] => url
            [3] => status
            [4] => priority
            [5] => comments
            [6] => templateid
            [7] => type
            [8] => recovery_mode
            [9] => recovery_expression
            [10] => correlation_mode
            [11] => correlation_tag
            [12] => manual_close
            [13] => opdata
            [14] => discover
            [15] => event_name
        )

    [selectDependencies] => Array
        (
            [0] => triggerid
        )

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

    [triggerids] => 150732
)
Result:
Array
(
    [0] => Array
        (
            [triggerid] => 150732
            [expression] => {323417}<1
            [description] => Free disk space is less than 1% on volume {#FSNAME}
            [url] => 
            [status] => 1
            [priority] => 5
            [comments] => 
            [templateid] => 0
            [type] => 0
            [recovery_mode] => 0
            [recovery_expression] => 
            [correlation_mode] => 0
            [correlation_tag] => 
            [manual_close] => 0
            [opdata] => 
            [discover] => 1
            [event_name] => 
            [tags] => Array
                (
                )

            [dependencies] => Array
                (
                )

        )

)

6. triggerprototype.update [trigger_prototypes.php:345]

Parameters:
Array
(
    [description] => Free disk space is less than1 1% on volume {#FSNAME}
    [triggerid] => 150732
)
Result:

7. triggerprototype.get [forms.inc.php:1659]

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

    [triggerids] => 150732
)
Result:
Array
(
    [0] => Array
        (
            [triggerid] => 150732
            [expression] => {323417}<1
            [description] => Free disk space is less than 1% on volume {#FSNAME}
            [url] => 
            [status] => 1
            [value] => 0
            [priority] => 5
            [lastchange] => 0
            [comments] => 
            [error] => 
            [templateid] => 0
            [type] => 0
            [state] => 0
            [flags] => 2
            [recovery_mode] => 0
            [recovery_expression] => 
            [correlation_mode] => 0
            [correlation_tag] => 
            [manual_close] => 0
            [opdata] => 
            [discover] => 1
            [event_name] => 
            [uuid] => 4c2d4aacee824a45859cd32c46aab8fd
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 11920
                        )

                )

        )

)

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

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

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

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

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

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

    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [templateid] => 11920
            [name] => Template OS Windows - Active
            [flags] => 0
        )

)

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

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

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

    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [itemid] => 448781
            [name] => Mounted filesystem discovery
            [items] => 4
            [triggers] => 6
            [graphs] => 1
            [hostPrototypes] => 0
        )

)


SQL (0.00032): COMMIT
trigger_prototypes.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:183

SQL (0.000977): BEGIN
trigger_prototypes.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:129

SQL (0.0007): SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid=3
trigger_prototypes.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:170

SQL (0.001108): SELECT moduleid FROM module WHERE status=1
trigger_prototypes.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() → DBselect() in include/classes/api/services/CRole.php:841

SQL (0.001057): SELECT roleid,type,name,value_int,value_str,value_moduleid FROM role_rule WHERE roleid=3
trigger_prototypes.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() → DBselect() in include/classes/api/services/CRole.php:847

SQL (0.000268): COMMIT
trigger_prototypes.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:183

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

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

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

SQL (0.000813): BEGIN
trigger_prototypes.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:129

SQL (0.001763): 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 FROM config c
trigger_prototypes.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:81

SQL (0.001185): COMMIT
trigger_prototypes.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:183

SQL (0.00229): BEGIN
trigger_prototypes.php:114 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

SQL (0.003369): SELECT i.itemid,i.name,i.hostid FROM items i WHERE i.flags=1 AND i.itemid=448781
trigger_prototypes.php:114 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:280

SQL (0.00027): COMMIT
trigger_prototypes.php:114 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:183

SQL (0.000237): BEGIN
trigger_prototypes.php:126 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

SQL (0.001434): SELECT t.triggerid FROM triggers t WHERE t.flags=2 AND t.triggerid=150732
trigger_prototypes.php:126 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:367

SQL (0.000224): COMMIT
trigger_prototypes.php:126 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:183

SQL (0.000261): BEGIN
trigger_prototypes.php:258 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

SQL (0.001869): SELECT t.triggerid,t.expression,t.description,t.url,t.status,t.priority,t.comments,t.templateid,t.type,t.recovery_mode,t.recovery_expression,t.correlation_mode,t.correlation_tag,t.manual_close,t.opdata,t.discover,t.event_name FROM triggers t WHERE t.flags=2 AND t.triggerid=150732
trigger_prototypes.php:258 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:367

SQL (0.003264): SELECT t.triggertagid,t.tag,t.value,t.triggerid FROM trigger_tag t WHERE t.triggerid=150732
trigger_prototypes.php:258 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:357

SQL (0.001132): SELECT td.triggerid_up,td.triggerid_down FROM trigger_depends td WHERE td.triggerid_down=150732
trigger_prototypes.php:258 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerPrototype.php:1068

SQL (0.000438): COMMIT
trigger_prototypes.php:258 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:183

SQL (0.001704): SELECT f.functionid,f.itemid,f.name,f.parameter FROM functions f WHERE f.functionid=323417
trigger_prototypes.php:262 → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:953

SQL (0.001812): SELECT i.itemid,i.hostid,i.key_ FROM items i WHERE i.itemid=448783
trigger_prototypes.php:262 → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:984

SQL (0.006974): SELECT h.hostid,h.host FROM hosts h WHERE h.hostid=11920
trigger_prototypes.php:262 → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:995

SQL (0.000445): BEGIN
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

SQL (0.000698): SELECT t.triggerid,t.description,t.expression,t.url,t.status,t.priority,t.comments,t.type,t.templateid,t.recovery_mode,t.recovery_expression,t.correlation_mode,t.correlation_tag,t.manual_close,t.opdata,t.event_name,t.discover FROM triggers t WHERE t.flags=2 AND t.triggerid=150732
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:367

SQL (0.000478): SELECT td.triggerid_up,td.triggerid_down FROM trigger_depends td WHERE td.triggerid_down=150732
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerPrototype.php:1068

SQL (0.002335): SELECT id.parent_itemid,f.triggerid FROM item_discovery id,functions f WHERE f.triggerid=150732 AND f.itemid=id.itemid
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerPrototype.php:1108

SQL (0.002022): SELECT i.itemid FROM items i WHERE i.flags=1 AND i.itemid=448781
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:280

SQL (0.000521): SELECT f.functionid,f.itemid,f.name,f.parameter FROM functions f WHERE f.functionid=323417
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:953

SQL (0.000473): SELECT i.itemid,i.hostid,i.key_ FROM items i WHERE i.itemid=448783
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:984

SQL (0.000553): SELECT h.hostid,h.host FROM hosts h WHERE h.hostid=11920
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:995

SQL (0.000451): SELECT triggertagid,triggerid,tag,value FROM trigger_tag WHERE triggerid=150732
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → DB::select() → DBselect() in include/classes/db/DB.php:981

SQL (0.001644): SELECT h.hostid,h.host,h.status FROM hosts h WHERE h.host='Template OS Windows - Active' AND h.status IN (0,1,3)
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->update() → CTriggerGeneral->validateUpdate() → CTriggerGeneral->populateHostIds() → DBselect() in include/classes/api/services/CTriggerGeneral.php:569

SQL (0.000365): ROLLBACK
trigger_prototypes.php:345 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBrollback() → DBexecute() in include/db.inc.php:202

SQL (0.000224): BEGIN
trigger_prototypes.php:503 → getTriggerFormData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

SQL (0.001284): SELECT t.* FROM triggers t WHERE t.flags=2 AND t.triggerid=150732
trigger_prototypes.php:503 → getTriggerFormData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:367

SQL (0.003202): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid=150732 AND f.itemid=i.itemid
trigger_prototypes.php:503 → getTriggerFormData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:723

SQL (0.001018): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=11920 AND h.status IN (0,1,3)
trigger_prototypes.php:503 → getTriggerFormData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1105

SQL (0.000275): COMMIT
trigger_prototypes.php:503 → getTriggerFormData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:183

SQL (0.000583): SELECT f.functionid,f.itemid,f.name,f.parameter FROM functions f WHERE f.functionid=323417
trigger_prototypes.php:503 → getTriggerFormData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:953

SQL (0.00047): SELECT i.itemid,i.hostid,i.key_ FROM items i WHERE i.itemid=448783
trigger_prototypes.php:503 → getTriggerFormData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:984

SQL (0.00055): SELECT h.hostid,h.host FROM hosts h WHERE h.hostid=11920
trigger_prototypes.php:503 → getTriggerFormData() → CMacrosResolverHelper::resolveTriggerExpressions() → CMacrosResolver->resolveTriggerExpressions() → DBselect() in include/classes/macros/CMacrosResolver.php:995

SQL (0.000212): BEGIN
trigger_prototypes.php:507 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

SQL (0.000837): SELECT h.hostid,h.status,h.name,h.maintenance_status,h.flags FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=11920 AND h.status IN (0,1)
trigger_prototypes.php:507 → 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:1105

SQL (0.00026): COMMIT
trigger_prototypes.php:507 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:183

SQL (0.000197): BEGIN
trigger_prototypes.php:507 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

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

SQL (0.000215): COMMIT
trigger_prototypes.php:507 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:183

SQL (0.000186): BEGIN
trigger_prototypes.php:507 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:129

SQL (0.000507): SELECT i.itemid,i.name FROM items i WHERE i.flags=1 AND i.itemid=448781
trigger_prototypes.php:507 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:280

SQL (0.002347): SELECT DISTINCT COUNT(DISTINCT i.itemid) AS rowscount,id.parent_itemid FROM items i,item_discovery id WHERE i.flags=2 AND id.parent_itemid=448781 AND i.itemid=id.itemid GROUP BY id.parent_itemid
trigger_prototypes.php:507 → 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.002279): SELECT DISTINCT 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=448781 GROUP BY id.parent_itemid
trigger_prototypes.php:507 → 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.005557): SELECT DISTINCT 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=448781 GROUP BY id.parent_itemid
trigger_prototypes.php:507 → 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:297

SQL (0.003555): SELECT DISTINCT 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=448781 GROUP BY hd.parent_itemid
trigger_prototypes.php:507 → 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:103

SQL (0.002654): COMMIT
trigger_prototypes.php:507 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:183

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

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