OxiechunweiO的博客

原创 各位大神，求帮忙把这个sql性能优化一下

SELECT IFNULL(p.name,ci.shortName) `name`, IFNULL(p.mobilePhone,ci.agentMobilePhone) mobilePhone, pb.productName, ROUND(t.investAmount/productAmount * 100,0) AS investPercent,ph.receiveInterestDate, (...