******************** Script profiler ********************
Total time: 0.19299
Total SQL time: 0.161454
SQL count: 146 (selects: 114 | executes: 32)
Peak memory usage: 4M
Memory limit: 128M

1. hostgroup.get [CPageFilter.php:390]

Parameters:
Array
(
    [output] => Array
        (
            [0] => groupid
            [1] => name
        )

    [preservekeys] => 1
    [sortfield] => Array
        (
            [0] => name
        )

    [monitored_hosts] => 1
    [with_monitored_triggers] => 1
)
Result:
Array
(
    [59] => Array
        (
            [groupid] => 59
            [name] => -=Кемерово УКВ=-
        )

    [58] => Array
        (
            [groupid] => 58
            [name] => -=Реплейсеры=-
        )

    [39] => Array
        (
            [groupid] => 39
            [name] => -=СДК=-
        )

    [55] => Array
        (
            [groupid] => 55
            [name] => -=Сплайсеры 1MUX=-
        )

    [56] => Array
        (
            [groupid] => 56
            [name] => -=Сплайсеры 2MUX=-
        )

    [36] => Array
        (
            [groupid] => 36
            [name] => .Банново
        )

    [46] => Array
        (
            [groupid] => 46
            [name] => .Бачатский
        )

    [31] => Array
        (
            [groupid] => 31
            [name] => .Зеленогорский
        )

    [28] => Array
        (
            [groupid] => 28
            [name] => .Каз
        )

    [32] => Array
        (
            [groupid] => 32
            [name] => .Калтан
        )

    [48] => Array
        (
            [groupid] => 48
            [name] => .Комсомольск
        )

    [42] => Array
        (
            [groupid] => 42
            [name] => .Краснобродский
        )

    [40] => Array
        (
            [groupid] => 40
            [name] => .Красное
        )

    [33] => Array
        (
            [groupid] => 33
            [name] => .Листвяги
        )

    [37] => Array
        (
            [groupid] => 37
            [name] => .Малиновка
        )

    [35] => Array
        (
            [groupid] => 35
            [name] => .Осинники
        )

    [41] => Array
        (
            [groupid] => 41
            [name] => .Пермяки
        )

    [25] => Array
        (
            [groupid] => 25
            [name] => .Плотниково
        )

    [26] => Array
        (
            [groupid] => 26
            [name] => .Прокопьевск
        )

    [34] => Array
        (
            [groupid] => 34
            [name] => .Промышленная
        )

    [47] => Array
        (
            [groupid] => 47
            [name] => .Салаир
        )

    [43] => Array
        (
            [groupid] => 43
            [name] => .Старобачаты
        )

    [38] => Array
        (
            [groupid] => 38
            [name] => .Тарасово
        )

    [44] => Array
        (
            [groupid] => 44
            [name] => .Титово
        )

    [45] => Array
        (
            [groupid] => 45
            [name] => .Топки
        )

    [27] => Array
        (
            [groupid] => 27
            [name] => .Шерегеш
        )

    [4] => Array
        (
            [groupid] => 4
            [name] => Zabbix servers
        )

    [12] => Array
        (
            [groupid] => 12
            [name] => Анжеро-Судженск
        )

    [21] => Array
        (
            [groupid] => 21
            [name] => Белогорск
        )

    [20] => Array
        (
            [groupid] => 20
            [name] => Берикульский
        )

    [22] => Array
        (
            [groupid] => 22
            [name] => Гурьевск
        )

    [23] => Array
        (
            [groupid] => 23
            [name] => им. Ильича
        )

    [7] => Array
        (
            [groupid] => 7
            [name] => Кемерово
        )

    [24] => Array
        (
            [groupid] => 24
            [name] => Киселевск
        )

    [14] => Array
        (
            [groupid] => 14
            [name] => Ключевая
        )

    [9] => Array
        (
            [groupid] => 9
            [name] => Ленинск-Кузнецкий
        )

    [15] => Array
        (
            [groupid] => 15
            [name] => Междуреченск
        )

    [11] => Array
        (
            [groupid] => 11
            [name] => Мундыбаш
        )

    [10] => Array
        (
            [groupid] => 10
            [name] => Новокузнецк
        )

    [30] => Array
        (
            [groupid] => 30
            [name] => Панфилово
        )

    [8] => Array
        (
            [groupid] => 8
            [name] => Пограничный
        )

    [16] => Array
        (
            [groupid] => 16
            [name] => Притомский
        )

    [52] => Array
        (
            [groupid] => 52
            [name] => Сплайсеры
        )

    [53] => Array
        (
            [groupid] => 53
            [name] => Сплайсеры 1 mux
        )

    [54] => Array
        (
            [groupid] => 54
            [name] => Сплайсеры 2 mux
        )

    [17] => Array
        (
            [groupid] => 17
            [name] => Таштагол
        )

    [18] => Array
        (
            [groupid] => 18
            [name] => Темиртау
        )

    [49] => Array
        (
            [groupid] => 49
            [name] => Электросчетчики
        )

    [13] => Array
        (
            [groupid] => 13
            [name] => Юрга
        )

    [19] => Array
        (
            [groupid] => 19
            [name] => Яшкино
        )

)

2. host.get [CPageFilter.php:504]

