Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.sous_titre AS sous_titre_3,
  t0.date_ajout AS date_ajout_4,
  t0.nb_page AS nb_page_5,
  t0.prix AS prix_6,
  t0.traducteur AS traducteur_7,
  t0.ean AS ean_8,
  t0.collection AS collection_9,
  t0.date_parution AS date_parution_10,
  t0.video AS video_11,
  t0.audio AS audio_12,
  t0.poche AS poche_13,
  t0.url_feuilletage AS url_feuilletage_14,
  t0.premier_roman AS premier_roman_15,
  t0.update_at AS update_at_16,
  t0.old_id AS old_id_17,
  t0.slug AS slug_18,
  t0.is_web_only AS is_web_only_19,
  t0.has_couv AS has_couv_20,
  t0.reco_text AS reco_text_21,
  t0.info_techis_valid AS info_techis_valid_22,
  t0.mediasis_valid AS mediasis_valid_23,
  t0.chroniqueis_valid AS chroniqueis_valid_24,
  t0.maquette_ftis_valid AS maquette_ftis_valid_25,
  t0.maquette_mediais_valid AS maquette_mediais_valid_26,
  t0.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_27,
  t0.reco_is_valid AS reco_is_valid_28,
  t0.maquette_reco_is_valid AS maquette_reco_is_valid_29,
  t0.niveau_libraire AS niveau_libraire_30,
  t0.jpro_video AS jpro_video_31,
  t0.has_thumb AS has_thumb_32,
  t0.image_interieur AS image_interieur_33,
  t0.url_interieur AS url_interieur_34,
  t0.genre_id AS genre_id_35,
  t0.type_id AS type_id_36,
  t0.niveau_id AS niveau_id_37,
  t0.distributeur_id AS distributeur_id_38,
  t0.ecrivain_voyageur_id AS ecrivain_voyageur_id_39,
  t0.jplecture_id AS jplecture_id_40,
  t0.j_pro_editeur_id AS j_pro_editeur_id_41,
  t0.categorie_id AS categorie_id_42,
  t0.interieur_ext_id AS interieur_ext_id_43
FROM
  livre t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.date_ajout AS date_ajout_4, t0.nb_page AS nb_page_5, t0.prix AS prix_6, t0.traducteur AS traducteur_7, t0.ean AS ean_8, t0.collection AS collection_9, t0.date_parution AS date_parution_10, t0.video AS video_11, t0.audio AS audio_12, t0.poche AS poche_13, t0.url_feuilletage AS url_feuilletage_14, t0.premier_roman AS premier_roman_15, t0.update_at AS update_at_16, t0.old_id AS old_id_17, t0.slug AS slug_18, t0.is_web_only AS is_web_only_19, t0.has_couv AS has_couv_20, t0.reco_text AS reco_text_21, t0.info_techis_valid AS info_techis_valid_22, t0.mediasis_valid AS mediasis_valid_23, t0.chroniqueis_valid AS chroniqueis_valid_24, t0.maquette_ftis_valid AS maquette_ftis_valid_25, t0.maquette_mediais_valid AS maquette_mediais_valid_26, t0.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_27, t0.reco_is_valid AS reco_is_valid_28, t0.maquette_reco_is_valid AS maquette_reco_is_valid_29, t0.niveau_libraire AS niveau_libraire_30, t0.jpro_video AS jpro_video_31, t0.has_thumb AS has_thumb_32, t0.image_interieur AS image_interieur_33, t0.url_interieur AS url_interieur_34, t0.genre_id AS genre_id_35, t0.type_id AS type_id_36, t0.niveau_id AS niveau_id_37, t0.distributeur_id AS distributeur_id_38, t0.ecrivain_voyageur_id AS ecrivain_voyageur_id_39, t0.jplecture_id AS jplecture_id_40, t0.j_pro_editeur_id AS j_pro_editeur_id_41, t0.categorie_id AS categorie_id_42, t0.interieur_ext_id AS interieur_ext_id_43 FROM livre t0 WHERE t0.slug = 'peines-perdues' LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.nom AS nom_1,
  f0_.titre AS titre_2,
  f0_.code AS code_3,
  f0_.est_publie AS est_publie_4,
  f0_.est_metier AS est_metier_5,
  f1_.id AS id_6,
  f1_.titre AS titre_7,
  f1_.date_creation AS date_creation_8,
  f1_.is_permanent AS is_permanent_9,
  f1_.date_debut_pub AS date_debut_pub_10,
  f1_.date_fin_pub AS date_fin_pub_11,
  f1_.ordre AS ordre_12,
  f1_.image AS image_13,
  f1_.texte AS texte_14,
  f1_.image_position AS image_position_15,
  f1_.parameters AS parameters_16,
  f1_.couleur_fond_id AS couleur_fond_id_17,
  f1_.type_id AS type_id_18,
  f1_.front_page_id AS front_page_id_19
