Symfony Profiler

"COMMIT"

"COMMIT";

INSERT INTO notis__job (
  status, semaphore, channels, servicesTotal,
  servicesProcessing, servicesSucceeded,
  servicesFailed, messagesTotal, messagesProcessing,
  messagesSucceeded, messagesFailed,
  messagesDelivered, messagesUndelivered,
  firstActivityAt, lastActivityAt,
  lastDeliveryAt, error, errorCount,
  uid, createdAt, updatedAt, touchedAt,
  appTotal, appProcessing, appSucceeded,
  appFailed, appDelivered, appUndelivered,
  appError, emailTotal, emailProcessing,
  emailSucceeded, emailFailed, emailDelivered,
  emailUndelivered, emailOpened, emailSpammed,
  emailError, facebookTotal, facebookProcessing,
  facebookSucceeded, facebookFailed,
  facebookError, instagramTotal, instagramProcessing,
  instagramSucceeded, instagramFailed,
  instagramError, smsTotal, smsProcessing,
  smsSucceeded, smsFailed, smsDelivered,
  smsUndelivered, smsError, twitterTotal,
  twitterProcessing, twitterSucceeded,
  twitterFailed, twitterError, voiceTotal,
  voiceProcessing, voiceSucceeded,
  voiceFailed, voiceDelivered, voiceUndelivered,
  voiceAnswered, voiceError, websiteTotal,
  websiteProcessing, websiteSucceeded,
  websiteFailed, websiteError, notification,
  tenant, createdBy, updatedBy, touchedBy
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO notis__job (status, semaphore, channels, servicesTotal, servicesProcessing, servicesSucceeded, servicesFailed, messagesTotal, messagesProcessing, messagesSucceeded, messagesFailed, messagesDelivered, messagesUndelivered, firstActivityAt, lastActivityAt, lastDeliveryAt, error, errorCount, uid, createdAt, updatedAt, touchedAt, appTotal, appProcessing, appSucceeded, appFailed, appDelivered, appUndelivered, appError, emailTotal, emailProcessing, emailSucceeded, emailFailed, emailDelivered, emailUndelivered, emailOpened, emailSpammed, emailError, facebookTotal, facebookProcessing, facebookSucceeded, facebookFailed, facebookError, instagramTotal, instagramProcessing, instagramSucceeded, instagramFailed, instagramError, smsTotal, smsProcessing, smsSucceeded, smsFailed, smsDelivered, smsUndelivered, smsError, twitterTotal, twitterProcessing, twitterSucceeded, twitterFailed, twitterError, voiceTotal, voiceProcessing, voiceSucceeded, voiceFailed, voiceDelivered, voiceUndelivered, voiceAnswered, voiceError, websiteTotal, websiteProcessing, websiteSucceeded, websiteFailed, websiteError, notification, tenant, createdBy, updatedBy, touchedBy) VALUES ('1', 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, 'a61069a8-a2fd-11ef-9091-02756dc5e3a5', '2024-11-15 02:59:36', NULL, '2024-11-15 02:59:36', 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, NULL, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, NULL, 2538, 1, 1, NULL, 1);

UPDATE
  notis__notification
SET
  status = 2,
  semaphore = NULL
WHERE
  (
    (id = ?)
    AND (notis__notification.tenant = 1)
  )
  AND discr IN ('message')

UPDATE notis__notification SET status = 2, semaphore = NULL WHERE ((id = 2538) AND (notis__notification.tenant = 1)) AND discr IN ('message');

UPDATE
  notis__job
SET
  status = 2
WHERE
  (id = ?)
  AND (notis__job.tenant = 1)

UPDATE notis__job SET status = 2 WHERE (id = 889) AND (notis__job.tenant = 1);

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  n0_.method AS method_0,
  n0_.recordedAt AS recordedAt_1,
  n0_.speechText AS speechText_2,
  n0_.speechTaskId AS speechTaskId_3,
  n0_.phoneCallId AS phoneCallId_4,
  n0_.phoneRecordingId AS phoneRecordingId_5,
  n0_.phoneRecordingUrl AS phoneRecordingUrl_6,
  n0_.phoneRecordingStatus AS phoneRecordingStatus_7,
  n0_.id AS id_8,
  n0_.uid AS uid_9,
  n0_.createdAt AS createdAt_10,
  n0_.updatedAt AS updatedAt_11,
  n0_.touchedAt AS touchedAt_12,
  n0_.tenant AS tenant_13,
  n0_.createdBy AS createdBy_14,
  n0_.updatedBy AS updatedBy_15,
  n0_.touchedBy AS touchedBy_16
FROM
  notis__recording n0_
  LEFT JOIN notis__translation n1_ ON (n1_.recording = n0_.id)
  AND (n1_.tenant = 1)
WHERE
  (n1_.id = ?)
  AND (n0_.tenant = 1)

SELECT n0_.method AS method_0, n0_.recordedAt AS recordedAt_1, n0_.speechText AS speechText_2, n0_.speechTaskId AS speechTaskId_3, n0_.phoneCallId AS phoneCallId_4, n0_.phoneRecordingId AS phoneRecordingId_5, n0_.phoneRecordingUrl AS phoneRecordingUrl_6, n0_.phoneRecordingStatus AS phoneRecordingStatus_7, n0_.id AS id_8, n0_.uid AS uid_9, n0_.createdAt AS createdAt_10, n0_.updatedAt AS updatedAt_11, n0_.touchedAt AS touchedAt_12, n0_.tenant AS tenant_13, n0_.createdBy AS createdBy_14, n0_.updatedBy AS updatedBy_15, n0_.touchedBy AS touchedBy_16 FROM notis__recording n0_ LEFT JOIN notis__translation n1_ ON (n1_.recording = n0_.id) AND (n1_.tenant = 1) WHERE (n1_.id = 2207) AND (n0_.tenant = 1);

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.createdAt AS createdAt_3,
  t0.updatedAt AS updatedAt_4,
  t0.touchedAt AS touchedAt_5,
  t0.channels AS channels_6,
  t0.locale AS locale_7,
  t0.title AS title_8,
  t0.description AS description_9,
  t0.script AS script_10,
  t0.html AS html_11,
  t0.media AS media_12,
  t0.flags AS flags_13,
  t0.notification AS notification_14,
  t0.template AS template_15,
  t0.tenant AS tenant_16,
  t0.createdBy AS createdBy_17,
  t0.updatedBy AS updatedBy_18,
  t0.touchedBy AS touchedBy_19,
  t0.recording AS recording_20
FROM
  notis__translation t0
WHERE
  t0.locale = ?
  AND t0.notification = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.touchedAt AS touchedAt_5, t0.channels AS channels_6, t0.locale AS locale_7, t0.title AS title_8, t0.description AS description_9, t0.script AS script_10, t0.html AS html_11, t0.media AS media_12, t0.flags AS flags_13, t0.notification AS notification_14, t0.template AS template_15, t0.tenant AS tenant_16, t0.createdBy AS createdBy_17, t0.updatedBy AS updatedBy_18, t0.touchedBy AS touchedBy_19, t0.recording AS recording_20 FROM notis__translation t0 WHERE t0.locale = 'es-ES' AND t0.notification = 2538 AND ((t0.tenant = 1)) LIMIT 1;

UPDATE
  notis__notification
SET
  channels = ?,
  updatedAt = ?,
  touchedAt = ?
WHERE
  id = ?

UPDATE notis__notification SET channels = '67', updatedAt = '2024-11-15 02:59:36', touchedAt = '2024-11-15 02:59:36' WHERE id = 2538;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  notis__job
SET
  semaphore = (semaphore + 1)
WHERE
  (id = ?)
  AND (notis__job.tenant = 1)

UPDATE notis__job SET semaphore = (semaphore + 1) WHERE (id = 889) AND (notis__job.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 = ?
  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
  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 = ?
  AND t0.type = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  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 AND t0.type = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.createdAt AS createdAt_3,
  t0.updatedAt AS updatedAt_4,
  t0.touchedAt AS touchedAt_5,
  t0.channels AS channels_6,
  t0.locale AS locale_7,
  t0.title AS title_8,
  t0.description AS description_9,
  t0.script AS script_10,
  t0.html AS html_11,
  t0.media AS media_12,
  t0.flags AS flags_13,
  t0.notification AS notification_14,
  t0.template AS template_15,
  t0.tenant AS tenant_16,
  t0.createdBy AS createdBy_17,
  t0.updatedBy AS updatedBy_18,
  t0.touchedBy AS touchedBy_19,
  t0.recording AS recording_20
FROM
  notis__translation t0
WHERE
  t0.notification = ?
  AND (
    (t0.tenant = 1)
  )
ORDER BY
  t0.locale ASC

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.touchedAt AS touchedAt_5, t0.channels AS channels_6, t0.locale AS locale_7, t0.title AS title_8, t0.description AS description_9, t0.script AS script_10, t0.html AS html_11, t0.media AS media_12, t0.flags AS flags_13, t0.notification AS notification_14, t0.template AS template_15, t0.tenant AS tenant_16, t0.createdBy AS createdBy_17, t0.updatedBy AS updatedBy_18, t0.touchedBy AS touchedBy_19, t0.recording AS recording_20 FROM notis__translation t0 WHERE t0.notification = 2538 AND ((t0.tenant = 1)) ORDER BY t0.locale ASC;

SELECT
  c0_.grp 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_.grp IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      )
    )
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN ('group')

