Query Metrics
4
Database Queries
4
Different statements
6.62 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 1.77 ms |
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
Parameters:
[ "identifierValue" => "[email protected]" "kgId" => 2035 ] |
2 | 1.67 ms |
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
Parameters:
[ "identifierValue" => 21708 ] |
3 | 2.50 ms |
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
Parameters:
[ "identifierValue" => 21708 ] |
internal connection
#▲ | Time | Info |
---|---|---|
1 | 0.69 ms |
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
Parameters:
[
21708
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
internal | doctrine.dbal.internal_connection |
migration | doctrine.dbal.migration_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
internal | doctrine.orm.internal_entity_manager |
migration | doctrine.orm.migration_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
No loaded entities.
internal entity manager
Class | Mapping errors |
---|---|
App\Entity\Internal\TwoFaConfig | No errors. |
migration entity manager
No loaded entities.