select p.item_parameterid, p.itemid, p.name, p.value, i.hostid from item_parameter p, items i, hosts h where p.itemid = i.itemid and i.hostid = h.hostid and h.status in (...) and i.flags <> ? order by p.itemid;

select h.hostid from hosts h where h.flags in (...) and h.status in (...) and ((h.name_upper like ? escape ? or h.name_upper like ? escape ?));

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

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;

select gitemid, graphid, itemid, drawtype, sortorder, color, yaxisside, calc_fnc, type from graphs_items where graphid in (...);

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

select dv.mandatory from dbversion dv;

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

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

select service_problem_tagid, serviceid, tag, operator, value from service_problem_tag order by serviceid;

delete from trends_uint where itemid = ? and clock < ?;

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

delete from task where status in (...) and clock <= ?;

select type, itemid from httpstepitem where httpstepid = ?;

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

select eventid from problem where source = ? and object = ? and not exists ( select null from triggers where triggerid = objectid);

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

select hostmacroid, hostid, macro, value, type from hostmacro;

select i.interfaceid, i.hostid, i.type, i.main, i.useip, i.ip, i.dns, i.port, i.available, i.disable_until, i.error, i.errors_from, s.version, s.bulk, s.community, s.securityname, s.securitylevel, s.authpassphrase, s.privpassphrase, s.authprotocol, s.privprotocol, s.contextname, s.max_repetitions from interface i left join interface_snmp s on i.interfaceid = s.interfaceid;

select itemid, flags from items where itemid = ?;

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 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 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 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 not null and nextcheck <= ? order by actionid, triggerid, itemid, r_eventid asc nulls first, escalationid;