https://staging.test.campussuite.com/_dashboard/notifications/messages/2487/details

Query Metrics

15 Database Queries
10 Different statements
102.23 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.82 ms
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"
]
2 0.94 ms
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"
]
3 1.47 ms
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:
[
  "2487"
]
4 3.01 ms
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
]
5 0.80 ms
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
]
6 75.74 ms
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
]
7 6.57 ms
SELECT t0.status AS status_1, t0.semaphore AS semaphore_2, t0.channels AS channels_3, t0.servicesTotal AS servicesTotal_4, t0.servicesProcessing AS servicesProcessing_5, t0.servicesSucceeded AS servicesSucceeded_6, t0.servicesFailed AS servicesFailed_7, t0.messagesTotal AS messagesTotal_8, t0.messagesProcessing AS messagesProcessing_9, t0.messagesSucceeded AS messagesSucceeded_10, t0.messagesFailed AS messagesFailed_11, t0.messagesDelivered AS messagesDelivered_12, t0.messagesUndelivered AS messagesUndelivered_13, t0.firstActivityAt AS firstActivityAt_14, t0.lastActivityAt AS lastActivityAt_15, t0.lastDeliveryAt AS lastDeliveryAt_16, t0.error AS error_17, t0.errorCount AS errorCount_18, t0.id AS id_19, t0.uid AS uid_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.touchedAt AS touchedAt_23, t0.appTotal AS appTotal_24, t0.appProcessing AS appProcessing_25, t0.appSucceeded AS appSucceeded_26, t0.appFailed AS appFailed_27, t0.appDelivered AS appDelivered_28, t0.appUndelivered AS appUndelivered_29, t0.appError AS appError_30, t0.emailTotal AS emailTotal_31, t0.emailProcessing AS emailProcessing_32, t0.emailSucceeded AS emailSucceeded_33, t0.emailFailed AS emailFailed_34, t0.emailDelivered AS emailDelivered_35, t0.emailUndelivered AS emailUndelivered_36, t0.emailOpened AS emailOpened_37, t0.emailSpammed AS emailSpammed_38, t0.emailError AS emailError_39, t0.facebookTotal AS facebookTotal_40, t0.facebookProcessing AS facebookProcessing_41, t0.facebookSucceeded AS facebookSucceeded_42, t0.facebookFailed AS facebookFailed_43, t0.facebookError AS facebookError_44, t0.instagramTotal AS instagramTotal_45, t0.instagramProcessing AS instagramProcessing_46, t0.instagramSucceeded AS instagramSucceeded_47, t0.instagramFailed AS instagramFailed_48, t0.instagramError AS instagramError_49, t0.smsTotal AS smsTotal_50, t0.smsProcessing AS smsProcessing_51, t0.smsSucceeded AS smsSucceeded_52, t0.smsFailed AS smsFailed_53, t0.smsDelivered AS smsDelivered_54, t0.smsUndelivered AS smsUndelivered_55, t0.smsError AS smsError_56, t0.twitterTotal AS twitterTotal_57, t0.twitterProcessing AS twitterProcessing_58, t0.twitterSucceeded AS twitterSucceeded_59, t0.twitterFailed AS twitterFailed_60, t0.twitterError AS twitterError_61, t0.voiceTotal AS voiceTotal_62, t0.voiceProcessing AS voiceProcessing_63, t0.voiceSucceeded AS voiceSucceeded_64, t0.voiceFailed AS voiceFailed_65, t0.voiceDelivered AS voiceDelivered_66, t0.voiceUndelivered AS voiceUndelivered_67, t0.voiceAnswered AS voiceAnswered_68, t0.voiceError AS voiceError_69, t0.websiteTotal AS websiteTotal_70, t0.websiteProcessing AS websiteProcessing_71, t0.websiteSucceeded AS websiteSucceeded_72, t0.websiteFailed AS websiteFailed_73, t0.websiteError AS websiteError_74, t0.notification AS notification_75, t0.tenant AS tenant_76, t0.createdBy AS createdBy_77, t0.updatedBy AS updatedBy_78, t0.touchedBy AS touchedBy_79 FROM notis__job t0 WHERE t0.notification = ? AND ((t0.tenant = 1)) ORDER BY t0.createdAt DESC
Parameters:
[
  2487
]
8 0.86 ms
SELECT t0.method AS method_1, t0.recordedAt AS recordedAt_2, t0.speechText AS speechText_3, t0.speechTaskId AS speechTaskId_4, t0.phoneCallId AS phoneCallId_5, t0.phoneRecordingId AS phoneRecordingId_6, t0.phoneRecordingUrl AS phoneRecordingUrl_7, t0.phoneRecordingStatus AS phoneRecordingStatus_8, t0.id AS id_9, t0.uid AS uid_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.touchedAt AS touchedAt_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM notis__recording t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  855
]
9 1.57 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01h5afc8f0c83jfv09b1kznqa5"
]
10 4.52 ms
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:
[
  2487
]
11 2.35 ms
SELECT t0.method AS method_1, t0.recordedAt AS recordedAt_2, t0.speechText AS speechText_3, t0.speechTaskId AS speechTaskId_4, t0.phoneCallId AS phoneCallId_5, t0.phoneRecordingId AS phoneRecordingId_6, t0.phoneRecordingUrl AS phoneRecordingUrl_7, t0.phoneRecordingStatus AS phoneRecordingStatus_8, t0.id AS id_9, t0.uid AS uid_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.touchedAt AS touchedAt_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM notis__recording t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  1054
]
12 0.80 ms
SELECT t0.method AS method_1, t0.recordedAt AS recordedAt_2, t0.speechText AS speechText_3, t0.speechTaskId AS speechTaskId_4, t0.phoneCallId AS phoneCallId_5, t0.phoneRecordingId AS phoneRecordingId_6, t0.phoneRecordingUrl AS phoneRecordingUrl_7, t0.phoneRecordingStatus AS phoneRecordingStatus_8, t0.id AS id_9, t0.uid AS uid_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.touchedAt AS touchedAt_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM notis__recording t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  1053
]
13 0.78 ms
SELECT t0.method AS method_1, t0.recordedAt AS recordedAt_2, t0.speechText AS speechText_3, t0.speechTaskId AS speechTaskId_4, t0.phoneCallId AS phoneCallId_5, t0.phoneRecordingId AS phoneRecordingId_6, t0.phoneRecordingUrl AS phoneRecordingUrl_7, t0.phoneRecordingStatus AS phoneRecordingStatus_8, t0.id AS id_9, t0.uid AS uid_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.touchedAt AS touchedAt_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM notis__recording t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  1055
]
14 0.95 ms
SELECT t0.method AS method_1, t0.recordedAt AS recordedAt_2, t0.speechText AS speechText_3, t0.speechTaskId AS speechTaskId_4, t0.phoneCallId AS phoneCallId_5, t0.phoneRecordingId AS phoneRecordingId_6, t0.phoneRecordingUrl AS phoneRecordingUrl_7, t0.phoneRecordingStatus AS phoneRecordingStatus_8, t0.id AS id_9, t0.uid AS uid_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.touchedAt AS touchedAt_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM notis__recording t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  1056
]
15 1.05 ms
SELECT t0.method AS method_1, t0.recordedAt AS recordedAt_2, t0.speechText AS speechText_3, t0.speechTaskId AS speechTaskId_4, t0.phoneCallId AS phoneCallId_5, t0.phoneRecordingId AS phoneRecordingId_6, t0.phoneRecordingUrl AS phoneRecordingUrl_7, t0.phoneRecordingStatus AS phoneRecordingStatus_8, t0.id AS id_9, t0.uid AS uid_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.touchedAt AS touchedAt_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM notis__recording t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  1057
]

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.