Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.50 ms Query time

1 Invalid entities

Queries

Group similar statements

umem connection

#▲	Time	Info
1	0.50 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: [`"education/residency/required_rotations"`] View formatted query View runnable query Explain query 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 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 = 'education/residency/required_rotations' LIMIT 1;

#▲

Time

Info

0.50 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:

[
  "education/residency/required_rotations"
]

View formatted query View runnable query Explain query

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

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 = 'education/residency/required_rotations' LIMIT 1;

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\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\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\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\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.

Symfony Profiler

GET https://stg.umem.org/page/education/residency/required_rotations

Configuration Settings

Theme

Page Width

Query Metrics

Queries

umem connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

fabric entity manager