mysql> SHOW FULL PROCESSLIST\G
*************************** 1. row ***************************
Id: 6787
User: web121
Host: localhost
db: usr_web121_1
Command: Query
Time: 639
State: Sending data
Info: SELECT t.boardid, t.threadid, t.lastposttime FROM bb1_threads t WHERE t .visible = 1 AND t.lastposttime > '1389816844' AND t.closed <> 3
*************************** 2. row ***************************
Id: 6984
User: web121
Host: localhost
db: usr_web121_1
Command: Query
Time: 419
State: Sending data
Info: SELECT t.boardid, t.threadid, t.lastposttime FROM bb1_threads t WHERE t .visible = 1 AND t.lastposttime > '1389817064' AND t.closed <> 3
*************************** 3. row ***************************
Id: 7131
User: web121
Host: localhost
db: usr_web121_1
Command: Query
Time: 135
State: Sorting result
Info: SELECT t.*, b.title, b.hotthread_reply, b.hotthread_view
FROM bb1_threads t, bb1_boards b
WHERE (b.boardid IN (1,5,35,37,38,39,40,41,42,43,49,50,51,52,54,55,56,57 ,58,59,60,62,64,66,67,69,70,72,74,76,78,80,84,85,86,87,88,89,90,91,92,93,95,97,9 9,100,102,103,105,106,108,109,111,112,113,115,118,119,120,123,127,128,129,130,13 1,132,134,135,136,137,138,139,140,141)
AND NOT (b.boardid IN (-1)))
AND (b.boardid = t.boardid)
AND (t.visible <> 0)
AND (t.closed < 3)
ORDER BY t.lastposttime DESC LIMIT 10
*************************** 4. row ***************************
Id: 7167
User: web121
Host: localhost
db: usr_web121_1
Command: Query
Time: 80
State: Sorting result
Info: SELECT t.*, b.title, b.hotthread_reply, b.hotthread_view
FROM bb1_threads t, bb1_boards b
WHERE (b.boardid IN (1,5,35,37,38,39,40,41,42,43,49,50,51,52,54,55,56,57 ,58,59,60,62,64,66,67,69,70,72,74,76,78,80,84,85,86,87,88,89,90,91,92,93,95,97,9 9,100,102,103,105,106,108,109,111,112,113,115,118,119,120,123,127,128,129,130,13 1,132,134,135,136,137,138,139,140,141)
AND NOT (b.boardid IN (-1)))
AND (b.boardid = t.boardid)
AND (t.visible <> 0)
AND (t.closed < 3)
ORDER BY t.lastposttime DESC LIMIT 10
*************************** 5. row ***************************
Id: 7192
User: web121
Host: localhost
db: usr_web121_1
Command: Query
Time: 25
State: Sending data
Info: SELECT t.boardid, t.threadid, t.lastposttime FROM bb1_threads t WHERE t .visible = 1 AND t.lastposttime > '1389817458' AND t.closed <> 3
*************************** 6. row ***************************
Id: 7193
User: database45
Host: localhost
db: database45
Command: Sleep
Time: 13
State:
Info: NULL
*************************** 7. row ***************************
Id: 7199
User: database45
Host: localhost
db: database45
Command: Sleep
Time: 1
State:
Info: NULL
*************************** 8. row ***************************
Id: 7204
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: SHOW FULL PROCESSLIST
8 rows in set (0.00 sec)
