Array ( [0] => 0002 [1] => 0000 [2] => 0000 [3] => 0000 [4] => 0000 [5] => 0000 [6] => 0000 [7] => 0000 [8] => 0000 [9] => 0000 [10] => 01d6 [11] => 0000 [12] => 0424 [13] => 0000 [14] => 0000 [15] => 0000 [16] => 0000 [17] => 0ac9 [18] => 0064 [19] => 09a2 [20] => 0000 [21] => 0000 [22] => 04af [23] => 176f [24] => 0000 [25] => 016e [26] => 0176 [27] => 0023 [28] => 0000 [29] => 0000 [30] => 0000 [31] => 0000 [32] => 0000 [33] => 0000 [34] => 0008 [35] => 000f [36] => 0000 [37] => 0000 [38] => 0000 [39] => 0000 [40] => 0000 [41] => 0000 [42] => 0000 [43] => 0000 [44] => 4e25 [45] => 0001 [46] => 0000 [47] => 0000 [48] => 0000 [49] => 0000 [50] => 0000 [51] => 2c17 [52] => 0000 [53] => 0000 [54] => 0000 [55] => 0000 [56] => 0000 [57] => 0000 [58] => 0000 [59] => 097f [60] => 0000 [61] => 0002 [62] => 0000 [63] => 11cc [64] => 0000 [65] => 0000 [66] => 0000 [67] => 099c [68] => 0000 [69] => 0000 [70] => 0000 [71] => 0000 [72] => 0000 [73] => 0000 [74] => 01fe [75] => 0000 [76] => 0208 [77] => 0000 [78] => 01fe [79] => 0000 [80] => 0000 [81] => 0000 [82] => 0010 [83] => 0000 [84] => 0013 [85] => 0000 [86] => 0002 [87] => 0000 [88] => 1ef9 [89] => 0000 [90] => 0000 [91] => 0001 [92] => 0000 [93] => 0000 [94] => 0000 [95] => 0000 [96] => 0000 [97] => 0000 [98] => 0000 [99] => 0000 [100] => 0000 [101] => 0000 [102] => 0000 [103] => 0000 [104] => 0000 [105] => 0000 [106] => 0000 [107] => 0000 [108] => 0000 [109] => 0000 [110] => 0000 [111] => 0000 [112] => 0000 [113] => 0000 [114] => 0000 [115] => 0000 [116] => 0000 [117] => 0000 [118] => 0000 [119] => 0000 [120] => 0000 [121] => 0000 [122] => 0000 [123] => 0000 [124] => 0000 [125] => 0000 [126] => 0000 [127] => 0000 [128] => 0000 [129] => 0000 [130] => 0000 [131] => 0000 [132] => 0000 [133] => 0000 [134] => 0000 [135] => 0000 [136] => 0000 [137] => 0000 [138] => 0000 [139] => 0000 [140] => 0000 [141] => 0000 [142] => 0000 [143] => 0000 [144] => 0000 [145] => 0000 [146] => 0000 [147] => 0000 [148] => 0000 [149] => 0000 [150] => 0000 [151] => 0000 [152] => 0000 [153] => 0000 [154] => 0000 [155] => 0000 [156] => 0000 [157] => 0000 [158] => 0000 [159] => 0000 [160] => 0000 [161] => 0000 [162] => 0000 [163] => 0000 [164] => 0000 [165] => 0000 [166] => 0000 [167] => 0000 [168] => 0000 [169] => 0000 [170] => 0000 [171] => 0000 [172] => 0000 [173] => 0000 [174] => 0000 [175] => 0000 [176] => 0000 [177] => 0000 [178] => 0000 [179] => 0000 [180] => 0000 [181] => 0000 [182] => 0000 [183] => 0000 [184] => 0000 [185] => 0000 [186] => 0000 [187] => 0000 [188] => 0401 [189] => 2400 [190] => 0000 [191] => 0000 [192] => 0000 [193] => 0000 [194] => 0000 [195] => 0000 [196] => 0000 [197] => 0000 [198] => 0000 [199] => 0000 [200] => 0000 [201] => 0000 [202] => 0000 [203] => 0000 [204] => 0000 [205] => 0000 [206] => 0000 [207] => 0000 [208] => 0000 [209] => 0000 [210] => 0000 [211] => 0000 [212] => 0000 [213] => 0000 [214] => 0000 [215] => 0000 [216] => 0048 [217] => 0000 [218] => 0000 [219] => 0000 [220] => 0000 [221] => 3230 [222] => 3030 [223] => 302e [224] => ff00 )
CREATE TABLE if not exists ir ( serial text , dt text , SystemStatusId text --0 , Vpv1 num --1 0.1V , Ppv1 num --3,4 0.1W , Buck1Cur num --7 0.1A , OP_Watt num --9 0.1W , OP_VA num --11 0.1VA , ACChr_Watt num --13 0.1VA , ACChr_VA num --15 0.1VA , BatVolt num --17 , BatSOC num --18 % , BusVolt num --19 0.1V , GridVolt num --20 0.1V , LineFreq num --21 0.01Hz , OutputFreq num --23 , WorkTime num --30,31 , AC_InWatt num --36-37 0.1W , AC_InVA num --38-39 0.1W , Epv1_today num --48,49 0.1kWh , Epv1_total num --50,51 0.1kWh , Eac_chrToday num --56-57 0.1kWh , Eac_chrTotal num --58-59 0.1kWh , Ebat_dischrToday num --60,61 0.1kWh , Ebat_dischrTotal num --62,63 0.1kWh , Eac_dischrToday num --64-65 0.1kWh , Eac_dischrTotal num --66-67 0.1kWh , Bat_Watt num --77 0.1W , Eop_dischrToday num --85-86 0.1kWh , Eop_dischrTotal num --87-88 0.1kWh , PRIMARY KEY(serial, dt) )
insert or ignore into ir values( 'UKDGBMF010', '2025-07-07 18:12:03', '2', 0, 0, 0, 47, 106, 0, 0, 27.61, 100, 246.6, 0, 0, 119.9, 0, 0, 0, 0, 1128.7, 0, 243.1, 0.2, 455.6, 0, 246, 51, 0.2, 792.9 )