Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine 1
• Emails
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.color AS color_2, t0.background AS background_3, t0.position AS position_4, t0.is_publier AS is_publier_5, t0.slug AS slug_6, t0.image AS image_7 FROM projettype t0 WHERE t0.is_publier = ? ORDER BY t0.position ASC

[
  true
]

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.background AS background_3,
  t0.position AS position_4,
  t0.is_publier AS is_publier_5,
  t0.slug AS slug_6,
  t0.image AS image_7
FROM
  projettype t0
WHERE
  t0.is_publier = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.color AS color_2, t0.background AS background_3, t0.position AS position_4, t0.is_publier AS is_publier_5, t0.slug AS slug_6, t0.image AS image_7 FROM projettype t0 WHERE t0.is_publier = 1 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = ?

[
  "1"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.titre AS titre_3,
  t0.id AS id_4
FROM
  projettype_translation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = '1';

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = ?

[
  "3"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.titre AS titre_3,
  t0.id AS id_4
FROM
  projettype_translation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = '3';

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.titre AS titre_3,
  t0.id AS id_4
FROM
  projettype_translation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = '2';

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = ?

[
  "4"
]

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.titre AS titre_3,
  t0.id AS id_4
FROM
  projettype_translation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.titre AS titre_3, t0.id AS id_4 FROM projettype_translation t0 WHERE t0.id = '4';

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 ?

[
  "en"
  6
  0
]

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 = 'en'
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 6 OFFSET 0;

SELECT
  ph.picpath,
  g.slug AS gallery_slug,
  p.slug AS project_slug,
  COALESCE(pt.titre, ptfr.titre, '') AS project_title
FROM photos ph
INNER JOIN gallery g ON g.id = ph.gallery_id
INNER JOIN projet p ON p.id = g.projet_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'
WHERE COALESCE(g.is_active, 0) = 1
  AND COALESCE(p.is_publier, 0) = 1
ORDER BY ph.updated_at DESC, ph.id DESC
LIMIT ?

[
  "en"
  10
]

SELECT
  ph.picpath,
  g.slug AS gallery_slug,
  p.slug AS project_slug,
  COALESCE(pt.titre, ptfr.titre, '') AS project_title
FROM
  photos ph
  INNER JOIN gallery g ON g.id = ph.gallery_id
  INNER JOIN projet p ON p.id = g.projet_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'
WHERE
  COALESCE(g.is_active, 0) = 1
  AND COALESCE(p.is_publier, 0) = 1
ORDER BY
  ph.updated_at DESC,
  ph.id DESC
LIMIT
  ?

SELECT
  ph.picpath,
  g.slug AS gallery_slug,
  p.slug AS project_slug,
  COALESCE(pt.titre, ptfr.titre, '') AS project_title
FROM photos ph
INNER JOIN gallery g ON g.id = ph.gallery_id
INNER JOIN projet p ON p.id = g.projet_id
LEFT JOIN projet_translation pt   ON pt.id = p.id AND pt.lang = 'en'
LEFT JOIN projet_translation ptfr ON ptfr.id = p.id AND ptfr.lang = 'fr'
WHERE COALESCE(g.is_active, 0) = 1
  AND COALESCE(p.is_publier, 0) = 1
ORDER BY ph.updated_at DESC, ph.id DESC
LIMIT 10;