select * from tscm_product p where (p.productid,p.supplierid) in(select pp.productid,pp.supplierid from tscm_product pp where pp.productid=100124) 效率不高