执行了超找执行慢的MYSQL语句。反馈如下
| 4089 | bbs_discu | localhost | bbs_discu | Query | 17 | Locked | SELECT * FROM pre_forum_thread WHERE tid='382525' LIMIT 1 |
| 4091 | bbs_discu | localhost | bbs_discu | Query | 14 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4092 | bbs_discu | localhost | bbs_discu | Query | 14 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4108 | bbs_discu | localhost | bbs_discu | Query | 10 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4109 | bbs_discu | localhost | bbs_discu | Query | 10 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4115 | bbs_discu | localhost | bbs_discu | Query | 9 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4122 | bbs_discu | localhost | bbs_discu | Query | 9 | Locked | SELECT * FROM pre_forum_thread WHERE tid='380221' LIMIT 1 |
| 4124 | bbs_discu | localhost | bbs_discu | Query | 8 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4127 | bbs_discu | localhost | bbs_discu | Query | 7 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4146 | bbs_discu | localhost | bbs_discu | Query | 5 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4150 | bbs_discu | localhost | bbs_discu | Query | 3 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4151 | bbs_discu | localhost | bbs_discu | Query | 3 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4153 | bbs_discu | localhost | bbs_discu | Query | 3 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4154 | bbs_discu | localhost | bbs_discu | Query | 3 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4155 | bbs_discu | localhost | bbs_discu | Query | 3 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4156 | bbs_discu | localhost | bbs_discu | Query | 3 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4158 | bbs_discu | localhost | bbs_discu | Query | 2 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4159 | bbs_discu | localhost | bbs_discu | Query | 2 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4160 | bbs_discu | localhost | bbs_discu | Query | 2 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4161 | bbs_discu | localhost | bbs_discu | Query | 2 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4162 | bbs_discu | localhost | bbs_discu | Query | 2 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4163 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4165 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4166 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT COUNT(*) FROM pre_forum_thread WHERE fid='17' AND displayorder='-2' AND authorid='59305' |
| 4167 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4168 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4169 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4170 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4171 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4172 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4173 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4175 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4176 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4177 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4178 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4179 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4180 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT * FROM pre_forum_thread WHERE tid='270797' LIMIT 1 |
| 4182 | bbs_discu | localhost | bbs_discu | Query | 1 | Locked | SELECT * FROM pre_forum_thread WHERE tid='202537' LIMIT 1 |
| 4183 | bbs_discu | localhost | bbs_discu | Sleep | 0 | | NULL |
| 4184 | bbs_discu | localhost | bbs_discu | Sleep | 1 | | NULL |
| 4185 | bbs_discu | localhost | bbs_discu | Query | 0 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
| 4186 | bbs_discu | localhost | bbs_discu | Query | 0 | Locked | SELECT * FROM pre_forum_thread WHERE tid='234673' LIMIT 1 |
| 4187 | bbs_discu | localhost | bbs_discu | Query | 0 | Locked | SELECT t.*, f.name FROM pre_forum_thread t, pre_forum_forum f WHERE f.status'3' AND f.fid=t.fid AND f.fid not IN(15) AND t.displayorder not IN(-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10 |
+------+---------------+-----------+---------------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
112 rows in set (0.00 sec) |
