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 COUNT(*) FROM actualite a WHERE a.is_publier = 1

[]

SELECT
  COUNT(*)
FROM
  actualite a
WHERE
  a.is_publier = 1

SELECT COUNT(*) FROM actualite a WHERE a.is_publier = 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 = ?
LEFT JOIN actualite_translation tfr
  ON tfr.id = a.id AND tfr.lang = 'fr'
WHERE a.is_publier = 1
ORDER BY a.created_at DESC
LIMIT ? OFFSET ?

[
  "en"
  9
  0
]

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
ORDER BY
  a.created_at DESC
LIMIT
  ?
OFFSET
  ?

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 = 'en'
LEFT JOIN actualite_translation tfr
  ON tfr.id = a.id AND tfr.lang = 'fr'
WHERE a.is_publier = 1
ORDER BY a.created_at DESC
LIMIT 9 OFFSET 0;