I have a lot of Slow Queries occurrences in my log.
If the query is rewritten these occurrences of Slow Query will disappear.

1144405:20230322:170441.345 slow query: 11.273333 sec

 
select i.itemid,
i.hostid,
i.status,
i.type,
i.value_type,
i.key_,
i.snmp_oid,
i.ipmi_sensor,
i.delay,
i.trapper_hosts,
i.logtimefmt,
i.params,
ir.state,
i.authtype,
i.username,
i.password,
i.publickey,
i.privatekey,
i.flags,
i.interfaceid,
ir.lastlogsize,
ir.mtime,
i.history,
i.trends,
i.inventory_link,
i.valuemapid,
i.units,
ir.error,
i.jmx_endpoint,
i.master_itemid,
i.timeout,
i.url,
i.query_fields,
i.posts,
i.status_codes,
i.follow_redirects,
i.post_type,
i.http_proxy,
i.headers,
i.retrieve_mode,
i.request_method,
i.output_format,
i.ssl_cert_file,
i.ssl_key_file,
i.ssl_key_password,
i.verify_peer,
i.verify_host,
i.allow_traps,
i.templateid,
null from items i
inner join hosts h on i.hostid=h.hostid
join item_rtdata ir on i.itemid=ir.itemid
where h.status in (0,1)
and i.flags<>2