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 presse p WHERE p.is_publier = 1

[]

SELECT
  COUNT(*)
FROM
  presse p
WHERE
  p.is_publier = 1

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

[
  "en"
  12
  0
]

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

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
ORDER BY p.created_at DESC
LIMIT 12 OFFSET 0;