Symfony Profiler

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  etablissement e0_

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM etablissement e0_;

SELECT
  COUNT(DISTINCT m0_.id) AS sclr_0
FROM
  metier m0_
  LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id
  LEFT JOIN etablissement_metier e2_ ON m0_.id = e2_.metier_id
  LEFT JOIN etablissement e3_ ON e2_.etablissement_id = e3_.id

SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM metier m0_ LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id LEFT JOIN etablissement_metier e2_ ON m0_.id = e2_.metier_id LEFT JOIN etablissement e3_ ON e2_.etablissement_id = e3_.id;

SELECT
  COUNT(*)
FROM
  candidature t0

SELECT COUNT(*) FROM candidature t0;

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,
  l1_.id AS id_5,
  l1_.nom AS nom_6,
  l1_.type AS type_7,
  l1_.creation AS creation_8,
  l1_.modification AS modification_9,
  d2_.id AS id_10,
  d2_.nom AS nom_11,
  d2_.chef_lieu AS chef_lieu_12,
  d2_.creation AS creation_13,
  d2_.modification AS modification_14,
  e3_.id AS id_15,
  e3_.nbrplace AS nbrplace_16,
  e3_.niveau_requis AS niveau_requis_17,
  e3_.duree_formation AS duree_formation_18,
  m4_.id AS id_19,
  m4_.nom AS nom_20,
  m4_.creation AS creation_21,
  m4_.modification AS modification_22,
  e0_.localite_id AS localite_id_23,
  e0_.direction_regionale_id AS direction_regionale_id_24,
  e0_.user_id AS user_id_25,
  l1_.parent_id AS parent_id_26,
  l1_.direction_regionale_id AS direction_regionale_id_27,
  l1_.user_id AS user_id_28,
  d2_.user_id AS user_id_29,
  e3_.etablissement_id AS etablissement_id_30,
  e3_.metier_id AS metier_id_31,
  m4_.secteur_id AS secteur_id_32,
  m4_.user_id AS user_id_33
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
  LEFT JOIN etablissement_metier e3_ ON e0_.id = e3_.etablissement_id
  LEFT JOIN metier m4_ ON e3_.metier_id = m4_.id
WHERE
  e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
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, l1_.id AS id_5, l1_.nom AS nom_6, l1_.type AS type_7, l1_.creation AS creation_8, l1_.modification AS modification_9, d2_.id AS id_10, d2_.nom AS nom_11, d2_.chef_lieu AS chef_lieu_12, d2_.creation AS creation_13, d2_.modification AS modification_14, e3_.id AS id_15, e3_.nbrplace AS nbrplace_16, e3_.niveau_requis AS niveau_requis_17, e3_.duree_formation AS duree_formation_18, m4_.id AS id_19, m4_.nom AS nom_20, m4_.creation AS creation_21, m4_.modification AS modification_22, e0_.localite_id AS localite_id_23, e0_.direction_regionale_id AS direction_regionale_id_24, e0_.user_id AS user_id_25, l1_.parent_id AS parent_id_26, l1_.direction_regionale_id AS direction_regionale_id_27, l1_.user_id AS user_id_28, d2_.user_id AS user_id_29, e3_.etablissement_id AS etablissement_id_30, e3_.metier_id AS metier_id_31, m4_.secteur_id AS secteur_id_32, m4_.user_id AS user_id_33 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 LEFT JOIN etablissement_metier e3_ ON e0_.id = e3_.etablissement_id LEFT JOIN metier m4_ ON e3_.metier_id = m4_.id WHERE e0_.id IN (12, 13, 3, 7, 102, 100, 9, 104, 10) 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,
  s1_.id AS id_4,
  s1_.nom AS nom_5,
  s1_.creation AS creation_6,
  s1_.modification AS modification_7,
  e2_.id AS id_8,
  e2_.nbrplace AS nbrplace_9,
  e2_.niveau_requis AS niveau_requis_10,
  e2_.duree_formation AS duree_formation_11,
  e3_.id AS id_12,
  e3_.nom AS nom_13,
  e3_.definition AS definition_14,
  e3_.creation AS creation_15,
  e3_.modification AS modification_16,
  m0_.secteur_id AS secteur_id_17,
  m0_.user_id AS user_id_18,
  s1_.user_id AS user_id_19,
  e2_.etablissement_id AS etablissement_id_20,
  e2_.metier_id AS metier_id_21,
  e3_.localite_id AS localite_id_22,
  e3_.direction_regionale_id AS direction_regionale_id_23,
  e3_.user_id AS user_id_24
FROM
  metier m0_
  LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id
  LEFT JOIN etablissement_metier e2_ ON m0_.id = e2_.metier_id
  LEFT JOIN etablissement e3_ ON e2_.etablissement_id = e3_.id
ORDER BY
  m0_.nom ASC
LIMIT
  9

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.creation AS creation_2, m0_.modification AS modification_3, s1_.id AS id_4, s1_.nom AS nom_5, s1_.creation AS creation_6, s1_.modification AS modification_7, e2_.id AS id_8, e2_.nbrplace AS nbrplace_9, e2_.niveau_requis AS niveau_requis_10, e2_.duree_formation AS duree_formation_11, e3_.id AS id_12, e3_.nom AS nom_13, e3_.definition AS definition_14, e3_.creation AS creation_15, e3_.modification AS modification_16, m0_.secteur_id AS secteur_id_17, m0_.user_id AS user_id_18, s1_.user_id AS user_id_19, e2_.etablissement_id AS etablissement_id_20, e2_.metier_id AS metier_id_21, e3_.localite_id AS localite_id_22, e3_.direction_regionale_id AS direction_regionale_id_23, e3_.user_id AS user_id_24 FROM metier m0_ LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id LEFT JOIN etablissement_metier e2_ ON m0_.id = e2_.metier_id LEFT JOIN etablissement e3_ ON e2_.etablissement_id = e3_.id ORDER BY m0_.nom ASC LIMIT 9;

SELECT
  e0_.id AS id_0
FROM
  etablissement e0_
ORDER BY
  e0_.nom ASC
LIMIT
  9

SELECT e0_.id AS id_0 FROM etablissement e0_ ORDER BY e0_.nom ASC LIMIT 9;

SELECT
  SUM(nbrplace) as total
FROM
  etablissement_metier

SELECT SUM(nbrplace) as total FROM etablissement_metier;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.chef_lieu AS chef_lieu_3,
  t0.creation AS creation_4,
  t0.modification AS modification_5,
  t0.user_id AS user_id_6
FROM
  direction_regionale t0
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chef_lieu AS chef_lieu_3, t0.creation AS creation_4, t0.modification AS modification_5, t0.user_id AS user_id_6 FROM direction_regionale t0 ORDER BY t0.nom ASC;

SELECT
  COUNT(*)
FROM
  secteur t0

SELECT COUNT(*) FROM secteur t0;

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
ORDER BY
  t0.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 ORDER BY t0.nom ASC;

SELECT
  COUNT(*)
FROM
  etablissement t0

SELECT COUNT(*) FROM etablissement t0;

SELECT
  COUNT(*)
FROM
  metier t0

SELECT COUNT(*) FROM metier t0;