Parameters:
Array
(
    [output] => Array
        (
            [0] => hostid
            [1] => name
            [2] => status
        )

    [groupids] => 20
    [monitored_hosts] => 1
    [with_monitored_triggers] => 1
)
Result:
Array
(
    [0] => Array
        (
            [hostid] => 10237
            [name] => СДК Берикульский
            [status] => 0
        )

    [1] => Array
        (
            [hostid] => 10238
            [name] => 1mux Передатчик Берикульский
            [status] => 0
        )

    [2] => Array
        (
            [hostid] => 10239
            [name] => 1mux Приемник Берикульский
            [status] => 0
        )

    [3] => Array
        (
            [hostid] => 10584
            [name] => МУК-2 Берикульский
            [status] => 0
        )

    [4] => Array
        (
            [hostid] => 10603
            [name] => 1mux РЕГИОН Приемник Берикульский
            [status] => 0
        )

    [5] => Array
        (
            [hostid] => 10604
            [name] => 1mux Реплейсер Берикульский
            [status] => 0
        )

    [6] => Array
        (
            [hostid] => 10722
            [name] => 1mux ИБП Берикульский
            [status] => 0
        )

    [7] => Array
        (
            [hostid] => 10723
            [name] => 2mux ИБП Берикульский
            [status] => 0
        )

)

3. trigger.get [tr_status.php:357]

Parameters:
Array
(
    [output] => Array
        (
            [0] => triggerid
            [1] => description
        )

    [monitored] => 1
    [skipDependent] => 1
    [sortfield] => description
    [limit] => 1001
    [groupids] => 20
    [only_true] => 1
    [maintenance] => 
)
Result:
Array
(
    [0] => Array
        (
            [triggerid] => 30785
            [description] => Батарея заряжается
        )

    [1] => Array
        (
            [triggerid] => 25367
            [description] => Включена замена PLP
        )

    [2] => Array
        (
            [triggerid] => 25366
            [description] => Включена замена SI таблиц
        )

    [3] => Array
        (
            [triggerid] => 14758
            [description] => Неправильно назначен шаблон устройства
        )

    [4] => Array
        (
            [triggerid] => 25375
            [description] => Ошибка источников синхронизации
        )

    [5] => Array
        (
            [triggerid] => 25383
            [description] => Статус устройства - неисправность
        )

    [6] => Array
        (
            [triggerid] => 14757
            [description] => Статус устройства - предупреждение
        )

)

4. trigger.get [tr_status.php:369]

