2025-11-24 08:01:07 更新了水表 25300029 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300053 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300071 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300072 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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 ('623902834', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902834'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902834') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300094 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300117 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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 ('623902999', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902999'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902999') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300150 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300234 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 08:01:07 更新了水表 25300355 的 switch_status 为 3
2025-11-24 08:01:07 执行了插入操作：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-11-24 00:00:00', '2025-11-24 08:01:07', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300029 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300053 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300072 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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 ('623902834', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902834'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902834') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300117 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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 ('623902999', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902999'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902999') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300150 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300234 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300355 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)
2025-11-24 15:09:17 更新了水表 25300356 的 switch_status 为 3
2025-11-24 15:09:17 执行了插入操作：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-11-24 00:00:00', '2025-11-24 15:09:17', 0, 0, 0)