数据库问题。。。

/usr/var/slowquery.log
这个位置在那的？

没有人知道吗

。。。。。。。。。。。。。。。。。

找到了 里面记录很多内容

1. D:\server\mysql\bin\mysqld-nt, Version: 5.0.41-community-nt-log (MySQL Community Edition (GPL)). started with:
   
2. TCP Port: 3306, Named Pipe: (null)
   
3. Time Id Command Argument
   
4. # Time: 090101 1:24:59
   
5. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
   
6. # Query_time: 18 Lock_time: 0 Rows_sent: 10 Rows_examined: 72296
   
7. use feifei;
   
8. SELECT s.uid,s.username,s.name,s.namestatus
   
9. FROM uchome_space s, uchome_spacefield sf
   
10. WHERE s.uid=sf.uid AND s.avatar='1' AND sf.sex='2' AND s.uid NOT IN (419467)
    
11. ORDER BY s.friendnum DESC LIMIT 0,10;
    
12. # Time: 090101 2:40:39
    
13. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
14. # Query_time: 160 Lock_time: 0 Rows_sent: 0 Rows_examined: 1044722
    
15. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%' OR p.subject LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%')) ORDER BY tid DESC LIMIT 500;
    
16. # Time: 090101 2:40:47
    
17. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
18. # Query_time: 156 Lock_time: 148 Rows_sent: 40 Rows_examined: 96869
    
19. SELECT t.tid, t.closed, t.author FROM cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND (0 OR t.subject LIKE '%幻想曹操传%') ORDER BY tid DESC LIMIT 500;
    
20. # Time: 090101 2:41:37
    
21. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
22. # Query_time: 207 Lock_time: 149 Rows_sent: 0 Rows_examined: 1044722
    
23. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%' OR p.subject LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%')) ORDER BY tid DESC LIMIT 500;
    
24. # Time: 090101 2:41:38
    
25. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
26. # Query_time: 214 Lock_time: 155 Rows_sent: 0 Rows_examined: 1044722
    
27. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%' OR p.subject LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%')) ORDER BY tid DESC LIMIT 500;
    
28. # Time: 090101 2:42:02
    
29. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
30. # Query_time: 225 Lock_time: 142 Rows_sent: 0 Rows_examined: 1044722
    
31. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%' OR p.subject LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%')) ORDER BY tid DESC LIMIT 500;
    
32. # Time: 090101 2:42:05
    
33. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
34. # Query_time: 242 Lock_time: 156 Rows_sent: 0 Rows_examined: 1044722
    
35. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%' OR p.subject LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%')) ORDER BY tid DESC LIMIT 500;
    
36. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
37. # Query_time: 239 Lock_time: 153 Rows_sent: 0 Rows_examined: 1044722
    
38. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%' OR p.subject LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%')) ORDER BY tid DESC LIMIT 500;
    
39. # Time: 090101 2:42:07
    
40. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
41. # Query_time: 240 Lock_time: 152 Rows_sent: 0 Rows_examined: 1044722
    
42. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%' OR p.subject LIKE '%最终幻想之株神的黄昏（资料篇）Z1.1隐藏英雄密码%')) ORDER BY tid DESC LIMIT 500;
    
43. # Time: 090101 3:49:16
    
44. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
45. # Query_time: 303 Lock_time: 0 Rows_sent: 500 Rows_examined: 1046399
    
46. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔界复仇%' OR p.subject LIKE '%魔界复仇%')) ORDER BY tid DESC LIMIT 500;
    
47. # Time: 090101 5:03:42
    
48. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
49. # Query_time: 244 Lock_time: 0 Rows_sent: 1 Rows_examined: 1044865
    
50. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%东方暗战1.0测试版%' OR p.subject LIKE '%东方暗战1.0测试版%')) ORDER BY tid DESC LIMIT 500;
    
51. # Time: 090101 5:04:40
    
52. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
53. # Query_time: 293 Lock_time: 235 Rows_sent: 1 Rows_examined: 1044865
    
54. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%东方暗战1.0测试版%' OR p.subject LIKE '%东方暗战1.0测试版%')) ORDER BY tid DESC LIMIT 500;
    
55. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
56. # Query_time: 296 Lock_time: 238 Rows_sent: 500 Rows_examined: 1049379
    
57. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%神界危机%' OR p.subject LIKE '%神界危机%')) ORDER BY tid DESC LIMIT 500;
    
58. # Time: 090101 5:04:41
    
59. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
60. # Query_time: 291 Lock_time: 232 Rows_sent: 1 Rows_examined: 1044865
    
61. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%东方暗战1.0测试版%' OR p.subject LIKE '%东方暗战1.0测试版%')) ORDER BY tid DESC LIMIT 500;
    
62. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
63. # Query_time: 295 Lock_time: 236 Rows_sent: 1 Rows_examined: 1044865
    
64. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%东方暗战1.0测试版%' OR p.subject LIKE '%东方暗战1.0测试版%')) ORDER BY tid DESC LIMIT 500;
    
65. # Time: 090101 5:31:52
    
66. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
67. # Query_time: 32 Lock_time: 0 Rows_sent: 0 Rows_examined: 1044904
    
68. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔界复仇3.4%' OR p.subject LIKE '%魔界复仇3.4%')) ORDER BY tid DESC LIMIT 500;
    
69. # Time: 090101 5:31:54
    
70. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
71. # Query_time: 32 Lock_time: 0 Rows_sent: 0 Rows_examined: 1044904
    
72. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔界复仇3.4%' OR p.subject LIKE '%魔界复仇3.4%')) ORDER BY tid DESC LIMIT 500;
    
73. # Time: 090101 5:32:00
    
74. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
75. # Query_time: 29 Lock_time: 22 Rows_sent: 1 Rows_examined: 0
    
76. SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS fid
    
77. FROM cdb_threads t
    
78. INNER JOIN cdb_forums f ON f.fid=t.fid
    
79. LEFT JOIN cdb_forumfields ff ON ff.fid=f.fid
    
80. WHERE t.tid='173517' AND t.displayorder>='0' LIMIT 1;
    
81. # Time: 090101 5:32:22
    
82. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
83. # Query_time: 57 Lock_time: 28 Rows_sent: 0 Rows_examined: 1044904
    
84. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔界复仇3.4%' OR p.subject LIKE '%魔界复仇3.4%')) ORDER BY tid DESC LIMIT 500;
    
85. # Time: 090101 5:32:36
    
86. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
87. # Query_time: 70 Lock_time: 27 Rows_sent: 0 Rows_examined: 1044904
    
88. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔界复仇3.4%' OR p.subject LIKE '%魔界复仇3.4%')) ORDER BY tid DESC LIMIT 500;
    
89. # Time: 090101 5:32:37
    
90. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
91. # Query_time: 72 Lock_time: 28 Rows_sent: 0 Rows_examined: 1044904
    
92. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔界复仇3.4%' OR p.subject LIKE '%魔界复仇3.4%')) ORDER BY tid DESC LIMIT 500;
    
93. # Time: 090101 6:43:58
    
94. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
95. # Query_time: 38 Lock_time: 0 Rows_sent: 1 Rows_examined: 748120
    
96. SELECT COUNT(*) FROM cdb_members WHERE regdate>='1230677000';
    
97. # Time: 090101 7:53:43
    
98. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
    
99. # Query_time: 341 Lock_time: 0 Rows_sent: 100 Rows_examined: 1045227
    
100. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔幻手机%' OR p.subject LIKE '%魔幻手机%')) ORDER BY tid DESC LIMIT 500;
     
101. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
102. # Query_time: 348 Lock_time: 0 Rows_sent: 100 Rows_examined: 1045227
     
103. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔幻手机%' OR p.subject LIKE '%魔幻手机%')) ORDER BY tid DESC LIMIT 500;
     
104. # Time: 090101 7:53:44
     
105. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
106. # Query_time: 343 Lock_time: 0 Rows_sent: 100 Rows_examined: 1045227
     
107. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔幻手机%' OR p.subject LIKE '%魔幻手机%')) ORDER BY tid DESC LIMIT 500;
     
108. # Time: 090101 7:53:51
     
109. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
110. # Query_time: 330 Lock_time: 323 Rows_sent: 3 Rows_examined: 96864
     
111. SELECT t.tid, t.closed, t.author FROM cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND (0 OR t.subject LIKE '%魔幻手机1.2%') ORDER BY tid DESC LIMIT 500;
     
112. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
113. # Query_time: 339 Lock_time: 332 Rows_sent: 7 Rows_examined: 96868
     
114. SELECT t.tid, t.closed, t.author FROM cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND (0 OR t.subject LIKE '%澄海3c5.56%') ORDER BY tid DESC LIMIT 500;
     
115. # Time: 090101 7:53:54
     
116. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
117. # Query_time: 334 Lock_time: 324 Rows_sent: 7 Rows_examined: 96868
     
118. SELECT t.tid, t.closed, t.author FROM cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND (0 OR t.subject LIKE '%澄海3c5.56%') ORDER BY tid DESC LIMIT 500;
     
119. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
120. # Query_time: 316 Lock_time: 306 Rows_sent: 3 Rows_examined: 96864
     
