表达技巧有哪些

页面:/news/view-2061941/ | 耗时:0.2297 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2061941 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2061941 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2061941 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(795370,619917,586269,602858,750412,1006583,477533,1006455,1011012,735081,1116553,651802,625158,1043064,1104637,900533,1011947,407794,1009341,1051734,399279,503215,886995,804227,848987,1064378,716425,544728,462188,970593) ORDER BY field (ArticleID,795370,619917,586269,602858,750412,1006583,477533,1006455,1011012,735081,1116553,651802,625158,1043064,1104637,900533,1011947,407794,1009341,1051734,399279,503215,886995,804227,848987,1064378,716425,544728,462188,970593)