2024-11-04 15:25:36 更新了水表 25300237 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300306 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300315 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300324 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300327 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300368 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300382 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300383 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 15:25:36 更新了水表 25300428 的 switch_status 为 3 2024-11-04 15:25: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 ('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-11-04 00:00:00', '2024-11-04 15:25:36', 0, 0, 0) 2024-11-04 17:44:30 更新了水表 25300327 的 switch_status 为 3 2024-11-04 17:44:30 执行了插入操作: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-11-04 00:00:00', '2024-11-04 17:44:30', 0, 0, 0) 2024-11-04 17:44:30 更新了水表 25300368 的 switch_status 为 3 2024-11-04 17:44:30 执行了插入操作: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-11-04 00:00:00', '2024-11-04 17:44:30', 0, 0, 0) 2024-11-04 17:44:30 更新了水表 25300428 的 switch_status 为 3 2024-11-04 17:44:30 执行了插入操作: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-11-04 00:00:00', '2024-11-04 17:44:30', 0, 0, 0)