Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.comp_titre AS comp_titre_3,
  t0.annee AS annee_4,
  t0.ville AS ville_5,
  t0.format AS format_6,
  t0.nb_pages AS nb_pages_7,
  t0.pagination_double AS pagination_double_8,
  t0.isbn AS isbn_9,
  t0.e_isbn AS e_isbn_10,
  t0.issn AS issn_11,
  t0.e_issn AS e_issn_12,
  t0.doi AS doi_13,
  t0.edition AS edition_14,
  t0.numero_collection AS numero_collection_15,
  t0.tome AS tome_16,
  t0.nb_volumes AS nb_volumes_17,
  t0.volume AS volume_18,
  t0.numero AS numero_19,
  t0.fascicule AS fascicule_20,
  t0.cahier AS cahier_21,
  t0.tirage AS tirage_22,
  t0.notes AS notes_23,
  t0.date_creation AS date_creation_24,
  t0.date_update AS date_update_25,
  t0.validation AS validation_26,
  t0.type_id AS type_id_27,
  t0.support_id AS support_id_28,
  t0.editeur_id AS editeur_id_29,
  t0.collection_id AS collection_id_30,
  t0.doc_original_id AS doc_original_id_31,
  t0.infos_element_id AS infos_element_id_32,
  t0.infos_these_id AS infos_these_id_33
FROM
  document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.comp_titre AS comp_titre_3, t0.annee AS annee_4, t0.ville AS ville_5, t0.format AS format_6, t0.nb_pages AS nb_pages_7, t0.pagination_double AS pagination_double_8, t0.isbn AS isbn_9, t0.e_isbn AS e_isbn_10, t0.issn AS issn_11, t0.e_issn AS e_issn_12, t0.doi AS doi_13, t0.edition AS edition_14, t0.numero_collection AS numero_collection_15, t0.tome AS tome_16, t0.nb_volumes AS nb_volumes_17, t0.volume AS volume_18, t0.numero AS numero_19, t0.fascicule AS fascicule_20, t0.cahier AS cahier_21, t0.tirage AS tirage_22, t0.notes AS notes_23, t0.date_creation AS date_creation_24, t0.date_update AS date_update_25, t0.validation AS validation_26, t0.type_id AS type_id_27, t0.support_id AS support_id_28, t0.editeur_id AS editeur_id_29, t0.collection_id AS collection_id_30, t0.doc_original_id AS doc_original_id_31, t0.infos_element_id AS infos_element_id_32, t0.infos_these_id AS infos_these_id_33 FROM document t0 WHERE t0.id = 2438;

SELECT
  t0.id AS id_1,
  t0.page_debut AS page_debut_2,
  t0.page_fin AS page_fin_3,
  t0.num_chapitre AS num_chapitre_4,
  t0.titre_hote AS titre_hote_5,
  t0.doc_hote_id AS doc_hote_id_6
FROM
  infos_element t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.page_debut AS page_debut_2, t0.page_fin AS page_fin_3, t0.num_chapitre AS num_chapitre_4, t0.titre_hote AS titre_hote_5, t0.doc_hote_id AS doc_hote_id_6 FROM infos_element t0 WHERE t0.id = 1675;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.comp_titre AS comp_titre_3,
  t0.annee AS annee_4,
  t0.ville AS ville_5,
  t0.format AS format_6,
  t0.nb_pages AS nb_pages_7,
  t0.pagination_double AS pagination_double_8,
  t0.isbn AS isbn_9,
  t0.e_isbn AS e_isbn_10,
  t0.issn AS issn_11,
  t0.e_issn AS e_issn_12,
  t0.doi AS doi_13,
  t0.edition AS edition_14,
  t0.numero_collection AS numero_collection_15,
  t0.tome AS tome_16,
  t0.nb_volumes AS nb_volumes_17,
  t0.volume AS volume_18,
  t0.numero AS numero_19,
  t0.fascicule AS fascicule_20,
  t0.cahier AS cahier_21,
  t0.tirage AS tirage_22,
  t0.notes AS notes_23,
  t0.date_creation AS date_creation_24,
  t0.date_update AS date_update_25,
  t0.validation AS validation_26,
  t0.type_id AS type_id_27,
  t0.support_id AS support_id_28,
  t0.editeur_id AS editeur_id_29,
  t0.collection_id AS collection_id_30,
  t0.doc_original_id AS doc_original_id_31,
  t0.infos_element_id AS infos_element_id_32,
  t0.infos_these_id AS infos_these_id_33
