select * from product where pid='1784349' and `category`='battery'