rendered paste body+----------+-------+--------------------+-------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+-------+--------------------+-------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
| 13372791 | gifyo | 216.59.15.34:53612 | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '180873' |
| 13372845 | gifyo | 216.59.15.34:53619 | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '288828' |
| 13372905 | gifyo | 216.59.15.34:53630 | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '61712' |
| 13372936 | gifyo | localhost | gifyo | Query | 15 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372937 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372938 | gifyo | localhost | gifyo | Query | 0 | Sending data | UPDATE users u SET nr_pictures = (SELECT count(p.id) FROM pictures p WHERE p.user_id = u.id and p.ac |
| 13372939 | gifyo | localhost | gifyo | Query | 15 | Waiting for table level lock | REPLACE INTO stats SET
added = 1332486000,
nr_booths = (select count(id) from pictures |
| 13372942 | gifyo | localhost | gifyo | Query | 15 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372943 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372948 | gifyo | 216.59.15.34:53635 | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '48805' |
| 13372956 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '91442' |
| 13372957 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372962 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '186379' |
| 13372963 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372966 | gifyo | localhost | gifyo | Query | 15 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372967 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372975 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372976 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372980 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372981 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372982 | gifyo | localhost | gifyo | Query | 15 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372983 | gifyo | localhost | gifyo | Sleep | 15 | | |
| 13372989 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '85983' |
| 13372990 | gifyo | localhost | gifyo | Sleep | 14 | | |
| 13372991 | gifyo | localhost | gifyo | Query | 14 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372992 | gifyo | localhost | gifyo | Sleep | 14 | | |
| 13372995 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372996 | gifyo | localhost | gifyo | Sleep | 14 | | |
| 13372998 | gifyo | 216.59.15.34:53652 | gifyo | Query | 10 | Waiting for table level lock | INSERT IGNORE INTO `pictures` SET `id` = NULL, `folder` = '44', `picture` = '39af9771c6507b6c7e2ff87 |
| 13372999 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT u.user, u.id, u.nr_pictures as total, u.id as id
FROM followers f
LEF |
| 13373000 | gifyo | localhost | gifyo | Sleep | 14 | | |
| 13373008 | gifyo | localhost | gifyo | Query | 14 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373009 | gifyo | localhost | gifyo | Sleep | 14 | | |
| 13373010 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '86562' |
| 13373011 | gifyo | localhost | gifyo | Sleep | 13 | | |
| 13373016 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '321377' |
| 13373017 | gifyo | localhost | gifyo | Sleep | 13 | | |
| 13373022 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '98419' |
| 13373024 | gifyo | localhost | gifyo | Sleep | 13 | | |
| 13373037 | gifyo | localhost | gifyo | Query | 13 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373038 | gifyo | localhost | gifyo | Sleep | 13 | | |
| 13373043 | gifyo | localhost | gifyo | Query | 13 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373044 | gifyo | localhost | gifyo | Sleep | 13 | | |
| 13373051 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT u.user, u.id, u.nr_pictures as total, u.id as id
FROM followers f
LEF |
| 13373052 | gifyo | localhost | gifyo | Sleep | 13 | | |
| 13373053 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373054 | gifyo | localhost | gifyo | Sleep | 12 | | |
| 13373055 | gifyo | localhost | gifyo | Query | 12 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373056 | gifyo | localhost | gifyo | Sleep | 12 | | |
| 13373057 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '230996' |
| 13373058 | gifyo | localhost | gifyo | Sleep | 12 | | |
| 13373059 | gifyo | localhost | gifyo | Query | 12 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373060 | gifyo | localhost | gifyo | Sleep | 12 | | |
| 13373066 | gifyo | localhost | gifyo | Query | 12 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373067 | gifyo | localhost | gifyo | Sleep | 12 | | |
| 13373068 | gifyo | localhost | gifyo | Query | 12 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373069 | gifyo | localhost | gifyo | Sleep | 12 | | |
| 13373082 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT u.user, u.id, u.nr_pictures as total, u.id as id
FROM followers f
LEF |
| 13373083 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373084 | gifyo | localhost | gifyo | Query | 11 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373085 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373088 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '320224' |
| 13373089 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373093 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '28519' |
| 13373094 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373095 | gifyo | localhost | gifyo | Query | 11 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373096 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373097 | gifyo | localhost | gifyo | Query | 11 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373098 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373101 | gifyo | localhost | gifyo | Query | 11 | Waiting for table level lock | UPDATE pictures SET comments = comments + 1 WHERE id = '2054953' |
| 13373102 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373103 | gifyo | localhost | gifyo | Query | 11 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373104 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373109 | gifyo | localhost | gifyo | Query | 11 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373110 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373111 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '124967' |
| 13373112 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373115 | gifyo | localhost | gifyo | Query | 11 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373116 | gifyo | localhost | gifyo | Sleep | 11 | | |
| 13373120 | gifyo | localhost | gifyo | Query | 10 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373121 | gifyo | localhost | gifyo | Sleep | 10 | | |
| 13373122 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373123 | gifyo | localhost | gifyo | Sleep | 10 | | |
| 13373124 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '267546' |
| 13373125 | gifyo | localhost | gifyo | Sleep | 10 | | |
| 13373127 | gifyo | localhost | gifyo | Query | 10 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373128 | gifyo | localhost | gifyo | Sleep | 10 | | |
| 13373132 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '6569' |
| 13373133 | gifyo | localhost | gifyo | Sleep | 10 | | |
| 13373134 | gifyo | localhost | gifyo | Query | 10 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373135 | gifyo | localhost | gifyo | Sleep | 10 | | |
| 13373138 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373139 | gifyo | localhost | gifyo | Sleep | 9 | | |
| 13373140 | gifyo | localhost | gifyo | Query | 9 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373141 | gifyo | localhost | gifyo | Sleep | 9 | | |
| 13373149 | gifyo | localhost | gifyo | Query | 9 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373150 | gifyo | localhost | gifyo | Sleep | 9 | | |
| 13373151 | gifyo | localhost | gifyo | Query | 9 | Waiting for table level lock | UPDATE pictures SET comments = comments + 1 WHERE id = '2054954' |
| 13373152 | gifyo | localhost | gifyo | Sleep | 9 | | |
| 13373155 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373156 | gifyo | localhost | gifyo | Sleep | 9 | | |
| 13373164 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '98481' |
| 13373165 | gifyo | localhost | gifyo | Sleep | 9 | | |
| 13373170 | gifyo | localhost | gifyo | Query | 8 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373171 | gifyo | localhost | gifyo | Sleep | 8 | | |
| 13373172 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '224932' |
| 13373173 | gifyo | localhost | gifyo | Sleep | 8 | | |
| 13373174 | gifyo | localhost | gifyo | Query | 0 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373175 | gifyo | localhost | gifyo | Sleep | 8 | | |
| 13373176 | gifyo | localhost | gifyo | Query | 8 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
|
| 13373177 | gifyo | localhost | gifyo | Sleep | 8 | | |
| 13373178 | gifyo | localhost | gifyo | Query | 8 | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373179 | gifyo | localhost | gifyo | Sleep | 8 | | |
| 13373189 | gifyo | 216.59.15.34:53682 | gifyo | Sleep | 4 | | |
| 13373191 | root | localhost | | Query | 0 | | show processlist |
+----------+-------+--------------------+-------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+