Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation 2
• 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"
  "presentation"
]

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 = 'presentation'
LIMIT 1;

SELECT
  p.id,
  p.slug,
  COALESCE(pt.titre, ptfr.titre, '') AS titre
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.catpage_id = ?
ORDER BY p.position ASC, p.id ASC

[
  "en"
  1
]

SELECT
  p.id,
  p.slug,
  COALESCE(pt.titre, ptfr.titre, '') AS titre
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.catpage_id = ?
ORDER BY
  p.position ASC,
  p.id ASC

SELECT
  p.id,
  p.slug,
  COALESCE(pt.titre, ptfr.titre, '') AS titre
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.catpage_id = 1
ORDER BY p.position ASC, p.id ASC;