数据库中运算符的几种用法

页面:/news/view-1487652/ | 耗时:0.9467 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1487652 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1487652 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1487652 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1085854,1100889,1044442,336525,1101333,1061044,1056976,1065795,1050395,1084667,1090699,1088605,1111870,1080375,1078424,1077960,1115263,1067895,1086138,1086872,1066684,1090771,1081859,1072278,1042020,1065713,1105345,1109925,1072837,1064249) ORDER BY field (ArticleID,1085854,1100889,1044442,336525,1101333,1061044,1056976,1065795,1050395,1084667,1090699,1088605,1111870,1080375,1078424,1077960,1115263,1067895,1086138,1086872,1066684,1090771,1081859,1072278,1042020,1065713,1105345,1109925,1072837,1064249)