I love prefetch....

gistfile1.sql

SELECT "me"."id", "me"."users_id", "me"."context", "me"."context_id",
"me"."content", "me"."deleted", "me"."created", "me"."updated",
"me"."parent_id", "user"."id", "user"."username", "user"."public",
"user"."admin", "user"."email", "user"."gravatar_email",
"user"."userpage", "user"."data", "user"."notes", "user"."created",
"user"."updated", "user"."roles", "token"."id", "token"."msgid",
"token"."msgid_plural", "token"."msgctxt", "token"."type",
"token"."data", "token"."notes", "token"."token_domain_id",
"token"."created", "token"."updated", "token_domain"."id",
"token_domain"."key", "token_domain"."name",
"token_domain"."description", "token_domain"."data",
"token_domain"."sorting", "token_domain"."source_language_id",
"token_domain"."sticky_notes", "token_domain"."notes",
"token_domain"."created", "token_domain"."updated", "user_blog"."id",
"user_blog"."users_id", "user_blog"."translation_of_id",
"user_blog"."title", "user_blog"."uri", "user_blog"."teaser",
"user_blog"."content", "user_blog"."topics",
"user_blog"."company_blog", "user_blog"."raw_html",
"user_blog"."live", "user_blog"."language_id", "user_blog"."data",
"user_blog"."fixed_date", "user_blog"."created",
"user_blog"."updated", "user_2"."id", "user_2"."username",
"user_2"."public", "user_2"."admin", "user_2"."email",
"user_2"."gravatar_email", "user_2"."userpage", "user_2"."data",
"user_2"."notes", "user_2"."created", "user_2"."updated",
"user_2"."roles", "token_language_translation_vote"."id",
"token_language_translation_vote"."users_id",
"token_language_translation_vote"."token_language_translation_id",
"token_language_translation_vote"."created",
"token_language_translation_vote"."updated", "user_3"."id",
"user_3"."username", "user_3"."public", "user_3"."admin",
"user_3"."email", "user_3"."gravatar_email", "user_3"."userpage",
"user_3"."data", "user_3"."notes", "user_3"."created",
"user_3"."updated", "user_3"."roles",
"token_language_translation"."id",
"token_language_translation"."msgstr0",
"token_language_translation"."msgstr1",
"token_language_translation"."msgstr2",
"token_language_translation"."msgstr3",
"token_language_translation"."msgstr4",
"token_language_translation"."msgstr5",
"token_language_translation"."data",
"token_language_translation"."notes",
"token_language_translation"."token_language_id",
"token_language_translation"."check_result",
"token_language_translation"."check_timestamp",
"token_language_translation"."check_users_id",
"token_language_translation"."username",
"token_language_translation"."created",
"token_language_translation"."updated", "user_4"."id",
"user_4"."username", "user_4"."public", "user_4"."admin",
"user_4"."email", "user_4"."gravatar_email", "user_4"."userpage",
"user_4"."data", "user_4"."notes", "user_4"."created",
"user_4"."updated", "user_4"."roles", "token_language"."id",
"token_language"."token_id",
"token_language"."token_domain_language_id", "token_language"."notes",
"token_language"."msgstr0", "token_language"."msgstr1",
"token_language"."msgstr2", "token_language"."msgstr3",
"token_language"."msgstr4", "token_language"."msgstr5",
"token_language"."translator_users_id", "token_language"."data",
"token_language"."created", "token_language"."updated",
"token_2"."id", "token_2"."msgid", "token_2"."msgid_plural",
"token_2"."msgctxt", "token_2"."type", "token_2"."data",
"token_2"."notes", "token_2"."token_domain_id", "token_2"."created",
"token_2"."updated", "token_domain_2"."id", "token_domain_2"."key",
"token_domain_2"."name", "token_domain_2"."description",
"token_domain_2"."data", "token_domain_2"."sorting",
"token_domain_2"."source_language_id",
"token_domain_2"."sticky_notes", "token_domain_2"."notes",
"token_domain_2"."created", "token_domain_2"."updated",
"token_domain_language"."id", "token_domain_language"."language_id",
"token_domain_language"."token_domain_id",
"token_domain_language"."sticky_notes",
"token_domain_language"."created", "token_domain_language"."updated",
"token_domain_3"."id", "token_domain_3"."key",
"token_domain_3"."name", "token_domain_3"."description",
"token_domain_3"."data", "token_domain_3"."sorting",
"token_domain_3"."source_language_id",
"token_domain_3"."sticky_notes", "token_domain_3"."notes",
"token_domain_3"."created", "token_domain_3"."updated",
"language"."id", "language"."name_in_english",
"language"."name_in_local", "language"."lang_in_local",
"language"."locale", "language"."country_id",
"language"."sticky_notes", "language"."flagicon",
"language"."nplurals", "language"."plural", "language"."rtl",
"language"."data", "language"."notes", "language"."created",
"language"."updated", "language"."parent_id", "thread"."id",
"thread"."users_id", "thread"."comment_id", "thread"."title",
"thread"."data", "thread"."category_id", "thread"."created",
"thread"."updated", "thread"."sticky", "user_5"."id",
"user_5"."username", "user_5"."public", "user_5"."admin",
"user_5"."email", "user_5"."gravatar_email", "user_5"."userpage",
"user_5"."data", "user_5"."notes", "user_5"."created",
"user_5"."updated", "user_5"."roles", "comment"."id",
"comment"."users_id", "comment"."context", "comment"."context_id",
"comment"."content", "comment"."deleted", "comment"."created",
"comment"."updated", "comment"."parent_id",
"token_domain_language_2"."id",
"token_domain_language_2"."language_id",
"token_domain_language_2"."token_domain_id",
"token_domain_language_2"."sticky_notes",
"token_domain_language_2"."created",
"token_domain_language_2"."updated", "token_domain_4"."id",
"token_domain_4"."key", "token_domain_4"."name",
"token_domain_4"."description", "token_domain_4"."data",
"token_domain_4"."sorting", "token_domain_4"."source_language_id",
"token_domain_4"."sticky_notes", "token_domain_4"."notes",
"token_domain_4"."created", "token_domain_4"."updated",
"language_2"."id", "language_2"."name_in_english",
"language_2"."name_in_local", "language_2"."lang_in_local",
"language_2"."locale", "language_2"."country_id",
"language_2"."sticky_notes", "language_2"."flagicon",
"language_2"."nplurals", "language_2"."plural", "language_2"."rtl",
"language_2"."data", "language_2"."notes", "language_2"."created",
"language_2"."updated", "language_2"."parent_id",
"token_language_2"."id", "token_language_2"."token_id",
"token_language_2"."token_domain_language_id",
"token_language_2"."notes", "token_language_2"."msgstr0",
"token_language_2"."msgstr1", "token_language_2"."msgstr2",
"token_language_2"."msgstr3", "token_language_2"."msgstr4",
"token_language_2"."msgstr5",
"token_language_2"."translator_users_id", "token_language_2"."data",
"token_language_2"."created", "token_language_2"."updated",
"token_3"."id", "token_3"."msgid", "token_3"."msgid_plural",
"token_3"."msgctxt", "token_3"."type", "token_3"."data",
"token_3"."notes", "token_3"."token_domain_id", "token_3"."created",
"token_3"."updated", "token_domain_5"."id", "token_domain_5"."key",
"token_domain_5"."name", "token_domain_5"."description",
"token_domain_5"."data", "token_domain_5"."sorting",
"token_domain_5"."source_language_id",
"token_domain_5"."sticky_notes", "token_domain_5"."notes",
"token_domain_5"."created", "token_domain_5"."updated",
"token_domain_language_3"."id",
"token_domain_language_3"."language_id",
"token_domain_language_3"."token_domain_id",
"token_domain_language_3"."sticky_notes",
"token_domain_language_3"."created",
"token_domain_language_3"."updated", "token_domain_6"."id",
"token_domain_6"."key", "token_domain_6"."name",
"token_domain_6"."description", "token_domain_6"."data",
"token_domain_6"."sorting", "token_domain_6"."source_language_id",
"token_domain_6"."sticky_notes", "token_domain_6"."notes",
"token_domain_6"."created", "token_domain_6"."updated",
"language_3"."id", "language_3"."name_in_english",
"language_3"."name_in_local", "language_3"."lang_in_local",
"language_3"."locale", "language_3"."country_id",
"language_3"."sticky_notes", "language_3"."flagicon",
"language_3"."nplurals", "language_3"."plural", "language_3"."rtl",
"language_3"."data", "language_3"."notes", "language_3"."created",
"language_3"."updated", "language_3"."parent_id", "children"."id",
"children"."users_id", "children"."context", "children"."context_id",
"children"."content", "children"."deleted", "children"."created",
"children"."updated", "children"."parent_id", "user_6"."id",
"user_6"."username", "user_6"."public", "user_6"."admin",
"user_6"."email", "user_6"."gravatar_email", "user_6"."userpage",
"user_6"."data", "user_6"."notes", "user_6"."created",
"user_6"."updated", "user_6"."roles", "children_2"."id",
"children_2"."users_id", "children_2"."context",
"children_2"."context_id", "children_2"."content",
"children_2"."deleted", "children_2"."created",
"children_2"."updated", "children_2"."parent_id", "user_7"."id",
"user_7"."username", "user_7"."public", "user_7"."admin",
"user_7"."email", "user_7"."gravatar_email", "user_7"."userpage",
"user_7"."data", "user_7"."notes", "user_7"."created",
"user_7"."updated", "user_7"."roles", "children_3"."id",
"children_3"."users_id", "children_3"."context",
"children_3"."context_id", "children_3"."content",
"children_3"."deleted", "children_3"."created",
"children_3"."updated", "children_3"."parent_id", "user_8"."id",
"user_8"."username", "user_8"."public", "user_8"."admin",
"user_8"."email", "user_8"."gravatar_email", "user_8"."userpage",
"user_8"."data", "user_8"."notes", "user_8"."created",
"user_8"."updated", "user_8"."roles", "children_4"."id",
"children_4"."users_id", "children_4"."context",
"children_4"."context_id", "children_4"."content",
"children_4"."deleted", "children_4"."created",
"children_4"."updated", "children_4"."parent_id", "user_9"."id",
"user_9"."username", "user_9"."public", "user_9"."admin",
"user_9"."email", "user_9"."gravatar_email", "user_9"."userpage",
"user_9"."data", "user_9"."notes", "user_9"."created",
"user_9"."updated", "user_9"."roles", "children_5"."id",
"children_5"."users_id", "children_5"."context",
"children_5"."context_id", "children_5"."content",
"children_5"."deleted", "children_5"."created",
"children_5"."updated", "children_5"."parent_id", "user_10"."id",
"user_10"."username", "user_10"."public", "user_10"."admin",
"user_10"."email", "user_10"."gravatar_email", "user_10"."userpage",
"user_10"."data", "user_10"."notes", "user_10"."created",
"user_10"."updated", "user_10"."roles", "children_6"."id",
"children_6"."users_id", "children_6"."context",
"children_6"."context_id", "children_6"."content",
"children_6"."deleted", "children_6"."created",
"children_6"."updated", "children_6"."parent_id", "user_11"."id",
"user_11"."username", "user_11"."public", "user_11"."admin",
"user_11"."email", "user_11"."gravatar_email", "user_11"."userpage",
"user_11"."data", "user_11"."notes", "user_11"."created",
"user_11"."updated", "user_11"."roles", "children_7"."id",
"children_7"."users_id", "children_7"."context",
"children_7"."context_id", "children_7"."content",
"children_7"."deleted", "children_7"."created",
"children_7"."updated", "children_7"."parent_id", "user_12"."id",
"user_12"."username", "user_12"."public", "user_12"."admin",
"user_12"."email", "user_12"."gravatar_email", "user_12"."userpage",
"user_12"."data", "user_12"."notes", "user_12"."created",
"user_12"."updated", "user_12"."roles", "children_8"."id",
"children_8"."users_id", "children_8"."context",
"children_8"."context_id", "children_8"."content",
"children_8"."deleted", "children_8"."created",
"children_8"."updated", "children_8"."parent_id", "user_13"."id",
"user_13"."username", "user_13"."public", "user_13"."admin",
"user_13"."email", "user_13"."gravatar_email", "user_13"."userpage",
"user_13"."data", "user_13"."notes", "user_13"."created",
"user_13"."updated", "user_13"."roles", "children_9"."id",
"children_9"."users_id", "children_9"."context",
"children_9"."context_id", "children_9"."content",
"children_9"."deleted", "children_9"."created",
"children_9"."updated", "children_9"."parent_id", "user_14"."id",
"user_14"."username", "user_14"."public", "user_14"."admin",
"user_14"."email", "user_14"."gravatar_email", "user_14"."userpage",
"user_14"."data", "user_14"."notes", "user_14"."created",
"user_14"."updated", "user_14"."roles", "children_10"."id",
"children_10"."users_id", "children_10"."context",
"children_10"."context_id", "children_10"."content",
"children_10"."deleted", "children_10"."created",
"children_10"."updated", "children_10"."parent_id",
"children_11"."id", "children_11"."users_id", "children_11"."context",
"children_11"."context_id", "children_11"."content",
"children_11"."deleted", "children_11"."created",
"children_11"."updated", "children_11"."parent_id", "user_15"."id",
"user_15"."username", "user_15"."public", "user_15"."admin",
"user_15"."email", "user_15"."gravatar_email", "user_15"."userpage",
"user_15"."data", "user_15"."notes", "user_15"."created",
"user_15"."updated", "user_15"."roles"   FROM (     SELECT "me"."id",
"me"."users_id", "me"."context", "me"."context_id", "me"."content",
"me"."deleted", "me"."created", "me"."updated", "me"."parent_id"
  FROM (
    SELECT "me"."id", "me"."users_id", "me"."context", "me"."context_id", "me"."content", "me"."deleted", "me"."created", "me"."updated", "me"."parent_id"
      FROM "comment" "me"
      JOIN "users" "user"
        ON "user"."id" = "me"."users_id"
    WHERE "me"."context" IN ( 'DDGC::DB::Result::Token::Language', 'DDGC::DB::Result::Token::Domain::Language' ) AND "me"."id" IN (
        SELECT "comment_context"."latest_comment_id"
          FROM (
            SELECT ( latest ) .id AS latest_comment_id, (
                  FIRST
               ) .id AS first_comment_id, (
                  FIRST
               ) .context AS comments_context, (
                  FIRST
               ) .context_id AS comments_context_id
              FROM (
                SELECT (
                    SELECT latest
                      FROM comment latest
                    WHERE latest.context = c.context AND latest.context_id = c.context_id
                    ORDER BY created DESC
                      LIMIT 1
                   ) AS latest, (
                    SELECT
                      FIRST
                      FROM comment
                      FIRST
                    WHERE first.context = c.context AND first.context_id = c.context_id
                    ORDER BY created ASC
                      LIMIT 1
                   )
                  FIRST
                  FROM comment c
                GROUP BY context, context_id
               ) latest_comment
           ) "comment_context"
       )
    ORDER BY "me"."created" DESC
      LIMIT '15'
   ) "me"
  JOIN "users" "user"
    ON "user"."id" = "me"."users_id"
  LEFT JOIN "token" "token"
    ON "me"."context" = 'DDGC::DB::Result::Token' AND "token"."id" = "me"."context_id"
  LEFT JOIN "token_domain" "token_domain"
    ON "token_domain"."id" = "token"."token_domain_id"
  LEFT JOIN "user_blog" "user_blog"
    ON "me"."context" = 'DDGC::DB::Result::User::Blog' AND "user_blog"."id" = "me"."context_id"
  LEFT JOIN "users" "user_2"
    ON "user_2"."id" = "user_blog"."users_id"
  LEFT JOIN "token_language_translation_vote" "token_language_translation_vote"
    ON "me"."context" = 'DDGC::DB::Result::Token::Language::Translation::Vote' AND "token_language_translation_vote"."id" = "me"."context_id"
  LEFT JOIN "users" "user_3"
    ON "user_3"."id" = "token_language_translation_vote"."users_id"
  LEFT JOIN "token_language_translation" "token_language_translation"
    ON "token_language_translation"."id" = "token_language_translation_vote"."token_language_translation_id"
  LEFT JOIN "users" "user_4"
    ON "user_4"."username" = "token_language_translation"."username"
  LEFT JOIN "token_language" "token_language"
    ON "token_language"."id" = "token_language_translation"."token_language_id"
  LEFT JOIN "token" "token_2"
    ON "token_2"."id" = "token_language"."token_id"
  LEFT JOIN "token_domain" "token_domain_2"
    ON "token_domain_2"."id" = "token_2"."token_domain_id"
  LEFT JOIN "token_domain_language" "token_domain_language"
    ON "token_domain_language"."id" = "token_language"."token_domain_language_id"
  LEFT JOIN "token_domain" "token_domain_3"
    ON "token_domain_3"."id" = "token_domain_language"."token_domain_id"
  LEFT JOIN "language" "language"
    ON "language"."id" = "token_domain_language"."language_id"
  LEFT JOIN "thread" "thread"
    ON "me"."context" = 'DDGC::DB::Result::Thread' AND "thread"."id" = "me"."context_id"
  LEFT JOIN "users" "user_5"
    ON "user_5"."id" = "thread"."users_id"
  LEFT JOIN "comment" "comment"
    ON "comment"."id" = "thread"."comment_id"
  LEFT JOIN "token_domain_language" "token_domain_language_2"
    ON "me"."context" = 'DDGC::DB::Result::Token::Domain::Language' AND "token_domain_language_2"."id" = "me"."context_id"
  LEFT JOIN "token_domain" "token_domain_4"
    ON "token_domain_4"."id" = "token_domain_language_2"."token_domain_id"
  LEFT JOIN "language" "language_2"
    ON "language_2"."id" = "token_domain_language_2"."language_id"
  LEFT JOIN "token_language" "token_language_2"
    ON "me"."context" = 'DDGC::DB::Result::Token::Language' AND "token_language_2"."id" = "me"."context_id"
  LEFT JOIN "token" "token_3"
    ON "token_3"."id" = "token_language_2"."token_id"
  LEFT JOIN "token_domain" "token_domain_5"
    ON "token_domain_5"."id" = "token_3"."token_domain_id"
  LEFT JOIN "token_domain_language" "token_domain_language_3"
    ON "token_domain_language_3"."id" = "token_language_2"."token_domain_language_id"
  LEFT JOIN "token_domain" "token_domain_6"
    ON "token_domain_6"."id" = "token_domain_language_3"."token_domain_id"
  LEFT JOIN "language" "language_3"
    ON "language_3"."id" = "token_domain_language_3"."language_id"
  LEFT JOIN "comment" "children"
    ON "children"."parent_id" = "me"."id"
  LEFT JOIN "users" "user_6"
    ON "user_6"."id" = "children"."users_id"
  LEFT JOIN "comment" "children_2"
    ON "children_2"."parent_id" = "children"."id"
  LEFT JOIN "users" "user_7"
    ON "user_7"."id" = "children_2"."users_id"
  LEFT JOIN "comment" "children_3"
    ON "children_3"."parent_id" = "children_2"."id"
  LEFT JOIN "users" "user_8"
    ON "user_8"."id" = "children_3"."users_id"
  LEFT JOIN "comment" "children_4"
    ON "children_4"."parent_id" = "children_3"."id"
  LEFT JOIN "users" "user_9"
    ON "user_9"."id" = "children_4"."users_id"
  LEFT JOIN "comment" "children_5"
    ON "children_5"."parent_id" = "children_4"."id"
  LEFT JOIN "users" "user_10"
    ON "user_10"."id" = "children_5"."users_id"
  LEFT JOIN "comment" "children_6"
    ON "children_6"."parent_id" = "children_5"."id"
  LEFT JOIN "users" "user_11"
    ON "user_11"."id" = "children_6"."users_id"
  LEFT JOIN "comment" "children_7"
    ON "children_7"."parent_id" = "children_6"."id"
  LEFT JOIN "users" "user_12"
    ON "user_12"."id" = "children_7"."users_id"
  LEFT JOIN "comment" "children_8"
    ON "children_8"."parent_id" = "children_7"."id"
  LEFT JOIN "users" "user_13"
    ON "user_13"."id" = "children_8"."users_id"
  LEFT JOIN "comment" "children_9"
    ON "children_9"."parent_id" = "children_8"."id"
  LEFT JOIN "users" "user_14"
    ON "user_14"."id" = "children_9"."users_id"
  LEFT JOIN "comment" "children_10"
    ON "children_10"."parent_id" = "children_9"."id"
  LEFT JOIN "comment" "children_11"
    ON "children_11"."parent_id" = "children_10"."id"
  LEFT JOIN "users" "user_15"
    ON "user_15"."id" = "children_11"."users_id"
WHERE "me"."context" IN ( 'DDGC::DB::Result::Token::Language', 'DDGC::DB::Result::Token::Domain::Language' ) AND "me"."id" IN (
    SELECT "comment_context"."latest_comment_id"
      FROM (
        SELECT ( latest ) .id AS latest_comment_id, (
              FIRST
           ) .id AS first_comment_id, (
              FIRST
           ) .context AS comments_context, (
              FIRST
           ) .context_id AS comments_context_id
          FROM (
            SELECT (
                SELECT latest
                  FROM comment latest
                WHERE latest.context = c.context AND latest.context_id = c.context_id
                ORDER BY created DESC
                  LIMIT 1
               ) AS latest, (
                SELECT
                  FIRST
                  FROM comment
                  FIRST
                WHERE first.context = c.context AND first.context_id = c.context_id
                ORDER BY created ASC
                  LIMIT 1
               )
              FIRST
              FROM comment c
            GROUP BY context, context_id
           ) latest_comment
       ) "comment_context"
   )
ORDER BY "me"."created" DESC