Symfony Profiler

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.old_id AS old_id_2,
  t0.roles AS roles_3,
  t0.email AS email_4,
  t0.username AS username_5,
  t0.last_login AS last_login_6,
  t0.confirmation_token AS confirmation_token_7,
  t0.password_requested_at AS password_requested_at_8,
  t0.password AS password_9,
  t0.enabled AS enabled_10,
  t0.date_creation AS date_creation_11,
  t0.token_api AS token_api_12,
  t13.id AS id_14,
  t13.nom AS nom_15,
  t13.prenom AS prenom_16,
  t13.telephone AS telephone_17,
  t13.code_abomarque AS code_abomarque_18,
  t13.commentaire AS commentaire_19,
  t13.facebook AS facebook_20,
  t13.twitter AS twitter_21,
  t13.email AS email_22,
  t13.old_id AS old_id_23,
  t13.civilite AS civilite_24,
  t13.old_userid AS old_userid_25,
  t13.actif AS actif_26,
  t13.bio AS bio_27,
  t13.has_photo AS has_photo_28,
  t13.is_referent AS is_referent_29,
  t13.date_creation AS date_creation_30,
  t13.receive_nmardi AS receive_nmardi_31,
  t13.receive_nvendredi AS receive_nvendredi_32,
  t13.receive_ireseau AS receive_ireseau_33,
  t13.structure_id AS structure_id_34,
  t13.adresse_id AS adresse_id_35,
  t13.utilisateur_id AS utilisateur_id_36,
  t13.news_contact_id AS news_contact_id_37,
  t0.client_id AS client_id_38
FROM
  user t0
  LEFT JOIN contact t13 ON t13.utilisateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.roles AS roles_3, t0.email AS email_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.password AS password_9, t0.enabled AS enabled_10, t0.date_creation AS date_creation_11, t0.token_api AS token_api_12, t13.id AS id_14, t13.nom AS nom_15, t13.prenom AS prenom_16, t13.telephone AS telephone_17, t13.code_abomarque AS code_abomarque_18, t13.commentaire AS commentaire_19, t13.facebook AS facebook_20, t13.twitter AS twitter_21, t13.email AS email_22, t13.old_id AS old_id_23, t13.civilite AS civilite_24, t13.old_userid AS old_userid_25, t13.actif AS actif_26, t13.bio AS bio_27, t13.has_photo AS has_photo_28, t13.is_referent AS is_referent_29, t13.date_creation AS date_creation_30, t13.receive_nmardi AS receive_nmardi_31, t13.receive_nvendredi AS receive_nvendredi_32, t13.receive_ireseau AS receive_ireseau_33, t13.structure_id AS structure_id_34, t13.adresse_id AS adresse_id_35, t13.utilisateur_id AS utilisateur_id_36, t13.news_contact_id AS news_contact_id_37, t0.client_id AS client_id_38 FROM user t0 LEFT JOIN contact t13 ON t13.utilisateur_id = t0.id WHERE t0.id = 7819;

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

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 = 'home' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3
FROM
  type_espace_pro t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM type_espace_pro t0 WHERE t0.id = 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 = ?
  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.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.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;