FROM
  front_page f0_
  LEFT JOIN front_module f1_ ON f0_.id = f1_.front_page_id
WHERE
  f0_.code = ?
ORDER BY
  f1_.ordre ASC

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.titre AS titre_2, f0_.code AS code_3, f0_.est_publie AS est_publie_4, f0_.est_metier AS est_metier_5, f1_.id AS id_6, f1_.titre AS titre_7, f1_.date_creation AS date_creation_8, f1_.is_permanent AS is_permanent_9, f1_.date_debut_pub AS date_debut_pub_10, f1_.date_fin_pub AS date_fin_pub_11, f1_.ordre AS ordre_12, f1_.image AS image_13, f1_.texte AS texte_14, f1_.image_position AS image_position_15, f1_.parameters AS parameters_16, f1_.couleur_fond_id AS couleur_fond_id_17, f1_.type_id AS type_id_18, f1_.front_page_id AS front_page_id_19 FROM front_page f0_ LEFT JOIN front_module f1_ ON f0_.id = f1_.front_page_id WHERE f0_.code = 'chronique' ORDER BY f1_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.infois_ok AS infois_ok_3,
  t0.visuel_ok AS visuel_ok_4,
  t0.recos_ok AS recos_ok_5,
  t0.textes_ok AS textes_ok_6,
  t0.date_creation AS date_creation_7,
  t0.update_at AS update_at_8,
  t0.signature AS signature_9,
  t0.old_id AS old_id_10,
  t0.reco_selectionne AS reco_selectionne_11,
  t0.type AS type_12,
  t0.exergue AS exergue_13,
  t0.texte_original_id AS texte_original_id_14,
  t0.texte_relu_id AS texte_relu_id_15,
  t0.texte_final_id AS texte_final_id_16,
  t0.revue_id AS revue_id_17,
  t0.auteur_id AS auteur_id_18,
  t0.contact_id AS contact_id_19,
  t0.genre_id AS genre_id_20
FROM
  chronique t0
  INNER JOIN chronique_livre ON t0.id = chronique_livre.chronique_id
WHERE
  chronique_livre.livre_id = ?
ORDER BY
  t0.type DESC,
  t0.id DESC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.infois_ok AS infois_ok_3, t0.visuel_ok AS visuel_ok_4, t0.recos_ok AS recos_ok_5, t0.textes_ok AS textes_ok_6, t0.date_creation AS date_creation_7, t0.update_at AS update_at_8, t0.signature AS signature_9, t0.old_id AS old_id_10, t0.reco_selectionne AS reco_selectionne_11, t0.type AS type_12, t0.exergue AS exergue_13, t0.texte_original_id AS texte_original_id_14, t0.texte_relu_id AS texte_relu_id_15, t0.texte_final_id AS texte_final_id_16, t0.revue_id AS revue_id_17, t0.auteur_id AS auteur_id_18, t0.contact_id AS contact_id_19, t0.genre_id AS genre_id_20 FROM chronique t0 INNER JOIN chronique_livre ON t0.id = chronique_livre.chronique_id WHERE chronique_livre.livre_id = 21594 ORDER BY t0.type DESC, t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.chapeau AS chapeau_3,
  t0.contenu AS contenu_4,
  t0.is_valide AS is_valide_5
