mysql 六张张联合查询_联合六张表查询，怎么才能快点呀，现在用的是jion关联查询，慢。...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

select `wcmmetatablehcn_dou_jiang_ji`.`WCMMetaTableHCN_DOU_JIANG_JIID` AS `WCMMetaTableHCN_DOU_JIANG_JIID`,`wcmmetatablehcn_dou_jiang_ji`.`MetaDataId` AS `MetaDataId`,`wcmmetatablehcn_dou_jiang_ji`.`ChannelId` AS `ChannelId`,`wcmmetatablehcn_dou_jiang_ji`.`CrUser` AS `CrUser`,`wcmmetatablehcn_dou_jiang_ji`.`CrTime` AS `CrTime`,`wcmmetatablehcn_dou_jiang_ji`.`ABLEI` AS `ABLEI`,`wcmmetatablehcn_dou_jiang_ji`.`CHANPINDINGWEI` AS `CHANPINDINGWEI`,`wcmmetatablehcn_dou_jiang_ji`.`TOUFANGQUDAO` AS `TOUFANGQUDAO`,`wcmmetatablehcn_dou_jiang_ji`.`JDXXZZ` AS `JDXXZZ`,`wcmmetatablehcn_dou_jiang_ji`.`price` AS `price`,`wcmmetatablehcn_dou_jiang_ji`.`XINPIN` AS `XINPIN`,`wcmmetatablehcn_dou_jiang_ji`.`XPBQYXQ` AS `XPBQYXQ`,`wcmmetatablehcn_dou_jiang_ji`.`REMAIPIN` AS `REMAIPIN`,`wcmmetatablehcn_dou_jiang_ji`.`RMPBQYXQ` AS `RMPBQYXQ`,`wcmmetatablehcn_dou_jiang_ji`.`RL` AS `RL`,`wcmmetatablehcn_dou_jiang_ji`.`BEITICAIZHI` AS `BEITICAIZHI`,`wcmmetatablehcn_dou_jiang_ji`.`JIAREFANGSHI` AS `JIAREFANGSHI`,`wcmmetatablehcn_dou_jiang_ji`.`GUOLVWANG` AS `GUOLVWANG`,`wcmmetatablehcn_dou_jiang_ji`.`SHIYONGRENSHU` AS `SHIYONGRENSHU`,`wcmmetatablehcn_dou_jiang_ji`.`CPJZ` AS `CPJZ`,`wcmmetatablehcn_dou_jiang_ji`.`CPMZ` AS `CPMZ`,`wcmmetatablehcn_dou_jiang_ji`.`CPCC` AS `CPCC`,`wcmmetatablehcn_dou_jiang_ji`.`EDDY` AS `EDDY`,`wcmmetatablehcn_dou_jiang_ji`.`EDPL` AS `EDPL`,`wcmmetatablehcn_dou_jiang_ji`.`JRGL` AS `JRGL`,`wcmmetatablehcn_dou_jiang_ji`.`GANDOU` AS `GANDOU`,`wcmmetatablehcn_dou_jiang_ji`.`SHIDOU` AS `SHIDOU`,`wcmmetatablehcn_dou_jiang_ji`.`MIHU` AS `MIHU`,`wcmmetatablehcn_dou_jiang_ji`.`WUGU` AS `WUGU`,`wcmmetatablehcn_dou_jiang_ji`.`GUOSHULENGYIN` AS `GUOSHULENGYIN`,`wcmmetatablehcn_dou_jiang_ji`.`YUMIZHI` AS `YUMIZHI`,`wcmmetatablehcn_dou_jiang_ji`.`LVDOU` AS `LVDOU`,`wcmmetatablehcn_dou_jiang_ji`.`ZIDONGQINGXI` AS `ZIDONGQINGXI`,`wcmmetatablehcn_dou_jiang_ji`.`FANGTANGSHEJI` AS `FANGTANGSHEJI`,`wcmmetatablehcn_dou_jiang_ji`.`BAOWENGONGNENG` AS `BAOWENGONGNENG`,`wcmmetatablehcn_dou_jiang_ji`.`PName` AS `PName`,`wcmmetatablehcn_dou_jiang_ji`.`ModelNo` AS `ModelNo`,`wcmmetatablehcn_dou_jiang_ji`.`SFYJTS` AS `SFYJTS`,`wcmmetatablehcn_dou_jiang_ji`.`Driver` AS `Driver`,`wcmmetatablehcn_dou_jiang_ji`.`Special` AS `Special`,`wcmmetatablehcn_dou_jiang_ji`.`PCode` AS `PCode`,`wcmmetatablehcn_dou_jiang_ji`.`PKeywords` AS `PKeywords`,`wcmmetatablehcn_dou_jiang_ji`.`PSale` AS `PSale`,`wcmmetatablehcn_dou_jiang_ji`.`PSaleValid` AS `PSaleValid`,`wcmmetatablehcn_dou_jiang_ji`.`PPromotion` AS `PPromotion`,`wcmmetatablehcn_dou_jiang_ji`.`PPromotionValid` AS `PPromotionValid`,`wcmmetatablehcn_dou_jiang_ji`.`PPromotionURL` AS `PPromotionURL`,`wcmmetatablehcn_dou_jiang_ji`.`CommentCount` AS `CommentCount`,`wcmmetatablehcn_dou_jiang_ji`.`ClickCount` AS `ClickCount`,`wcmmetatablehcn_dou_jiang_ji`.`FavCount` AS `FavCount`,`wcmmetatablehcn_dou_jiang_ji`.`ShareCount` AS `ShareCount`,`wcmmetatablehcn_dou_jiang_ji`.`WBuyCount` AS `WBuyCount`,`wcmmetatablehcn_dou_jiang_ji`.`Suggest` AS `Suggest`,`wcmmetatablehcn_dou_jiang_ji`.`HOutputId` AS `HOutputId`,`wcmmetatablehcn_dou_jiang_ji`.`OutlineViewMode` AS `OutlineViewMode`,`wcmmetatablehcn_dou_jiang_ji`.`Outline` AS `Outline`,`wcmmetatablehcn_dou_jiang_ji`.`Book` AS `Book`,`wcmmetatablehcn_dou_jiang_ji`.`FAQ` AS `FAQ`,`wcmmetatablehcn_dou_jiang_ji`.`SHANGSHISHIJIAN` AS `SHANGSHISHIJIAN`,group_concat(`t`.`GName` separator '|') AS `gdesc`,`wcmchannel`.`CHNLNAME` AS `CHNLNAME`,`wcmappendix`.`APPFILE` AS `APPFILE`,`wcmdocument`.`DOCPUBURL` AS `DOCPUBURL`,`wcmchnldoc`.`DOCORDERPRI` AS `DOCORDERPRI` from (((((`wcmmetatablehcn_dou_jiang_ji` join `wcmchnldoc`) join `wcmchannel`) join `wcmappendix`) join `wcmdocument`) join `wcmmetatablehcn_chan_ping_gai_su` `t`) where ((`wcmmetatablehcn_dou_jiang_ji`.`MetaDataId` = `wcmchnldoc`.`DOCID`) and (`wcmmetatablehcn_dou_jiang_ji`.`ChannelId` = `wcmchannel`.`CHANNELID`) and (`wcmmetatablehcn_dou_jiang_ji`.`MetaDataId` = `wcmdocument`.`DOCID`) and ((`wcmdocument`.`DOCSTATUS` = 10) or (`wcmdocument`.`DOCSTATUS` = 27)) and (`wcmmetatablehcn_dou_jiang_ji`.`MetaDataId` = `wcmappendix`.`APPDOCID`) and (`wcmappendix`.`APPSERN` = 1) and (locate(`t`.`MetaDataId`,`wcmmetatablehcn_dou_jiang_ji`.`Outline`) > 0)) group by `wcmmetatablehcn_dou_jiang_ji`.`MetaDataId`