SELECT -- `PartLaid`.`bigBuyerId`, `PartLaid`.`bigId`, `PartLaid`.`brandId`, `PartLaid`.`buyAmount`, `PartLaid`.`buydetailId`, `PartLaid`.`contractId`, `PartLaid`.`id`, `PartLaid`.`locationId`, `PartLaid`.`note`, `PartLaid`.`orderNumber`, `PartLaid`.`partCode`, `PartLaid`.`partId`, `PartLaid`.`partName`, `PartLaid`.`pastureId`, `PartLaid`.`price`, `PartLaid`.`providerId`, `PartLaid`.`purpose`, `PartLaid`.`receivedAmount`, `PartLaid`.`reportery`, `PartLaid`.`specification`, `PartLaid`.`storageAmount`, `PartLaid`.`storageType`, `PartLaid`.`subscribePasture`, `PartLaid`.`subscribeProvider`, `PartLaid`.`sumPrice`, `PartLaid`.`unit`, `PartLaid`.`dflag`, `PartLaid`.`rowNumber`, `PartLaid`.`IsZeroStock` FROM PartLaid pl -- join bigpartlaid bpl on pl.bigid = bpl.id -- WHERE -- bpl.laidcode = 'RK01220826002' limit 10