2024-06-03 01:38:10 更新了水表 25300077 的 switch_status 为 3
2024-06-03 01:38: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 ('623902839', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902839'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902839') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 01:38:10', 0, 0, 0)
2024-06-03 01:48:15 更新了水表 25300223 的 switch_status 为 2
2024-06-03 01:48: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 ('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-06-03 00:00:00', '2024-06-03 01:48:15', 0, 0, 0)
2024-06-03 03:09:00 更新了水表 25300154 的 switch_status 为 3
2024-06-03 03:09:00 执行了插入操作：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 ('623903060', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903060'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903060') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 03:09:00', 0, 0, 0)
2024-06-03 04:45:54 更新了水表 25300158 的 switch_status 为 3
2024-06-03 04:45:54 执行了插入操作：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 ('623903064', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903064'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903064') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 04:45:54', 0, 0, 0)
2024-06-03 04:51:57 更新了水表 25300219 的 switch_status 为 3
2024-06-03 04:51:57 执行了插入操作：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 ('623903257', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903257'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903257') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 04:51:57', 0, 0, 0)
2024-06-03 05:30:18 更新了水表 25300077 的 switch_status 为 3
2024-06-03 05:30:18 执行了插入操作：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 ('623902839', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902839'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902839') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 05:30:18', 0, 0, 0)
2024-06-03 05:36:22 更新了水表 25300234 的 switch_status 为 2
2024-06-03 05:36: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 ('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-06-03 00:00:00', '2024-06-03 05:36:22', 0, 0, 0)
2024-06-03 05:56:33 更新了水表 25300223 的 switch_status 为 2
2024-06-03 05:56:33 执行了插入操作：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-06-03 00:00:00', '2024-06-03 05:56:33', 0, 0, 0)
2024-06-03 06:59:07 更新了水表 25300057 的 switch_status 为 3
2024-06-03 06:59:07 执行了插入操作：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 ('623902807', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902807'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902807') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 06:59:07', 0, 0, 0)
2024-06-03 08:34:00 更新了水表 25300158 的 switch_status 为 3
2024-06-03 08:34:00 执行了插入操作：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 ('623903064', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903064'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903064') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 08:34:00', 0, 0, 0)
2024-06-03 09:24:28 更新了水表 25300234 的 switch_status 为 2
2024-06-03 09:24:28 执行了插入操作：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-06-03 00:00:00', '2024-06-03 09:24:28', 0, 0, 0)
2024-06-03 10:04:50 更新了水表 25300223 的 switch_status 为 2
2024-06-03 10:04: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 ('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-06-03 00:00:00', '2024-06-03 10:04:50', 0, 0, 0)
2024-06-03 11:11:26 更新了水表 25300154 的 switch_status 为 3
2024-06-03 11:11:26 执行了插入操作：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 ('623903060', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903060'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903060') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 11:11:26', 0, 0, 0)
2024-06-03 13:18:36 更新了水表 25300077 的 switch_status 为 3
2024-06-03 13:18:36 执行了插入操作：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 ('623902839', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902839'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902839') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 13:18:36', 0, 0, 0)
2024-06-03 13:30:43 更新了水表 25300552 的 switch_status 为 3
2024-06-03 13:30: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 ('623904082', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623904082'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623904082') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 13:30:43', 0, 0, 0)
2024-06-03 13:32:44 更新了水表 25300552 的 switch_status 为 3
2024-06-03 13:32:44 执行了插入操作：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 ('623904082', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623904082'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623904082') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 13:32:44', 0, 0, 0)
2024-06-03 14:13:06 更新了水表 25300223 的 switch_status 为 2
2024-06-03 14:13:06 执行了插入操作：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-06-03 00:00:00', '2024-06-03 14:13:06', 0, 0, 0)
2024-06-03 14:25:13 更新了水表 25300537 的 switch_status 为 3
2024-06-03 14:25:13 执行了插入操作：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 ('623904055', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623904055'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623904055') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 14:25:13', 0, 0, 0)
2024-06-03 14:27:14 更新了水表 25300537 的 switch_status 为 3
2024-06-03 14:27:14 执行了插入操作：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 ('623904055', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623904055'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623904055') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 14:27:14', 0, 0, 0)
2024-06-03 14:31:16 更新了水表 25300537 的 switch_status 为 3
2024-06-03 14:31:16 执行了插入操作：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 ('623904055', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623904055'), 
                                  (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623904055') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2024-06-03 00:00:00', '2024-06-03 14:31:16', 0, 0, 0)