Query Metrics
16
Database Queries
8
Different statements
208.66 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
93.76 ms (44.94%) |
9 |
SELECT t0.id AS id_1, t0.maxIdleTime AS maxidletime_2, t0.environment AS environment_3, t0.version AS version_4, t0.siteEmail AS siteemail_5, t0.dbServerAddress AS dbserveraddress_6, t0.dbServerPort AS dbserverport_7, t0.dbServerAccountUserName AS dbserveraccountusername_8, t0.dbServerAccountPassword AS dbserveraccountpassword_9, t0.dbDatabaseName AS dbdatabasename_10, t0.smtpServerAddress AS smtpserveraddress_11, t0.mailerTransport AS mailertransport_12, t0.mailerAuthMode AS mailerauthmode_13, t0.mailerUseSecureConnection AS mailerusesecureconnection_14, t0.mailerUser AS maileruser_15, t0.mailerPassword AS mailerpassword_16, t0.mailerPort AS mailerport_17, t0.mailerSpool AS mailerspool_18, t0.mailerFlushQueueFrequency AS mailerflushqueuefrequency_19, t0.mailerDeliveryAddresses AS mailerdeliveryaddresses_20, t0.ldapAll AS ldapall_21, t0.aDLDAPServerAddress AS adldapserveraddress_22, t0.aDLDAPServerPort AS adldapserverport_23, t0.aDLDAPServerOu AS adldapserverou_24, t0.aDLDAPServerAccountUserName AS adldapserveraccountusername_25, t0.aDLDAPServerAccountPassword AS adldapserveraccountpassword_26, t0.ldapExePath AS ldapexepath_27, t0.ldapExeFilename AS ldapexefilename_28, t0.ldapMapperEmail AS ldapmapperemail_29, t0.aDLDAPServerAddress2 AS adldapserveraddress2_30, t0.aDLDAPServerPort2 AS adldapserverport2_31, t0.aDLDAPServerOu2 AS adldapserverou2_32, t0.aDLDAPServerAccountUserName2 AS adldapserveraccountusername2_33, t0.aDLDAPServerAccountPassword2 AS adldapserveraccountpassword2_34, t0.ldapExePath2 AS ldapexepath2_35, t0.ldapExeFilename2 AS ldapexefilename2_36, t0.ldapMapperEmail2 AS ldapmapperemail2_37, t0.enableAutoAssignmentInstitutionalScope AS enableautoassignmentinstitutionalscope_38, t0.pacsvendorSlideManagerDBServerAddress AS pacsvendorslidemanagerdbserveraddress_39, t0.pacsvendorSlideManagerDBServerPort AS pacsvendorslidemanagerdbserverport_40, t0.pacsvendorSlideManagerDBUserName AS pacsvendorslidemanagerdbusername_41, t0.pacsvendorSlideManagerDBPassword AS pacsvendorslidemanagerdbpassword_42, t0.pacsvendorSlideManagerDBName AS pacsvendorslidemanagerdbname_43, t0.institutionurl AS institutionurl_44, t0.institutionname AS institutionname_45, t0.departmenturl AS departmenturl_46, t0.departmentname AS departmentname_47, t0.subinstitutionurl AS subinstitutionurl_48, t0.subinstitutionname AS subinstitutionname_49, t0.showCopyrightOnFooter AS showcopyrightonfooter_50, t0.maintenance AS maintenance_51, t0.maintenanceenddate AS maintenanceenddate_52, t0.maintenancelogoutmsg AS maintenancelogoutmsg_53, t0.maintenanceloginmsg AS maintenanceloginmsg_54, t0.globalNoteLogin AS globalnotelogin_55, t0.scanuploadpath AS scanuploadpath_56, t0.employeesuploadpath AS employeesuploadpath_57, t0.avataruploadpath AS avataruploadpath_58, t0.fellappuploadpath AS fellappuploadpath_59, t0.resappuploadpath AS resappuploadpath_60, t0.vacrequploadpath AS vacrequploadpath_61, t0.transresuploadpath AS transresuploadpath_62, t0.callloguploadpath AS callloguploadpath_63, t0.crnuploadpath AS crnuploadpath_64, t0.mainHomeTitle AS mainhometitle_65, t0.listManagerTitle AS listmanagertitle_66, t0.eventLogTitle AS eventlogtitle_67, t0.siteSettingsTitle AS sitesettingstitle_68, t0.contentAboutPage AS contentaboutpage_69, t0.underLoginMsgUser AS underloginmsguser_70, t0.underLoginMsgScan AS underloginmsgscan_71, t0.backupUpdateDatetimeFellApp AS backupupdatedatetimefellapp_72, t0.libreOfficeConvertToPDFPathFellApp AS libreofficeconverttopdfpathfellapp_73, t0.libreOfficeConvertToPDFPathFellAppLinux AS libreofficeconverttopdfpathfellapplinux_74, t0.libreOfficeConvertToPDFFilenameFellApp AS libreofficeconverttopdffilenamefellapp_75, t0.libreOfficeConvertToPDFFilenameFellAppLinux AS libreofficeconverttopdffilenamefellapplinux_76, t0.libreOfficeConvertToPDFArgumentsdFellApp AS libreofficeconverttopdfargumentsdfellapp_77, t0.libreOfficeConvertToPDFArgumentsdFellAppLinux AS libreofficeconverttopdfargumentsdfellapplinux_78, t0.pdftkPathFellApp AS pdftkpathfellapp_79, t0.pdftkPathFellAppLinux AS pdftkpathfellapplinux_80, t0.pdftkFilenameFellApp AS pdftkfilenamefellapp_81, t0.pdftkFilenameFellAppLinux AS pdftkfilenamefellapplinux_82, t0.pdftkArgumentsFellApp AS pdftkargumentsfellapp_83, t0.pdftkArgumentsFellAppLinux AS pdftkargumentsfellapplinux_84, t0.gsPathFellApp AS gspathfellapp_85, t0.gsPathFellAppLinux AS gspathfellapplinux_86, t0.gsFilenameFellApp AS gsfilenamefellapp_87, t0.gsFilenameFellAppLinux AS gsfilenamefellapplinux_88, t0.gsArgumentsFellApp AS gsargumentsfellapp_89, t0.gsArgumentsFellAppLinux AS gsargumentsfellapplinux_90, t0.wkhtmltopdfpath AS wkhtmltopdfpath_91, t0.wkhtmltopdfpathLinux AS wkhtmltopdfpathlinux_92, t0.phantomjs AS phantomjs_93, t0.phantomjsLinux AS phantomjslinux_94, t0.rasterize AS rasterize_95, t0.rasterizeLinux AS rasterizelinux_96, t0.lisDBServerAddress AS lisdbserveraddress_97, t0.lisDBServerPort AS lisdbserverport_98, t0.lisDBAccountUserName AS lisdbaccountusername_99, t0.lisDBAccountPassword AS lisdbaccountpassword_100, t0.lisDBName AS lisdbname_101, t0.lisName AS lisname_102, t0.lisVersion AS lisversion_103, t0.lisDBServerAddressTest AS lisdbserveraddresstest_104, t0.lisDBServerPortTest AS lisdbserverporttest_105, t0.lisDBAccountUserNameTest AS lisdbaccountusernametest_106, t0.lisDBAccountPasswordTest AS lisdbaccountpasswordtest_107, t0.lisDBNameTest AS lisdbnametest_108, t0.LISNameTest AS lisnametest_109, t0.LISVersionTest AS lisversiontest_110, t0.lisDBServerAddressDevelopment AS lisdbserveraddressdevelopment_111, t0.lisDBServerPortDevelopment AS lisdbserverportdevelopment_112, t0.lisDBAccountUserNameDevelopment AS lisdbaccountusernamedevelopment_113, t0.lisDBAccountPasswordDevelopment AS lisdbaccountpassworddevelopment_114, t0.lisDBNameDevelopment AS lisdbnamedevelopment_115, t0.LISNameDevelopment AS lisnamedevelopment_116, t0.LISVersionDevelopment AS lisversiondevelopment_117, t0.academicYearStart AS academicyearstart_118, t0.academicYearEnd AS academicyearend_119, t0.liveSiteRootUrl AS livesiterooturl_120, t0.enableMetaphone AS enablemetaphone_121, t0.pathMetaphone AS pathmetaphone_122, t0.initialConfigurationCompleted AS initialconfigurationcompleted_123, t0.networkDrivePath AS networkdrivepath_124, t0.permittedFailedLoginAttempt AS permittedfailedloginattempt_125, t0.captchaSiteKey AS captchasitekey_126, t0.captchaSecretKey AS captchasecretkey_127, t0.captchaEnabled AS captchaenabled_128, t0.noticeAttemptingPasswordResetLDAP AS noticeattemptingpasswordresetldap_129, t0.loginInstruction AS logininstruction_130, t0.noticeSignUpNoCwid AS noticesignupnocwid_131, t0.noticeHasLdapAccount AS noticehasldapaccount_132, t0.noticeLdapName AS noticeldapname_133, t0.calllogResources AS calllogresources_134, t0.logoWidth AS logowidth_135, t0.logoHeight AS logoheight_136, t0.connectionChannel AS connectionchannel_137, t0.urlConnectionChannel AS urlconnectionchannel_138, t0.transresProjectSelectionNote AS transresprojectselectionnote_139, t0.transresHumanSubjectName AS transreshumansubjectname_140, t0.transresAnimalSubjectName AS transresanimalsubjectname_141, t0.transresBusinessEntityName AS transresbusinessentityname_142, t0.transresBusinessEntityAbbreviation AS transresbusinessentityabbreviation_143, t0.emailCriticalError AS emailcriticalerror_144, t0.restartServerErrorCounter AS restartservererrorcounter_145, t0.remoteAccessUrl AS remoteaccessurl_146, t0.externalMonitorUrl AS externalmonitorurl_147, t0.monitorScript AS monitorscript_148, t0.monitorCheckInterval AS monitorcheckinterval_149, t0.sendEmailUserAdded AS sendemailuseradded_150, t0.dbBackupConfig AS dbbackupconfig_151, t0.filesBackupConfig AS filesbackupconfig_152, t0.secretKey AS secretkey_153, t0.instanceId AS instanceid_154, t0.showTenantsHomepage AS showtenantshomepage_155, t0.defaultPrimaryPublicUserIdType_id AS defaultprimarypublicuseridtype_id_156, t0.ldapMapperPrimaryPublicUserIdType_id AS ldapmapperprimarypublicuseridtype_id_157, t0.ldapMapperPrimaryPublicUserIdType2_id AS ldapmapperprimarypublicuseridtype2_id_158, t0.autoAssignInstitution_id AS autoassigninstitution_id_159, t0.fellappSiteParameter_id AS fellappsiteparameter_id_160, t0.resappSiteParameter_id AS resappsiteparameter_id_161, t0.calllogSiteParameter_id AS calllogsiteparameter_id_162, t0.crnSiteParameter_id AS crnsiteparameter_id_163, t0.dashboardSiteParameter_id AS dashboardsiteparameter_id_164, t0.navbarFilterInstitution1_id AS navbarfilterinstitution1_id_165, t0.navbarFilterInstitution2_id AS navbarfilterinstitution2_id_166, t0.defaultDeidentifierAccessionType_id AS defaultdeidentifieraccessiontype_id_167, t0.defaultScanAccessionType_id AS defaultscanaccessiontype_id_168, t0.defaultScanMrnType_id AS defaultscanmrntype_id_169, t0.defaultScanDelivery_id AS defaultscandelivery_id_170, t0.defaultOrganizationRecipient_id AS defaultorganizationrecipient_id_171, t0.defaultScanner_id AS defaultscanner_id_172, t0.transresDashboardInstitution_id AS transresdashboardinstitution_id_173, t0.vacreqSiteParameter_id AS vacreqsiteparameter_id_174, t0.telephonySiteParameter_id AS telephonysiteparameter_id_175, t0.authUserGroup_id AS authusergroup_id_176, t0.authServerNetwork_id AS authservernetwork_id_177, t0.authPartnerServer_id AS authpartnerserver_id_178 FROM user_siteparameters t0
Parameters:
[] |
|
27.12 ms (13.00%) |
1 |
SELECT t0.selfSignUp AS selfsignup_1, t0.showSignUp AS showsignup_2, t0.showRequestAccount AS showrequestaccount_3, t0.showForgotPassword AS showforgotpassword_4, t0.accessibility AS accessibility_5, t0.showLinkHomePage AS showlinkhomepage_6, t0.showLinkNavbar AS showlinknavbar_7, t0.fromEmail AS fromemail_8, t0.requireVerifyMobilePhone AS requireverifymobilephone_9, t0.requireMobilePhoneToLogin AS requiremobilephonetologin_10, t0.noteOnLoginPage AS noteonloginpage_11, t0.id AS id_12, t0.name AS name_13, t0.abbreviation AS abbreviation_14, t0.shortname AS shortname_15, t0.description AS description_16, t0.type AS type_17, t0.createdate AS createdate_18, t0.updatedon AS updatedon_19, t0.orderinlist AS orderinlist_20, t0.updateAuthorRoles AS updateauthorroles_21, t0.fulltitle AS fulltitle_22, t0.linkToListId AS linktolistid_23, t0.entityId AS entityid_24, t0.entityNamespace AS entitynamespace_25, t0.entityName AS entityname_26, t0.version AS version_27, t0.textAttribute AS textattribute_28, t0.urlSlug AS urlslug_29, t0.original_id AS original_id_30, t0.creator_id AS creator_id_31, t0.updatedby_id AS updatedby_id_32, t0.objectType_id AS objecttype_id_33 FROM user_siteList t0 WHERE t0.abbreviation = ? LIMIT 1
Parameters:
[
"employees"
]
|
|
26.46 ms (12.68%) |
1 |
SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.level AS level_3, t0.root AS root_4, t0.id AS id_5, t0.name AS name_6, t0.abbreviation AS abbreviation_7, t0.shortname AS shortname_8, t0.description AS description_9, t0.type AS type_10, t0.createdate AS createdate_11, t0.updatedon AS updatedon_12, t0.orderinlist AS orderinlist_13, t0.updateAuthorRoles AS updateauthorroles_14, t0.fulltitle AS fulltitle_15, t0.linkToListId AS linktolistid_16, t0.entityId AS entityid_17, t0.entityNamespace AS entitynamespace_18, t0.entityName AS entityname_19, t0.version AS version_20, t0.textAttribute AS textattribute_21, t0.urlSlug AS urlslug_22, t0.parent_id AS parent_id_23, t0.original_id AS original_id_24, t0.organizationalGroupType_id AS organizationalgrouptype_id_25, t0.collaborationType_id AS collaborationtype_id_26, t0.creator_id AS creator_id_27, t0.updatedby_id AS updatedby_id_28, t0.objectType_id AS objecttype_id_29 FROM user_institution t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Pathology and Laboratory Medicine"
]
|
|
18.32 ms (8.78%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.shortname AS shortname_4, t0.description AS description_5, t0.type AS type_6, t0.createdate AS createdate_7, t0.updatedon AS updatedon_8, t0.orderinlist AS orderinlist_9, t0.updateAuthorRoles AS updateauthorroles_10, t0.fulltitle AS fulltitle_11, t0.linkToListId AS linktolistid_12, t0.entityId AS entityid_13, t0.entityNamespace AS entitynamespace_14, t0.entityName AS entityname_15, t0.version AS version_16, t0.textAttribute AS textattribute_17, t0.urlSlug AS urlslug_18, t0.original_id AS original_id_19, t0.creator_id AS creator_id_20, t0.updatedby_id AS updatedby_id_21, t0.objectType_id AS objecttype_id_22 FROM user_sourceSystemList t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ORDER Employee Directory"
]
|
|
15.50 ms (7.43%) |
1 |
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.abbreviation AS abbreviation_2, u0_.shortname AS shortname_3, u0_.description AS description_4, u0_.type AS type_5, u0_.createdate AS createdate_6, u0_.updatedon AS updatedon_7, u0_.orderinlist AS orderinlist_8, u0_.updateAuthorRoles AS updateauthorroles_9, u0_.fulltitle AS fulltitle_10, u0_.linkToListId AS linktolistid_11, u0_.entityId AS entityid_12, u0_.entityNamespace AS entitynamespace_13, u0_.entityName AS entityname_14, u0_.version AS version_15, u0_.textAttribute AS textattribute_16, u0_.urlSlug AS urlslug_17, u0_.original_id AS original_id_18, u0_.creator_id AS creator_id_19, u0_.updatedby_id AS updatedby_id_20, u0_.objectType_id AS objecttype_id_21 FROM user_sourceSystemList u0_ WHERE (u0_.type = ? OR u0_.type = ?) AND (u0_.name LIKE '%ORDER%' OR u0_.name LIKE '%External Authentication%') ORDER BY u0_.orderinlist ASC
Parameters:
[ "default" "user-added" ] |
|
12.01 ms (5.75%) |
1 |
SELECT u0_.alias AS alias_0, u0_.level AS level_1, u0_.id AS id_2, u0_.name AS name_3, u0_.abbreviation AS abbreviation_4, u0_.shortname AS shortname_5, u0_.description AS description_6, u0_.type AS type_7, u0_.createdate AS createdate_8, u0_.updatedon AS updatedon_9, u0_.orderinlist AS orderinlist_10, u0_.updateAuthorRoles AS updateauthorroles_11, u0_.fulltitle AS fulltitle_12, u0_.linkToListId AS linktolistid_13, u0_.entityId AS entityid_14, u0_.entityNamespace AS entitynamespace_15, u0_.entityName AS entityname_16, u0_.version AS version_17, u0_.textAttribute AS textattribute_18, u0_.urlSlug AS urlslug_19, u0_.original_id AS original_id_20, u0_.institution_id AS institution_id_21, u0_.fellowshipSubspecialty_id AS fellowshipsubspecialty_id_22, u0_.globalFellowshipSpecialty_id AS globalfellowshipspecialty_id_23, u0_.residencySubspecialty_id AS residencysubspecialty_id_24, u0_.residencyTrack_id AS residencytrack_id_25, u0_.creator_id AS creator_id_26, u0_.updatedby_id AS updatedby_id_27, u0_.objectType_id AS objecttype_id_28 FROM user_roles u0_ LEFT JOIN user_roles_sites u2_ ON u0_.id = u2_.role_id LEFT JOIN user_siteList u1_ ON u1_.id = u2_.site_id WHERE (u1_.name = ? OR u1_.abbreviation = ?) AND (u0_.type = ? OR u0_.type = ?)
Parameters:
[ "employees" "employees" "default" "user-added" ] |
|
9.50 ms (4.55%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.shortname AS shortname_4, t0.description AS description_5, t0.type AS type_6, t0.createdate AS createdate_7, t0.updatedon AS updatedon_8, t0.orderinlist AS orderinlist_9, t0.updateAuthorRoles AS updateauthorroles_10, t0.fulltitle AS fulltitle_11, t0.linkToListId AS linktolistid_12, t0.entityId AS entityid_13, t0.entityNamespace AS entitynamespace_14, t0.entityName AS entityname_15, t0.version AS version_16, t0.textAttribute AS textattribute_17, t0.urlSlug AS urlslug_18, t0.original_id AS original_id_19, t0.creator_id AS creator_id_20, t0.updatedby_id AS updatedby_id_21, t0.objectType_id AS objecttype_id_22 FROM user_usernameType t0 WHERE t0.type IN (?, ?) AND t0.abbreviation IN (?, ?) ORDER BY t0.orderinlist ASC
Parameters:
[ "default" "user-added" "ldap-user" "local-user" ] |
|
5.99 ms (2.87%) |
1 |
SELECT u0_.lft AS lft_0, u0_.rgt AS rgt_1, u0_.level AS level_2, u0_.root AS root_3, u0_.id AS id_4, u0_.name AS name_5, u0_.abbreviation AS abbreviation_6, u0_.shortname AS shortname_7, u0_.description AS description_8, u0_.type AS type_9, u0_.createdate AS createdate_10, u0_.updatedon AS updatedon_11, u0_.orderinlist AS orderinlist_12, u0_.updateAuthorRoles AS updateauthorroles_13, u0_.fulltitle AS fulltitle_14, u0_.linkToListId AS linktolistid_15, u0_.entityId AS entityid_16, u0_.entityNamespace AS entitynamespace_17, u0_.entityName AS entityname_18, u0_.version AS version_19, u0_.textAttribute AS textattribute_20, u0_.urlSlug AS urlslug_21, u0_.parent_id AS parent_id_22, u0_.original_id AS original_id_23, u0_.organizationalGroupType_id AS organizationalgrouptype_id_24, u0_.collaborationType_id AS collaborationtype_id_25, u0_.creator_id AS creator_id_26, u0_.updatedby_id AS updatedby_id_27, u0_.objectType_id AS objecttype_id_28 FROM user_institution u0_ LEFT JOIN user_institutions_types u2_ ON u0_.id = u2_.institution_id LEFT JOIN user_institutiontype u1_ ON u1_.id = u2_.institutiontype_id WHERE (u0_.type = 'default' OR u0_.type = 'user-added') AND (u1_.name IS NULL OR u1_.name <> 'Collaboration')
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| external | doctrine.dbal.external_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| external | doctrine.orm.external_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
external entity manager
No loaded entities.