2.39 ms (22.80%)
|
5 |
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
Parameters: [â–¼
2390
1
]
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 = 2390
AND dp.paratexte_id = 1
ORDER BY dp.rang;
|
1.48 ms (14.14%)
|
1 |
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 = ?
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 = 2390;
|