Query Metrics
7
Database Queries
3
Different statements
5.08 ms
Query time
1
Invalid entities
Queries
umem connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.53 ms |
SELECT t1.id AS id_2, t1.title AS title_3, t1.description AS description_4, t1.location AS location_5, t1.notes AS notes_6, t1.start AS start_7, t1.duration AS duration_8, t1.public AS public_9, t1.created AS created_10, t1.created_by AS created_by_11, t1.updated AS updated_12, t1.updated_by AS updated_by_13, t0.active AS active_14, t1.event_location_id AS event_location_id_15, t1.dtype FROM conference t0 INNER JOIN event t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
7693
]
|
| 2 | 1.14 ms |
SELECT t1.id AS id_2, t1.title AS title_3, t1.description AS description_4, t1.location AS location_5, t1.notes AS notes_6, t1.start AS start_7, t1.duration AS duration_8, t1.public AS public_9, t1.created AS created_10, t1.created_by AS created_by_11, t1.updated AS updated_12, t1.updated_by AS updated_by_13, t0.objectives AS objectives_14, t0.grandrounds AS grandrounds_15, t0.financial_interest AS financial_interest_16, t0.attendance_flag AS attendance_flag_17, t0.video_url AS video_url_18, t0.video_url_livestream AS video_url_livestream_19, t0.audience_faculty AS audience_faculty_20, t0.audience_resident AS audience_resident_21, t0.audience_student AS audience_student_22, t0.attendance_required AS attendance_required_23, t0.credit_time AS credit_time_24, t0.faculty_extra AS faculty_extra_25, t1.event_location_id AS event_location_id_26, t0.conference_id AS conference_id_27, t0.category_id AS category_id_28, t1.dtype FROM lecture t0 INNER JOIN event t1 ON t0.id = t1.id WHERE t0.conference_id = ? ORDER BY t1.start ASC
Parameters:
[
7693
]
|
| 3 | 1.79 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = ?
Parameters:
[
7694
]
|
| 4 | 0.21 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = ?
Parameters:
[
7695
]
|
| 5 | 0.15 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = ?
Parameters:
[
7696
]
|
| 6 | 0.13 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = ?
Parameters:
[
7697
]
|
| 7 | 0.12 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = ?
Parameters:
[
7698
]
|
Database Connections
| Name | Service |
|---|---|
| umem | doctrine.dbal.umem_connection |
| mailman | doctrine.dbal.mailman_connection |
| moodle | doctrine.dbal.moodle_connection |
| fabric | doctrine.dbal.fabric_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| fabric | doctrine.orm.fabric_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
fabric entity manager
| Class | Mapping errors |
|---|---|
| Umem\FabricBundle\FabricEntity\StaffingModelLevel | No errors. |
| Umem\FabricBundle\FabricEntity\StaffingModel |
|
| Umem\FabricBundle\FabricEntity\StaffingModelWeight | No errors. |