+-------+-------+--------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-------+--------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 84837 | gifyo | localhost | gifyo | Query | 45 | Sending data | UPDATE users u SET nr_pictures = (SELECT count(p.id) FROM pictures p WHERE p.user_id = u.id and p.ac | | 86249 | gifyo | 216.59.15.34:55443 | gifyo | Query | 40 | update | INSERT IGNORE INTO `pictures` SET `id` = NULL, `folder` = '82', `picture` = '4fca3d6c8b8a56c6ed7a584 | | 86421 | gifyo | localhost | gifyo | Query | 37 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2055241' | | 86563 | gifyo | localhost | gifyo | Query | 34 | Updating | UPDATE pictures SET comments = comments + 1 WHERE id = '2055241' | | 86803 | gifyo | localhost | gifyo | Query | 27 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2055241' | | 86804 | gifyo | localhost | gifyo | Sleep | 27 | | | | 86892 | gifyo | localhost | gifyo | Query | 25 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2055241' | | 86893 | gifyo | localhost | gifyo | Sleep | 25 | | | | 87062 | gifyo | localhost | gifyo | Query | 20 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2055245' | | 87063 | gifyo | localhost | gifyo | Sleep | 21 | | | | 87148 | gifyo | localhost | gifyo | Query | 18 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2055245' | | 87149 | gifyo | localhost | gifyo | Sleep | 18 | | | | 87159 | gifyo | localhost | gifyo | Query | 18 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2055241' | | 87160 | gifyo | localhost | gifyo | Sleep | 18 | | | | 87199 | gifyo | localhost | gifyo | Query | 16 | Updating | UPDATE pictures SET views=views+1 WHERE id = '315304' | | 87200 | gifyo | localhost | gifyo | Sleep | 16 | | | | 87206 | gifyo | localhost | gifyo | Query | 16 | Updating | UPDATE pictures SET views=views+1 WHERE id = '632601' | | 87207 | gifyo | localhost | gifyo | Sleep | 16 | | | | 87242 | gifyo | localhost | gifyo | Query | 15 | Updating | UPDATE pictures SET views=views+1 WHERE id = '51167' | | 87243 | gifyo | localhost | gifyo | Sleep | 15 | | | | 87270 | gifyo | localhost | gifyo | Query | 14 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2030164' | | 87271 | gifyo | localhost | gifyo | Sleep | 14 | | | | 87336 | gifyo | localhost | gifyo | Query | 12 | Updating | UPDATE pictures SET views=views+1 WHERE id = '831109' | | 87337 | gifyo | localhost | gifyo | Sleep | 12 | | | | 87342 | gifyo | localhost | gifyo | Query | 12 | Updating | UPDATE pictures SET views=views+1 WHERE id = '1771054' | | 87343 | gifyo | localhost | gifyo | Sleep | 12 | | | | 87452 | gifyo | localhost | gifyo | Query | 9 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2055245' | | 87453 | gifyo | localhost | gifyo | Sleep | 9 | | | | 87484 | gifyo | localhost | gifyo | Query | 8 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2038247' | | 87485 | gifyo | localhost | gifyo | Sleep | 8 | | | | 87493 | gifyo | localhost | gifyo | Query | 8 | Updating | UPDATE pictures SET views=views+1 WHERE id = '717200' | | 87494 | gifyo | localhost | gifyo | Sleep | 8 | | | | 87539 | gifyo | localhost | gifyo | Query | 6 | Updating | UPDATE pictures SET views=views+1 WHERE id = '679948' | | 87540 | gifyo | localhost | gifyo | Sleep | 6 | | | | 87556 | gifyo | localhost | gifyo | Query | 6 | Updating | UPDATE pictures SET views=views+1 WHERE id = '1978901' | | 87557 | gifyo | localhost | gifyo | Sleep | 6 | | | | 87599 | gifyo | localhost | gifyo | Query | 4 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2038247' | | 87600 | gifyo | localhost | gifyo | Sleep | 4 | | | | 87685 | gifyo | 216.59.15.34:55679 | gifyo | Sleep | 2 | | | | 87696 | gifyo | localhost | gifyo | Query | 1 | Updating | UPDATE pictures SET views=views+1 WHERE id = '2047182' | | 87697 | gifyo | localhost | gifyo | Sleep | 1 | | | | 87758 | root | localhost | | Query | 0 | | show processlist | +-------+-------+--------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+