FROM
  chronique_texte t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.chapeau AS chapeau_3, t0.contenu AS contenu_4, t0.is_valide AS is_valide_5 FROM chronique_texte t0 WHERE t0.id = 27339;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_electre AS nom_electre_3,
  t0.couleur AS couleur_4,
  t0.ordre AS ordre_5,
  t0.slug AS slug_6,
  t0.old_id AS old_id_7,
  t0.color1 AS color1_8,
  t0.color2 AS color2_9,
  t0.parent_id AS parent_id_10
FROM
  genre t0
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.titre AS titre_4,
  t0.texte AS texte_5,
  t0.is_actif AS is_actif_6,
  t0.nom AS nom_7,
  t0.slug AS slug_8,
  t0.categorie AS categorie_9,
  t10.id AS id_11,
  t10.titre AS titre_12,
  t10.texte_explicatif AS texte_explicatif_13,
  t10.actif AS actif_14,
  t10.date AS date_15,
  t10.slug AS slug_16,
  t10.lieu AS lieu_17,
  t10.repartition_pro AS repartition_pro_18,
  t10.nb_max_peronnes AS nb_max_peronnes_19,
  t10.critere_inscrit AS critere_inscrit_20,
  t10.lib_contenu AS lib_contenu_21,
  t10.bib_abonnee AS bib_abonnee_22,
  t10.lib_dif AS lib_dif_23,
  t10.type_jp AS type_jp_24,
  t10.heure_debut AS heure_debut_25,
  t10.heure_fin AS heure_fin_26,
  t10.image_badge AS image_badge_27,
  t10.display_corner_editeur AS display_corner_editeur_28,
  t10.illustration AS illustration_29,
  t10.video AS video_30,
  t10.programme AS programme_31,
  t10.livret AS livret_32,
  t10.active_chapitrage AS active_chapitrage_33,
  t10.chapitrage_category AS chapitrage_category_34,
  t10.date_badge AS date_badge_35,
  t10.page_id AS page_id_36
FROM
  page t0
  LEFT JOIN journee_pro t10 ON t10.page_id = t0.id
WHERE
  t0.type = ?
  AND t0.is_actif = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = 'front_metier' AND t0.is_actif = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.titre AS titre_4,
  t0.texte AS texte_5,
  t0.is_actif AS is_actif_6,
  t0.nom AS nom_7,
  t0.slug AS slug_8,
  t0.categorie AS categorie_9,
  t10.id AS id_11,
  t10.titre AS titre_12,
  t10.texte_explicatif AS texte_explicatif_13,
  t10.actif AS actif_14,
  t10.date AS date_15,
  t10.slug AS slug_16,
  t10.lieu AS lieu_17,
  t10.repartition_pro AS repartition_pro_18,
  t10.nb_max_peronnes AS nb_max_peronnes_19,
  t10.critere_inscrit AS critere_inscrit_20,
  t10.lib_contenu AS lib_contenu_21,
  t10.bib_abonnee AS bib_abonnee_22,
  t10.lib_dif AS lib_dif_23,
  t10.type_jp AS type_jp_24,
  t10.heure_debut AS heure_debut_25,
  t10.heure_fin AS heure_fin_26,
  t10.image_badge AS image_badge_27,
  t10.display_corner_editeur AS display_corner_editeur_28,
  t10.illustration AS illustration_29,
  t10.video AS video_30,
  t10.programme AS programme_31,
  t10.livret AS livret_32,
  t10.active_chapitrage AS active_chapitrage_33,
  t10.chapitrage_category AS chapitrage_category_34,
  t10.date_badge AS date_badge_35,
  t10.page_id AS page_id_36
