//批量回滚库存 （关联更新）
UPDATE product_sku_copy1 a,( SELECT `SKU`.`pCode`, `L`.`lastStock` FROM `product_log` AS `L` LEFT JOIN `product_sku` AS `SKU` ON `L`.`pId` = `SKU`.`id` LEFT JOIN `product_spu` AS `SPU` ON `SKU`.`pId` = `SPU`.`id` LEFT JOIN `log_type` AS `LT` ON `L`.`cateId` = `LT`.`id` LEFT JOIN `store` AS `S` ON `L`.`storeId` = `S`.`id` where `L`.`cateId`=9 and `L`.`addTime`>='2019-10-31 18:23:40' GROUP BY `L`.`id` ) d SET a.stock =d.lastStock where a.pCode = d.pCode
//没有了groub by 超级慢 //批量回滚库存 UPDATE product_sku_copy1 a,( SELECT `SKU`.`pCode`, `L`.`lastStock` FROM `product_log` AS `L` LEFT JOIN `product_sku` AS `SKU` ON `L`.`pId` = `SKU`.`id` LEFT JOIN `product_spu` AS `SPU` ON `SKU`.`pId` = `SPU`.`id` LEFT JOIN `log_type` AS `LT` ON `L`.`cateId` = `LT`.`id` LEFT JOIN `store` AS `S` ON `L`.`storeId` = `S`.`id` where `L`.`cateId`=9 and `L`.`addTime`>='2019-10-31 18:23:40' ) d SET a.stock =d.lastStock where a.pCode = d.pCode
