Symfony Profiler

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

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;

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

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 = 'wcsd.fallhaven.org') OR (c0_.name = 'wcsd' AND c1_.host = 'fallhaven.org')) AND (c0_.tenant = 1) LIMIT 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.parent = ?
  AND t0.slug = ?
  AND t0._discr IN (
    'generic', 'personal', 'intranet',
    'storage'
  )
  AND (
    (t0.tenant = 1)
  )
LIMIT
  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.parent = 149 AND t0.slug = 'config.json' AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1)) LIMIT 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_._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

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 = 12) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic') LIMIT 1;

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

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 = 149) AND (c0_.tenant = 1) LIMIT 1;

SELECT
  t0.placeholder AS placeholder_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.lockedAt AS lockedAt_7,
  t0.lockRefreshedAt AS lockRefreshedAt_8,
  t0.data_title AS data_title_9,
  t0.data_slug AS data_slug_10,
  t0.data_content AS data_content_11,
  t0.data_source AS data_source_12,
  t0.data_appendToNav AS data_appendToNav_13,
  t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_14,
  t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_15,
  t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_16,
  t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_17,
  t0.data_social_socialImage AS data_social_socialImage_18,
  t0.data_social_facebookImage AS data_social_facebookImage_19,
  t0.data_social_twitterImage AS data_social_twitterImage_20,
  t0.data_standardMetadata_title AS data_standardMetadata_title_21,
  t0.data_standardMetadata_description AS data_standardMetadata_description_22,
  t0.data_standardMetadata_keywords AS data_standardMetadata_keywords_23,
  t0.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_24,
  t0.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_25,
  t0.data_standardMetadata_robots AS data_standardMetadata_robots_26,
  t0.container AS container_27,
  t0.tenant AS tenant_28,
  t0.createdBy AS createdBy_29,
  t0.updatedBy AS updatedBy_30,
  t0.touchedBy AS touchedBy_31,
  t0.lockedBy AS lockedBy_32,
  t0.data_defaultOuterLayout AS data_defaultOuterLayout_33,
  t0.data_defaultInnerLayout AS data_defaultInnerLayout_34,
  t0.socialImage AS socialImage_35,
  t0.history AS history_36,
  t0.draft AS draft_37
FROM
  cms__modules__page__page__proxy t0
WHERE
  t0.container = ?
  AND t0.data_slug = ?
  AND (
    (t0.placeholder = 0)
    AND (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.placeholder AS placeholder_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.lockedAt AS lockedAt_7, t0.lockRefreshedAt AS lockRefreshedAt_8, t0.data_title AS data_title_9, t0.data_slug AS data_slug_10, t0.data_content AS data_content_11, t0.data_source AS data_source_12, t0.data_appendToNav AS data_appendToNav_13, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_14, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_15, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_16, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_17, t0.data_social_socialImage AS data_social_socialImage_18, t0.data_social_facebookImage AS data_social_facebookImage_19, t0.data_social_twitterImage AS data_social_twitterImage_20, t0.data_standardMetadata_title AS data_standardMetadata_title_21, t0.data_standardMetadata_description AS data_standardMetadata_description_22, t0.data_standardMetadata_keywords AS data_standardMetadata_keywords_23, t0.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_24, t0.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_25, t0.data_standardMetadata_robots AS data_standardMetadata_robots_26, t0.container AS container_27, t0.tenant AS tenant_28, t0.createdBy AS createdBy_29, t0.updatedBy AS updatedBy_30, t0.touchedBy AS touchedBy_31, t0.lockedBy AS lockedBy_32, t0.data_defaultOuterLayout AS data_defaultOuterLayout_33, t0.data_defaultInnerLayout AS data_defaultInnerLayout_34, t0.socialImage AS socialImage_35, t0.history AS history_36, t0.draft AS draft_37 FROM cms__modules__page__page__proxy t0 WHERE t0.container = 149 AND t0.data_slug = 'config.json' AND ((t0.placeholder = 0) AND (t0.tenant = 1)) LIMIT 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

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 (149) AND c0_.data_startDate <= '2024-11-01 06:32:24' AND c0_.data_expiryDate >= '2024-11-01 06:32:24') AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_level ASC, c0_.data_startDate ASC, c0_.data_expiryDate ASC LIMIT 6;

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')

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 = 39 AND t0._discr IN ('custom', 'lets-encrypt');

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

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 = 149 AND c0_.lft < 1 AND c0_.rgt > 24) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic', 'personal', 'intranet', 'storage') ORDER BY c0_.lft ASC;

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)

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 = 12 AND c0_.source IN ('/config.json', '/config.json/')) AND (c0_.tenant = 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)
  )

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 = 10814 AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1));