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_.slug AS slug_2,
          b0_.description AS description_3,
          b0_.year AS year_4,
          b0_.binding AS binding_5,
          b0_.orientation AS orientation_6,
          b0_.dimensions AS dimensions_7,
          b0_.weight AS weight_8,
          b0_.pages AS pages_9,
          b0_.edition AS edition_10,
          b0_.languages AS languages_11,
          b0_.isbn_ean AS isbn_ean_12,
          b0_.price AS price_13,
          b0_.countries AS countries_14,
          b0_.created_at AS created_at_15,
          b0_.updated_at AS updated_at_16,
          a1_.id AS id_17,
          a1_.name AS name_18,
          a1_.created_at AS created_at_19,
          a1_.updated_at AS updated_at_20,
          p2_.id AS id_21,
          p2_.name AS name_22,
          p2_.created_at AS created_at_23,
          p2_.updated_at AS updated_at_24
        FROM
          books b0_
          LEFT JOIN book_author b3_ ON b0_.id = b3_.book_id
          LEFT JOIN authors a1_ ON a1_.id = b3_.author_id
          LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id
          LEFT JOIN publishers p2_ ON p2_.id = b4_.publisher_id
        ORDER BY
          a1_.name ASC
      ) 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_.slug AS slug_2, b0_.description AS description_3, b0_.year AS year_4, b0_.binding AS binding_5, b0_.orientation AS orientation_6, b0_.dimensions AS dimensions_7, b0_.weight AS weight_8, b0_.pages AS pages_9, b0_.edition AS edition_10, b0_.languages AS languages_11, b0_.isbn_ean AS isbn_ean_12, b0_.price AS price_13, b0_.countries AS countries_14, b0_.created_at AS created_at_15, b0_.updated_at AS updated_at_16, a1_.id AS id_17, a1_.name AS name_18, a1_.created_at AS created_at_19, a1_.updated_at AS updated_at_20, p2_.id AS id_21, p2_.name AS name_22, p2_.created_at AS created_at_23, p2_.updated_at AS updated_at_24 FROM books b0_ LEFT JOIN book_author b3_ ON b0_.id = b3_.book_id LEFT JOIN authors a1_ ON a1_.id = b3_.author_id LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id LEFT JOIN publishers p2_ ON p2_.id = b4_.publisher_id ORDER BY a1_.name ASC) dctrn_result) dctrn_table;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.year AS year_4,
  b0_.binding AS binding_5,
  b0_.orientation AS orientation_6,
  b0_.dimensions AS dimensions_7,
  b0_.weight AS weight_8,
  b0_.pages AS pages_9,
  b0_.edition AS edition_10,
  b0_.languages AS languages_11,
  b0_.isbn_ean AS isbn_ean_12,
  b0_.price AS price_13,
  b0_.countries AS countries_14,
  b0_.created_at AS created_at_15,
  b0_.updated_at AS updated_at_16,
  a1_.id AS id_17,
  a1_.name AS name_18,
  a1_.created_at AS created_at_19,
  a1_.updated_at AS updated_at_20,
  p2_.id AS id_21,
  p2_.name AS name_22,
  p2_.created_at AS created_at_23,
  p2_.updated_at AS updated_at_24,
  b0_.created_by AS created_by_25,
  b0_.updated_by AS updated_by_26,
  a1_.created_by AS created_by_27,
  a1_.updated_by AS updated_by_28,
  p2_.created_by AS created_by_29,
  p2_.updated_by AS updated_by_30
FROM
  books b0_
  LEFT JOIN book_author b3_ ON b0_.id = b3_.book_id
  LEFT JOIN authors a1_ ON a1_.id = b3_.author_id
  LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id
  LEFT JOIN publishers p2_ ON p2_.id = b4_.publisher_id
