2024-12-06 06:47:52 更新了水表 25300234 的 switch_status 为 3
2024-12-06 06:47:52 执行了插入操作：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, '2024-12-06 00:00:00', '2024-12-06 06:47:52', 0, 0, 0)
2024-12-06 06:47:52 更新了水表 25301220 的 switch_status 为 3
2024-12-06 06:47:52 执行了插入操作：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-12-06 00:00:00', '2024-12-06 06:47:52', 0, 0, 0)
2024-12-06 06:47:52 更新了水表 25301367 的 switch_status 为 3
2024-12-06 06:47:52 执行了插入操作：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-12-06 00:00:00', '2024-12-06 06:47:52', 0, 0, 0)
2024-12-06 06:47:52 更新了水表 25301467 的 switch_status 为 3
2024-12-06 06:47:52 执行了插入操作：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-12-06 00:00:00', '2024-12-06 06:47:52', 0, 0, 0)
2024-12-06 06:47:52 更新了水表 2404110112345680 的 switch_status 为 2
2024-12-06 06:47:52 执行了插入操作：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 ('2595217981570307712', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '2595217981570307712'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '2595217981570307712') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-12-06 00:00:00', '2024-12-06 06:47:52', 0, 0, 0)