SELECT c0_.grp 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_.grp IN (20, 93, 97, 103, 107, 108, 112, 143, 147, 148, 156, 158, 162, 168, 172, 173, 177, 183, 187, 251)) AND (c0_.tenant = 1)) AND c0_._discr IN ('group');

UPDATE
  notis__notification
SET
  status = ?,
  updatedAt = ?,
  touchedAt = ?
WHERE
  id = ?

UPDATE notis__notification SET status = '1', updatedAt = '2024-11-15 02:59:36', touchedAt = '2024-11-15 02:59:36' WHERE id = 2538;

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 = 'staging' LIMIT 1;

SELECT
  t0.urgent AS urgent_1,
  t0.templateChannels AS templateChannels_2,
  t0.status AS status_3,
  t0.facades AS facades_4,
  t0.scheduledAt AS scheduledAt_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.channels AS channels_11,
  t0.locale AS locale_12,
  t0.title AS title_13,
  t0.description AS description_14,
  t0.script AS script_15,
  t0.html AS html_16,
  t0.media AS media_17,
  t0.emailName AS emailName_18,
  t0.emailFrom AS emailFrom_19,
  t0.smsUrl AS smsUrl_20,
  t0.facebookNote AS facebookNote_21,
  t0.twitterNote AS twitterNote_22,
  t0.websiteBehavior AS websiteBehavior_23,
  t0.websiteLevel AS websiteLevel_24,
  t0.websiteEndDateTime AS websiteEndDateTime_25,
  t0.flags AS flags_26,
  t0.semaphore AS semaphore_27,
  t0.branding AS branding_28,
  t0.tenant AS tenant_29,
  t0.createdBy AS createdBy_30,
  t0.updatedBy AS updatedBy_31,
  t0.touchedBy AS touchedBy_32,
  t0.recording AS recording_33,
  t0.voiceCallerId AS voiceCallerId_34,
  t0.discr
