mysql> alter table nodes add key `visitcount` (`visitcount`);
然后再执行相应sql语句
SELECT nodes.uid , nid , subject
FROM nodes use index(visitcount) ,users
WHERE access = 0
AND nodes.uid = users.uid
AND nodetype = 0
AND pctype < 4
GROUP BY uid
ORDER BY nodes.visitcount DESC
LIMIT 0 ,50;
可以正常查询了，相关页面也显示正常了，hehe
【 在 JulyClyde (七月) 的大作中提到: 】
: 好像要求是primary key
--
FROM 221.192.220.*