1.13 ms (23.87%)
|
1 |
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.status AS status_19, t17.post AS post_20, t17.biography AS biography_21, t17.interest_areas AS interest_areas_22, t17.english_interest_areas AS english_interest_areas_23, t17.active AS active_24, t17.user_id AS user_id_25, t26.id AS id_27, t26.career AS career_28, t26.curriculum AS curriculum_29, t26.other_university AS other_university_30, t26.user_id AS user_id_31, t26.cod_pais AS cod_pais_32, t26.cod_universidad AS cod_universidad_33, t0.cod_pais AS cod_pais_34, t0.cod_universidad AS cod_universidad_35 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t26 ON t26.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.status AS status_19, t17.post AS post_20, t17.biography AS biography_21, t17.interest_areas AS interest_areas_22, t17.english_interest_areas AS english_interest_areas_23, t17.active AS active_24, t17.user_id AS user_id_25, t26.id AS id_27, t26.career AS career_28, t26.curriculum AS curriculum_29, t26.other_university AS other_university_30, t26.user_id AS user_id_31, t26.cod_pais AS cod_pais_32, t26.cod_universidad AS cod_universidad_33, t0.cod_pais AS cod_pais_34, t0.cod_universidad AS cod_universidad_35 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t26 ON t26.user_id = t0.id WHERE t0.id = 59;
|
0.70 ms (14.78%)
|
1 |
SELECT t0.rut AS rut_1, t0.status AS status_2, t0.post AS post_3, t0.biography AS biography_4, t0.interest_areas AS interest_areas_5, t0.english_interest_areas AS english_interest_areas_6, t0.active AS active_7, t0.user_id AS user_id_8 FROM faculty t0 WHERE t0.user_id = ? LIMIT 1
SELECT t0.rut AS rut_1, t0.status AS status_2, t0.post AS post_3, t0.biography AS biography_4, t0.interest_areas AS interest_areas_5, t0.english_interest_areas AS english_interest_areas_6, t0.active AS active_7, t0.user_id AS user_id_8 FROM faculty t0 WHERE t0.user_id = 59 LIMIT 1;
|
0.50 ms (10.66%)
|
1 |
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.title AS title_3, t0.english_title AS english_title_4, t0.description AS description_5, t0.english_description AS english_description_6, t0.total_slots AS total_slots_7, t0.picture AS picture_8, t0.published_deadline AS published_deadline_9, t0.faculty_rut AS faculty_rut_10, t0.second_faculty_rut AS second_faculty_rut_11, t0.status_id AS status_id_12, t0.cod_curriculum_id AS cod_curriculum_id_13, t0.created_by_admin_id AS created_by_admin_id_14 FROM opportunity t0 WHERE t0.faculty_rut = ?
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.title AS title_3, t0.english_title AS english_title_4, t0.description AS description_5, t0.english_description AS english_description_6, t0.total_slots AS total_slots_7, t0.picture AS picture_8, t0.published_deadline AS published_deadline_9, t0.faculty_rut AS faculty_rut_10, t0.second_faculty_rut AS second_faculty_rut_11, t0.status_id AS status_id_12, t0.cod_curriculum_id AS cod_curriculum_id_13, t0.created_by_admin_id AS created_by_admin_id_14 FROM opportunity t0 WHERE t0.faculty_rut = 10862215;
|