mysql视图慢_mysql如何提高视图查询速度？

最近数据库从5.5.18升级到了5.6.38，出现了一个问题，有个视图同样的数据量执行效率相比老数据库慢了20倍，应该怎么优化？

如下是视图sql：

SELECT

`wz_demand`.`id` AS `id`,

`wz_demand`.`operator` AS `operator`,

`wz_member`.`username` AS `musername`,

`wz_admin`.`truename` AS `truename`,

`wz_demand`.`cid` AS `cid`,

`wz_demand`.`title` AS `title`,

`wz_demand`.`css` AS `css`,

`wz_demand`.`thumb` AS `thumb`,

`wz_demand`.`keywords` AS `keywords`,

`wz_demand`.`remark` AS `remark`,

`wz_demand`.`url` AS `url`,

`wz_demand`.`status` AS `status`,

`wz_demand`.`route` AS `route`,

`wz_demand`.`publisher` AS `publisher`,

`wz_demand`.`addtime` AS `addtime`,

`wz_demand`.`updatetime` AS `updatetime`,

`wz_demand`.`coin` AS `coin`,

`wz_demand`.`template` AS `template`,

`wz_demand`.`areaid` AS `areaid`,

`wz_demand`.`areaid_1` AS `areaid_1`,

`wz_demand`.`areaid_2` AS `areaid_2`,

`wz_demand`.`sort` AS `sort`,

`wz_demand`