In ZBXNEXT-3588 code has been prepared for bulk select on multiple events per condition and many places are implemented.
In ZBXNEXT-3613 trigger id and trigger id in template condition evaluation has been implemented.

This task focuses on template condition evaluation optimization. After it is implemented, there shall be all trigger sources optimized.

Currently there is one select to obtain parent trigger id and then select with multiple levels possible to obtain hostid and compare to condition.

Both selects shall select in bulk