Parameters:
Array
(
    [triggerids] => Array
        (
            [0] => 30785
            [1] => 25367
            [2] => 25366
            [3] => 14758
            [4] => 25375
            [5] => 25383
            [6] => 14757
        )

    [output] => extend
    [selectHosts] => Array
        (
            [0] => hostid
            [1] => name
            [2] => description
            [3] => status
            [4] => maintenanceid
            [5] => maintenance_status
            [6] => maintenance_type
        )

    [selectItems] => Array
        (
            [0] => itemid
            [1] => hostid
            [2] => name
            [3] => key_
            [4] => value_type
        )

    [selectDependencies] => extend
    [selectLastEvent] => Array
        (
            [0] => eventid
            [1] => objectid
            [2] => clock
            [3] => ns
        )

    [preservekeys] => 1
)
Result:
Array
(
    [14757] => Array
        (
            [triggerid] => 14757
            [expression] => {14235}=1
            [description] => Статус устройства - предупреждение
            [url] => 
            [status] => 0
            [value] => 1
            [priority] => 2
            [lastchange] => 1536809970
            [comments] => 
            [error] => 
            [templateid] => 13717
            [type] => 0
            [state] => 0
            [flags] => 0
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10238
                            [name] => 1mux Передатчик Берикульский
                            [description] => 
                            [status] => 0
                            [maintenanceid] => 0
                            [maintenance_status] => 0
                            [maintenance_type] => 0
                        )

                )

            [dependencies] => Array
                (
                    [0] => Array
                        (
                            [triggerid] => 14755
                            [expression] => {14233}=1
                            [description] => Нет данных в течение {$WAITTIME} секунд.
                            [url] => 
                            [status] => 0
                            [value] => 0
                            [priority] => 2
                            [lastchange] => 1533117356
                            [comments] => 
                            [error] => 
                            [templateid] => 13663
                            [type] => 0
                            [state] => 0
                            [flags] => 0
                        )

                )

            [items] => Array
                (
                    [0] => Array
                        (
                            [itemid] => 25061
                            [hostid] => 10238
                            [name] => Глобальный статус устройства
                            [key_] => state
                            [value_type] => 3
                        )

                )

            [lastEvent] => Array
                (
                    [objectid] => 14757
                    [ns] => 841
                    [eventid] => 22241635
                    [clock] => 1536809970
                )

        )

    [14758] => Array
        (
            [triggerid] => 14758
            [expression] => {14236}<>{$TYPE_ID}
            [description] => Неправильно назначен шаблон устройства
            [url] => 
            [status] => 0
            [value] => 1
            [priority] => 2
            [lastchange] => 1535795508
            [comments] => 
            [error] => 
            [templateid] => 13636
            [type] => 0
            [state] => 0
            [flags] => 0
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10238
                            [name] => 1mux Передатчик Берикульский
                            [description] => 
                            [status] => 0
                            [maintenanceid] => 0
                            [maintenance_status] => 0
                            [maintenance_type] => 0
                        )

                )

            [dependencies] => Array
                (
                    [0] => Array
                        (
                            [triggerid] => 14755
                            [expression] => {14233}=1
                            [description] => Нет данных в течение {$WAITTIME} секунд.
                            [url] => 
                            [status] => 0
                            [value] => 0
                            [priority] => 2
                            [lastchange] => 1533117356
                            [comments] => 
                            [error] => 
                            [templateid] => 13663
                            [type] => 0
                            [state] => 0
                            [flags] => 0
                        )

                )

            [items] => Array
                (
                    [0] => Array
                        (
                            [itemid] => 25063
                            [hostid] => 10238
                            [name] => ID типа устройства
                            [key_] => typeId
                            [value_type] => 3
                        )

                )

            [lastEvent] => Array
                (
                    [objectid] => 14758
                    [ns] => 879975848
                    [eventid] => 22006530
                    [clock] => 1535795508
                )

        )

    [25366] => Array
        (
            [triggerid] => 25366
            [expression] => {36096}=1
            [description] => Включена замена SI таблиц
            [url] => 
            [status] => 0
            [value] => 1
            [priority] => 1
            [lastchange] => 1518602265
            [comments] => 
            [error] => 
            [templateid] => 15285
            [type] => 0
            [state] => 0
            [flags] => 0
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10604
                            [name] => 1mux Реплейсер Берикульский
                            [description] => 
                            [status] => 0
                            [maintenanceid] => 0
                            [maintenance_status] => 0
                            [maintenance_type] => 0
                        )

                )

            [dependencies] => Array
                (
                    [0] => Array
                        (
                            [triggerid] => 25362
                            [expression] => {36092}=1
                            [description] => Нет связи между Блоком СДК и реплейсером
                            [url] => 
                            [status] => 0
                            [value] => 0
                            [priority] => 3
                            [lastchange] => 1524470461
                            [comments] => 
                            [error] => 
                            [templateid] => 15358
                            [type] => 0
                            [state] => 0
                            [flags] => 0
                        )

                )

            [items] => Array
                (
                    [0] => Array
                        (
                            [itemid] => 36183
                            [hostid] => 10604
                            [name] => Замена SI таблиц
                            [key_] => 14.value
                            [value_type] => 3
                        )

                )

            [lastEvent] => Array
                (
                    [objectid] => 25366
                    [ns] => 0
                    [eventid] => 19128766
                    [clock] => 1518602265
                )

        )

    [25367] => Array
        (
            [triggerid] => 25367
            [expression] => {36097}=1
            [description] => Включена замена PLP
            [url] => 
            [status] => 0
            [value] => 1
            [priority] => 1
            [lastchange] => 1532930545
            [comments] => 
            [error] => 
            [templateid] => 15284
            [type] => 0
            [state] => 0
            [flags] => 0
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10604
                            [name] => 1mux Реплейсер Берикульский
                            [description] => 
                            [status] => 0
                            [maintenanceid] => 0
                            [maintenance_status] => 0
                            [maintenance_type] => 0
                        )

                )

            [dependencies] => Array
                (
                    [0] => Array
                        (
                            [triggerid] => 25362
                            [expression] => {36092}=1
                            [description] => Нет связи между Блоком СДК и реплейсером
                            [url] => 
                            [status] => 0
                            [value] => 0
                            [priority] => 3
                            [lastchange] => 1524470461
                            [comments] => 
                            [error] => 
                            [templateid] => 15358
                            [type] => 0
                            [state] => 0
                            [flags] => 0
                        )

                )

            [items] => Array
                (
                    [0] => Array
                        (
                            [itemid] => 36184
                            [hostid] => 10604
                            [name] => Замена PLP
                            [key_] => 15.value
                            [value_type] => 3
                        )

                )

            [lastEvent] => Array
                (
                    [objectid] => 25367
                    [ns] => 0
                    [eventid] => 21435280
                    [clock] => 1532930545
                )

        )

    [25375] => Array
        (
            [triggerid] => 25375
            [expression] => {36105}=1
            [description] => Ошибка источников синхронизации
            [url] => 
            [status] => 0
            [value] => 0
            [priority] => 2
            [lastchange] => 1536840280
            [comments] => НЕ ИМЕЕТ ОТНОШЕНИЯ К МУЛЬТИПЛЕКСУ.
Ошибка синхронизации времени устройства с источником точного времени (СДК).
            [error] => 
            [templateid] => 15395
            [type] => 0
            [state] => 0
            [flags] => 0
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10604
                            [name] => 1mux Реплейсер Берикульский
                            [description] => 
                            [status] => 0
                            [maintenanceid] => 0
                            [maintenance_status] => 0
                            [maintenance_type] => 0
                        )

                )

            [dependencies] => Array
                (
                    [0] => Array
                        (
                            [triggerid] => 25362
                            [expression] => {36092}=1
                            [description] => Нет связи между Блоком СДК и реплейсером
                            [url] => 
                            [status] => 0
                            [value] => 0
                            [priority] => 3
                            [lastchange] => 1524470461
                            [comments] => 
                            [error] => 
                            [templateid] => 15358
                            [type] => 0
                            [state] => 0
                            [flags] => 0
                        )

                )

            [items] => Array
                (
                    [0] => Array
                        (
                            [itemid] => 36190
                            [hostid] => 10604
                            [name] => Ошибка источников синхронизации
                            [key_] => 5.value
                            [value_type] => 3
                        )

                )

            [lastEvent] => Array
                (
                    [objectid] => 25375
                    [ns] => 36
                    [eventid] => 22247190
                    [clock] => 1536840280
                )

        )

    [25383] => Array
        (
            [triggerid] => 25383
            [expression] => {36117}=2
            [description] => Статус устройства - неисправность
            [url] => 
            [status] => 0
            [value] => 0
            [priority] => 4
            [lastchange] => 1536840281
            [comments] => 
            [error] => 
            [templateid] => 15236
            [type] => 0
            [state] => 0
            [flags] => 0
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10604
                            [name] => 1mux Реплейсер Берикульский
                            [description] => 
                            [status] => 0
                            [maintenanceid] => 0
                            [maintenance_status] => 0
                            [maintenance_type] => 0
                        )

                )

            [dependencies] => Array
                (
                    [0] => Array
                        (
                            [triggerid] => 25380
                            [expression] => {36110}=1
                            [description] => Нет данных в течение {$WAITTIME} секунд.
                            [url] => 
                            [status] => 0
                            [value] => 0
                            [priority] => 2
                            [lastchange] => 1535274614
                            [comments] => 
                            [error] => 
                            [templateid] => 15235
                            [type] => 0
                            [state] => 0
                            [flags] => 0
                        )

                )

            [items] => Array
                (
                    [0] => Array
                        (
                            [itemid] => 36198
                            [hostid] => 10604
                            [name] => Глобальный статус устройства
                            [key_] => state
                            [value_type] => 3
                        )

                )

            [lastEvent] => Array
                (
                    [objectid] => 25383
                    [ns] => 85
                    [eventid] => 22247191
                    [clock] => 1536840281
                )

        )

    [30785] => Array
        (
            [triggerid] => 30785
            [expression] => {42058}=1
            [description] => Батарея заряжается
            [url] => 
            [status] => 0
            [value] => 1
            [priority] => 1
            [lastchange] => 1535595757
            [comments] => 
            [error] => 
            [templateid] => 20116
            [type] => 0
            [state] => 0
            [flags] => 0
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10723
                            [name] => 2mux ИБП Берикульский
                            [description] => 
                            [status] => 0
                            [maintenanceid] => 0
                            [maintenance_status] => 0
                            [maintenance_type] => 0
                        )

                )

            [dependencies] => Array
                (
                    [0] => Array
                        (
                            [triggerid] => 30789
                            [expression] => {42062}=1
                            [description] => Нет данных в течение {$WAITTIME} секунд.
                            [url] => 
                            [status] => 0
                            [value] => 0
                            [priority] => 2
                            [lastchange] => 1535384335
                            [comments] => 
                            [error] => 
                            [templateid] => 13869
                            [type] => 0
                            [state] => 0
                            [flags] => 0
                        )

                )

            [items] => Array
                (
                    [0] => Array
                        (
                            [itemid] => 40755
                            [hostid] => 10723
                            [name] => Состояние батареи
                            [key_] => 4.value
                            [value_type] => 3
                        )

                )

            [lastEvent] => Array
                (
                    [objectid] => 30785
                    [ns] => 0
                    [eventid] => 21982522
                    [clock] => 1535595757
                )

        )

)

