Symfony Profiler

select
  DISTINCT IFNULL(
    eg.group_id,
    IFNULL(cg2.group_id, cg.group_id)
  ) as `group`,
  IFNULL(
    eg.from_date,
    IFNULL(cg2.from_date, cg.from_date)
  ) as from_date,
  IFNULL(
    eg.end_date,
    IFNULL(cg2.end_date, cg.end_date)
  ) as end_date
from
  user u
  inner join user_role_linker url on u.user_id = url.user_id
  inner join user_role ur on url.role_id = ur.id
  left join educators e on u.user_id = e.user_id
  left join educators_groups eg on (eg.educator_id = e.id)
  left join family_users fu on (
    fu.user_id = u.user_id
    and fu.entity_type = 'parinte'
    and ur.role_id = 'parinte'
  )
  left join family_users fu2 on (
    fu.family_id = fu2.family_id
    and fu2.entity_type = 'child'
    and ur.role_id = 'parinte'
  )
  left join children_groups cg2 on (cg2.child_id = fu2.entity_id)
  left join children c on u.user_id = c.student_id
  left join children_groups cg on (cg.child_id = c.user_id)
where
  u.user_id = :identifierValue

select
                DISTINCT IFNULL(eg.group_id,
                   IFNULL(cg2.group_id, cg.group_id)
                ) as `group`,
                IFNULL(eg.from_date,
                   IFNULL(cg2.from_date, cg.from_date)
                ) as from_date,
                IFNULL(eg.end_date,
                   IFNULL(cg2.end_date, cg.end_date)
                ) as end_date                
            from user u
                inner join user_role_linker url on u.user_id = url.user_id
                inner join user_role ur on url.role_id = ur.id
                
                left join educators e on u.user_id = e.user_id
                left join educators_groups eg on (eg.educator_id = e.id)
                
                left join family_users fu on (fu.user_id = u.user_id and fu.entity_type = 'parinte' and ur.role_id = 'parinte')
                left join family_users fu2 on (fu.family_id = fu2.family_id and fu2.entity_type = 'child' and ur.role_id = 'parinte')
                left join children_groups cg2 on (cg2.child_id = fu2.entity_id)
                
                left join children c on u.user_id = c.student_id
                left join children_groups cg on (cg.child_id = c.user_id)            
            where u.user_id=21708
        ;

select
  u.*,
  GROUP_CONCAT(
    DISTINCT fu2.entity_id SEPARATOR ','
  ) AS my_children,
  kr.modules_access,
  kr.role_id,
  CASE when c.student_id is not null then 'student' else ur.role_id end as type
from
  user u
  inner join user_role_linker url on u.user_id = url.user_id
  inner join user_role ur on url.role_id = ur.id
  left join kg_role_users kru on (
    u.user_id = kru.user_id
    and kru.kindergarten_id = :kgId
  )
  left join kg_roles kr on (
    :kgId = kr.kindergarten_id
    and (
      kru.role_id = kr.role_id
      or (
        kru.role_id is null
        and (
          kr.role_id = ur.role_id
          or (
            kr.role_id = 'parent'
            and ur.role_id = 'parinte'
          )
        )
      )
    )
  )
  left join family_users fu on (
    fu.user_id = u.user_id
    and fu.entity_type = 'parinte'
    and ur.role_id = 'parinte'
  )
  left join family_users fu2 on (
    fu.family_id = fu2.family_id
    and fu2.entity_type = 'child'
    and ur.role_id = 'parinte'
  )
  left join children c on u.user_id = c.student_id
where
  u.email = :identifierValue
group by
  u.user_id

select u.*,
                   GROUP_CONCAT(DISTINCT fu2.entity_id SEPARATOR ',') AS my_children,
                   kr.modules_access,
                   kr.role_id,
                   CASE
                       when c.student_id is not null then 'student'
                       else ur.role_id
                    end as type
            from user u
                inner join user_role_linker url on u.user_id = url.user_id
                    inner join user_role ur on url.role_id = ur.id
            
                left join kg_role_users kru on (u.user_id = kru.user_id and kru.kindergarten_id = 2035)
                    left join kg_roles kr on (2035 = kr.kindergarten_id and (kru.role_id = kr.role_id or (kru.role_id is null and (kr.role_id=ur.role_id or (kr.role_id='parent' and ur.role_id='parinte')))))
            
                left join family_users fu on (fu.user_id = u.user_id and fu.entity_type = 'parinte' and ur.role_id = 'parinte')
                left join family_users fu2 on (fu.family_id = fu2.family_id and fu2.entity_type = 'child' and ur.role_id = 'parinte')
            
                left join children c on u.user_id = c.student_id
            
            where u.email='[email protected]'
            group by u.user_id
        ;

select
  DISTINCT IFNULL(
    uke.kindergarten_id,
    IFNULL(
      ukka.kindergarten_id,
      IFNULL(
        ukp.kindergarten_id,
        IFNULL(
          ukc2.kindergarten_id,
          IFNULL(
            ukc3.kindergarten_id, ukc.kindergarten_id
          )
        )
      )
    )
  ) as kg,
  IFNULL(
    uke.from_date,
    IFNULL(
      ukka.from_date,
      IFNULL(
        ukp.from_date,
        IFNULL(ukc.from_date, ukc2.from_date)
      )
    )
  ) as from_date,
  IFNULL(
    uke.end_date,
    IFNULL(
      ukka.end_date,
      IFNULL(
        ukp.end_date,
        IFNULL(ukc.end_date, ukc2.end_date)
      )
    )
  ) as end_date
