秒杀模块解决方案

站点库存表主键ID;商品ID;站点ID;....

station_stock

批次库存表主键ID;商品ID;站点ID;批次号;....

stock

#查询站点库存表主键select id from station_stock where station_id = 46 and goods_code = 'MX';＃行锁&数据操作select id from station_stock where id = 100089 for update;＃查询站点库存redisif ($redis - get()) {}