首页 随笔 乐走天涯 程序资料 评论中心 Tag 论坛 其他资源 搜索 联系我 关于 RSS

评论中心 - [peterpantw] 当前页 1


peterpantw 于 2008-07-16 17:36(15 年以前) 发表:
被空间商暂时停站,特来请教
Discuz 6.0

292733
peterpantw
localhost
peterpantw
Query
931
Locked
SELECT uid FROM cdb_sessions WHERE uid IN(55,250,5819,5,55,1948,2697,5819,375,250,2697,9446,55,5819,

292854
peterpantw
localhost
peterpantw
Query
932
Locked
SELECT pid FROM cdb_posts WHERE tid='13747' AND authorid='2697' LIMIT 1

292863
peterpantw
localhost
peterpantw
Query
932
Locked
SELECT pid FROM cdb_posts WHERE tid='13747' AND authorid='2697' LIMIT 1

293009
peterpantw
localhost
peterpantw
Query
1043
Locked
UPDATE cdb_sessions SET uid='4220', username='rainlily', groupid='23', styleid='11', invisible='0',

293019
peterpantw
localhost
peterpantw
Query
1018
Locked
UPDATE cdb_members SET posts=posts+('+1') , lastpost='1216193637' , extcredits2=extcredits2+6*1 WHER

293064
peterpantw
localhost
peterpantw
Query
1048
Locked
SELECT uid FROM cdb_sessions WHERE uid IN(5069,9594,5834,2416,5069,2416) AND invisible=0

293067
peterpantw
localhost
peterpantw
Query
1049
Locked
SELECT uid FROM cdb_sessions WHERE uid IN(2002,2002,2002) AND invisible=0



能不能给个方向去解决它?
麻烦了
XiaoHui 回复于 2008-07-16 18:49:
最初步的办法, 查 SELECT 语句后面的 WHERE 子句操作涉及的字段的属性,用 show columns from table_name 查看. 如果没有索引,尝试加上.


当前页: 1 / 1
所有页面: [1]  
首页 随笔 乐走天涯 猎户星 Google Earth 程序资料 程序生活 评论 Tag 论坛 资源 搜索 联系 关于 隐私声明 版权声明 订阅邮件

程序员小辉 建站于 1997 ◇ 做一名最好的开发者是我不变的理想。
Copyright © XiaoHui.com; 保留所有权利。