数据库查询视图有几种方式

页面:/news/view-1855456/ | 耗时:0.8982 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1855456 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1855456 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1855456 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1116387,1367388,1129755,1089488,3247491,1128753,1127419,1076255,1119103,1060331,1123979,1128553,1083946,1108456,2844227,1050455,1132565,1128299,1103708,1855456,1079820,1111796,1078995,1110027,1079043,1092185,1459455,1063783,1073702,1079129) ORDER BY field (ArticleID,1116387,1367388,1129755,1089488,3247491,1128753,1127419,1076255,1119103,1060331,1123979,1128553,1083946,1108456,2844227,1050455,1132565,1128299,1103708,1855456,1079820,1111796,1078995,1110027,1079043,1092185,1459455,1063783,1073702,1079129)