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
qq_41256758
2020/11/24 16:06
  • mysql
  • 点赞
  • 收藏
  • 回答
    私信

2个回复