Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 10
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• HTTP Client
• Doctrine 1
• Migrations
• Debug
• Messages
• E-mails
• Notifications
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.definition AS definition_3, t0.creation AS creation_4, t0.modification AS modification_5, t0.localite_id AS localite_id_6, t0.direction_regionale_id AS direction_regionale_id_7, t0.user_id AS user_id_8 FROM etablissement t0 WHERE t0.id = ?

[
  "12"
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.definition AS definition_3,
  t0.creation AS creation_4,
  t0.modification AS modification_5,
  t0.localite_id AS localite_id_6,
  t0.direction_regionale_id AS direction_regionale_id_7,
  t0.user_id AS user_id_8
FROM
  etablissement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.definition AS definition_3, t0.creation AS creation_4, t0.modification AS modification_5, t0.localite_id AS localite_id_6, t0.direction_regionale_id AS direction_regionale_id_7, t0.user_id AS user_id_8 FROM etablissement t0 WHERE t0.id = '12';

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.definition AS definition_2, e0_.creation AS creation_3, e0_.modification AS modification_4, e0_.localite_id AS localite_id_5, e0_.direction_regionale_id AS direction_regionale_id_6, e0_.user_id AS user_id_7 FROM etablissement e0_ LEFT JOIN localite l1_ ON e0_.localite_id = l1_.id LEFT JOIN direction_regionale d2_ ON l1_.direction_regionale_id = d2_.id ORDER BY e0_.nom ASC

[]

SELECT
  e0_.id AS id_0,
  e0_.nom AS nom_1,
  e0_.definition AS definition_2,
  e0_.creation AS creation_3,
  e0_.modification AS modification_4,
  e0_.localite_id AS localite_id_5,
  e0_.direction_regionale_id AS direction_regionale_id_6,
  e0_.user_id AS user_id_7
FROM
  etablissement e0_
  LEFT JOIN localite l1_ ON e0_.localite_id = l1_.id
  LEFT JOIN direction_regionale d2_ ON l1_.direction_regionale_id = d2_.id
ORDER BY
  e0_.nom ASC

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.definition AS definition_2, e0_.creation AS creation_3, e0_.modification AS modification_4, e0_.localite_id AS localite_id_5, e0_.direction_regionale_id AS direction_regionale_id_6, e0_.user_id AS user_id_7 FROM etablissement e0_ LEFT JOIN localite l1_ ON e0_.localite_id = l1_.id LEFT JOIN direction_regionale d2_ ON l1_.direction_regionale_id = d2_.id ORDER BY e0_.nom ASC;

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.creation AS creation_2, m0_.modification AS modification_3, m0_.secteur_id AS secteur_id_4, m0_.user_id AS user_id_5 FROM metier m0_ INNER JOIN etablissement_metier e1_ ON m0_.id = e1_.metier_id INNER JOIN secteur s2_ ON m0_.secteur_id = s2_.id WHERE e1_.etablissement_id = ? ORDER BY s2_.nom ASC, m0_.nom ASC

[
  12
]

SELECT
  m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.creation AS creation_2,
  m0_.modification AS modification_3,
  m0_.secteur_id AS secteur_id_4,
  m0_.user_id AS user_id_5
FROM
  metier m0_
  INNER JOIN etablissement_metier e1_ ON m0_.id = e1_.metier_id
  INNER JOIN secteur s2_ ON m0_.secteur_id = s2_.id
WHERE
  e1_.etablissement_id = ?
ORDER BY
  s2_.nom ASC,
  m0_.nom ASC

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.creation AS creation_2, m0_.modification AS modification_3, m0_.secteur_id AS secteur_id_4, m0_.user_id AS user_id_5 FROM metier m0_ INNER JOIN etablissement_metier e1_ ON m0_.id = e1_.metier_id INNER JOIN secteur s2_ ON m0_.secteur_id = s2_.id WHERE e1_.etablissement_id = 12 ORDER BY s2_.nom ASC, m0_.nom ASC;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.creation AS creation_3, t0.modification AS modification_4, t0.user_id AS user_id_5 FROM secteur t0 WHERE t0.id = ?

[
  9
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.creation AS creation_3,
  t0.modification AS modification_4,
  t0.user_id AS user_id_5
FROM
  secteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.creation AS creation_3, t0.modification AS modification_4, t0.user_id AS user_id_5 FROM secteur t0 WHERE t0.id = 9;