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)