sql优化,查询时间太长了要两分多钟,哪位大佬帮忙看看
SELECT p.goods_sku,m.site_id,l.listing_category1,l.listing_category2,l.listing_price,m.goods_sku as sku_vo FROM product_goods AS p LEFT JOIN product_goods_more AS m ON p.goods_id=m.goods_id LEFT JOIN product_listing AS l ON m.goods_moreid=l.discription_id WHERE l.listing_type=1 and l.listing_price>0 GROUP BY p.goods_sku,m.site_id limit 1,500
qq_41256758
2020/11/24 16:06- mysql
- 点赞
- 收藏
- 回答