平翘舌区分的技巧

页面:/news/view-587519/ | 耗时:0.3735 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=587519 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=587519 LIMIT 0,1
select * from tbl_Articles_sphinx where id=587519 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1064278,86272,1117644,1082151,1044114,1115439,638993,86263,3489573,479971,81110,1108534,1359054,1091413,1085360,2103453,100887,3443340,3430845,724556,86248,1102516,352390,359058,100634,1116649,1118178,558067,100419,2406775) ORDER BY field (ArticleID,1064278,86272,1117644,1082151,1044114,1115439,638993,86263,3489573,479971,81110,1108534,1359054,1091413,1085360,2103453,100887,3443340,3430845,724556,86248,1102516,352390,359058,100634,1116649,1118178,558067,100419,2406775)