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 appeloffre a WHERE a.publier = 1

[]

SELECT
  COUNT(*)
FROM
  appeloffre a
WHERE
  a.publier = 1

SELECT COUNT(*) FROM appeloffre a WHERE a.publier = 1;

SELECT
  a.id,
  a.slug,
  a.numoffre,
  a.file,
  a.dateprevue,
  a.datevisit,
  a.estimation,
  a.cautionnement,
  a.fraidossie,
  a.champ2,
  a.champ6,
  a.champ7,
  a.created_at,
  a.updated_at,
  COALESCE(NULLIF(t.objet,''), tfr.objet) AS objet
FROM appeloffre a
LEFT JOIN appeloffre_translation t
  ON t.id = a.id AND t.lang = ?
LEFT JOIN appeloffre_translation tfr
  ON tfr.id = a.id AND tfr.lang = 'fr'
WHERE a.publier = 1
ORDER BY a.created_at DESC
LIMIT ? OFFSET ?

[
  "fr"
  10
  10
]

SELECT
  a.id,
  a.slug,
  a.numoffre,
  a.file,
  a.dateprevue,
  a.datevisit,
  a.estimation,
  a.cautionnement,
  a.fraidossie,
  a.champ2,
  a.champ6,
  a.champ7,
  a.created_at,
  a.updated_at,
  COALESCE(
    NULLIF(t.objet, ''),
    tfr.objet
  ) AS objet
FROM
  appeloffre a
  LEFT JOIN appeloffre_translation t ON t.id = a.id
  AND t.lang = ?
  LEFT JOIN appeloffre_translation tfr ON tfr.id = a.id
  AND tfr.lang = 'fr'
WHERE
  a.publier = 1
ORDER BY
  a.created_at DESC
LIMIT
  ?
OFFSET
  ?

SELECT
  a.id,
  a.slug,
  a.numoffre,
  a.file,
  a.dateprevue,
  a.datevisit,
  a.estimation,
  a.cautionnement,
  a.fraidossie,
  a.champ2,
  a.champ6,
  a.champ7,
  a.created_at,
  a.updated_at,
  COALESCE(NULLIF(t.objet,''), tfr.objet) AS objet
FROM appeloffre a
LEFT JOIN appeloffre_translation t
  ON t.id = a.id AND t.lang = 'fr'
LEFT JOIN appeloffre_translation tfr
  ON tfr.id = a.id AND tfr.lang = 'fr'
WHERE a.publier = 1
ORDER BY a.created_at DESC
LIMIT 10 OFFSET 10;