Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  t0.refresh_token AS refresh_token_1,
  t0.username AS username_2,
  t0.valid AS valid_3,
  t0.id AS id_4
FROM
  refresh_tokens t0
WHERE
  t0.refresh_token = ?
LIMIT
  1

SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = 'ea1a622a28c62e59568dea28ff5690c47aebd03ac1253bc23eb814e5cb412b96a8427c6d7dd4ad085bbb41f457f9fe64b2ff2676782f4addd07f929607db03a5' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  refresh_tokens
WHERE
  id = ?

DELETE FROM refresh_tokens WHERE id = 101770;

INSERT INTO refresh_tokens (refresh_token, username, valid)
VALUES
  (?, ?, ?)

INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES ('f269497e723d5565626284fbc8dd7d000e7a8136293283bd73a71b16e164cced5abc0b9828eebf1c6bc063606dc9f7cda4151599680f0e9d5ccae71af5b605b6', '[email protected]', '2024-10-28 10:19:18');

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
  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 = 0)
                    left join kg_roles kr on (0 = 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(
    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
        ;