sql优化记录

一、sql优化记录：

1. 先来欣赏一下我公司不知道哪个大牛写的这段sql。

SELECT a.Id,a.ProductName,a.Pointfree,a.ProductState,a.Product_ASNI,a.ProductImges,b.UserName,b.userId,D.StieName,b.ContactPhone  FROM `fksd_product`  a 
left join fksdtb_user b on a.MerchantCode=b.MerchantCode
left join fksd_amazonsite D on a.StieId=D.Id
where (a.Product_ASNI = '1858762267' or a.ProductName like '%1858762267%' or b.UserName = '1858762267' or b.ContactPhone = '1858762267')  and a.IsCrawl=1 and b.userType=2 

2. 下班以后补充优化