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