Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.titre AS titre_3,
  t0.code AS code_4,
  t0.est_publie AS est_publie_5,
  t0.est_metier AS est_metier_6
FROM
  front_page t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.code AS code_4, t0.est_publie AS est_publie_5, t0.est_metier AS est_metier_6 FROM front_page t0 WHERE t0.code = 'ou-nous-trouver' LIMIT 1;

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.titre AS titre_2,
  t0.date_creation AS date_creation_3,
  t0.is_permanent AS is_permanent_4,
  t0.date_debut_pub AS date_debut_pub_5,
  t0.date_fin_pub AS date_fin_pub_6,
  t0.ordre AS ordre_7,
  t0.image AS image_8,
  t0.texte AS texte_9,
  t0.image_position AS image_position_10,
  t0.parameters AS parameters_11,
  t0.couleur_fond_id AS couleur_fond_id_12,
  t0.type_id AS type_id_13,
  t0.front_page_id AS front_page_id_14
FROM
  front_module t0
WHERE
  t0.front_page_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_creation AS date_creation_3, t0.is_permanent AS is_permanent_4, t0.date_debut_pub AS date_debut_pub_5, t0.date_fin_pub AS date_fin_pub_6, t0.ordre AS ordre_7, t0.image AS image_8, t0.texte AS texte_9, t0.image_position AS image_position_10, t0.parameters AS parameters_11, t0.couleur_fond_id AS couleur_fond_id_12, t0.type_id AS type_id_13, t0.front_page_id AS front_page_id_14 FROM front_module t0 WHERE t0.front_page_id = 24 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 = 1;

SELECT
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.date_fin AS date_fin_3,
  t0.parameters AS parameters_4,
  t0.front_module_id AS front_module_id_5
FROM
  timeline t0
WHERE
  t0.front_module_id = ?
ORDER BY
  t0.date_debut ASC

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.parameters AS parameters_4, t0.front_module_id AS front_module_id_5 FROM timeline t0 WHERE t0.front_module_id = 70 ORDER BY t0.date_debut 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 = 18;

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.numero AS numero_2,
  r0_.date_publication AS date_publication_3,
  r0_.date_bouclage AS date_bouclage_4,
  r0_.date_livraison AS date_livraison_5,
  r0_.date_butoir AS date_butoir_6,
  r0_.cle_pressmo AS cle_pressmo_7,
  r0_.repertoire AS repertoire_8,
  r0_.prix AS prix_9,
  r0_.epuise AS epuise_10
FROM
  revue r0_
WHERE
  r0_.date_publication < ?
ORDER BY
  r0_.numero DESC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.numero AS numero_2, r0_.date_publication AS date_publication_3, r0_.date_bouclage AS date_bouclage_4, r0_.date_livraison AS date_livraison_5, r0_.date_butoir AS date_butoir_6, r0_.cle_pressmo AS cle_pressmo_7, r0_.repertoire AS repertoire_8, r0_.prix AS prix_9, r0_.epuise AS epuise_10 FROM revue r0_ WHERE r0_.date_publication < '2026-06-02 18:18:17' ORDER BY r0_.numero DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.facturee AS facturee_3,
  t0.retournee AS retournee_4,
  t0.repique AS repique_5,
  t0.is_avenant AS is_avenant_6,
  t0.revue_id AS revue_id_7,
  t0.contrat_id AS contrat_id_8,
  t9.id AS id_10,
  t9.is_avoir AS is_avoir_11,
  t9.montant_ht AS montant_ht_12,
  t9.montant_ttc AS montant_ttc_13,
  t9.quantite_fact AS quantite_fact_14,
  t9.date_facturation AS date_facturation_15,
  t9.is_traite AS is_traite_16,
  t9.date_traitement AS date_traitement_17,
  t9.diffusion_num_id AS diffusion_num_id_18
FROM
  diffusion_num t0
  LEFT JOIN diffusion_fact t9 ON t9.diffusion_num_id = t0.id
WHERE
  t0.revue_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.facturee AS facturee_3, t0.retournee AS retournee_4, t0.repique AS repique_5, t0.is_avenant AS is_avenant_6, t0.revue_id AS revue_id_7, t0.contrat_id AS contrat_id_8, t9.id AS id_10, t9.is_avoir AS is_avoir_11, t9.montant_ht AS montant_ht_12, t9.montant_ttc AS montant_ttc_13, t9.quantite_fact AS quantite_fact_14, t9.date_facturation AS date_facturation_15, t9.is_traite AS is_traite_16, t9.date_traitement AS date_traitement_17, t9.diffusion_num_id AS diffusion_num_id_18 FROM diffusion_num t0 LEFT JOIN diffusion_fact t9 ON t9.diffusion_num_id = t0.id WHERE t0.revue_id = 99;

SELECT
  t0.id AS id_1,
  t0.id_contrat AS id_contrat_2,
  t0.num_debut AS num_debut_3,
  t0.num_fin AS num_fin_4,
  t0.type_tarif AS type_tarif_5,
  t0.type_facturation AS type_facturation_6,
  t0.type_livraison AS type_livraison_7,
  t0.tarif_uht AS tarif_uht_8,
  t0.structure_id AS structure_id_9,
  t0.type_id AS type_id_10
FROM
  diffusion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_contrat AS id_contrat_2, t0.num_debut AS num_debut_3, t0.num_fin AS num_fin_4, t0.type_tarif AS type_tarif_5, t0.type_facturation AS type_facturation_6, t0.type_livraison AS type_livraison_7, t0.tarif_uht AS tarif_uht_8, t0.structure_id AS structure_id_9, t0.type_id AS type_id_10 FROM diffusion t0 WHERE t0.id = 2457;

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 = 5180;

SELECT
  t0.id AS id_1,
  t0.id_contrat AS id_contrat_2,
  t0.num_debut AS num_debut_3,
  t0.num_fin AS num_fin_4,
  t0.type_tarif AS type_tarif_5,
  t0.type_facturation AS type_facturation_6,
  t0.type_livraison AS type_livraison_7,
  t0.tarif_uht AS tarif_uht_8,
  t0.structure_id AS structure_id_9,
  t0.type_id AS type_id_10
FROM
  diffusion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_contrat AS id_contrat_2, t0.num_debut AS num_debut_3, t0.num_fin AS num_fin_4, t0.type_tarif AS type_tarif_5, t0.type_facturation AS type_facturation_6, t0.type_livraison AS type_livraison_7, t0.tarif_uht AS tarif_uht_8, t0.structure_id AS structure_id_9, t0.type_id AS type_id_10 FROM diffusion t0 WHERE t0.id = 2459;

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 = 86;

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

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 = 86 ORDER BY t0.principale DESC;

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.id_contrat AS id_contrat_2,
  t0.num_debut AS num_debut_3,
  t0.num_fin AS num_fin_4,
  t0.type_tarif AS type_tarif_5,
  t0.type_facturation AS type_facturation_6,
  t0.type_livraison AS type_livraison_7,
  t0.tarif_uht AS tarif_uht_8,
  t0.structure_id AS structure_id_9,
  t0.type_id AS type_id_10
FROM
  diffusion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_contrat AS id_contrat_2, t0.num_debut AS num_debut_3, t0.num_fin AS num_fin_4, t0.type_tarif AS type_tarif_5, t0.type_facturation AS type_facturation_6, t0.type_livraison AS type_livraison_7, t0.tarif_uht AS tarif_uht_8, t0.structure_id AS structure_id_9, t0.type_id AS type_id_10 FROM diffusion t0 WHERE t0.id = 2460;

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 = ?