SELECT sql_cache inc.I_id, inc.I_logo, inc.I_name, inc.I_mode, inc.I_regfinanc, inc.I_Y, inc.I_mostly, inc.I_create, inc.I_province, inc.I_city, inc.I_hit, inc.I_Nikname,
Data1.Ipq, Data1.Online, Data1.HeadNumb, (TGPasteNum * 10 + TGRepasteNum + TGClickNum + IndivGrade) AS Grade, (YEAR(NOW()) - I_create) AS CCcreate,
MAX(if(if(bp_edtime,bp_edtime,bp_time),if(bp_edtime,bp_edtime,bp_time),if(I_time1,I_time1,I_time))) AS retime, COUNT(bp_id) AS sumre,
((I_regfinanc * y_rate)/100) AS ratermb
FROM inc LEFT JOIN Data1 ON I_Nikname = NiceName
LEFT JOIN bizpaste ON inc.I_id = bizpaste.I_id
LEFT JOIN ymbhl ON inc.I_Y = ymbhl.y_na
WHERE inc.I_id >0
GROUP BY inc.I_id, inc.I_logo, inc.I_name, inc.I_mode, inc.I_regfinanc, inc.I_Y, inc.I_mostly, inc.I_create, inc.I_province, inc.I_city, inc.I_hit, inc.I_Nikname,
Data1.Ipq, Data1.Online, Data1.HeadNumb ;
用上面的语句查询特别慢啊。怎么优化一下?
表inc有10W条记录。
表Data1有10W。
表bizpaste有6W。
表ymbhl有10条记录。
Data1.Ipq, Data1.Online, Data1.HeadNumb, (TGPasteNum * 10 + TGRepasteNum + TGClickNum + IndivGrade) AS Grade, (YEAR(NOW()) - I_create) AS CCcreate,
MAX(if(if(bp_edtime,bp_edtime,bp_time),if(bp_edtime,bp_edtime,bp_time),if(I_time1,I_time1,I_time))) AS retime, COUNT(bp_id) AS sumre,
((I_regfinanc * y_rate)/100) AS ratermb
FROM inc LEFT JOIN Data1 ON I_Nikname = NiceName
LEFT JOIN bizpaste ON inc.I_id = bizpaste.I_id
LEFT JOIN ymbhl ON inc.I_Y = ymbhl.y_na
WHERE inc.I_id >0
GROUP BY inc.I_id, inc.I_logo, inc.I_name, inc.I_mode, inc.I_regfinanc, inc.I_Y, inc.I_mostly, inc.I_create, inc.I_province, inc.I_city, inc.I_hit, inc.I_Nikname,
Data1.Ipq, Data1.Online, Data1.HeadNumb ;
用上面的语句查询特别慢啊。怎么优化一下?
表inc有10W条记录。
表Data1有10W。
表bizpaste有6W。
表ymbhl有10条记录。
ymbhl.y_na
NiceName
建立索引再试试