2026-01-12 04:50:47 更新了水表 25300010 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300029 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300053 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300068 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300072 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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 ('623902834', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902834'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902834') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300075 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300094 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300101 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300117 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300141 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300150 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300160 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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 ('623903072', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903072'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903072') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300354 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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 ('623903572', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903572'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903572') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300355 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300356 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25300359 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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 ('623903577', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903577'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903577') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25301229 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 04:50:47 更新了水表 25301467 的 switch_status 为 3 2026-01-12 04:50:47 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 04:50:47', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300010 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300029 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300053 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300068 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300072 的 switch_status 为 3 2026-01-12 12:55: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 ('623902834', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902834'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902834') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300117 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300150 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300355 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25300356 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25301229 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 12:55:43 更新了水表 25301467 的 switch_status 为 3 2026-01-12 12:55: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 ('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, '2026-01-12 00:00:00', '2026-01-12 12:55:43', 0, 0, 0) 2026-01-12 15:31:19 更新了水表 25300010 的 switch_status 为 3 2026-01-12 15:31:19 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 15:31:19', 0, 0, 0) 2026-01-12 15:31:19 更新了水表 25300072 的 switch_status 为 3 2026-01-12 15:31:19 执行了插入操作: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 ('623902834', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902834'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902834') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-12 00:00:00', '2026-01-12 15:31:19', 0, 0, 0) 2026-01-12 15:31:19 更新了水表 25300117 的 switch_status 为 3 2026-01-12 15:31:19 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 15:31:19', 0, 0, 0) 2026-01-12 15:31:19 更新了水表 25300355 的 switch_status 为 3 2026-01-12 15:31:19 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 15:31:19', 0, 0, 0) 2026-01-12 15:31:19 更新了水表 25301229 的 switch_status 为 3 2026-01-12 15:31:19 执行了插入操作: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, '2026-01-12 00:00:00', '2026-01-12 15:31:19', 0, 0, 0)