2.59 ms (72.41%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.azure_id AS azure_id_5, t0.username AS username_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.department AS department_9, t0.job_title AS job_title_10, t0.azure_groups AS azure_groups_11, t12.id AS id_13, t12.firstname AS firstname_14, t12.lastname AS lastname_15, t12.user_id AS user_id_16, t17.id AS id_18, t17.firstname AS firstname_19, t17.lastname AS lastname_20, t17.user_id AS user_id_21, t22.id AS id_23, t22.firstname AS firstname_24, t22.lastname AS lastname_25, t22.company AS company_26, t22.user_id AS user_id_27 FROM user t0 LEFT JOIN student t12 ON t12.user_id = t0.id LEFT JOIN professor t17 ON t17.user_id = t0.id LEFT JOIN tutor t22 ON t22.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.azure_id AS azure_id_5, t0.username AS username_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.department AS department_9, t0.job_title AS job_title_10, t0.azure_groups AS azure_groups_11, t12.id AS id_13, t12.firstname AS firstname_14, t12.lastname AS lastname_15, t12.user_id AS user_id_16, t17.id AS id_18, t17.firstname AS firstname_19, t17.lastname AS lastname_20, t17.user_id AS user_id_21, t22.id AS id_23, t22.firstname AS firstname_24, t22.lastname AS lastname_25, t22.company AS company_26, t22.user_id AS user_id_27 FROM user t0 LEFT JOIN student t12 ON t12.user_id = t0.id LEFT JOIN professor t17 ON t17.user_id = t0.id LEFT JOIN tutor t22 ON t22.user_id = t0.id WHERE t0.id = 70;
|
0.99 ms (27.59%)
|
1 |
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.title AS title_2, n0_.message AS message_3, n0_.read_at AS read_at_4, n0_.created_at AS created_at_5, n0_.metadata AS metadata_6, n0_.recipient_id AS recipient_id_7 FROM notification n0_ WHERE n0_.recipient_id = ? AND n0_.read_at IS NULL ORDER BY n0_.created_at DESC
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.title AS title_2, n0_.message AS message_3, n0_.read_at AS read_at_4, n0_.created_at AS created_at_5, n0_.metadata AS metadata_6, n0_.recipient_id AS recipient_id_7 FROM notification n0_ WHERE n0_.recipient_id = 70 AND n0_.read_at IS NULL ORDER BY n0_.created_at DESC;
|