Query Metrics
6
Database Queries
6
Different statements
91.96 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
38.47 ms (41.83%) |
1 |
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.phd_names AS phd_names_29, t14.nrc AS nrc_30, t14.alpha_score AS alpha_score_31, t14.numeric_score AS numeric_score_32, t14.grade_confirmed AS grade_confirmed_33, t14.special_authorization AS special_authorization_34, t14.special_authorization_date AS special_authorization_date_35, t14.application_id AS application_id_36, t14.student_id AS student_id_37, t14.oportunity_research_id AS oportunity_research_id_38, t14.report_id AS report_id_39, t14.responsible_mentor_id AS responsible_mentor_id_40, t14.rcer_submission_id AS rcer_submission_id_41, t0.state_id AS state_id_42 FROM application t0 LEFT JOIN research t14 ON t14.application_id = t0.id WHERE t0.oportunity_research_id = ?
Parameters:
[
2592
]
|
||||||||||||||||||||||||||||||||
|
18.31 ms (19.91%) |
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.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 = ?
Parameters:
[
676
]
|
||||||||||||||||||||||||||||||||
|
14.13 ms (15.37%) |
1 |
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 = ?
Parameters:
[
2592
]
|
||||||||||||||||||||||||||||||||
|
11.73 ms (12.75%) |
1 |
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.last_activity_date AS last_activity_date_17, t0.responsible_mentor_id AS responsible_mentor_id_18, t0.rcer_station_id AS rcer_station_id_19 FROM oportunity_research t0 WHERE t0.id = ?
Parameters:
[
"2592"
]
|
||||||||||||||||||||||||||||||||
|
4.82 ms (5.24%) |
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 = ? LIMIT 1
Parameters:
[
"apply-by-student"
]
|
||||||||||||||||||||||||||||||||
|
4.50 ms (4.90%) |
1 |
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 = ?
Parameters:
[
676
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\OportunityResearch | 1 |
| App\Entity\Mentor | 1 |
| App\Entity\User | 1 |
| App\Entity\Faculty | 1 |
| App\Entity\Affiliation | 1 |
| App\Entity\Setting | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\OportunityResearch | No errors. |
| App\Entity\Mentor | No errors. |
| App\Entity\RcerStation | No errors. |
| App\Entity\Keyword | No errors. |
| App\Entity\Visit | No errors. |
| App\Entity\Prerequisite | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\Research | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ExternalAcademicUnit | No errors. |
| App\Entity\Enterprise | No errors. |
| App\Entity\Faculty | No errors. |
| App\Entity\Affiliation | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\Other | No errors. |
| App\Entity\Student | No errors. |
| App\Entity\Major | No errors. |
| App\Entity\Restorer | No errors. |
| App\Entity\LoginLog | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\LogState | No errors. |
| App\Entity\Penalization | No errors. |
| App\Entity\Report | No errors. |
| App\Entity\RcerSubmission | No errors. |
| App\Entity\ApplicationState | No errors. |