select * from monitor_sn_info where alarm = '1' select * from monitor_sn_info where alarm = 1 是完全不同的两句话,在执行时需要注意