Symfony Profiler

SELECT
  t0.status AS status_1,
  t0.semaphore AS semaphore_2,
  t0.channels AS channels_3,
  t0.servicesTotal AS servicesTotal_4,
  t0.servicesProcessing AS servicesProcessing_5,
  t0.servicesSucceeded AS servicesSucceeded_6,
  t0.servicesFailed AS servicesFailed_7,
  t0.messagesTotal AS messagesTotal_8,
  t0.messagesProcessing AS messagesProcessing_9,
  t0.messagesSucceeded AS messagesSucceeded_10,
  t0.messagesFailed AS messagesFailed_11,
  t0.messagesDelivered AS messagesDelivered_12,
  t0.messagesUndelivered AS messagesUndelivered_13,
  t0.firstActivityAt AS firstActivityAt_14,
  t0.lastActivityAt AS lastActivityAt_15,
  t0.lastDeliveryAt AS lastDeliveryAt_16,
  t0.error AS error_17,
  t0.errorCount AS errorCount_18,
  t0.id AS id_19,
  t0.uid AS uid_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.touchedAt AS touchedAt_23,
  t0.appTotal AS appTotal_24,
  t0.appProcessing AS appProcessing_25,
  t0.appSucceeded AS appSucceeded_26,
  t0.appFailed AS appFailed_27,
  t0.appDelivered AS appDelivered_28,
  t0.appUndelivered AS appUndelivered_29,
  t0.appError AS appError_30,
  t0.emailTotal AS emailTotal_31,
  t0.emailProcessing AS emailProcessing_32,
  t0.emailSucceeded AS emailSucceeded_33,
  t0.emailFailed AS emailFailed_34,
  t0.emailDelivered AS emailDelivered_35,
  t0.emailUndelivered AS emailUndelivered_36,
  t0.emailOpened AS emailOpened_37,
  t0.emailSpammed AS emailSpammed_38,
  t0.emailError AS emailError_39,
  t0.facebookTotal AS facebookTotal_40,
  t0.facebookProcessing AS facebookProcessing_41,
  t0.facebookSucceeded AS facebookSucceeded_42,
  t0.facebookFailed AS facebookFailed_43,
  t0.facebookError AS facebookError_44,
  t0.instagramTotal AS instagramTotal_45,
  t0.instagramProcessing AS instagramProcessing_46,
  t0.instagramSucceeded AS instagramSucceeded_47,
  t0.instagramFailed AS instagramFailed_48,
  t0.instagramError AS instagramError_49,
  t0.smsTotal AS smsTotal_50,
  t0.smsProcessing AS smsProcessing_51,
  t0.smsSucceeded AS smsSucceeded_52,
  t0.smsFailed AS smsFailed_53,
  t0.smsDelivered AS smsDelivered_54,
  t0.smsUndelivered AS smsUndelivered_55,
  t0.smsError AS smsError_56,
  t0.twitterTotal AS twitterTotal_57,
  t0.twitterProcessing AS twitterProcessing_58,
  t0.twitterSucceeded AS twitterSucceeded_59,
  t0.twitterFailed AS twitterFailed_60,
  t0.twitterError AS twitterError_61,
  t0.voiceTotal AS voiceTotal_62,
  t0.voiceProcessing AS voiceProcessing_63,
  t0.voiceSucceeded AS voiceSucceeded_64,
  t0.voiceFailed AS voiceFailed_65,
  t0.voiceDelivered AS voiceDelivered_66,
  t0.voiceUndelivered AS voiceUndelivered_67,
  t0.voiceAnswered AS voiceAnswered_68,
  t0.voiceError AS voiceError_69,
  t0.websiteTotal AS websiteTotal_70,
  t0.websiteProcessing AS websiteProcessing_71,
  t0.websiteSucceeded AS websiteSucceeded_72,
  t0.websiteFailed AS websiteFailed_73,
  t0.websiteError AS websiteError_74,
  t0.notification AS notification_75,
  t0.tenant AS tenant_76,
  t0.createdBy AS createdBy_77,
  t0.updatedBy AS updatedBy_78,
  t0.touchedBy AS touchedBy_79
FROM
  notis__job t0
WHERE
  t0.notification = ?
  AND (
    (t0.tenant = 1)
  )
ORDER BY
  t0.createdAt DESC