FROM
  page t0
  LEFT JOIN journee_pro t10 ON t10.page_id = t0.id
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = 'front';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.titre AS titre_4,
  t0.texte AS texte_5,
  t0.is_actif AS is_actif_6,
  t0.nom AS nom_7,
  t0.slug AS slug_8,
  t0.categorie AS categorie_9,
  t10.id AS id_11,
  t10.titre AS titre_12,
  t10.texte_explicatif AS texte_explicatif_13,
  t10.actif AS actif_14,
  t10.date AS date_15,
  t10.slug AS slug_16,
  t10.lieu AS lieu_17,
  t10.repartition_pro AS repartition_pro_18,
  t10.nb_max_peronnes AS nb_max_peronnes_19,
  t10.critere_inscrit AS critere_inscrit_20,
  t10.lib_contenu AS lib_contenu_21,
  t10.bib_abonnee AS bib_abonnee_22,
  t10.lib_dif AS lib_dif_23,
  t10.type_jp AS type_jp_24,
  t10.heure_debut AS heure_debut_25,
  t10.heure_fin AS heure_fin_26,
  t10.image_badge AS image_badge_27,
  t10.display_corner_editeur AS display_corner_editeur_28,
  t10.illustration AS illustration_29,
  t10.video AS video_30,
  t10.programme AS programme_31,
  t10.livret AS livret_32,
  t10.active_chapitrage AS active_chapitrage_33,
  t10.chapitrage_category AS chapitrage_category_34,
  t10.date_badge AS date_badge_35,
  t10.page_id AS page_id_36
FROM
  page t0
  LEFT JOIN journee_pro t10 ON t10.page_id = t0.id
WHERE
  t0.type = ?
  AND t0.is_actif = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = 'front_metier' AND t0.is_actif = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.titre AS titre_4,
  t0.texte AS texte_5,
  t0.is_actif AS is_actif_6,
  t0.nom AS nom_7,
  t0.slug AS slug_8,
  t0.categorie AS categorie_9,
  t10.id AS id_11,
  t10.titre AS titre_12,
  t10.texte_explicatif AS texte_explicatif_13,
  t10.actif AS actif_14,
  t10.date AS date_15,
  t10.slug AS slug_16,
  t10.lieu AS lieu_17,
  t10.repartition_pro AS repartition_pro_18,
  t10.nb_max_peronnes AS nb_max_peronnes_19,
  t10.critere_inscrit AS critere_inscrit_20,
  t10.lib_contenu AS lib_contenu_21,
  t10.bib_abonnee AS bib_abonnee_22,
  t10.lib_dif AS lib_dif_23,
  t10.type_jp AS type_jp_24,
  t10.heure_debut AS heure_debut_25,
  t10.heure_fin AS heure_fin_26,
  t10.image_badge AS image_badge_27,
  t10.display_corner_editeur AS display_corner_editeur_28,
  t10.illustration AS illustration_29,
  t10.video AS video_30,
  t10.programme AS programme_31,
  t10.livret AS livret_32,
  t10.active_chapitrage AS active_chapitrage_33,
  t10.chapitrage_category AS chapitrage_category_34,
  t10.date_badge AS date_badge_35,
  t10.page_id AS page_id_36
FROM
  page t0
  LEFT JOIN journee_pro t10 ON t10.page_id = t0.id
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = 'front';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_electre AS nom_electre_3,
  t0.couleur AS couleur_4,
  t0.ordre AS ordre_5,
  t0.slug AS slug_6,
  t0.old_id AS old_id_7,
  t0.color1 AS color1_8,
  t0.color2 AS color2_9,
  t0.parent_id AS parent_id_10
FROM
  genre t0
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.descriptif AS descriptif_4
FROM
  type_front_module t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.descriptif AS descriptif_4 FROM type_front_module t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.prenom AS prenom_2,
  t0.nom AS nom_3,
  t0.biographie AS biographie_4,
  t0.bibliographie AS bibliographie_5,
  t0.date_creation AS date_creation_6,
  t0.update_at AS update_at_7,
  t0.is_ecrivain AS is_ecrivain_8,
  t0.is_illustrateur AS is_illustrateur_9,
  t0.old_id AS old_id_10,
  t0.portrait AS portrait_11,
  t0.id_electre AS id_electre_12,
  t0.photo_ext_id AS photo_ext_id_13
FROM
  auteur t0
  INNER JOIN livre_auteur ON t0.id = livre_auteur.auteur_id
