[14] => Array
        (
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10337
                            [name] => FS03
                        )

                )

            [triggerid] => 19073
            [value_flags] => 0
            [error] => 
            [url] => 
            [expression] => {20475}>0 | {20476}>0 | {20477}>0
            [description] => Требуется установка {ITEM.VALUE1} обновлений системы: {ITEM.VALUE2}/{ITEM.VALUE3}
            [priority] => 2
            [type] => 0
            [lastchange] => 1409202042
[...skip...]
SQL (0.000595): SELECT DISTINCT f.triggerid,f.functionid,i.itemid,i.lastvalue,i.lastclock,i.value_type,i.units,i.valuemapid,m.mappingid,m.newvalue FROM functions f INNER JOIN items i ON f.itemid=i.itemid INNER JOIN hosts h ON i.hostid=h.hostid LEFT JOIN mappings m ON i.valuemapid=m.valuemapid AND i.lastvalue=m.value WHERE f.functionid IN ('20475','20476','20477')
make_latest_issues() -> CEventHelper::expandDescription() -> CTriggerDescription->expand() -> CTriggerDescription->expandDescriptions() -> CTriggerDescription->expandItemMacros() -> DBselect()

SQL (0.000393): SELECT value FROM history_uint WHERE itemid='38603' AND clock='1409202042' AND ns='105456357' LIMIT 1 OFFSET 0
make_latest_issues() -> CEventHelper::expandDescription() -> CTriggerDescription->expand() -> CTriggerDescription->expandDescriptions() -> CTriggerDescription->expandItemMacros() -> CEventDescription->resolveItemValueMacro() -> item_get_history() -> DBselect()

SQL (0.000394): SELECT DISTINCT clock FROM history_uint WHERE itemid='38603' AND clock='1409202042' AND ns<'105456357'
make_latest_issues() -> CEventHelper::expandDescription() -> CTriggerDescription->expand() -> CTriggerDescription->expandDescriptions() -> CTriggerDescription->expandItemMacros() -> CEventDescription->resolveItemValueMacro() -> item_get_history() -> DBselect()

SQL (0.000325): SELECT MAX(clock) AS clock FROM history_uint WHERE itemid='38603' AND clock<'1409202042'
make_latest_issues() -> CEventHelper::expandDescription() -> CTriggerDescription->expand() -> CTriggerDescription->expandDescriptions() -> CTriggerDescription->expandItemMacros() -> CEventDescription->resolveItemValueMacro() -> item_get_history() -> DBselect()

SQL (0.001036): SELECT value FROM history_uint WHERE itemid='38603' AND clock='1409115611' ORDER BY itemid,clock desc,ns desc LIMIT 1 OFFSET 0
make_latest_issues() -> CEventHelper::expandDescription() -> CTriggerDescription->expand() -> CTriggerDescription->expandDescriptions() -> CTriggerDescription->expandItemMacros() -> CEventDescription->resolveItemValueMacro() -> item_get_history() -> DBselect()
[...skip till the end...]

mysql> SELECT DISTINCT f.triggerid,f.functionid,i.itemid,i.lastvalue,i.lastclock,i.value_type,i.units,i.valuemapid,m.mappingid,m.newvalue FROM functions f INNER JOIN items i ON f.itemid=i.itemid INNER JOIN hosts h ON i.hostid=h.hostid LEFT JOIN mappings m ON i.valuemapid=m.valuemapid AND i.lastvalue=m.value WHERE f.functionid IN ('20475','20476','20477');
+-----------+------------+--------+-----------+------------+------------+-------+------------+-----------+----------+
| triggerid | functionid | itemid | lastvalue | lastclock  | value_type | units | valuemapid | mappingid | newvalue |
+-----------+------------+--------+-----------+------------+------------+-------+------------+-----------+----------+
|     19073 |      20475 |  38603 | 1         | 1409202042 |          3 |       |       NULL |      NULL | NULL     |
|     19073 |      20476 |  38600 | 1         | 1409202042 |          3 |       |       NULL |      NULL | NULL     |
|     19073 |      20477 |  38601 | 0         | 1409202042 |          3 |       |       NULL |      NULL | NULL     |
+-----------+------------+--------+-----------+------------+------------+-------+------------+-----------+----------+
3 rows in set (0.00 sec)

mysql> SELECT value FROM history_uint WHERE itemid='38603' AND clock='1409202042' AND ns='105456357' LIMIT 1 OFFSET 0;
Empty set (0.00 sec)

mysql> SELECT DISTINCT clock FROM history_uint WHERE itemid='38603' AND clock='1409202042' AND ns<'105456357';
Empty set (0.01 sec)

mysql> SELECT MAX(clock) AS clock FROM history_uint WHERE itemid='38603' AND clock<'1409202042';
+------------+
| clock      |
+------------+
| 1409115611 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT value FROM history_uint WHERE itemid='38603' AND clock='1409115611' ORDER BY itemid,clock desc,ns desc LIMIT 1 OFFSET 0;
+-------+
| value |
+-------+
|     0 |
+-------+
1 row in set (0.01 sec)