Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => [13] => [14] => [15] => [16] => [17] => [18] => [19] => [20] => [21] => [22] => [23] => [24] => [25] => [26] => [27] => [28] => [29] => [30] => [31] => [32] => [33] => [34] => [35] => [36] => [37] => [38] => [39] => [40] => [41] => [42] => [43] => [44] => [45] => 0001 [46] => 0000 [47] => 0000 [48] => 0000 [49] => 0000 [50] => 0000 [51] => 2bde [52] => 0000 [53] => 0000 [54] => 0000 [55] => 0000 [56] => 0000 [57] => 0000 [58] => 0000 [59] => 0abc [60] => 0000 [61] => 0000 [62] => 0000 [63] => 1f78 [64] => 0000 [65] => 0006 [66] => 0000 [67] => 0e3f [68] => 0000 [69] => 0000 [70] => 0000 [71] => 0000 [72] => 0000 [73] => 0000 [74] => 01d6 [75] => 0000 [76] => 0226 [77] => 0000 [78] => 01fe [79] => 0000 [80] => 0000 [81] => 0000 [82] => 0010 [83] => 0000 [84] => 0015 [85] => 0000 [86] => 0006 [87] => 0000 [88] => 301a [89] => 0000 [90] => [91] => [92] => [93] => [94] => [95] => [96] => [97] => [98] => [99] => [100] => [101] => [102] => [103] => [104] => [105] => [106] => [107] => [108] => [109] => [110] => [111] => [112] => [113] => [114] => [115] => [116] => [117] => [118] => [119] => [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] => 0100 [222] => 0300 [223] => 0000 [224] => 0000 )
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', '2026-08-15 11:12:30', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1123, 0, 274.8, 0, 805.6, 0.6, 364.7, 51, 0.6, 1231.4 )