Symfony Profiler

SELECT
  n0_.name AS name_0,
  n0_.types AS types_1,
  n0_.id AS id_2,
  n0_.uid AS uid_3,
  n0_.createdAt AS createdAt_4,
  n0_.updatedAt AS updatedAt_5,
  n0_.touchedAt AS touchedAt_6,
  n0_.onerosterId AS onerosterId_7,
  n0_.onerosterArchived AS onerosterArchived_8,
  n0_.flags AS flags_9,
  n0_.alias AS alias_10,
  n0_.conditionQuery AS conditionQuery_11,
  n0_.discr AS discr_12,
  n0_.school AS school_13,
  n0_.tenant AS tenant_14,
  n0_.createdBy AS createdBy_15,
  n0_.updatedBy AS updatedBy_16,
  n0_.touchedBy AS touchedBy_17
FROM
  notis__list n0_
WHERE
  (
    (n0_.tenant = 46)
  )
  AND n0_.discr IN (
    'district', 'static', 'school', 'condition'
  )
ORDER BY
  n0_.name ASC

SELECT n0_.name AS name_0, n0_.types AS types_1, n0_.id AS id_2, n0_.uid AS uid_3, n0_.createdAt AS createdAt_4, n0_.updatedAt AS updatedAt_5, n0_.touchedAt AS touchedAt_6, n0_.onerosterId AS onerosterId_7, n0_.onerosterArchived AS onerosterArchived_8, n0_.flags AS flags_9, n0_.alias AS alias_10, n0_.conditionQuery AS conditionQuery_11, n0_.discr AS discr_12, n0_.school AS school_13, n0_.tenant AS tenant_14, n0_.createdBy AS createdBy_15, n0_.updatedBy AS updatedBy_16, n0_.touchedBy AS touchedBy_17 FROM notis__list n0_ WHERE ((n0_.tenant = 46)) AND n0_.discr IN ('district', 'static', 'school', 'condition') ORDER BY n0_.name ASC;

SELECT
  s0_.name AS name_0,
  s0_.type AS type_1,
  s0_.oneRosterOrg AS oneRosterOrg_2,
  s0_.id AS id_3,
  s0_.uid AS uid_4,
  s0_.createdAt AS createdAt_5,
  s0_.updatedAt AS updatedAt_6,
  s0_.touchedAt AS touchedAt_7,
  s0_.ulid AS ulid_8,
  s0_.details_phone AS details_phone_9,
  s0_.details_fax AS details_fax_10,
  s0_.details_links AS details_links_11,
  s0_.details_inquiryEmails AS details_inquiryEmails_12,
  s0_.details_checkupEmails AS details_checkupEmails_13,
  s0_.details_sisUrl AS details_sisUrl_14,
  s0_.details_contactManagement AS details_contactManagement_15,
  s0_.details_address_recipient AS details_address_recipient_16,
  s0_.details_address_organization AS details_address_organization_17,
  s0_.details_address_street AS details_address_street_18,
  s0_.details_address_unit AS details_address_unit_19,
  s0_.details_address_city AS details_address_city_20,
  s0_.details_address_state AS details_address_state_21,
  s0_.details_address_postalCode AS details_address_postalCode_22,
  s0_.details_address_country AS details_address_country_23,
  s0_.branding_bust AS branding_bust_24,
  s0_.branding_images AS branding_images_25,
  s0_.branding_colorPrimary AS branding_colorPrimary_26,
  s0_.branding_colorSecondary AS branding_colorSecondary_27,
  s0_.branding_colorTertiary AS branding_colorTertiary_28,
  s0_.branding_colorMobileHeader AS branding_colorMobileHeader_29,
  s0_.branding_colorMobileText AS branding_colorMobileText_30,
  s0_.mobile_shortcuts AS mobile_shortcuts_31,
  s0_.mobile_directoryUrl AS mobile_directoryUrl_32,
  s0_.department AS department_33,
  s0_.tenant AS tenant_34,
  s0_.createdBy AS createdBy_35,
  s0_.updatedBy AS updatedBy_36,
  s0_.touchedBy AS touchedBy_37
FROM
  sys__school s0_
WHERE
  (s0_.tenant = 46)
ORDER BY
  s0_.name ASC

