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,
  d4_.text AS text_34,
  d4_.position AS position_35,
  d4_.info AS info_36,
  d4_.type AS type_37,
  d4_.sort AS sort_38,
  d4_.compilationPage AS compilationPage_39,
  d4_.id AS id_40,
  c0_.edition_id AS edition_id_41,
  c0_.compilation_id AS compilation_id_42,
  t2_.correction_id AS correction_id_43,
  d4_.compilation_id AS compilation_id_44
FROM
  correction c0_
  LEFT JOIN correction_register c5_ ON c0_.id = c5_.correction_id
  LEFT JOIN register r1_ ON r1_.id = c5_.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 c6_ ON c0_.compilation_id = c6_.id
  LEFT JOIN edition_docket e7_ ON e3_.id = e7_.edition_id
  LEFT JOIN docket d4_ ON d4_.id = e7_.docket_id
WHERE
  r1_.hgv = ?
ORDER BY
  c0_.sort ASC

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, d4_.text AS text_34, d4_.position AS position_35, d4_.info AS info_36, d4_.type AS type_37, d4_.sort AS sort_38, d4_.compilationPage AS compilationPage_39, d4_.id AS id_40, c0_.edition_id AS edition_id_41, c0_.compilation_id AS compilation_id_42, t2_.correction_id AS correction_id_43, d4_.compilation_id AS compilation_id_44 FROM correction c0_ LEFT JOIN correction_register c5_ ON c0_.id = c5_.correction_id LEFT JOIN register r1_ ON r1_.id = c5_.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 c6_ ON c0_.compilation_id = c6_.id LEFT JOIN edition_docket e7_ ON e3_.id = e7_.edition_id LEFT JOIN docket d4_ ON d4_.id = e7_.docket_id WHERE r1_.hgv = '74915' ORDER BY c0_.sort 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
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 ORDER BY t0.collection ASC, t0.volume ASC;