多表关联查询优化方案

zkw1813133460

以下是我的minidao的sql

1. select count(1) from (select techown_report.ID as ID,
   
2. techown_report.name as apiname,
   
3. t_s_base_user.realname as sale,
   
4. techown_api.accountname as accountname,
   
5. techown_customer.customershort as customershort,
   
6. techown_api.price as price,
   
7. industry.typename as industryclassification,
   
8. account.typename as accounttype,
   
9. billingway.typename as billingway,
   
10. paymentway.typename as paymentway from techown_report
    
11. LEFT JOIN techown_api on techown_report.name=techown_api.apiname
    
12. LEFT JOIN techown_customer on techown_api.customerid=techown_customer.id
    
13. LEFT JOIN t_s_base_user on t_s_base_user.username=techown_customer.sale
    
14. LEFT JOIN (select t_s_type.typecode,t_s_type.typename from  t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='industry') as industry on techown_api.industryclassification=industry.typecode
    
15. LEFT JOIN (select t_s_type.typecode,t_s_type.typename from  t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='account') as account on techown_api.accounttype=account.typecode
    
16. LEFT JOIN (select t_s_type.typecode,t_s_type.typename from  t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='billingway') as billingway on techown_api.billingway=billingway.typecode
    
17. LEFT JOIN (select t_s_type.typecode,t_s_type.typename from  t_s_type LEFT JOIN t_s_typegroup on t_s_typegroup.ID=t_s_type.typegroupid where t_s_typegroup.typegroupcode='paymentway') as paymentway on techown_api.paymentway=paymentway.typecode
    
18. where 1=1
    
19. <#if accountname ?exists && accountname ?length gt 0>
    
20.         and accountname like :accountname
    
21. </#if>
    
22. <#if customershort ?exists && customershort ?length gt 0>
    
23.         and customershort like :customershort
    
24. </#if>
    
25. GROUP BY techown_report.name
    
26. ORDER BY techown_report.name) m

复制代码

求优化方案。该如何做？

admin

非jeecg的问题，尽量不要发，可以看下执行计划，加下索引

zkw1813133460

admin 发表于 2018-6-8 11:59
非jeecg的问题，尽量不要发，可以看下执行计划，加下索引

只是我实在想不到方案   所谓急病乱投医