SELECT t0.status AS status_1, t0.semaphore AS semaphore_2, t0.channels AS channels_3, t0.servicesTotal AS servicesTotal_4, t0.servicesProcessing AS servicesProcessing_5, t0.servicesSucceeded AS servicesSucceeded_6, t0.servicesFailed AS servicesFailed_7, t0.messagesTotal AS messagesTotal_8, t0.messagesProcessing AS messagesProcessing_9, t0.messagesSucceeded AS messagesSucceeded_10, t0.messagesFailed AS messagesFailed_11, t0.messagesDelivered AS messagesDelivered_12, t0.messagesUndelivered AS messagesUndelivered_13, t0.firstActivityAt AS firstActivityAt_14, t0.lastActivityAt AS lastActivityAt_15, t0.lastDeliveryAt AS lastDeliveryAt_16, t0.error AS error_17, t0.errorCount AS errorCount_18, t0.id AS id_19, t0.uid AS uid_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.touchedAt AS touchedAt_23, t0.appTotal AS appTotal_24, t0.appProcessing AS appProcessing_25, t0.appSucceeded AS appSucceeded_26, t0.appFailed AS appFailed_27, t0.appDelivered AS appDelivered_28, t0.appUndelivered AS appUndelivered_29, t0.appError AS appError_30, t0.emailTotal AS emailTotal_31, t0.emailProcessing AS emailProcessing_32, t0.emailSucceeded AS emailSucceeded_33, t0.emailFailed AS emailFailed_34, t0.emailDelivered AS emailDelivered_35, t0.emailUndelivered AS emailUndelivered_36, t0.emailOpened AS emailOpened_37, t0.emailSpammed AS emailSpammed_38, t0.emailError AS emailError_39, t0.facebookTotal AS facebookTotal_40, t0.facebookProcessing AS facebookProcessing_41, t0.facebookSucceeded AS facebookSucceeded_42, t0.facebookFailed AS facebookFailed_43, t0.facebookError AS facebookError_44, t0.instagramTotal AS instagramTotal_45, t0.instagramProcessing AS instagramProcessing_46, t0.instagramSucceeded AS instagramSucceeded_47, t0.instagramFailed AS instagramFailed_48, t0.instagramError AS instagramError_49, t0.smsTotal AS smsTotal_50, t0.smsProcessing AS smsProcessing_51, t0.smsSucceeded AS smsSucceeded_52, t0.smsFailed AS smsFailed_53, t0.smsDelivered AS smsDelivered_54, t0.smsUndelivered AS smsUndelivered_55, t0.smsError AS smsError_56, t0.twitterTotal AS twitterTotal_57, t0.twitterProcessing AS twitterProcessing_58, t0.twitterSucceeded AS twitterSucceeded_59, t0.twitterFailed AS twitterFailed_60, t0.twitterError AS twitterError_61, t0.voiceTotal AS voiceTotal_62, t0.voiceProcessing AS voiceProcessing_63, t0.voiceSucceeded AS voiceSucceeded_64, t0.voiceFailed AS voiceFailed_65, t0.voiceDelivered AS voiceDelivered_66, t0.voiceUndelivered AS voiceUndelivered_67, t0.voiceAnswered AS voiceAnswered_68, t0.voiceError AS voiceError_69, t0.websiteTotal AS websiteTotal_70, t0.websiteProcessing AS websiteProcessing_71, t0.websiteSucceeded AS websiteSucceeded_72, t0.websiteFailed AS websiteFailed_73, t0.websiteError AS websiteError_74, t0.notification AS notification_75, t0.tenant AS tenant_76, t0.createdBy AS createdBy_77, t0.updatedBy AS updatedBy_78, t0.touchedBy AS touchedBy_79 FROM notis__job t0 WHERE t0.notification = 2538 AND ((t0.tenant = 1)) ORDER BY t0.createdAt DESC;

SELECT
  t0.name AS name_1,
  t0.types AS types_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.onerosterId AS onerosterId_8,
  t0.onerosterArchived AS onerosterArchived_9,
  t0.flags AS flags_10,
  t0.alias AS alias_11,
  t0.school AS school_12,
  t0.tenant AS tenant_13,
  t0.createdBy AS createdBy_14,
  t0.updatedBy AS updatedBy_15,
  t0.touchedBy AS touchedBy_16,
  t0.discr,
  t0.conditionQuery AS conditionQuery_17
FROM
  notis__list t0
  INNER JOIN notis__notification_x_list ON t0.id = notis__notification_x_list.list
WHERE
  notis__notification_x_list.notification = ?
  AND t0.discr IN (
    'district', 'static', 'school', 'condition'
  )
  AND (
    (t0.tenant = 1)
  )

