MySQL交叉查询难以置信的慢, 请教高人

不是流氓

1. SELECT SQL_NO_CACHE distinct tsl.TestSuiteID, tsl.TestSuiteName, tsl.TPrefix,
   
2. tps.ID, tcp.TestCaseID, tpl.Name, tpl.Version,
   
3. tps.Name AS ScriptName, tps.Version AS ScriptVersion
   
4. FROM test_case_procedure  tcp
   
5.         left join test_procedure_label tpl on tpl.ID = tcp.TestProcedureLabelID
   
6.         left join  test_procedure_script tps  on  tcp.ID = tps.TestCaseProcedureID
   
7.         left join event_script es on es.TestProcedureScriptID = tps.ID                       
   
8.         left join test_event te on te.TestEventID = es.TestEventID
   
9.         left join test_case tc on tc.TestCaseID = tcp.TestCaseID
   
10.         left join test_suite_list tsl on tsl.TestSuiteID = tc.TestSuiteID
    
11.         left join project p on te.ProjID = p.ProjectID
    
12. where p.CoreID=11
    
13. ORDER BY tcp.TestCaseID, tpl.Name, tpl.Version DESC,tps.Name, tps.Version
    
14.                            
    
15. 
    
16. alter table project add index prj_idx(CoreID);
    
17. alter table test_case_procedure add index tcp_idx(ID);
    
18. alter table test_case add index tc_idx(TestCaseID,TestSuiteID);
    
19. alter table event_script add index es_idx(TestProcedureScriptID);
    
20. alter table test_procedure_label add index tpl_idx(ID);
    
21. alter table test_suite_list add index tsl_idx(TestSuiteID);

复制代码

加上索引啦