https://wcsd.fallhaven.org/test/1/88678646-b838-11e7-b7a6-080027873a16/149/30b737a2-19db-11ed-b634-02b341c080f7/favicon/144

Method
GET
HTTP Status
404
IP
71.6.134.230
Profiled on
Token
cd2eb8

Query Metrics

25 Database Queries
19 Different statements
243.92 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
48.75 ms
(19.99%) 		2 
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: 
[]
View formatted query    View runnable query    Explain query
26.86 ms
(11.01%) 		2 
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
]
View formatted query    View runnable query    Explain query
24.78 ms
(10.16%) 		1 
SELECT t0.name AS name_1, t0.description AS description_2, t0.intranet AS intranet_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.contents AS contents_9, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_10, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_11, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_12, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_13, t0.theme AS theme_14, t0.tenant AS tenant_15, t0.createdBy AS createdBy_16, t0.updatedBy AS updatedBy_17, t0.touchedBy AS touchedBy_18 FROM cms__theme__inner_layout t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
21.78 ms
(8.93%) 		1 
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
]
View formatted query    View runnable query    Explain query
19.25 ms
(7.89%) 		2 
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
  "test"
]
View formatted query    View runnable query    Explain query
18.79 ms
(7.70%) 		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_startDate AS data_startDate_10, c0_.data_expiryDate AS data_expiryDate_11, c0_.data_abstract AS data_abstract_12, c0_.data_content AS data_content_13, c0_.data_externalLink AS data_externalLink_14, c0_.data_level AS data_level_15, c0_.data_behavior AS data_behavior_16, c0_.sharedChecksum AS sharedChecksum_17, c0_.importIndex AS importIndex_18, c0_.data_standardMetadata_title AS data_standardMetadata_title_19, c0_.data_standardMetadata_description AS data_standardMetadata_description_20, c0_.data_standardMetadata_keywords AS data_standardMetadata_keywords_21, c0_.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_22, c0_.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_23, c0_.data_standardMetadata_robots AS data_standardMetadata_robots_24, c0_.data_social_socialImage AS data_social_socialImage_25, c0_.data_social_facebookImage AS data_social_facebookImage_26, c0_.data_social_twitterImage AS data_social_twitterImage_27, c0_.container AS container_28, c0_.tenant AS tenant_29, c0_.createdBy AS createdBy_30, c0_.updatedBy AS updatedBy_31, c0_.touchedBy AS touchedBy_32, c0_.lockedBy AS lockedBy_33, c0_.socialImage AS socialImage_34, c0_.data_tag0 AS data_tag0_35, c0_.data_tag1 AS data_tag1_36, c0_.data_tag2 AS data_tag2_37, c0_.data_tag3 AS data_tag3_38, c0_.data_tag4 AS data_tag4_39, c0_.data_tag5 AS data_tag5_40, c0_.data_tag6 AS data_tag6_41, c0_.data_tag7 AS data_tag7_42, c0_.data_tag8 AS data_tag8_43, c0_.data_tag9 AS data_tag9_44, c0_.data_tag10 AS data_tag10_45, c0_.data_tag11 AS data_tag11_46, c0_.import AS import_47, c0_.history AS history_48, c0_.draft AS draft_49, c0_.sharedProxy AS sharedProxy_50 FROM cms__modules__alert__alert__proxy c0_ WHERE (c0_.container IN (?) AND c0_.data_startDate <= ? AND c0_.data_expiryDate >= ?) AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_level ASC, c0_.data_startDate ASC, c0_.data_expiryDate ASC LIMIT 6
Parameters: 
[
  149
  "2024-11-08 14:40:15"
  "2024-11-08 14:40:15"
]
View formatted query    View runnable query    Explain query
14.97 ms
(6.14%) 		1 
SELECT t0.name AS name_1, t0.description AS description_2, t0.base AS base_3, t0.intranet AS intranet_4, t0.adaFooter AS adaFooter_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.contents AS contents_11, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_12, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_13, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_14, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_15, t0.template AS template_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20 FROM cms__theme__outer_layout t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
13.71 ms
(5.62%) 		1 
SELECT c0_.id AS id_0, c0_.uid AS uid_1, c0_.name AS name_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4 FROM cms__theme__twig_source c0_ WHERE (c0_.template = ?) AND (c0_.tenant = 1)
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
10.10 ms
(4.14%) 		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')
Parameters: 
[
  39
]
View formatted query    View runnable query    Explain query
9.22 ms
(3.78%) 		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_._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
]
View formatted query    View runnable query    Explain query
8.23 ms
(3.38%) 		1 
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 = ?)) AND (c0_.tenant = 1)
Parameters: 
[
  12
  "/*"
  "/test/*"
  "/test/1/*"
  "/test/1/88678646-b838-11e7-b7a6-080027873a16/*"
  "/test/1/88678646-b838-11e7-b7a6-080027873a16/149/*"
  "/test/1/88678646-b838-11e7-b7a6-080027873a16/149/30b737a2-19db-11ed-b634-02b341c080f7/*"
  "/test/1/88678646-b838-11e7-b7a6-080027873a16/149/30b737a2-19db-11ed-b634-02b341c080f7/favicon/*"
  "/test/1/88678646-b838-11e7-b7a6-080027873a16/149/30b737a2-19db-11ed-b634-02b341c080f7/favicon/144/*"
]
View formatted query    View runnable query    Explain query
7.72 ms
(3.16%) 		1 
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
  "/test/1/88678646-b838-11e7-b7a6-080027873a16/149/30b737a2-19db-11ed-b634-02b341c080f7/favicon/144"
  "/test/1/88678646-b838-11e7-b7a6-080027873a16/149/30b737a2-19db-11ed-b634-02b341c080f7/favicon/144/"
]
View formatted query    View runnable query    Explain query
6.94 ms
(2.85%) 		1 
SELECT t0.title AS title_1, t0.listHtml AS listHtml_2, t0.shares AS shares_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.innerLayout AS innerLayout_9, t0.container AS container_10, t0.tenant AS tenant_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.touchedBy AS touchedBy_14 FROM cms__modules__alert__module_settings t0 WHERE t0.container = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters: 
[
  149
]
View formatted query    View runnable query    Explain query
4.21 ms
(1.73%) 		3 
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_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 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"
]
View formatted query    View runnable query    Explain query
3.70 ms
(1.52%) 		1 
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_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 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"
]
View formatted query    View runnable query    Explain query
1.43 ms
(0.58%) 		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: 
[
  10814
]
View formatted query    View runnable query    Explain query
1.28 ms
(0.52%) 		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
1.17 ms
(0.48%) 		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.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
1.04 ms
(0.43%) 		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

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\DomainBundle\Entity\Domain No errors.
Cms\DomainBundle\Entity\Apex No errors.
Cms\DomainBundle\Entity\SslCertificate No errors.
Cms\TenantBundle\Entity\Tenant No errors.
Platform\SecurityBundle\Entity\Identity\Account No errors.
Cms\DomainBundle\Entity\SslCertificates\CustomSslCertificate No errors.
Cms\DomainBundle\Entity\SslCertificates\LetsEncryptSslCertificate No errors.
Cms\RedirectBundle\Entity\Redirect No errors.
Cms\ContainerBundle\Entity\Containers\GenericContainer No errors.
Cms\ContainerBundle\Entity\Container No errors.
Cms\ThemeBundle\Entity\Template No errors.
Cms\ThemeBundle\Entity\OuterLayout No errors.
Cms\ThemeBundle\Entity\InnerLayout No errors.
Cms\ContainerBundle\Entity\Containers\PersonalContainer No errors.
Cms\ImportBundle\Entity\Import No errors.
Cms\ContainerBundle\Entity\Containers\IntranetContainer No errors.
Cms\ContainerBundle\Entity\Containers\StorageContainer No errors.
Cms\Modules\PageBundle\Entity\ModuleSettings No errors.
Products\SocialBundle\Entity\SocialAccount No errors.
Products\SocialBundle\Entity\SocialAccounts\FacebookSocialAccount No errors.
Products\SocialBundle\Entity\SocialAccounts\TwitterSocialAccount No errors.
Cms\Modules\AlertBundle\Entity\ModuleSettings No errors.
Cms\Modules\AlertBundle\Entity\Alert\AlertProxy No errors.