+-----+--------------+-----------+--------------+---------+------+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+--------------+-----------+--------------+---------+------+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 315 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 62 | Sending data | SELECT c.com_id AS comment_id, c.com_itemid AS post_id, c.com_created AS created, c.com_text AS body, c.com_uid AS uid, p.title AS title, p.cat_id AS cat_id FROM xoops_xoopscomments AS c, xoops_weblog_post AS p WHERE c.com_itemid = p.post_id AND c.com_modid = 19 AND p.weblog_id = 235 ORDER BY c.com_created DESC LIMIT 10 |
| 318 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 7 | Sending data | SELECT c.com_id AS comment_id, c.com_itemid AS post_id, c.com_created AS created, c.com_text AS body, c.com_uid AS uid, p.title AS title, p.cat_id AS cat_id FROM xoops_xoopscomments AS c, xoops_weblog_post AS p WHERE c.com_itemid = p.post_id AND c.com_modid = 19 AND p.weblog_id = 334 ORDER BY c.com_created DESC LIMIT 10 |
| 317 | lifewit_lwc2 | localhost | lifewit_lwc2 | Sleep | 8 | | NULL |
| 319 | lifewit_lwc2 | localhost | lifewit_lwc2 | Sleep | 10 | | NULL |
| 322 | lifewit_lwc2 | localhost | lifewit_lwc2 | Sleep | 8 | | NULL |
| 323 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 2 | Sorting result | SELECT c.com_id AS comment_id, c.com_itemid AS post_id, c.com_created AS created, c.com_text AS body, c.com_uid AS uid, p.title AS title, p.cat_id AS cat_id FROM xoops_xoopscomments AS c, xoops_weblog_post AS p WHERE c.com_itemid = p.post_id AND c.com_modid = 19 AND p.weblog_id = 236 ORDER BY c.com_created DESC LIMIT 10 |
| 324 | lifewit_lwc2 | localhost | lifewit_lwc2 | Sleep | 11 | | NULL |
| 326 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 11 | Copying to tmp table | SELECT c.com_itemid AS post_id, p.title AS title, p.cat_id AS cat_id, p.comments AS count, MAX( c.com_created ) AS publish_date FROM xoops_xoopscomments AS c, xoops_weblog_post AS p WHERE c.com_itemid = p.post_id AND c.com_modid = 19 AND p.weblog_id = 249 GROUP BY c.com_itemid ORDER BY publish_date DESC LIMIT 10 |
| 327 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 1 | Sorting for group | SELECT c.com_itemid AS post_id, p.title AS title, p.cat_id AS cat_id, p.comments AS count, MAX( c.com_created ) AS publish_date FROM xoops_xoopscomments AS c, xoops_weblog_post AS p WHERE c.com_itemid = p.post_id AND c.com_modid = 19 AND p.weblog_id = 282 GROUP BY c.com_itemid ORDER BY publish_date DESC LIMIT 10 |
| 330 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 25 | Sending data | SELECT c.com_id AS comment_id, c.com_itemid AS post_id, c.com_created AS created, c.com_text AS body, c.com_uid AS uid, p.title AS title, p.cat_id AS cat_id FROM xoops_xoopscomments AS c, xoops_weblog_post AS p WHERE c.com_itemid = p.post_id AND c.com_modid = 19 AND p.weblog_id = 235 ORDER BY c.com_created DESC LIMIT 10 |
| 332 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 16 | Sending data | SELECT c.com_id AS comment_id, c.com_itemid AS post_id, c.com_created AS created, c.com_text AS body, c.com_uid AS uid, p.title AS title, p.cat_id AS cat_id FROM xoops_xoopscomments AS c, xoops_weblog_post AS p WHERE c.com_itemid = p.post_id AND c.com_modid = 19 AND p.weblog_id = 934 ORDER BY c.com_created DESC LIMIT 10 |
| 333 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 8 | Copying to tmp table | SELECT c.*, COUNT(p.post_id) as entryCount FROM xoops_weblog_cat AS c, xoops_weblog_post AS p WHERE c.cat_id=p.cat_id AND c.weblog_id=1073 AND p.status = 'A' GROUP BY c.cat_id, c.name ORDER BY c.name |
| 334 | lifewit_lwc2 | localhost | lifewit_lwc2 | Query | 5 | Copying to tmp table | SELECT c.*, COUNT(p.post_id) as entryCount FROM xoops_weblog_cat AS c, xoops_weblog_post AS p WHERE c.cat_id=p.cat_id AND c.weblog_id=282 AND p.status = 'A' GROUP BY c.cat_id, c.name ORDER BY c.name |
| 335 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
+-----+--------------+-----------+--------------+---------+------+----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
14 rows in set (0.08 sec)