- Request / Response
-
Tenant
-
Permissions
- Performance
- Validator
- Forms
- Exception
- Logs 35
- Events
- Routing
- Cache
- Translation
- Security
- Twig
- Doctrine
- Configuration
Configuration Settings
Query Metrics
20
Database Queries
20
Different statements
43.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.17 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 | 1.07 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 | 3.10 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.14 ms |
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
]
|
| 5 | 0.96 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
]
|
| 6 | 0.92 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
]
|
| 7 | 1.37 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 ] |
| 8 | 4.48 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.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
]
|
| 9 | 0.95 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.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
]
|
| 10 | 1.08 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
]
|
| 11 | 3.77 ms |
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
]
|
| 12 | 0.92 ms |
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
]
|
| 13 | 1.38 ms |
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
]
|
| 14 | 2.53 ms |
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
]
|
| 15 | 1.57 ms |
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 ] |
| 16 | 1.42 ms |
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
]
|
| 17 | 1.90 ms |
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
]
|
| 18 | 0.72 ms |
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
]
|
| 19 | 5.48 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
]
|
| 20 | 5.03 ms |
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
]
|
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.