GET https://stg.umem.org/event/conference/7687

Query Metrics

7 Database Queries
3 Different statements
2.55 ms Query time
1 Invalid entities

Queries

Group similar statements

umem connection

# Time Info
1 0.56 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:
[
  7687
]
2 0.70 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:
[
  7687
]
3 0.34 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:
[
  7691
]
4 0.30 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:
[
  7688
]
5 0.22 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:
[
  7689
]
6 0.22 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:
[
  7690
]
7 0.20 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:
[
  7692
]

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

Class Mapping errors
Umem\EventBundle\Entity\Event No errors.
Umem\EventBundle\Entity\Conference No errors.
Umem\EventBundle\Entity\EventLocation No errors.
Vich\UploaderBundle\Entity\File No errors.
Umem\EventBundle\Entity\EventFile No errors.
Umem\EventBundle\Entity\Lecture No errors.
Umem\EventBundle\Entity\LectureCategory No errors.
Umem\EventBundle\Entity\Speaker No errors.
Umem\EventBundle\Entity\LectureAttendance No errors.
Umem\EventBundle\Entity\Evaluation No errors.
Umem\AppBundle\Entity\ContactsAppAuth No errors.
Umem\AppBundle\Entity\MeetingDate No errors.
Umem\AppBundle\Entity\Perm No errors.
Umem\AppBundle\Entity\MeetingAttendance No errors.
Umem\AppBundle\Entity\PermSet No errors.
Umem\EmployeeBundle\Entity\Phone No errors.
Umem\EmployeeBundle\Entity\EmpSites No errors.
Umem\EmployeeBundle\Entity\BoardCertStatus No errors.
Umem\EmployeeBundle\Entity\Site No errors.
Umem\EmployeeBundle\Entity\FundingProfile No errors.
Umem\EmployeeBundle\Entity\SiteNetworkMap No errors.
Umem\EmployeeBundle\Entity\MailingListCriteria No errors.
Umem\EmployeeBundle\Entity\EmpBoardCert No errors.
Umem\EmployeeBundle\Entity\ProfFellowAssoc No errors.
Umem\EmployeeBundle\Entity\Degree No errors.
Umem\EmployeeBundle\Entity\PhoneVendor No errors.
Umem\EmployeeBundle\Entity\ContactMe No errors.
Umem\EmployeeBundle\Entity\Status No errors.
Umem\EmployeeBundle\Entity\Bio No errors.
Umem\EmployeeBundle\Entity\Employee No errors.
Umem\EmployeeBundle\Entity\EmpPhoto No errors.
Umem\EmployeeBundle\Entity\Address No errors.
Umem\EmployeeBundle\Entity\EmpStatus No errors.
Umem\EmployeeBundle\Entity\Education No errors.
Umem\EmployeeBundle\Entity\EduSubtype No errors.
Umem\EmployeeBundle\Entity\Email No errors.
Umem\EmployeeBundle\Entity\Citizenship No errors.
Umem\EmployeeBundle\Entity\TitleType No errors.
Umem\EmployeeBundle\Entity\PhoneType No errors.
Umem\EmployeeBundle\Entity\Gender No errors.
Umem\EmployeeBundle\Entity\Pref No errors.
Umem\EmployeeBundle\Entity\AddressType No errors.
Umem\EmployeeBundle\Entity\TitleSubtype No errors.
Umem\EmployeeBundle\Entity\EduType No errors.
Umem\EmployeeBundle\Entity\EmpTitle No errors.
Umem\EmployeeBundle\Entity\EmpProfAssoc No errors.
Umem\EmployeeBundle\Entity\BoardCertification No errors.
Umem\UserBundle\Entity\Track No errors.
Umem\UserBundle\Entity\Users No errors.
Umem\ContentBundle\Entity\RotationFile No errors.
Umem\ContentBundle\Entity\PhoneList No errors.
Umem\ContentBundle\Entity\RotationInfo No errors.
Umem\ContentBundle\Entity\PhoneCategory No errors.
Umem\ContentBundle\Entity\DynamicContent No errors.
Umem\ContentBundle\Entity\Faq No errors.
Umem\ContentBundle\Entity\BlogPost No errors.
Umem\ContentBundle\Entity\RotationContact No errors.
Umem\EducationBundle\Entity\Podcast No errors.
Umem\EducationBundle\Entity\Tag No errors.
Umem\EventBundle\Entity\EvaluationQuestion No errors.
Umem\EventBundle\Entity\OffsiteLecture No errors.
Umem\EventBundle\Entity\EvaluationTemplate No errors.
Umem\EventBundle\Entity\EmployeeIdCard No errors.
Umem\EventBundle\Entity\EvaluationArchive No errors.
Umem\EventBundle\Entity\EvaluationResponse No errors.
Umem\EventBundle\Entity\ExtraCredit No errors.
Umem\FileCollectionBundle\Entity\Category No errors.
Umem\FileCollectionBundle\Entity\File No errors.
Umem\FileCollectionBundle\Entity\FileCollection No errors.
Umem\PearlBundle\Entity\PearlCategory No errors.
Umem\PearlBundle\Entity\PearlFile No errors.
Umem\PearlBundle\Entity\Pearl No errors.
Umem\PearlBundle\Entity\PushToken No errors.
Umem\PearlBundle\Entity\Ads No errors.
Umem\UtilitiesBundle\Entity\Country No errors.
Umem\UtilitiesBundle\Entity\State No errors.
Umem\ResearchBundle\Entity\Investigator No errors.
Umem\ResearchBundle\Entity\ResearchStudy No errors.
Umem\ResearchBundle\Entity\PrincipalInvestigator No errors.
Umem\ResearchBundle\Entity\ResearchStatus No errors.
Umem\MedStudentBundle\Entity\Shift No errors.
Umem\MedStudentBundle\Entity\EvaluationType No errors.
Umem\MedStudentBundle\Entity\Evaluation No errors.
Umem\TimesheetBundle\Entity\ClinicalSchedule No errors.
Umem\TimesheetBundle\Entity\TrackerEvent No errors.
Umem\SurveyBundle\Entity\Response No errors.
Umem\SurveyBundle\Entity\Question No errors.

fabric entity manager

Class Mapping errors
Umem\FabricBundle\FabricEntity\StaffingModelLevel No errors.
Umem\FabricBundle\FabricEntity\StaffingModel
  • The field Umem\FabricBundle\FabricEntity\StaffingModel#levels is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Umem\FabricBundle\FabricEntity\StaffingModelLevel#model does not contain the required 'inversedBy="levels"' attribute.
Umem\FabricBundle\FabricEntity\StaffingModelWeight No errors.