Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.isbn AS isbn_2,
          b0_.cover AS cover_3,
          b0_.edited_at AS edited_at_4,
          b0_.plot AS plot_5,
          b0_.status AS status_6,
          b0_.page_number AS page_number_7
        FROM
          book b0_
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      b0_.id AS id_0,
      b0_.title AS title_1,
      b0_.isbn AS isbn_2,
      b0_.cover AS cover_3,
      b0_.edited_at AS edited_at_4,
      b0_.plot AS plot_5,
      b0_.status AS status_6,
      b0_.page_number AS page_number_7
    FROM
      book b0_
  ) dctrn_result
LIMIT
  10
OFFSET
  20

SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result LIMIT 10 OFFSET 20;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.isbn AS isbn_2,
  b0_.cover AS cover_3,
  b0_.edited_at AS edited_at_4,
  b0_.plot AS plot_5,
  b0_.status AS status_6,
  b0_.page_number AS page_number_7,
  b0_.editor_id AS editor_id_8,
  b0_.created_by_id AS created_by_id_9
FROM
  book b0_
WHERE
  b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7, b0_.editor_id AS editor_id_8, b0_.created_by_id AS created_by_id_9 FROM book b0_ WHERE b0_.id IN (132, 116, 120, 106, 118, 122, 127, 108, 110, 119);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 106;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 106;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 108;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 108;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 110;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 110;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 116;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 116;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 118;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 118;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 119;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 119;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 120;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 120;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 122;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.book_id AS book_id_8
FROM
  comment t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 122;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.date_of_death AS date_of_death_4,
  t0.nationality AS nationality_5
FROM
  author t0
  INNER JOIN book_author ON t0.id = book_author.author_id
WHERE
  book_author.book_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 127;