******************** Script profiler ******************** Total time: 0.86244 Total SQL time: 0.706366 SQL count: 174 (selects: 83 | executes: 91) Peak memory usage: 17M Memory limit: 1024M 1. host.isWritable [hosts.php:127] Parameters: Array ( [0] => 16164 ) Result: 1 2. host.delete [hosts.php:654] Parameters: Array ( [0] => 16164 ) Result: 3. hostgroup.get [CPageFilter.php:390] Parameters: Array ( [output] => Array ( [0] => groupid [1] => name ) [preservekeys] => 1 [sortfield] => Array ( [0] => name ) [real_hosts] => 1 [editable] => 1 ) Result: Array ( [105] => Array ( [groupid] => 105 [name] => 112 ) [39] => Array ( [groupid] => 39 [name] => 9jan ) [34] => Array ( [groupid] => 34 [name] => A23 ) [33] => Array ( [groupid] => 33 [name] => A26 ) [38] => Array ( [groupid] => 38 [name] => A31 ) [37] => Array ( [groupid] => 37 [name] => A33 ) [19] => Array ( [groupid] => 19 [name] => A36 ) [21] => Array ( [groupid] => 21 [name] => A45 ) [32] => Array ( [groupid] => 32 [name] => A49 ) [42] => Array ( [groupid] => 42 [name] => A52 ) [35] => Array ( [groupid] => 35 [name] => A53 ) [40] => Array ( [groupid] => 40 [name] => A66 ) [41] => Array ( [groupid] => 41 [name] => A73 ) [20] => Array ( [groupid] => 20 [name] => A77 ) [58] => Array ( [groupid] => 58 [name] => Anna ) [79] => Array ( [groupid] => 79 [name] => ASA ) [13] => Array ( [groupid] => 13 [name] => asr ) [28] => Array ( [groupid] => 28 [name] => BGLBSK ) [26] => Array ( [groupid] => 26 [name] => Bobrov ) [27] => Array ( [groupid] => 27 [name] => Boguch ) [9] => Array ( [groupid] => 9 [name] => broadband ) [29] => Array ( [groupid] => 29 [name] => Buturl ) [82] => Array ( [groupid] => 82 [name] => CiscoRouter ) [80] => Array ( [groupid] => 80 [name] => CiscoSW ) [81] => Array ( [groupid] => 81 [name] => CorpSW ) [10] => Array ( [groupid] => 10 [name] => CXK6 ) [89] => Array ( [groupid] => 89 [name] => DGS3420 ) [5] => Array ( [groupid] => 5 [name] => Discovered hosts ) [84] => Array ( [groupid] => 84 [name] => DSLAM ) [73] => Array ( [groupid] => 73 [name] => EGE ) [57] => Array ( [groupid] => 57 [name] => Ertil ) [100] => Array ( [groupid] => 100 [name] => Extreme ) [88] => Array ( [groupid] => 88 [name] => Gpon-Iskratel ) [30] => Array ( [groupid] => 30 [name] => Grib ) [31] => Array ( [groupid] => 31 [name] => Hohol ) [8] => Array ( [groupid] => 8 [name] => HP 5406 series ) [108] => Array ( [groupid] => 108 [name] => IBM Servers ) [71] => Array ( [groupid] => 71 [name] => IES1248-IES2000 ) [70] => Array ( [groupid] => 70 [name] => IPTV ) [23] => Array ( [groupid] => 23 [name] => kalach ) [47] => Array ( [groupid] => 47 [name] => Kamen ) [51] => Array ( [groupid] => 51 [name] => Kantem ) [63] => Array ( [groupid] => 63 [name] => Kash ) [14] => Array ( [groupid] => 14 [name] => Liski ) [103] => Array ( [groupid] => 103 [name] => localhost.localdomain ) [99] => Array ( [groupid] => 99 [name] => Lomon ) [68] => Array ( [groupid] => 68 [name] => ma5600 ) [95] => Array ( [groupid] => 95 [name] => ME60 ) [106] => Array ( [groupid] => 106 [name] => Mikrotik-Router ) [83] => Array ( [groupid] => 83 [name] => natex ) [45] => Array ( [groupid] => 45 [name] => Ndevick ) [11] => Array ( [groupid] => 11 [name] => NE40 ) [55] => Array ( [groupid] => 55 [name] => NHopr ) [18] => Array ( [groupid] => 18 [name] => Nusm ) [62] => Array ( [groupid] => 62 [name] => NVor ) [48] => Array ( [groupid] => 48 [name] => Olh ) [101] => Array ( [groupid] => 101 [name] => OLT ) [25] => Array ( [groupid] => 25 [name] => OSTR ) [69] => Array ( [groupid] => 69 [name] => OtherDSLAM ) [59] => Array ( [groupid] => 59 [name] => Panino ) [52] => Array ( [groupid] => 52 [name] => Petrop ) [72] => Array ( [groupid] => 72 [name] => pfSense ) [49] => Array ( [groupid] => 49 [name] => Podgor ) [43] => Array ( [groupid] => 43 [name] => Pov ) [98] => Array ( [groupid] => 98 [name] => Prober ) [22] => Array ( [groupid] => 22 [name] => PVL ) [93] => Array ( [groupid] => 93 [name] => Radius-server ) [61] => Array ( [groupid] => 61 [name] => Ramon ) [46] => Array ( [groupid] => 46 [name] => Repev ) [24] => Array ( [groupid] => 24 [name] => ROSS ) [16] => Array ( [groupid] => 16 [name] => S5328 ) [12] => Array ( [groupid] => 12 [name] => S8508 ) [86] => Array ( [groupid] => 86 [name] => SBC ) [96] => Array ( [groupid] => 96 [name] => sb-Mikrotik ) [44] => Array ( [groupid] => 44 [name] => Seml ) [94] => Array ( [groupid] => 94 [name] => Server ) [91] => Array ( [groupid] => 91 [name] => Storage ) [15] => Array ( [groupid] => 15 [name] => SwitchAccess ) [66] => Array ( [groupid] => 66 [name] => SwitchAccessAll ) [65] => Array ( [groupid] => 65 [name] => SwitchAccessNoRing ) [64] => Array ( [groupid] => 64 [name] => SwitchUser ) [54] => Array ( [groupid] => 54 [name] => Tal ) [56] => Array ( [groupid] => 56 [name] => Tern ) [36] => Array ( [groupid] => 36 [name] => test ) [97] => Array ( [groupid] => 97 [name] => UCN ) [87] => Array ( [groupid] => 87 [name] => UPS ) [60] => Array ( [groupid] => 60 [name] => VHava ) [107] => Array ( [groupid] => 107 [name] => Vibory ) [110] => Array ( [groupid] => 110 [name] => vibory403p ) [112] => Array ( [groupid] => 112 [name] => vibory408p ) [102] => Array ( [groupid] => 102 [name] => Virtual machines ) [104] => Array ( [groupid] => 104 [name] => (vm) ) [50] => Array ( [groupid] => 50 [name] => VMamon ) [53] => Array ( [groupid] => 53 [name] => Vorob ) [111] => Array ( [groupid] => 111 [name] => Vybory2016 ) [4] => Array ( [groupid] => 4 [name] => Zabbix servers ) [67] => Array ( [groupid] => 67 [name] => ZyXEL_IES5k5_6K ) ) 4. host.get [hosts.php:853] Parameters: Array ( [output] => Array ( [0] => hostid [1] => proxy_hostid [2] => host [3] => name [4] => status [5] => ipmi_authtype [6] => ipmi_privilege [7] => ipmi_username [8] => ipmi_password [9] => flags [10] => description [11] => tls_connect [12] => tls_accept [13] => tls_issuer [14] => tls_subject [15] => tls_psk_identity [16] => tls_psk ) [selectGroups] => Array ( [0] => groupid ) [selectParentTemplates] => Array ( [0] => templateid ) [selectMacros] => Array ( [0] => hostmacroid [1] => macro [2] => value ) [selectDiscoveryRule] => Array ( [0] => itemid [1] => name ) [selectInventory] => 1 [hostids] => Array ( [0] => 16164 ) ) Result: Array ( [0] => Array ( [hostid] => 16164 [proxy_hostid] => 0 [host] => ma1-gagarina28-seml [name] => ma1-gagarina28-seml [status] => 1 [ipmi_authtype] => 0 [ipmi_privilege] => 2 [ipmi_username] => [ipmi_password] => [flags] => 0 [description] => [tls_connect] => 1 [tls_accept] => 1 [tls_issuer] => [tls_subject] => [tls_psk_identity] => [tls_psk] => [groups] => Array ( [0] => Array ( [groupid] => 68 ) [1] => Array ( [groupid] => 44 ) [2] => Array ( [groupid] => 84 ) ) [parentTemplates] => Array ( [0] => Array ( [templateid] => 14936 ) ) [macros] => Array ( ) [inventory] => Array ( [hostid] => 16164 [inventory_mode] => 1 [type] => [type_full] => [name] => [alias] => [os] => [os_full] => [os_short] => [serialno_a] => [serialno_b] => [tag] => [asset_tag] => [macaddress_a] => 00-46-4b-d6-b7-cc [macaddress_b] => [hardware] => [hardware_full] => [software] => [software_full] => [software_app_a] => [software_app_b] => [software_app_c] => [software_app_d] => [software_app_e] => [contact] => [location] => [location_lat] => [location_lon] => [notes] => 247 days, 13:54:38 [chassis] => [model] => [hw_arch] => [vendor] => [contract_number] => [installer_name] => [deployment_status] => [url_a] => [url_b] => [url_c] => [host_networks] => [host_netmask] => [host_router] => [oob_ip] => [oob_netmask] => [oob_router] => [date_hw_purchase] => [date_hw_install] => [date_hw_expiry] => [date_hw_decomm] => [site_address_a] => [site_address_b] => [site_address_c] => [site_city] => [site_state] => [site_country] => Russia [site_zip] => [site_rack] => [site_notes] => [poc_1_name] => [poc_1_email] => [poc_1_phone_a] => [poc_1_phone_b] => [poc_1_cell] => [poc_1_screen] => [poc_1_notes] => [poc_2_name] => [poc_2_email] => [poc_2_phone_a] => [poc_2_phone_b] => [poc_2_cell] => [poc_2_screen] => [poc_2_notes] => ) [discoveryRule] => Array ( ) ) ) 5. hostinterface.get [hosts.php:870] Parameters: Array ( [output] => Array ( [0] => interfaceid [1] => main [2] => type [3] => useip [4] => ip [5] => dns [6] => port [7] => bulk ) [selectItems] => Array ( [0] => type ) [hostids] => Array ( [0] => 16164 ) [sortfield] => interfaceid ) Result: Array ( [0] => Array ( [interfaceid] => 12005 [main] => 1 [type] => 1 [useip] => 1 [ip] => 10.76.133.3 [dns] => [port] => 10050 [bulk] => 1 [items] => Array ( [0] => Array ( [type] => 3 ) ) ) [1] => Array ( [interfaceid] => 12006 [main] => 1 [type] => 2 [useip] => 1 [ip] => 10.76.133.3 [dns] => [port] => 161 [bulk] => 0 [items] => Array ( [0] => Array ( [type] => 4 ) [1] => Array ( [type] => 4 ) [2] => Array ( [type] => 4 ) [3] => Array ( [type] => 4 ) [4] => Array ( [type] => 4 ) [5] => Array ( [type] => 4 ) [6] => Array ( [type] => 4 ) [7] => Array ( [type] => 4 ) [8] => Array ( [type] => 4 ) [9] => Array ( [type] => 4 ) ) ) ) 6. item.get [hosts.php:971] Parameters: Array ( [output] => Array ( [0] => inventory_link [1] => itemid [2] => hostid [3] => name [4] => key_ ) [hostids] => Array ( [0] => 16164 ) [filter] => Array ( [inventory_link] => Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 [5] => 6 [6] => 7 [7] => 8 [8] => 9 [9] => 10 [10] => 11 [11] => 12 [12] => 13 [13] => 14 [14] => 15 [15] => 16 [16] => 17 [17] => 18 [18] => 19 [19] => 20 [20] => 21 [21] => 22 [22] => 23 [23] => 24 [24] => 25 [25] => 26 [26] => 27 [27] => 28 [28] => 29 [29] => 30 [30] => 31 [31] => 32 [32] => 33 [33] => 34 [34] => 35 [35] => 36 [36] => 37 [37] => 38 [38] => 39 [39] => 40 [40] => 41 [41] => 42 [42] => 43 [43] => 44 [44] => 45 [45] => 46 [46] => 47 [47] => 48 [48] => 49 [49] => 50 [50] => 51 [51] => 52 [52] => 53 [53] => 54 [54] => 55 [55] => 56 [56] => 57 [57] => 58 [58] => 59 [59] => 60 [60] => 61 [61] => 62 [62] => 63 [63] => 64 [64] => 65 [65] => 66 [66] => 67 [67] => 68 [68] => 69 [69] => 70 ) ) ) Result: Array ( [0] => Array ( [itemid] => 388708 [inventory_link] => 27 [hostid] => 16164 [name] => sysUptime [key_] => sysUptime ) ) 7. proxy.get [hosts.php:992] Parameters: Array ( [output] => Array ( [0] => host ) [preservekeys] => 1 ) Result: Array ( ) 8. hostgroup.get [hosts.php:1019] Parameters: Array ( [output] => Array ( ) [editable] => 1 [preservekeys] => 1 ) Result: Array ( [22] => Array ( [groupid] => 22 ) [1] => Array ( [groupid] => 1 ) [2] => Array ( [groupid] => 2 ) [4] => Array ( [groupid] => 4 ) [5] => Array ( [groupid] => 5 ) [7] => Array ( [groupid] => 7 ) [8] => Array ( [groupid] => 8 ) [23] => Array ( [groupid] => 23 ) [24] => Array ( [groupid] => 24 ) [19] => Array ( [groupid] => 19 ) [21] => Array ( [groupid] => 21 ) [20] => Array ( [groupid] => 20 ) [25] => Array ( [groupid] => 25 ) [29] => Array ( [groupid] => 29 ) [30] => Array ( [groupid] => 30 ) [31] => Array ( [groupid] => 31 ) [28] => Array ( [groupid] => 28 ) [26] => Array ( [groupid] => 26 ) [27] => Array ( [groupid] => 27 ) [12] => Array ( [groupid] => 12 ) [33] => Array ( [groupid] => 33 ) [32] => Array ( [groupid] => 32 ) [35] => Array ( [groupid] => 35 ) [36] => Array ( [groupid] => 36 ) [10] => Array ( [groupid] => 10 ) [11] => Array ( [groupid] => 11 ) [13] => Array ( [groupid] => 13 ) [14] => Array ( [groupid] => 14 ) [15] => Array ( [groupid] => 15 ) [70] => Array ( [groupid] => 70 ) [39] => Array ( [groupid] => 39 ) [67] => Array ( [groupid] => 67 ) [34] => Array ( [groupid] => 34 ) [18] => Array ( [groupid] => 18 ) [38] => Array ( [groupid] => 38 ) [37] => Array ( [groupid] => 37 ) [42] => Array ( [groupid] => 42 ) [41] => Array ( [groupid] => 41 ) [40] => Array ( [groupid] => 40 ) [68] => Array ( [groupid] => 68 ) [65] => Array ( [groupid] => 65 ) [45] => Array ( [groupid] => 45 ) [46] => Array ( [groupid] => 46 ) [47] => Array ( [groupid] => 47 ) [48] => Array ( [groupid] => 48 ) [49] => Array ( [groupid] => 49 ) [50] => Array ( [groupid] => 50 ) [51] => Array ( [groupid] => 51 ) [52] => Array ( [groupid] => 52 ) [53] => Array ( [groupid] => 53 ) [54] => Array ( [groupid] => 54 ) [55] => Array ( [groupid] => 55 ) [56] => Array ( [groupid] => 56 ) [57] => Array ( [groupid] => 57 ) [58] => Array ( [groupid] => 58 ) [59] => Array ( [groupid] => 59 ) [60] => Array ( [groupid] => 60 ) [61] => Array ( [groupid] => 61 ) [62] => Array ( [groupid] => 62 ) [63] => Array ( [groupid] => 63 ) [69] => Array ( [groupid] => 69 ) [66] => Array ( [groupid] => 66 ) [43] => Array ( [groupid] => 43 ) [44] => Array ( [groupid] => 44 ) [64] => Array ( [groupid] => 64 ) [92] => Array ( [groupid] => 92 ) [72] => Array ( [groupid] => 72 ) [71] => Array ( [groupid] => 71 ) [73] => Array ( [groupid] => 73 ) [80] => Array ( [groupid] => 80 ) [81] => Array ( [groupid] => 81 ) [82] => Array ( [groupid] => 82 ) [83] => Array ( [groupid] => 83 ) [79] => Array ( [groupid] => 79 ) [85] => Array ( [groupid] => 85 ) [86] => Array ( [groupid] => 86 ) [84] => Array ( [groupid] => 84 ) [87] => Array ( [groupid] => 87 ) [88] => Array ( [groupid] => 88 ) [89] => Array ( [groupid] => 89 ) [16] => Array ( [groupid] => 16 ) [91] => Array ( [groupid] => 91 ) [93] => Array ( [groupid] => 93 ) [94] => Array ( [groupid] => 94 ) [95] => Array ( [groupid] => 95 ) [96] => Array ( [groupid] => 96 ) [97] => Array ( [groupid] => 97 ) [98] => Array ( [groupid] => 98 ) [99] => Array ( [groupid] => 99 ) [100] => Array ( [groupid] => 100 ) [101] => Array ( [groupid] => 101 ) [102] => Array ( [groupid] => 102 ) [103] => Array ( [groupid] => 103 ) [104] => Array ( [groupid] => 104 ) [105] => Array ( [groupid] => 105 ) [106] => Array ( [groupid] => 106 ) [107] => Array ( [groupid] => 107 ) [108] => Array ( [groupid] => 108 ) [9] => Array ( [groupid] => 9 ) [111] => Array ( [groupid] => 111 ) [109] => Array ( [groupid] => 109 ) [112] => Array ( [groupid] => 112 ) [110] => Array ( [groupid] => 110 ) ) 9. hostgroup.get [hosts.php:1022] Parameters: Array ( [output] => Array ( [0] => groupid [1] => name ) ) Result: Array ( [0] => Array ( [groupid] => 22 [name] => PVL ) [1] => Array ( [groupid] => 1 [name] => Templates ) [2] => Array ( [groupid] => 2 [name] => Linux servers ) [3] => Array ( [groupid] => 4 [name] => Zabbix servers ) [4] => Array ( [groupid] => 5 [name] => Discovered hosts ) [5] => Array ( [groupid] => 7 [name] => Hypervisors ) [6] => Array ( [groupid] => 8 [name] => HP 5406 series ) [7] => Array ( [groupid] => 23 [name] => kalach ) [8] => Array ( [groupid] => 24 [name] => ROSS ) [9] => Array ( [groupid] => 19 [name] => A36 ) [10] => Array ( [groupid] => 21 [name] => A45 ) [11] => Array ( [groupid] => 20 [name] => A77 ) [12] => Array ( [groupid] => 25 [name] => OSTR ) [13] => Array ( [groupid] => 29 [name] => Buturl ) [14] => Array ( [groupid] => 30 [name] => Grib ) [15] => Array ( [groupid] => 31 [name] => Hohol ) [16] => Array ( [groupid] => 28 [name] => BGLBSK ) [17] => Array ( [groupid] => 26 [name] => Bobrov ) [18] => Array ( [groupid] => 27 [name] => Boguch ) [19] => Array ( [groupid] => 12 [name] => S8508 ) [20] => Array ( [groupid] => 33 [name] => A26 ) [21] => Array ( [groupid] => 32 [name] => A49 ) [22] => Array ( [groupid] => 35 [name] => A53 ) [23] => Array ( [groupid] => 36 [name] => test ) [24] => Array ( [groupid] => 10 [name] => CXK6 ) [25] => Array ( [groupid] => 11 [name] => NE40 ) [26] => Array ( [groupid] => 13 [name] => asr ) [27] => Array ( [groupid] => 14 [name] => Liski ) [28] => Array ( [groupid] => 15 [name] => SwitchAccess ) [29] => Array ( [groupid] => 70 [name] => IPTV ) [30] => Array ( [groupid] => 39 [name] => 9jan ) [31] => Array ( [groupid] => 67 [name] => ZyXEL_IES5k5_6K ) [32] => Array ( [groupid] => 34 [name] => A23 ) [33] => Array ( [groupid] => 18 [name] => Nusm ) [34] => Array ( [groupid] => 38 [name] => A31 ) [35] => Array ( [groupid] => 37 [name] => A33 ) [36] => Array ( [groupid] => 42 [name] => A52 ) [37] => Array ( [groupid] => 41 [name] => A73 ) [38] => Array ( [groupid] => 40 [name] => A66 ) [39] => Array ( [groupid] => 68 [name] => ma5600 ) [40] => Array ( [groupid] => 65 [name] => SwitchAccessNoRing ) [41] => Array ( [groupid] => 45 [name] => Ndevick ) [42] => Array ( [groupid] => 46 [name] => Repev ) [43] => Array ( [groupid] => 47 [name] => Kamen ) [44] => Array ( [groupid] => 48 [name] => Olh ) [45] => Array ( [groupid] => 49 [name] => Podgor ) [46] => Array ( [groupid] => 50 [name] => VMamon ) [47] => Array ( [groupid] => 51 [name] => Kantem ) [48] => Array ( [groupid] => 52 [name] => Petrop ) [49] => Array ( [groupid] => 53 [name] => Vorob ) [50] => Array ( [groupid] => 54 [name] => Tal ) [51] => Array ( [groupid] => 55 [name] => NHopr ) [52] => Array ( [groupid] => 56 [name] => Tern ) [53] => Array ( [groupid] => 57 [name] => Ertil ) [54] => Array ( [groupid] => 58 [name] => Anna ) [55] => Array ( [groupid] => 59 [name] => Panino ) [56] => Array ( [groupid] => 60 [name] => VHava ) [57] => Array ( [groupid] => 61 [name] => Ramon ) [58] => Array ( [groupid] => 62 [name] => NVor ) [59] => Array ( [groupid] => 63 [name] => Kash ) [60] => Array ( [groupid] => 69 [name] => OtherDSLAM ) [61] => Array ( [groupid] => 66 [name] => SwitchAccessAll ) [62] => Array ( [groupid] => 43 [name] => Pov ) [63] => Array ( [groupid] => 44 [name] => Seml ) [64] => Array ( [groupid] => 64 [name] => SwitchUser ) [65] => Array ( [groupid] => 92 [name] => Mikrotik ) [66] => Array ( [groupid] => 72 [name] => pfSense ) [67] => Array ( [groupid] => 71 [name] => IES1248-IES2000 ) [68] => Array ( [groupid] => 73 [name] => EGE ) [69] => Array ( [groupid] => 80 [name] => CiscoSW ) [70] => Array ( [groupid] => 81 [name] => CorpSW ) [71] => Array ( [groupid] => 82 [name] => CiscoRouter ) [72] => Array ( [groupid] => 83 [name] => natex ) [73] => Array ( [groupid] => 79 [name] => ASA ) [74] => Array ( [groupid] => 85 [name] => CiscoBroadband ) [75] => Array ( [groupid] => 86 [name] => SBC ) [76] => Array ( [groupid] => 84 [name] => DSLAM ) [77] => Array ( [groupid] => 87 [name] => UPS ) [78] => Array ( [groupid] => 88 [name] => Gpon-Iskratel ) [79] => Array ( [groupid] => 89 [name] => DGS3420 ) [80] => Array ( [groupid] => 16 [name] => S5328 ) [81] => Array ( [groupid] => 91 [name] => Storage ) [82] => Array ( [groupid] => 93 [name] => Radius-server ) [83] => Array ( [groupid] => 94 [name] => Server ) [84] => Array ( [groupid] => 95 [name] => ME60 ) [85] => Array ( [groupid] => 96 [name] => sb-Mikrotik ) [86] => Array ( [groupid] => 97 [name] => UCN ) [87] => Array ( [groupid] => 98 [name] => Prober ) [88] => Array ( [groupid] => 99 [name] => Lomon ) [89] => Array ( [groupid] => 100 [name] => Extreme ) [90] => Array ( [groupid] => 101 [name] => OLT ) [91] => Array ( [groupid] => 102 [name] => Virtual machines ) [92] => Array ( [groupid] => 103 [name] => localhost.localdomain ) [93] => Array ( [groupid] => 104 [name] => (vm) ) [94] => Array ( [groupid] => 105 [name] => 112 ) [95] => Array ( [groupid] => 106 [name] => Mikrotik-Router ) [96] => Array ( [groupid] => 107 [name] => Vibory ) [97] => Array ( [groupid] => 108 [name] => IBM Servers ) [98] => Array ( [groupid] => 9 [name] => broadband ) [99] => Array ( [groupid] => 111 [name] => Vybory2016 ) [100] => Array ( [groupid] => 109 [name] => Network ) [101] => Array ( [groupid] => 112 [name] => vibory408p ) [102] => Array ( [groupid] => 110 [name] => vibory403p ) ) 10. template.get [hosts.php:1029] Parameters: Array ( [output] => Array ( [0] => templateid [1] => name ) [templateids] => Array ( [0] => 14936 ) ) Result: Array ( [0] => Array ( [templateid] => 14936 [name] => ma5600 ) ) 11. host.get [html.inc.php:243] Parameters: Array ( [output] => Array ( [0] => hostid [1] => status [2] => proxy_hostid [3] => name [4] => maintenance_status [5] => flags [6] => available [7] => snmp_available [8] => jmx_available [9] => ipmi_available [10] => error [11] => snmp_error [12] => jmx_error [13] => ipmi_error ) [selectHostDiscovery] => Array ( [0] => ts_delete ) [hostids] => Array ( [0] => 16164 ) [editable] => 1 [selectApplications] => count [selectItems] => count [selectTriggers] => count [selectGraphs] => count [selectDiscoveries] => count [selectHttpTests] => count ) Result: Array ( [0] => Array ( [hostid] => 16164 [status] => 1 [proxy_hostid] => 0 [name] => ma1-gagarina28-seml [maintenance_status] => 0 [flags] => 0 [available] => 0 [snmp_available] => 0 [jmx_available] => 0 [ipmi_available] => 0 [error] => [snmp_error] => [jmx_error] => [ipmi_error] => [items] => 7 [discoveries] => 2 [triggers] => 7 [graphs] => 0 [httpTests] => 0 [applications] => 1 [hostDiscovery] => Array ( ) ) ) SQL (0.000336): SET search_path = 'public' hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:80 SQL (0.000289): SET bytea_output = escape hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:91 SQL (0.00389): SELECT 1 FROM information_schema.tables WHERE table_catalog='zabbix' AND table_schema='public' AND table_name='dbversion' hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → PostgresqlDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/PostgresqlDbBackend.php:41 SQL (0.000478): SELECT dv.mandatory,dv.optional FROM dbversion dv hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in include/classes/db/DbBackend.php:46 SQL (0.000873): SELECT NULL FROM config c hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkConfig() → DBselect() in include/classes/db/DbBackend.php:62 SQL (0.000298): BEGIN hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.001557): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='8545f821c62a85c771d133389eba453b' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1477379040 OR u.autologout=0) hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1197 SQL (0.00082): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid='4' AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0 hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → check_perm2system() → DBselect() in include/perm.inc.php:75 SQL (0.000507): UPDATE sessions SET lastaccess=1477379040 WHERE userid='4' AND sessionid='8545f821c62a85c771d133389eba453b' hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBexecute() in include/classes/api/services/CUser.php:1222 SQL (0.000834): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='4' AND g.usrgrpid=ug.usrgrpid hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DBselect() in include/classes/api/services/CUser.php:1230 SQL (0.000696): 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='4' hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1254 SQL (0.000553): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='4' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1 hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1262 SQL (0.000263): COMMIT hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.009296): SELECT p.* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid hosts.php:40 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:42 SQL (0.000743): SELECT c.* FROM config c hosts.php:40 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33 SQL (0.000357): BEGIN hosts.php:127 → CFrontendApiWrapper->isWritable() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.001285): SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1,3) hosts.php:127 → CFrontendApiWrapper->isWritable() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->isWritable() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000265): COMMIT hosts.php:127 → CFrontendApiWrapper->isWritable() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.000258): BEGIN hosts.php:652 → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.00049): SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1,3) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CHost->validateDelete() → CHost->checkPermissions() → CHost->isWritable() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.001095): SELECT i.itemid FROM items i WHERE i.flags=1 AND i.hostid='16164' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:222 SQL (0.000967): SELECT i.* FROM items i WHERE i.flags=1 AND i.itemid IN ('388703','388704') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:222 SQL (0.000521): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1,3) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CDiscoveryRule->get() → CDiscoveryRule->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.009597): SELECT i.itemid FROM items i WHERE i.templateid IN ('388703','388704') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → DBselect() in include/classes/api/services/CDiscoveryRule.php:369 SQL (0.000504): SELECT i.* FROM items i WHERE i.flags=1 AND 1=0 hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:222 SQL (0.007234): SELECT i.itemid FROM item_discovery id,items i WHERE i.itemid=id.itemid AND parent_itemid IN ('388703','388704') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → DBselect() in include/classes/api/services/CDiscoveryRule.php:394 SQL (0.000671): SELECT i.* FROM items i WHERE i.flags=2 AND i.itemid IN ('388705','388706') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItemPrototype->get() → DBselect() in include/classes/api/services/CItemPrototype.php:238 SQL (0.000487): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1,3) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItemPrototype->get() → CItemPrototype->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000384): SELECT itemid FROM items WHERE templateid IN ('388705','388706') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → DBselect() in include/classes/api/services/CItemPrototype.php:735 SQL (0.000466): SELECT i.* FROM items i WHERE i.flags=2 AND 1=0 hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItemPrototype->get() → DBselect() in include/classes/api/services/CItemPrototype.php:238 SQL (0.001405): SELECT DISTINCT g.graphid FROM graphs g,graphs_items gi WHERE g.flags=2 AND gi.graphid=g.graphid AND gi.itemid IN ('388705','388706') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CGraphPrototype->get() → DBselect() in include/classes/api/services/CGraphPrototype.php:302 SQL (0.010452): SELECT g.graphid,g.ymax_type FROM graphs g WHERE g.ymax_itemid IN ('388705','388706') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItemGeneral->checkGraphReference() → CItemGeneral->checkUseInGraphAxis() → DBselect() in include/classes/api/services/CItemGeneral.php:659 SQL (0.010053): SELECT g.graphid,g.ymin_type FROM graphs g WHERE g.ymin_itemid IN ('388705','388706') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItemGeneral->checkGraphReference() → CItemGeneral->checkUseInGraphAxis() → DBselect() in include/classes/api/services/CItemGeneral.php:659 SQL (0.011432): SELECT itemid FROM item_discovery WHERE parent_itemid IN ('388705','388706') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → DBselect() in include/classes/api/services/CItemPrototype.php:772 SQL (0.000703): SELECT i.itemid,i.name,i.templateid,i.flags,i.hostid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.itemid IN ('405058','405253','405254','405255','405256') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:355 SQL (0.000629): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1,3) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CItem->get() → CItem->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000469): SELECT i.itemid FROM items i WHERE i.templateid IN ('405058','405253','405254','405255','405256') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DBselect() in include/classes/api/services/CItem.php:590 SQL (0.001073): SELECT gi.graphid FROM graphs_items gi WHERE gi.itemid IN ('405058','405253','405254','405255','405256') AND NOT EXISTS (SELECT NULL FROM graphs_items gii WHERE gii.graphid=gi.graphid AND gii.itemid NOT IN ('405058','405253','405254','405255','405256')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DBselect() in include/classes/api/services/CItem.php:610 SQL (0.000393): SELECT g.graphid,g.ymax_type FROM graphs g WHERE g.ymax_itemid IN ('405058','405253','405254','405255','405256') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CItemGeneral->checkGraphReference() → CItemGeneral->checkUseInGraphAxis() → DBselect() in include/classes/api/services/CItemGeneral.php:659 SQL (0.000404): SELECT g.graphid,g.ymin_type FROM graphs g WHERE g.ymin_itemid IN ('405058','405253','405254','405255','405256') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CItemGeneral->checkGraphReference() → CItemGeneral->checkUseInGraphAxis() → DBselect() in include/classes/api/services/CItemGeneral.php:659 SQL (0.001375): SELECT DISTINCT t.triggerid FROM triggers t,functions f WHERE f.itemid IN ('405058','405253','405254','405255','405256') AND f.triggerid=t.triggerid AND t.flags IN ('0','4') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019 SQL (0.003431): SELECT triggerid FROM triggers WHERE templateid IN ('74688058','74688221','74688222','74688223','74688224') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → DBselect() in include/classes/api/services/CTrigger.php:704 SQL (0.000675): SELECT t.triggerid,t.description,t.expression FROM triggers t WHERE t.triggerid IN ('74688058','74688221','74688222','74688223','74688224') AND t.flags IN ('0','4') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019 SQL (0.006744): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN ('74688058','74688221','74688222','74688223','74688224') AND f.itemid=i.itemid hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:325 SQL (0.000484): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1,3) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000779): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.000414): UPDATE ids SET nextid=189204 WHERE table_name='auditlog' AND field_name='auditid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.055399): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('4','1477379040','80.82.56.203','2','13','74688058','Chassis _Fail H801MABC_0 0','189204') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000478): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.000409): UPDATE ids SET nextid=189205 WHERE table_name='auditlog' AND field_name='auditid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.000572): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('4','1477379040','80.82.56.203','2','13','74688221','Slot_Fail H801CITD_0_0 0.0','189205') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000442): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.000396): UPDATE ids SET nextid=189206 WHERE table_name='auditlog' AND field_name='auditid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.00793): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('4','1477379040','80.82.56.203','2','13','74688222','Slot_Fail VDM_0_2 0.2','189206') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000426): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.000383): UPDATE ids SET nextid=189207 WHERE table_name='auditlog' AND field_name='auditid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.000563): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('4','1477379040','80.82.56.203','2','13','74688223','Slot_Fail VDM_0_3 0.3','189207') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000395): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.00039): UPDATE ids SET nextid=189208 WHERE table_name='auditlog' AND field_name='auditid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.000591): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('4','1477379040','80.82.56.203','2','13','74688224','Slot_Fail H801SCUB_0_9 0.9','189208') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → add_audit_ext() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.192518): DELETE FROM profiles WHERE idx='web.events.filter.triggerid' AND (value_id IN ('74688058','74688221','74688222','74688223','74688224')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.003296): DELETE FROM sysmaps_elements WHERE (elementid IN ('74688058','74688221','74688222','74688223','74688224')) AND elementtype='2' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.021129): SELECT DISTINCT actionid FROM conditions WHERE conditiontype=2 AND (value IN ('74688221','74688058','74688224','74688223','74688222')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DBselect() in include/classes/api/services/CTrigger.php:797 SQL (0.016713): UPDATE actions SET status=1 WHERE 1=0 hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DBexecute() in include/classes/api/services/CTrigger.php:802 SQL (0.000507): DELETE FROM conditions WHERE conditiontype='2' AND (value IN ('74688058','74688221','74688222','74688223','74688224')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.000658): SELECT serviceid FROM services WHERE triggerid IN ('74688058','74688221','74688222','74688223','74688224') LIMIT 1 OFFSET 0 hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->deleteByIds() → CTrigger->usedInItServices() → DBselect() in include/classes/api/services/CTrigger.php:1977 SQL (0.008327): DELETE FROM triggers WHERE (triggerid IN ('74688058','74688221','74688222','74688223','74688224')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTrigger->delete() → CTrigger->deleteByIds() → CApiService->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.000756): SELECT DISTINCT t.triggerid FROM triggers t,functions f WHERE t.flags=2 AND f.itemid IN ('405058','405253','405254','405255','405256') AND f.triggerid=t.triggerid hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:380 SQL (0.001802): DELETE FROM screens_items WHERE (resourceid IN ('405058','405253','405254','405255','405256')) AND (resourcetype IN ('1','3','7')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.125789): DELETE FROM items WHERE (itemid IN ('405058','405253','405254','405255','405256')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.00222): DELETE FROM profiles WHERE idx='web.favorite.graphids' AND source='itemid' AND (value_id IN ('405058','405253','405254','405255','405256')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.00104): SELECT nextid FROM ids WHERE table_name='housekeeper' AND field_name='housekeeperid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.004083): UPDATE ids SET nextid=1289869 WHERE table_name='housekeeper' AND field_name='housekeeperid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.066408): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid','405058','1289835') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000419): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid','405058','1289836') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000339): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid','405058','1289837') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000488): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid','405058','1289838') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000439): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid','405058','1289839') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000495): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid','405058','1289840') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000432): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid','405058','1289841') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000432): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid','405256','1289842') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000445): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid','405256','1289843') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000416): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid','405256','1289844') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000419): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid','405256','1289845') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.00042): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid','405256','1289846') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000417): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid','405256','1289847') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000472): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid','405256','1289848') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000446): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid','405254','1289849') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000416): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid','405254','1289850') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000413): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid','405254','1289851') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000416): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid','405254','1289852') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000416): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid','405254','1289853') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000409): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid','405254','1289854') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.00032): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid','405254','1289855') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000329): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid','405253','1289856') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.00053): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid','405253','1289857') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000425): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid','405253','1289858') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000437): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid','405253','1289859') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000422): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid','405253','1289860') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000423): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid','405253','1289861') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000405): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid','405253','1289862') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000418): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends','itemid','405255','1289863') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000423): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('trends_uint','itemid','405255','1289864') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000348): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_text','itemid','405255','1289865') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000347): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_log','itemid','405255','1289866') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000351): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_uint','itemid','405255','1289867') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000332): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history_str','itemid','405255','1289868') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000351): INSERT INTO housekeeper (tablename,field,value,housekeeperid) VALUES ('history','itemid','405255','1289869') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CItem->delete() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000844): SELECT DISTINCT t.triggerid FROM triggers t,functions f WHERE t.flags=2 AND f.itemid IN ('388705','388706') AND f.triggerid=t.triggerid hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:380 SQL (0.000381): SELECT triggerid FROM triggers WHERE templateid IN ('74684495','74684496') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → DBselect() in include/classes/api/services/CTriggerPrototype.php:620 SQL (0.003723): SELECT triggerid FROM trigger_discovery WHERE parent_triggerid IN ('74684495','74684496') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → DBselect() in include/classes/api/services/CTriggerPrototype.php:633 SQL (0.000417): SELECT triggerid FROM triggers WHERE templateid IN ('74688058','74688221','74688222','74688223','74688224') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → DBselect() in include/classes/api/services/CTrigger.php:704 SQL (0.000443): SELECT t.triggerid,t.description,t.expression FROM triggers t WHERE t.triggerid IN ('74688058','74688221','74688222','74688223','74688224') AND t.flags IN ('0','4') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1019 SQL (0.001996): DELETE FROM profiles WHERE idx='web.events.filter.triggerid' AND (value_id IN ('74688058','74688221','74688222','74688223','74688224')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.001575): DELETE FROM sysmaps_elements WHERE (elementid IN ('74688058','74688221','74688222','74688223','74688224')) AND elementtype='2' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.000467): SELECT DISTINCT actionid FROM conditions WHERE conditiontype=2 AND (value IN ('74688221','74688222','74688223','74688224','74688058')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DBselect() in include/classes/api/services/CTrigger.php:797 SQL (0.000376): UPDATE actions SET status=1 WHERE 1=0 hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DBexecute() in include/classes/api/services/CTrigger.php:802 SQL (0.00035): DELETE FROM conditions WHERE conditiontype='2' AND (value IN ('74688058','74688221','74688222','74688223','74688224')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.000418): SELECT serviceid FROM services WHERE triggerid IN ('74688058','74688221','74688222','74688223','74688224') LIMIT 1 OFFSET 0 hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->deleteByIds() → CTrigger->usedInItServices() → DBselect() in include/classes/api/services/CTrigger.php:1977 SQL (0.000423): DELETE FROM triggers WHERE (triggerid IN ('74688058','74688221','74688222','74688223','74688224')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTrigger->delete() → CTrigger->deleteByIds() → CApiService->deleteByIds() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.000485): SELECT t.triggerid,t.description,t.expression FROM triggers t WHERE t.flags=2 AND t.triggerid IN ('74684495','74684496') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTriggerPrototype->get() → DBselect() in include/classes/api/services/CTriggerPrototype.php:380 SQL (0.000651): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN ('74684495','74684496') AND f.itemid=i.itemid hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:325 SQL (0.000514): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1,3) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → CTriggerPrototype->get() → CTriggerPrototype->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000436): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.00041): UPDATE ids SET nextid=189209 WHERE table_name='auditlog' AND field_name='auditid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.00065): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('4','1477379041','80.82.56.203','2','31','74684495','Slot_Fail {#SNMPVALUE} {#SNMPINDEX}:{143357}=3','189209') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → add_audit_ext() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.000405): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:114 SQL (0.000414): UPDATE ids SET nextid=189210 WHERE table_name='auditlog' AND field_name='auditid' hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → add_audit_ext() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:128 SQL (0.000799): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('4','1477379041','80.82.56.203','2','31','74684496','Chassis _Fail {#SNMPVALUE} {#SNMPINDEX}:{143358}<>1','189210') hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → add_audit_ext() → DB::insert() → DBexecute() in include/classes/db/DB.php:440 SQL (0.02372): DELETE FROM triggers WHERE (triggerid IN ('74684495','74684496')) hosts.php:654 → CFrontendApiWrapper->delete() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->delete() → CDiscoveryRule->delete() → CItemPrototype->delete() → CTriggerPrototype->delete() → DB::delete() → DBexecute() in include/classes/db/DB.php:817 SQL (0.000477): ROLLBACK hosts.php:655 → DBend() → DBrollback() → DBexecute() in include/db.inc.php:339 SQL (0.000329): BEGIN hosts.php:720 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.016783): SELECT g.groupid,g.name FROM groups g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN ('0','1') AND g.groupid=hg.groupid) ORDER BY g.name hosts.php:720 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:324 SQL (0.000276): COMMIT hosts.php:720 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.00029): BEGIN hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.000825): SELECT h.hostid,h.proxy_hostid,h.host,h.name,h.status,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.flags,h.description,h.tls_connect,h.tls_accept,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1) hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000447): SELECT t.hostgroupid,t.hostid,t.groupid FROM hosts_groups t WHERE t.hostid='16164' hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318 SQL (0.000427): SELECT g.groupid FROM groups g WHERE g.groupid IN ('44','68','84') hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:324 SQL (0.000657): SELECT t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid='16164' hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:318 SQL (0.000479): SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND h.hostid='14936' hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261 SQL (0.000616): SELECT hm.hostmacroid,hm.macro,hm.value,hm.hostid FROM hostmacro hm WHERE hm.hostid='16164' hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:212 SQL (0.001534): SELECT t.* FROM host_inventory t WHERE t.hostid='16164' hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350 SQL (0.000494): SELECT hd.hostid,hd2.parent_itemid FROM host_discovery hd,host_discovery hd2 WHERE hd.hostid='16164' AND hd.parent_hostid=hd2.hostid hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → DBselect() in include/classes/api/services/CHost.php:1486 SQL (0.000445): SELECT i.itemid,i.name FROM items i WHERE i.flags=1 AND 1=0 hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:222 SQL (0.000255): COMMIT hosts.php:853 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.00028): BEGIN hosts.php:870 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.000851): SELECT hi.interfaceid,hi.main,hi.type,hi.useip,hi.ip,hi.dns,hi.port,hi.bulk FROM interface hi WHERE hi.hostid='16164' ORDER BY hi.interfaceid hosts.php:870 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:160 SQL (0.000635): SELECT i.itemid,i.type,i.interfaceid FROM items i WHERE i.type<>9 AND i.interfaceid IN ('12005','12006') hosts.php:870 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostInterface->get() → CHostInterface->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:355 SQL (0.000322): COMMIT hosts.php:870 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.000259): BEGIN hosts.php:971 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.000724): SELECT i.itemid,i.inventory_link,i.hostid,i.name,i.key_ FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid='16164' AND i.inventory_link BETWEEN '1' AND '70' hosts.php:971 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:355 SQL (0.000333): COMMIT hosts.php:971 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.000534): BEGIN hosts.php:992 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.000578): SELECT h.hostid,h.host FROM hosts h WHERE h.status IN (5,6) hosts.php:992 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CProxy->get() → DBselect() in include/classes/api/services/CProxy.php:128 SQL (0.000307): COMMIT hosts.php:992 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.000497): BEGIN hosts.php:1019 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.000699): SELECT g.groupid FROM groups g hosts.php:1019 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:324 SQL (0.000384): COMMIT hosts.php:1019 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.000315): BEGIN hosts.php:1022 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.000538): SELECT g.groupid,g.name FROM groups g hosts.php:1022 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:324 SQL (0.000293): COMMIT hosts.php:1022 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.000334): BEGIN hosts.php:1029 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.001228): SELECT h.hostid,h.templateid,h.name FROM hosts h WHERE h.status=3 AND h.hostid='14936' hosts.php:1029 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:261 SQL (0.000306): COMMIT hosts.php:1029 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310 SQL (0.000282): BEGIN hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:249 SQL (0.00209): SELECT h.hostid,h.status,h.proxy_hostid,h.name,h.maintenance_status,h.flags,h.available,h.snmp_available,h.jmx_available,h.ipmi_available,h.error,h.snmp_error,h.jmx_error,h.ipmi_error FROM hosts h WHERE h.flags IN (0,4) AND h.hostid='16164' AND h.status IN (0,1) hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:434 SQL (0.000616): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid='16164' GROUP BY i.hostid hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:355 SQL (0.000463): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i WHERE i.flags=1 AND i.hostid='16164' GROUP BY i.hostid hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:222 SQL (0.00111): SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid='16164' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4') GROUP BY i.hostid hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTrigger->get() → DBselect() in include/classes/api/services/CTrigger.php:425 SQL (0.001163): SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid='16164' AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:296 SQL (0.000923): SELECT COUNT(DISTINCT ht.httptestid) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid='16164' GROUP BY ht.hostid hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHttpTest->get() → DBselect() in include/classes/api/services/CHttpTest.php:203 SQL (0.000726): SELECT COUNT(DISTINCT a.applicationid) AS rowscount,a.hostid FROM applications a WHERE a.hostid='16164' GROUP BY a.hostid hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApplication->get() → DBselect() in include/classes/api/services/CApplication.php:209 SQL (0.000404): SELECT t.hostid,t.ts_delete FROM host_discovery t WHERE t.hostid='16164' hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350 SQL (0.000382): COMMIT hosts.php:1130 → CView->render() → include() → get_header_host_table() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:310