Symfony Profiler

SELECT
  c0_.source AS source_0,
  c0_.text AS text_1,
  c0_.position AS position_2,
  c0_.description AS description_3,
  c0_.compilationPage AS compilationPage_4,
  c0_.compilationIndex AS compilationIndex_5,
  c0_.status AS status_6,
  c0_.creator AS creator_7,
  c0_.created AS created_8,
  c0_.sortPage AS sortPage_9,
  c0_.sortSide AS sortSide_10,
  c0_.sortFragment AS sortFragment_11,
  c0_.sortColumn AS sortColumn_12,
  c0_.sortLine AS sortLine_13,
  c0_.sortSystem AS sortSystem_14,
  c0_.sortUser AS sortUser_15,
  c0_.sort AS sort_16,
  c0_.id AS id_17,
  r1_.hgv AS hgv_18,
  r1_.tm AS tm_19,
  r1_.ddb AS ddb_20,
  r1_.dclp AS dclp_21,
  r1_.id AS id_22,
  t2_.category AS category_23,
  t2_.description AS description_24,
  t2_.cleared AS cleared_25,
  t2_.id AS id_26,
  e3_.sort AS sort_27,
  e3_.title AS title_28,
  e3_.collection AS collection_29,
  e3_.volume AS volume_30,
  e3_.remark AS remark_31,
  e3_.material AS material_32,
  e3_.id AS id_33,
  c0_.edition_id AS edition_id_34,
  c0_.compilation_id AS compilation_id_35,
  t2_.correction_id AS correction_id_36
FROM
  correction c0_
  INNER JOIN correction_register c4_ ON c0_.id = c4_.correction_id
  INNER JOIN register r1_ ON r1_.id = c4_.register_id
  LEFT JOIN task t2_ ON c0_.id = t2_.correction_id
  INNER JOIN edition e3_ ON c0_.edition_id = e3_.id
  INNER JOIN compilation c5_ ON c0_.compilation_id = c5_.id
WHERE
  c5_.collection = ?
  AND r1_.dclp IS NOT NULL
ORDER BY
  c0_.sort ASC
LIMIT
  2000

SELECT c0_.source AS source_0, c0_.text AS text_1, c0_.position AS position_2, c0_.description AS description_3, c0_.compilationPage AS compilationPage_4, c0_.compilationIndex AS compilationIndex_5, c0_.status AS status_6, c0_.creator AS creator_7, c0_.created AS created_8, c0_.sortPage AS sortPage_9, c0_.sortSide AS sortSide_10, c0_.sortFragment AS sortFragment_11, c0_.sortColumn AS sortColumn_12, c0_.sortLine AS sortLine_13, c0_.sortSystem AS sortSystem_14, c0_.sortUser AS sortUser_15, c0_.sort AS sort_16, c0_.id AS id_17, r1_.hgv AS hgv_18, r1_.tm AS tm_19, r1_.ddb AS ddb_20, r1_.dclp AS dclp_21, r1_.id AS id_22, t2_.category AS category_23, t2_.description AS description_24, t2_.cleared AS cleared_25, t2_.id AS id_26, e3_.sort AS sort_27, e3_.title AS title_28, e3_.collection AS collection_29, e3_.volume AS volume_30, e3_.remark AS remark_31, e3_.material AS material_32, e3_.id AS id_33, c0_.edition_id AS edition_id_34, c0_.compilation_id AS compilation_id_35, t2_.correction_id AS correction_id_36 FROM correction c0_ INNER JOIN correction_register c4_ ON c0_.id = c4_.correction_id INNER JOIN register r1_ ON r1_.id = c4_.register_id LEFT JOIN task t2_ ON c0_.id = t2_.correction_id INNER JOIN edition e3_ ON c0_.edition_id = e3_.id INNER JOIN compilation c5_ ON c0_.compilation_id = c5_.id WHERE c5_.collection = 'BOEP' AND r1_.dclp IS NOT NULL ORDER BY c0_.sort ASC LIMIT 2000;

SELECT
  t0.volume AS volume_1,
  t0.fascicle AS fascicle_2,
  t0.title AS title_3,
  t0.collection AS collection_4,
  t0.item AS item_5,
  t0.short AS short_6,
  t0.start AS start_7,
  t0.end AS end_8,
  t0.publication AS publication_9,
  t0.id AS id_10
FROM
  compilation t0
WHERE
  t0.collection = ?
ORDER BY
  t0.collection ASC,
  t0.volume ASC

SELECT t0.volume AS volume_1, t0.fascicle AS fascicle_2, t0.title AS title_3, t0.collection AS collection_4, t0.item AS item_5, t0.short AS short_6, t0.start AS start_7, t0.end AS end_8, t0.publication AS publication_9, t0.id AS id_10 FROM compilation t0 WHERE t0.collection = 'BOEP' ORDER BY t0.collection ASC, t0.volume ASC;