Query Metrics
14
Database Queries
12
Different statements
136.61 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
29.57 ms (21.64%) |
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
]
|
29.33 ms (21.47%) |
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.submission AS submission_6, t0.workflowIdentity AS workflowIdentity_7, t0.container AS container_8, t0.tenant AS tenant_9, t0.createdBy AS createdBy_10, t0.updatedBy AS updatedBy_11, t0.touchedBy AS touchedBy_12 FROM cms__workflows_workflow_enforcement t0 WHERE t0.container = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
]
|
27.40 ms (20.05%) |
1 |
SELECT c0_.placeholder AS placeholder_0, c0_.id AS id_1, c0_.uid AS uid_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4, c0_.touchedAt AS touchedAt_5, c0_.lockedAt AS lockedAt_6, c0_.lockRefreshedAt AS lockRefreshedAt_7, c0_.data_title AS data_title_8, c0_.data_slug AS data_slug_9, c0_.data_content AS data_content_10, c0_.data_source AS data_source_11, c0_.data_appendToNav AS data_appendToNav_12, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_13, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_14, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_15, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_16, c0_.data_social_socialImage AS data_social_socialImage_17, c0_.data_social_facebookImage AS data_social_facebookImage_18, c0_.data_social_twitterImage AS data_social_twitterImage_19, c0_.data_standardMetadata_title AS data_standardMetadata_title_20, c0_.data_standardMetadata_description AS data_standardMetadata_description_21, c0_.data_standardMetadata_keywords AS data_standardMetadata_keywords_22, c0_.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_23, c0_.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_24, c0_.data_standardMetadata_robots AS data_standardMetadata_robots_25, c0_.container AS container_26, c0_.tenant AS tenant_27, c0_.createdBy AS createdBy_28, c0_.updatedBy AS updatedBy_29, c0_.touchedBy AS touchedBy_30, c0_.lockedBy AS lockedBy_31, c0_.data_defaultOuterLayout AS data_defaultOuterLayout_32, c0_.data_defaultInnerLayout AS data_defaultInnerLayout_33, c0_.socialImage AS socialImage_34, c0_.history AS history_35, c0_.draft AS draft_36 FROM cms__modules__page__page__proxy c0_ WHERE (c0_.container = ?) AND (c0_.tenant = 1)
Parameters:
[
149
]
|
15.47 ms (11.32%) |
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.verification_code AS verification_code_7, t0.verification_date AS verification_date_8, t0.tenant AS tenant_9, t0.createdBy AS createdBy_10, t0.updatedBy AS updatedBy_11, t0.touchedBy AS touchedBy_12 FROM cms__domain__apex t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
1
]
|
9.57 ms (7.00%) |
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.redirection_enabled AS redirection_enabled_8, t0.redirection_host AS redirection_host_9, t0.redirection_path AS redirection_path_10, t0.redirection_appendPath AS redirection_appendPath_11, t0.redirection_query AS redirection_query_12, t0.redirection_appendQuery AS redirection_appendQuery_13, t0.redirection_code AS redirection_code_14, t0.apex AS apex_15, t0.certificate AS certificate_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20 FROM cms__domain__domain t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
12
]
|
8.49 ms (6.22%) |
1 |
SELECT t0.name AS name_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.rt AS rt_7, t0.lvl AS lvl_8, t0.lft AS lft_9, t0.rgt AS rgt_10, t0.parent AS parent_11, t0.container AS container_12, t0.tenant AS tenant_13, t0.createdBy AS createdBy_14, t0.updatedBy AS updatedBy_15, t0.touchedBy AS touchedBy_16, t0._discr, t0.description AS description_17, t0.status AS status_18, t0.extension AS extension_19, t0.mime AS mime_20, t0.description AS description_21, t0.size AS size_22, t0.uploadedAt AS uploadedAt_23, t0.note AS note_24, t0.flags AS flags_25, t0.uploadedBy AS uploadedBy_26, t0.optimization_cropSquare AS optimization_cropSquare_27, t0.optimization_cropRectangle AS optimization_cropRectangle_28, t0.optimization_cropWide AS optimization_cropWide_29, t0.optimization_processing AS optimization_processing_30, t0.documentMeta_pages AS documentMeta_pages_31 FROM cms__file__node t0 WHERE t0.id = ? AND t0._discr IN ('folder', 'file', 'generic', 'image', 'document') AND ((t0.tenant = 1))
Parameters:
[
756
]
|
5.83 ms (4.27%) |
2 |
SELECT t0.name AS name_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.rt AS rt_7, t0.lvl AS lvl_8, t0.lft AS lft_9, t0.rgt AS rgt_10, t0.status AS status_11, t0.extension AS extension_12, t0.mime AS mime_13, t0.description AS description_14, t0.size AS size_15, t0.uploadedAt AS uploadedAt_16, t0.note AS note_17, t0.flags AS flags_18, t0.parent AS parent_19, t0.container AS container_20, t0.tenant AS tenant_21, t0.createdBy AS createdBy_22, t0.updatedBy AS updatedBy_23, t0.touchedBy AS touchedBy_24, t0.uploadedBy AS uploadedBy_25, t0._discr, t0.optimization_cropSquare AS optimization_cropSquare_26, t0.optimization_cropRectangle AS optimization_cropRectangle_27, t0.optimization_cropWide AS optimization_cropWide_28, t0.optimization_processing AS optimization_processing_29, t0.documentMeta_pages AS documentMeta_pages_30 FROM cms__file__node t0 WHERE t0.id = ? AND t0._discr IN ('file', 'generic', 'image', 'document') AND ((t0.tenant = 1))
Parameters:
[
823
]
|
3.92 ms (2.87%) |
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"
]
|
3.11 ms (2.28%) |
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.parent AS parent_31, t0.domain AS domain_32, t0.tenant AS tenant_33, t0.createdBy AS createdBy_34, t0.updatedBy AS updatedBy_35, t0.touchedBy AS touchedBy_36, t0.defaultTheme AS defaultTheme_37, t0.defaultOuterLayout AS defaultOuterLayout_38, t0.defaultInnerLayout AS defaultInnerLayout_39, t0._discr, t0.preferred AS preferred_40, t0.importIndex AS importIndex_41, t0.account AS account_42, t0.container AS container_43, t0.import AS import_44, t0.feedSetting_blog AS feedSetting_blog_45, t0.feedSetting_calendar AS feedSetting_calendar_46, t0.feedSetting_news AS feedSetting_news_47, t0.feedSetting_alert AS feedSetting_alert_48, t0.preferred AS preferred_49 FROM cms__container__container t0 WHERE t0.id = ? AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1))
Parameters:
[
149
]
|
1.88 ms (1.38%) |
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 WHERE t0.rt = ? AND t0._discr IN ('generic') AND ((t0.tenant = 1)) ORDER BY t0.lft ASC
Parameters:
[
149
]
|
1.62 ms (1.19%) |
2 |
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 ] |
0.41 ms (0.30%) |
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.