SELECThomepageId,userId,homepagesummary,totalviews,totalleadpercents,totalappointments,homepagestatus,linkphone,imagepath,createtime,updatetime,recommendtime,sortcode,designerimagepath,isrecommend,(SELECTcount(*)FROMhomepagexxxrelationWHEREhomepageid=h.homepageidANDgroundingstatus=0)AStotalxxx,(SELECTcount(*)FROMhomepagexxxrelationWHEREhomepageid=h.homepageidANDgroundingstatus=0ANDCreatetime>=DATE_SUB(sysdate(),INTERVAL7DAY))ASweektotalxxxFROMdesignerhomepagehWHERE1=1andisrecommend=1orderbyweektotalxxxDESC,homepageidDESC;优化后:SELECTh.homepageId,h.userId,h.homepagesummary,h.totalviews,h.totalleadpercents,h.totalappointments,h.homepagestatus,h.linkphone,h.imagepath,h.createtime,h.updatetime,h.recommendtime,h.sortcode,h.designerimagepath,h.isrecommend,ifnull(h3.cnt2,0)AStotalscheme,ifnull(h3.cnt1,0)ASweektotalxxxFROMdesignerhomepagehLEFTJOIN(SELECTHomepageid,sum(casewhenHP.Createtime>=DATE_SUB(sysdate(),INTERVAL7DAY)then1else0end)cnt1,count(*)cnt2FROMhomepagexxxrelationhpWHEREHP.groundingstatus=0GROUPBYHomepageid)h3ONh3.homepageid=h.homepageidWHERE1=1andisrecommend=1ORDERBYweektotalxxxDESC,homepageidDESC;