2024-07-08 05:24:59 更新了水表 25300101 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623902977', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902977'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902977') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300306 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903494', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903494'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903494') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300324 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903524', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903524'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903524') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300327 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903527', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903527'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903527') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300332 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903538', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903538'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903538') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300368 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903592', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903592'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903592') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300383 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903619', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903619'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903619') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300398 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903640', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903640'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903640') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300445 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903813', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903813'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903813') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300447 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903815', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903815'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903815') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300457 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903831', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903831'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903831') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300458 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903832', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903832'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903832') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300463 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903843', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903843'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903843') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:24:59 更新了水表 25300517 的 switch_status 为 3
2024-07-08 05:24:59 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623904023', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623904023'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623904023') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:24:59', 0, 0, 0)
2024-07-08 05:25:00 更新了水表 25301220 的 switch_status 为 3
2024-07-08 05:25:00 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907360', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907360'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907360') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:25:00', 0, 0, 0)
2024-07-08 05:25:00 更新了水表 25301228 的 switch_status 为 3
2024-07-08 05:25:00 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907368', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907368'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907368') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:25:00', 0, 0, 0)
2024-07-08 05:25:00 更新了水表 25301229 的 switch_status 为 3
2024-07-08 05:25:00 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907369', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907369'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907369') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:25:00', 0, 0, 0)
2024-07-08 05:25:00 更新了水表 25301342 的 switch_status 为 3
2024-07-08 05:25:00 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907650', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907650'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907650') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:25:00', 0, 0, 0)
2024-07-08 05:25:00 更新了水表 25301367 的 switch_status 为 3
2024-07-08 05:25:00 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907687', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907687'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907687') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:25:00', 0, 0, 0)
2024-07-08 05:25:00 更新了水表 25301467 的 switch_status 为 3
2024-07-08 05:25:00 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907943', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907943'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907943') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 05:25:00', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25300306 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903494', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903494'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903494') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25300368 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903592', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903592'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903592') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25300383 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903619', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903619'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903619') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25300445 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903813', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903813'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903813') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25300458 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903832', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903832'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903832') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25301220 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907360', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907360'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907360') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25301228 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907368', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907368'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907368') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25301229 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907369', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907369'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907369') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25301342 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907650', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907650'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907650') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25301367 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907687', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907687'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907687') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:34:25 更新了水表 25301467 的 switch_status 为 3
2024-07-08 09:34:25 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623907943', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907943'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907943') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:34:25', 0, 0, 0)
2024-07-08 09:42:19 更新了水表 25300332 的 switch_status 为 3
2024-07-08 09:42:19 执行了插入操作：INSERT INTO emac.watermeter_log (mac_addr, ton, switch_status, pin_status, bw, factor, preamble, freq_rx, freq_tx, waittime, battery, server_updatetime, node_updatetime, jizhongqi_id, dog_flag, rssi) 
                          VALUES ('623903538', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903538'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903538') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-07-08 00:00:00', '2024-07-08 09:42:19', 0, 0, 0)