# Query_time: 30.882528 Lock_time: 0.000186 Rows_sent: 400 Rows_examined: 2080376
SET timestamp=1338170725;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1039600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 30.018006 Lock_time: 0.000177 Rows_sent: 400 Rows_examined: 2077976
SET timestamp=1338170725;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1038400,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 30.319799 Lock_time: 0.000162 Rows_sent: 400 Rows_examined: 2051576
SET timestamp=1338170725;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1025200,400;
# Time: 120528 10:05:26
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 28.085818 Lock_time: 0.000155 Rows_sent: 400 Rows_examined: 2073976
SET timestamp=1338170726;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1036400,400;
# Time: 120528 10:05:27
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 18.380546 Lock_time: 0.000139 Rows_sent: 400 Rows_examined: 2048376
SET timestamp=1338170727;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1023600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 29.066499 Lock_time: 0.000160 Rows_sent: 1 Rows_examined: 1131711
SET timestamp=1338170727;
SELECT count(*) as total FROM pw_threads t FORCE INDEX (idx_postdate) WHERE t.ifcheck = 1 AND t.fid !=0 AND t.postdate < '1338171058';
# Time: 120528 10:05:29
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 3.276196 Lock_time: 0.000183 Rows_sent: 400 Rows_examined: 2081176
SET timestamp=1338170729;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1040000,400;
# Time: 120528 10:05:51
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 21.195674 Lock_time: 0.000149 Rows_sent: 400 Rows_examined: 2082776
SET timestamp=1338170751;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1040800,400;
# Time: 120528 10:05:52
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 21.947665 Lock_time: 0.208899 Rows_sent: 400 Rows_examined: 2052376
SET timestamp=1338170752;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1025600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 21.290749 Lock_time: 0.000125 Rows_sent: 400 Rows_examined: 2077976
SET timestamp=1338170752;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1038400,400;
# Time: 120528 10:05:53
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.162070 Lock_time: 0.189128 Rows_sent: 400 Rows_examined: 2080376
SET timestamp=1338170753;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1039600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 22.681838 Lock_time: 0.000089 Rows_sent: 400 Rows_examined: 2068376
SET timestamp=1338170753;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1033600,400;
# Time: 120528 10:05:55
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 22.853524 Lock_time: 0.000141 Rows_sent: 400 Rows_examined: 2076376
SET timestamp=1338170755;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1037600,400;
# Time: 120528 10:05:56
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.252480 Lock_time: 0.000125 Rows_sent: 400 Rows_examined: 2077976
SET timestamp=1338170756;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1038400,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.091890 Lock_time: 0.000106 Rows_sent: 400 Rows_examined: 2083576
SET timestamp=1338170756;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1041200,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 22.358188 Lock_time: 0.000144 Rows_sent: 400 Rows_examined: 2049176
SET timestamp=1338170756;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1024000,400;
# Time: 120528 10:05:57
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.519501 Lock_time: 0.000155 Rows_sent: 400 Rows_examined: 2081976
SET timestamp=1338170757;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1040400,400;
# Time: 120528 10:05:58
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 19.894060 Lock_time: 0.000188 Rows_sent: 400 Rows_examined: 2083576
SET timestamp=1338170758;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1041200,400;
# Time: 120528 10:05:59
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 16.762812 Lock_time: 0.000166 Rows_sent: 400 Rows_examined: 2053176
SET timestamp=1338170759;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1026000,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 16.230836 Lock_time: 0.000181 Rows_sent: 400 Rows_examined: 2082776
SET timestamp=1338170759;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1040800,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 15.702157 Lock_time: 0.000130 Rows_sent: 400 Rows_examined: 2077976
SET timestamp=1338170759;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >= '1' AND lastpost <= '1338150233' LIMIT 1038400,400;
直接把服务器搞挂了
bbs/aCloud/version/phpwind/common/ver.common.thread.php
具体语句是在这个文件里面的 目前 把函数注释掉了