5. trigger.get [tr_status.php:413]

Parameters:
Array
(
    [triggerids] => Array
        (
            [0] => 30785
            [1] => 25367
            [2] => 25366
            [3] => 14758
            [4] => 25375
            [5] => 25383
            [6] => 14757
        )

    [output] => Array
        (
            [0] => triggerid
        )

    [filter] => Array
        (
            [flags] => 0
        )

    [editable] => 1
    [preservekeys] => 1
)
Result:
Array
(
    [14757] => Array
        (
            [triggerid] => 14757
        )

    [14758] => Array
        (
            [triggerid] => 14758
        )

    [25366] => Array
        (
            [triggerid] => 25366
        )

    [25367] => Array
        (
            [triggerid] => 25367
        )

    [25375] => Array
        (
            [triggerid] => 25375
        )

    [25383] => Array
        (
            [triggerid] => 25383
        )

    [30785] => Array
        (
            [triggerid] => 30785
        )

)

6. event.get [tr_status.php:431]

Parameters:
Array
(
    [source] => 0
    [object] => 0
    [countOutput] => 1
    [groupCount] => 1
    [objectids] => Array
        (
            [0] => 30785
            [1] => 25367
            [2] => 25366
            [3] => 14758
            [4] => 25375
            [5] => 25383
            [6] => 14757
        )

    [filter] => Array
        (
            [acknowledged] => 0
            [value] => 1
        )

)
Result:
Array
(
    [0] => Array
        (
            [rowscount] => 287
            [objectid] => 14757
        )

    [1] => Array
        (
            [rowscount] => 1
            [objectid] => 25366
        )

    [2] => Array
        (
            [rowscount] => 36
            [objectid] => 25367
        )

    [3] => Array
        (
            [rowscount] => 181
            [objectid] => 25375
        )

    [4] => Array
        (
            [rowscount] => 1191
            [objectid] => 25383
        )

    [5] => Array
        (
            [rowscount] => 47
            [objectid] => 30785
        )

)

7. event.get [tr_status.php:456]

Parameters:
Array
(
    [source] => 0
    [object] => 0
    [countOutput] => 1
    [groupCount] => 1
    [objectids] => Array
        (
            [0] => 14758
        )

)
Result:
Array
(
    [0] => Array
        (
            [rowscount] => 3
            [objectid] => 14758
        )

)

8. host.get [tr_status.php:524]

