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

[
  "fr"
  "fr"
  "amenagement-de-la-voirie-a-l-interieur-de-la-ville-de-mohammedia"
]

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 = '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 p.slug = 'amenagement-de-la-voirie-a-l-interieur-de-la-ville-de-mohammedia'
LIMIT 1;

-- SELECT url, COALESCE(position, 0) AS position, COALESCE(title, '') AS title
SELECT url, COALESCE(position, 0) AS position
FROM vedio
WHERE projet_id = ?
  AND COALESCE(is_publier, 0) = 1
  AND url IS NOT NULL AND url <> ''
ORDER BY COALESCE(position, 999999) ASC, id ASC

[
  56
]

-- SELECT url, COALESCE(position, 0) AS position, COALESCE(title, '') AS title
SELECT
  url,
  COALESCE(position, 0) AS position
FROM
  vedio
WHERE
  projet_id = ?
  AND COALESCE(is_publier, 0) = 1
  AND url IS NOT NULL
  AND url <> ''
ORDER BY
  COALESCE(position, 999999) ASC,
  id ASC

-- SELECT url, COALESCE(position, 0) AS position, COALESCE(title, '') AS title
SELECT url, COALESCE(position, 0) AS position
FROM vedio
WHERE projet_id = 56
  AND COALESCE(is_publier, 0) = 1
  AND url IS NOT NULL AND url <> ''
ORDER BY COALESCE(position, 999999) ASC, id ASC;