Query Metrics
27
Database Queries
15
Different statements
38.66 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
11.82 ms (30.57%) |
12 |
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE t0.oneRosterOrg = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
"ORG-DISTRICT"
]
|
4.28 ms (11.06%) |
1 |
UPDATE notis__notification SET media = ?, updatedAt = ?, touchedAt = ?, updatedBy = ? WHERE id = ?
Parameters:
[ "[]" "2024-11-15 02:59:24" "2024-11-15 02:59:24" 1 2538 ] |
4.17 ms (10.80%) |
1 |
"COMMIT"
Parameters:
[] |
2.44 ms (6.30%) |
1 |
SELECT c0_.account AS sclr_0, c0_.grp AS sclr_1 FROM cms__security__identity__group_account c0_ WHERE (c0_.account = ?) AND (c0_.tenant = 1)
Parameters:
[
1
]
|
2.39 ms (6.17%) |
2 |
SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_4, t0.id AS id_5, t0.uid AS uid_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.touchedAt AS touchedAt_9, t0.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
1
]
|
2.11 ms (5.45%) |
1 |
SELECT n0_.method AS method_0, n0_.recordedAt AS recordedAt_1, n0_.speechText AS speechText_2, n0_.speechTaskId AS speechTaskId_3, n0_.phoneCallId AS phoneCallId_4, n0_.phoneRecordingId AS phoneRecordingId_5, n0_.phoneRecordingUrl AS phoneRecordingUrl_6, n0_.phoneRecordingStatus AS phoneRecordingStatus_7, n0_.id AS id_8, n0_.uid AS uid_9, n0_.createdAt AS createdAt_10, n0_.updatedAt AS updatedAt_11, n0_.touchedAt AS touchedAt_12, n0_.tenant AS tenant_13, n0_.createdBy AS createdBy_14, n0_.updatedBy AS updatedBy_15, n0_.touchedBy AS touchedBy_16 FROM notis__recording n0_ LEFT JOIN notis__notification n1_ ON (n1_.recording = n0_.id) AND n1_.discr IN ('message', 'invocation') AND (n1_.tenant = 1) WHERE (n1_.id = ?) AND (n0_.tenant = 1)
Parameters:
[
2538
]
|
2.04 ms (5.28%) |
1 |
SELECT c0_.account AS sclr_0, c0_.role AS sclr_1, c0_.container AS sclr_2, c0_.inheritance AS inheritance_3, c0_.school AS sclr_4, c0_.list AS sclr_5 FROM cms__security__access__role_association c0_ WHERE ((c0_.account = ?) AND (c0_.tenant = 1)) AND c0_._discr IN ('account')
Parameters:
[
1
]
|
1.71 ms (4.42%) |
1 |
SELECT t0.name AS name_1, t0.types AS types_2, t0.id AS id_3, t0.uid AS uid_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.touchedAt AS touchedAt_7, t0.onerosterId AS onerosterId_8, t0.onerosterArchived AS onerosterArchived_9, t0.flags AS flags_10, t0.alias AS alias_11, t0.school AS school_12, t0.tenant AS tenant_13, t0.createdBy AS createdBy_14, t0.updatedBy AS updatedBy_15, t0.touchedBy AS touchedBy_16, t0.discr, t0.conditionQuery AS conditionQuery_17 FROM notis__list t0 WHERE t0.discr IN ('district', 'static', 'school', 'condition') AND ((t0.tenant = 1)) ORDER BY t0.name ASC
Parameters:
[] |
1.65 ms (4.26%) |
1 |
SELECT t0.urgent AS urgent_1, t0.templateChannels AS templateChannels_2, t0.status AS status_3, t0.facades AS facades_4, t0.scheduledAt AS scheduledAt_5, t0.id AS id_6, t0.uid AS uid_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.touchedAt AS touchedAt_10, t0.channels AS channels_11, t0.locale AS locale_12, t0.title AS title_13, t0.description AS description_14, t0.script AS script_15, t0.html AS html_16, t0.media AS media_17, t0.emailName AS emailName_18, t0.emailFrom AS emailFrom_19, t0.smsUrl AS smsUrl_20, t0.facebookNote AS facebookNote_21, t0.twitterNote AS twitterNote_22, t0.websiteBehavior AS websiteBehavior_23, t0.websiteLevel AS websiteLevel_24, t0.websiteEndDateTime AS websiteEndDateTime_25, t0.flags AS flags_26, t0.semaphore AS semaphore_27, t0.branding AS branding_28, t0.tenant AS tenant_29, t0.createdBy AS createdBy_30, t0.updatedBy AS updatedBy_31, t0.touchedBy AS touchedBy_32, t0.recording AS recording_33, t0.voiceCallerId AS voiceCallerId_34, t0.discr FROM notis__notification t0 WHERE t0.id = ? AND t0.discr IN ('message') AND ((t0.tenant = 1))
Parameters:
[
"2538"
]
|
1.33 ms (3.45%) |
1 |
SELECT t0.email AS email_1, t0.active AS active_2, t0.policyAcceptedOn AS policyAcceptedOn_3, t0.termsAcceptedOn AS termsAcceptedOn_4, t0.password AS password_5, t0.passwordChangedAt AS passwordChangedAt_6, t0.lastLoggedInAt AS lastLoggedInAt_7, t0.metadata AS metadata_8, t0.internalUid AS internalUid_9, t0.id AS id_10, t0.uid AS uid_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.onerosterId AS onerosterId_15, t0.onerosterArchived AS onerosterArchived_16, t0.importIndex AS importIndex_17, t0.specialPermissions_superUser AS specialPermissions_superUser_18, t0.systemProfile_displayName AS systemProfile_displayName_19, t0.systemProfile_firstName AS systemProfile_firstName_20, t0.systemProfile_lastName AS systemProfile_lastName_21, t0.systemProfile_avatar AS systemProfile_avatar_22, t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_23, t0.tenant AS tenant_24, t0.createdBy AS createdBy_25, t0.updatedBy AS updatedBy_26, t0.touchedBy AS touchedBy_27, t0.import AS import_28 FROM cms__security__identity__account t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"1"
]
|
1.10 ms (2.85%) |
1 |
"START TRANSACTION"
Parameters:
[] |
1.04 ms (2.69%) |
1 |
SELECT t0.name AS name_1, t0.types AS types_2, t0.id AS id_3, t0.uid AS uid_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.touchedAt AS touchedAt_7, t0.onerosterId AS onerosterId_8, t0.onerosterArchived AS onerosterArchived_9, t0.flags AS flags_10, t0.alias AS alias_11, t0.school AS school_12, t0.tenant AS tenant_13, t0.createdBy AS createdBy_14, t0.updatedBy AS updatedBy_15, t0.touchedBy AS touchedBy_16, t0.discr, t0.conditionQuery AS conditionQuery_17 FROM notis__list t0 INNER JOIN notis__notification_x_list ON t0.id = notis__notification_x_list.list WHERE notis__notification_x_list.notification = ? AND t0.discr IN ('district', 'static', 'school', 'condition') AND ((t0.tenant = 1))
Parameters:
[
2538
]
|
0.90 ms (2.34%) |
1 |
SELECT c0_.grp AS sclr_0, c0_.role AS sclr_1, c0_.container AS sclr_2, c0_.inheritance AS inheritance_3, c0_.school AS sclr_4, c0_.list AS sclr_5 FROM cms__security__access__role_association c0_ WHERE ((c0_.grp IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c0_.tenant = 1)) AND c0_._discr IN ('group')
Parameters:
[ 20 93 97 103 107 108 112 143 147 148 156 158 162 168 172 173 177 183 187 251 ] |
0.90 ms (2.34%) |
1 |
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.touchedAt AS touchedAt_5, t0.channels AS channels_6, t0.locale AS locale_7, t0.title AS title_8, t0.description AS description_9, t0.script AS script_10, t0.html AS html_11, t0.media AS media_12, t0.flags AS flags_13, t0.notification AS notification_14, t0.template AS template_15, t0.tenant AS tenant_16, t0.createdBy AS createdBy_17, t0.updatedBy AS updatedBy_18, t0.touchedBy AS touchedBy_19, t0.recording AS recording_20 FROM notis__translation t0 WHERE t0.notification = ? AND ((t0.tenant = 1)) ORDER BY t0.locale ASC
Parameters:
[
2538
]
|
0.78 ms (2.03%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.status AS status_3, t0.emailsDisplay AS emailsDisplay_4, t0.policy AS policy_5, t0.disqusId AS disqusId_6, t0.googleToken AS googleToken_7, t0.stage AS stage_8, t0.teamworkTasklist AS teamworkTasklist_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.redirects AS redirects_12, t0.redirectCodes AS redirectCodes_13, t0.debugging AS debugging_14, t0.products AS products_15, t0.hubspotId AS hubspotId_16, t0.weglotId AS weglotId_17, t0.id AS id_18, t0.uid AS uid_19, t0.createdAt AS createdAt_20, t0.updatedAt AS updatedAt_21, t0.touchedAt AS touchedAt_22, t0.data_custom0 AS data_custom0_23, t0.data_custom1 AS data_custom1_24, t0.data_custom2 AS data_custom2_25, t0.data_custom3 AS data_custom3_26, t0.authenticationTypes AS authenticationTypes_27, t0.classlinkCustomerId AS classlinkCustomerId_28, t0.cleverCustomerId AS cleverCustomerId_29, t0.gg4lCustomerId AS gg4lCustomerId_30, t0.googleCustomerId AS googleCustomerId_31, t0.microsoftCustomerId AS microsoftCustomerId_32, t0.ulid AS ulid_33, t0.locale_timezone AS locale_timezone_34, t0.ada_reportsFolder AS ada_reportsFolder_35, t0.ada_reportsPrimary AS ada_reportsPrimary_36, t0.ada_reportsDocuments AS ada_reportsDocuments_37, t0.type_primary AS type_primary_38, t0.type_secondary AS type_secondary_39 FROM cms__tenant__tenant t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"staging"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.