SELECT s0_.name AS name_0, s0_.type AS type_1, s0_.oneRosterOrg AS oneRosterOrg_2, s0_.id AS id_3, s0_.uid AS uid_4, s0_.createdAt AS createdAt_5, s0_.updatedAt AS updatedAt_6, s0_.touchedAt AS touchedAt_7, s0_.ulid AS ulid_8, s0_.details_phone AS details_phone_9, s0_.details_fax AS details_fax_10, s0_.details_links AS details_links_11, s0_.details_inquiryEmails AS details_inquiryEmails_12, s0_.details_checkupEmails AS details_checkupEmails_13, s0_.details_sisUrl AS details_sisUrl_14, s0_.details_contactManagement AS details_contactManagement_15, s0_.details_address_recipient AS details_address_recipient_16, s0_.details_address_organization AS details_address_organization_17, s0_.details_address_street AS details_address_street_18, s0_.details_address_unit AS details_address_unit_19, s0_.details_address_city AS details_address_city_20, s0_.details_address_state AS details_address_state_21, s0_.details_address_postalCode AS details_address_postalCode_22, s0_.details_address_country AS details_address_country_23, s0_.branding_bust AS branding_bust_24, s0_.branding_images AS branding_images_25, s0_.branding_colorPrimary AS branding_colorPrimary_26, s0_.branding_colorSecondary AS branding_colorSecondary_27, s0_.branding_colorTertiary AS branding_colorTertiary_28, s0_.branding_colorMobileHeader AS branding_colorMobileHeader_29, s0_.branding_colorMobileText AS branding_colorMobileText_30, s0_.mobile_shortcuts AS mobile_shortcuts_31, s0_.mobile_directoryUrl AS mobile_directoryUrl_32, s0_.department AS department_33, s0_.tenant AS tenant_34, s0_.createdBy AS createdBy_35, s0_.updatedBy AS updatedBy_36, s0_.touchedBy AS touchedBy_37 FROM sys__school s0_ WHERE (s0_.tenant = 46) ORDER BY s0_.name ASC;

SELECT
  c0_.name AS name_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_.permissions AS permissions_6,
  c0_.discr AS discr_7,
  c0_.tenant AS tenant_8,
  c0_.createdBy AS createdBy_9,
  c0_.updatedBy AS updatedBy_10,
  c0_.touchedBy AS touchedBy_11
FROM
  cms__security__access__role c0_
WHERE
  (
    (c0_.tenant = 46)
  )
  AND c0_.discr IN ('cms')
ORDER BY
  c0_.name ASC

SELECT c0_.name AS name_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_.permissions AS permissions_6, c0_.discr AS discr_7, c0_.tenant AS tenant_8, c0_.createdBy AS createdBy_9, c0_.updatedBy AS updatedBy_10, c0_.touchedBy AS touchedBy_11 FROM cms__security__access__role c0_ WHERE ((c0_.tenant = 46)) AND c0_.discr IN ('cms') ORDER BY c0_.name ASC;

SELECT
  t0.email AS email_1,
  t0.active AS active_2,
  t0.policyAcceptedOn AS policyAcceptedOn_3,
  t0.termsAcceptedOn AS termsAcceptedOn_4,
  t0.password AS password_5,
  t0.passwordChangedAt AS passwordChangedAt_6,
  t0.lastLoggedInAt AS lastLoggedInAt_7,
  t0.metadata AS metadata_8,
  t0.internalUid AS internalUid_9,
  t0.id AS id_10,
  t0.uid AS uid_11,
  t0.createdAt AS createdAt_12,
  t0.updatedAt AS updatedAt_13,
  t0.touchedAt AS touchedAt_14,
  t0.onerosterId AS onerosterId_15,
  t0.onerosterArchived AS onerosterArchived_16,
  t0.importIndex AS importIndex_17,
  t0.specialPermissions_superUser AS specialPermissions_superUser_18,
  t0.systemProfile_displayName AS systemProfile_displayName_19,
  t0.systemProfile_firstName AS systemProfile_firstName_20,
  t0.systemProfile_lastName AS systemProfile_lastName_21,
  t0.systemProfile_avatar AS systemProfile_avatar_22,
  t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_23,
  t0.tenant AS tenant_24,
  t0.createdBy AS createdBy_25,
  t0.updatedBy AS updatedBy_26,
  t0.touchedBy AS touchedBy_27,
  t0.import AS import_28
FROM
  cms__security__identity__account t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant = 46)
  )

