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

Method
GET
HTTP Status
200
IP
50.5.181.156
Profiled on
Token
e5dd3e

Query Metrics

20 Database Queries
20 Different statements
43.96 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
5.48 ms
(12.47%) 		1 
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
]
View formatted query    View runnable query    Explain query
5.03 ms
(11.43%) 		1 
SELECT t0.name AS name_1, t0.phoneNumber AS phoneNumber_2, t0.verificationExtension AS verificationExtension_3, t0.verificationValidationCode AS verificationValidationCode_4, t0.verificationCallSid AS verificationCallSid_5, t0.verificationStatus AS verificationStatus_6, t0.twilioOutgoingCallerIdSid AS twilioOutgoingCallerIdSid_7, t0.id AS id_8, t0.uid AS uid_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.config AS config_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__twilio_caller_id t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
4.48 ms
(10.19%) 		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.subaccountSid AS subaccountSid_6, t0.apiKeySid AS apiKeySid_7, t0.apiKeySecret AS apiKeySecret_8, t0.businessProfileSid AS businessProfileSid_9, t0.addressSid AS addressSid_10, t0.supportingDocumentSid AS supportingDocumentSid_11, t0.businessInformationSid AS businessInformationSid_12, t0.primaryRepresentativeSid AS primaryRepresentativeSid_13, t0.secondaryRepresentativeSid AS secondaryRepresentativeSid_14, t0.assignmentBusinessProfileSid AS assignmentBusinessProfileSid_15, t0.assignmentSupportingDocumentSid AS assignmentSupportingDocumentSid_16, t0.assignmentBusinessInformationSid AS assignmentBusinessInformationSid_17, t0.assignmentPrimaryRepresentativeSid AS assignmentPrimaryRepresentativeSid_18, t0.assignmentSecondaryRepresentativeSid AS assignmentSecondaryRepresentativeSid_19, t0.assignmentPhoneChannelEndpointSids AS assignmentPhoneChannelEndpointSids_20, t0.evaluationSids AS evaluationSids_21, t0.evaluations AS evaluations_22, t0.evaluationStatus AS evaluationStatus_23, t0.persistedChecksum AS persistedChecksum_24, t0.status AS status_25, t0.statusTimestamp AS statusTimestamp_26, t0.incomingPhoneNumberSid AS incomingPhoneNumberSid_27, t0.incomingPhoneNumber AS incomingPhoneNumber_28, t0.phoneNumberCache AS phoneNumberCache_29, t0.callerIdCache AS callerIdCache_30, t0.messagingServiceSid AS messagingServiceSid_31, t0.twimlAppSid AS twimlAppSid_32, t0.messagingPhoneNumberSids AS messagingPhoneNumberSids_33, t0.smsTrustProductSid AS smsTrustProductSid_34, t0.smsAssignmentPrimaryTrustProductSid AS smsAssignmentPrimaryTrustProductSid_35, t0.smsAssignmentTrustProductSid AS smsAssignmentTrustProductSid_36, t0.smsMessagingProfileInformationSid AS smsMessagingProfileInformationSid_37, t0.smsAssignmentMessagingProfileInformationSid AS smsAssignmentMessagingProfileInformationSid_38, t0.smsBrandRegistrationSid AS smsBrandRegistrationSid_39, t0.smsBrandRegistrationStatus AS smsBrandRegistrationStatus_40, t0.smsBrandRegistrationStatusTimestamp AS smsBrandRegistrationStatusTimestamp_41, t0.smsBrandRegistrationStatusMessage AS smsBrandRegistrationStatusMessage_42, t0.smsBrandRegistrationTcrId AS smsBrandRegistrationTcrId_43, t0.smsBrandRegistrationScore AS smsBrandRegistrationScore_44, t0.smsCampaignSid AS smsCampaignSid_45, t0.smsCampaignStatus AS smsCampaignStatus_46, t0.smsCampaignStatusTimestamp AS smsCampaignStatusTimestamp_47, t0.smsEvaluationSids AS smsEvaluationSids_48, t0.smsEvaluations AS smsEvaluations_49, t0.smsEvaluationStatus AS smsEvaluationStatus_50, t0.smsStatus AS smsStatus_51, t0.smsStatusTimestamp AS smsStatusTimestamp_52, t0.voiceTrustProductSid AS voiceTrustProductSid_53, t0.voiceAssignmentPrimaryTrustProductSid AS voiceAssignmentPrimaryTrustProductSid_54, t0.voiceAssignmentTrustProductSid AS voiceAssignmentTrustProductSid_55, t0.voiceAssignmentChannelEndpointSids AS voiceAssignmentChannelEndpointSids_56, t0.voiceEvaluationSids AS voiceEvaluationSids_57, t0.voiceEvaluations AS voiceEvaluations_58, t0.voiceEvaluationStatus AS voiceEvaluationStatus_59, t0.voiceStatus AS voiceStatus_60, t0.voiceStatusTimestamp AS voiceStatusTimestamp_61, t0.cnamDisplayName AS cnamDisplayName_62, t0.cnamTrustProductSid AS cnamTrustProductSid_63, t0.cnamAssignmentPrimaryTrustProductSid AS cnamAssignmentPrimaryTrustProductSid_64, t0.cnamAssignmentTrustProductSid AS cnamAssignmentTrustProductSid_65, t0.cnamInformationSid AS cnamInformationSid_66, t0.cnamAssignmentInformationSid AS cnamAssignmentInformationSid_67, t0.cnamAssignmentChannelEndpointSids AS cnamAssignmentChannelEndpointSids_68, t0.cnamEvaluationSids AS cnamEvaluationSids_69, t0.cnamEvaluations AS cnamEvaluations_70, t0.cnamEvaluationStatus AS cnamEvaluationStatus_71, t0.cnamStatus AS cnamStatus_72, t0.cnamStatusTimestamp AS cnamStatusTimestamp_73, t0.businessInfo_name AS businessInfo_name_74, t0.businessInfo_email AS businessInfo_email_75, t0.businessInfo_phone AS businessInfo_phone_76, t0.businessInfo_type AS businessInfo_type_77, t0.businessInfo_classification AS businessInfo_classification_78, t0.businessInfo_industry AS businessInfo_industry_79, t0.businessInfo_identifierType AS businessInfo_identifierType_80, t0.businessInfo_identifier AS businessInfo_identifier_81, t0.businessInfo_region AS businessInfo_region_82, t0.businessInfo_website AS businessInfo_website_83, t0.addressInfo_street AS addressInfo_street_84, t0.addressInfo_city AS addressInfo_city_85, t0.addressInfo_region AS addressInfo_region_86, t0.addressInfo_postalCode AS addressInfo_postalCode_87, t0.addressInfo_country AS addressInfo_country_88, t0.primaryContactInfo_firstName AS primaryContactInfo_firstName_89, t0.primaryContactInfo_lastName AS primaryContactInfo_lastName_90, t0.primaryContactInfo_email AS primaryContactInfo_email_91, t0.primaryContactInfo_phone AS primaryContactInfo_phone_92, t0.primaryContactInfo_title AS primaryContactInfo_title_93, t0.primaryContactInfo_position AS primaryContactInfo_position_94, t0.secondaryContactInfo_firstName AS secondaryContactInfo_firstName_95, t0.secondaryContactInfo_lastName AS secondaryContactInfo_lastName_96, t0.secondaryContactInfo_email AS secondaryContactInfo_email_97, t0.secondaryContactInfo_phone AS secondaryContactInfo_phone_98, t0.secondaryContactInfo_title AS secondaryContactInfo_title_99, t0.secondaryContactInfo_position AS secondaryContactInfo_position_100, t0.tenant AS tenant_101, t0.createdBy AS createdBy_102, t0.updatedBy AS updatedBy_103, t0.touchedBy AS touchedBy_104 FROM sys__twilio_config t0 WHERE t0.tenant = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3.77 ms
(8.58%) 		1 
SELECT t0.name AS name_1, t0.uses AS uses_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.facebookPageId AS facebookPageId_8, t0.facebookUserId AS facebookUserId_9, t0.facebookUserName AS facebookUserName_10, t0.facebookAccessToken AS facebookAccessToken_11, t0.tenant AS tenant_12, t0.createdBy AS createdBy_13, t0.updatedBy AS updatedBy_14, t0.touchedBy AS touchedBy_15, t0._discr FROM sys__social_account t0 INNER JOIN notis__notification_x_facebook_social_account ON t0.id = notis__notification_x_facebook_social_account.facebookSocialAccount WHERE notis__notification_x_facebook_social_account.notification = ? AND t0._discr IN ('facebook') AND ((t0.tenant = 1))
Parameters: 
[
  2487
]
View formatted query    View runnable query    Explain query
3.14 ms
(7.14%) 		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: 
[
  2487
]
View formatted query    View runnable query    Explain query
3.10 ms
(7.04%) 		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: 
[
  "2487"
]
View formatted query    View runnable query    Explain query
2.53 ms
(5.76%) 		1 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.hidden AS hidden_3, t0.color AS color_4, t0.code AS code_5, t0.schoolNowMigrated AS schoolNowMigrated_6, t0.id AS id_7, t0.uid AS uid_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.touchedAt AS touchedAt_11, t0.rt AS rt_12, t0.lvl AS lvl_13, t0.lft AS lft_14, t0.rgt AS rgt_15, t0.navigation AS navigation_16, t0.moduleFlags_alert AS moduleFlags_alert_17, t0.moduleFlags_blog AS moduleFlags_blog_18, t0.moduleFlags_calendar AS moduleFlags_calendar_19, t0.moduleFlags_gallery AS moduleFlags_gallery_20, t0.moduleFlags_news AS moduleFlags_news_21, t0.moduleFlags_page AS moduleFlags_page_22, t0.moduleFlags_people AS moduleFlags_people_23, t0.moduleFlags_question AS moduleFlags_question_24, t0.moduleFlags_snippet AS moduleFlags_snippet_25, t0.moduleFlags_feed AS moduleFlags_feed_26, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_27, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_28, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_29, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_30, t0.preferred AS preferred_31, t0.parent AS parent_32, t0.domain AS domain_33, t0.tenant AS tenant_34, t0.createdBy AS createdBy_35, t0.updatedBy AS updatedBy_36, t0.touchedBy AS touchedBy_37, t0.defaultTheme AS defaultTheme_38, t0.defaultOuterLayout AS defaultOuterLayout_39, t0.defaultInnerLayout AS defaultInnerLayout_40, t0._discr FROM cms__container__container t0 INNER JOIN notis__notification_x_department ON t0.id = notis__notification_x_department.department WHERE notis__notification_x_department.notification = ? AND t0._discr IN ('generic') AND ((t0.tenant = 1))
Parameters: 
[
  2487
]
View formatted query    View runnable query    Explain query
2.17 ms
(4.95%) 		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"
]
View formatted query    View runnable query    Explain query
1.90 ms
(4.32%) 		1 
SELECT t0.expiration AS expiration_1, t0.ready AS ready_2, t0.error AS error_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.data_privateKey AS data_privateKey_9, t0.data_intermediateCertificates AS data_intermediateCertificates_10, t0.data_certficate AS data_certficate_11, t0.data_certificateSigningRequest AS data_certificateSigningRequest_12, t0.domain AS domain_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17, t0._discr, t0.csr_email AS csr_email_18, t0.csr_organization AS csr_organization_19, t0.csr_unit AS csr_unit_20, t0.csr_country AS csr_country_21, t0.csr_province AS csr_province_22, t0.csr_locality AS csr_locality_23, t0.le_challenge AS le_challenge_24, t0.le_token AS le_token_25, t0.le_payload AS le_payload_26 FROM cms__domain__ssl_certificate t0 WHERE t0.id = ? AND t0._discr IN ('custom', 'lets-encrypt') AND ((t0.tenant = 1))
Parameters: 
[
  39
]
View formatted query    View runnable query    Explain query
1.57 ms
(3.58%) 		1 
SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.hidden AS hidden_2, c0_.color AS color_3, c0_.code AS code_4, c0_.schoolNowMigrated AS schoolNowMigrated_5, c0_.id AS id_6, c0_.uid AS uid_7, c0_.createdAt AS createdAt_8, c0_.updatedAt AS updatedAt_9, c0_.touchedAt AS touchedAt_10, c0_.rt AS rt_11, c0_.lvl AS lvl_12, c0_.lft AS lft_13, c0_.rgt AS rgt_14, c0_.navigation AS navigation_15, c0_.moduleFlags_alert AS moduleFlags_alert_16, c0_.moduleFlags_blog AS moduleFlags_blog_17, c0_.moduleFlags_calendar AS moduleFlags_calendar_18, c0_.moduleFlags_gallery AS moduleFlags_gallery_19, c0_.moduleFlags_news AS moduleFlags_news_20, c0_.moduleFlags_page AS moduleFlags_page_21, c0_.moduleFlags_people AS moduleFlags_people_22, c0_.moduleFlags_question AS moduleFlags_question_23, c0_.moduleFlags_snippet AS moduleFlags_snippet_24, c0_.moduleFlags_feed AS moduleFlags_feed_25, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29, c0_.preferred AS preferred_30, c0_.importIndex AS importIndex_31, c0_.feedSetting_blog AS feedSetting_blog_32, c0_.feedSetting_calendar AS feedSetting_calendar_33, c0_.feedSetting_news AS feedSetting_news_34, c0_.feedSetting_alert AS feedSetting_alert_35, c0_.preferred AS preferred_36, c0_._discr AS _discr_37, c0_.parent AS parent_38, c0_.domain AS domain_39, c0_.tenant AS tenant_40, c0_.createdBy AS createdBy_41, c0_.updatedBy AS updatedBy_42, c0_.touchedBy AS touchedBy_43, c0_.defaultTheme AS defaultTheme_44, c0_.defaultOuterLayout AS defaultOuterLayout_45, c0_.defaultInnerLayout AS defaultInnerLayout_46, c0_.account AS account_47, c0_.container AS container_48, c0_.import AS import_49 FROM cms__container__container c0_ WHERE ((c0_.rt = ? AND c0_.lft < ? AND c0_.rgt > ?) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic', 'personal', 'intranet', 'storage') ORDER BY c0_.lft ASC
Parameters: 
[
  149
  1
  24
]
View formatted query    View runnable query    Explain query
1.42 ms
(3.24%) 		1 
SELECT t0.name AS name_1, t0.httpsUpgrade AS httpsUpgrade_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.dnsLookupAt AS dnsLookupAt_8, t0.dnsLookupResult AS dnsLookupResult_9, t0.redirection_enabled AS redirection_enabled_10, t0.redirection_host AS redirection_host_11, t0.redirection_path AS redirection_path_12, t0.redirection_appendPath AS redirection_appendPath_13, t0.redirection_query AS redirection_query_14, t0.redirection_appendQuery AS redirection_appendQuery_15, t0.redirection_code AS redirection_code_16, t0.apex AS apex_17, t0.certificate AS certificate_18, t0.tenant AS tenant_19, t0.createdBy AS createdBy_20, t0.updatedBy AS updatedBy_21, t0.touchedBy AS touchedBy_22 FROM cms__domain__domain t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
1.38 ms
(3.13%) 		1 
SELECT t0.name AS name_1, t0.uses AS uses_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.instagramProfileId AS instagramProfileId_8, t0.instagramUserId AS instagramUserId_9, t0.instagramUserName AS instagramUserName_10, t0.instagramAccessToken AS instagramAccessToken_11, t0.tenant AS tenant_12, t0.createdBy AS createdBy_13, t0.updatedBy AS updatedBy_14, t0.touchedBy AS touchedBy_15, t0._discr FROM sys__social_account t0 INNER JOIN notis__notification_x_instagram_social_account ON t0.id = notis__notification_x_instagram_social_account.instagramSocialAccount WHERE notis__notification_x_instagram_social_account.notification = ? AND t0._discr IN ('instagram') AND ((t0.tenant = 1))
Parameters: 
[
  2487
]
View formatted query    View runnable query    Explain query
1.37 ms
(3.11%) 		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
]
View formatted query    View runnable query    Explain query
1.08 ms
(2.45%) 		1 
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
]
View formatted query    View runnable query    Explain query
1.07 ms
(2.43%) 		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"
]
View formatted query    View runnable query    Explain query
0.96 ms
(2.20%) 		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
]
View formatted query    View runnable query    Explain query
0.95 ms
(2.17%) 		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.subaccountId AS subaccountId_6, t0.subaccountUsername AS subaccountUsername_7, t0.apiKeyId AS apiKeyId_8, t0.apiKey AS apiKey_9, t0.webhookUrl AS webhookUrl_10, t0.domainCache AS domainCache_11, t0.tenant AS tenant_12, t0.createdBy AS createdBy_13, t0.updatedBy AS updatedBy_14, t0.touchedBy AS touchedBy_15 FROM sys__sendgrid_config t0 WHERE t0.tenant = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.92 ms
(2.09%) 		1 
SELECT t0.name AS name_1, t0.uses AS uses_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.twitterUserId AS twitterUserId_8, t0.twitterUserName AS twitterUserName_9, t0.twitterAccessToken AS twitterAccessToken_10, t0.twitterTokenSecret AS twitterTokenSecret_11, t0.tenant AS tenant_12, t0.createdBy AS createdBy_13, t0.updatedBy AS updatedBy_14, t0.touchedBy AS touchedBy_15, t0._discr FROM sys__social_account t0 INNER JOIN notis__notification_x_twitter_social_account ON t0.id = notis__notification_x_twitter_social_account.twitterSocialAccount WHERE notis__notification_x_twitter_social_account.notification = ? AND t0._discr IN ('twitter') AND ((t0.tenant = 1))
Parameters: 
[
  2487
]
View formatted query    View runnable query    Explain query
0.92 ms
(2.09%) 		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
]
View formatted query    View runnable query    Explain query
0.72 ms
(1.63%) 		1 
SELECT t0.host AS host_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.dnsLookupAt AS dnsLookupAt_7, t0.dnsLookupResult AS dnsLookupResult_8, t0.verification_code AS verification_code_9, t0.verification_date AS verification_date_10, t0.tenant AS tenant_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.touchedBy AS touchedBy_14 FROM cms__domain__apex t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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.