FROM
  notis__notification t0
WHERE
  t0.id = ?
  AND t0.discr IN ('message')
  AND (
    (t0.tenant = 1)
  )

SELECT t0.urgent AS urgent_1, t0.templateChannels AS templateChannels_2, t0.status AS status_3, t0.facades AS facades_4, t0.scheduledAt AS scheduledAt_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.channels AS channels_11, t0.locale AS locale_12, t0.title AS title_13, t0.description AS description_14, t0.script AS script_15, t0.html AS html_16, t0.media AS media_17, t0.emailName AS emailName_18, t0.emailFrom AS emailFrom_19, t0.smsUrl AS smsUrl_20, t0.facebookNote AS facebookNote_21, t0.twitterNote AS twitterNote_22, t0.websiteBehavior AS websiteBehavior_23, t0.websiteLevel AS websiteLevel_24, t0.websiteEndDateTime AS websiteEndDateTime_25, t0.flags AS flags_26, t0.semaphore AS semaphore_27, t0.branding AS branding_28, t0.tenant AS tenant_29, t0.createdBy AS createdBy_30, t0.updatedBy AS updatedBy_31, t0.touchedBy AS touchedBy_32, t0.recording AS recording_33, t0.voiceCallerId AS voiceCallerId_34, t0.discr FROM notis__notification t0 WHERE t0.id = '2538' AND t0.discr IN ('message') 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 = ?
  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
  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
  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);