Symfony Profiler

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 = 'anytown' LIMIT 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 = 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 = '7304' AND ((t0.tenant = 46));

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

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cms__one_roster__job (
  status, startPhase, phasesReady, phasesRunning,
  phasesComplete, firstActivityAt,
  lastActivityAt, semaphore, error,
  uid, createdAt, updatedAt, touchedAt,
  sync, tenant, createdBy, updatedBy,
  touchedBy
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO cms__one_roster__job (status, startPhase, phasesReady, phasesRunning, phasesComplete, firstActivityAt, lastActivityAt, semaphore, error, uid, createdAt, updatedAt, touchedAt, sync, tenant, createdBy, updatedBy, touchedBy) VALUES (0, 1, 0, 0, 0, NULL, NULL, 0, '[]', '6c916af0-819d-11ef-a15f-0a58a9feac02', '2024-10-03 15:37:40', NULL, '2024-10-03 15:37:40', 38, 46, 7304, NULL, 7304);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  cms__one_roster__sync
SET
  lastRunAt = ?,
  updatedAt = ?,
  touchedAt = ?,
  updatedBy = ?
WHERE
  id = ?

UPDATE cms__one_roster__sync SET lastRunAt = '2024-10-03 15:37:40', updatedAt = '2024-10-03 15:37:40', touchedAt = '2024-10-03 15:37:40', updatedBy = 7304 WHERE id = 38;

"COMMIT"

"COMMIT";

UPDATE
  cms__one_roster__job
SET
  status = 1,
  phasesReady = (phasesReady | ?)
WHERE
  (id = ?)
  AND (cms__one_roster__job.tenant = 46)

UPDATE cms__one_roster__job SET status = 1, phasesReady = (phasesReady | 1) WHERE (id = 661) AND (cms__one_roster__job.tenant = 46);

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE cms__one_roster__job SET semaphore = (semaphore + 1) WHERE (id = 661) AND (cms__one_roster__job.tenant = 46);

"COMMIT"

"COMMIT";