FROM
  document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.comp_titre AS comp_titre_3, t0.annee AS annee_4, t0.ville AS ville_5, t0.format AS format_6, t0.nb_pages AS nb_pages_7, t0.pagination_double AS pagination_double_8, t0.isbn AS isbn_9, t0.e_isbn AS e_isbn_10, t0.issn AS issn_11, t0.e_issn AS e_issn_12, t0.doi AS doi_13, t0.edition AS edition_14, t0.numero_collection AS numero_collection_15, t0.tome AS tome_16, t0.nb_volumes AS nb_volumes_17, t0.volume AS volume_18, t0.numero AS numero_19, t0.fascicule AS fascicule_20, t0.cahier AS cahier_21, t0.tirage AS tirage_22, t0.notes AS notes_23, t0.date_creation AS date_creation_24, t0.date_update AS date_update_25, t0.validation AS validation_26, t0.type_id AS type_id_27, t0.support_id AS support_id_28, t0.editeur_id AS editeur_id_29, t0.collection_id AS collection_id_30, t0.doc_original_id AS doc_original_id_31, t0.infos_element_id AS infos_element_id_32, t0.infos_these_id AS infos_these_id_33 FROM document t0 WHERE t0.id = 2434;

SELECT
  p.id,
  CONCAT(p.prenom, ' ', p.nom) AS identite
FROM
  document_autorite aut
  INNER JOIN personne p ON aut.personne_id = p.id
WHERE
  aut.document_id = ?
  AND aut.role_id = ?
ORDER BY
  aut.rang ASC

SELECT p.id, CONCAT(p.prenom, ' ', p.nom) AS identite 
        FROM document_autorite aut
        INNER JOIN personne p ON aut.personne_id = p.id
        WHERE aut.document_id = 2438
        AND aut.role_id = 1
        ORDER BY aut.rang ASC;

SELECT
  p.id,
  CONCAT(p.prenom, ' ', p.nom) AS identite
FROM
  document_autorite aut
  INNER JOIN personne p ON aut.personne_id = p.id
WHERE
  aut.document_id = ?
  AND aut.role_id = ?
ORDER BY
  aut.rang ASC

SELECT p.id, CONCAT(p.prenom, ' ', p.nom) AS identite 
        FROM document_autorite aut
        INNER JOIN personne p ON aut.personne_id = p.id
        WHERE aut.document_id = 2438
        AND aut.role_id = 3
        ORDER BY aut.rang ASC;

SELECT
  t0.id AS id_1,
  t0.libelle_fr AS libelle_fr_2,
  t0.libelle_en AS libelle_en_3
FROM
  support t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3 FROM support t0 WHERE t0.id = 1;

SELECT
  t0.document_id AS document_id_1,
  t0.langue_id AS langue_id_2
FROM
  document_langue t0
WHERE
  t0.document_id = ?

SELECT t0.document_id AS document_id_1, t0.langue_id AS langue_id_2 FROM document_langue t0 WHERE t0.document_id = 2438;

SELECT
  t0.id AS id_1,
  t0.libelle_fr AS libelle_fr_2,
  t0.libelle_en AS libelle_en_3,
  t0.code_iso AS code_iso_4
FROM
  langue t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.code_iso AS code_iso_4 FROM langue t0 WHERE t0.id = 1;

SELECT
  t0.document_id AS document_id_1,
  t0.url_id AS url_id_2
FROM
  document_url t0
WHERE
  t0.document_id = ?

SELECT t0.document_id AS document_id_1, t0.url_id AS url_id_2 FROM document_url t0 WHERE t0.document_id = 2438;

SELECT
  t0.id AS id_1,
  t0.libelle_fr AS libelle_fr_2,
  t0.libelle_en AS libelle_en_3
FROM
  paratexte t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3 FROM paratexte t0 ORDER BY t0.id ASC;

SELECT
  p.id,
  CONCAT(p.prenom, ' ', p.nom) AS identite,
  dp.rang,
  dp.page_debut,
  dp.page_fin,
  pt.libelle_fr,
  pt.libelle_en,
  pt.id AS id_paratexte
FROM
  document_paratexte dp
  INNER JOIN personne p ON dp.personne_id = p.id
  INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
WHERE
  dp.document_id = ?
  AND dp.paratexte_id = ?
ORDER BY
  dp.rang

SELECT p.id, CONCAT(p.prenom, ' ', p.nom) AS identite, dp.rang, dp.page_debut, dp.page_fin, pt.libelle_fr, pt.libelle_en, pt.id AS id_paratexte
        FROM document_paratexte dp
        INNER JOIN personne p ON dp.personne_id = p.id
        INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
        WHERE dp.document_id = 2438
        AND dp.paratexte_id = 1
        ORDER BY dp.rang;

SELECT
  p.id,
  CONCAT(p.prenom, ' ', p.nom) AS identite,
  dp.rang,
  dp.page_debut,
  dp.page_fin,
  pt.libelle_fr,
  pt.libelle_en,
  pt.id AS id_paratexte
FROM
  document_paratexte dp
  INNER JOIN personne p ON dp.personne_id = p.id
  INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
WHERE
  dp.document_id = ?
  AND dp.paratexte_id = ?
ORDER BY
  dp.rang