Parameters:
Array
(
    [output] => Array
        (
            [0] => hostid
            [1] => status
        )

    [hostids] => Array
        (
            [10723] => 10723
            [10604] => 10604
            [10238] => 10238
        )

    [preservekeys] => 1
    [selectGraphs] => count
    [selectScreens] => count
)
Result:
Array
(
    [10238] => Array
        (
            [hostid] => 10238
            [status] => 0
            [graphs] => 4
            [screens] => 0
        )

    [10604] => Array
        (
            [hostid] => 10604
            [status] => 0
            [graphs] => 0
            [screens] => 0
        )

    [10723] => Array
        (
            [hostid] => 10723
            [status] => 0
            [graphs] => 10
            [screens] => 0
        )

)

9. script.getScriptsByHosts [tr_status.php:528]

Parameters:
Array
(
    [10723] => 10723
    [10604] => 10604
    [10238] => 10238
)
Result:
Array
(
    [10723] => Array
        (
            [0] => Array
                (
                    [scriptid] => 3
                    [name] => Detect operating system
                    [command] => sudo /usr/bin/nmap -O {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 7
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [1] => Array
                (
                    [scriptid] => 1
                    [name] => Ping
                    [command] => /bin/ping -c 3 {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 0
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [2] => Array
                (
                    [scriptid] => 18
                    [name] => PLP-fix
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-PLP-fix.sh {HOST.CONN} {$RCUPORT}  >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => Попытаться исправить ошибку замещения PLP "перевключением" настройки "Замена PLP"
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [3] => Array
                (
                    [scriptid] => 2
                    [name] => Traceroute
                    [command] => /usr/sbin/traceroute {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 0
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [4] => Array
                (
                    [scriptid] => 16
                    [name] => Включить замещение PLP
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-set-enable-PLP-replacing.sh {HOST.CONN} {$RCUPORT} >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [5] => Array
                (
                    [scriptid] => 17
                    [name] => Выключить замещение PLP
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-set-disable-PLP-replacing.sh {HOST.CONN} {$RCUPORT} >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

        )

    [10604] => Array
        (
            [0] => Array
                (
                    [scriptid] => 3
                    [name] => Detect operating system
                    [command] => sudo /usr/bin/nmap -O {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 7
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [1] => Array
                (
                    [scriptid] => 1
                    [name] => Ping
                    [command] => /bin/ping -c 3 {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 0
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [2] => Array
                (
                    [scriptid] => 18
                    [name] => PLP-fix
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-PLP-fix.sh {HOST.CONN} {$RCUPORT}  >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => Попытаться исправить ошибку замещения PLP "перевключением" настройки "Замена PLP"
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [3] => Array
                (
                    [scriptid] => 2
                    [name] => Traceroute
                    [command] => /usr/sbin/traceroute {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 0
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [4] => Array
                (
                    [scriptid] => 16
                    [name] => Включить замещение PLP
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-set-enable-PLP-replacing.sh {HOST.CONN} {$RCUPORT} >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [5] => Array
                (
                    [scriptid] => 17
                    [name] => Выключить замещение PLP
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-set-disable-PLP-replacing.sh {HOST.CONN} {$RCUPORT} >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [6] => Array
                (
                    [scriptid] => 15
                    [name] => Получить статус замены PLP
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-get-PLP-replacing-status.sh {HOST.CONN} {$RCUPORT}
                    [host_access] => 2
                    [usrgrpid] => 0
                    [groupid] => 58
                    [description] => Получить состояние настройки "Замена PLP"
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

        )

    [10238] => Array
        (
            [0] => Array
                (
                    [scriptid] => 3
                    [name] => Detect operating system
                    [command] => sudo /usr/bin/nmap -O {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 7
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [1] => Array
                (
                    [scriptid] => 1
                    [name] => Ping
                    [command] => /bin/ping -c 3 {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 0
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [2] => Array
                (
                    [scriptid] => 18
                    [name] => PLP-fix
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-PLP-fix.sh {HOST.CONN} {$RCUPORT}  >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => Попытаться исправить ошибку замещения PLP "перевключением" настройки "Замена PLP"
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [3] => Array
                (
                    [scriptid] => 2
                    [name] => Traceroute
                    [command] => /usr/sbin/traceroute {HOST.CONN} 2>&1
                    [host_access] => 2
                    [usrgrpid] => 0
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [4] => Array
                (
                    [scriptid] => 16
                    [name] => Включить замещение PLP
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-set-enable-PLP-replacing.sh {HOST.CONN} {$RCUPORT} >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

            [5] => Array
                (
                    [scriptid] => 17
                    [name] => Выключить замещение PLP
                    [command] => /usr/share/zabbix/externalscripts/Nevion-CP330/replacer-set-disable-PLP-replacing.sh {HOST.CONN} {$RCUPORT} >>/var/log/zabbix-scripts/{HOST.CONN}-PLP-fix.log 2>&1
                    [host_access] => 2
                    [usrgrpid] => 19
                    [groupid] => 0
                    [description] => 
                    [confirmation] => 
                    [type] => 0
                    [execute_on] => 1
                )

        )

)

10. trigger.get [CMacrosResolver.php:411]

Parameters:
Array
(
    [output] => Array
        (
        )

    [selectHosts] => Array
        (
            [0] => hostid
        )

    [triggerids] => Array
        (
            [0] => 30789
        )

    [preservekeys] => 1
)
Result:
Array
(
    [30789] => Array
        (
            [triggerid] => 30789
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10723
                        )

                )

        )

)

11. trigger.get [CMacrosResolver.php:411]

Parameters:
Array
(
    [output] => Array
        (
        )

    [selectHosts] => Array
        (
            [0] => hostid
        )

    [triggerids] => Array
        (
            [0] => 14755
        )

    [preservekeys] => 1
)
Result:
Array
(
    [14755] => Array
        (
            [triggerid] => 14755
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10238
                        )

                )

        )

)

12. trigger.get [CMacrosResolver.php:946]

Parameters:
Array
(
    [output] => Array
        (
        )

    [selectHosts] => Array
        (
            [0] => hostid
        )

    [triggerids] => Array
        (
            [0] => 14758
        )

    [preservekeys] => 1
)
Result:
Array
(
    [14758] => Array
        (
            [triggerid] => 14758
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10238
                        )

                )

        )

)

13. trigger.get [CMacrosResolver.php:411]

Parameters:
Array
(
    [output] => Array
        (
        )

    [selectHosts] => Array
        (
            [0] => hostid
        )

    [triggerids] => Array
        (
            [0] => 25380
        )

    [preservekeys] => 1
)
Result:
Array
(
    [25380] => Array
        (
            [triggerid] => 25380
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10604
                        )

                )

        )

)

14. trigger.get [CMacrosResolver.php:411]

Parameters:
Array
(
    [output] => Array
        (
        )

    [selectHosts] => Array
        (
            [0] => hostid
        )

    [triggerids] => Array
        (
            [0] => 14755
        )

    [preservekeys] => 1
)
Result:
Array
(
    [14755] => Array
        (
            [triggerid] => 14755
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10238
                        )

                )

        )

)


SQL (0.000134): SET NAMES utf8
tr_status.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:63

SQL (0.000683): SHOW TABLES LIKE 'dbversion'
tr_status.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → MysqlDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/MysqlDbBackend.php:32

SQL (0.000212): SELECT dv.mandatory,dv.optional FROM dbversion dv
tr_status.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in include/classes/db/DbBackend.php:46

SQL (0.000145): SELECT NULL FROM config c
tr_status.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkConfig() → DBselect() in include/classes/db/DbBackend.php:62

SQL (0.000121): BEGIN
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000313): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='60217e321a3a65c8d15f7afda9b0fd8d' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1536840719 OR u.autologout=0)
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1204

SQL (0.000283): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid='1' AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->checkAuthentication() → check_perm2system() → DBselect() in include/perm.inc.php:75

SQL (0.000244): UPDATE sessions SET lastaccess=1536840719 WHERE userid='1' AND sessionid='60217e321a3a65c8d15f7afda9b0fd8d'
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->checkAuthentication() → DBexecute() in include/classes/api/services/CUser.php:1229

SQL (0.000313): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='1' AND g.usrgrpid=ug.usrgrpid
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1237

SQL (0.000281): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid='1'
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1261

SQL (0.00023): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='1' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1269

SQL (9.7E-5): COMMIT
tr_status.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000278): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.menu.view.last'
tr_status.php:33 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000343): SELECT c.* FROM config c
tr_status.php:33 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33

SQL (0.000326): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.login.attempt.failed'
tr_status.php:33 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000326): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.view.groupid'
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000281): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.view.hostid'
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000236): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.view.graphid'
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000284): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.view.druleid'
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (9.4E-5): BEGIN
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.121071): SELECT   g.groupid,g.name FROM groups g WHERE EXISTS (SELECT NULL FROM hosts h,items i,functions f,triggers t,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status='0' AND hg.hostid=i.hostid AND i.itemid=f.itemid AND f.triggerid=t.triggerid AND i.status='0' AND t.status='0' AND t.flags IN ('0','4') AND g.groupid=hg.groupid) ORDER BY g.name
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:321

SQL (0.000145): COMMIT
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000336): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.latest.groupid'
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (6.4E-5): BEGIN
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_initHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000726): SELECT  DISTINCT  h.hostid,h.name,h.status FROM hosts h,hosts_groups hg WHERE h.flags IN (0,4) AND hg.groupid='20' AND hg.hostid=h.hostid AND h.status=0 AND EXISTS (SELECT NULL FROM items i,functions f,triggers t WHERE h.hostid=i.hostid AND i.itemid=f.itemid AND f.triggerid=t.triggerid AND i.status=0 AND t.status=0 AND t.flags IN (0,4))
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_initHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (0.000145): COMMIT
tr_status.php:86 → CPageFilter->__construct() → CPageFilter->_initHosts() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000292): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.show_triggers'
tr_status.php:150 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000222): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.show_details'
tr_status.php:151 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.00022): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.show_maintenance'
tr_status.php:152 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000213): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.show_severity'
tr_status.php:153 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000212): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.txt_select'
tr_status.php:154 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000216): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.status_change'
tr_status.php:155 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.00016): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.status_change_days'
tr_status.php:156 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000154): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.ack_status'
tr_status.php:158 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000257): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.show_events'
tr_status.php:159 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000204): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.application'
tr_status.php:168 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000282): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.inventory.field'
tr_status.php:172 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000272): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.php.sort'
tr_status.php:182 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000278): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.php.sortorder'
tr_status.php:183 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000213): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.tr_status.filter.state'
tr_status.php:233 → CView->render() → include() → CFilter->__construct() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (6.2E-5): BEGIN
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.005651): SELECT  DISTINCT  t.triggerid,t.description FROM triggers t,functions f,items i,hosts_groups hg WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid='20' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND h.maintenance_status=1) AND t.flags IN ('0','4') AND ((t.value=1) OR ((t.value=0) AND (t.lastchange>1536838919))) ORDER BY t.description LIMIT 2002 OFFSET 0
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1011

