Symfony Profiler

SELECT
  COUNT(*) as doublon
FROM
  campagneprospect cp
  LEFT JOIN prospect p ON p.id = cp.prospect_id
WHERE
  cp.campagne_id = 119
  AND p.societe IN (
    SELECT
      d.societe
    FROM
      prospectdoublon AS d
  )

SELECT COUNT(*) as doublon FROM 
                campagneprospect cp
                LEFT JOIN prospect p ON p.id=cp.prospect_id
                WHERE cp.campagne_id=119 AND p.societe IN (SELECT d.societe FROM prospectdoublon AS d);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.active AS active_6,
  t0.session_active AS session_active_7,
  t0.parametres AS parametres_8,
  t0.erreur AS erreur_9,
  t0.erreurdate AS erreurdate_10,
  t0.groupe_id AS groupe_id_11,
  t0.photo_id AS photo_id_12,
  t0.client_id AS client_id_13
FROM
  utilisateur t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.parametres AS parametres_8, t0.erreur AS erreur_9, t0.erreurdate AS erreurdate_10, t0.groupe_id AS groupe_id_11, t0.photo_id AS photo_id_12, t0.client_id AS client_id_13 FROM utilisateur t0 WHERE t0.email = 'sana@itsales.fr' LIMIT 1;