Redirect 302 redirect from GET @app_dashboard (768e87)

GET https://emotionya.sara.education/admin/requests

Query Metrics

19 Database Queries
12 Different statements
7.16 ms Query time
0 Invalid entities
137 Managed entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT t0.id AS id_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.auth_token AS auth_token_15, t0.auth_token_expires_at AS auth_token_expires_at_16, t0.discriminator, t1.specialization AS specialization_17, t2.family_id AS family_id_18, t3.pseudo AS pseudo_19, t3.class AS class_20, t3.school_name AS school_name_21, t3.points AS points_22, t3.need_tags AS need_tags_23, t3.family_id AS family_id_24, t4.specializations AS specializations_25 FROM `user` t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN parent_user t2 ON t0.id = t2.id LEFT JOIN student t3 ON t0.id = t3.id LEFT JOIN specialist t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.id = ?
Parameters:
[
  37
]
2 0.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.type AS type_5, t0.priority AS priority_6, t0.response AS response_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.assigned_to_id AS assigned_to_id_10, t0.creator_id AS creator_id_11, t0.recipient_id AS recipient_id_12, t0.family_id AS family_id_13, t0.coach_id AS coach_id_14, t0.parent_id AS parent_id_15, t0.student_id AS student_id_16, t0.specialist_id AS specialist_id_17 FROM request t0 WHERE t0.student_id = ?
Parameters:
[
  37
]
3 0.46 ms
SELECT t0.id AS id_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.auth_token AS auth_token_15, t0.auth_token_expires_at AS auth_token_expires_at_16, t0.discriminator, t1.specialization AS specialization_17, t2.family_id AS family_id_18, t3.pseudo AS pseudo_19, t3.class AS class_20, t3.school_name AS school_name_21, t3.points AS points_22, t3.need_tags AS need_tags_23, t3.family_id AS family_id_24, t4.specializations AS specializations_25 FROM `user` t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN parent_user t2 ON t0.id = t2.id LEFT JOIN student t3 ON t0.id = t3.id LEFT JOIN specialist t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.id = ?
Parameters:
[
  2
]
4 0.33 ms
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.status AS status_3, r0_.type AS type_4, r0_.priority AS priority_5, r0_.response AS response_6, r0_.created_at AS created_at_7, r0_.updated_at AS updated_at_8, r0_.assigned_to_id AS assigned_to_id_9, r0_.creator_id AS creator_id_10, r0_.recipient_id AS recipient_id_11, r0_.family_id AS family_id_12, r0_.coach_id AS coach_id_13, r0_.parent_id AS parent_id_14, r0_.student_id AS student_id_15, r0_.specialist_id AS specialist_id_16 FROM request r0_ WHERE r0_.assigned_to_id = ?
Parameters:
[
  37
]
5 0.31 ms
SELECT t0.id AS id_1, t0.family_identifier AS family_identifier_2, t0.type AS type_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.location AS location_7, t0.coach_id AS coach_id_8 FROM family t0 WHERE t0.coach_id = ?
Parameters:
[
  2
]
6 0.28 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.family_id AS family_id_13, t1.discriminator FROM parent_user t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  3
]
7 0.34 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.family_id AS family_id_13, t1.discriminator FROM parent_user t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  4
]
8 0.30 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.family_id AS family_id_13, t1.discriminator FROM parent_user t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  8
]
9 0.24 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.family_id AS family_id_13, t1.discriminator FROM parent_user t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  9
]
10 0.28 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.family_id AS family_id_13, t1.discriminator FROM parent_user t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  10
]
11 0.28 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.family_id AS family_id_13, t1.discriminator FROM parent_user t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  11
]
12 0.30 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.family_id AS family_id_13, t1.discriminator FROM parent_user t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  12
]
13 0.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_origin AS description_origin_4, t0.deadline AS deadline_5, t0.category AS category_6, t0.category_tags AS category_tags_7, t0.status AS status_8, t0.progress AS progress_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.student_id AS student_id_12, t0.coach_id AS coach_id_13 FROM objective t0 WHERE t0.coach_id = ?
Parameters:
[
  2
]
14 0.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.type AS type_5, t0.priority AS priority_6, t0.response AS response_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.assigned_to_id AS assigned_to_id_10, t0.creator_id AS creator_id_11, t0.recipient_id AS recipient_id_12, t0.family_id AS family_id_13, t0.coach_id AS coach_id_14, t0.parent_id AS parent_id_15, t0.student_id AS student_id_16, t0.specialist_id AS specialist_id_17 FROM request t0 WHERE t0.coach_id = ?
Parameters:
[
  2
]
15 0.43 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.specializations AS specializations_13, t1.discriminator FROM specialist t0 INNER JOIN `user` t1 ON t0.id = t1.id INNER JOIN family_specialists ON t0.id = family_specialists.specialist_id WHERE family_specialists.family_id = ?
Parameters:
[
  3
]
16 0.37 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.is_active AS is_active_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t1.auth_token AS auth_token_11, t1.auth_token_expires_at AS auth_token_expires_at_12, t0.pseudo AS pseudo_13, t0.class AS class_14, t0.school_name AS school_name_15, t0.points AS points_16, t0.need_tags AS need_tags_17, t0.family_id AS family_id_18, t1.discriminator FROM student t0 INNER JOIN `user` t1 ON t0.id = t1.id WHERE t0.family_id = ?
Parameters:
[
  3
]
17 0.30 ms
SELECT COUNT(*) FROM objective t0 WHERE t0.student_id = ?
Parameters:
[
  37
]
18 0.29 ms
SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.day_of_week AS day_of_week_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.coach_id AS coach_id_7, t0.specialist_id AS specialist_id_8, t0.parent_id AS parent_id_9, t0.student_id AS student_id_10 FROM availability t0 WHERE t0.student_id = ?
Parameters:
[
  37
]
19 0.31 ms
SELECT COUNT(*) FROM message t0 WHERE t0.request_id = ?
Parameters:
[
  9
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Objective 82
App\Entity\User 28
App\Entity\Request 20
App\Entity\Family 7

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Coach No errors.
App\Entity\ParentUser No errors.
App\Entity\Student No errors.
App\Entity\Specialist No errors.
App\Entity\Admin No errors.
App\Entity\Family No errors.
App\Entity\Comment No errors.
App\Entity\Objective No errors.
App\Entity\Request No errors.
App\Entity\Availability No errors.
App\Entity\Note No errors.
App\Entity\Message No errors.
App\Entity\Task No errors.