Posts

web brains [/] About Trac login close Login with password Forgot password? Login with OpenID Archive for September, 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 newforms fastcgi shell middleware decorator punbb pagination форум seo backup бабло awstats foreignkey memoryleak script блоги logrotate orm validation nginx firefox pybb экспорт oscon byteflow блог debugging sape статистика firebug деньги debug template select_related ajax templatetag backend authentication rubyonrails django python sql javascript plugin документация production mercurial Advertize webmaster: lorien debug sql count: 9, sql time: 0.147 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 - 09 - 01 AND 2001 - 10 - 01 ) ORDER BY ` blog_post ` . ` date ` DESC time: 0.014 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.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.027 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.006 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.007 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.007 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.026 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.053 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