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
  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_.date_publication ASC
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:01' ORDER BY r0_.date_publication ASC 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 = ?
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 = 'list-dossiers' LIMIT 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
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.infois_ok AS infois_ok_2,
  c0_.visuel_ok AS visuel_ok_3,
  c0_.recos_ok AS recos_ok_4,
  c0_.textes_ok AS textes_ok_5,
  c0_.date_creation AS date_creation_6,
  c0_.update_at AS update_at_7,
  c0_.signature AS signature_8,
  c0_.old_id AS old_id_9,
  c0_.reco_selectionne AS reco_selectionne_10,
  c0_.type AS type_11,
  c0_.exergue AS exergue_12,
  c1_.id AS id_13,
  c1_.titre AS titre_14,
  c1_.chapeau AS chapeau_15,
  c1_.contenu AS contenu_16,
  c1_.is_valide AS is_valide_17,
  c0_.texte_original_id AS texte_original_id_18,
  c0_.texte_relu_id AS texte_relu_id_19,
  c0_.texte_final_id AS texte_final_id_20,
  c0_.revue_id AS revue_id_21,
  c0_.auteur_id AS auteur_id_22,
  c0_.contact_id AS contact_id_23,
  c0_.genre_id AS genre_id_24
FROM
  chronique c0_
  LEFT JOIN chronique_texte c1_ ON c0_.texte_final_id = c1_.id
  LEFT JOIN revue r2_ ON c0_.revue_id = r2_.id
WHERE
  r2_.id < ?
  AND c1_.is_valide = 1
  AND c0_.type = 'Dossier'
  AND c0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  c0_.date_creation DESC,
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.infois_ok AS infois_ok_2, c0_.visuel_ok AS visuel_ok_3, c0_.recos_ok AS recos_ok_4, c0_.textes_ok AS textes_ok_5, c0_.date_creation AS date_creation_6, c0_.update_at AS update_at_7, c0_.signature AS signature_8, c0_.old_id AS old_id_9, c0_.reco_selectionne AS reco_selectionne_10, c0_.type AS type_11, c0_.exergue AS exergue_12, c1_.id AS id_13, c1_.titre AS titre_14, c1_.chapeau AS chapeau_15, c1_.contenu AS contenu_16, c1_.is_valide AS is_valide_17, c0_.texte_original_id AS texte_original_id_18, c0_.texte_relu_id AS texte_relu_id_19, c0_.texte_final_id AS texte_final_id_20, c0_.revue_id AS revue_id_21, c0_.auteur_id AS auteur_id_22, c0_.contact_id AS contact_id_23, c0_.genre_id AS genre_id_24 FROM chronique c0_ LEFT JOIN chronique_texte c1_ ON c0_.texte_final_id = c1_.id LEFT JOIN revue r2_ ON c0_.revue_id = r2_.id WHERE r2_.id < 100 AND c1_.is_valide = 1 AND c0_.type = 'Dossier' AND c0_.id IN (18249, 18236, 18120, 18110, 18109, 18104) ORDER BY c0_.date_creation DESC, c0_.id DESC;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  chronique c0_
  LEFT JOIN chronique_texte c1_ ON c0_.texte_final_id = c1_.id
  LEFT JOIN revue r2_ ON c0_.revue_id = r2_.id
WHERE
  r2_.id < ?
  AND c1_.is_valide = 1
  AND c0_.type = 'Dossier'

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM chronique c0_ LEFT JOIN chronique_texte c1_ ON c0_.texte_final_id = c1_.id LEFT JOIN revue r2_ ON c0_.revue_id = r2_.id WHERE r2_.id < 100 AND c1_.is_valide = 1 AND c0_.type = 'Dossier';

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
  DISTINCT c0_.id AS id_0,
  c0_.date_creation AS date_creation_1,
  c0_.id AS id_2
FROM
  chronique c0_
  LEFT JOIN chronique_texte c1_ ON c0_.texte_final_id = c1_.id
  LEFT JOIN revue r2_ ON c0_.revue_id = r2_.id
WHERE
  r2_.id < ?
  AND c1_.is_valide = 1
  AND c0_.type = 'Dossier'
ORDER BY
  c0_.date_creation DESC,
  c0_.id DESC
LIMIT
  6

SELECT DISTINCT c0_.id AS id_0, c0_.date_creation AS date_creation_1, c0_.id AS id_2 FROM chronique c0_ LEFT JOIN chronique_texte c1_ ON c0_.texte_final_id = c1_.id LEFT JOIN revue r2_ ON c0_.revue_id = r2_.id WHERE r2_.id < 100 AND c1_.is_valide = 1 AND c0_.type = 'Dossier' ORDER BY c0_.date_creation DESC, c0_.id DESC LIMIT 6;