逻辑结构和物理结构各有什么特点

页面:/news/view-2262833/ | 耗时:0.4802 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2262833 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2262833 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2262833 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1109304,1063251,1109989,1107851,1074820,1091731,1052121,1046963,1094109,1133285,1065179,997352,1054298,1062959,1079131,1070934,1126482,1062578,1062000,1075606,1130752,1075827,1066704,1064247,1068150,1104133,1049548,1062712,1068296,1071341) ORDER BY field (ArticleID,1109304,1063251,1109989,1107851,1074820,1091731,1052121,1046963,1094109,1133285,1065179,997352,1054298,1062959,1079131,1070934,1126482,1062578,1062000,1075606,1130752,1075827,1066704,1064247,1068150,1104133,1049548,1062712,1068296,1071341)