WHERE
  livre_auteur.livre_id = ?

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.biographie AS biographie_4, t0.bibliographie AS bibliographie_5, t0.date_creation AS date_creation_6, t0.update_at AS update_at_7, t0.is_ecrivain AS is_ecrivain_8, t0.is_illustrateur AS is_illustrateur_9, t0.old_id AS old_id_10, t0.portrait AS portrait_11, t0.id_electre AS id_electre_12, t0.photo_ext_id AS photo_ext_id_13 FROM auteur t0 INNER JOIN livre_auteur ON t0.id = livre_auteur.auteur_id WHERE livre_auteur.livre_id = 21594;

SELECT
  t0.id AS id_1,
  t0.prenom AS prenom_2,
  t0.nom AS nom_3,
  t0.biographie AS biographie_4,
  t0.bibliographie AS bibliographie_5,
  t0.date_creation AS date_creation_6,
  t0.update_at AS update_at_7,
  t0.is_ecrivain AS is_ecrivain_8,
  t0.is_illustrateur AS is_illustrateur_9,
  t0.old_id AS old_id_10,
  t0.portrait AS portrait_11,
  t0.id_electre AS id_electre_12,
  t0.photo_ext_id AS photo_ext_id_13
FROM
  auteur t0
  INNER JOIN livre_illustrateur ON t0.id = livre_illustrateur.auteur_id
WHERE
  livre_illustrateur.livre_id = ?

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.biographie AS biographie_4, t0.bibliographie AS bibliographie_5, t0.date_creation AS date_creation_6, t0.update_at AS update_at_7, t0.is_ecrivain AS is_ecrivain_8, t0.is_illustrateur AS is_illustrateur_9, t0.old_id AS old_id_10, t0.portrait AS portrait_11, t0.id_electre AS id_electre_12, t0.photo_ext_id AS photo_ext_id_13 FROM auteur t0 INNER JOIN livre_illustrateur ON t0.id = livre_illustrateur.auteur_id WHERE livre_illustrateur.livre_id = 21594;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.old_id AS old_id_3,
  t0.slug AS slug_4,
  t0.date_creation AS date_creation_5,
  t0.udpate_at AS udpate_at_6,
  t0.alias_electre AS alias_electre_7,
  t0.id_electre AS id_electre_8
FROM
  editeur t0
  INNER JOIN livre_editeur ON t0.id = livre_editeur.editeur_id
WHERE
  livre_editeur.livre_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.old_id AS old_id_3, t0.slug AS slug_4, t0.date_creation AS date_creation_5, t0.udpate_at AS udpate_at_6, t0.alias_electre AS alias_electre_7, t0.id_electre AS id_electre_8 FROM editeur t0 INNER JOIN livre_editeur ON t0.id = livre_editeur.editeur_id WHERE livre_editeur.livre_id = 21594;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.telephone AS telephone_4,
  t0.code_abomarque AS code_abomarque_5,
  t0.commentaire AS commentaire_6,
  t0.facebook AS facebook_7,
  t0.twitter AS twitter_8,
  t0.email AS email_9,
  t0.old_id AS old_id_10,
  t0.civilite AS civilite_11,
  t0.old_userid AS old_userid_12,
  t0.actif AS actif_13,
  t0.bio AS bio_14,
  t0.has_photo AS has_photo_15,
  t0.is_referent AS is_referent_16,
  t0.date_creation AS date_creation_17,
  t0.receive_nmardi AS receive_nmardi_18,
  t0.receive_nvendredi AS receive_nvendredi_19,
  t0.receive_ireseau AS receive_ireseau_20,
  t0.structure_id AS structure_id_21,
  t0.adresse_id AS adresse_id_22,
  t0.utilisateur_id AS utilisateur_id_23,
  t0.news_contact_id AS news_contact_id_24
