Symfony Profiler

SELECT
  count(DISTINCT r0_.id) AS sclr_0
FROM
  reference r0_
  LEFT JOIN reference_type r1_ ON r0_.reference_type_id = r1_.id
WHERE
  (r0_.deletedAt IS NULL)

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM reference r0_ LEFT JOIN reference_type r1_ ON r0_.reference_type_id = r1_.id WHERE (r0_.deletedAt IS NULL);

SELECT
  r0_.id AS id_0,
  r0_.authors AS authors_1,
  r0_.editors AS editors_2,
  r0_.title AS title_3,
  r0_.title_edition AS title_edition_4,
  r0_.volume AS volume_5,
  r0_.place AS place_6,
  r0_.year AS year_7,
  r0_.pages AS pages_8,
  r0_.abbreviation AS abbreviation_9,
  r0_.uri1 AS uri1_10,
  r0_.uri1_accession_date AS uri1_accession_date_11,
  r0_.uri2 AS uri2_12,
  r0_.uri2_accession_date AS uri2_accession_date_13,
  r0_.fully_entered AS fully_entered_14,
  r0_.deleted AS deleted_15,
  r0_.deletedAt AS deletedAt_16,
  r0_.internal_note AS internal_note_17,
  r0_.sort_value AS sort_value_18,
  r0_.has_own_column AS has_own_column_19,
  r0_.filePath AS filePath_20,
  r0_.is_file_public AS is_file_public_21,
  r0_.redirect_to_reference AS redirect_to_reference_22,
  r0_.creation_date AS creation_date_23,
  r0_.modified_date AS modified_date_24,
  r0_.comment AS comment_25,
  r1_.id AS id_26,
  r1_.reference_type AS reference_type_27,
  r1_.deleted AS deleted_28,
  r1_.sort_value AS sort_value_29,
  r1_.creation_date AS creation_date_30,
  r1_.modified_date AS modified_date_31,
  r1_.comment AS comment_32,
  r0_.reference_type_id AS reference_type_id_33,
  r0_.created_by AS created_by_34,
  r0_.modified_by AS modified_by_35,
  r1_.created_by AS created_by_36,
  r1_.modified_by AS modified_by_37
FROM
  reference r0_
  LEFT JOIN reference_type r1_ ON r0_.reference_type_id = r1_.id
WHERE
  (
    r0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )
  AND (r0_.deletedAt IS NULL)

SELECT r0_.id AS id_0, r0_.authors AS authors_1, r0_.editors AS editors_2, r0_.title AS title_3, r0_.title_edition AS title_edition_4, r0_.volume AS volume_5, r0_.place AS place_6, r0_.year AS year_7, r0_.pages AS pages_8, r0_.abbreviation AS abbreviation_9, r0_.uri1 AS uri1_10, r0_.uri1_accession_date AS uri1_accession_date_11, r0_.uri2 AS uri2_12, r0_.uri2_accession_date AS uri2_accession_date_13, r0_.fully_entered AS fully_entered_14, r0_.deleted AS deleted_15, r0_.deletedAt AS deletedAt_16, r0_.internal_note AS internal_note_17, r0_.sort_value AS sort_value_18, r0_.has_own_column AS has_own_column_19, r0_.filePath AS filePath_20, r0_.is_file_public AS is_file_public_21, r0_.redirect_to_reference AS redirect_to_reference_22, r0_.creation_date AS creation_date_23, r0_.modified_date AS modified_date_24, r0_.comment AS comment_25, r1_.id AS id_26, r1_.reference_type AS reference_type_27, r1_.deleted AS deleted_28, r1_.sort_value AS sort_value_29, r1_.creation_date AS creation_date_30, r1_.modified_date AS modified_date_31, r1_.comment AS comment_32, r0_.reference_type_id AS reference_type_id_33, r0_.created_by AS created_by_34, r0_.modified_by AS modified_by_35, r1_.created_by AS created_by_36, r1_.modified_by AS modified_by_37 FROM reference r0_ LEFT JOIN reference_type r1_ ON r0_.reference_type_id = r1_.id WHERE (r0_.id IN (42, 43, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 56, 58, 59, 60, 62, 63, 65, 67)) AND (r0_.deletedAt IS NULL);

SELECT
  r0_.id AS id_0,
  r0_.reference_type AS reference_type_1,
  r0_.deleted AS deleted_2,
  r0_.sort_value AS sort_value_3,
  r0_.creation_date AS creation_date_4,
  r0_.modified_date AS modified_date_5,
  r0_.comment AS comment_6,
  r0_.created_by AS created_by_7,
  r0_.modified_by AS modified_by_8
FROM
  reference_type r0_
ORDER BY
  r0_.reference_type ASC

SELECT r0_.id AS id_0, r0_.reference_type AS reference_type_1, r0_.deleted AS deleted_2, r0_.sort_value AS sort_value_3, r0_.creation_date AS creation_date_4, r0_.modified_date AS modified_date_5, r0_.comment AS comment_6, r0_.created_by AS created_by_7, r0_.modified_by AS modified_by_8 FROM reference_type r0_ ORDER BY r0_.reference_type ASC;

SELECT
  DISTINCT r0_.id AS id_0
FROM
  reference r0_
  LEFT JOIN reference_type r1_ ON r0_.reference_type_id = r1_.id
WHERE
  (r0_.deletedAt IS NULL)
LIMIT
  20 OFFSET 40

SELECT DISTINCT r0_.id AS id_0 FROM reference r0_ LEFT JOIN reference_type r1_ ON r0_.reference_type_id = r1_.id WHERE (r0_.deletedAt IS NULL) LIMIT 20 OFFSET 40;