SELECT t0.email AS email_1, t0.active AS active_2, t0.policyAcceptedOn AS policyAcceptedOn_3, t0.termsAcceptedOn AS termsAcceptedOn_4, t0.password AS password_5, t0.passwordChangedAt AS passwordChangedAt_6, t0.lastLoggedInAt AS lastLoggedInAt_7, t0.metadata AS metadata_8, t0.internalUid AS internalUid_9, t0.id AS id_10, t0.uid AS uid_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.onerosterId AS onerosterId_15, t0.onerosterArchived AS onerosterArchived_16, t0.importIndex AS importIndex_17, t0.specialPermissions_superUser AS specialPermissions_superUser_18, t0.systemProfile_displayName AS systemProfile_displayName_19, t0.systemProfile_firstName AS systemProfile_firstName_20, t0.systemProfile_lastName AS systemProfile_lastName_21, t0.systemProfile_avatar AS systemProfile_avatar_22, t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_23, t0.tenant AS tenant_24, t0.createdBy AS createdBy_25, t0.updatedBy AS updatedBy_26, t0.touchedBy AS touchedBy_27, t0.import AS import_28 FROM cms__security__identity__account t0 WHERE t0.id = '7363' AND ((t0.tenant = 46));

SELECT
  c0_.account AS sclr_0,
  c0_.role AS sclr_1,
  c0_.container AS sclr_2,
  c0_.inheritance AS inheritance_3,
  c0_.school AS sclr_4,
  c0_.list AS sclr_5
FROM
  cms__security__access__role_association c0_
WHERE
  (
    (c0_.account = ?)
    AND (c0_.tenant = 46)
  )
  AND c0_._discr IN ('account')

SELECT c0_.account AS sclr_0, c0_.role AS sclr_1, c0_.container AS sclr_2, c0_.inheritance AS inheritance_3, c0_.school AS sclr_4, c0_.list AS sclr_5 FROM cms__security__access__role_association c0_ WHERE ((c0_.account = 7363) AND (c0_.tenant = 46)) AND c0_._discr IN ('account');

SELECT
  c0_.account AS sclr_0,
  c0_.grp AS sclr_1
FROM
  cms__security__identity__group_account c0_
WHERE
  (c0_.account = ?)
  AND (c0_.tenant = 46)

SELECT c0_.account AS sclr_0, c0_.grp AS sclr_1 FROM cms__security__identity__group_account c0_ WHERE (c0_.account = 7363) AND (c0_.tenant = 46);

SELECT
  DISTINCT id_1
