| 1 |
0.81 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.deactivated_notifications AS deactivated_notifications_5, t0.sex AS sex_6, t0.rut AS rut_7, t0.name AS name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13, t0.career AS career_14, t0.curriculum AS curriculum_15, t0.other_university AS other_university_16, t17.rut AS rut_18, t17.biography AS biography_19, t17.interest_areas AS interest_areas_20, t17.english_interest_areas AS english_interest_areas_21, t17.active AS active_22, t17.english_bio AS english_bio_23, t17.user_id AS user_id_24, t25.id AS id_26, t25.career AS career_27, t25.curriculum AS curriculum_28, t25.other_university AS other_university_29, t25.user_id AS user_id_30, t25.cod_pais AS cod_pais_31, t25.cod_universidad AS cod_universidad_32, t0.cod_pais AS cod_pais_33, t0.cod_universidad AS cod_universidad_34 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t25 ON t25.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.deactivated_notifications AS deactivated_notifications_5, t0.sex AS sex_6, t0.rut AS rut_7, t0.name AS name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13, t0.career AS career_14, t0.curriculum AS curriculum_15, t0.other_university AS other_university_16, t17.rut AS rut_18, t17.biography AS biography_19, t17.interest_areas AS interest_areas_20, t17.english_interest_areas AS english_interest_areas_21, t17.active AS active_22, t17.english_bio AS english_bio_23, t17.user_id AS user_id_24, t25.id AS id_26, t25.career AS career_27, t25.curriculum AS curriculum_28, t25.other_university AS other_university_29, t25.user_id AS user_id_30, t25.cod_pais AS cod_pais_31, t25.cod_universidad AS cod_universidad_32, t0.cod_pais AS cod_pais_33, t0.cod_universidad AS cod_universidad_34 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t25 ON t25.user_id = t0.id WHERE t0.id = 1;
|
| 2 |
1.04 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE ? OR u0_.roles LIKE ?
Parameters: [
"%"ROLE_ADMINISTRATIVE"%"
"%"ROLE_OTHER"%"
]
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMINISTRATIVE\"%' OR u0_.roles LIKE '%\"ROLE_OTHER\"%';
|
| 3 |
0.31 ms |
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = 159;
|
| 4 |
0.27 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 159;
|
| 5 |
0.27 ms |
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = 160;
|
| 6 |
0.22 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 160;
|
| 7 |
0.28 ms |
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = 161;
|
| 8 |
0.21 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 161;
|
| 9 |
0.24 ms |
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = 162;
|
| 10 |
0.24 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 162;
|
| 11 |
0.24 ms |
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?
SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = 163;
|
| 12 |
0.26 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 163;
|
| 13 |
0.36 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE ?
Parameters: [
"%"ROLE_PROFESSOR"%"
]
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE '%\"ROLE_PROFESSOR\"%';
|
| 14 |
0.57 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ INNER JOIN user_assistants u2_ ON u0_.id = u2_.user_target INNER JOIN `user` u1_ ON u1_.id = u2_.user_source
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ INNER JOIN user_assistants u2_ ON u0_.id = u2_.user_target INNER JOIN `user` u1_ ON u1_.id = u2_.user_source;
|