Symfony Profiler

SELECT
  DISTINCT o0_.id AS id_0
FROM
  organization o0_
  INNER JOIN store s1_ ON o0_.store_id = s1_.id
  LEFT JOIN postal_address p2_ ON s1_.postal_address_id = p2_.id
  LEFT JOIN organization_legal_representative o4_ ON o0_.id = o4_.organization_id
  LEFT JOIN legal_representative l3_ ON l3_.id = o4_.legal_representative_id
  LEFT JOIN legal_representative l5_ ON l3_.id = l5_.parent_id
  LEFT JOIN person p6_ ON l3_.person_id = p6_.id
  AND (p6_.type = 'PHYSICAL')
  LEFT JOIN person p7_ ON l5_.person_id = p7_.id
  AND (p7_.type = 'PHYSICAL')
  INNER JOIN subscription s8_ ON o0_.id = s8_.organization_id
  INNER JOIN service s9_ ON s8_.id = s9_.subscription_id
  INNER JOIN product p10_ ON s9_.product_id = p10_.id
  LEFT JOIN ibml_organization_configuration i11_ ON o0_.id = i11_.organization_id
WHERE
  o0_.status NOT IN (?)
  AND p10_.unique_key = ?
  AND s1_.is_exportable_ibml = 1
  AND o0_.bal <> ''
  AND o0_.bal IS NOT NULL
  AND o0_.bal <> '0'
GROUP BY
  o0_.id
LIMIT
  30 OFFSET 30

SELECT DISTINCT o0_.id AS id_0 FROM organization o0_ INNER JOIN store s1_ ON o0_.store_id = s1_.id LEFT JOIN postal_address p2_ ON s1_.postal_address_id = p2_.id LEFT JOIN organization_legal_representative o4_ ON o0_.id = o4_.organization_id LEFT JOIN legal_representative l3_ ON l3_.id = o4_.legal_representative_id LEFT JOIN legal_representative l5_ ON l3_.id = l5_.parent_id LEFT JOIN person p6_ ON l3_.person_id = p6_.id AND (p6_.type = 'PHYSICAL') LEFT JOIN person p7_ ON l5_.person_id = p7_.id AND (p7_.type = 'PHYSICAL') INNER JOIN subscription s8_ ON o0_.id = s8_.organization_id INNER JOIN service s9_ ON s8_.id = s9_.subscription_id INNER JOIN product p10_ ON s9_.product_id = p10_.id LEFT JOIN ibml_organization_configuration i11_ ON o0_.id = i11_.organization_id WHERE o0_.status NOT IN ('NEW', 'SUPPRIME', 'PERDU') AND p10_.unique_key = 'DOMICILIATION_COMMERCIALE' AND s1_.is_exportable_ibml = 1 AND o0_.bal <> '' AND o0_.bal IS NOT NULL AND o0_.bal <> '0' GROUP BY o0_.id LIMIT 30 OFFSET 30;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  organization o0_
  INNER JOIN store s1_ ON o0_.store_id = s1_.id
  LEFT JOIN postal_address p2_ ON s1_.postal_address_id = p2_.id
  LEFT JOIN organization_legal_representative o4_ ON o0_.id = o4_.organization_id
  LEFT JOIN legal_representative l3_ ON l3_.id = o4_.legal_representative_id
  LEFT JOIN legal_representative l5_ ON l3_.id = l5_.parent_id
  LEFT JOIN person p6_ ON l3_.person_id = p6_.id
  AND (p6_.type = 'PHYSICAL')
  LEFT JOIN person p7_ ON l5_.person_id = p7_.id
  AND (p7_.type = 'PHYSICAL')
  INNER JOIN subscription s8_ ON o0_.id = s8_.organization_id
  INNER JOIN service s9_ ON s8_.id = s9_.subscription_id
  INNER JOIN product p10_ ON s9_.product_id = p10_.id
  LEFT JOIN ibml_organization_configuration i11_ ON o0_.id = i11_.organization_id
WHERE
  o0_.status NOT IN (?)
  AND p10_.unique_key = ?
  AND s1_.is_exportable_ibml = 1
  AND o0_.bal <> ''
  AND o0_.bal IS NOT NULL
  AND o0_.bal <> '0'
GROUP BY
  o0_.id

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM organization o0_ INNER JOIN store s1_ ON o0_.store_id = s1_.id LEFT JOIN postal_address p2_ ON s1_.postal_address_id = p2_.id LEFT JOIN organization_legal_representative o4_ ON o0_.id = o4_.organization_id LEFT JOIN legal_representative l3_ ON l3_.id = o4_.legal_representative_id LEFT JOIN legal_representative l5_ ON l3_.id = l5_.parent_id LEFT JOIN person p6_ ON l3_.person_id = p6_.id AND (p6_.type = 'PHYSICAL') LEFT JOIN person p7_ ON l5_.person_id = p7_.id AND (p7_.type = 'PHYSICAL') INNER JOIN subscription s8_ ON o0_.id = s8_.organization_id INNER JOIN service s9_ ON s8_.id = s9_.subscription_id INNER JOIN product p10_ ON s9_.product_id = p10_.id LEFT JOIN ibml_organization_configuration i11_ ON o0_.id = i11_.organization_id WHERE o0_.status NOT IN ('NEW', 'SUPPRIME', 'PERDU') AND p10_.unique_key = 'DOMICILIATION_COMMERCIALE' AND s1_.is_exportable_ibml = 1 AND o0_.bal <> '' AND o0_.bal IS NOT NULL AND o0_.bal <> '0' GROUP BY o0_.id;

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 = 'alain@hairun-technology.com' OR a0_.phone_number = 'alain@hairun-technology.com';

