2025-09-23 00:59:06 更新了水表 25300029 的 switch_status 为 3
2025-09-23 00:59:06 执行了插入操作：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-09-23 00:00:00', '2025-09-23 00:59:06', 0, 0, 0)
2025-09-23 00:59:06 更新了水表 25300053 的 switch_status 为 3
2025-09-23 00:59:06 执行了插入操作：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-09-23 00:00:00', '2025-09-23 00:59:06', 0, 0, 0)
2025-09-23 00:59:06 更新了水表 25300068 的 switch_status 为 3
2025-09-23 00:59:06 执行了插入操作：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 ('623902824', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902824'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902824') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-09-23 00:00:00', '2025-09-23 00:59:06', 0, 0, 0)
2025-09-23 00:59:06 更新了水表 25300082 的 switch_status 为 3
2025-09-23 00:59:06 执行了插入操作：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 ('623902850', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902850'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902850') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-09-23 00:00:00', '2025-09-23 00:59:06', 0, 0, 0)
2025-09-23 00:59:06 更新了水表 25301229 的 switch_status 为 3
2025-09-23 00:59:06 执行了插入操作：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-09-23 00:00:00', '2025-09-23 00:59:06', 0, 0, 0)
2025-09-23 00:59:06 更新了水表 25301342 的 switch_status 为 3
2025-09-23 00:59:06 执行了插入操作：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-09-23 00:00:00', '2025-09-23 00:59:06', 0, 0, 0)
2025-09-23 00:59:06 更新了水表 25301467 的 switch_status 为 3
2025-09-23 00:59:06 执行了插入操作：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-09-23 00:00:00', '2025-09-23 00:59:06', 0, 0, 0)
2025-09-23 14:29:54 更新了水表 25300029 的 switch_status 为 3
2025-09-23 14:29:54 执行了插入操作：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-09-23 00:00:00', '2025-09-23 14:29:54', 0, 0, 0)
2025-09-23 14:29:54 更新了水表 25300053 的 switch_status 为 3
2025-09-23 14:29:54 执行了插入操作：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-09-23 00:00:00', '2025-09-23 14:29:54', 0, 0, 0)
2025-09-23 14:29:54 更新了水表 25300068 的 switch_status 为 3
2025-09-23 14:29:54 执行了插入操作：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 ('623902824', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902824'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902824') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-09-23 00:00:00', '2025-09-23 14:29:54', 0, 0, 0)
2025-09-23 14:29:55 更新了水表 25300355 的 switch_status 为 3
2025-09-23 14:29:55 执行了插入操作：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-09-23 00:00:00', '2025-09-23 14:29:55', 0, 0, 0)
2025-09-23 14:29:55 更新了水表 25301229 的 switch_status 为 3
2025-09-23 14:29:55 执行了插入操作：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-09-23 00:00:00', '2025-09-23 14:29:55', 0, 0, 0)
2025-09-23 14:29:55 更新了水表 25301342 的 switch_status 为 3
2025-09-23 14:29:55 执行了插入操作：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-09-23 00:00:00', '2025-09-23 14:29:55', 0, 0, 0)
2025-09-23 14:29:55 更新了水表 25301467 的 switch_status 为 3
2025-09-23 14:29:55 执行了插入操作：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-09-23 00:00:00', '2025-09-23 14:29:55', 0, 0, 0)