FROM
  contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.telephone AS telephone_4, t0.code_abomarque AS code_abomarque_5, t0.commentaire AS commentaire_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.email AS email_9, t0.old_id AS old_id_10, t0.civilite AS civilite_11, t0.old_userid AS old_userid_12, t0.actif AS actif_13, t0.bio AS bio_14, t0.has_photo AS has_photo_15, t0.is_referent AS is_referent_16, t0.date_creation AS date_creation_17, t0.receive_nmardi AS receive_nmardi_18, t0.receive_nvendredi AS receive_nvendredi_19, t0.receive_ireseau AS receive_ireseau_20, t0.structure_id AS structure_id_21, t0.adresse_id AS adresse_id_22, t0.utilisateur_id AS utilisateur_id_23, t0.news_contact_id AS news_contact_id_24 FROM contact t0 WHERE t0.id = 4882;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.telephone AS telephone_3,
  t0.email AS email_4,
  t0.code_abomarque AS code_abomarque_5,
  t0.compte_cegid AS compte_cegid_6,
  t0.tvaintra AS tvaintra_7,
  t0.exonere_tva AS exonere_tva_8,
  t0.facebook AS facebook_9,
  t0.twitter AS twitter_10,
  t0.site_web AS site_web_11,
  t0.logo_accueil AS logo_accueil_12,
  t0.editeur_poche AS editeur_poche_13,
  t0.alias_electre AS alias_electre_14,
  t0.sarch_id AS sarch_id_15,
  t0.type_actif AS type_actif_16,
  t0.logo AS logo_17,
  t0.is_referent AS is_referent_18,
  t0.est_abonne AS est_abonne_19,
  t0.date_creation AS date_creation_20,
  t0.siret AS siret_21,
  t0.zone_geo AS zone_geo_22,
  t0.type_id AS type_id_23,
  t0.departement_id AS departement_id_24,
  t0.region_id AS region_id_25,
  t26.id AS id_27,
  t26.sujet AS sujet_28,
  t26.nom_exp AS nom_exp_29,
  t26.email_exp AS email_exp_30,
  t26.nom_retour AS nom_retour_31,
  t26.email_retour AS email_retour_32,
  t26.structure_id AS structure_id_33
FROM
  structure t0
  LEFT JOIN client_cle_en_main t26 ON t26.structure_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.email AS email_4, t0.code_abomarque AS code_abomarque_5, t0.compte_cegid AS compte_cegid_6, t0.tvaintra AS tvaintra_7, t0.exonere_tva AS exonere_tva_8, t0.facebook AS facebook_9, t0.twitter AS twitter_10, t0.site_web AS site_web_11, t0.logo_accueil AS logo_accueil_12, t0.editeur_poche AS editeur_poche_13, t0.alias_electre AS alias_electre_14, t0.sarch_id AS sarch_id_15, t0.type_actif AS type_actif_16, t0.logo AS logo_17, t0.is_referent AS is_referent_18, t0.est_abonne AS est_abonne_19, t0.date_creation AS date_creation_20, t0.siret AS siret_21, t0.zone_geo AS zone_geo_22, t0.type_id AS type_id_23, t0.departement_id AS departement_id_24, t0.region_id AS region_id_25, t26.id AS id_27, t26.sujet AS sujet_28, t26.nom_exp AS nom_exp_29, t26.email_exp AS email_exp_30, t26.nom_retour AS nom_retour_31, t26.email_retour AS email_retour_32, t26.structure_id AS structure_id_33 FROM structure t0 LEFT JOIN client_cle_en_main t26 ON t26.structure_id = t0.id WHERE t0.id = 2324;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.old_id AS old_id_3,
  t0.type_espace_pro_id AS type_espace_pro_id_4
FROM
  type_structure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.old_id AS old_id_3, t0.type_espace_pro_id AS type_espace_pro_id_4 FROM type_structure t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.ligne1 AS ligne1_2,
  t0.ligne2 AS ligne2_3,
  t0.ligne3 AS ligne3_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.etat AS etat_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.pays AS pays_10,
  t0.label AS label_11,
  t0.principale AS principale_12,
  t0.structure_id AS structure_id_13
FROM
  adresse t0
WHERE
  t0.structure_id = ?
ORDER BY
  t0.principale DESC