https://wcsd.fallhaven.org/

Query Metrics

62 Database Queries
38 Different statements
461.39 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.39 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_.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"
]
2 38.54 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:
[
  39
]
3 0.63 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
]
4 0.74 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 1.89 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_.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"
]
6 14.73 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
  "/"
]
7 0.49 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 = ?) AND (c0_.tenant = 1)
Parameters:
[
  12
  "/*"
]
8 0.64 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_.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"
]
9 21.77 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 9.65 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
  ""
]
11 14.32 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 9.78 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 24.04 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:
[]
14 26.53 ms
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
Parameters:
[
  149
  "index"
]
15 14.72 ms
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
]
16 28.33 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_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.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE ((t0.tenant = 1)) ORDER BY t0.type ASC, t0.name ASC
Parameters:
[]
17 3.64 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
]
18 42.96 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s1_.schoolType AS schoolType_43, s1_.timestamp AS timestamp_44, s1_.label AS label_45, s1_.preview AS preview_46, s1_.media AS media_47, s1_.visibility AS visibility_48, s1_.boosted AS boosted_49, s1_.pinned AS pinned_50, s1_.pinnedAt AS pinnedAt_51, s1_.link AS link_52, s1_.id AS id_53, s1_.createdAt AS createdAt_54, s1_.updatedAt AS updatedAt_55, s1_.touchedAt AS touchedAt_56, c2_.name AS name_57, c2_.slug AS slug_58, c2_.hidden AS hidden_59, c2_.color AS color_60, c2_.code AS code_61, c2_.schoolNowMigrated AS schoolNowMigrated_62, c2_.id AS id_63, c2_.uid AS uid_64, c2_.createdAt AS createdAt_65, c2_.updatedAt AS updatedAt_66, c2_.touchedAt AS touchedAt_67, c2_.rt AS rt_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c2_.navigation AS navigation_72, c2_.moduleFlags_alert AS moduleFlags_alert_73, c2_.moduleFlags_blog AS moduleFlags_blog_74, c2_.moduleFlags_calendar AS moduleFlags_calendar_75, c2_.moduleFlags_gallery AS moduleFlags_gallery_76, c2_.moduleFlags_news AS moduleFlags_news_77, c2_.moduleFlags_page AS moduleFlags_page_78, c2_.moduleFlags_people AS moduleFlags_people_79, c2_.moduleFlags_question AS moduleFlags_question_80, c2_.moduleFlags_snippet AS moduleFlags_snippet_81, c2_.moduleFlags_feed AS moduleFlags_feed_82, c2_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_83, c2_.htmlOverrides_headScripts AS htmlOverrides_headScripts_84, c2_.htmlOverrides_topScripts AS htmlOverrides_topScripts_85, c2_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_86, c2_.preferred AS preferred_87, c2_.importIndex AS importIndex_88, c2_.feedSetting_blog AS feedSetting_blog_89, c2_.feedSetting_calendar AS feedSetting_calendar_90, c2_.feedSetting_news AS feedSetting_news_91, c2_.feedSetting_alert AS feedSetting_alert_92, c2_.preferred AS preferred_93, s0_.discr AS discr_94, s1_.discr AS discr_95, c2_._discr AS _discr_96 FROM sn__content__object s0_ LEFT JOIN sys__feed__entry s1_ ON s0_.id = s1_.object AND s1_.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND (s1_.tenant = 1) LEFT JOIN cms__container__container c2_ ON s1_.department = c2_.id AND c2_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c2_.tenant = 1) WHERE ((c2_.rt = ? AND ((s1_.schoolType & ?) > 0 OR s1_.department IN (?)) AND s1_.boosted = ? AND s1_.visibility = ? AND s1_.timestamp <= ? AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s1_.pinned DESC, s1_.timestamp DESC, s1_.label ASC) dctrn_result) dctrn_table
Parameters:
[
  149
  1
  149
  1
  4
  "2024-11-06 03:05:34"
  8
  8
]
19 7.26 ms
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, pinned_50, timestamp_44, label_45 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s1_.schoolType AS schoolType_43, s1_.timestamp AS timestamp_44, s1_.label AS label_45, s1_.preview AS preview_46, s1_.media AS media_47, s1_.visibility AS visibility_48, s1_.boosted AS boosted_49, s1_.pinned AS pinned_50, s1_.pinnedAt AS pinnedAt_51, s1_.link AS link_52, s1_.id AS id_53, s1_.createdAt AS createdAt_54, s1_.updatedAt AS updatedAt_55, s1_.touchedAt AS touchedAt_56, c2_.name AS name_57, c2_.slug AS slug_58, c2_.hidden AS hidden_59, c2_.color AS color_60, c2_.code AS code_61, c2_.schoolNowMigrated AS schoolNowMigrated_62, c2_.id AS id_63, c2_.uid AS uid_64, c2_.createdAt AS createdAt_65, c2_.updatedAt AS updatedAt_66, c2_.touchedAt AS touchedAt_67, c2_.rt AS rt_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c2_.navigation AS navigation_72, c2_.moduleFlags_alert AS moduleFlags_alert_73, c2_.moduleFlags_blog AS moduleFlags_blog_74, c2_.moduleFlags_calendar AS moduleFlags_calendar_75, c2_.moduleFlags_gallery AS moduleFlags_gallery_76, c2_.moduleFlags_news AS moduleFlags_news_77, c2_.moduleFlags_page AS moduleFlags_page_78, c2_.moduleFlags_people AS moduleFlags_people_79, c2_.moduleFlags_question AS moduleFlags_question_80, c2_.moduleFlags_snippet AS moduleFlags_snippet_81, c2_.moduleFlags_feed AS moduleFlags_feed_82, c2_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_83, c2_.htmlOverrides_headScripts AS htmlOverrides_headScripts_84, c2_.htmlOverrides_topScripts AS htmlOverrides_topScripts_85, c2_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_86, c2_.preferred AS preferred_87, c2_.importIndex AS importIndex_88, c2_.feedSetting_blog AS feedSetting_blog_89, c2_.feedSetting_calendar AS feedSetting_calendar_90, c2_.feedSetting_news AS feedSetting_news_91, c2_.feedSetting_alert AS feedSetting_alert_92, c2_.preferred AS preferred_93, s0_.discr AS discr_94, s1_.discr AS discr_95, c2_._discr AS _discr_96 FROM sn__content__object s0_ LEFT JOIN sys__feed__entry s1_ ON s0_.id = s1_.object AND s1_.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND (s1_.tenant = 1) LEFT JOIN cms__container__container c2_ ON s1_.department = c2_.id AND c2_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c2_.tenant = 1) WHERE ((c2_.rt = ? AND ((s1_.schoolType & ?) > 0 OR s1_.department IN (?)) AND s1_.boosted = ? AND s1_.visibility = ? AND s1_.timestamp <= ? AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post')) dctrn_result_inner ORDER BY pinned_50 DESC, timestamp_44 DESC, label_45 ASC) dctrn_result LIMIT 4
Parameters:
[
  149
  1
  149
  1
  4
  "2024-11-06 03:05:34"
  8
  8
]
20 10.39 ms
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s1_.schoolType AS schoolType_43, s1_.timestamp AS timestamp_44, s1_.label AS label_45, s1_.preview AS preview_46, s1_.media AS media_47, s1_.visibility AS visibility_48, s1_.boosted AS boosted_49, s1_.pinned AS pinned_50, s1_.pinnedAt AS pinnedAt_51, s1_.link AS link_52, s1_.id AS id_53, s1_.createdAt AS createdAt_54, s1_.updatedAt AS updatedAt_55, s1_.touchedAt AS touchedAt_56, c2_.name AS name_57, c2_.slug AS slug_58, c2_.hidden AS hidden_59, c2_.color AS color_60, c2_.code AS code_61, c2_.schoolNowMigrated AS schoolNowMigrated_62, c2_.id AS id_63, c2_.uid AS uid_64, c2_.createdAt AS createdAt_65, c2_.updatedAt AS updatedAt_66, c2_.touchedAt AS touchedAt_67, c2_.rt AS rt_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c2_.navigation AS navigation_72, c2_.moduleFlags_alert AS moduleFlags_alert_73, c2_.moduleFlags_blog AS moduleFlags_blog_74, c2_.moduleFlags_calendar AS moduleFlags_calendar_75, c2_.moduleFlags_gallery AS moduleFlags_gallery_76, c2_.moduleFlags_news AS moduleFlags_news_77, c2_.moduleFlags_page AS moduleFlags_page_78, c2_.moduleFlags_people AS moduleFlags_people_79, c2_.moduleFlags_question AS moduleFlags_question_80, c2_.moduleFlags_snippet AS moduleFlags_snippet_81, c2_.moduleFlags_feed AS moduleFlags_feed_82, c2_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_83, c2_.htmlOverrides_headScripts AS htmlOverrides_headScripts_84, c2_.htmlOverrides_topScripts AS htmlOverrides_topScripts_85, c2_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_86, c2_.preferred AS preferred_87, c2_.importIndex AS importIndex_88, c2_.feedSetting_blog AS feedSetting_blog_89, c2_.feedSetting_calendar AS feedSetting_calendar_90, c2_.feedSetting_news AS feedSetting_news_91, c2_.feedSetting_alert AS feedSetting_alert_92, c2_.preferred AS preferred_93, s0_.discr AS discr_94, s0_.school_id AS school_id_95, s0_.department_id AS department_id_96, s0_.tenant AS tenant_97, s0_.createdBy AS createdBy_98, s0_.updatedBy AS updatedBy_99, s0_.touchedBy AS touchedBy_100, s1_.discr AS discr_101, s1_.school AS school_102, s1_.department AS department_103, s1_.tenant AS tenant_104, s1_.createdBy AS createdBy_105, s1_.updatedBy AS updatedBy_106, s1_.touchedBy AS touchedBy_107, s1_.object AS object_108, s1_.draft AS draft_109, c2_._discr AS _discr_110, c2_.parent AS parent_111, c2_.domain AS domain_112, c2_.tenant AS tenant_113, c2_.createdBy AS createdBy_114, c2_.updatedBy AS updatedBy_115, c2_.touchedBy AS touchedBy_116, c2_.defaultTheme AS defaultTheme_117, c2_.defaultOuterLayout AS defaultOuterLayout_118, c2_.defaultInnerLayout AS defaultInnerLayout_119, c2_.account AS account_120, c2_.container AS container_121, c2_.import AS import_122 FROM sn__content__object s0_ LEFT JOIN sys__feed__entry s1_ ON s0_.id = s1_.object AND s1_.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND (s1_.tenant = 1) LEFT JOIN cms__container__container c2_ ON s1_.department = c2_.id AND c2_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c2_.tenant = 1) WHERE ((c2_.rt = ? AND ((s1_.schoolType & ?) > 0 OR s1_.department IN (?)) AND s1_.boosted = ? AND s1_.visibility = ? AND s1_.timestamp <= ? AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s1_.pinned DESC, s1_.timestamp DESC, s1_.label ASC
Parameters:
[
  149
  1
  149
  1
  4
  "2024-11-06 03:05:34"
  8
  8
  "01j4w7mp90khzxd91rtmeaxfe3"
  "01j4vr8m60wt2jb3pznfnbsj9h"
  "01hygygv3rkf596hw1f4d633ys"
  "01hydyczc84smz4yht40cnr7nj"
]
21 11.94 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01j4w7mjc085xh2rxjgy8asb7w"
]
22 0.40 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01hydyby5rpvb9fs2nhwdx9naq"
]
23 10.41 ms
SELECT t0.title AS title_1, t0.listHtml AS listHtml_2, t0.viewMode AS viewMode_3, t0.shares AS shares_4, t0.selections AS selections_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.innerLayout AS innerLayout_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 FROM cms__modules__calendar__module_settings t0 WHERE t0.container = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
]
24 35.05 ms
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_startDateDisplay AS data_startDateDisplay_11, c0_.data_endDate AS data_endDate_12, c0_.data_endDateDisplay AS data_endDateDisplay_13, c0_.data_abstract AS data_abstract_14, c0_.data_description AS data_description_15, c0_.data_location AS data_location_16, c0_.data_locationLink AS data_locationLink_17, c0_.data_allDay AS data_allDay_18, c0_.data_attachments AS data_attachments_19, c0_.sharedChecksum AS sharedChecksum_20, c0_.syncUid AS syncUid_21, c0_.syncToken AS syncToken_22, c0_.importIndex AS importIndex_23, c0_.data_standardMetadata_title AS data_standardMetadata_title_24, c0_.data_standardMetadata_description AS data_standardMetadata_description_25, c0_.data_standardMetadata_keywords AS data_standardMetadata_keywords_26, c0_.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_27, c0_.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_28, c0_.data_standardMetadata_robots AS data_standardMetadata_robots_29, c0_.data_social_socialImage AS data_social_socialImage_30, c0_.data_social_facebookImage AS data_social_facebookImage_31, c0_.data_social_twitterImage AS data_social_twitterImage_32, c0_.container AS container_33, c0_.tenant AS tenant_34, c0_.createdBy AS createdBy_35, c0_.updatedBy AS updatedBy_36, c0_.touchedBy AS touchedBy_37, c0_.lockedBy AS lockedBy_38, c0_.socialImage AS socialImage_39, c0_.data_tag0 AS data_tag0_40, c0_.data_tag1 AS data_tag1_41, c0_.data_tag2 AS data_tag2_42, c0_.data_tag3 AS data_tag3_43, c0_.data_tag4 AS data_tag4_44, c0_.data_tag5 AS data_tag5_45, c0_.data_tag6 AS data_tag6_46, c0_.data_tag7 AS data_tag7_47, c0_.data_tag8 AS data_tag8_48, c0_.data_tag9 AS data_tag9_49, c0_.data_tag10 AS data_tag10_50, c0_.data_tag11 AS data_tag11_51, c0_.sync AS sync_52, c0_.import AS import_53, c0_.history AS history_54, c0_.draft AS draft_55, c0_.sharedProxy AS sharedProxy_56 FROM cms__modules__calendar__event__proxy c0_ WHERE (c0_.container IN (?) AND (((c0_.data_startDate >= ? AND c0_.data_startDate < ?) OR (c0_.data_endDate > ? AND c0_.data_endDate < ?) OR (c0_.data_startDate < ? AND c0_.data_endDate >= ?)))) AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_startDate ASC, c0_.data_endDate ASC
Parameters:
[
  149
  "2024-11-01 04:00:00"
  "2024-12-01 05:00:00"
  "2024-11-01 04:00:00"
  "2024-12-01 05:00:00"
  "2024-11-01 04:00:00"
  "2024-12-01 05:00:00"
]
25 0.65 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
]
26 0.45 ms
SELECT t0.title AS title_1, t0.listHtml AS listHtml_2, t0.viewMode AS viewMode_3, t0.shares AS shares_4, t0.selections AS selections_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.innerLayout AS innerLayout_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 FROM cms__modules__calendar__module_settings t0 WHERE t0.container = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
]
27 3.18 ms
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_startDateDisplay AS data_startDateDisplay_11, c0_.data_endDate AS data_endDate_12, c0_.data_endDateDisplay AS data_endDateDisplay_13, c0_.data_abstract AS data_abstract_14, c0_.data_description AS data_description_15, c0_.data_location AS data_location_16, c0_.data_locationLink AS data_locationLink_17, c0_.data_allDay AS data_allDay_18, c0_.data_attachments AS data_attachments_19, c0_.sharedChecksum AS sharedChecksum_20, c0_.syncUid AS syncUid_21, c0_.syncToken AS syncToken_22, c0_.importIndex AS importIndex_23, c0_.data_standardMetadata_title AS data_standardMetadata_title_24, c0_.data_standardMetadata_description AS data_standardMetadata_description_25, c0_.data_standardMetadata_keywords AS data_standardMetadata_keywords_26, c0_.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_27, c0_.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_28, c0_.data_standardMetadata_robots AS data_standardMetadata_robots_29, c0_.data_social_socialImage AS data_social_socialImage_30, c0_.data_social_facebookImage AS data_social_facebookImage_31, c0_.data_social_twitterImage AS data_social_twitterImage_32, c0_.container AS container_33, c0_.tenant AS tenant_34, c0_.createdBy AS createdBy_35, c0_.updatedBy AS updatedBy_36, c0_.touchedBy AS touchedBy_37, c0_.lockedBy AS lockedBy_38, c0_.socialImage AS socialImage_39, c0_.data_tag0 AS data_tag0_40, c0_.data_tag1 AS data_tag1_41, c0_.data_tag2 AS data_tag2_42, c0_.data_tag3 AS data_tag3_43, c0_.data_tag4 AS data_tag4_44, c0_.data_tag5 AS data_tag5_45, c0_.data_tag6 AS data_tag6_46, c0_.data_tag7 AS data_tag7_47, c0_.data_tag8 AS data_tag8_48, c0_.data_tag9 AS data_tag9_49, c0_.data_tag10 AS data_tag10_50, c0_.data_tag11 AS data_tag11_51, c0_.sync AS sync_52, c0_.import AS import_53, c0_.history AS history_54, c0_.draft AS draft_55, c0_.sharedProxy AS sharedProxy_56 FROM cms__modules__calendar__event__proxy c0_ WHERE (c0_.container IN (?) AND (c0_.data_startDate >= ? OR c0_.data_endDate > ?)) AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_startDate ASC, c0_.data_endDate ASC LIMIT 3
Parameters:
[
  149
  "2024-11-05 05:00:00"
  "2024-11-05 05:00:00"
]
28 1.98 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_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.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE t0.department = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
]
29 3.89 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s0_.discr AS discr_43 FROM sn__content__object s0_ WHERE ((s0_.discr IN ('exhibits.gallery', 'exhibits.video') AND s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC) dctrn_result) dctrn_table
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
]
30 3.10 ms
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, touchedAt_13, headline_14 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s0_.discr AS discr_43 FROM sn__content__object s0_ WHERE ((s0_.discr IN ('exhibits.gallery', 'exhibits.video') AND s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post')) dctrn_result_inner ORDER BY touchedAt_13 DESC, headline_14 ASC) dctrn_result LIMIT 3
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
]
31 1.10 ms
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s0_.discr AS discr_43, s0_.school_id AS school_id_44, s0_.department_id AS department_id_45, s0_.tenant AS tenant_46, s0_.createdBy AS createdBy_47, s0_.updatedBy AS updatedBy_48, s0_.touchedBy AS touchedBy_49 FROM sn__content__object s0_ WHERE ((s0_.discr IN ('exhibits.gallery', 'exhibits.video') AND s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
  "01h7zv35t0h5sadrk5pj0xx8jv"
  "01h66xzv8gny8s8b30aybrj6br"
  "01h66y5ns8jydpex6ta0cgk723"
]
32 0.49 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01h7zv35t0h5sadrk5pj0xx8jv"
]
33 0.40 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01h66xzv8gny8s8b30aybrj6br"
]
34 0.42 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01h66y5ns8jydpex6ta0cgk723"
]
35 1.63 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01h7zv21nrbn3j8kcm0jaa5ejr"
]
36 0.37 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01h66xydbr49z6d2pya59sm1wp"
]
37 1.47 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_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.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE t0.department = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
]
38 2.91 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC) dctrn_result) dctrn_table
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
]
39 2.31 ms
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, touchedAt_13, headline_14 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post')) dctrn_result_inner ORDER BY touchedAt_13 DESC, headline_14 ASC) dctrn_result LIMIT 3
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
]
40 0.76 ms
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23, s0_.school_id AS school_id_24, s0_.department_id AS department_id_25, s0_.tenant AS tenant_26, s0_.createdBy AS createdBy_27, s0_.updatedBy AS updatedBy_28, s0_.touchedBy AS touchedBy_29 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
  "01j4w7mp90khzxd91rtmeaxfe3"
  "01j4vr8m60wt2jb3pznfnbsj9h"
  "01hygygv3rkf596hw1f4d633ys"
]
41 0.67 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_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.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE t0.department = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
]
42 1.58 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC) dctrn_result) dctrn_table
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
]
43 2.88 ms
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, touchedAt_13, headline_14 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post')) dctrn_result_inner ORDER BY touchedAt_13 DESC, headline_14 ASC) dctrn_result LIMIT 9
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
]
44 1.02 ms
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23, s0_.school_id AS school_id_24, s0_.department_id AS department_id_25, s0_.tenant AS tenant_26, s0_.createdBy AS createdBy_27, s0_.updatedBy AS updatedBy_28, s0_.touchedBy AS touchedBy_29 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC
Parameters:
[
  4
  "2024-11-06 03:05:34"
  149
  1
  8
  8
  "01j4w7mp90khzxd91rtmeaxfe3"
  "01j4vr8m60wt2jb3pznfnbsj9h"
  "01hygygv3rkf596hw1f4d633ys"
  "01hydyczc84smz4yht40cnr7nj"
  "01hybk94h0at5dsdq9rj40jx61"
  "01hvs6m6y0qt3hgfdn0vfsgfqx"
  "01hvmc98203ax37g84zd1wyj3r"
  "01hkdjyexr13z2k460hzwe7qke"
  "01hke15gegykf2g34bkvnwj751"
]
45 0.52 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01hybk94h0at5dsdq9rj40jx61"
]
46 0.43 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01hvs6m6y0qt3hgfdn0vfsgfqx"
]
47 0.46 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01hvmc98203ax37g84zd1wyj3r"
]
48 0.43 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01hkdjyexr13z2k460hzwe7qke"
]
49 0.45 ms
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
  "01hke15gegykf2g34bkvnwj751"
]
50 0.39 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01hybk7zdg4cmfgws16nfqp3k2"
]
51 0.42 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01hvs6kmc8x1c5n6yp8vnrp7fr"
]
52 0.35 ms
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
  "01hvmc8fmr6grzek4t4bjx9s4n"
]
53 29.55 ms
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:
[
  2
]
54 21.77 ms
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
]
55 0.74 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.id = ? AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1))
Parameters:
[
  10814
]
56 10.53 ms
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
]
57 24.79 ms
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-06 03:05:35"
  "2024-11-06 03:05:35"
]
58 0.56 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_.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"
]
59 0.61 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
]
60 4.76 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
  ""
]
61 0.42 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
]
62 0.72 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.

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\ImportBundle\Entity\Import 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\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\PageBundle\Entity\Page\PageProxy No errors.
Cms\FileBundle\Entity\Nodes\File No errors.
Cms\Modules\PageBundle\Entity\Page\PageHistory No errors.
Cms\Modules\PageBundle\Entity\Page\PageDraft No errors.
Cms\ThemeBundle\Entity\TwigSource No errors.
App\Entity\System\School No errors.
App\Entity\System\SocialAccount No errors.
App\Entity\Feed\Entry\AbstractContentEntry No errors.
App\Entity\Content\AbstractObject No errors.
App\Entity\Content\Alerts\Alert\AlertObject No errors.
App\Entity\Content\Events\Event\EventObject No errors.
App\Entity\Content\Exhibits\Gallery\GalleryObject No errors.
App\Entity\Content\Exhibits\Video\VideoObject No errors.
App\Entity\Content\Posts\Post\PostObject No errors.
App\Entity\Feed\AbstractEntry No errors.
App\Entity\Feed\Entry\ContentEventEntry No errors.
App\Entity\Feed\Entry\ContentGalleryEntry No errors.
App\Entity\Feed\Entry\ContentPostEntry No errors.
App\Entity\Feed\Entry\ContentVideoEntry No errors.
App\Entity\Content\AbstractDraft No errors.
App\Entity\Filesystem\LooseFile No errors.
App\Entity\Filesystem\LooseFolder No errors.
Cms\Modules\CalendarBundle\Entity\Event\EventProxy No errors.
Cms\Modules\CalendarBundle\Entity\ModuleSettings No errors.
Cms\TagBundle\Entity\Tag No errors.
Cms\SyncBundle\Entity\Sync No errors.
Cms\Modules\CalendarBundle\Entity\Event\EventHistory No errors.
Cms\Modules\CalendarBundle\Entity\Event\EventDraft No errors.
Cms\Modules\AlertBundle\Entity\ModuleSettings No errors.
Cms\Modules\AlertBundle\Entity\Alert\AlertProxy No errors.
Cms\Modules\AlertBundle\Entity\Alert\AlertHistory No errors.
Cms\Modules\AlertBundle\Entity\Alert\AlertDraft No errors.