2025-07-10 22:33:21 更新了水表 25300010 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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 ('623902736', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902736'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902736') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300029 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300053 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300068 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300075 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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 ('623902837', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902837'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902837') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300082 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300094 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300117 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300141 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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 ('623903041', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903041'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903041') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300150 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300234 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300261 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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 ('623903329', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903329'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903329') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300355 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:21 更新了水表 25300356 的 switch_status 为 3 2025-07-10 22:33:21 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:21', 0, 0, 0) 2025-07-10 22:33:22 更新了水表 25301220 的 switch_status 为 3 2025-07-10 22:33:22 执行了插入操作: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, '2025-07-10 00:00:00', '2025-07-10 22:33:22', 0, 0, 0) 2025-07-10 22:33:22 更新了水表 25301342 的 switch_status 为 3 2025-07-10 22:33:22 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:22', 0, 0, 0) 2025-07-10 22:33:22 更新了水表 25301367 的 switch_status 为 3 2025-07-10 22:33:22 执行了插入操作: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, '2025-07-10 00:00:00', '2025-07-10 22:33:22', 0, 0, 0) 2025-07-10 22:33:29 更新了水表 25300234 的 switch_status 为 3 2025-07-10 22:33:29 执行了插入操作: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-07-10 00:00:00', '2025-07-10 22:33:29', 0, 0, 0)