Symfony Profiler

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.numero_affaire AS numero_affaire_1
FROM
  affaire a0_
  LEFT JOIN client c1_ ON a0_.client_id = c1_.id
  LEFT JOIN categorie_affaire c2_ ON a0_.categorie_id = c2_.id
  LEFT JOIN user u3_ ON a0_.responsable_id = u3_.id
  LEFT JOIN proposition p4_ ON a0_.id = p4_.affaire_id
WHERE
  (
    LOWER(a0_.numero_affaire) LIKE ?
    OR LOWER(a0_.numero_affaire) IN (?)
    OR LOWER(a0_.objet) LIKE ?
    OR LOWER(a0_.objet) IN (?)
    OR LOWER(a0_.site) LIKE ?
    OR LOWER(a0_.site) IN (?)
    OR LOWER(a0_.site_contact) LIKE ?
    OR LOWER(a0_.site_contact) IN (?)
    OR LOWER(c1_.societe) LIKE ?
    OR LOWER(c1_.societe) IN (?)
    OR LOWER(c1_.contact_nom) LIKE ?
    OR LOWER(c1_.contact_nom) IN (?)
    OR LOWER(c1_.contact_prenom) LIKE ?
    OR LOWER(c1_.contact_prenom) IN (?)
    OR LOWER(c2_.libelle_court) LIKE ?
    OR LOWER(c2_.libelle_court) IN (?)
    OR LOWER(c2_.libelle_long) LIKE ?
    OR LOWER(c2_.libelle_long) IN (?)
    OR LOWER(u3_.nom) LIKE ?
    OR LOWER(u3_.nom) IN (?)
    OR LOWER(u3_.prenom) LIKE ?
    OR LOWER(u3_.prenom) IN (?)
    OR LOWER(u3_.trigramme) LIKE ?
    OR LOWER(u3_.trigramme) IN (?)
    OR LOWER(p4_.objet) LIKE ?
    OR LOWER(p4_.objet) IN (?)
    OR LOWER(p4_.avancement) LIKE ?
    OR LOWER(p4_.avancement) IN (?)
  )
  AND (
    a0_.is_deleted = 0
    OR a0_.is_deleted IS NULL
  )
ORDER BY
  a0_.numero_affaire DESC
LIMIT
  30

SELECT DISTINCT a0_.id AS id_0, a0_.numero_affaire AS numero_affaire_1 FROM affaire a0_ LEFT JOIN client c1_ ON a0_.client_id = c1_.id LEFT JOIN categorie_affaire c2_ ON a0_.categorie_id = c2_.id LEFT JOIN user u3_ ON a0_.responsable_id = u3_.id LEFT JOIN proposition p4_ ON a0_.id = p4_.affaire_id WHERE (LOWER(a0_.numero_affaire) LIKE '%chambery%' OR LOWER(a0_.numero_affaire) IN ('chambery') OR LOWER(a0_.objet) LIKE '%chambery%' OR LOWER(a0_.objet) IN ('chambery') OR LOWER(a0_.site) LIKE '%chambery%' OR LOWER(a0_.site) IN ('chambery') OR LOWER(a0_.site_contact) LIKE '%chambery%' OR LOWER(a0_.site_contact) IN ('chambery') OR LOWER(c1_.societe) LIKE '%chambery%' OR LOWER(c1_.societe) IN ('chambery') OR LOWER(c1_.contact_nom) LIKE '%chambery%' OR LOWER(c1_.contact_nom) IN ('chambery') OR LOWER(c1_.contact_prenom) LIKE '%chambery%' OR LOWER(c1_.contact_prenom) IN ('chambery') OR LOWER(c2_.libelle_court) LIKE '%chambery%' OR LOWER(c2_.libelle_court) IN ('chambery') OR LOWER(c2_.libelle_long) LIKE '%chambery%' OR LOWER(c2_.libelle_long) IN ('chambery') OR LOWER(u3_.nom) LIKE '%chambery%' OR LOWER(u3_.nom) IN ('chambery') OR LOWER(u3_.prenom) LIKE '%chambery%' OR LOWER(u3_.prenom) IN ('chambery') OR LOWER(u3_.trigramme) LIKE '%chambery%' OR LOWER(u3_.trigramme) IN ('chambery') OR LOWER(p4_.objet) LIKE '%chambery%' OR LOWER(p4_.objet) IN ('chambery') OR LOWER(p4_.avancement) LIKE '%chambery%' OR LOWER(p4_.avancement) IN ('chambery')) AND (a0_.is_deleted = 0 OR a0_.is_deleted IS NULL) ORDER BY a0_.numero_affaire DESC LIMIT 30;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  affaire a0_
  LEFT JOIN client c1_ ON a0_.client_id = c1_.id
  LEFT JOIN categorie_affaire c2_ ON a0_.categorie_id = c2_.id
  LEFT JOIN user u3_ ON a0_.responsable_id = u3_.id
  LEFT JOIN proposition p4_ ON a0_.id = p4_.affaire_id