Entities Mapping

Class Mapping errors
Cms\TenantBundle\Entity\Tenant No errors.
Platform\SecurityBundle\Entity\Identity\Account No errors.
Cms\ImportBundle\Entity\Import No errors.
Platform\SecurityBundle\Entity\Access\RoleAssociation\AccountRoleAssociation No errors.
Cms\ContainerBundle\Entity\Container No errors.
App\Entity\OAuth2\Admin\AbstractAdminToken No errors.
Products\NotificationsBundle\Entity\Notifications\Message No errors.
App\Entity\System\School No errors.
Products\NotificationsBundle\Entity\Recording No errors.
App\Entity\System\Twilio\TwilioCallerId No errors.
Products\NotificationsBundle\Entity\AbstractNotification No errors.
Products\NotificationsBundle\Entity\AbstractList No errors.
Cms\ContainerBundle\Entity\Containers\GenericContainer No errors.
App\Entity\System\SocialAccounts\FacebookSocialAccount No errors.
App\Entity\System\SocialAccounts\InstagramSocialAccount No errors.
App\Entity\System\SocialAccounts\TwitterSocialAccount No errors.
Products\NotificationsBundle\Entity\Job No errors.
Products\NotificationsBundle\Entity\Notifications\Translations\Translation No errors.
Products\NotificationsBundle\Entity\Lists\DistrictList No errors.
Products\NotificationsBundle\Entity\Lists\StaticList No errors.
Products\NotificationsBundle\Entity\Lists\SchoolList No errors.
Products\NotificationsBundle\Entity\Lists\ConditionList No errors.
Platform\SecurityBundle\Entity\Access\GroupAccount No errors.
Platform\SecurityBundle\Entity\Access\RoleAssociation\GroupRoleAssociation No errors.
App\Entity\System\Twilio\TwilioConfig No errors.
App\Entity\System\Sendgrid\SendgridConfig No errors.
App\Entity\System\Sendgrid\SendgridDomain No errors.
App\Entity\System\SocialAccount No errors.
Cms\DomainBundle\Entity\Domain No errors.
Cms\ThemeBundle\Entity\Template No errors.
Cms\ThemeBundle\Entity\OuterLayout No errors.
Cms\ThemeBundle\Entity\InnerLayout No errors.
Cms\DomainBundle\Entity\Apex No errors.
Cms\DomainBundle\Entity\SslCertificate No errors.
Cms\DomainBundle\Entity\SslCertificates\CustomSslCertificate No errors.
Cms\DomainBundle\Entity\SslCertificates\LetsEncryptSslCertificate No errors.