2024-08-31 21:02:43 更新了水表 22110073 的 switch_status 为 2
2024-08-31 21:02:43 执行了插入操作：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 ('571539571', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '571539571'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '571539571') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 22110094 的 switch_status 为 2
2024-08-31 21:02:43 执行了插入操作：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 ('571539604', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '571539604'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '571539604') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300012 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623902738', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902738'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902738') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300015 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300071 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300093 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300094 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300101 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300135 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300234 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300237 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903287', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903287'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903287') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300306 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300315 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300324 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300327 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300332 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903538', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903538'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903538') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300337 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903543', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903543'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903543') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300338 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903544', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903544'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903544') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300339 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903545', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903545'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903545') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300353 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903571', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903571'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903571') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300362 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903586', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903586'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903586') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300368 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903592', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903592'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903592') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300382 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903618', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903618'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903618') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300383 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903619', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903619'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903619') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300395 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903637', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903637'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903637') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300398 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903640', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903640'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903640') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300410 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903760', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903760'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903760') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300428 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903784', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903784'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903784') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300445 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903813', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903813'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903813') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300447 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903815', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903815'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903815') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300450 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903824', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903824'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903824') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300455 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903829', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903829'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903829') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300457 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903831', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903831'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903831') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300458 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903832', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903832'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903832') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300463 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903843', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903843'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903843') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 25300487 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('623903879', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903879'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903879') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 2404110112345680 的 switch_status 为 2
2024-08-31 21:02:43 执行了插入操作：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-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)
2024-08-31 21:02:43 更新了水表 2404110112345696 的 switch_status 为 3
2024-08-31 21:02:43 执行了插入操作：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 ('2595217981570307734', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '2595217981570307734'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '2595217981570307734') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-08-31 00:00:00', '2024-08-31 21:02:43', 0, 0, 0)