SELECT t0.name AS name_1, t0.types AS types_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.onerosterId AS onerosterId_8, t0.onerosterArchived AS onerosterArchived_9, t0.flags AS flags_10, t0.alias AS alias_11, t0.school AS school_12, t0.tenant AS tenant_13, t0.createdBy AS createdBy_14, t0.updatedBy AS updatedBy_15, t0.touchedBy AS touchedBy_16, t0.discr, t0.conditionQuery AS conditionQuery_17 FROM notis__list t0 INNER JOIN notis__notification_x_list ON t0.id = notis__notification_x_list.list WHERE notis__notification_x_list.notification = 2538 AND t0.discr IN ('district', 'static', 'school', 'condition') AND ((t0.tenant = 1));

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__student n0_
WHERE
  (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__student n0_ WHERE (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  t0.strategies AS strategies_1,
  t0.vendor AS vendor_2,
  t0.apiClientId AS apiClientId_3,
  t0.apiClientSecret AS apiClientSecret_4,
  t0.apiAppName AS apiAppName_5,
  t0.apiToken AS apiToken_6,
  t0.districtId AS districtId_7,
  t0.baseUri AS baseUri_8,
  t0.active AS active_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.flags AS flags_15,
  t0.semaphore AS semaphore_16,
  t0.schedule AS schedule_17,
  t0.lastRunAt AS lastRunAt_18,
  t0.nextRunAt AS nextRunAt_19,
  t0.tenant AS tenant_20,
  t0.createdBy AS createdBy_21,
  t0.updatedBy AS updatedBy_22,
  t0.touchedBy AS touchedBy_23
FROM
  cms__one_roster__sync t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    n0_.role IN (?)
    AND (n0_.reachability & ?) > 0
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN ('community') AND (n0_.reachability & 6) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  n0_.urgent AS urgent_0,
  n0_.templateChannels AS templateChannels_1,
  n0_.status AS status_2,
  n0_.facades AS facades_3,
  n0_.scheduledAt AS scheduledAt_4,
  n0_.id AS id_5,
  n0_.uid AS uid_6,
  n0_.createdAt AS createdAt_7,
  n0_.updatedAt AS updatedAt_8,
  n0_.touchedAt AS touchedAt_9,
  n0_.channels AS channels_10,
  n0_.locale AS locale_11,
  n0_.title AS title_12,
  n0_.description AS description_13,
  n0_.script AS script_14,
  n0_.html AS html_15,
  n0_.media AS media_16,
  n0_.emailName AS emailName_17,
  n0_.emailFrom AS emailFrom_18,
  n0_.smsUrl AS smsUrl_19,
  n0_.facebookNote AS facebookNote_20,
  n0_.twitterNote AS twitterNote_21,
  n0_.websiteBehavior AS websiteBehavior_22,
  n0_.websiteLevel AS websiteLevel_23,
  n0_.websiteEndDateTime AS websiteEndDateTime_24,
  n0_.flags AS flags_25,
  n0_.semaphore AS semaphore_26,
  n0_.discr AS discr_27,
  n0_.branding AS branding_28,
  n0_.tenant AS tenant_29,
  n0_.createdBy AS createdBy_30,
  n0_.updatedBy AS updatedBy_31,
  n0_.touchedBy AS touchedBy_32,
  n0_.recording AS recording_33,
  n0_.voiceCallerId AS voiceCallerId_34
FROM
  notis__notification n0_
WHERE
  (
    (n0_.status <> ?)
    AND (n0_.tenant = 1)
  )
  AND n0_.discr IN ('message')
ORDER BY
  n0_.touchedAt DESC
LIMIT
  6

SELECT n0_.urgent AS urgent_0, n0_.templateChannels AS templateChannels_1, n0_.status AS status_2, n0_.facades AS facades_3, n0_.scheduledAt AS scheduledAt_4, n0_.id AS id_5, n0_.uid AS uid_6, n0_.createdAt AS createdAt_7, n0_.updatedAt AS updatedAt_8, n0_.touchedAt AS touchedAt_9, n0_.channels AS channels_10, n0_.locale AS locale_11, n0_.title AS title_12, n0_.description AS description_13, n0_.script AS script_14, n0_.html AS html_15, n0_.media AS media_16, n0_.emailName AS emailName_17, n0_.emailFrom AS emailFrom_18, n0_.smsUrl AS smsUrl_19, n0_.facebookNote AS facebookNote_20, n0_.twitterNote AS twitterNote_21, n0_.websiteBehavior AS websiteBehavior_22, n0_.websiteLevel AS websiteLevel_23, n0_.websiteEndDateTime AS websiteEndDateTime_24, n0_.flags AS flags_25, n0_.semaphore AS semaphore_26, n0_.discr AS discr_27, n0_.branding AS branding_28, n0_.tenant AS tenant_29, n0_.createdBy AS createdBy_30, n0_.updatedBy AS updatedBy_31, n0_.touchedBy AS touchedBy_32, n0_.recording AS recording_33, n0_.voiceCallerId AS voiceCallerId_34 FROM notis__notification n0_ WHERE ((n0_.status <> 0) AND (n0_.tenant = 1)) AND n0_.discr IN ('message') ORDER BY n0_.touchedAt DESC LIMIT 6;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id)
  AND n2_.discr IN ('email')
  AND (n2_.tenant = 1)
WHERE
  (
    n2_.id IS NOT NULL
    AND (n1_.primaryPreferences & ?) > 0
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id) AND n2_.discr IN ('email') AND (n2_.tenant = 1) WHERE (n2_.id IS NOT NULL AND (n1_.primaryPreferences & 4) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__notification n0_
WHERE
  (
    (
      n0_.status IN (?, ?)
      AND n0_.touchedAt >= ?
    )
    AND (n0_.tenant = 1)
  )
  AND n0_.discr IN ('message')

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__notification n0_ WHERE ((n0_.status IN (2, 4) AND n0_.touchedAt >= '2024-10-15 03:24:40') AND (n0_.tenant = 1)) AND n0_.discr IN ('message');

SELECT
  t0.status AS status_1,
  t0.startPhase AS startPhase_2,
  t0.phasesReady AS phasesReady_3,
  t0.phasesRunning AS phasesRunning_4,
  t0.phasesComplete AS phasesComplete_5,
  t0.firstActivityAt AS firstActivityAt_6,
  t0.lastActivityAt AS lastActivityAt_7,
  t0.semaphore AS semaphore_8,
  t0.error AS error_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.sync AS sync_15,
  t0.tenant AS tenant_16,
  t0.createdBy AS createdBy_17,
  t0.updatedBy AS updatedBy_18,
  t0.touchedBy AS touchedBy_19
FROM
  cms__one_roster__job t0
WHERE
  t0.sync = ?
  AND (
    (t0.tenant = 1)
  )
ORDER BY
  t0.createdAt DESC

SELECT t0.status AS status_1, t0.startPhase AS startPhase_2, t0.phasesReady AS phasesReady_3, t0.phasesRunning AS phasesRunning_4, t0.phasesComplete AS phasesComplete_5, t0.firstActivityAt AS firstActivityAt_6, t0.lastActivityAt AS lastActivityAt_7, t0.semaphore AS semaphore_8, t0.error AS error_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.sync AS sync_15, t0.tenant AS tenant_16, t0.createdBy AS createdBy_17, t0.updatedBy AS updatedBy_18, t0.touchedBy AS touchedBy_19 FROM cms__one_roster__job t0 WHERE t0.sync = 16 AND ((t0.tenant = 1)) ORDER BY t0.createdAt DESC;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id)
  AND n2_.discr IN ('phone')
  AND (n2_.tenant = 1)
WHERE
  (
    n2_.id IS NOT NULL
    AND (n1_.primaryPreferences & ?) > 0
    AND n2_.method IN (?, ?)
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id) AND n2_.discr IN ('phone') AND (n2_.tenant = 1) WHERE (n2_.id IS NOT NULL AND (n1_.primaryPreferences & 2) > 0 AND n2_.method IN (1, 4)) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

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

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

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__student n0_
WHERE
  (
    (n0_.reachability & ?) > 0
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__student n0_ WHERE ((n0_.reachability & 6) > 0) AND (n0_.discarded = 0) AND (n0_.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.id = ?
  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.id = 106 AND ((t0.tenant = 1));

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    (n0_.reachability & ?) > 0
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE ((n0_.reachability & 6) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    n0_.role IN (?, ?, ?)
    AND (n0_.reachability & ?) > 0
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN ('guardian', 'parent', 'relative') AND (n0_.reachability & 6) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    n0_.role IN (?, ?, ?, ?, ?)
    AND (n0_.reachability & ?) > 0
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN ('administrator', 'aide', 'proctor', 'teacher', 'staff') AND (n0_.reachability & 6) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id)
  AND n2_.discr IN ('app')
  AND (n2_.tenant = 1)
WHERE
  (
    n2_.id IS NOT NULL
    AND (n1_.primaryPreferences & ?) > 0
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id) AND n2_.discr IN ('app') AND (n2_.tenant = 1) WHERE (n2_.id IS NOT NULL AND (n1_.primaryPreferences & 8) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

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

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

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__student n0_
WHERE
  (n0_.reachability = ?)
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__student n0_ WHERE (n0_.reachability = 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(*)
FROM
  sys__school t0
WHERE
  (
    (t0.tenant = 1)
  )

SELECT COUNT(*) FROM sys__school t0 WHERE ((t0.tenant = 1));

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

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    n0_.role IN (?)
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN ('community')) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    n0_.role IN (?, ?, ?, ?, ?)
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN ('administrator', 'aide', 'proctor', 'teacher', 'staff')) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    n0_.role IN (?)
    AND n0_.reachability = ?
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN ('community') AND n0_.reachability = 0) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notis__profile n0_
WHERE
  (
    n0_.role IN (?, ?, ?, ?, ?)
    AND n0_.reachability = ?
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)