Symfony Profiler

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.id AS id_1
FROM
  news n0_
  INNER JOIN user u1_ ON n0_.author_id = u1_.id
  LEFT JOIN news_attachment n2_ ON n0_.id = n2_.news_id
ORDER BY
  n0_.id ASC
LIMIT
  30

SELECT DISTINCT n0_.id AS id_0, n0_.id AS id_1 FROM news n0_ INNER JOIN user u1_ ON n0_.author_id = u1_.id LEFT JOIN news_attachment n2_ ON n0_.id = n2_.news_id ORDER BY n0_.id ASC LIMIT 30;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.status AS status_2,
  n0_.object AS object_3,
  n0_.news AS news_4,
  n0_.slug AS slug_5,
  n0_.created_at AS created_at_6,
  n0_.updated_at AS updated_at_7,
  n0_.attachment_path AS attachment_path_8,
  u1_.id AS id_9,
  u1_.email AS email_10,
  u1_.roles AS roles_11,
  u1_.password AS password_12,
  u1_.first_name AS first_name_13,
  u1_.last_name AS last_name_14,
  u1_.agree_terms AS agree_terms_15,
  u1_.created_at AS created_at_16,
  u1_.updated_at AS updated_at_17,
  u1_.is_verified AS is_verified_18,
  n2_.id AS id_19,
  n2_.original_name AS original_name_20,
  n2_.stored_name AS stored_name_21,
  n2_.path AS path_22,
  n2_.mime_type AS mime_type_23,
  n2_.size AS size_24,
  n2_.created_at AS created_at_25,
  n0_.author_id AS author_id_26,
  n2_.news_id AS news_id_27
FROM
  news n0_
  INNER JOIN user u1_ ON n0_.author_id = u1_.id
  LEFT JOIN news_attachment n2_ ON n0_.id = n2_.news_id
WHERE
  n0_.id IN (?)
ORDER BY
  n0_.id ASC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.status AS status_2, n0_.object AS object_3, n0_.news AS news_4, n0_.slug AS slug_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.attachment_path AS attachment_path_8, u1_.id AS id_9, u1_.email AS email_10, u1_.roles AS roles_11, u1_.password AS password_12, u1_.first_name AS first_name_13, u1_.last_name AS last_name_14, u1_.agree_terms AS agree_terms_15, u1_.created_at AS created_at_16, u1_.updated_at AS updated_at_17, u1_.is_verified AS is_verified_18, n2_.id AS id_19, n2_.original_name AS original_name_20, n2_.stored_name AS stored_name_21, n2_.path AS path_22, n2_.mime_type AS mime_type_23, n2_.size AS size_24, n2_.created_at AS created_at_25, n0_.author_id AS author_id_26, n2_.news_id AS news_id_27 FROM news n0_ INNER JOIN user u1_ ON n0_.author_id = u1_.id LEFT JOIN news_attachment n2_ ON n0_.id = n2_.news_id WHERE n0_.id IN (6, 7) ORDER BY n0_.id ASC;

SELECT
  count(DISTINCT n0_.id) AS sclr_0
FROM
  news n0_
  INNER JOIN user u1_ ON n0_.author_id = u1_.id
  LEFT JOIN news_attachment n2_ ON n0_.id = n2_.news_id

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news n0_ INNER JOIN user u1_ ON n0_.author_id = u1_.id LEFT JOIN news_attachment n2_ ON n0_.id = n2_.news_id;