2025-01-11 23:11:28 更新了水表 25300071 的 switch_status 为 3 2025-01-11 23:11: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 ('623902833', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902833'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902833') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25300093 的 switch_status 为 3 2025-01-11 23:11: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 ('623902867', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623902867'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623902867') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25300094 的 switch_status 为 3 2025-01-11 23:11: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 ('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-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25300141 的 switch_status 为 3 2025-01-11 23:11: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 ('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-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25300160 的 switch_status 为 3 2025-01-11 23:11: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 ('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, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25300199 的 switch_status 为 3 2025-01-11 23:11: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 ('623903129', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903129'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903129') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25300234 的 switch_status 为 3 2025-01-11 23:11: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, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25300434 的 switch_status 为 3 2025-01-11 23:11: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 ('623903796', (SELECT ton FROM emac.watermeter_info WHERE mac_addr = '623903796'), (CASE WHEN (SELECT switch_status FROM emac.watermeter_info WHERE mac_addr = '623903796') = 3 THEN 3 ELSE 2 END), 0, 0, 0, 0, 0, 0, 0, 0, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25301229 的 switch_status 为 3 2025-01-11 23:11: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 ('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, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25301342 的 switch_status 为 3 2025-01-11 23:11: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 ('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-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25301367 的 switch_status 为 3 2025-01-11 23:11: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 ('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-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0) 2025-01-11 23:11:28 更新了水表 25301467 的 switch_status 为 3 2025-01-11 23:11: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 ('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, '2025-01-11 00:00:00', '2025-01-11 23:11:28', 0, 0, 0)