SELECT p.id, CONCAT(p.prenom, ' ', p.nom) AS identite, dp.rang, dp.page_debut, dp.page_fin, pt.libelle_fr, pt.libelle_en, pt.id AS id_paratexte
        FROM document_paratexte dp
        INNER JOIN personne p ON dp.personne_id = p.id
        INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
        WHERE dp.document_id = 2438
        AND dp.paratexte_id = 2
        ORDER BY dp.rang;

SELECT
  p.id,
  CONCAT(p.prenom, ' ', p.nom) AS identite,
  dp.rang,
  dp.page_debut,
  dp.page_fin,
  pt.libelle_fr,
  pt.libelle_en,
  pt.id AS id_paratexte
FROM
  document_paratexte dp
  INNER JOIN personne p ON dp.personne_id = p.id
  INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
WHERE
  dp.document_id = ?
  AND dp.paratexte_id = ?
ORDER BY
  dp.rang

SELECT p.id, CONCAT(p.prenom, ' ', p.nom) AS identite, dp.rang, dp.page_debut, dp.page_fin, pt.libelle_fr, pt.libelle_en, pt.id AS id_paratexte
        FROM document_paratexte dp
        INNER JOIN personne p ON dp.personne_id = p.id
        INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
        WHERE dp.document_id = 2438
        AND dp.paratexte_id = 3
        ORDER BY dp.rang;

SELECT
  p.id,
  CONCAT(p.prenom, ' ', p.nom) AS identite,
  dp.rang,
  dp.page_debut,
  dp.page_fin,
  pt.libelle_fr,
  pt.libelle_en,
  pt.id AS id_paratexte
FROM
  document_paratexte dp
  INNER JOIN personne p ON dp.personne_id = p.id
  INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
WHERE
  dp.document_id = ?
  AND dp.paratexte_id = ?
ORDER BY
  dp.rang

SELECT p.id, CONCAT(p.prenom, ' ', p.nom) AS identite, dp.rang, dp.page_debut, dp.page_fin, pt.libelle_fr, pt.libelle_en, pt.id AS id_paratexte
        FROM document_paratexte dp
        INNER JOIN personne p ON dp.personne_id = p.id
        INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
        WHERE dp.document_id = 2438
        AND dp.paratexte_id = 4
        ORDER BY dp.rang;

SELECT
  p.id,
  CONCAT(p.prenom, ' ', p.nom) AS identite,
  dp.rang,
  dp.page_debut,
  dp.page_fin,
  pt.libelle_fr,
  pt.libelle_en,
  pt.id AS id_paratexte
FROM
  document_paratexte dp
  INNER JOIN personne p ON dp.personne_id = p.id
  INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
WHERE
  dp.document_id = ?
  AND dp.paratexte_id = ?
ORDER BY
  dp.rang

SELECT p.id, CONCAT(p.prenom, ' ', p.nom) AS identite, dp.rang, dp.page_debut, dp.page_fin, pt.libelle_fr, pt.libelle_en, pt.id AS id_paratexte
        FROM document_paratexte dp
        INNER JOIN personne p ON dp.personne_id = p.id
        INNER JOIN paratexte pt ON dp.paratexte_id = pt.id
        WHERE dp.document_id = 2438
        AND dp.paratexte_id = 5
        ORDER BY dp.rang;

SELECT
  t0.id AS id_1,
  t0.titre_fr AS titre_fr_2,
  t0.titre_en AS titre_en_3,
  t0.numero AS numero_4,
  t0.pagination AS pagination_5,
  t0.document_id AS document_id_6,
  t0.paratexte_element_id AS paratexte_element_id_7
FROM
  document_paratexte_element t0
WHERE
  t0.document_id = ?

SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.numero AS numero_4, t0.pagination AS pagination_5, t0.document_id AS document_id_6, t0.paratexte_element_id AS paratexte_element_id_7 FROM document_paratexte_element t0 WHERE t0.document_id = 2438;

SELECT
  t0.id AS id_1,
  t0.resume AS resume_2,
  t0.document_id AS document_id_3,
  t0.langue_id AS langue_id_4
FROM
  resume t0
WHERE
  t0.document_id = ?

SELECT t0.id AS id_1, t0.resume AS resume_2, t0.document_id AS document_id_3, t0.langue_id AS langue_id_4 FROM resume t0 WHERE t0.document_id = 2438;

SELECT
  mc.id,
  mc.libelle_fr,
  mc.libelle_en,
  dmc.rang
FROM
  document_mot_cle dmc
  INNER JOIN document d ON dmc.document_id = d.id
  INNER JOIN mot_cle mc ON dmc.motcle_id = mc.id
WHERE
  d.id = ?
ORDER BY
  dmc.rang

SELECT mc.id, mc.libelle_fr, mc.libelle_en, dmc.rang
        FROM document_mot_cle dmc
        INNER JOIN document d ON dmc.document_id = d.id
        INNER JOIN mot_cle mc ON dmc.motcle_id = mc.id
        WHERE d.id = 2438
        ORDER BY dmc.rang;