FROM
  (
    SELECT
      DISTINCT id_1,
      name_7,
      name_40,
      name_52
    FROM
      (
        SELECT
          c0_.inheritance AS inheritance_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_.importIndex AS importIndex_6,
          s1_.name AS name_7,
          s1_.type AS type_8,
          s1_.oneRosterOrg AS oneRosterOrg_9,
          s1_.id AS id_10,
          s1_.uid AS uid_11,
          s1_.createdAt AS createdAt_12,
          s1_.updatedAt AS updatedAt_13,
          s1_.touchedAt AS touchedAt_14,
          s1_.ulid AS ulid_15,
          s1_.details_phone AS details_phone_16,
          s1_.details_fax AS details_fax_17,
          s1_.details_links AS details_links_18,
          s1_.details_inquiryEmails AS details_inquiryEmails_19,
          s1_.details_checkupEmails AS details_checkupEmails_20,
          s1_.details_sisUrl AS details_sisUrl_21,
          s1_.details_contactManagement AS details_contactManagement_22,
          s1_.details_address_recipient AS details_address_recipient_23,
          s1_.details_address_organization AS details_address_organization_24,
          s1_.details_address_street AS details_address_street_25,
          s1_.details_address_unit AS details_address_unit_26,
          s1_.details_address_city AS details_address_city_27,
          s1_.details_address_state AS details_address_state_28,
          s1_.details_address_postalCode AS details_address_postalCode_29,
          s1_.details_address_country AS details_address_country_30,
          s1_.branding_bust AS branding_bust_31,
          s1_.branding_images AS branding_images_32,
          s1_.branding_colorPrimary AS branding_colorPrimary_33,
          s1_.branding_colorSecondary AS branding_colorSecondary_34,
          s1_.branding_colorTertiary AS branding_colorTertiary_35,
          s1_.branding_colorMobileHeader AS branding_colorMobileHeader_36,
          s1_.branding_colorMobileText AS branding_colorMobileText_37,
          s1_.mobile_shortcuts AS mobile_shortcuts_38,
          s1_.mobile_directoryUrl AS mobile_directoryUrl_39,
          n2_.name AS name_40,
          n2_.types AS types_41,
          n2_.id AS id_42,
          n2_.uid AS uid_43,
          n2_.createdAt AS createdAt_44,
          n2_.updatedAt AS updatedAt_45,
          n2_.touchedAt AS touchedAt_46,
          n2_.onerosterId AS onerosterId_47,
          n2_.onerosterArchived AS onerosterArchived_48,
          n2_.flags AS flags_49,
          n2_.alias AS alias_50,
          n2_.conditionQuery AS conditionQuery_51,
          c3_.name AS name_52,
          c3_.id AS id_53,
          c3_.uid AS uid_54,
          c3_.createdAt AS createdAt_55,
          c3_.updatedAt AS updatedAt_56,
          c3_.touchedAt AS touchedAt_57,
          c3_.permissions AS permissions_58,
          c0_._discr AS _discr_59,
          n2_.discr AS discr_60,
          c3_.discr AS discr_61
        FROM
          cms__security__access__role_association c0_
          INNER JOIN cms__security__access__role c3_ ON c0_.role = c3_.id
          AND c3_.discr IN ('cms', 'notification')
          AND (c3_.tenant = 46)
          LEFT JOIN sys__school s1_ ON c0_.school = s1_.id
          AND (s1_.tenant = 46)
          LEFT JOIN notis__list n2_ ON c0_.list = n2_.id
          AND n2_.discr IN (
            'district', 'static', 'school', 'condition'
          )
          AND (n2_.tenant = 46)
        WHERE
          (
            (
              (
                (
                  c3_.discr IN ('notification')
                  AND (
                    c0_.school IS NOT NULL
                    OR c0_.school IS NULL
                  )
                )
                OR (
                  c3_.discr IN ('notification')
                  AND c0_.list IS NOT NULL
                )
              )
              AND c0_.account = ?
            )
            AND (c0_.tenant = 46)
          )
          AND c0_._discr IN ('account')
      ) dctrn_result_inner
    ORDER BY
      name_7 ASC,
      name_40 ASC,
      name_52 ASC
  ) dctrn_result
LIMIT
  10000

