Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.phone_number AS phone_number_2,
  a0_.password AS password_3,
  a0_.roles AS roles_4,
  a0_.lastname AS lastname_5,
  a0_.firstname AS firstname_6,
  a0_.created_at AS created_at_7,
  a0_.registration_source AS registration_source_8,
  a0_.honorific_prefix AS honorific_prefix_9,
  a0_.reset_token AS reset_token_10,
  a0_.reset_token_expiration_date AS reset_token_expiration_date_11,
  a0_.uniq_id AS uniq_id_12,
  a0_.code_confirmation AS code_confirmation_13,
  a0_.updated_at AS updated_at_14,
  a0_.is_active AS is_active_15
FROM
  app_users a0_
WHERE
  a0_.email = ?
  OR a0_.phone_number = ?

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = 'stanislas@digidom.pro' OR a0_.phone_number = 'stanislas@digidom.pro';

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.id AS id_1
FROM
  organization o0_
  LEFT JOIN organization_legal_representative o2_ ON o0_.id = o2_.organization_id
  LEFT JOIN legal_representative l1_ ON l1_.id = o2_.legal_representative_id
  LEFT JOIN organization_user o4_ ON o0_.id = o4_.organization_id
  LEFT JOIN app_users a3_ ON a3_.id = o4_.user_id
  LEFT JOIN person p5_ ON l1_.person_id = p5_.id
WHERE
  (
    (
      o0_.id = ?
      OR LOWER(o0_.bal) LIKE ?
      OR LOWER(o0_.email) LIKE ?
      OR LOWER(o0_.telephone) LIKE ?
      OR LOWER(o0_.siret) LIKE ?
      OR LOWER(o0_.legal_name) LIKE ?
      OR LOWER(o0_.commercial_court_registry) LIKE ?
      OR LOWER(o0_.alternate_name) LIKE ?
    )
    AND (
      o0_.status <> ?
      OR o0_.status IS NULL
    )
    AND o0_.legal_name NOT LIKE ?
  )
  OR (
    LOWER(p5_.family_name) LIKE ?
    OR LOWER(p5_.given_name) LIKE ?
  )
  OR LOWER(a3_.email) LIKE ?
  OR LOWER(a3_.phone_number) LIKE ?
  OR (
    LOWER(a3_.lastname) LIKE ?
    OR LOWER(a3_.firstname) LIKE ?
  )
ORDER BY
  o0_.id DESC
LIMIT
  5

SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM organization o0_ LEFT JOIN organization_legal_representative o2_ ON o0_.id = o2_.organization_id LEFT JOIN legal_representative l1_ ON l1_.id = o2_.legal_representative_id LEFT JOIN organization_user o4_ ON o0_.id = o4_.organization_id LEFT JOIN app_users a3_ ON a3_.id = o4_.user_id LEFT JOIN person p5_ ON l1_.person_id = p5_.id WHERE ((o0_.id = 'test29542' OR LOWER(o0_.bal) LIKE '%test29542%' OR LOWER(o0_.email) LIKE '%test29542%' OR LOWER(o0_.telephone) LIKE '%test29542%' OR LOWER(o0_.siret) LIKE '%test29542%' OR LOWER(o0_.legal_name) LIKE '%test29542%' OR LOWER(o0_.commercial_court_registry) LIKE '%test29542%' OR LOWER(o0_.alternate_name) LIKE '%test29542%') AND (o0_.status <> 'SUPPRIME' OR o0_.status IS NULL) AND o0_.legal_name NOT LIKE '%CANCELED%') OR (LOWER(p5_.family_name) LIKE '%test29542%' OR LOWER(p5_.given_name) LIKE '%test29542%') OR LOWER(a3_.email) LIKE '%test29542%' OR LOWER(a3_.phone_number) LIKE '%test29542%' OR (LOWER(a3_.lastname) LIKE '%test29542%' OR LOWER(a3_.firstname) LIKE '%test29542%') ORDER BY o0_.id DESC LIMIT 5;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  organization o0_
  LEFT JOIN organization_legal_representative o2_ ON o0_.id = o2_.organization_id
  LEFT JOIN legal_representative l1_ ON l1_.id = o2_.legal_representative_id
  LEFT JOIN organization_user o4_ ON o0_.id = o4_.organization_id
  LEFT JOIN app_users a3_ ON a3_.id = o4_.user_id
  LEFT JOIN person p5_ ON l1_.person_id = p5_.id
WHERE
  (
    (
      o0_.id = ?
      OR LOWER(o0_.bal) LIKE ?
      OR LOWER(o0_.email) LIKE ?
      OR LOWER(o0_.telephone) LIKE ?
      OR LOWER(o0_.siret) LIKE ?
      OR LOWER(o0_.legal_name) LIKE ?
      OR LOWER(o0_.commercial_court_registry) LIKE ?
      OR LOWER(o0_.alternate_name) LIKE ?
    )
    AND (
      o0_.status <> ?
      OR o0_.status IS NULL
    )
    AND o0_.legal_name NOT LIKE ?
  )
  OR (
    LOWER(p5_.family_name) LIKE ?
    OR LOWER(p5_.given_name) LIKE ?
  )
  OR LOWER(a3_.email) LIKE ?
  OR LOWER(a3_.phone_number) LIKE ?
  OR (
    LOWER(a3_.lastname) LIKE ?
    OR LOWER(a3_.firstname) LIKE ?
  )

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM organization o0_ LEFT JOIN organization_legal_representative o2_ ON o0_.id = o2_.organization_id LEFT JOIN legal_representative l1_ ON l1_.id = o2_.legal_representative_id LEFT JOIN organization_user o4_ ON o0_.id = o4_.organization_id LEFT JOIN app_users a3_ ON a3_.id = o4_.user_id LEFT JOIN person p5_ ON l1_.person_id = p5_.id WHERE ((o0_.id = 'test29542' OR LOWER(o0_.bal) LIKE '%test29542%' OR LOWER(o0_.email) LIKE '%test29542%' OR LOWER(o0_.telephone) LIKE '%test29542%' OR LOWER(o0_.siret) LIKE '%test29542%' OR LOWER(o0_.legal_name) LIKE '%test29542%' OR LOWER(o0_.commercial_court_registry) LIKE '%test29542%' OR LOWER(o0_.alternate_name) LIKE '%test29542%') AND (o0_.status <> 'SUPPRIME' OR o0_.status IS NULL) AND o0_.legal_name NOT LIKE '%CANCELED%') OR (LOWER(p5_.family_name) LIKE '%test29542%' OR LOWER(p5_.given_name) LIKE '%test29542%') OR LOWER(a3_.email) LIKE '%test29542%' OR LOWER(a3_.phone_number) LIKE '%test29542%' OR (LOWER(a3_.lastname) LIKE '%test29542%' OR LOWER(a3_.firstname) LIKE '%test29542%');