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
  a.id,
  a.slug,
  a.image,
  a.created_at,
  a.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 actualite a
LEFT JOIN actualite_translation t
  ON t.id = a.id AND t.lang = ?
LEFT JOIN actualite_translation tfr
  ON tfr.id = a.id AND tfr.lang = 'fr'
WHERE a.is_publier = 1
  AND (
    a.slug = ?
    OR (? IS NOT NULL AND a.id = ?)
  )
LIMIT 1

[
  "fr"
  "super-collecteur-ouest-sa-majeste-le-roi-mohammed-vi-donne-le-coup-d-envoi"
  null
  null
]

SELECT
  a.id,
  a.slug,
  a.image,
  a.created_at,
  a.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
  actualite a
  LEFT JOIN actualite_translation t ON t.id = a.id
  AND t.lang = ?
  LEFT JOIN actualite_translation tfr ON tfr.id = a.id
  AND tfr.lang = 'fr'
WHERE
  a.is_publier = 1
  AND (
    a.slug = ?
    OR (
      ? IS NOT NULL
      AND a.id = ?
    )
  )
LIMIT
  1

SELECT
  a.id,
  a.slug,
  a.image,
  a.created_at,
  a.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 actualite a
LEFT JOIN actualite_translation t
  ON t.id = a.id AND t.lang = 'fr'
LEFT JOIN actualite_translation tfr
  ON tfr.id = a.id AND tfr.lang = 'fr'
WHERE a.is_publier = 1
  AND (
    a.slug = 'super-collecteur-ouest-sa-majeste-le-roi-mohammed-vi-donne-le-coup-d-envoi'
    OR (NULL IS NOT NULL AND a.id = NULL)
  )
LIMIT 1;