查询的时候异常缓慢这个语句有误再优化空间呢,谢谢select * from tc_ypxt.t_camera t where 1=1 and t.camera_no in (select sxtbm from t_camera_error a where a.gjbm is not null and yxbz = '1' and a.gjbm in (select gjbm from t_camera_error where yxbz = '1' group by gjbm having count(1) > 1) and (qx_id in (select udfcode from t_zd_qx t where t.parentcode = '350500') or (qx_id = '35' and dsbm = '350500'))) order by yjyt_code asc