WHERE
  b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a1_.name ASC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.year AS year_4, b0_.binding AS binding_5, b0_.orientation AS orientation_6, b0_.dimensions AS dimensions_7, b0_.weight AS weight_8, b0_.pages AS pages_9, b0_.edition AS edition_10, b0_.languages AS languages_11, b0_.isbn_ean AS isbn_ean_12, b0_.price AS price_13, b0_.countries AS countries_14, b0_.created_at AS created_at_15, b0_.updated_at AS updated_at_16, a1_.id AS id_17, a1_.name AS name_18, a1_.created_at AS created_at_19, a1_.updated_at AS updated_at_20, p2_.id AS id_21, p2_.name AS name_22, p2_.created_at AS created_at_23, p2_.updated_at AS updated_at_24, b0_.created_by AS created_by_25, b0_.updated_by AS updated_by_26, a1_.created_by AS created_by_27, a1_.updated_by AS updated_by_28, p2_.created_by AS created_by_29, p2_.updated_by AS updated_by_30 FROM books b0_ LEFT JOIN book_author b3_ ON b0_.id = b3_.book_id LEFT JOIN authors a1_ ON a1_.id = b3_.author_id LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id LEFT JOIN publishers p2_ ON p2_.id = b4_.publisher_id WHERE b0_.id IN (205, 206, 104, 146, 13, 237, 258, 67, 70, 244, 10, 249, 108, 242, 140, 208, 2, 22, 105, 49, 231, 245, 96, 8, 175) ORDER BY a1_.name ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_18
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.slug AS slug_2,
          b0_.description AS description_3,
          b0_.year AS year_4,
          b0_.binding AS binding_5,
          b0_.orientation AS orientation_6,
          b0_.dimensions AS dimensions_7,
          b0_.weight AS weight_8,
          b0_.pages AS pages_9,
          b0_.edition AS edition_10,
          b0_.languages AS languages_11,
          b0_.isbn_ean AS isbn_ean_12,
          b0_.price AS price_13,
          b0_.countries AS countries_14,
          b0_.created_at AS created_at_15,
          b0_.updated_at AS updated_at_16,
          a1_.id AS id_17,
          a1_.name AS name_18,
          a1_.created_at AS created_at_19,
          a1_.updated_at AS updated_at_20,
          p2_.id AS id_21,
          p2_.name AS name_22,
          p2_.created_at AS created_at_23,
          p2_.updated_at AS updated_at_24
        FROM
          books b0_
          LEFT JOIN book_author b3_ ON b0_.id = b3_.book_id
          LEFT JOIN authors a1_ ON a1_.id = b3_.author_id
          LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id
          LEFT JOIN publishers p2_ ON p2_.id = b4_.publisher_id
      ) dctrn_result_inner
    ORDER BY
      name_18 ASC
  ) dctrn_result
LIMIT
  25 OFFSET 100

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_18 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.year AS year_4, b0_.binding AS binding_5, b0_.orientation AS orientation_6, b0_.dimensions AS dimensions_7, b0_.weight AS weight_8, b0_.pages AS pages_9, b0_.edition AS edition_10, b0_.languages AS languages_11, b0_.isbn_ean AS isbn_ean_12, b0_.price AS price_13, b0_.countries AS countries_14, b0_.created_at AS created_at_15, b0_.updated_at AS updated_at_16, a1_.id AS id_17, a1_.name AS name_18, a1_.created_at AS created_at_19, a1_.updated_at AS updated_at_20, p2_.id AS id_21, p2_.name AS name_22, p2_.created_at AS created_at_23, p2_.updated_at AS updated_at_24 FROM books b0_ LEFT JOIN book_author b3_ ON b0_.id = b3_.book_id LEFT JOIN authors a1_ ON a1_.id = b3_.author_id LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id LEFT JOIN publishers p2_ ON p2_.id = b4_.publisher_id) dctrn_result_inner ORDER BY name_18 ASC) dctrn_result LIMIT 25 OFFSET 100;