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
  p.id,
  p.slug,
  p.image,
  p.image2,
  p.champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu,
  COALESCE(pt.programme, ptfr.programme) AS programme,
  COALESCE(pt.partenaire, ptfr.partenaire) AS partenaire,
  COALESCE(pt.financement, ptfr.financement) AS financement,
  COALESCE(pt.champ7, ptfr.champ7) AS champ7,
  COALESCE(pt.budget, ptfr.budget) AS budget,
  COALESCE(pt.localisation, ptfr.localisation) AS localisation,
  COALESCE(pt.etat, ptfr.etat) AS etat,
  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 p.slug = ?
LIMIT 1

[
  "ar"
  "ar"
  "complexe-sportif-derb-ghalef"
]

SELECT
  p.id,
  p.slug,
  p.image,
  p.image2,
  p.champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu,
  COALESCE(pt.programme, ptfr.programme) AS programme,
  COALESCE(pt.partenaire, ptfr.partenaire) AS partenaire,
  COALESCE(
    pt.financement, ptfr.financement
  ) AS financement,
  COALESCE(pt.champ7, ptfr.champ7) AS champ7,
  COALESCE(pt.budget, ptfr.budget) AS budget,
  COALESCE(
    pt.localisation, ptfr.localisation
  ) AS localisation,
  COALESCE(pt.etat, ptfr.etat) AS etat,
  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 p.slug = ?
LIMIT
  1

SELECT
  p.id,
  p.slug,
  p.image,
  p.image2,
  p.champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu,
  COALESCE(pt.programme, ptfr.programme) AS programme,
  COALESCE(pt.partenaire, ptfr.partenaire) AS partenaire,
  COALESCE(pt.financement, ptfr.financement) AS financement,
  COALESCE(pt.champ7, ptfr.champ7) AS champ7,
  COALESCE(pt.budget, ptfr.budget) AS budget,
  COALESCE(pt.localisation, ptfr.localisation) AS localisation,
  COALESCE(pt.etat, ptfr.etat) AS etat,
  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 = 'ar'
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 = 'ar'
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 p.slug = 'complexe-sportif-derb-ghalef'
LIMIT 1;

SELECT
  g.id AS gallery_id,
  g.title AS gallery_title,
  g.type AS gallery_type,
  g.description AS gallery_description,
  g.slug AS gallery_slug,
  ph.id AS photo_id,
  ph.title AS photo_title,
  ph.picpath,
  ph.is_default,
  ph.order_photo
FROM gallery g
LEFT JOIN photos ph ON ph.gallery_id = g.id
WHERE g.projet_id = ?
  AND COALESCE(g.is_active, 0) = 1
ORDER BY g.id ASC, COALESCE(ph.order_photo, 999999) ASC, ph.id ASC

[
  59
]

SELECT
  g.id AS gallery_id,
  g.title AS gallery_title,
  g.type AS gallery_type,
  g.description AS gallery_description,
  g.slug AS gallery_slug,
  ph.id AS photo_id,
  ph.title AS photo_title,
  ph.picpath,
  ph.is_default,
  ph.order_photo
FROM
  gallery g
  LEFT JOIN photos ph ON ph.gallery_id = g.id
WHERE
  g.projet_id = ?
  AND COALESCE(g.is_active, 0) = 1
ORDER BY
  g.id ASC,
  COALESCE(ph.order_photo, 999999) ASC,
  ph.id ASC

SELECT
  g.id AS gallery_id,
  g.title AS gallery_title,
  g.type AS gallery_type,
  g.description AS gallery_description,
  g.slug AS gallery_slug,
  ph.id AS photo_id,
  ph.title AS photo_title,
  ph.picpath,
  ph.is_default,
  ph.order_photo
FROM gallery g
LEFT JOIN photos ph ON ph.gallery_id = g.id
WHERE g.projet_id = 59
  AND COALESCE(g.is_active, 0) = 1
ORDER BY g.id ASC, COALESCE(ph.order_photo, 999999) ASC, ph.id ASC;