- 论坛徽章:
- 0
|
mysql> show full processlist
-> ;
+-----+------------------+-----------+-----------------------+---------+------+-
---------------+----------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------+
| Id | User | Host | db | Command | Time |
State | Info
|
+-----+------------------+-----------+-----------------------+---------+------+-
---------------+----------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------+
| 264 | rym3_hok | localhost | rym3_ah | Sleep | 386 |
| NULL
|
| 265 | rym3_hok | localhost | rym3_ah | Sleep | 385 |
| NULL
|
| 267 | rym3_hok | localhost | rym3_ah | Sleep | 116 |
| NULL
|
| 268 | rym3_hok | localhost | rym3_ah | Query | 0 |
Sorting result | Select arc.ID,arc.title,arc.iscommend,arc.color,
arc.typeid,arc.ismake,arc.money,arc.description,arc.shorttitle,
arc.memberid,arc.writer,arc.postnum,arc.lastpost,
arc.pubdate,arc.senddate,arc.arcrank,arc.click,arc.litpic,
tp.typedir,tp.typename,tp.isdefault,tp.defaultname,
tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl
,dede_addon15.ask,dede_addon15.answer
from dede_archives arc
left join dede_arctype tp on arc.typeid=tp.ID
left join dede_addon15 on arc.ID = dede_addon15.aid
where arc.arcrank > -1 And ( ( arc.typeid='2' ) Or arc.typ
eid2='2') order by arc.sortrank desc limit 1315,263 |
| 270 | rym3_hok | localhost | rym3_ah | Sleep | 388 |
| NULL
|
| 271 | rym3_hok | localhost | rym3_ah | Sleep | 65 |
| NULL
|
| 272 | rym3_hok | localhost | rym3_ah | Sleep | 277 |
| NULL
|
| 273 | rym3_hok | localhost | rym3_ah | Sleep | 384 |
| NULL
|
| 274 | rym3_hok | localhost | rym3_ah | Sleep | 11 |
| NULL
|
| 275 | rym3_hok | localhost | rym3_ah | Sleep | 185 |
| NULL
|
| 289 | root | localhost | NULL | Query | 0 |
NULL | show full processlist
|
+-----+------------------+-----------+-----------------------+---------+------+-
---------------+----------------------------------------------------------------
--------------------------------------------------------------------------------
11 rows in set (0.00 sec) |
|