| 1 |
1.91 ms |
SELECT DISTINCT count(DISTINCT f0_.rut) AS sclr_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id
SELECT DISTINCT count(DISTINCT f0_.rut) AS sclr_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id;
|
| 2 |
1.11 ms |
SELECT DISTINCT f0_.rut AS rut_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id LIMIT 10 OFFSET 220
SELECT DISTINCT f0_.rut AS rut_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id LIMIT 10 OFFSET 220;
|
| 3 |
1.42 ms |
SELECT DISTINCT f0_.rut AS rut_0, f0_.status AS status_1, f0_.post AS post_2, f0_.biography AS biography_3, f0_.interest_areas AS interest_areas_4, f0_.english_interest_areas AS english_interest_areas_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.deactivated_notifications AS deactivated_notifications_10, u1_.sex AS sex_11, u1_.rut AS rut_12, u1_.name AS name_13, u1_.last_name AS last_name_14, u1_.phone AS phone_15, u1_.picture AS picture_16, u1_.reset_token AS reset_token_17, u1_.reset_token_expires_at AS reset_token_expires_at_18, d2_.id AS id_19, d2_.department AS department_20, d2_.english_name AS english_name_21, r3_.id AS id_22, r3_.area AS area_23, r3_.english_name AS english_name_24, r3_.cod_curriculum AS cod_curriculum_25, r3_.cod_param_77_vig AS cod_param_77_vig_26, r4_.id AS id_27, r4_.line AS line_28, r4_.english_name AS english_name_29, r4_.description AS description_30, f0_.user_id AS user_id_31, u1_.administrativo_asignado_id AS administrativo_asignado_id_32, f5_.faculty_rut AS faculty_rut_33, f5_.position_id AS position_id_34, f5_.department_id AS department_id_35, r4_.area_id AS area_id_36, r4_.department_id AS department_id_37 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN department d2_ ON f5_.department_id = d2_.id LEFT JOIN faculty_research_area f6_ ON f0_.rut = f6_.faculty_rut LEFT JOIN research_area r3_ ON r3_.id = f6_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r4_ ON r4_.id = f7_.research_line_id WHERE f0_.rut IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
21518458
23385478
24671029
24914938
25046023
25085795
25238700
25294384
25442481
26159159
]
SELECT
DISTINCT f0_.rut AS rut_0,
f0_.status AS status_1,
f0_.post AS post_2,
f0_.biography AS biography_3,
f0_.interest_areas AS interest_areas_4,
f0_.english_interest_areas AS english_interest_areas_5,
u1_.id AS id_6,
u1_.email AS email_7,
u1_.roles AS roles_8,
u1_.password AS password_9,
u1_.deactivated_notifications AS deactivated_notifications_10,
u1_.sex AS sex_11,
u1_.rut AS rut_12,
u1_.name AS name_13,
u1_.last_name AS last_name_14,
u1_.phone AS phone_15,
u1_.picture AS picture_16,
u1_.reset_token AS reset_token_17,
u1_.reset_token_expires_at AS reset_token_expires_at_18,
d2_.id AS id_19,
d2_.department AS department_20,
d2_.english_name AS english_name_21,
r3_.id AS id_22,
r3_.area AS area_23,
r3_.english_name AS english_name_24,
r3_.cod_curriculum AS cod_curriculum_25,
r3_.cod_param_77_vig AS cod_param_77_vig_26,
r4_.id AS id_27,
r4_.line AS line_28,
r4_.english_name AS english_name_29,
r4_.description AS description_30,
f0_.user_id AS user_id_31,
u1_.administrativo_asignado_id AS administrativo_asignado_id_32,
f5_.faculty_rut AS faculty_rut_33,
f5_.position_id AS position_id_34,
f5_.department_id AS department_id_35,
r4_.area_id AS area_id_36,
r4_.department_id AS department_id_37
FROM
faculty f0_
LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id
LEFT JOIN faculty_assignment f5_ ON f0_.rut = f5_.faculty_rut
LEFT JOIN department d2_ ON f5_.department_id = d2_.id
LEFT JOIN faculty_research_area f6_ ON f0_.rut = f6_.faculty_rut
LEFT JOIN research_area r3_ ON r3_.id = f6_.research_area_id
LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut
LEFT JOIN research_line r4_ ON r4_.id = f7_.research_line_id
WHERE
f0_.rut IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT DISTINCT f0_.rut AS rut_0, f0_.status AS status_1, f0_.post AS post_2, f0_.biography AS biography_3, f0_.interest_areas AS interest_areas_4, f0_.english_interest_areas AS english_interest_areas_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.deactivated_notifications AS deactivated_notifications_10, u1_.sex AS sex_11, u1_.rut AS rut_12, u1_.name AS name_13, u1_.last_name AS last_name_14, u1_.phone AS phone_15, u1_.picture AS picture_16, u1_.reset_token AS reset_token_17, u1_.reset_token_expires_at AS reset_token_expires_at_18, d2_.id AS id_19, d2_.department AS department_20, d2_.english_name AS english_name_21, r3_.id AS id_22, r3_.area AS area_23, r3_.english_name AS english_name_24, r3_.cod_curriculum AS cod_curriculum_25, r3_.cod_param_77_vig AS cod_param_77_vig_26, r4_.id AS id_27, r4_.line AS line_28, r4_.english_name AS english_name_29, r4_.description AS description_30, f0_.user_id AS user_id_31, u1_.administrativo_asignado_id AS administrativo_asignado_id_32, f5_.faculty_rut AS faculty_rut_33, f5_.position_id AS position_id_34, f5_.department_id AS department_id_35, r4_.area_id AS area_id_36, r4_.department_id AS department_id_37 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN department d2_ ON f5_.department_id = d2_.id LEFT JOIN faculty_research_area f6_ ON f0_.rut = f6_.faculty_rut LEFT JOIN research_area r3_ ON r3_.id = f6_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r4_ ON r4_.id = f7_.research_line_id WHERE f0_.rut IN (21518458, 23385478, 24671029, 24914938, 25046023, 25085795, 25238700, 25294384, 25442481, 26159159);
|
| 4 |
0.48 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 300;
|
| 5 |
0.38 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 300;
|
| 6 |
0.28 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 301;
|
| 7 |
0.25 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 301;
|
| 8 |
0.23 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 302;
|
| 9 |
0.20 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 302;
|
| 10 |
0.20 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 303;
|
| 11 |
0.20 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 303;
|
| 12 |
0.68 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 304;
|
| 13 |
0.48 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 304;
|
| 14 |
0.35 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 305;
|
| 15 |
0.39 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 305;
|
| 16 |
0.42 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 306;
|
| 17 |
0.63 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 306;
|
| 18 |
0.33 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 307;
|
| 19 |
0.44 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 307;
|
| 20 |
0.46 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 308;
|
| 21 |
0.30 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 308;
|
| 22 |
0.45 ms |
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.user_id AS user_id_4, t0.cod_pais AS cod_pais_5, t0.cod_universidad AS cod_universidad_6 FROM applicant t0 WHERE t0.user_id = 309;
|
| 23 |
0.35 ms |
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = ?
SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.comment AS comment_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.career AS career_7, t0.curriculum AS curriculum_8, t0.applicant_id AS applicant_id_9, t0.opportunity_id AS opportunity_id_10, t0.cod_universidad AS cod_universidad_11, t0.cod_pais AS cod_pais_12 FROM application t0 WHERE t0.applicant_id = 309;
|
| 24 |
0.82 ms |
SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2 FROM department d0_ ORDER BY d0_.department ASC
SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2 FROM department d0_ ORDER BY d0_.department ASC;
|
| 25 |
0.83 ms |
SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_curriculum AS cod_curriculum_3, r0_.cod_param_77_vig AS cod_param_77_vig_4 FROM research_area r0_ ORDER BY r0_.area ASC
SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_curriculum AS cod_curriculum_3, r0_.cod_param_77_vig AS cod_param_77_vig_4 FROM research_area r0_ ORDER BY r0_.area ASC;
|
| 26 |
1.29 ms |
SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.area_id AS area_id_4, r0_.department_id AS department_id_5 FROM research_line r0_ ORDER BY r0_.line ASC
SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.area_id AS area_id_4, r0_.department_id AS department_id_5 FROM research_line r0_ ORDER BY r0_.line ASC;
|
| 27 |
0.49 ms |
SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.opportunity_type_id AS opportunity_type_id_2 FROM cod_curriculum c0_ ORDER BY c0_.nom_curriculum ASC
SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.opportunity_type_id AS opportunity_type_id_2 FROM cod_curriculum c0_ ORDER BY c0_.nom_curriculum ASC;
|