SQL (0.00033): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down IN ('14757','14758','25366','25367','25375','25383','30785')
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1835

SQL (0.000271): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down IN ('14755','25362','25380','30789')
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1835

SQL (0.000225): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down IN ('14746','25380')
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1835

SQL (0.000268): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down='14746'
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1835

SQL (0.000376): SELECT t.triggerid FROM triggers t,functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status=1 OR h.status=1 OR t.status=1) AND t.triggerid IN ('14746','14755','25362','25380','30789')
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:1876

SQL (0.000145): COMMIT
tr_status.php:357 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000238): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.lastpage'
tr_status.php:366 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (0.000218): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.page'
tr_status.php:366 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:106

SQL (5.8E-5): BEGIN
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000283): SELECT   t.* FROM triggers t WHERE t.triggerid IN ('14757','14758','25366','25367','25375','25383','30785') AND t.flags IN ('0','4')
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.000329): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN ('14757','14758','25366','25367','25375','25383','30785') AND f.itemid=i.itemid
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:324

SQL (0.000283): SELECT   h.hostid,h.name,h.description,h.status,h.maintenanceid,h.maintenance_status,h.maintenance_type FROM hosts h WHERE h.flags IN (0,4) AND h.hostid IN ('10238','10604','10723') AND h.status IN (0,1,3)
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (0.000275): SELECT td.triggerid_up,td.triggerid_down FROM trigger_depends td WHERE td.triggerid_down IN ('14757','14758','25366','25367','25375','25383','30785')
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → DBselect() in include/classes/api/services/CTrigger.php:1618