from
  user u
  inner join user_role_linker url on u.user_id = url.user_id
  inner join user_role ur on url.role_id = ur.id
  left join educators e on u.user_id = e.user_id
  left join parents p on u.user_id = p.user_id
  left join family_users fu on (
    fu.user_id = u.user_id
    and fu.entity_type = 'parinte'
    and ur.role_id = 'parinte'
  )
  left join family_users fu2 on (
    fu.family_id = fu2.family_id
    and fu2.entity_type = 'child'
    and ur.role_id = 'parinte'
  )
  left join children c on u.user_id = c.student_id
  left join children c2 on p.id = c2.parent_id
  left join kg_admins ka on u.user_id = ka.user_id
  left join user_kindergartens uke on (
    uke.entity_id = e.id
    and uke.entity_type = 'educator'
    and ur.role_id = 'educator'
  )
  left join user_kindergartens ukka on (
    ukka.entity_id = ka.id
    and ukka.entity_type = 'gradinita_admin'
    and ur.role_id = 'gradinita_admin'
  )
  left join user_kindergartens ukp on (
    ukp.entity_id = p.id
    and ukp.entity_type = 'parinte'
    and ur.role_id = 'parinte'
  )
  left join user_kindergartens ukc on (
    ukc.entity_id = c.user_id
    and ukc.entity_type = 'copil'
    and ur.role_id = 'parinte'
  )
  left join user_kindergartens ukc2 on (
    ukc2.entity_id = fu2.user_id
    and ukc2.entity_type = 'copil'
    and ur.role_id = 'parinte'
  )
  left join user_kindergartens ukc3 on (
    ukc3.entity_id = c2.user_id
    and ukc3.entity_type = 'copil'
    and ur.role_id = 'parinte'
  )
where
  u.user_id = :identifierValue

select
                DISTINCT IFNULL(uke.kindergarten_id,
                    IFNULL(ukka.kindergarten_id,
                        IFNULL(ukp.kindergarten_id,
                            IFNULL(ukc2.kindergarten_id, IFNULL(ukc3.kindergarten_id, ukc.kindergarten_id))
                        )
                    )
                ) as kg,
                IFNULL(uke.from_date,
                    IFNULL(ukka.from_date,
                        IFNULL(ukp.from_date,
                            IFNULL(ukc.from_date, ukc2.from_date)
                        )
                    )
                ) as from_date,
                IFNULL(uke.end_date,
                    IFNULL(ukka.end_date,
                        IFNULL(ukp.end_date,
                            IFNULL(ukc.end_date, ukc2.end_date)
                        )
                    )
                ) as end_date
            from user u
                 inner join user_role_linker url on u.user_id = url.user_id
                 inner join user_role ur on url.role_id = ur.id
            
                 left join educators e on u.user_id = e.user_id
            
                 left join parents p on u.user_id = p.user_id
            
                 left join family_users fu on (fu.user_id = u.user_id and fu.entity_type = 'parinte' and ur.role_id = 'parinte')
                 left join family_users fu2 on (fu.family_id = fu2.family_id and fu2.entity_type = 'child' and ur.role_id = 'parinte')
            
                 left join children c on u.user_id = c.student_id
                 left join children c2 on p.id = c2.parent_id
                 left join kg_admins ka on u.user_id = ka.user_id
            
                 left join user_kindergartens uke on (uke.entity_id = e.id and uke.entity_type = 'educator' and ur.role_id = 'educator')
                 left join user_kindergartens ukka on (ukka.entity_id = ka.id and ukka.entity_type = 'gradinita_admin' and ur.role_id = 'gradinita_admin')
                 left join user_kindergartens ukp on (ukp.entity_id = p.id and ukp.entity_type = 'parinte' and ur.role_id = 'parinte')
                 left join user_kindergartens ukc on (ukc.entity_id = c.user_id and ukc.entity_type = 'copil' and ur.role_id = 'parinte')
            
                 left join user_kindergartens ukc2 on (ukc2.entity_id = fu2.user_id and ukc2.entity_type = 'copil' and ur.role_id = 'parinte')
                 left join user_kindergartens ukc3 on (ukc3.entity_id = c2.user_id and ukc3.entity_type = 'copil' and ur.role_id = 'parinte')
            
            where u.user_id=21708
        ;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.type AS type_3,
  t0.status AS status_4,
  t0.confirmation_code AS confirmation_code_5,
  t0.confirmation_expire_at AS confirmation_expire_at_6,
  t0.enabled_at AS enabled_at_7
FROM
  twofa_config t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.type AS type_3, t0.status AS status_4, t0.confirmation_code AS confirmation_code_5, t0.confirmation_expire_at AS confirmation_expire_at_6, t0.enabled_at AS enabled_at_7 FROM twofa_config t0 WHERE t0.user_id = 21708 LIMIT 1;