Symfony Profiler

SELECT
  n0_.managed AS managed_0,
  n0_.id AS id_1,
  n0_.uid AS uid_2,
  n0_.createdAt AS createdAt_3,
  n0_.updatedAt AS updatedAt_4,
  n0_.touchedAt AS touchedAt_5,
  n0_.enabled AS enabled_6,
  n0_.primaryPreferences AS primaryPreferences_7,
  n0_.secondaryPreferences AS secondaryPreferences_8,
  n0_.onerosterId AS onerosterId_9,
  n0_.onerosterArchived AS onerosterArchived_10,
  n0_.discarded AS discarded_11,
  n0_.discardedAt AS discardedAt_12,
  n1_.contact AS contact_13,
  n1_.active AS active_14,
  n1_.id AS id_15,
  n1_.uid AS uid_16,
  n1_.createdAt AS createdAt_17,
  n1_.updatedAt AS updatedAt_18,
  n1_.touchedAt AS touchedAt_19,
  n1_.standing AS standing_20,
  n1_.contactability AS contactability_21,
  n1_.reachability AS reachability_22,
  n1_.lookup AS lookup_23,
  n1_.lookupTimestamp AS lookupTimestamp_24,
  n1_.lookupStatus AS lookupStatus_25,
  n1_.type AS type_26,
  n1_.method AS method_27,
  n1_.blocked AS blocked_28,
  n1_.platform AS platform_29,
  n1_.installation AS installation_30,
  n1_.name AS name_31,
  n1_.refreshedAt AS refreshedAt_32,
  n1_.firebase AS firebase_33,
  n0_.profile AS profile_34,
  n0_.recipient AS recipient_35,
  n0_.tenant AS tenant_36,
  n0_.createdBy AS createdBy_37,
  n0_.updatedBy AS updatedBy_38,
  n0_.touchedBy AS touchedBy_39,
  n1_.discr AS discr_40,
  n1_.tenant AS tenant_41,
  n1_.createdBy AS createdBy_42,
  n1_.updatedBy AS updatedBy_43,
  n1_.touchedBy AS touchedBy_44
FROM
  notis__profile_contact n0_
  LEFT JOIN notis__recipient n1_ ON n0_.recipient = n1_.id
  AND n1_.discr IN ('email', 'phone', 'app')
  AND (n1_.tenant = 1)
WHERE
  (
    n1_.active = ?
    AND n0_.profile = ?
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)
ORDER BY
  n1_.discr ASC,
  n1_.contact ASC

SELECT n0_.managed AS managed_0, n0_.id AS id_1, n0_.uid AS uid_2, n0_.createdAt AS createdAt_3, n0_.updatedAt AS updatedAt_4, n0_.touchedAt AS touchedAt_5, n0_.enabled AS enabled_6, n0_.primaryPreferences AS primaryPreferences_7, n0_.secondaryPreferences AS secondaryPreferences_8, n0_.onerosterId AS onerosterId_9, n0_.onerosterArchived AS onerosterArchived_10, n0_.discarded AS discarded_11, n0_.discardedAt AS discardedAt_12, n1_.contact AS contact_13, n1_.active AS active_14, n1_.id AS id_15, n1_.uid AS uid_16, n1_.createdAt AS createdAt_17, n1_.updatedAt AS updatedAt_18, n1_.touchedAt AS touchedAt_19, n1_.standing AS standing_20, n1_.contactability AS contactability_21, n1_.reachability AS reachability_22, n1_.lookup AS lookup_23, n1_.lookupTimestamp AS lookupTimestamp_24, n1_.lookupStatus AS lookupStatus_25, n1_.type AS type_26, n1_.method AS method_27, n1_.blocked AS blocked_28, n1_.platform AS platform_29, n1_.installation AS installation_30, n1_.name AS name_31, n1_.refreshedAt AS refreshedAt_32, n1_.firebase AS firebase_33, n0_.profile AS profile_34, n0_.recipient AS recipient_35, n0_.tenant AS tenant_36, n0_.createdBy AS createdBy_37, n0_.updatedBy AS updatedBy_38, n0_.touchedBy AS touchedBy_39, n1_.discr AS discr_40, n1_.tenant AS tenant_41, n1_.createdBy AS createdBy_42, n1_.updatedBy AS updatedBy_43, n1_.touchedBy AS touchedBy_44 FROM notis__profile_contact n0_ LEFT JOIN notis__recipient n1_ ON n0_.recipient = n1_.id AND n1_.discr IN ('email', 'phone', 'app') AND (n1_.tenant = 1) WHERE (n1_.active = 1 AND n0_.profile = 137960) AND (n0_.discarded = 0) AND (n0_.tenant = 1) ORDER BY n1_.discr ASC, n1_.contact ASC;

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
  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
  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.oneRosterOrg IN (?, ?)
  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.oneRosterOrg IN ('ORG-EASTSIDE', 'ORG-DOWNTOWN') AND ((t0.tenant = 1));