SELECT DISTINCT id_1 FROM (SELECT DISTINCT id_1, name_7, name_40, name_52 FROM (SELECT c0_.inheritance AS inheritance_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_.importIndex AS importIndex_6, s1_.name AS name_7, s1_.type AS type_8, s1_.oneRosterOrg AS oneRosterOrg_9, s1_.id AS id_10, s1_.uid AS uid_11, s1_.createdAt AS createdAt_12, s1_.updatedAt AS updatedAt_13, s1_.touchedAt AS touchedAt_14, s1_.ulid AS ulid_15, s1_.details_phone AS details_phone_16, s1_.details_fax AS details_fax_17, s1_.details_links AS details_links_18, s1_.details_inquiryEmails AS details_inquiryEmails_19, s1_.details_checkupEmails AS details_checkupEmails_20, s1_.details_sisUrl AS details_sisUrl_21, s1_.details_contactManagement AS details_contactManagement_22, s1_.details_address_recipient AS details_address_recipient_23, s1_.details_address_organization AS details_address_organization_24, s1_.details_address_street AS details_address_street_25, s1_.details_address_unit AS details_address_unit_26, s1_.details_address_city AS details_address_city_27, s1_.details_address_state AS details_address_state_28, s1_.details_address_postalCode AS details_address_postalCode_29, s1_.details_address_country AS details_address_country_30, s1_.branding_bust AS branding_bust_31, s1_.branding_images AS branding_images_32, s1_.branding_colorPrimary AS branding_colorPrimary_33, s1_.branding_colorSecondary AS branding_colorSecondary_34, s1_.branding_colorTertiary AS branding_colorTertiary_35, s1_.branding_colorMobileHeader AS branding_colorMobileHeader_36, s1_.branding_colorMobileText AS branding_colorMobileText_37, s1_.mobile_shortcuts AS mobile_shortcuts_38, s1_.mobile_directoryUrl AS mobile_directoryUrl_39, n2_.name AS name_40, n2_.types AS types_41, n2_.id AS id_42, n2_.uid AS uid_43, n2_.createdAt AS createdAt_44, n2_.updatedAt AS updatedAt_45, n2_.touchedAt AS touchedAt_46, n2_.onerosterId AS onerosterId_47, n2_.onerosterArchived AS onerosterArchived_48, n2_.flags AS flags_49, n2_.alias AS alias_50, n2_.conditionQuery AS conditionQuery_51, c3_.name AS name_52, c3_.id AS id_53, c3_.uid AS uid_54, c3_.createdAt AS createdAt_55, c3_.updatedAt AS updatedAt_56, c3_.touchedAt AS touchedAt_57, c3_.permissions AS permissions_58, c0_._discr AS _discr_59, n2_.discr AS discr_60, c3_.discr AS discr_61 FROM cms__security__access__role_association c0_ INNER JOIN cms__security__access__role c3_ ON c0_.role = c3_.id AND c3_.discr IN ('cms', 'notification') AND (c3_.tenant = 46) LEFT JOIN sys__school s1_ ON c0_.school = s1_.id AND (s1_.tenant = 46) LEFT JOIN notis__list n2_ ON c0_.list = n2_.id AND n2_.discr IN ('district', 'static', 'school', 'condition') AND (n2_.tenant = 46) WHERE ((((c3_.discr IN ('notification') AND (c0_.school IS NOT NULL OR c0_.school IS NULL)) OR (c3_.discr IN ('notification') AND c0_.list IS NOT NULL)) AND c0_.account = 7308) AND (c0_.tenant = 46)) AND c0_._discr IN ('account')) dctrn_result_inner ORDER BY name_7 ASC, name_40 ASC, name_52 ASC) dctrn_result LIMIT 10000;

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.slug = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.status AS status_3, t0.emailsDisplay AS emailsDisplay_4, t0.policy AS policy_5, t0.disqusId AS disqusId_6, t0.googleToken AS googleToken_7, t0.stage AS stage_8, t0.teamworkTasklist AS teamworkTasklist_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.redirects AS redirects_12, t0.redirectCodes AS redirectCodes_13, t0.debugging AS debugging_14, t0.products AS products_15, t0.hubspotId AS hubspotId_16, t0.weglotId AS weglotId_17, t0.id AS id_18, t0.uid AS uid_19, t0.createdAt AS createdAt_20, t0.updatedAt AS updatedAt_21, t0.touchedAt AS touchedAt_22, t0.data_custom0 AS data_custom0_23, t0.data_custom1 AS data_custom1_24, t0.data_custom2 AS data_custom2_25, t0.data_custom3 AS data_custom3_26, t0.authenticationTypes AS authenticationTypes_27, t0.classlinkCustomerId AS classlinkCustomerId_28, t0.cleverCustomerId AS cleverCustomerId_29, t0.gg4lCustomerId AS gg4lCustomerId_30, t0.googleCustomerId AS googleCustomerId_31, t0.microsoftCustomerId AS microsoftCustomerId_32, t0.ulid AS ulid_33, t0.locale_timezone AS locale_timezone_34, t0.ada_reportsFolder AS ada_reportsFolder_35, t0.ada_reportsPrimary AS ada_reportsPrimary_36, t0.ada_reportsDocuments AS ada_reportsDocuments_37, t0.type_primary AS type_primary_38, t0.type_secondary AS type_secondary_39 FROM cms__tenant__tenant t0 WHERE t0.slug = 'anytownschdist2024' LIMIT 1;

