GET https://stg.umem.org/

Query Metrics

3 Database Queries
3 Different statements
8.51 ms Query time
1 Invalid entities

Queries

Group similar statements

umem connection

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.sidebar AS sidebar_5, t0.publish AS publish_6, t0.authors AS authors_7, t0.url_slug AS url_slug_8, t0.created_by AS created_by_9, t0.created AS created_10, t0.updated_by AS updated_by_11, t0.updated AS updated_12, t0.alternate_template AS alternate_template_13, t0.secure AS secure_14 FROM dynamic_content t0 WHERE t0.url_slug = ? LIMIT 1
Parameters:
[
  "department/chairmans_welcome"
]
2 1.07 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.body AS body_2, b0_.post_date AS post_date_3, b0_.posted_by AS posted_by_4, b0_.created AS created_5, b0_.created_by AS created_by_6, b0_.modified AS modified_7, b0_.modified_by AS modified_by_8, b0_.posted_by AS posted_by_9 FROM blog_post b0_ WHERE b0_.post_date <= CURRENT_DATE ORDER BY b0_.post_date DESC LIMIT 3
Parameters:
[]
3 6.91 ms
SELECT p0_.pearl_index AS pearl_index_0, p0_.pearl_title AS pearl_title_1, p0_.pearl_author AS pearl_author_2, p0_.pearl_category AS pearl_category_3, p0_.pearl_audience AS pearl_audience_4, p0_.pearl_message AS pearl_message_5, p0_.pearl_timestamp AS pearl_timestamp_6, p0_.pearl_emailed AS pearl_emailed_7, p0_.pearl_keywords AS pearl_keywords_8, p0_.pearl_reference AS pearl_reference_9, p0_.pearl_active AS pearl_active_10, p0_.pearl_updated AS pearl_updated_11, p0_.pearl_preview AS pearl_preview_12, p0_.pearl_visualdiagnosis_flag AS pearl_visualdiagnosis_flag_13, p0_.pearl_visualdiagnosis_text AS pearl_visualdiagnosis_text_14, p0_.format AS format_15, p0_.pearl_author AS pearl_author_16, p0_.pearl_category AS pearl_category_17 FROM pearl p0_ WHERE p0_.pearl_active = 1 ORDER BY p0_.pearl_emailed DESC LIMIT 5
Parameters:
[]

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\ContentBundle\Entity\DynamicContent No errors.
Umem\ContentBundle\Entity\BlogPost No errors.
Umem\EmployeeBundle\Entity\Employee No errors.
Umem\PearlBundle\Entity\Pearl No errors.
Umem\PearlBundle\Entity\PearlCategory No errors.
Umem\PearlBundle\Entity\PearlFile No errors.
Umem\UserBundle\Entity\Users No errors.
Umem\EmployeeBundle\Entity\Email No errors.
Umem\EmployeeBundle\Entity\Address No errors.
Umem\EmployeeBundle\Entity\Phone No errors.
Umem\EmployeeBundle\Entity\Citizenship No errors.
Umem\EmployeeBundle\Entity\Gender No errors.
Umem\EmployeeBundle\Entity\EmpStatus No errors.
Umem\EmployeeBundle\Entity\EmpSites No errors.
Umem\EmployeeBundle\Entity\EmpTitle No errors.
Umem\EmployeeBundle\Entity\EmpProfAssoc No errors.
Umem\EmployeeBundle\Entity\EmpBoardCert No errors.
Umem\EmployeeBundle\Entity\EmpPhoto No errors.
Umem\EmployeeBundle\Entity\Education No errors.
Umem\EmployeeBundle\Entity\Pref No errors.
Umem\AppBundle\Entity\Perm No errors.
Umem\EmployeeBundle\Entity\Bio No errors.
Umem\UserBundle\Entity\Track No errors.
Umem\EducationBundle\Entity\Podcast No errors.
Umem\MedStudentBundle\Entity\Evaluation No errors.
Umem\EmployeeBundle\Entity\FundingProfile No errors.
Umem\AppBundle\Entity\ContactsAppAuth No errors.
Umem\AppBundle\Entity\MeetingDate No errors.
Umem\AppBundle\Entity\MeetingAttendance No errors.
Umem\AppBundle\Entity\PermSet No errors.
Umem\EmployeeBundle\Entity\Site No errors.
Umem\EmployeeBundle\Entity\AddressType No errors.
Umem\EmployeeBundle\Entity\PhoneType No errors.
Umem\EmployeeBundle\Entity\PhoneVendor No errors.
Umem\EmployeeBundle\Entity\Status No errors.
Umem\EmployeeBundle\Entity\TitleType No errors.
Umem\EmployeeBundle\Entity\TitleSubtype No errors.
Umem\EmployeeBundle\Entity\ProfFellowAssoc No errors.
Umem\EmployeeBundle\Entity\BoardCertification No errors.
Umem\EmployeeBundle\Entity\BoardCertStatus No errors.
Umem\EmployeeBundle\Entity\EduType No errors.
Umem\EmployeeBundle\Entity\EduSubtype No errors.
Umem\EmployeeBundle\Entity\Degree No errors.
Umem\EmployeeBundle\Entity\SiteNetworkMap No errors.
Umem\EmployeeBundle\Entity\MailingListCriteria No errors.
Umem\EmployeeBundle\Entity\ContactMe 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\Faq No errors.
Umem\ContentBundle\Entity\RotationContact No errors.
Umem\EducationBundle\Entity\Tag No errors.
Umem\EventBundle\Entity\EvaluationQuestion No errors.
Umem\EventBundle\Entity\Event No errors.
Umem\EventBundle\Entity\OffsiteLecture No errors.
Umem\EventBundle\Entity\EventLocation No errors.
Umem\EventBundle\Entity\EvaluationTemplate No errors.
Umem\EventBundle\Entity\Speaker No errors.
Umem\EventBundle\Entity\EmployeeIdCard No errors.
Umem\EventBundle\Entity\EvaluationArchive No errors.
Umem\EventBundle\Entity\LectureCategory No errors.
Umem\EventBundle\Entity\LectureAttendance No errors.
Umem\EventBundle\Entity\EvaluationResponse No errors.
Umem\EventBundle\Entity\Conference No errors.
Umem\EventBundle\Entity\Evaluation No errors.
Umem\EventBundle\Entity\Lecture No errors.
Umem\EventBundle\Entity\ExtraCredit No errors.
Vich\UploaderBundle\Entity\File No errors.
Umem\EventBundle\Entity\EventFile No errors.
Umem\FileCollectionBundle\Entity\Category No errors.
Umem\FileCollectionBundle\Entity\File No errors.
Umem\FileCollectionBundle\Entity\FileCollection No errors.
Umem\PearlBundle\Entity\PushToken No errors.
Umem\PearlBundle\Entity\Ads No errors.
Umem\UtilitiesBundle\Entity\State No errors.
Umem\UtilitiesBundle\Entity\Country 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\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.