将下面代码中的ORDER BY 后面的T.view去掉或改成T.ctime时间，就正常了
$sql_travel = "SELECT T.tid,T.uid,T.title,T.content,T.view,T.ctime,T.utime,T.priv,
COUNT(DISTINCT TC.cid) AS tccounts,
COUNT(DISTINCT TU.id) AS tucounts,
U.nickname,U.city
FROM ty_travels T
LEFT JOIN ty_travel_comments TC
ON T.tid = TC.tid
LEFT JOIN ty_travel_up TU
ON T.tid = TU.tid
LEFT JOIN ty_user U
ON T.uid = U.uid
WHERE T.priv = 1
GROUP BY T.tid
ORDER BY T.view DESC, T.sort DESC
LIMIT " . $page->firstRow . ',' . $page->listRows;
可能是正则的问题，但是非常郁闷的是，一样的页面按时间排序就非常快，时间和view阅读次数类型完全一样。
最佳答案
