Symfony Profiler

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

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 = 149 AND ((s1_.schoolType & 1) > 0 OR s1_.department IN (149)) AND s1_.boosted = 1 AND s1_.visibility = 4 AND s1_.timestamp <= '2024-11-06 03:05:34' AND (s0_.channels & 8) = 8) 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;

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_.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

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 (149) AND (((c0_.data_startDate >= '2024-11-01 04:00:00' AND c0_.data_startDate < '2024-12-01 05:00:00') OR (c0_.data_endDate > '2024-11-01 04:00:00' AND c0_.data_endDate < '2024-12-01 05:00:00') OR (c0_.data_startDate < '2024-11-01 04:00:00' AND c0_.data_endDate >= '2024-12-01 05:00:00')))) AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_startDate ASC, c0_.data_endDate ASC;

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

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 = 2 AND ((t0.tenant = 1));

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

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;

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 = 'index' 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-06 03:05:35' AND c0_.data_expiryDate >= '2024-11-06 03:05:35') 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.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;