SELECT
  t0.firstName AS firstName_1,
  t0.lastName AS lastName_2,
  t0.language AS language_3,
  t0.languageOverride AS languageOverride_4,
  t0.role AS role_5,
  t0.code AS code_6,
  t0.metadata AS metadata_7,
  t0.id AS id_8,
  t0.uid AS uid_9,
  t0.createdAt AS createdAt_10,
  t0.updatedAt AS updatedAt_11,
  t0.touchedAt AS touchedAt_12,
  t0.standing AS standing_13,
  t0.contactability AS contactability_14,
  t0.reachability AS reachability_15,
  t0.onerosterId AS onerosterId_16,
  t0.onerosterArchived AS onerosterArchived_17,
  t0.discarded AS discarded_18,
  t0.discardedAt AS discardedAt_19,
  t0.flags AS flags_20,
  t0.alias AS alias_21,
  t0.tenant AS tenant_22,
  t0.createdBy AS createdBy_23,
  t0.updatedBy AS updatedBy_24,
  t0.touchedBy AS touchedBy_25
FROM
  notis__profile t0
WHERE
  t0.id = ?
  AND (
    (t0.discarded = 0)
    AND (t0.tenant = 1)
  )

SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.language AS language_3, t0.languageOverride AS languageOverride_4, t0.role AS role_5, t0.code AS code_6, t0.metadata AS metadata_7, t0.id AS id_8, t0.uid AS uid_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.standing AS standing_13, t0.contactability AS contactability_14, t0.reachability AS reachability_15, t0.onerosterId AS onerosterId_16, t0.onerosterArchived AS onerosterArchived_17, t0.discarded AS discarded_18, t0.discardedAt AS discardedAt_19, t0.flags AS flags_20, t0.alias AS alias_21, t0.tenant AS tenant_22, t0.createdBy AS createdBy_23, t0.updatedBy AS updatedBy_24, t0.touchedBy AS touchedBy_25 FROM notis__profile t0 WHERE t0.id = '137960' AND ((t0.discarded = 0) AND (t0.tenant = 1));

SELECT
  t0.firstName AS firstName_1,
  t0.lastName AS lastName_2,
  t0.metadata AS metadata_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.standing AS standing_9,
  t0.contactability AS contactability_10,
  t0.reachability AS reachability_11,
  t0.onerosterId AS onerosterId_12,
  t0.onerosterArchived AS onerosterArchived_13,
  t0.discarded AS discarded_14,
  t0.discardedAt AS discardedAt_15,
  t0.tenant AS tenant_16,
  t0.createdBy AS createdBy_17,
  t0.updatedBy AS updatedBy_18,
  t0.touchedBy AS touchedBy_19
FROM
  notis__student t0
WHERE
  t0.id = ?
  AND (
    (t0.discarded = 0)
    AND (t0.tenant = 1)
  )

SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.metadata AS metadata_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.standing AS standing_9, t0.contactability AS contactability_10, t0.reachability AS reachability_11, t0.onerosterId AS onerosterId_12, t0.onerosterArchived AS onerosterArchived_13, t0.discarded AS discarded_14, t0.discardedAt AS discardedAt_15, t0.tenant AS tenant_16, t0.createdBy AS createdBy_17, t0.updatedBy AS updatedBy_18, t0.touchedBy AS touchedBy_19 FROM notis__student t0 WHERE t0.id = 88048 AND ((t0.discarded = 0) AND (t0.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
  t0.metadata AS metadata_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.onerosterId AS onerosterId_7,
  t0.onerosterArchived AS onerosterArchived_8,
  t0.profile AS profile_9,
  t0.student AS student_10,
  t0.tenant AS tenant_11,
  t0.createdBy AS createdBy_12,
  t0.updatedBy AS updatedBy_13,
  t0.touchedBy AS touchedBy_14
FROM
  notis__profile_relationship t0
WHERE
  t0.profile = ?
  AND (
    (t0.tenant = 1)
  )

SELECT t0.metadata AS metadata_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.onerosterId AS onerosterId_7, t0.onerosterArchived AS onerosterArchived_8, t0.profile AS profile_9, t0.student AS student_10, t0.tenant AS tenant_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.touchedBy AS touchedBy_14 FROM notis__profile_relationship t0 WHERE t0.profile = 137960 AND ((t0.tenant = 1));

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

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;