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
  t.id,
  t.slug,
  t.color,
  t.background,
  COALESCE(tt.titre, ttfr.titre, '') AS titre
FROM projettype t
LEFT JOIN projettype_translation tt   ON tt.id = t.id AND tt.lang = ?
LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id AND ttfr.lang = 'fr'
WHERE t.is_publier = 1
ORDER BY t.position ASC, t.id ASC

[
  "fr"
]

SELECT
  t.id,
  t.slug,
  t.color,
  t.background,
  COALESCE(tt.titre, ttfr.titre, '') AS titre
FROM
  projettype t
  LEFT JOIN projettype_translation tt ON tt.id = t.id
  AND tt.lang = ?
  LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id
  AND ttfr.lang = 'fr'
WHERE
  t.is_publier = 1
ORDER BY
  t.position ASC,
  t.id ASC

SELECT
  t.id,
  t.slug,
  t.color,
  t.background,
  COALESCE(tt.titre, ttfr.titre, '') AS titre
FROM projettype t
LEFT JOIN projettype_translation tt   ON tt.id = t.id AND tt.lang = 'fr'
LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id AND ttfr.lang = 'fr'
WHERE t.is_publier = 1
ORDER BY t.position ASC, t.id ASC;

SELECT
  p.id,
  p.slug,
  p.image2,
  COALESCE(p.champ11, 0) AS champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  t.slug AS type_slug,
  t.color AS type_color,
  t.background AS type_background,
  COALESCE(tt.titre, ttfr.titre, '') AS type_titre
FROM projet p
INNER JOIN projettype t ON t.id = p.type_id
LEFT JOIN projet_translation pt   ON pt.id = p.id AND pt.lang = ?
LEFT JOIN projet_translation ptfr ON ptfr.id = p.id AND ptfr.lang = 'fr'
LEFT JOIN projettype_translation tt   ON tt.id = t.id AND tt.lang = ?
LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id AND ttfr.lang = 'fr'
WHERE p.is_publier = 1
  AND t.is_publier = 1 AND t.slug = ?  ORDER BY p.position ASC, p.id ASC

[
  "fr"
  "fr"
  "culture-loisirs-et-sports"
]

SELECT
  p.id,
  p.slug,
  p.image2,
  COALESCE(p.champ11, 0) AS champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  t.slug AS type_slug,
  t.color AS type_color,
  t.background AS type_background,
  COALESCE(tt.titre, ttfr.titre, '') AS type_titre
FROM
  projet p
  INNER JOIN projettype t ON t.id = p.type_id
  LEFT JOIN projet_translation pt ON pt.id = p.id
  AND pt.lang = ?
  LEFT JOIN projet_translation ptfr ON ptfr.id = p.id
  AND ptfr.lang = 'fr'
  LEFT JOIN projettype_translation tt ON tt.id = t.id
  AND tt.lang = ?
  LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id
  AND ttfr.lang = 'fr'
WHERE
  p.is_publier = 1
  AND t.is_publier = 1
  AND t.slug = ?
ORDER BY
  p.position ASC,
  p.id ASC

SELECT
  p.id,
  p.slug,
  p.image2,
  COALESCE(p.champ11, 0) AS champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  t.slug AS type_slug,
  t.color AS type_color,
  t.background AS type_background,
  COALESCE(tt.titre, ttfr.titre, '') AS type_titre
FROM projet p
INNER JOIN projettype t ON t.id = p.type_id
LEFT JOIN projet_translation pt   ON pt.id = p.id AND pt.lang = 'fr'
LEFT JOIN projet_translation ptfr ON ptfr.id = p.id AND ptfr.lang = 'fr'
LEFT JOIN projettype_translation tt   ON tt.id = t.id AND tt.lang = 'fr'
LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id AND ttfr.lang = 'fr'
WHERE p.is_publier = 1
  AND t.is_publier = 1 AND t.slug = 'culture-loisirs-et-sports'  ORDER BY p.position ASC, p.id ASC ;