121. SELECT t.tid, t.closed, t.author FROM cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND (0 OR t.subject LIKE '%魔幻手机1.2%') ORDER BY tid DESC LIMIT 500;
     
122. # Time: 090101 7:54:14
     
123. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
124. # Query_time: 366 Lock_time: 336 Rows_sent: 10 Rows_examined: 1045047
     
125. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔幻手机1.2%' OR p.subject LIKE '%魔幻手机1.2%')) ORDER BY tid DESC LIMIT 500;
     
126. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
127. # Query_time: 365 Lock_time: 335 Rows_sent: 10 Rows_examined: 1045047
     
128. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%魔幻手机1.2%' OR p.subject LIKE '%魔幻手机1.2%')) ORDER BY tid DESC LIMIT 500;
     
129. # Time: 090101 8:00:38
     
130. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
131. # Query_time: 28 Lock_time: 0 Rows_sent: 0 Rows_examined: 1045027
     
132. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%弓于法3C%' OR p.subject LIKE '%弓于法3C%')) ORDER BY tid DESC LIMIT 500;
     
133. # Time: 090101 8:03:55
     
134. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
135. # Query_time: 27 Lock_time: 0 Rows_sent: 11 Rows_examined: 1045051
     
136. SELECT DISTINCT t.tid, t.closed, t.author FROM cdb_posts p, cdb_threads t WHERE t.fid IN ('2','576','144','4','21','6','22','93','157','142','308','591','592','297','296','604','606','607','615','617','618','594','474','625','627','628','293','612','302','304','310','588','608','546','609','214','614','616','600','599','20','619','23','24','624','333','150','368','580','603','620','622','623','626','570','613','8','41','404','153','9','31','5','192','597','470','574','575','572','596','263','273','577','38','166','276','107','147','129','96','503','14','15') AND t.displayorder>='0' AND p.tid=t.tid AND p.invisible='0' AND (0 OR (p.message LIKE '%神界危机密码%' OR p.subject LIKE '%神界危机密码%')) ORDER BY tid DESC LIMIT 500;
     
137. # Time: 090101 8:32:10
     
138. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
139. # Query_time: 21 Lock_time: 0 Rows_sent: 10 Rows_examined: 73672
     
140. SELECT s.uid,s.username,s.name,s.namestatus
     
141. FROM uchome_space s, uchome_spacefield sf
     
142. WHERE s.uid=sf.uid AND s.avatar='1' AND sf.sex='2' AND s.uid NOT IN (854110)
     
143. ORDER BY s.friendnum DESC LIMIT 0,10;
     
144. # Time: 090101 8:51:10
     
145. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
146. # Query_time: 39 Lock_time: 0 Rows_sent: 10 Rows_examined: 748269
     
147. SELECT uid,username,extcredits7 FROM cdb_members ORDER BY extcredits7 DESC LIMIT 0,10;
     
148. # Time: 090101 9:45:11
     
149. # User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
     
150. # Query_time: 9 Lock_time: 0 Rows_sent: 68 Rows_examined: 68060
     
151. SELECT authorid, COUNT(*) AS posts FROM cdb_posts
     
152. WHERE dateline>=1230774301-86400*30 AND authorid IN (0,580738,464476,201489,677498,607629,166880,661144,568908,677498,696123,431968,607629,340817,558746,249899,340817,402724,277734,597319,315933,139570,607478,627532,533436,595938,1FBI 提醒民众: 此人已枪决、有事烧纸36,711997,696123,597319,671955,558746,712194,767454,661144,743226,607629,402724,767454,654274,572333,766886,696123,315933,698820,597645,340817,515208,616427,720606,698820,133449,625995,229863,FBI 提醒民众: 此人已枪决、有事烧纸,607629,1069,5236,661144,305800,249899,305800,337289,764972,605056,158767,52702,139570,405251,661144,350983,340817,431968,217259,25136,247940,166880,568354,FBI 提醒民众: 此人已枪决、有事烧纸,166880,364492,275827,605627,515208,599625,340817,595470,247940,42050,766886,431968,247398,541641,166880,647834,605627,607629,178622,607629,278031,1,250888,607629,607478,605627,605056,599625,597645,597319,595938,595470,580738,572609,572333,568908,568354,558746,616427,625995,627532,767454,766886,764972,743226,730405,720606,720110,712194,711997,704742,677498,671955,661144,654274,647834,629236,541641,533436,696123,698820,178622,166880,158767,139570,133449,275827,277734,278031,52702,51825,42050,25136,5236,201489,217259,229863,515208,464476,431968,405251,402724,364492,350983,340817,337289,315933,305800,251698,249899,247940,247398,1069) AND invisible='0' GROUP BY authorid;
     

复制代码