WHERE
  (
    LOWER(a0_.numero_affaire) LIKE ?
    OR LOWER(a0_.numero_affaire) IN (?)
    OR LOWER(a0_.objet) LIKE ?
    OR LOWER(a0_.objet) IN (?)
    OR LOWER(a0_.site) LIKE ?
    OR LOWER(a0_.site) IN (?)
    OR LOWER(a0_.site_contact) LIKE ?
    OR LOWER(a0_.site_contact) IN (?)
    OR LOWER(c1_.societe) LIKE ?
    OR LOWER(c1_.societe) IN (?)
    OR LOWER(c1_.contact_nom) LIKE ?
    OR LOWER(c1_.contact_nom) IN (?)
    OR LOWER(c1_.contact_prenom) LIKE ?
    OR LOWER(c1_.contact_prenom) IN (?)
    OR LOWER(c2_.libelle_court) LIKE ?
    OR LOWER(c2_.libelle_court) IN (?)
    OR LOWER(c2_.libelle_long) LIKE ?
    OR LOWER(c2_.libelle_long) IN (?)
    OR LOWER(u3_.nom) LIKE ?
    OR LOWER(u3_.nom) IN (?)
    OR LOWER(u3_.prenom) LIKE ?
    OR LOWER(u3_.prenom) IN (?)
    OR LOWER(u3_.trigramme) LIKE ?
    OR LOWER(u3_.trigramme) IN (?)
    OR LOWER(p4_.objet) LIKE ?
    OR LOWER(p4_.objet) IN (?)
    OR LOWER(p4_.avancement) LIKE ?
    OR LOWER(p4_.avancement) IN (?)
  )
  AND (
    a0_.is_deleted = 0
    OR a0_.is_deleted IS NULL
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM affaire a0_ LEFT JOIN client c1_ ON a0_.client_id = c1_.id LEFT JOIN categorie_affaire c2_ ON a0_.categorie_id = c2_.id LEFT JOIN user u3_ ON a0_.responsable_id = u3_.id LEFT JOIN proposition p4_ ON a0_.id = p4_.affaire_id WHERE (LOWER(a0_.numero_affaire) LIKE '%chambery%' OR LOWER(a0_.numero_affaire) IN ('chambery') OR LOWER(a0_.objet) LIKE '%chambery%' OR LOWER(a0_.objet) IN ('chambery') OR LOWER(a0_.site) LIKE '%chambery%' OR LOWER(a0_.site) IN ('chambery') OR LOWER(a0_.site_contact) LIKE '%chambery%' OR LOWER(a0_.site_contact) IN ('chambery') OR LOWER(c1_.societe) LIKE '%chambery%' OR LOWER(c1_.societe) IN ('chambery') OR LOWER(c1_.contact_nom) LIKE '%chambery%' OR LOWER(c1_.contact_nom) IN ('chambery') OR LOWER(c1_.contact_prenom) LIKE '%chambery%' OR LOWER(c1_.contact_prenom) IN ('chambery') OR LOWER(c2_.libelle_court) LIKE '%chambery%' OR LOWER(c2_.libelle_court) IN ('chambery') OR LOWER(c2_.libelle_long) LIKE '%chambery%' OR LOWER(c2_.libelle_long) IN ('chambery') OR LOWER(u3_.nom) LIKE '%chambery%' OR LOWER(u3_.nom) IN ('chambery') OR LOWER(u3_.prenom) LIKE '%chambery%' OR LOWER(u3_.prenom) IN ('chambery') OR LOWER(u3_.trigramme) LIKE '%chambery%' OR LOWER(u3_.trigramme) IN ('chambery') OR LOWER(p4_.objet) LIKE '%chambery%' OR LOWER(p4_.objet) IN ('chambery') OR LOWER(p4_.avancement) LIKE '%chambery%' OR LOWER(p4_.avancement) IN ('chambery')) AND (a0_.is_deleted = 0 OR a0_.is_deleted IS NULL);

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.telephone AS telephone_9,
  t0.actif AS actif_10,
  t0.trigramme AS trigramme_11,
  t0.agence_id AS agence_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.telephone AS telephone_9, t0.actif AS actif_10, t0.trigramme AS trigramme_11, t0.agence_id AS agence_id_12 FROM user t0 WHERE t0.id = 5;