SQL (0.000224): SELECT   t.* FROM triggers t WHERE t.triggerid IN ('14755','25362','25380','30789') AND t.flags IN ('0','4')
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.000279): SELECT   t.functionid,t.triggerid,t.itemid FROM functions t WHERE t.triggerid IN ('14757','14758','25366','25367','25375','25383','30785')
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:317

SQL (0.000263): SELECT   i.itemid,i.hostid,i.name,i.key_,i.value_type FROM items i WHERE i.flags IN (0,4) AND i.itemid IN ('25061','25063','36183','36184','36190','36198','40755')
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:352

SQL (0.002418): SELECT e.objectid,e.ns,e.eventid,e.clock FROM events e JOIN (SELECT e2.source,e2.object,e2.objectid,MAX(clock) AS clock FROM events e2 WHERE e2.source=0 AND e2.object=0 AND e2.objectid IN ('14757','14758','25366','25367','25375','25383','30785') GROUP BY e2.source,e2.object,e2.objectid) e3 ON e3.source=e.source AND e3.object=e.object AND e3.objectid=e.objectid AND e3.clock=e.clock
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → DBselect() in include/classes/api/services/CTrigger.php:1709

SQL (9.1E-5): COMMIT
tr_status.php:369 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000116): BEGIN
tr_status.php:413 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000235): SELECT   t.triggerid FROM triggers t WHERE t.triggerid IN ('14757','14758','25366','25367','25375','25383','30785') AND t.flags='0'
tr_status.php:413 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.00012): COMMIT
tr_status.php:413 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000129): BEGIN
tr_status.php:431 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.00715): SELECT   COUNT(DISTINCT e.eventid) AS rowscount,e.objectid FROM events e WHERE e.objectid IN ('14757','14758','25366','25367','25375','25383','30785') AND e.object='0' AND e.source='0' AND e.acknowledged='0' AND e.value='1' GROUP BY e.objectid
tr_status.php:431 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:320

SQL (0.000127): COMMIT
tr_status.php:431 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.00013): BEGIN
tr_status.php:456 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000273): SELECT   COUNT(DISTINCT e.eventid) AS rowscount,e.objectid FROM events e WHERE e.objectid='14758' AND e.object='0' AND e.source='0' GROUP BY e.objectid
tr_status.php:456 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:320

SQL (0.000118): COMMIT
tr_status.php:456 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000113): BEGIN
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000219): SELECT   h.hostid,h.status FROM hosts h WHERE h.flags IN (0,4) AND h.hostid IN ('10238','10604','10723') AND h.status IN (0,1)
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (0.0005): SELECT  DISTINCT  COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid IN ('10238','10604','10723') AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:293

SQL (0.00021): SELECT ht.* FROM hosts_templates ht WHERE hostid IN ('10238','10604','10723')
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:172

SQL (0.000186): SELECT ht.* FROM hosts_templates ht WHERE hostid IN ('10106','10133','10302')
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:172

SQL (0.000134): SELECT ht.* FROM hosts_templates ht WHERE hostid='10085'
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:172

SQL (0.000224): SELECT   COUNT(DISTINCT s.screenid) AS rowscount,s.templateid FROM screens s WHERE s.templateid IS NOT NULL AND s.templateid IN ('10085','10106','10133','10238','10302','10604','10723') GROUP BY s.templateid
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CTemplateScreen->get() → DBselect() in include/classes/api/services/CTemplateScreen.php:205

SQL (4.3E-5): COMMIT
tr_status.php:524 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (4.2E-5): BEGIN
tr_status.php:528 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.00023): SELECT  DISTINCT  g.groupid FROM groups g,hosts_groups hg WHERE hg.hostid IN ('10238','10604','10723') AND hg.groupid=g.groupid
tr_status.php:528 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScript->getScriptsByHosts() → CScript->get() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:321