SELECT
  c0_.name AS name_0,
  c0_.slug AS slug_1,
  c0_.hidden AS hidden_2,
  c0_.color AS color_3,
  c0_.code AS code_4,
  c0_.schoolNowMigrated AS schoolNowMigrated_5,
  c0_.id AS id_6,
  c0_.uid AS uid_7,
  c0_.createdAt AS createdAt_8,
  c0_.updatedAt AS updatedAt_9,
  c0_.touchedAt AS touchedAt_10,
  c0_.rt AS rt_11,
  c0_.lvl AS lvl_12,
  c0_.lft AS lft_13,
  c0_.rgt AS rgt_14,
  c0_.navigation AS navigation_15,
  c0_.moduleFlags_alert AS moduleFlags_alert_16,
  c0_.moduleFlags_blog AS moduleFlags_blog_17,
  c0_.moduleFlags_calendar AS moduleFlags_calendar_18,
  c0_.moduleFlags_gallery AS moduleFlags_gallery_19,
  c0_.moduleFlags_news AS moduleFlags_news_20,
  c0_.moduleFlags_page AS moduleFlags_page_21,
  c0_.moduleFlags_people AS moduleFlags_people_22,
  c0_.moduleFlags_question AS moduleFlags_question_23,
  c0_.moduleFlags_snippet AS moduleFlags_snippet_24,
  c0_.moduleFlags_feed AS moduleFlags_feed_25,
  c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26,
  c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27,
  c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28,
  c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29,
  c0_.preferred AS preferred_30,
  c0_.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,
  CASE WHEN c1_._discr IN (?) THEN
    0
  WHEN c1_._discr IN (?) THEN
    1
  WHEN c1_._discr IN (?) THEN
    2
  WHEN c1_._discr IN (?) THEN
    3
  ELSE
    4
  END AS sclr_37,
  c0_._discr AS _discr_38,
  c0_.parent AS parent_39,
  c0_.domain AS domain_40,
  c0_.tenant AS tenant_41,
  c0_.createdBy AS createdBy_42,
  c0_.updatedBy AS updatedBy_43,
  c0_.touchedBy AS touchedBy_44,
  c0_.defaultTheme AS defaultTheme_45,
  c0_.defaultOuterLayout AS defaultOuterLayout_46,
  c0_.defaultInnerLayout AS defaultInnerLayout_47,
  c0_.account AS account_48,
  c0_.container AS container_49,
  c0_.import AS import_50
FROM
  cms__container__container c0_
  LEFT JOIN cms__container__container c1_ ON (c0_.rt = c1_.id)
  AND c1_._discr IN (
    'generic', 'personal', 'intranet',
    'storage'
  )
  AND (c1_.tenant = 46)
WHERE
  (
    (
      c0_._discr IN ('generic')
      OR c0_._discr IN ('intranet')
    )
    AND (c0_.tenant = 46)
  )
  AND c0_._discr IN (
    'generic', 'personal', 'intranet',
    'storage'
  )
ORDER BY
  sclr_37 ASC,
  c1_.name ASC,
  c0_.rt ASC,
  c0_.lft ASC

SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.hidden AS hidden_2, c0_.color AS color_3, c0_.code AS code_4, c0_.schoolNowMigrated AS schoolNowMigrated_5, c0_.id AS id_6, c0_.uid AS uid_7, c0_.createdAt AS createdAt_8, c0_.updatedAt AS updatedAt_9, c0_.touchedAt AS touchedAt_10, c0_.rt AS rt_11, c0_.lvl AS lvl_12, c0_.lft AS lft_13, c0_.rgt AS rgt_14, c0_.navigation AS navigation_15, c0_.moduleFlags_alert AS moduleFlags_alert_16, c0_.moduleFlags_blog AS moduleFlags_blog_17, c0_.moduleFlags_calendar AS moduleFlags_calendar_18, c0_.moduleFlags_gallery AS moduleFlags_gallery_19, c0_.moduleFlags_news AS moduleFlags_news_20, c0_.moduleFlags_page AS moduleFlags_page_21, c0_.moduleFlags_people AS moduleFlags_people_22, c0_.moduleFlags_question AS moduleFlags_question_23, c0_.moduleFlags_snippet AS moduleFlags_snippet_24, c0_.moduleFlags_feed AS moduleFlags_feed_25, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29, c0_.preferred AS preferred_30, c0_.importIndex AS importIndex_31, c0_.feedSetting_blog AS feedSetting_blog_32, c0_.feedSetting_calendar AS feedSetting_calendar_33, c0_.feedSetting_news AS feedSetting_news_34, c0_.feedSetting_alert AS feedSetting_alert_35, c0_.preferred AS preferred_36, CASE WHEN c1_._discr IN ('generic') THEN 0 WHEN c1_._discr IN ('intranet') THEN 1 WHEN c1_._discr IN ('personal') THEN 2 WHEN c1_._discr IN ('storage') THEN 3 ELSE 4 END AS sclr_37, c0_._discr AS _discr_38, c0_.parent AS parent_39, c0_.domain AS domain_40, c0_.tenant AS tenant_41, c0_.createdBy AS createdBy_42, c0_.updatedBy AS updatedBy_43, c0_.touchedBy AS touchedBy_44, c0_.defaultTheme AS defaultTheme_45, c0_.defaultOuterLayout AS defaultOuterLayout_46, c0_.defaultInnerLayout AS defaultInnerLayout_47, c0_.account AS account_48, c0_.container AS container_49, c0_.import AS import_50 FROM cms__container__container c0_ LEFT JOIN cms__container__container c1_ ON (c0_.rt = c1_.id) AND c1_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c1_.tenant = 46) WHERE ((c0_._discr IN ('generic') OR c0_._discr IN ('intranet')) AND (c0_.tenant = 46)) AND c0_._discr IN ('generic', 'personal', 'intranet', 'storage') ORDER BY sclr_37 ASC, c1_.name ASC, c0_.rt ASC, c0_.lft ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          c0_.inheritance AS inheritance_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_.importIndex AS importIndex_6,
          c0_._discr AS _discr_7
        FROM
          cms__security__access__role_association c0_
          INNER JOIN cms__security__access__role c1_ ON c0_.role = c1_.id
          AND c1_.discr IN ('cms', 'notification')
          AND (c1_.tenant = 46)
          LEFT JOIN sys__school s2_ ON c0_.school = s2_.id
          AND (s2_.tenant = 46)
          LEFT JOIN notis__list n3_ ON c0_.list = n3_.id
          AND n3_.discr IN (
            'district', 'static', 'school', 'condition'
          )
          AND (n3_.tenant = 46)
        WHERE
          (
            (
              (
                (
                  c1_.discr IN ('notification')
                  AND (
                    c0_.school IS NOT NULL
                    OR c0_.school IS NULL
                  )
                )
                OR (
                  c1_.discr IN ('notification')
                  AND c0_.list IS NOT NULL
                )
              )
              AND c0_.account = ?
            )
            AND (c0_.tenant = 46)
          )
          AND c0_._discr IN ('account')
        ORDER BY
          s2_.name ASC,
          n3_.name ASC,
          c1_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT c0_.inheritance AS inheritance_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_.importIndex AS importIndex_6, c0_._discr AS _discr_7 FROM cms__security__access__role_association c0_ INNER JOIN cms__security__access__role c1_ ON c0_.role = c1_.id AND c1_.discr IN ('cms', 'notification') AND (c1_.tenant = 46) LEFT JOIN sys__school s2_ ON c0_.school = s2_.id AND (s2_.tenant = 46) LEFT JOIN notis__list n3_ ON c0_.list = n3_.id AND n3_.discr IN ('district', 'static', 'school', 'condition') AND (n3_.tenant = 46) WHERE ((((c1_.discr IN ('notification') AND (c0_.school IS NOT NULL OR c0_.school IS NULL)) OR (c1_.discr IN ('notification') AND c0_.list IS NOT NULL)) AND c0_.account = 7308) AND (c0_.tenant = 46)) AND c0_._discr IN ('account') ORDER BY s2_.name ASC, n3_.name ASC, c1_.name ASC) dctrn_result) dctrn_table;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          c0_.inheritance AS inheritance_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_.importIndex AS importIndex_6,
          c0_._discr AS _discr_7
        FROM
          cms__security__access__role_association c0_
          INNER JOIN cms__security__access__role c1_ ON c0_.role = c1_.id
          AND c1_.discr IN ('cms', 'notification')
          AND (c1_.tenant = 46)
          LEFT JOIN cms__container__container c2_ ON c0_.container = c2_.id
          AND c2_._discr IN (
            'generic', 'personal', 'intranet',
            'storage'
          )
          AND (c2_.tenant = 46)
        WHERE
          (
            (
              (
                c1_.discr IN ('cms')
                AND (
                  c0_.container IS NOT NULL
                  OR c0_.container IS NULL
                )
                AND (
                  c0_.school IS NULL
                  AND c0_.list IS NULL
                )
              )
              AND c0_.account = ?
            )
            AND (c0_.tenant = 46)
          )
          AND c0_._discr IN ('account')
        ORDER BY
          c2_.name ASC,
          c1_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT c0_.inheritance AS inheritance_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_.importIndex AS importIndex_6, c0_._discr AS _discr_7 FROM cms__security__access__role_association c0_ INNER JOIN cms__security__access__role c1_ ON c0_.role = c1_.id AND c1_.discr IN ('cms', 'notification') AND (c1_.tenant = 46) LEFT JOIN cms__container__container c2_ ON c0_.container = c2_.id AND c2_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c2_.tenant = 46) WHERE (((c1_.discr IN ('cms') AND (c0_.container IS NOT NULL OR c0_.container IS NULL) AND (c0_.school IS NULL AND c0_.list IS NULL)) AND c0_.account = 7308) AND (c0_.tenant = 46)) AND c0_._discr IN ('account') ORDER BY c2_.name ASC, c1_.name ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_1
