Posts

web brains [/] About Trac login close Login with password Forgot password? Login with OpenID Archive for May, 2001 Previous month Next month Last comments lorien » Просмотр SQL запросов в Django: часть2 Лунная соната » Просмотр SQL запросов в Django: часть2 Фадеев » Firefox3 && firebug Фадеев » Просмотр SQL запросов в Django: часть2 Константин » Просмотр SQL запросов в Django: часть2 Last posts Просмотр SQL запросов в Django: часть2 Firefox3 && firebug Плагины для веб приложения на django Розовый попятчсо Тестирование импорта сообщений Useful information Blog feed Comments feed Tags seo firefox authentication debug oscon nginx select_related firebug middleware форум plugin memoryleak newforms production backup validation templatetag orm ajax template javascript блог mercurial pagination rubyonrails byteflow sql awstats foreignkey python деньги script экспорт logrotate django debugging блоги punbb бабло pybb статистика fastcgi sape shell документация decorator backend Advertize webmaster: lorien debug sql count: 9, sql time: 0.062 time: 0.002 SELECT ` blog_post ` . ` id ` , ` blog_post ` . ` author_id ` , ` blog_post ` . ` name ` , ` blog_post ` . ` slug ` , ` blog_post ` . ` teaser ` , ` blog_post ` . ` text ` , ` blog_post ` . ` render_method ` , ` blog_post ` . ` html ` , ` blog_post ` . ` date ` , ` blog_post ` . ` is_draft ` , ` blog_post ` . ` is_featured ` , ` blog_post ` . ` enable_comments ` , ` blog_post ` . ` tags ` ,( SELECT COUNT ( * ) FROM comment_nodes , django_content_type WHERE comment_nodes . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND comment_nodes . object_id = blog_post . id AND comment_nodes . approved ) AS ` approved_comments_count ` , ( SELECT COUNT ( * ) FROM pingback , django_content_type WHERE pingback . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND pingback . object_id = blog_post . id ) AS ` pingback_count ` FROM ` blog_post ` WHERE ( ` blog_post ` . ` is_draft ` = False AND ` blog_post ` . ` date ` BETWEEN 2001 - 05 - 01 AND 2001 - 06 - 01 ) ORDER BY ` blog_post ` . ` date ` DESC time: 0.002 SELECT ` comment_nodes ` . ` id ` , ` comment_nodes ` . ` user_id ` , ` comment_nodes ` . ` pub_date ` , ` comment_nodes ` . ` body ` , ` comment_nodes ` . ` body_html ` , ` comment_nodes ` . ` reply_to_id ` , ` comment_nodes ` . ` approved ` , ` comment_nodes ` . ` content_type_id ` , ` comment_nodes ` . ` object_id ` , ` comment_nodes ` . ` lft ` , ` comment_nodes ` . ` rght ` , ` auth_user ` . ` id ` , ` auth_user ` . ` username ` , ` auth_user ` . ` first_name ` , ` auth_user ` . ` last_name ` , ` auth_user ` . ` email ` , ` auth_user ` . ` password ` , ` auth_user ` . ` is_staff ` , ` auth_user ` . ` is_active ` , ` auth_user ` . ` is_superuser ` , ` auth_user ` . ` last_login ` , ` auth_user ` . ` date_joined ` , ` auth_user ` . ` site ` , ` auth_user ` . ` email_new ` , ` django_content_type ` . ` id ` , ` django_content_type ` . ` name ` , ` django_content_type ` . ` app_label ` , ` django_content_type ` . ` model ` FROM ` comment_nodes ` , ` auth_user ` , ` django_content_type ` WHERE ( ` comment_nodes ` . ` approved ` = True ) AND ` comment_nodes ` . ` user_id ` = ` auth_user ` . ` id ` AND ` comment_nodes ` . ` content_type_id ` = ` django_content_type ` . ` id ` ORDER BY ` comment_nodes ` . ` pub_date ` DESC LIMIT 5 time: 0.002 SELECT ` blog_post ` . ` id ` , ` blog_post ` . ` author_id ` , ` blog_post ` . ` name ` , ` blog_post ` . ` slug ` , ` blog_post ` . ` teaser ` , ` blog_post ` . ` text ` , ` blog_post ` . ` render_method ` , ` blog_post ` . ` html ` , ` blog_post ` . ` date ` , ` blog_post ` . ` is_draft ` , ` blog_post ` . ` is_featured ` , ` blog_post ` . ` enable_comments ` , ` blog_post ` . ` tags ` ,( SELECT COUNT ( * ) FROM comment_nodes , django_content_type WHERE comment_nodes . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND comment_nodes . object_id = blog_post . id AND comment_nodes . approved ) AS ` approved_comments_count ` , ( SELECT COUNT ( * ) FROM pingback , django_content_type WHERE pingback . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND pingback . object_id = blog_post . id ) AS ` pingback_count ` FROM ` blog_post ` WHERE ( ` blog_post ` . ` id ` = 28 ) time: 0.005 SELECT ` blog_post ` . ` id ` , ` blog_post ` . ` author_id ` , ` blog_post ` . ` name ` , ` blog_post ` . ` slug ` , ` blog_post ` . ` teaser ` , ` blog_post ` . ` text ` , ` blog_post ` . ` render_method ` , ` blog_post ` . ` html ` , ` blog_post ` . ` date ` , ` blog_post ` . ` is_draft ` , ` blog_post ` . ` is_featured ` , ` blog_post ` . ` enable_comments ` , ` blog_post ` . ` tags ` ,( SELECT COUNT ( * ) FROM comment_nodes , django_content_type WHERE comment_nodes . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND comment_nodes . object_id = blog_post . id AND comment_nodes . approved ) AS ` approved_comments_count ` , ( SELECT COUNT ( * ) FROM pingback , django_content_type WHERE pingback . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND pingback . object_id = blog_post . id ) AS ` pingback_count ` FROM ` blog_post ` WHERE ( ` blog_post ` . ` id ` = 28 ) time: 0.016 SELECT ` blog_post ` . ` id ` , ` blog_post ` . ` author_id ` , ` blog_post ` . ` name ` , ` blog_post ` . ` slug ` , ` blog_post ` . ` teaser ` , ` blog_post ` . ` text ` , ` blog_post ` . ` render_method ` , ` blog_post ` . ` html ` , ` blog_post ` . ` date ` , ` blog_post ` . ` is_draft ` , ` blog_post ` . ` is_featured ` , ` blog_post ` . ` enable_comments ` , ` blog_post ` . ` tags ` ,( SELECT COUNT ( * ) FROM comment_nodes , django_content_type WHERE comment_nodes . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND comment_nodes . object_id = blog_post . id AND comment_nodes . approved ) AS ` approved_comments_count ` , ( SELECT COUNT ( * ) FROM pingback , django_content_type WHERE pingback . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND pingback . object_id = blog_post . id ) AS ` pingback_count ` FROM ` blog_post ` WHERE ( ` blog_post ` . ` id ` = 27 ) time: 0.004 SELECT ` blog_post ` . ` id ` , ` blog_post ` . ` author_id ` , ` blog_post ` . ` name ` , ` blog_post ` . ` slug ` , ` blog_post ` . ` teaser ` , ` blog_post ` . ` text ` , ` blog_post ` . ` render_method ` , ` blog_post ` . ` html ` , ` blog_post ` . ` date ` , ` blog_post ` . ` is_draft ` , ` blog_post ` . ` is_featured ` , ` blog_post ` . ` enable_comments ` , ` blog_post ` . ` tags ` ,( SELECT COUNT ( * ) FROM comment_nodes , django_content_type WHERE comment_nodes . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND comment_nodes . object_id = blog_post . id AND comment_nodes . approved ) AS ` approved_comments_count ` , ( SELECT COUNT ( * ) FROM pingback , django_content_type WHERE pingback . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND pingback . object_id = blog_post . id ) AS ` pingback_count ` FROM ` blog_post ` WHERE ( ` blog_post ` . ` id ` = 28 ) time: 0.005 SELECT ` blog_post ` . ` id ` , ` blog_post ` . ` author_id ` , ` blog_post ` . ` name ` , ` blog_post ` . ` slug ` , ` blog_post ` . ` teaser ` , ` blog_post ` . ` text ` , ` blog_post ` . ` render_method ` , ` blog_post ` . ` html ` , ` blog_post ` . ` date ` , ` blog_post ` . ` is_draft ` , ` blog_post ` . ` is_featured ` , ` blog_post ` . ` enable_comments ` , ` blog_post ` . ` tags ` ,( SELECT COUNT ( * ) FROM comment_nodes , django_content_type WHERE comment_nodes . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND comment_nodes . object_id = blog_post . id AND comment_nodes . approved ) AS ` approved_comments_count ` , ( SELECT COUNT ( * ) FROM pingback , django_content_type WHERE pingback . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND pingback . object_id = blog_post . id ) AS ` pingback_count ` FROM ` blog_post ` WHERE ( ` blog_post ` . ` id ` = 28 ) time: 0.021 SELECT ` blog_post ` . ` id ` , ` blog_post ` . ` author_id ` , ` blog_post ` . ` name ` , ` blog_post ` . ` slug ` , ` blog_post ` . ` teaser ` , ` blog_post ` . ` text ` , ` blog_post ` . ` render_method ` , ` blog_post ` . ` html ` , ` blog_post ` . ` date ` , ` blog_post ` . ` is_draft ` , ` blog_post ` . ` is_featured ` , ` blog_post ` . ` enable_comments ` , ` blog_post ` . ` tags ` ,( SELECT COUNT ( * ) FROM comment_nodes , django_content_type WHERE comment_nodes . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND comment_nodes . object_id = blog_post . id AND comment_nodes . approved ) AS ` approved_comments_count ` , ( SELECT COUNT ( * ) FROM pingback , django_content_type WHERE pingback . content_type_id = django_content_type . id AND django_content_type . model = 'post' AND pingback . object_id = blog_post . id ) AS ` pingback_count ` FROM ` blog_post ` WHERE ( ` blog_post ` . ` is_draft ` = False ) ORDER BY ` blog_post ` . ` date ` DESC LIMIT 5 time: 0.005 SELECT DISTINCT ` tag ` . id , ` tag ` . name , COUNT ( ` blog_post ` . ` id ` ) FROM ` tag ` INNER JOIN ` tagged_item ` ON ` tag ` . id = ` tagged_item ` . tag_id INNER JOIN ` blog_post ` ON ` tagged_item ` . object_id = ` blog_post ` . ` id ` WHERE ` tagged_item ` . content_type_id = 12 GROUP BY ` tag ` . id , ` tag ` . name ORDER BY ` tag ` . name ASC