Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.path AS path_4,
  t0.visible AS visible_5,
  t0.roles AS roles_6,
  t0.downloadable AS downloadable_7
FROM
  information_tab t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.path AS path_4, t0.visible AS visible_5, t0.roles AS roles_6, t0.downloadable AS downloadable_7 FROM information_tab t0;

SELECT
  t0.id AS id_1,
  t0.application_date AS application_date_2,
  t0.last_update_date AS last_update_date_3,
  t0.authorized_by_letter AS authorized_by_letter_4,
  t0.banner_authorization_date AS banner_authorization_date_5,
  t0.comments AS comments_6,
  t0.numbers_code AS numbers_code_7,
  t0.initials_code AS initials_code_8,
  t0.class_name AS class_name_9,
  t0.motivation_letter AS motivation_letter_10,
  t0.student_year AS student_year_11,
  t0.student_id AS student_id_12,
  t0.oportunity_research_id AS oportunity_research_id_13,
  t14.id AS id_15,
  t14.initials_code AS initials_code_16,
  t14.numbers_code AS numbers_code_17,
  t14.semester AS semester_18,
  t14.academic_year AS academic_year_19,
  t14.class_name AS class_name_20,
  t14.section AS section_21,
  t14.creation_date AS creation_date_22,
  t14.creation_date_op AS creation_date_op_23,
  t14.name_op AS name_op_24,
  t14.cmd AS cmd_25,
  t14.credits AS credits_26,
  t14.description_op AS description_op_27,
  t14.modality_op AS modality_op_28,
  t14.nrc AS nrc_29,
  t14.alpha_score AS alpha_score_30,
  t14.numeric_score AS numeric_score_31,
  t14.application_id AS application_id_32,
  t14.student_id AS student_id_33,
  t14.oportunity_research_id AS oportunity_research_id_34,
  t14.report_id AS report_id_35,
  t14.responsible_mentor_id AS responsible_mentor_id_36,
  t14.rcer_submission_id AS rcer_submission_id_37,
  t0.state_id AS state_id_38
FROM
  application t0
  LEFT JOIN research t14 ON t14.application_id = t0.id
WHERE
  t0.oportunity_research_id = ?

SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.last_update_date AS last_update_date_3, t0.authorized_by_letter AS authorized_by_letter_4, t0.banner_authorization_date AS banner_authorization_date_5, t0.comments AS comments_6, t0.numbers_code AS numbers_code_7, t0.initials_code AS initials_code_8, t0.class_name AS class_name_9, t0.motivation_letter AS motivation_letter_10, t0.student_year AS student_year_11, t0.student_id AS student_id_12, t0.oportunity_research_id AS oportunity_research_id_13, t14.id AS id_15, t14.initials_code AS initials_code_16, t14.numbers_code AS numbers_code_17, t14.semester AS semester_18, t14.academic_year AS academic_year_19, t14.class_name AS class_name_20, t14.section AS section_21, t14.creation_date AS creation_date_22, t14.creation_date_op AS creation_date_op_23, t14.name_op AS name_op_24, t14.cmd AS cmd_25, t14.credits AS credits_26, t14.description_op AS description_op_27, t14.modality_op AS modality_op_28, t14.nrc AS nrc_29, t14.alpha_score AS alpha_score_30, t14.numeric_score AS numeric_score_31, t14.application_id AS application_id_32, t14.student_id AS student_id_33, t14.oportunity_research_id AS oportunity_research_id_34, t14.report_id AS report_id_35, t14.responsible_mentor_id AS responsible_mentor_id_36, t14.rcer_submission_id AS rcer_submission_id_37, t0.state_id AS state_id_38 FROM application t0 LEFT JOIN research t14 ON t14.application_id = t0.id WHERE t0.oportunity_research_id = 1125;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.uses_rubric AS uses_rubric_3,
  t0.comments AS comments_4,
  t0.discount AS discount_5,
  t0.research_id AS research_id_6,
  t0.evaluator_id AS evaluator_id_7
FROM
  evaluation t0
WHERE
  t0.research_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.uses_rubric AS uses_rubric_3, t0.comments AS comments_4, t0.discount AS discount_5, t0.research_id AS research_id_6, t0.evaluator_id AS evaluator_id_7 FROM evaluation t0 WHERE t0.research_id = 2335;

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.enabled AS enabled_12,
  t13.id AS id_14,
  t13.description AS description_15,
  t13.user_id AS user_id_16,
  t13.affiliation_id AS affiliation_id_17,
  t18.id AS id_19,
  t18.user_id AS user_id_20,
  t18.external_academic_unit_id AS external_academic_unit_id_21,
  t18.enterprise_id AS enterprise_id_22,
  t18.faculty_id AS faculty_id_23,
  t18.affiliation_id AS affiliation_id_24,
  t25.id AS id_26,
  t25.user_id AS user_id_27,
  t25.external_academic_unit_id AS external_academic_unit_id_28,
  t25.enterprise_id AS enterprise_id_29,
  t25.faculty_id AS faculty_id_30,
  t25.affiliation_id AS affiliation_id_31,
  t25.major_id AS major_id_32,
  t33.id AS id_34,
  t33.time AS time_35,
  t33.auth AS auth_36,
  t33.user_id AS user_id_37
