2025-03-02 05:20:30 更新了水表 25300013 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902739', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902739'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902739') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300015 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902741', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902741'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902741') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300029 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902761', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902761'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902761') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300046 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902790', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902790'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902790') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300053 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902803', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902803'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902803') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300071 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902833', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902833'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902833') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300075 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902837', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902837'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902837') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300093 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902867', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902867'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902867') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300094 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623902868', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902868'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902868') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300101 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300141 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903041', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903041'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903041') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300144 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903044', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903044'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903044') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300150 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903056', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903056'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903056') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300160 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903072', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903072'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903072') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300165 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903077', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903077'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903077') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300203 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903235', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903235'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903235') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300234 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903284', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903284'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903284') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300251 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903313', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903313'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903313') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300354 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903572', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903572'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903572') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300355 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903573', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903573'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903573') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300356 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903574', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903574'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903574') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300359 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903577', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903577'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903577') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300400 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623903744', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903744'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903744') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25300555 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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 ('623904085', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623904085'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623904085') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25301229 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25301342 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25301367 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25301451 的 switch_status 为 2
2025-03-02 05:20:30 执行了插入操作：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 ('623907921', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623907921'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623907921') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 05:20:30 更新了水表 25301467 的 switch_status 为 3
2025-03-02 05:20:30 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 05:20:30', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300029 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623902761', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902761'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902761') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300046 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623902790', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902790'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902790') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300053 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623902803', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902803'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902803') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300093 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623902867', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902867'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902867') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300150 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623903056', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903056'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903056') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300234 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623903284', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903284'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903284') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300355 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623903573', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903573'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903573') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25300356 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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 ('623903574', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903574'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903574') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25301229 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25301342 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 08:09:47 更新了水表 25301467 的 switch_status 为 3
2025-03-02 08:09:47 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 08:09:47', 0, 0, 0)
2025-03-02 10:49:13 更新了水表 25300029 的 switch_status 为 3
2025-03-02 10:49:13 执行了插入操作：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 ('623902761', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902761'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902761') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 10:49:13', 0, 0, 0)
2025-03-02 10:49:13 更新了水表 25300053 的 switch_status 为 3
2025-03-02 10:49:13 执行了插入操作：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 ('623902803', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902803'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902803') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 10:49:13', 0, 0, 0)
2025-03-02 10:49:14 更新了水表 25300355 的 switch_status 为 3
2025-03-02 10:49:14 执行了插入操作：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 ('623903573', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903573'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903573') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 10:49:14', 0, 0, 0)
2025-03-02 11:40:37 更新了水表 25300093 的 switch_status 为 3
2025-03-02 11:40:37 执行了插入操作：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 ('623902867', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902867'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902867') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 11:40:37', 0, 0, 0)
2025-03-02 11:40:37 更新了水表 25300234 的 switch_status 为 3
2025-03-02 11:40:37 执行了插入操作：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 ('623903284', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903284'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903284') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-03-02 00:00:00', '2025-03-02 11:40:37', 0, 0, 0)
2025-03-02 11:40:37 更新了水表 25301467 的 switch_status 为 3
2025-03-02 11:40:37 执行了插入操作：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, '2025-03-02 00:00:00', '2025-03-02 11:40:37', 0, 0, 0)