join的用法

页面:/news/view-474358/ | 耗时:0.2853 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=474358 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=474358 LIMIT 0,1
select * from tbl_Articles_sphinx where id=474358 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(101121,367177,1088499,100699,368835,1117111,98278,1119401,371385,1092159,1106583,1096440,1085580,87064,1121324,365999,100789,2210535,363525,3471945,1103196,660525,361799,374030,366429,1175547,361967,86831,100495,367443) ORDER BY field (ArticleID,101121,367177,1088499,100699,368835,1117111,98278,1119401,371385,1092159,1106583,1096440,1085580,87064,1121324,365999,100789,2210535,363525,3471945,1103196,660525,361799,374030,366429,1175547,361967,86831,100495,367443)