在上一篇文章完成首页浏览压测任务后,我们开始下单-支付场景的压测实践。
select p1.id, p1.product_category_id, p1.product_sn, p1.brand_name, p1.price, p1.name, p1.pic, p1.sub_title, p2.sku_code, p2.id as product_sku_id, p2.sp1, p2.sp2 from mall.pms_product as p1 join mall.pms_sku_stock as p2 on p1.id = p2.product_id where p1.stock >=50 and p2.stock > 50;