SELECT
  o0_.id AS id_0,
  o0_.legal_name AS legal_name_1,
  o0_.alternate_name AS alternate_name_2,
  i1_.id AS id_3,
  o0_.status AS status_4,
  o0_.bal AS bal_5,
  CASE WHEN i1_.alternate_name IS NOT NULL THEN i1_.alternate_name ELSE o0_.alternate_name END AS sclr_6,
  CASE WHEN i1_.legal_name IS NOT NULL THEN i1_.legal_name ELSE o0_.legal_name END AS sclr_7,
  CASE WHEN i1_.name_legal_representative IS NOT NULL THEN i1_.name_legal_representative ELSE (
    CASE WHEN p2_.family_name IS NOT NULL THEN CONCAT(
      p2_.given_name, ' ', p2_.family_name
    ) ELSE CONCAT(
      p3_.given_name, ' ', p3_.family_name
    ) END
  ) END AS sclr_8,
  CASE WHEN i1_.alternate_name IS NOT NULL
  OR i1_.legal_name IS NOT NULL THEN 1 ELSE 0 END AS sclr_9,
  CASE WHEN p2_.family_name IS NOT NULL THEN CONCAT(
    p2_.given_name, ' ', p2_.family_name
  ) ELSE CONCAT(
    p3_.given_name, ' ', p3_.family_name
  ) END AS sclr_10,
  s4_.id AS id_11,
  o0_.termination_date AS termination_date_12,
  o0_.email AS email_13
FROM
  organization o0_
  INNER JOIN store s4_ ON o0_.store_id = s4_.id
  LEFT JOIN postal_address p5_ ON s4_.postal_address_id = p5_.id
  LEFT JOIN organization_legal_representative o7_ ON o0_.id = o7_.organization_id
  LEFT JOIN legal_representative l6_ ON l6_.id = o7_.legal_representative_id
  LEFT JOIN legal_representative l8_ ON l6_.id = l8_.parent_id
  LEFT JOIN person p3_ ON l6_.person_id = p3_.id
  AND (p3_.type = 'PHYSICAL')
  LEFT JOIN person p2_ ON l8_.person_id = p2_.id
  AND (p2_.type = 'PHYSICAL')
  INNER JOIN subscription s9_ ON o0_.id = s9_.organization_id
  INNER JOIN service s10_ ON s9_.id = s10_.subscription_id
  INNER JOIN product p11_ ON s10_.product_id = p11_.id
  LEFT JOIN ibml_organization_configuration i1_ ON o0_.id = i1_.organization_id
WHERE
  o0_.status NOT IN (?)
  AND p11_.unique_key = ?
  AND s4_.is_exportable_ibml = 1
  AND o0_.bal <> ''
  AND o0_.bal IS NOT NULL
  AND o0_.bal <> '0'
  AND o0_.id IN (?)
GROUP BY
  o0_.id

SELECT o0_.id AS id_0, o0_.legal_name AS legal_name_1, o0_.alternate_name AS alternate_name_2, i1_.id AS id_3, o0_.status AS status_4, o0_.bal AS bal_5, CASE WHEN i1_.alternate_name IS NOT NULL THEN i1_.alternate_name ELSE o0_.alternate_name END AS sclr_6, CASE WHEN i1_.legal_name IS NOT NULL THEN i1_.legal_name ELSE o0_.legal_name END AS sclr_7, CASE WHEN i1_.name_legal_representative IS NOT NULL THEN i1_.name_legal_representative ELSE (CASE WHEN p2_.family_name IS NOT NULL THEN CONCAT(p2_.given_name, ' ', p2_.family_name) ELSE CONCAT(p3_.given_name, ' ', p3_.family_name) END) END AS sclr_8, CASE WHEN i1_.alternate_name IS NOT NULL OR i1_.legal_name IS NOT NULL THEN 1 ELSE 0 END AS sclr_9, CASE WHEN p2_.family_name IS NOT NULL THEN CONCAT(p2_.given_name, ' ', p2_.family_name) ELSE CONCAT(p3_.given_name, ' ', p3_.family_name) END AS sclr_10, s4_.id AS id_11, o0_.termination_date AS termination_date_12, o0_.email AS email_13 FROM organization o0_ INNER JOIN store s4_ ON o0_.store_id = s4_.id LEFT JOIN postal_address p5_ ON s4_.postal_address_id = p5_.id LEFT JOIN organization_legal_representative o7_ ON o0_.id = o7_.organization_id LEFT JOIN legal_representative l6_ ON l6_.id = o7_.legal_representative_id LEFT JOIN legal_representative l8_ ON l6_.id = l8_.parent_id LEFT JOIN person p3_ ON l6_.person_id = p3_.id AND (p3_.type = 'PHYSICAL') LEFT JOIN person p2_ ON l8_.person_id = p2_.id AND (p2_.type = 'PHYSICAL') INNER JOIN subscription s9_ ON o0_.id = s9_.organization_id INNER JOIN service s10_ ON s9_.id = s10_.subscription_id INNER JOIN product p11_ ON s10_.product_id = p11_.id LEFT JOIN ibml_organization_configuration i1_ ON o0_.id = i1_.organization_id WHERE o0_.status NOT IN ('NEW', 'SUPPRIME', 'PERDU') AND p11_.unique_key = 'DOMICILIATION_COMMERCIALE' AND s4_.is_exportable_ibml = 1 AND o0_.bal <> '' AND o0_.bal IS NOT NULL AND o0_.bal <> '0' AND o0_.id IN (3427, 3429, 3432, 3434, 3435, 3438, 3439, 3440, 3441, 3442, 3443, 3445, 3446, 3450, 3451, 3452, 3456, 3457, 3461, 3463, 3466, 3467, 3470, 3473, 3478, 3479, 3482, 3484, 3485, 3486) GROUP BY o0_.id;