Query Metrics

13 Database Queries
12 Different statements
26.56 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.70 ms
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.redirection_enabled AS redirection_enabled_7, c0_.redirection_host AS redirection_host_8, c0_.redirection_path AS redirection_path_9, c0_.redirection_appendPath AS redirection_appendPath_10, c0_.redirection_query AS redirection_query_11, c0_.redirection_appendQuery AS redirection_appendQuery_12, c0_.redirection_code AS redirection_code_13, c0_.apex AS apex_14, c0_.certificate AS certificate_15, c0_.tenant AS tenant_16, c0_.createdBy AS createdBy_17, c0_.updatedBy AS updatedBy_18, c0_.touchedBy AS touchedBy_19 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id WHERE (c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?) LIMIT 1
Parameters:
[
  ""
  "wcsd.fallhaven.org"
  "wcsd"
  "fallhaven.org"
]
2 2.88 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')
Parameters:
[
  37
]
3 0.87 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.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
]
4 3.27 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.id = ?
Parameters:
[
  1
]
5 2.06 ms
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.redirection_enabled AS redirection_enabled_7, c0_.redirection_host AS redirection_host_8, c0_.redirection_path AS redirection_path_9, c0_.redirection_appendPath AS redirection_appendPath_10, c0_.redirection_query AS redirection_query_11, c0_.redirection_appendQuery AS redirection_appendQuery_12, c0_.redirection_code AS redirection_code_13, c0_.apex AS apex_14, c0_.certificate AS certificate_15, c0_.tenant AS tenant_16, c0_.createdBy AS createdBy_17, c0_.updatedBy AS updatedBy_18, c0_.touchedBy AS touchedBy_19 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id AND (c1_.tenant = 1) WHERE ((c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?)) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[
  ""
  "wcsd.fallhaven.org"
  "wcsd"
  "fallhaven.org"
]
6 1.41 ms
SELECT c0_.code AS code_0, c0_.status AS status_1, c0_.description AS description_2, c0_.source AS source_3, c0_.destination AS destination_4, c0_.id AS id_5, c0_.uid AS uid_6, c0_.createdAt AS createdAt_7, c0_.updatedAt AS updatedAt_8, c0_.touchedAt AS touchedAt_9, c0_.importIndex AS importIndex_10, c0_.domain AS domain_11, c0_.tenant AS tenant_12, c0_.createdBy AS createdBy_13, c0_.updatedBy AS updatedBy_14, c0_.touchedBy AS touchedBy_15, c0_.import AS import_16 FROM cms__redirect__redirect c0_ WHERE (c0_.domain = ? AND c0_.source IN (?, ?)) AND (c0_.tenant = 1)
Parameters:
[
  12
  "/s/230323e2433323e2835313e24353/_/;/META-INF/maven/com.atlassian.jira/jira-webapp-dist/pom.properties"
  "/s/230323e2433323e2835313e24353/_/;/META-INF/maven/com.atlassian.jira/jira-webapp-dist/pom.properties/"
]
7 0.64 ms
SELECT c0_.code AS code_0, c0_.status AS status_1, c0_.description AS description_2, c0_.source AS source_3, c0_.destination AS destination_4, c0_.id AS id_5, c0_.uid AS uid_6, c0_.createdAt AS createdAt_7, c0_.updatedAt AS updatedAt_8, c0_.touchedAt AS touchedAt_9, c0_.importIndex AS importIndex_10, c0_.domain AS domain_11, c0_.tenant AS tenant_12, c0_.createdBy AS createdBy_13, c0_.updatedBy AS updatedBy_14, c0_.touchedBy AS touchedBy_15, c0_.import AS import_16 FROM cms__redirect__redirect c0_ WHERE (c0_.domain = ? AND (c0_.source = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ?)) AND (c0_.tenant = 1)
Parameters:
[
  12
  "/*"
  "/s/*"
  "/s/230323e2433323e2835313e24353/*"
  "/s/230323e2433323e2835313e24353/_/*"
  "/s/230323e2433323e2835313e24353/_/;/*"
  "/s/230323e2433323e2835313e24353/_/;/META-INF/*"
  "/s/230323e2433323e2835313e24353/_/;/META-INF/maven/*"
  "/s/230323e2433323e2835313e24353/_/;/META-INF/maven/com.atlassian.jira/*"
  "/s/230323e2433323e2835313e24353/_/;/META-INF/maven/com.atlassian.jira/jira-webapp-dist/*"
  "/s/230323e2433323e2835313e24353/_/;/META-INF/maven/com.atlassian.jira/jira-webapp-dist/pom.properties/*"
]
8 0.46 ms
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.redirection_enabled AS redirection_enabled_7, c0_.redirection_host AS redirection_host_8, c0_.redirection_path AS redirection_path_9, c0_.redirection_appendPath AS redirection_appendPath_10, c0_.redirection_query AS redirection_query_11, c0_.redirection_appendQuery AS redirection_appendQuery_12, c0_.redirection_code AS redirection_code_13, c0_.apex AS apex_14, c0_.certificate AS certificate_15, c0_.tenant AS tenant_16, c0_.createdBy AS createdBy_17, c0_.updatedBy AS updatedBy_18, c0_.touchedBy AS touchedBy_19 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id AND (c1_.tenant = 1) WHERE ((c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?)) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[
  ""
  "wcsd.fallhaven.org"
  "wcsd"
  "fallhaven.org"
]
9 5.80 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_._discr AS _discr_31, c0_.parent AS parent_32, c0_.domain AS domain_33, c0_.tenant AS tenant_34, c0_.createdBy AS createdBy_35, c0_.updatedBy AS updatedBy_36, c0_.touchedBy AS touchedBy_37, c0_.defaultTheme AS defaultTheme_38, c0_.defaultOuterLayout AS defaultOuterLayout_39, c0_.defaultInnerLayout AS defaultInnerLayout_40 FROM cms__container__container c0_ WHERE ((c0_.parent IS NULL AND c0_.domain = ?) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic') LIMIT 1
Parameters:
[
  12
]
10 0.80 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.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.parent = ? AND t0.slug = ? AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
  "s"
]
11 1.15 ms
SELECT t0.theme AS theme_1, t0.name AS name_2, t0.fonts AS fonts_3, t0.bust AS bust_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.variables AS variables_10, t0.source AS source_11, t0.configs AS configs_12, t0.outerLayout AS outerLayout_13, t0.innerLayout AS innerLayout_14, t0.tenant AS tenant_15, t0.createdBy AS createdBy_16, t0.updatedBy AS updatedBy_17, t0.touchedBy AS touchedBy_18 FROM cms__theme__template t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  2
]
12 1.20 ms
SELECT c0_.id AS id_0, c0_.uid AS uid_1, c0_.createdAt AS createdAt_2, c0_.updatedAt AS updatedAt_3, c0_.touchedAt AS touchedAt_4, c0_.container AS container_5, c0_.tenant AS tenant_6, c0_.createdBy AS createdBy_7, c0_.updatedBy AS updatedBy_8, c0_.touchedBy AS touchedBy_9 FROM cms__modules__page__module_settings c0_ WHERE (c0_.container = ?) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[
  149
]
13 4.32 ms
SELECT t0.name AS name_1, t0.auto AS auto_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.tenant AS tenant_8, t0.createdBy AS createdBy_9, t0.updatedBy AS updatedBy_10, t0.touchedBy AS touchedBy_11, t0._discr, t0.facebookPageId AS facebookPageId_12, t0.facebookUserId AS facebookUserId_13, t0.facebookUserName AS facebookUserName_14, t0.facebookAccessToken AS facebookAccessToken_15, t0.twitterUserId AS twitterUserId_16, t0.twitterUserName AS twitterUserName_17, t0.twitterAccessToken AS twitterAccessToken_18, t0.twitterTokenSecret AS twitterTokenSecret_19 FROM smm__account t0 WHERE t0._discr IN ('facebook', 'twitter') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[]

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.