2026-10-12 01:14:23 更新了水表 25300053 的 switch_status 为 3
2026-10-12 01:14:23 执行了插入操作：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-10-12 00:00:00', '2026-10-12 01:14:23', 0, 0, 0)
2026-10-12 01:14:23 更新了水表 25300072 的 switch_status 为 3
2026-10-12 01:14:23 执行了插入操作：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-10-12 00:00:00', '2026-10-12 01:14:23', 0, 0, 0)
2026-10-12 01:14:23 更新了水表 25300117 的 switch_status 为 3
2026-10-12 01:14:23 执行了插入操作：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-10-12 00:00:00', '2026-10-12 01:14:23', 0, 0, 0)
2026-10-12 01:14:23 更新了水表 25300354 的 switch_status 为 3
2026-10-12 01:14:23 执行了插入操作：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-10-12 00:00:00', '2026-10-12 01:14:23', 0, 0, 0)
2026-10-12 02:39:49 更新了水表 25300053 的 switch_status 为 3
2026-10-12 02:39:49 执行了插入操作：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-10-12 00:00:00', '2026-10-12 02:39:49', 0, 0, 0)
2026-10-12 02:39:49 更新了水表 25300117 的 switch_status 为 3
2026-10-12 02:39:49 执行了插入操作：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-10-12 00:00:00', '2026-10-12 02:39:49', 0, 0, 0)
2026-10-12 02:39:49 更新了水表 25300354 的 switch_status 为 3
2026-10-12 02:39:49 执行了插入操作：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-10-12 00:00:00', '2026-10-12 02:39:49', 0, 0, 0)
2026-10-12 09:45:21 更新了水表 25300053 的 switch_status 为 3
2026-10-12 09:45: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, '2026-10-12 00:00:00', '2026-10-12 09:45:21', 0, 0, 0)
2026-10-12 09:45:21 更新了水表 25300072 的 switch_status 为 3
2026-10-12 09:45: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 ('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-10-12 00:00:00', '2026-10-12 09:45:21', 0, 0, 0)
2026-10-12 09:45:21 更新了水表 25300117 的 switch_status 为 3
2026-10-12 09:45: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 ('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-10-12 00:00:00', '2026-10-12 09:45:21', 0, 0, 0)
2026-10-12 09:45:22 更新了水表 25300354 的 switch_status 为 3
2026-10-12 09:45: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 ('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-10-12 00:00:00', '2026-10-12 09:45:22', 0, 0, 0)
2026-10-12 11:42:10 更新了水表 25300053 的 switch_status 为 3
2026-10-12 11:42:10 执行了插入操作：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-10-12 00:00:00', '2026-10-12 11:42:10', 0, 0, 0)
2026-10-12 11:42:10 更新了水表 25300117 的 switch_status 为 3
2026-10-12 11:42:10 执行了插入操作：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-10-12 00:00:00', '2026-10-12 11:42:10', 0, 0, 0)
2026-10-12 11:42:10 更新了水表 25300354 的 switch_status 为 3
2026-10-12 11:42:10 执行了插入操作：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-10-12 00:00:00', '2026-10-12 11:42:10', 0, 0, 0)
2026-10-12 18:54:05 更新了水表 25300053 的 switch_status 为 3
2026-10-12 18:54:05 执行了插入操作：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-10-12 00:00:00', '2026-10-12 18:54:05', 0, 0, 0)
2026-10-12 18:54:05 更新了水表 25300072 的 switch_status 为 3
2026-10-12 18:54:05 执行了插入操作：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-10-12 00:00:00', '2026-10-12 18:54:05', 0, 0, 0)
2026-10-12 18:54:05 更新了水表 25300117 的 switch_status 为 3
2026-10-12 18:54:05 执行了插入操作：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-10-12 00:00:00', '2026-10-12 18:54:05', 0, 0, 0)
2026-10-12 18:54:05 更新了水表 25300354 的 switch_status 为 3
2026-10-12 18:54:05 执行了插入操作：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-10-12 00:00:00', '2026-10-12 18:54:05', 0, 0, 0)
2026-10-12 21:29:50 更新了水表 25300072 的 switch_status 为 3
2026-10-12 21:29:50 执行了插入操作：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-10-12 00:00:00', '2026-10-12 21:29:50', 0, 0, 0)
2026-10-12 21:29:50 更新了水表 25300117 的 switch_status 为 3
2026-10-12 21:29:50 执行了插入操作：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-10-12 00:00:00', '2026-10-12 21:29:50', 0, 0, 0)
2026-10-12 23:08:15 更新了水表 25300053 的 switch_status 为 3
2026-10-12 23:08:15 执行了插入操作：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-10-12 00:00:00', '2026-10-12 23:08:15', 0, 0, 0)
2026-10-12 23:08:15 更新了水表 25300354 的 switch_status 为 3
2026-10-12 23:08:15 执行了插入操作：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-10-12 00:00:00', '2026-10-12 23:08:15', 0, 0, 0)