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.fichier,
  p.created_at,
  p.updated_at,
  COALESCE(NULLIF(t.titre,''), tfr.titre)     AS titre,
  COALESCE(NULLIF(t.preview,''), tfr.preview) AS preview,
  COALESCE(NULLIF(t.contenu,''), tfr.contenu) AS contenu
FROM presse p
LEFT JOIN presse_translation t
  ON t.id = p.id AND t.lang = ?
LEFT JOIN presse_translation tfr
  ON tfr.id = p.id AND tfr.lang = 'fr'
WHERE p.is_publier = 1
  AND (
    p.slug = ?
    OR (? IS NOT NULL AND p.id = ?)
  )
LIMIT 1

[
  "en"
  "220"
  220
  220
]

SELECT
  p.id,
  p.slug,
  p.fichier,
  p.created_at,
  p.updated_at,
  COALESCE(
    NULLIF(t.titre, ''),
    tfr.titre
  ) AS titre,
  COALESCE(
    NULLIF(t.preview, ''),
    tfr.preview
  ) AS preview,
  COALESCE(
    NULLIF(t.contenu, ''),
    tfr.contenu
  ) AS contenu
FROM
  presse p
  LEFT JOIN presse_translation t ON t.id = p.id
  AND t.lang = ?
  LEFT JOIN presse_translation tfr ON tfr.id = p.id
  AND tfr.lang = 'fr'
WHERE
  p.is_publier = 1
  AND (
    p.slug = ?
    OR (
      ? IS NOT NULL
      AND p.id = ?
    )
  )
LIMIT
  1

SELECT
  p.id,
  p.slug,
  p.fichier,
  p.created_at,
  p.updated_at,
  COALESCE(NULLIF(t.titre,''), tfr.titre)     AS titre,
  COALESCE(NULLIF(t.preview,''), tfr.preview) AS preview,
  COALESCE(NULLIF(t.contenu,''), tfr.contenu) AS contenu
FROM presse p
LEFT JOIN presse_translation t
  ON t.id = p.id AND t.lang = 'en'
LEFT JOIN presse_translation tfr
  ON tfr.id = p.id AND tfr.lang = 'fr'
WHERE p.is_publier = 1
  AND (
    p.slug = '220'
    OR (220 IS NOT NULL AND p.id = 220)
  )
LIMIT 1;