Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• EasyAdmin
• Configuration

Query Metrics

SELECT a0_.id_actualite AS id_actualite_0, a0_.titre AS titre_1, a0_.date_publication AS date_publication_2, a0_.photo_1 AS photo_1_3, a0_.contenu AS contenu_4, a0_.page_accueil AS page_accueil_5, a0_.visible AS visible_6, a0_.id_ville AS id_ville_7, a0_.id_dechetterie AS id_dechetterie_8, a0_.id_tc_flux AS id_tc_flux_9 FROM actualite a0_ LEFT JOIN gpso_flux_ou_prestation g1_ ON a0_.id_tc_flux = g1_.id_gpso_flux_ou_prestation LEFT JOIN tc_structure t2_ ON g1_.structure = t2_.id_tc_structure WHERE a0_.visible = ? AND a0_.date_publication <= CURRENT_TIMESTAMP AND ((g1_.id_gpso_flux_ou_prestation IS NULL) OR (t2_.id_tc_structure = ?)) AND ((a0_.id_ville IS NULL OR a0_.id_ville IN (?, ?, ?)) AND (a0_.id_dechetterie IS NULL OR a0_.id_dechetterie IN (?, ?, ?))) ORDER BY a0_.date_publication DESC

[
  1
  102
  ""
  ",,"
  "0"
  ""
  ",,"
  "0"
]

SELECT
  a0_.id_actualite AS id_actualite_0,
  a0_.titre AS titre_1,
  a0_.date_publication AS date_publication_2,
  a0_.photo_1 AS photo_1_3,
  a0_.contenu AS contenu_4,
  a0_.page_accueil AS page_accueil_5,
  a0_.visible AS visible_6,
  a0_.id_ville AS id_ville_7,
  a0_.id_dechetterie AS id_dechetterie_8,
  a0_.id_tc_flux AS id_tc_flux_9
FROM
  actualite a0_
  LEFT JOIN gpso_flux_ou_prestation g1_ ON a0_.id_tc_flux = g1_.id_gpso_flux_ou_prestation
  LEFT JOIN tc_structure t2_ ON g1_.structure = t2_.id_tc_structure
WHERE
  a0_.visible = ?
  AND a0_.date_publication <= CURRENT_TIMESTAMP
  AND (
    (
      g1_.id_gpso_flux_ou_prestation IS NULL
    )
    OR (t2_.id_tc_structure = ?)
  )
  AND (
    (
      a0_.id_ville IS NULL
      OR a0_.id_ville IN (?, ?, ?)
    )
    AND (
      a0_.id_dechetterie IS NULL
      OR a0_.id_dechetterie IN (?, ?, ?)
    )
  )
ORDER BY
  a0_.date_publication DESC

SELECT a0_.id_actualite AS id_actualite_0, a0_.titre AS titre_1, a0_.date_publication AS date_publication_2, a0_.photo_1 AS photo_1_3, a0_.contenu AS contenu_4, a0_.page_accueil AS page_accueil_5, a0_.visible AS visible_6, a0_.id_ville AS id_ville_7, a0_.id_dechetterie AS id_dechetterie_8, a0_.id_tc_flux AS id_tc_flux_9 FROM actualite a0_ LEFT JOIN gpso_flux_ou_prestation g1_ ON a0_.id_tc_flux = g1_.id_gpso_flux_ou_prestation LEFT JOIN tc_structure t2_ ON g1_.structure = t2_.id_tc_structure WHERE a0_.visible = 1 AND a0_.date_publication <= CURRENT_TIMESTAMP AND ((g1_.id_gpso_flux_ou_prestation IS NULL) OR (t2_.id_tc_structure = 102)) AND ((a0_.id_ville IS NULL OR a0_.id_ville IN ('', ',,', '0')) AND (a0_.id_dechetterie IS NULL OR a0_.id_dechetterie IN ('', ',,', '0'))) ORDER BY a0_.date_publication DESC;

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.libelle AS libelle_1 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = ?

[
  102
]

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.libelle AS libelle_1
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.libelle AS libelle_1 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102;