Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 435
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Configuration

Query Metrics

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

[
  "list-dossiers"
]

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

[
  "2026-06-02 18:18:01"
]

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 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'

[
  100
]

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

[
  100
]

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

[
  100
  18249
  18236
  18120
  18110
  18109
  18104
]

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