FROM
  (
    SELECT
      DISTINCT id_1,
      name_7,
      name_44
    FROM
      (
        SELECT
          c0_.inheritance AS inheritance_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_.importIndex AS importIndex_6,
          c1_.name AS name_7,
          c1_.slug AS slug_8,
          c1_.hidden AS hidden_9,
          c1_.color AS color_10,
          c1_.code AS code_11,
          c1_.schoolNowMigrated AS schoolNowMigrated_12,
          c1_.id AS id_13,
          c1_.uid AS uid_14,
          c1_.createdAt AS createdAt_15,
          c1_.updatedAt AS updatedAt_16,
          c1_.touchedAt AS touchedAt_17,
          c1_.rt AS rt_18,
          c1_.lvl AS lvl_19,
          c1_.lft AS lft_20,
          c1_.rgt AS rgt_21,
          c1_.navigation AS navigation_22,
          c1_.moduleFlags_alert AS moduleFlags_alert_23,
          c1_.moduleFlags_blog AS moduleFlags_blog_24,
          c1_.moduleFlags_calendar AS moduleFlags_calendar_25,
          c1_.moduleFlags_gallery AS moduleFlags_gallery_26,
          c1_.moduleFlags_news AS moduleFlags_news_27,
          c1_.moduleFlags_page AS moduleFlags_page_28,
          c1_.moduleFlags_people AS moduleFlags_people_29,
          c1_.moduleFlags_question AS moduleFlags_question_30,
          c1_.moduleFlags_snippet AS moduleFlags_snippet_31,
          c1_.moduleFlags_feed AS moduleFlags_feed_32,
          c1_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_33,
          c1_.htmlOverrides_headScripts AS htmlOverrides_headScripts_34,
          c1_.htmlOverrides_topScripts AS htmlOverrides_topScripts_35,
          c1_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_36,
          c1_.preferred AS preferred_37,
          c1_.importIndex AS importIndex_38,
          c1_.feedSetting_blog AS feedSetting_blog_39,
          c1_.feedSetting_calendar AS feedSetting_calendar_40,
          c1_.feedSetting_news AS feedSetting_news_41,
          c1_.feedSetting_alert AS feedSetting_alert_42,
          c1_.preferred AS preferred_43,
          c2_.name AS name_44,
          c2_.id AS id_45,
          c2_.uid AS uid_46,
          c2_.createdAt AS createdAt_47,
          c2_.updatedAt AS updatedAt_48,
          c2_.touchedAt AS touchedAt_49,
          c2_.permissions AS permissions_50,
          c0_._discr AS _discr_51,
          c1_._discr AS _discr_52,
          c2_.discr AS discr_53
        FROM
          cms__security__access__role_association c0_
          INNER JOIN cms__security__access__role c2_ ON c0_.role = c2_.id
          AND c2_.discr IN ('cms', 'notification')
          AND (c2_.tenant = 46)
          LEFT JOIN cms__container__container c1_ ON c0_.container = c1_.id
          AND c1_._discr IN (
            'generic', 'personal', 'intranet',
            'storage'
          )
          AND (c1_.tenant = 46)
        WHERE
          (
            (
              (
                c2_.discr IN ('cms')
                AND (
                  c0_.container IS NOT NULL
                  OR c0_.container IS NULL
                )
                AND (
                  c0_.school IS NULL
                  AND c0_.list IS NULL
                )
              )
              AND c0_.account = ?
            )
            AND (c0_.tenant = 46)
          )
          AND c0_._discr IN ('account')
      ) dctrn_result_inner
    ORDER BY
      name_7 ASC,
      name_44 ASC
  ) dctrn_result
LIMIT
  10000