select hostid, groupid from hosts_groups where groupid in (...) and hostid = ?;

select c.actionid, c.conditionid, c.conditiontype, c.operator, c.value, c.value2 from conditions c where c.actionid = ?;

select configid, default_theme, server_check_interval, show_technical_errors, severity_color_0, severity_color_1, severity_color_2, severity_color_3, severity_color_4, severity_color_5, custom_color, problem_unack_color, problem_ack_color, ok_unack_color, ok_ack_color, default_lang, default_timezone, login_attempts, login_block, x_frame_options, auditlog_enabled from config;

insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?.?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?.?);

select ha_nodeid, name, status, lastaccess, address, port, ha_sessionid from ha_node order by ha_nodeid for update;

select o.lld_overrideid, o.lld_override_operationid, o.operationobject, o.operator, o.value, s.status, d.discover, p.delay, h.history, t.trends, os.severity, i.inventory_mode from lld_override_operation o left join lld_override_opstatus s on o.lld_override_operationid = s.lld_override_operationid left join lld_override_opdiscover d on o.lld_override_operationid = d.lld_override_operationid left join lld_override_opperiod p on o.lld_override_operationid = p.lld_override_operationid left join lld_override_ophistory h on o.lld_override_operationid = h.lld_override_operationid left join lld_override_optrends t on o.lld_override_operationid = t.lld_override_operationid left join lld_override_opseverity os on o.lld_override_operationid = os.lld_override_operationid left join lld_override_opinventory i on o.lld_override_operationid = i.lld_override_operationid where o.lld_overrideid = ? order by o.lld_override_operationid;

select ha_failover_delay, auditlog_enabled, auditlog_mode from config;

select min(clock) from events where events.source = ? and events.object = ? and not exists ( select null from problem where events.eventid = problem.eventid) and not exists ( select null from problem where events.eventid = problem.r_eventid) and not exists ( select null from event_symptom where events.eventid = event_symptom.cause_eventid);

insert into sessions (sessionid, userid, lastaccess, status, secret) values (?, ?, ?, ?, ?);

insert into trends (itemid, clock, num, value_min, value_avg, value_max) values (?, ?, ?, ?.?, ?.?, ?.?), (?, ?, ?, ?.?, ?.?, ?.?);

select h.hostid, h.name from hosts h where h.flags in (...) and h.hostid = ? and h.status in (...);

select triggerdepid, triggerid_down, triggerid_up from trigger_depends where triggerid_down = ?;

insert into profiles (profileid, userid, idx, value_str, type, idx2) values (?, ?, ?, ?, ?, ?);

select u.userid, u.username, u.name, u.surname from users u where u.userid in (...);

select c.conditionid, c.actionid, c.conditiontype, c.operator, c.value, c.value2 from conditions c, actions a where c.actionid = a.actionid and a.status = ?;

select ah.autoreg_hostid from autoreg_host ah where not exists ( select null from hosts h where ah.host = h.host) and not exists ( select null from events e where ah.autoreg_hostid = e.objectid and e.source = ? and e.object = ?) order by ah.autoreg_hostid limit ?;

select eventid, maintenanceid from event_suppress where suppress_until < ? and suppress_until <> ?;

select userid, username, name, surname, url, autologin, autologout, lang, refresh, theme, attempt_failed, attempt_ip, attempt_clock, rows_per_page, timezone, roleid, userdirectoryid, ts_provisioned from users where username = ?;

select userid from users where username = ?;

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.auditlog_mode, c.ha_failover_delay, c.geomaps_tile_provider, c.geomaps_tile_url, c.geomaps_max_zoom, c.geomaps_attribution, c.vault_provider, c.timeout_zabbix_agent, c.timeout_simple_check, c.timeout_snmp_agent, c.timeout_external_check, c.timeout_db_monitor, c.timeout_http_agent, c.timeout_ssh_agent, c.timeout_telnet_agent, c.timeout_script, c.timeout_browser from config c;

begin;

commit;

insert into history_uint (itemid, clock, ns, value) values (?, ?, ?, ?);

insert into history (itemid, clock, ns, value) values (?, ?, ?, ?);

insert into history (itemid, clock, ns, value) values (?, ?, ?, ?.?);

select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;

select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is null and serviceid is null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;

select escalationid, actionid, triggerid, eventid, r_eventid, nextcheck, esc_step, status, itemid, acknowledgeid, servicealarmid, serviceid from escalations where triggerid is null and itemid is null and serviceid is not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;