Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine
• Emails
• EasyAdmin
• Configuration

Query Metrics

SELECT
  p.id,
  p.slug,
  p.catpage_id,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu
FROM page p
LEFT JOIN page_translation pt   ON pt.id = p.id AND pt.lang = ?
LEFT JOIN page_translation ptfr ON ptfr.id = p.id AND ptfr.lang = 'fr'
WHERE p.is_publier = 1
  AND p.slug = ?
LIMIT 1

[
  "en"
  "mentions-legales"
]

SELECT
  p.id,
  p.slug,
  p.catpage_id,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu
FROM
  page p
  LEFT JOIN page_translation pt ON pt.id = p.id
  AND pt.lang = ?
  LEFT JOIN page_translation ptfr ON ptfr.id = p.id
  AND ptfr.lang = 'fr'
WHERE
  p.is_publier = 1
  AND p.slug = ?
LIMIT
  1

SELECT
  p.id,
  p.slug,
  p.catpage_id,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu
FROM page p
LEFT JOIN page_translation pt   ON pt.id = p.id AND pt.lang = 'en'
LEFT JOIN page_translation ptfr ON ptfr.id = p.id AND ptfr.lang = 'fr'
WHERE p.is_publier = 1
  AND p.slug = 'mentions-legales'
LIMIT 1;