sql优化，查询时间太长了要两分多钟，哪位大佬帮忙看看

Question

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

Answer 1

你加EXPLAIN  看下sql的执行情况，索引什么的有没有用上，是不是走了全表扫描