SQL (0.000256): SELECT   s.* FROM scripts s WHERE (s.groupid IN ('20','58') OR s.groupid IS NULL) ORDER BY s.name
tr_status.php:528 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScript->getScriptsByHosts() → CScript->get() → DBselect() in include/classes/api/services/CScript.php:159

SQL (0.000214): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid IN ('10238','10604','10723') AND h.status IN (0,1)
tr_status.php:528 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScript->getScriptsByHosts() → CScript->get() → CScript->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (0.000244): SELECT  DISTINCT  h.hostid FROM hosts h,hosts_groups hg WHERE h.flags IN (0,4) AND h.hostid IN ('10238','10604','10723') AND hg.groupid='58' AND hg.hostid=h.hostid AND h.status IN (0,1)
tr_status.php:528 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScript->getScriptsByHosts() → CScript->get() → CScript->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (9.3E-5): COMMIT
tr_status.php:528 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000209): SELECT triggerid_down,triggerid_up FROM trigger_depends WHERE triggerid_up IN ('14757','14758','25366','25367','25375','25383','30785')
tr_status.php:534 → DBselect() in tr_status.php:534

SQL (0.000143): SELECT DISTINCT t.description,t.expression,t.triggerid FROM triggers t WHERE t.triggerid='30789'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → DBselect() in include/classes/macros/CMacrosResolverHelper.php:293

SQL (6.2E-5): BEGIN
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000162): SELECT   t.triggerid FROM triggers t WHERE t.triggerid='30789' AND t.flags IN ('0','4')
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.000196): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='30789' AND f.itemid=i.itemid
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:324

SQL (0.00015): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10723' AND h.status IN (0,1,3)
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (9.5E-5): COMMIT
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000134): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10723'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000144): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10723'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000121): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10133'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000145): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10133'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000122): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000111): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.00011): SELECT DISTINCT t.description,t.expression,t.triggerid FROM triggers t WHERE t.triggerid='25362'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → DBselect() in include/classes/macros/CMacrosResolverHelper.php:293

SQL (0.000106): SELECT DISTINCT t.description,t.expression,t.triggerid FROM triggers t WHERE t.triggerid='25362'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → DBselect() in include/classes/macros/CMacrosResolverHelper.php:293

SQL (0.000106): SELECT DISTINCT t.description,t.expression,t.triggerid FROM triggers t WHERE t.triggerid='14755'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → DBselect() in include/classes/macros/CMacrosResolverHelper.php:293

SQL (5.4E-5): BEGIN
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000128): SELECT   t.triggerid FROM triggers t WHERE t.triggerid='14755' AND t.flags IN ('0','4')
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.000158): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='14755' AND f.itemid=i.itemid
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:324

SQL (0.000142): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10238' AND h.status IN (0,1,3)
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (6.0E-5): COMMIT
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000144): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10238'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000137): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10238'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000121): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10106'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.00011): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10106'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000117): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000108): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (3.3E-5): BEGIN
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000105): SELECT   t.triggerid FROM triggers t WHERE t.triggerid='14758' AND t.flags IN ('0','4')
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.000141): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='14758' AND f.itemid=i.itemid
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:324

SQL (0.000117): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10238' AND h.status IN (0,1,3)
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (3.6E-5): COMMIT
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000109): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10238'
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000109): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10238'
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000121): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10106'
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000112): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10106'
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000122): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10085'
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000108): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10085'
tr_status.php:620 → CMacrosResolverHelper::resolveEventDescription() → CMacrosResolver->resolveTriggerNames() → CMacrosResolver->resolveTriggerExpressionUserMacro() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.00011): SELECT DISTINCT t.description,t.expression,t.triggerid FROM triggers t WHERE t.triggerid='25362'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → DBselect() in include/classes/macros/CMacrosResolverHelper.php:293

SQL (0.000106): SELECT DISTINCT t.description,t.expression,t.triggerid FROM triggers t WHERE t.triggerid='25380'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → DBselect() in include/classes/macros/CMacrosResolverHelper.php:293

SQL (3.2E-5): BEGIN
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000126): SELECT   t.triggerid FROM triggers t WHERE t.triggerid='25380' AND t.flags IN ('0','4')
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.000164): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='25380' AND f.itemid=i.itemid
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:324

SQL (0.000136): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10604' AND h.status IN (0,1,3)
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (6.5E-5): COMMIT
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.00014): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10604'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000134): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10604'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000114): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10302'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000108): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10302'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000117): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000104): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000105): SELECT DISTINCT t.description,t.expression,t.triggerid FROM triggers t WHERE t.triggerid='14755'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → DBselect() in include/classes/macros/CMacrosResolverHelper.php:293

SQL (3.2E-5): BEGIN
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:250

SQL (0.000101): SELECT   t.triggerid FROM triggers t WHERE t.triggerid='14755' AND t.flags IN ('0','4')
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1043

SQL (0.000145): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='14755' AND f.itemid=i.itemid
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:324

SQL (0.000112): SELECT   h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='10238' AND h.status IN (0,1,3)
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:431

SQL (3.5E-5): COMMIT
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:311

SQL (0.000109): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10238'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000106): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10238'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.00012): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10106'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000107): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10106'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835

SQL (0.000114): SELECT hm.hostid,hm.macro,hm.value FROM hostmacro hm WHERE hm.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:801

SQL (0.000105): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10085'
tr_status.php:575 → CMacrosResolverHelper::resolveTriggerNameById() → CMacrosResolverHelper::resolveTriggerNameByIds() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getUserMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:835