交叉连接和全连接区别

页面:/news/view-3242354/ | 耗时:0.5040 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3242354 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3242354 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3242354 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(287219,191609,1125540,199241,851282,1113243,151966,2848945,1072278,189556,363820,292588,2477782,1084081,1073274,297165,1103841,1120418,1131063,345642,147518,163755,1093230,146613,1127187,161020,1125210,341024,313102,147288) ORDER BY field (ArticleID,287219,191609,1125540,199241,851282,1113243,151966,2848945,1072278,189556,363820,292588,2477782,1084081,1073274,297165,1103841,1120418,1131063,345642,147518,163755,1093230,146613,1127187,161020,1125210,341024,313102,147288)