SELECT blog_post id blog_post author_id blog_post slug blog_post rende

1
2
3
2 SELECT "blog_post"."id","blog_post"."author_id","blog_post"."slug","blog_post"."render_method","blog_post"."date","blog_post"."upd_date","blog_post"."enable_comments",(blog_posttranslation_ru.language_id) AS "_trans_language_id_ru",(blog_posttranslation_ru.is_featured) AS "_trans_is_featured_ru",(SELECT COUNT(*) FROM blog_posttranslation, comment_nodes, django_content_type WHERE comment_nodes.content_type_id = django_content_type.id AND django_content_type.model = 'posttranslation' AND comment_nodes.object_id = blog_posttranslation.id AND blog_posttranslation.master_id = blog_post.id AND blog_posttranslation.language_id = 2 AND comment_nodes.approved) AS "approved_comments_count",(blog_posttranslation_ru.id) AS "_trans_id_ru",(blog_posttranslation_en.text) AS "_trans_text_en",(blog_posttranslation_en.is_draft) AS "_trans_is_draft_en",(SELECT COUNT(*) FROM blog_posttranslation, pingback, django_content_type WHERE pingback.content_type_id = django_content_type.id AND django_content_type.model = 'posttranslation' AND blog_posttranslation.master_id = blog_post.id AND blog_posttranslation.language_id = 2 AND pingback.object_id = blog_posttranslation.id) AS "pingback_count",(blog_posttranslation_en.language_id) AS "_trans_language_id_en",(blog_posttranslation_en.html) AS "_trans_html_en",(blog_posttranslation_ru.tags) AS "_trans_tags_ru",(blog_posttranslation_ru.master_id) AS "_trans_master_id_ru",(blog_posttranslation_en.name) AS "_trans_name_en",(blog_posttranslation_ru.teaser) AS "_trans_teaser_ru",(blog_posttranslation_ru.text) AS "_trans_text_ru",(blog_posttranslation_ru.is_draft) AS "_trans_is_draft_ru",(blog_posttranslation_en.id) AS "_trans_id_en",(blog_posttranslation_ru.html) AS "_trans_html_ru",(blog_posttranslation_ru.name) AS "_trans_name_ru",(blog_posttranslation_en.is_featured) AS "_trans_is_featured_en",(blog_posttranslation_en.tags) AS "_trans_tags_en",(blog_posttranslation_en.teaser) AS "_trans_teaser_en",(blog_posttranslation_en.master_id) AS "_trans_master_id_en" FROM "blog_post" LEFT JOIN blog_posttranslation AS blog_posttranslation_en ON ((blog_posttranslation_en.master_id = blog_post.id) AND (blog_posttranslation_en.language_id = 1)) LEFT JOIN blog_posttranslation AS blog_posttranslation_ru ON ((blog_posttranslation_ru.master_id = blog_post.id) AND (blog_posttranslation_ru.language_id = 2)) WHERE ("blog_post"."date" BETWEEN '2008-03-22 00:00:00' AND '2008-03-22 23:59:59.999999' AND "blog_post"."slug" = 'new-post') 0.051
3 SELECT "blog_posttranslation"."id","blog_posttranslation"."teaser","blog_posttranslation"."name","blog_posttranslation"."html","blog_posttranslation"."text","blog_posttranslation"."is_draft","blog_posttranslation"."is_featured","blog_posttranslation"."tags","blog_posttranslation"."language_id","blog_posttranslation"."master_id" FROM "blog_posttranslation" WHERE ("blog_posttranslation"."master_id" = 1 AND "blog_posttranslation"."language_id" = 2) 0.001
4 SELECT "blog_posttranslation"."id","blog_posttranslation"."teaser","blog_posttranslation"."name","blog_posttranslation"."html","blog_posttranslation"."text","blog_posttranslation"."is_draft","blog_posttranslation"."is_featured","blog_posttranslation"."tags","blog_posttranslation"."language_id","blog_posttranslation"."master_id" FROM "blog_posttranslation" WHERE ("blog_posttranslation"."master_id" = 1 AND "blog_posttranslation"."language_id" = 2) 0.000