视图查询不是一般的慢

SELECT Fahuo.id AS id,Fahuo.uid AS uid,Fahuo.sid AS sid,Fahuo.bid AS bid,Fahuo.xid AS xid,Fahuo.times AS times,Fahuo.counts AS counts,Book.number AS bknum,Book.bkname AS bkname,Book.price AS price,Shop.number AS shopnum,Shop.pname AS pname,Shop.name AS shopname,User.nickname AS username FROM wudi_fahuo Fahuo LEFT JOIN wudi_book Book ON LEFT(Fahuo.bid,9)=LEFT(Book.number,9) JOIN wudi_shop Shop ON Fahuo.sid=Shop.id JOIN wudi_user User ON Fahuo.uid=User.id [ RunTime:17.476371s ]


显示行 0 - 29 (21,749 总计, 查询花费 0.0244 秒)这个是在PHPMYADMIN同样的条件查的时间，差距不是一般啊

应该不能怪视图，你要看你的表是不是优化了？关键的字段是不是有索引？