rendered paste body SHOW FULL PROCESSLIST;
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2332 | root | 212.58.13.3:30969 | gg | Sleep | 305 | | NULL |
| 2471 | root | 212.58.13.3:31024 | gg | Sleep | 593 | | NULL |
| 2539 | root | localhost | gg | Sleep | 84 | | NULL |
| 3277 | root | 212.58.13.3:31256 | NULL | Sleep | 10 | | NULL |
| 3411 | gg_user | localhost | gg | Query | 4 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='75' ORDER BY news_date DESC LIMIT 1 |
| 3442 | gg_user | localhost | gg | Query | 8 | Sending data | SELECT news.* FROM news LEFT JOIN authors ON news.news_author = authors.author_id WHERE authors.author_position='guest' and DATE(news_date)='2006-12-11' ORDER BY news.news_date DESC LIMIT 1 |
| 3449 | gg_user | localhost | gg | Query | 2 | Locked | SELECT * FROM news WHERE news_cat='magazin' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3456 | gg_user | localhost | gg | Query | 4 | Locked | SELECT * FROM news WHERE news_cat='kultur_sanat' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3485 | gg_user | localhost | gg | Query | 4 | Locked | SELECT * FROM news WHERE news_cat='kadin' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3490 | gg_user | localhost | gg | Query | 5 | Locked | SELECT * FROM news WHERE news_cat='saglik' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3512 | gg_user | localhost | gg | Query | 5 | Locked | SELECT * FROM news WHERE news_cat='ekonomi' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3516 | gg_user | localhost | gg | Query | 0 | Locked | SELECT * FROM news WHERE news_cat='spor' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3517 | gg_user | localhost | gg | Query | 5 | Locked | SELECT * FROM news WHERE news_cat='dunya' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3523 | gg_user | localhost | gg | Query | 0 | Locked | SELECT * FROM news WHERE news_cat='ekonomi' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3540 | gg_user | localhost | gg | Query | 6 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='25' ORDER BY news_date DESC LIMIT 1 |
| 3542 | gg_user | localhost | gg | Query | 0 | Locked | SELECT * FROM news WHERE news_cat='siyaset' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3547 | gg_user | localhost | gg | Query | 5 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3549 | gg_user | localhost | gg | Query | 5 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3557 | gg_user | localhost | gg | Query | 6 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3561 | gg_user | localhost | gg | Query | 4 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='75' ORDER BY news_date DESC LIMIT 1 |
| 3570 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
| 3582 | gg_user | localhost | gg | Query | 4 | Locked | SELECT * FROM news WHERE news_type='main_bottom' ORDER BY news_date DESC LIMIT 2 |
| 3586 | gg_user | localhost | gg | Query | 0 | Locked | SELECT * FROM news WHERE news_type='main' ORDER BY news_date DESC LIMIT 12 |
| 3588 | gg_user | localhost | gg | Query | 6 | Locked | SELECT news_id,news_title,news_date,news_cat FROM news WHERE
news_cat='medya' and news_id!='31995' ORDER BY news_date DESC LIMIT 25 |
| 3589 | gg_user | localhost | gg | Sleep | 0 | | NULL |
| 3590 | gg_user | localhost | gg | Query | 2 | Locked | SELECT * FROM news WHERE (news_type='main' or news_type='cat_main') and news_cat='medya' ORDER BY news_date DESC LIMIT 12 |
| 3593 | gg_user | localhost | gg | Query | 5 | Locked | UPDATE news SET news_hit='7' WHERE news_id='31995' |
| 3595 | gg_user | localhost | gg | Query | 4 | Locked | SELECT * FROM news WHERE news_type='main' ORDER BY news_date DESC LIMIT 12 |
| 3596 | gg_user | localhost | gg | Query | 2 | Locked | SELECT * FROM news WHERE (news_type='main' or news_type='cat_main') and news_cat='medya' ORDER BY news_date DESC LIMIT 12 |
| 3597 | gg_user | localhost | gg | Query | 6 | Locked | UPDATE news SET news_hit='7' WHERE news_id='31995' |
| 3598 | gg_user | localhost | gg | Query | 8 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3599 | gg_user | localhost | gg | Query | 8 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3600 | gg_user | localhost | gg | Query | 8 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3601 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3602 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3603 | gg_user | localhost | gg | Query | 5 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3604 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3605 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3606 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3607 | gg_user | localhost | gg | Query | 1 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3608 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3609 | gg_user | localhost | gg | Query | 4 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3610 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3611 | gg_user | localhost | gg | Query | 6 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3612 | gg_user | localhost | gg | Query | 5 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3613 | gg_user | localhost | gg | Query | 5 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3614 | gg_user | localhost | gg | Query | 6 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3615 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3616 | gg_user | localhost | gg | Query | 7 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3617 | gg_user | localhost | gg | Query | 6 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='2' ORDER BY news_date DESC LIMIT 1 |
| 3618 | gg_user | localhost | gg | Query | 1 | Locked | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='1' ORDER BY news_date DESC LIMIT 1 |
| 3619 | gg_user | localhost | gg | Sleep | 1 | | NULL |
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
52 rows in set (0.03 sec)
mysql> SHOW FULL PROCESSLIST;
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2332 | root | 212.58.13.3:30969 | gg | Sleep | 350 | | NULL |
| 2471 | root | 212.58.13.3:31024 | gg | Sleep | 638 | | NULL |
| 2539 | root | localhost | gg | Sleep | 40 | | NULL |
| 3277 | root | 212.58.13.3:31256 | NULL | Sleep | 55 | | NULL |
| 3449 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='25' ORDER BY news_date DESC LIMIT 1 |
| 3456 | gg_user | localhost | gg | Query | 1 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3485 | gg_user | localhost | gg | Query | 0 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='75' ORDER BY news_date DESC LIMIT 1 |
| 3490 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='59' ORDER BY news_date DESC LIMIT 1 |
| 3523 | gg_user | localhost | gg | Query | 1 | closing tables | SELECT * FROM news WHERE news_cat='magazin' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3542 | gg_user | localhost | gg | Query | 1 | closing tables | SELECT * FROM news WHERE news_cat='saglik' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3570 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
| 3582 | gg_user | localhost | gg | Sleep | 0 | | NULL |
| 3586 | gg_user | localhost | gg | Query | 2 | Sorting result | SELECT * FROM news WHERE news_cat='dunya' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3589 | gg_user | localhost | gg | Query | 1 | closing tables | SELECT * FROM news WHERE news_cat='ekonomi' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3595 | gg_user | localhost | gg | Query | 5 | Sorting result | SELECT * FROM news WHERE news_cat='siyaset' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3596 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3599 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT news.* FROM news LEFT JOIN authors ON news.news_author = authors.author_id WHERE authors.author_position='today' and DATE(news_date)='2006-12-11' ORDER BY news.news_date DESC LIMIT 1 |
| 3600 | gg_user | localhost | gg | Query | 2 | Sorting result | SELECT * FROM news WHERE news_cat='ekonomi' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3601 | gg_user | localhost | gg | Sleep | 0 | NULL | NULL |
| 3602 | gg_user | localhost | gg | Query | 2 | closing tables | SELECT news.* FROM news LEFT JOIN authors ON news.news_author = authors.author_id WHERE authors.author_position='today' and DATE(news_date)='2006-12-11' ORDER BY news.news_date DESC LIMIT 1 |
| 3604 | gg_user | localhost | gg | Query | 2 | closing tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='75' ORDER BY news_date DESC LIMIT 1 |
| 3608 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='75' ORDER BY news_date DESC LIMIT 1 |
| 3610 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3615 | gg_user | localhost | gg | Query | 0 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3619 | gg_user | localhost | gg | Query | 3 | Sorting result | SELECT * FROM news WHERE news_cat='guncel' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3632 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM ads_cache WHERE cacheid = 'what=zone:2' |
| 3633 | gg_user | localhost | gg | Query | 2 | Sorting result | SELECT * FROM news WHERE news_cat='guncel' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3635 | gg_user | localhost | gg | Query | 5 | Sorting result | SELECT * FROM news WHERE news_type='main' ORDER BY news_date DESC LIMIT 12 |
| 3636 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='73' ORDER BY news_date DESC LIMIT 1 |
| 3637 | gg_user | localhost | gg | Query | 2 | closing tables | SELECT * FROM news WHERE news_cat='guncel' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3638 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='59' ORDER BY news_date DESC LIMIT 1 |
| 3640 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT * FROM news WHERE news_cat='guncel' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3643 | gg_user | localhost | gg | Query | 5 | Sorting result | SELECT * FROM news WHERE news_type='main_bottom' ORDER BY news_date DESC LIMIT 2 |
| 3644 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM news WHERE news_cat='guncel' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3646 | gg_user | localhost | gg | Query | 4 | Sorting result | SELECT news_id,news_title,news_date,news_cat FROM news WHERE
news_cat='kultur_sanat' and news_id!='26521' ORDER BY news_date DESC LIMIT 25 |
| 3649 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT * FROM news WHERE news_cat='guncel' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3656 | gg_user | localhost | gg | Query | 2 | closing tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='45' ORDER BY news_date DESC LIMIT 1 |
| 3658 | gg_user | localhost | gg | Query | 1 | closing tables | SELECT * FROM news WHERE news_type='right' ORDER BY news_date DESC LIMIT 1 |
| 3662 | gg_user | localhost | gg | Query | 2 | closing tables | SELECT * FROM news WHERE news_type='main' ORDER BY news_date DESC LIMIT 12 |
| 3665 | gg_user | localhost | gg | Query | 6 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3666 | gg_user | localhost | gg | Query | 2 | closing tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='3' ORDER BY news_date DESC LIMIT 1 |
| 3671 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='3' ORDER BY news_date DESC LIMIT 1 |
| 3673 | gg_user | localhost | gg | Query | 1 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3675 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='1' ORDER BY news_date DESC LIMIT 1 |
| 3676 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM market LIMIT 1 |
| 3677 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM ads_cache WHERE cacheid = 'bannerid=41' |
| 3678 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM ads_cache WHERE cacheid = 'bannerid=55' |
| 3679 | gg_user | localhost | gg | Query | 1 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3680 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='1' ORDER BY news_date DESC LIMIT 1 |
| 3681 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM ads_cache WHERE cacheid = 'what=zone:1' |
| 3682 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM ads_cache WHERE cacheid = 'what=zone:1' |
| 3683 | gg_user | localhost | gg | Query | 0 | Opening tables | SELECT * FROM ads_cache WHERE cacheid = 'what=zone:1' |
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
52 rows in set (0.00 sec)
mysql> SHOW FULL PROCESSLIST;
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2332 | root | 212.58.13.3:30969 | gg | Sleep | 362 | | NULL |
| 2471 | root | 212.58.13.3:31024 | gg | Sleep | 650 | | NULL |
| 2539 | root | localhost | gg | Sleep | 52 | | NULL |
| 3277 | root | 212.58.13.3:31256 | NULL | Sleep | 67 | | NULL |
| 3449 | gg_user | localhost | gg | Query | 7 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3456 | gg_user | localhost | gg | Query | 1 | Sending data | SELECT news.* FROM news LEFT JOIN authors ON news.news_author = authors.author_id WHERE authors.author_position='today' and DATE(news_date)='2006-12-11' ORDER BY news.news_date DESC LIMIT 1 |
| 3485 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT * FROM news WHERE DATE(news_date) = '2006-12-11' ORDER BY news_hit DESC LIMIT 10 |
| 3490 | gg_user | localhost | gg | Query | 7 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='73' ORDER BY news_date DESC LIMIT 1 |
| 3570 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
| 3582 | gg_user | localhost | gg | Query | 6 | Opening tables | SELECT * FROM news WHERE news_cat='spor' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3586 | gg_user | localhost | gg | Query | 3 | Sorting result | SELECT * FROM news WHERE news_cat='ekonomi' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3589 | gg_user | localhost | gg | Query | 12 | closing tables | SELECT * FROM news WHERE news_cat='dunya' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3595 | gg_user | localhost | gg | Query | 7 | closing tables | SELECT * FROM news WHERE news_cat='dunya' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3596 | gg_user | localhost | gg | Sleep | 2 | NULL | NULL |
| 3599 | gg_user | localhost | gg | Query | 3 | statistics | SELECT news.* FROM news LEFT JOIN authors ON news.news_author = authors.author_id WHERE authors.author_position='guest' and DATE(news_date)='2006-12-11' ORDER BY news.news_date DESC LIMIT 1 |
| 3600 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT * FROM news WHERE news_cat='spor' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3601 | gg_user | localhost | gg | Query | 7 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='75' ORDER BY news_date DESC LIMIT 1 |
| 3602 | gg_user | localhost | gg | Query | 1 | closing tables | SELECT * FROM authors WHERE author_id='81' LIMIT 1 |
| 3608 | gg_user | localhost | gg | Query | 5 | Sending data | SELECT news.* FROM news LEFT JOIN authors ON news.news_author = authors.author_id WHERE authors.author_position='guest' and DATE(news_date)='2006-12-11' ORDER BY news.news_date DESC LIMIT 1 |
| 3610 | gg_user | localhost | gg | Query | 4 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='79' ORDER BY news_date DESC LIMIT 1 |
| 3615 | gg_user | localhost | gg | Query | 7 | closing tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='79' ORDER BY news_date DESC LIMIT 1 |
| 3619 | gg_user | localhost | gg | Query | 1 | Opening tables | SELECT * FROM news WHERE news_cat='dunya' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3632 | gg_user | localhost | gg | Query | 1 | Sorting result | SELECT * FROM news WHERE news_cat='siyaset' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3633 | gg_user | localhost | gg | Query | 6 | Opening tables | SELECT * FROM cats WHERE cat_nice_name='siyaset' LIMIT 1 |
| 3635 | gg_user | localhost | gg | Query | 7 | Sorting result | SELECT * FROM news WHERE news_type='main_bottom' ORDER BY news_date DESC LIMIT 2 |
| 3636 | gg_user | localhost | gg | Query | 3 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='25' ORDER BY news_date DESC LIMIT 1 |
| 3637 | gg_user | localhost | gg | Query | 7 | closing tables | SELECT * FROM cats WHERE cat_nice_name='siyaset' LIMIT 1 |
| 3638 | gg_user | localhost | gg | Query | 2 | Sending data | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='34' ORDER BY news_date DESC LIMIT 1 |
| 3640 | gg_user | localhost | gg | Query | 11 | closing tables | SELECT * FROM news WHERE news_cat='siyaset' and news_type='cat_home' ORDER BY news_date DESC LIMIT 1 |
| 3643 | gg_user | localhost | gg | Query | 1 | Sending data | SELECT * FROM ads_cache WHERE cacheid = 'what=zone:2' |
| 3644 | gg_user | localhost | gg | Query | 6 | Opening tables | SELECT * FROM cats WHERE cat_nice_name='guncel' LIMIT 1 |
| 3646 | gg_user | localhost | gg | Query | 5 | closing tables | SELECT news_id,news_date,news_type,news_title FROM news WHERE news_type='interview' ORDER BY news_date DESC LIMIT 1 |
| 3649 | gg_user | localhost | gg | Query | 5 | Sorting result | SELECT * FROM news WHERE news_cat='guncel' and news_type!='column' and news_type!='cat_home' ORDER BY news_date DESC LIMIT 5 |
| 3658 | gg_user | localhost | gg | Query | 5 | closing tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='59' ORDER BY news_date DESC LIMIT 1 |
| 3662 | gg_user | localhost | gg | Query | 4 | closing tables | SELECT * FROM ads_cache WHERE cacheid = 'what=zone:2' |
| 3665 | gg_user | localhost | gg | Query | 18 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3671 | gg_user | localhost | gg | Query | 3 | Opening tables | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='45' ORDER BY news_date DESC LIMIT 1 |
| 3673 | gg_user | localhost | gg | Query | 13 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3675 | gg_user | localhost | gg | Query | 4 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='3' ORDER BY news_date DESC LIMIT 1 |
| 3676 | gg_user | localhost | gg | Query | 11 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3677 | gg_user | localhost | gg | Query | 11 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3678 | gg_user | localhost | gg | Query | 11 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3679 | gg_user | localhost | gg | Query | 13 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3680 | gg_user | localhost | gg | Query | 2 | Sorting result | SELECT news_author,news_id,news_title,news_type FROM news WHERE news_type='column' and news_author='3' ORDER BY news_date DESC LIMIT 1 |
| 3681 | gg_user | localhost | gg | Query | 11 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3682 | gg_user | localhost | gg | Query | 10 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3683 | gg_user | localhost | gg | Query | 11 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3686 | gg_user | localhost | gg | Query | 3 | Copying to tmp table | SELECT DISTINCT news.* FROM news LEFT JOIN comments ON news.news_id = comments.com_news WHERE comments.com_status='online' ORDER BY comments.com_date DESC LIMIT 5 |
| 3687 | gg_user | localhost | gg | Query | 6 | Opening tables | SELECT * FROM authors WHERE author_position='top' and author_status='online' ORDER BY author_ordinal LIMIT 4 |
| 3688 | gg_user | localhost | gg | Query | 6 | Opening tables | SELECT * FROM authors WHERE author_position='top' and author_status='online' ORDER BY author_ordinal LIMIT 4 |
| 3689 | gg_user | localhost | gg | Query | 3 | Opening tables | SELECT * FROM authors WHERE author_position='top' and author_status='online' ORDER BY author_ordinal LIMIT 4 |
+------+---------+-------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
51 rows in set (0.00 sec)