FROM
  `user` t0
  LEFT JOIN other t13 ON t13.user_id = t0.id
  LEFT JOIN mentor t18 ON t18.user_id = t0.id
  LEFT JOIN student t25 ON t25.user_id = t0.id
  LEFT JOIN restorer t33 ON t33.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.enabled AS enabled_12, t13.id AS id_14, t13.description AS description_15, t13.user_id AS user_id_16, t13.affiliation_id AS affiliation_id_17, t18.id AS id_19, t18.user_id AS user_id_20, t18.external_academic_unit_id AS external_academic_unit_id_21, t18.enterprise_id AS enterprise_id_22, t18.faculty_id AS faculty_id_23, t18.affiliation_id AS affiliation_id_24, t25.id AS id_26, t25.user_id AS user_id_27, t25.external_academic_unit_id AS external_academic_unit_id_28, t25.enterprise_id AS enterprise_id_29, t25.faculty_id AS faculty_id_30, t25.affiliation_id AS affiliation_id_31, t25.major_id AS major_id_32, t33.id AS id_34, t33.time AS time_35, t33.auth AS auth_36, t33.user_id AS user_id_37 FROM `user` t0 LEFT JOIN other t13 ON t13.user_id = t0.id LEFT JOIN mentor t18 ON t18.user_id = t0.id LEFT JOIN student t25 ON t25.user_id = t0.id LEFT JOIN restorer t33 ON t33.user_id = t0.id WHERE t0.id = 680;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.external_academic_unit_id AS external_academic_unit_id_3,
  t0.enterprise_id AS enterprise_id_4,
  t0.faculty_id AS faculty_id_5,
  t0.affiliation_id AS affiliation_id_6
FROM
  mentor t0
  INNER JOIN oportunity_research_mentor ON t0.id = oportunity_research_mentor.mentor_id
WHERE
  oportunity_research_mentor.oportunity_research_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.external_academic_unit_id AS external_academic_unit_id_3, t0.enterprise_id AS enterprise_id_4, t0.faculty_id AS faculty_id_5, t0.affiliation_id AS affiliation_id_6 FROM mentor t0 INNER JOIN oportunity_research_mentor ON t0.id = oportunity_research_mentor.mentor_id WHERE oportunity_research_mentor.oportunity_research_id = 1125;

SELECT
  t0.id AS id_1,
  t0.published_deadline AS published_deadline_2,
  t0.use_published_deadline AS use_published_deadline_3,
  t0.creation_date AS creation_date_4,
  t0.name AS name_5,
  t0.english_name AS english_name_6,
  t0.description AS description_7,
  t0.english_description AS english_description_8,
  t0.phd_names AS phd_names_9,
  t0.public AS public_10,
  t0.credits AS credits_11,
  t0.modality AS modality_12,
  t0.vacants AS vacants_13,
  t0.cmd AS cmd_14,
  t0.hidden AS hidden_15,
  t0.rcer AS rcer_16,
  t0.responsible_mentor_id AS responsible_mentor_id_17,
  t0.rcer_station_id AS rcer_station_id_18
FROM
  oportunity_research t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.published_deadline AS published_deadline_2, t0.use_published_deadline AS use_published_deadline_3, t0.creation_date AS creation_date_4, t0.name AS name_5, t0.english_name AS english_name_6, t0.description AS description_7, t0.english_description AS english_description_8, t0.phd_names AS phd_names_9, t0.public AS public_10, t0.credits AS credits_11, t0.modality AS modality_12, t0.vacants AS vacants_13, t0.cmd AS cmd_14, t0.hidden AS hidden_15, t0.rcer AS rcer_16, t0.responsible_mentor_id AS responsible_mentor_id_17, t0.rcer_station_id AS rcer_station_id_18 FROM oportunity_research t0 WHERE t0.id = '1125';

SELECT
  t0.id AS id_1,
  t0.keyword AS keyword_2
FROM
  keyword t0
  INNER JOIN oportunity_research_keyword ON t0.id = oportunity_research_keyword.keyword_id
WHERE
  oportunity_research_keyword.oportunity_research_id = ?

SELECT t0.id AS id_1, t0.keyword AS keyword_2 FROM keyword t0 INNER JOIN oportunity_research_keyword ON t0.id = oportunity_research_keyword.keyword_id WHERE oportunity_research_keyword.oportunity_research_id = 1125;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.value_type AS value_type_5
FROM
  setting t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.value AS value_3, t0.description AS description_4, t0.value_type AS value_type_5 FROM setting t0 WHERE t0.code = 'apply-by-student' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.step AS step_2,
  t0.text AS text_3,
  t0.next_step_description AS next_step_description_4,
  t0.deprecated AS deprecated_5,
  t0.vacancy_consuming AS vacancy_consuming_6
FROM
  application_state t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.step AS step_2, t0.text AS text_3, t0.next_step_description AS next_step_description_4, t0.deprecated AS deprecated_5, t0.vacancy_consuming AS vacancy_consuming_6 FROM application_state t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.course_number AS course_number_2
FROM
  prerequisite t0
  INNER JOIN oportunity_research_prerequisite ON t0.id = oportunity_research_prerequisite.prerequisite_id
WHERE
  oportunity_research_prerequisite.oportunity_research_id = ?

SELECT t0.id AS id_1, t0.course_number AS course_number_2 FROM prerequisite t0 INNER JOIN oportunity_research_prerequisite ON t0.id = oportunity_research_prerequisite.prerequisite_id WHERE oportunity_research_prerequisite.oportunity_research_id = 1125;

SELECT
  t0.id AS id_1,
  t0.creation_date AS creation_date_2,
  t0.active AS active_3,
  t0.comments AS comments_4,
  t0.research_id AS research_id_5,
  t0.user_id AS user_id_6
FROM
  penalization t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.active AS active_3, t0.comments AS comments_4, t0.research_id AS research_id_5, t0.user_id AS user_id_6 FROM penalization t0 WHERE t0.user_id = 680;