Symfony Profiler

select
  *
from
  (
    WITH
      RECURSIVE tree_view AS (
        SELECT
          id,
          parent_id,
          code,
          name,
          0 AS level,
          customer_id,
          type as entity_type
        FROM
          site
        WHERE
          customer_id IS NOT NULL
          AND parent_id IS NULL
        UNION ALL
        SELECT
          parent.id,
          parent.parent_id,
          parent.code,
          parent.name,
          level + 1 AS level,
          tv.customer_id,
          type as entity_type
        FROM
          site parent
          JOIN tree_view tv ON parent.parent_id = tv.id
      )
    SELECT
      c.id,
      c.name,
      t.parent_id,
      t.id as site_id,
      t.name as site_name,
      t.level,
      t.entity_type,
      t.code,
      c.code as code_customer,
      c.reference as reference_customer
    FROM
      tree_view t
      INNER join customer c on t.customer_id = c.id
    ORDER BY
      c.name,
      t.parent_id,
      level asc,
      t.name asc
  ) p
where
  p.id in (
    310, 361, 437, 488, 489, 408, 496, 499,
    503, 505
  )
  and (
    p.entity_type = 'site'
    and p.site_id in (
      38347, 41079, 42564, 42721, 42726, 42729,
      42960, 43016, 43033, 43080, 43084
    )
    or p.entity_type != 'site'
  );

select * from (
                        WITH RECURSIVE tree_view AS (
        
                        SELECT id,
                             parent_id,
                             code,
                             name,
                             0 AS level,
                             customer_id,
                             type  as entity_type
                        FROM site
                        WHERE customer_id IS NOT NULL AND parent_id IS NULL
                         
                         
                    UNION ALL
                     
                        SELECT parent.id,
                    parent.parent_id,
                             parent.code,
                             parent.name,
                             level + 1 AS level,
                    tv.customer_id,
                    type as entity_type
                        FROM site parent
                        JOIN tree_view tv
                          ON parent.parent_id = tv.id 
                    )
                     
                    SELECT
                    c.id, c.name, t.parent_id, t.id as site_id, t.name as site_name, t.level, t.entity_type, t.code, c.code as code_customer
                    , c.reference as reference_customer
                         
                    FROM tree_view t INNER join customer c on t.customer_id = c.id
                    ORDER BY c.name,t.parent_id,level asc, t.name asc) p 
                    where  p.id in (310,361,437,488,489,408,496,499,503,505) and ( p.entity_type ='site' and p.site_id in (38347,41079,42564,42721,42726,42729,42960,43016,43033,43080,43084) or  p.entity_type !='site' ) ;
                    ;

SELECT
  a.site_id,
  c.id as id_customer,
  c.name as name_customer
FROM
  affectation a
  INNER JOIN site s on a.site_id = s.id
  left JOIN user_site us on s.id = us.site_id
  RIGHT JOIN customer c on s.customer_id = c.id
where
  a.document_id = 110028
  and a.is_applicable = 1
GROUP by
  a.site_id,
  a.document_id

SELECT a.site_id , c.id as id_customer, c.name as name_customer FROM affectation a
        INNER JOIN site s on a.site_id = s.id
        left JOIN user_site us on s.id = us.site_id 
        
        RIGHT JOIN customer c on s.customer_id = c.id                     
        where a.document_id = 110028 and a.is_applicable = 1
        GROUP by a.site_id, a.document_id;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.department AS department_4,
  t0.position AS position_5,
  t0.email AS email_6,
  t0.password AS password_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.website AS website_10,
  t0.roles AS roles_11,
  t0.activation_token AS activation_token_12,
  t0.activation_token_created_at AS activation_token_created_at_13,
  t0.is_enabled AS is_enabled_14,
  t0.expire_at AS expire_at_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.application_master AS application_master_18,
  t0.lang AS lang_19,
  t0.customer_associated AS customer_associated_20,
  t0.hide_in_pa AS hide_in_pa_21,
  t0.is_hotline AS is_hotline_22,
  t0.customer_id AS customer_id_23,
  t0.profile_picture_id AS profile_picture_id_24
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.department AS department_4, t0.position AS position_5, t0.email AS email_6, t0.password AS password_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.roles AS roles_11, t0.activation_token AS activation_token_12, t0.activation_token_created_at AS activation_token_created_at_13, t0.is_enabled AS is_enabled_14, t0.expire_at AS expire_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.application_master AS application_master_18, t0.lang AS lang_19, t0.customer_associated  AS customer_associated_20, t0.hide_in_pa AS hide_in_pa_21, t0.is_hotline AS is_hotline_22, t0.customer_id AS customer_id_23, t0.profile_picture_id AS profile_picture_id_24 FROM user t0 WHERE t0.email = 'bechir.f@axelites.com' LIMIT 1;