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.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
  INNER JOIN chronique_livre ON t0.id = chronique_livre.livre_id
WHERE
  chronique_livre.chronique_id = ?

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 INNER JOIN chronique_livre ON t0.id = chronique_livre.livre_id WHERE chronique_livre.chronique_id = 18249;

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
  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.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
  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.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 = 16 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;

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;