2024-11-29 19:04:45 更新了水表 25300015 的 switch_status 为 3
2024-11-29 19:04:45 执行了插入操作：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, '2024-11-29 00:00:00', '2024-11-29 19:04:45', 0, 0, 0)
2024-11-29 19:04:45 更新了水表 25300071 的 switch_status 为 3
2024-11-29 19:04:45 执行了插入操作：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, '2024-11-29 00:00:00', '2024-11-29 19:04:45', 0, 0, 0)
2024-11-29 19:04:45 更新了水表 25300094 的 switch_status 为 3
2024-11-29 19:04:45 执行了插入操作：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, '2024-11-29 00:00:00', '2024-11-29 19:04:45', 0, 0, 0)
2024-11-29 19:04:45 更新了水表 25300101 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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-11-29 00:00:00', '2024-11-29 19:04:45', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25300135 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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 ('623903029', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903029'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903029') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25300223 的 switch_status 为 2
2024-11-29 19:04:46 执行了插入操作：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 ('623903267', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903267'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903267') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25300234 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25300306 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25300315 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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 ('623903509', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903509'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903509') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25300324 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25300327 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)
2024-11-29 19:04:46 更新了水表 25301367 的 switch_status 为 3
2024-11-29 19:04:46 执行了插入操作：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-11-29 00:00:00', '2024-11-29 19:04:46', 0, 0, 0)