Symfony Profiler

SELECT
  DataPointTypes.`identifier` AS `dataPointTypeIdentifier`,
  COALESCE(
    Organizations.`id`, rootOrganization.`id`,
    systemRootOrganization.`id`
  ) `organizationId`,
  PlanTypes.`identifier` `planTypeIdentifier`,
  Providers.`identifier` `providerIdentifier`,
  ProviderSettings.`description`,
  ProviderSettings.`identifier`,
  ProviderSettings.`label`,
  ProviderSettings.`aiFeatureId`,
  IF(
    ProviderSettingViewTypes.`id` IS NULL,
    0, 1
  ) `hasClientServiceViewType`,
  IF(
    OrganizationProviderSettings.`id` IS NULL,
    0, 1
  ) `hasOrganizationOverride`,
  COALESCE(
    OrganizationProviderSettings.`value`,
    PlanTypeProviderSettings.`value`,
    rootOrganizationProviderSettings.`value`,
    systemRootOrganizationProviderSettings.`value`
  ) `value`,
  COALESCE(
    PlanTypeProviderSettings.`value`,
    rootOrganizationProviderSettings.`value`,
    systemRootOrganizationProviderSettings.`value`
  ) `defaultValue`,

  /*
                   * Which level the inherited default came from, mirroring the COALESCE
                   * above. The value alone cannot say: a UI telling a customer where a
                   * setting comes from has to distinguish "your plan includes this" from
                   * "this is the default for every organization", and those carry very
                   * different weight when someone is deciding whether to override it.
                   */
  CASE WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN
    'plan'
  WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN
    'domain'
  WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN
    'system'
  ELSE
    NULL
  END `defaultSource`
FROM
  `Organizations`
  LEFT JOIN `PlanTypes` ON PlanTypes.`id` = Organizations.`planTypeId`
  AND PlanTypes.`deletedAt` IS NULL
  JOIN `RootDomains` ON RootDomains.`id` = Organizations.`rootDomainId`
  JOIN `Organizations` rootOrganization ON rootOrganization.`id` = RootDomains.`mainOrganizationId`
  JOIN `Organizations` systemRootOrganization ON systemRootOrganization.`identifier` = ?
  JOIN `Providers` ON Providers.`id` = ?
  JOIN `ProviderSettings` ON ProviderSettings.`providerId` = Providers.`id`
  AND ProviderSettings.`deletedAt` IS NULL
  JOIN `DataPointTypes` ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId`
  JOIN `ViewTypes` ON ViewTypes.`identifier` = ?
  LEFT JOIN `ProviderSettingViewTypes` ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id`
  AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id`
  AND ProviderSettingViewTypes.`deletedAt` IS NULL
  LEFT JOIN `OrganizationProviderSettings` ON OrganizationProviderSettings.`organizationId` = Organizations.`id`
  AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
  AND OrganizationProviderSettings.`deletedAt` IS NULL
  LEFT JOIN `PlanTypeProviderSettings` ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id`
  AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id`
  AND PlanTypeProviderSettings.`deletedAt` IS NULL
  LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id`
  AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
  AND rootOrganizationProviderSettings.`deletedAt` IS NULL
  LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id`
  AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
  AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL
WHERE
  Organizations.`id` = ?
  AND Providers.`id` = ?
  AND NOT (
    OrganizationProviderSettings.`id` IS NULL
    AND PlanTypeProviderSettings.`id` IS NULL
    AND rootOrganizationProviderSettings.`id` IS NULL
    AND systemRootOrganizationProviderSettings.`id` IS NULL
  )
  AND ProviderSettings.`identifier` IN (?)
GROUP BY
  ProviderSettings.`id`

SELECT
                DataPointTypes.`identifier` AS `dataPointTypeIdentifier`,
                COALESCE(Organizations.`id`, rootOrganization.`id`, systemRootOrganization.`id`) `organizationId`,
                PlanTypes.`identifier` `planTypeIdentifier`,
                Providers.`identifier` `providerIdentifier`,
                ProviderSettings.`description`,
                ProviderSettings.`identifier`,
                ProviderSettings.`label`,
                ProviderSettings.`aiFeatureId`,
                IF(ProviderSettingViewTypes.`id` IS NULL, 0, 1) `hasClientServiceViewType`,
                IF(OrganizationProviderSettings.`id` IS NULL, 0, 1) `hasOrganizationOverride`,
                COALESCE(OrganizationProviderSettings.`value`, PlanTypeProviderSettings.`value`, rootOrganizationProviderSettings.`value`, systemRootOrganizationProviderSettings.`value`) `value`,
                COALESCE(
                    PlanTypeProviderSettings.`value`,
                    rootOrganizationProviderSettings.`value`,
                    systemRootOrganizationProviderSettings.`value`
                ) `defaultValue`,
                /*
                 * Which level the inherited default came from, mirroring the COALESCE
                 * above. The value alone cannot say: a UI telling a customer where a
                 * setting comes from has to distinguish "your plan includes this" from
                 * "this is the default for every organization", and those carry very
                 * different weight when someone is deciding whether to override it.
                 */
                CASE
                    WHEN PlanTypeProviderSettings.`value` IS NOT NULL THEN 'plan'
                    WHEN rootOrganizationProviderSettings.`value` IS NOT NULL THEN 'domain'
                    WHEN systemRootOrganizationProviderSettings.`value` IS NOT NULL THEN 'system'
                    ELSE NULL
                END `defaultSource`
            FROM `Organizations`
            LEFT JOIN `PlanTypes`
                ON PlanTypes.`id` = Organizations.`planTypeId`
                AND PlanTypes.`deletedAt` IS NULL
            JOIN `RootDomains`
                ON RootDomains.`id` = Organizations.`rootDomainId`
            JOIN `Organizations` rootOrganization
                ON rootOrganization.`id` = RootDomains.`mainOrganizationId`
            JOIN `Organizations` systemRootOrganization
                ON systemRootOrganization.`identifier` = 'EXACTHIRE'
            JOIN `Providers`
                ON Providers.`id` = 5
            JOIN `ProviderSettings`
                ON ProviderSettings.`providerId` = Providers.`id`
                AND ProviderSettings.`deletedAt` IS NULL
            JOIN `DataPointTypes`
                ON DataPointTypes.`id` = ProviderSettings.`dataPointTypeId`
            JOIN `ViewTypes`
                ON ViewTypes.`identifier` = 'CLIENT_SERVICES'
            LEFT JOIN `ProviderSettingViewTypes`
                ON ProviderSettingViewTypes.`providerSettingId` = ProviderSettings.`id`
                AND ProviderSettingViewTypes.`viewTypeId` = ViewTypes.`id`
                AND ProviderSettingViewTypes.`deletedAt` IS NULL
            LEFT JOIN `OrganizationProviderSettings`
                ON OrganizationProviderSettings.`organizationId` = Organizations.`id`
                AND OrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND OrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `PlanTypeProviderSettings`
                ON PlanTypeProviderSettings.`planTypeId` = PlanTypes.`id`
                AND PlanTypeProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND PlanTypeProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` rootOrganizationProviderSettings
                ON rootOrganizationProviderSettings.`organizationId` = rootOrganization.`id`
                AND rootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND rootOrganizationProviderSettings.`deletedAt` IS NULL LEFT JOIN `OrganizationProviderSettings` systemRootOrganizationProviderSettings
                ON systemRootOrganizationProviderSettings.`organizationId` = systemRootOrganization.`id`
                AND systemRootOrganizationProviderSettings.`providerSettingId` = ProviderSettings.`id`
                AND systemRootOrganizationProviderSettings.`deletedAt` IS NULL
            WHERE Organizations.`id` = 3
                AND Providers.`id` = 5
                AND NOT (OrganizationProviderSettings.`id` IS NULL AND PlanTypeProviderSettings.`id` IS NULL AND rootOrganizationProviderSettings.`id` IS NULL AND systemRootOrganizationProviderSettings.`id` IS NULL)
         AND ProviderSettings.`identifier` IN ('OPERATING_MODE') GROUP BY ProviderSettings.`id`;

SELECT
  t0.id AS id_1,
  t0.clientRegistrationPolicy AS clientRegistrationPolicy_2,
  t0.identifier AS identifier_3,
  t0.label AS label_4,
  t0.description AS description_5,
  t0.logoUrl AS logoUrl_6,
  t0.endpoint AS endpoint_7,
  t0.credentials AS credentials_8,
  t0.createdAt AS createdAt_9,
  t0.updatedAt AS updatedAt_10,
  t0.deletedAt AS deletedAt_11,
  t12.id AS id_13,
  t12.status AS status_14,
  t12.tagline AS tagline_15,
  t12.overview AS overview_16,
  t12.logoUrl AS logoUrl_17,
  t12.heroMediaUrl AS heroMediaUrl_18,
  t12.videoUrl AS videoUrl_19,
  t12.links AS links_20,
  t12.requirementsText AS requirementsText_21,
  t12.connectsToLabel AS connectsToLabel_22,
  t12.subscriptionNote AS subscriptionNote_23,
  t12.accessType AS accessType_24,
  t12.languages AS languages_25,
  t12.featured AS featured_26,
  t12.displayOrder AS displayOrder_27,
  t12.deprecated AS deprecated_28,
  t12.createdAt AS createdAt_29,
  t12.updatedAt AS updatedAt_30,
  t12.deletedAt AS deletedAt_31,
  t12.providerId AS providerId_32,
  t12.publisherId AS publisherId_33
FROM
  Providers t0
  LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id
  AND (
    (t12.deletedAt IS NULL)
  )
WHERE
  t0.identifier = ?
  AND (
    (t0.deletedAt IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.clientRegistrationPolicy AS clientRegistrationPolicy_2, t0.identifier AS identifier_3, t0.label AS label_4, t0.description AS description_5, t0.logoUrl AS logoUrl_6, t0.endpoint AS endpoint_7, t0.credentials AS credentials_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.deletedAt AS deletedAt_11, t12.id AS id_13, t12.status AS status_14, t12.tagline AS tagline_15, t12.overview AS overview_16, t12.logoUrl AS logoUrl_17, t12.heroMediaUrl AS heroMediaUrl_18, t12.videoUrl AS videoUrl_19, t12.links AS links_20, t12.requirementsText AS requirementsText_21, t12.connectsToLabel AS connectsToLabel_22, t12.subscriptionNote AS subscriptionNote_23, t12.accessType AS accessType_24, t12.languages AS languages_25, t12.featured AS featured_26, t12.displayOrder AS displayOrder_27, t12.deprecated AS deprecated_28, t12.createdAt AS createdAt_29, t12.updatedAt AS updatedAt_30, t12.deletedAt AS deletedAt_31, t12.providerId AS providerId_32, t12.publisherId AS publisherId_33 FROM Providers t0 LEFT JOIN ProviderListings t12 ON t12.providerId = t0.id AND ((t12.deletedAt IS NULL)) WHERE t0.identifier = 'ORGANIZATION_SETTINGS' AND ((t0.deletedAt IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locked AS locked_2,
  t0.createdAt AS createdAt_3,
  t0.updatedAt AS updatedAt_4,
  t0.deletedAt AS deletedAt_5,
  t0.permissionId AS permissionId_6,
  t7.id AS id_8,
  t7.label AS label_9,
  t7.description AS description_10,
  t7.identifier AS identifier_11,
  t7.visibility AS visibility_12,
  t7.displayOrder AS displayOrder_13,
  t7.createdAt AS createdAt_14,
  t7.updatedAt AS updatedAt_15,
  t7.deletedAt AS deletedAt_16,
  t7.subSystemId AS subSystemId_17,
  t7.permissionTypeId AS permissionTypeId_18,
  t0.roleId AS roleId_19
FROM
  RolePermissions t0
  LEFT JOIN Permissions t7 ON t0.permissionId = t7.id
  AND (
    (t7.deletedAt IS NULL)
  )
WHERE
  t0.roleId = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.locked AS locked_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.deletedAt AS deletedAt_5, t0.permissionId AS permissionId_6, t7.id AS id_8, t7.label AS label_9, t7.description AS description_10, t7.identifier AS identifier_11, t7.visibility AS visibility_12, t7.displayOrder AS displayOrder_13, t7.createdAt AS createdAt_14, t7.updatedAt AS updatedAt_15, t7.deletedAt AS deletedAt_16, t7.subSystemId AS subSystemId_17, t7.permissionTypeId AS permissionTypeId_18, t0.roleId AS roleId_19 FROM RolePermissions t0 LEFT JOIN Permissions t7 ON t0.permissionId = t7.id AND ((t7.deletedAt IS NULL)) WHERE t0.roleId = 2 AND ((t0.deletedAt IS NULL));

INSERT INTO HttpLogs (
  type, userAgent, device, os, osVersion,
  routeName, url, method, status, appVersion,
  data, formData, IpAddress, createdAt,
  updatedAt, deletedAt, userId, organizationId,
  requestId
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO HttpLogs (type, userAgent, device, os, osVersion, routeName, url, method, status, appVersion, data, formData, IpAddress, createdAt, updatedAt, deletedAt, userId, organizationId, requestId) VALUES ('REQUEST', NULL, '', 'UNK', 'UNK', 'post_application_thank_you_email', 'http://localhost/api/applications/send_thank_you_email', 'POST', NULL, '1.0.0', 'POST /api/applications/send_thank_you_email HTTP/1.1
Accept:         */*
Authorization:  Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8
Content-Length: 87
Content-Type:   application/json
Host:           localhost
User-Agent:     curl/8.5.0
X-Php-Ob-Level: 0

{\"applications\":[{\"id\":25171}],\"positions\":[44],\"user\":20177,\"sendThankYouEmail\":false}', '{\"applications\":[{\"id\":25171}],\"positions\":[44],\"user\":20177,\"sendThankYouEmail\":false}', '172.22.0.1', '2026-09-28 19:14:05', '2026-09-28 19:14:05', NULL, 657, 3, NULL);

SELECT
  t0.id AS id_1,
  t0.isDefault AS isDefault_2,
  t0.isExpired AS isExpired_3,
  t0.archivedAt AS archivedAt_4,
  t0.createdAt AS createdAt_5,
  t0.updatedAt AS updatedAt_6,
  t0.deletedAt AS deletedAt_7,
  t0.userId AS userId_8,
  t0.organizationId AS organizationId_9
FROM
  OrganizationUsers t0
WHERE
  t0.userId = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.isDefault AS isDefault_2, t0.isExpired AS isExpired_3, t0.archivedAt AS archivedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8, t0.organizationId AS organizationId_9 FROM OrganizationUsers t0 WHERE t0.userId = 657 AND ((t0.deletedAt IS NULL));

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.jti AS jti_3,
  t0.usedAt AS usedAt_4,
  t0.createdAt AS createdAt_5,
  t0.updatedAt AS updatedAt_6,
  t0.deletedAt AS deletedAt_7,
  t0.userId AS userId_8
FROM
  SSOTokens t0
WHERE
  t0.token = ?
  AND (
    (t0.deletedAt IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.jti AS jti_3, t0.usedAt AS usedAt_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.deletedAt AS deletedAt_7, t0.userId AS userId_8 FROM SSOTokens t0 WHERE t0.token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTA2MjAwNTIsImV4cCI6MTc5MDcwNjQ1Miwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sImlkIjo2NTcsIm9yZ2FuaXphdGlvbklkIjozLCJ0aW1lWm9uZSI6bnVsbH0.GRZkero3yfy1xUgWfi2u6ggNCYDYccBqI3V7SbmsgjoaIAlHbpRHAcYxZnD2dbKYPAarFaFeqwUMXcek_124AiHIuTuYCSZ7ohlzphsxTkFIdwS8UEv_SKnI9r84EPanmFGhkhPHCpWeGvby3bCzp_KtwRF7WjHFKP8OyJST6S7eUfAg54BcYWNUAgs3CkcrHVaPzwIeHxCYgM8EHl4__m6tFf05ZRufYeVDA-GYd6igDbWwit9yt6VhoOxWT-GuS-3h6ZPwaCF86MF16Bn6lwHROswL3F6JtvUO08Csa-vm8s7yLhhPxERdtHh1yCAATbuk5mcPGrIUIoL2lf7yNT37ZoZm_bJMeHxA43IySTW7k3teJ52q6j3MuDhc7tmtIZ3EHHY81wgwX8W5B065Hd_oGIKy6HJFozqZ5AqLQs1WAwpN6mF22G9p0gkkCuOpFdwvZyENdFKX7mV5rUmnf6IEnv_umL-1Bl0-Lk8eAg2F_wRgb-axd5dBtiPwuPOGEueDsYRD5a-bqRTtjPhakUH6_r-up04xtM1qQw0202AZRv3fYu3tqIOrIl7N0OQP-WVCm7JqvSu2RPt3-aX2QPps7B-PcOYdfmU8442EUeLFIREgJE1fU4aRKIO_um_nmsS4BiNTuxO33x3liETrdRS4iAogWLjQ6nt7tYKr-z8' AND ((t0.deletedAt IS NULL)) LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.password AS password_2,
  u0_.confirmation_token AS confirmation_token_3,
  u0_.password_requested_at AS password_requested_at_4,
  u0_.authIP AS authIP_5,
  u0_.enabled AS enabled_6,
  u0_.isLocked AS isLocked_7,
  u0_.isAuthy AS isAuthy_8,
  u0_.lastLogin AS lastLogin_9,
  u0_.createdAt AS createdAt_10,
  u0_.updatedAt AS updatedAt_11,
  u0_.deletedAt AS deletedAt_12,
  u0_.jobNotificationName AS jobNotificationName_13,
  u0_.jobNotificationFrequency AS jobNotificationFrequency_14,
  u0_.jobNotificationLastSentAt AS jobNotificationLastSentAt_15,
  u0_.jobNotificationSetAt AS jobNotificationSetAt_16,
  u0_.unsubscribeToken AS unsubscribeToken_17,
  u0_.jobNotificationChannel AS jobNotificationChannel_18,
  u0_.organizationId AS organizationId_19
FROM
  Users u0_
  INNER JOIN OrganizationUsers o1_ ON u0_.id = o1_.userId
  AND (o1_.deletedAt IS NULL)
WHERE
  (u0_.id = ?)
  AND (u0_.deletedAt IS NULL)
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.confirmation_token AS confirmation_token_3, u0_.password_requested_at AS password_requested_at_4, u0_.authIP AS authIP_5, u0_.enabled AS enabled_6, u0_.isLocked AS isLocked_7, u0_.isAuthy AS isAuthy_8, u0_.lastLogin AS lastLogin_9, u0_.createdAt AS createdAt_10, u0_.updatedAt AS updatedAt_11, u0_.deletedAt AS deletedAt_12, u0_.jobNotificationName AS jobNotificationName_13, u0_.jobNotificationFrequency AS jobNotificationFrequency_14, u0_.jobNotificationLastSentAt AS jobNotificationLastSentAt_15, u0_.jobNotificationSetAt AS jobNotificationSetAt_16, u0_.unsubscribeToken AS unsubscribeToken_17, u0_.jobNotificationChannel AS jobNotificationChannel_18, u0_.organizationId AS organizationId_19 FROM Users u0_ INNER JOIN OrganizationUsers o1_ ON u0_.id = o1_.userId AND (o1_.deletedAt IS NULL) WHERE (u0_.id = '657') AND (u0_.deletedAt IS NULL) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.confirmation_token AS confirmation_token_4,
  t0.password_requested_at AS password_requested_at_5,
  t0.authIP AS authIP_6,
  t0.enabled AS enabled_7,
  t0.isLocked AS isLocked_8,
  t0.isAuthy AS isAuthy_9,
  t0.lastLogin AS lastLogin_10,
  t0.createdAt AS createdAt_11,
  t0.updatedAt AS updatedAt_12,
  t0.deletedAt AS deletedAt_13,
  t0.jobNotificationName AS jobNotificationName_14,
  t0.jobNotificationFrequency AS jobNotificationFrequency_15,
  t0.jobNotificationLastSentAt AS jobNotificationLastSentAt_16,
  t0.jobNotificationSetAt AS jobNotificationSetAt_17,
  t0.unsubscribeToken AS unsubscribeToken_18,
  t0.jobNotificationChannel AS jobNotificationChannel_19,
  t0.organizationId AS organizationId_20
FROM
  Users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.confirmation_token AS confirmation_token_4, t0.password_requested_at AS password_requested_at_5, t0.authIP AS authIP_6, t0.enabled AS enabled_7, t0.isLocked AS isLocked_8, t0.isAuthy AS isAuthy_9, t0.lastLogin AS lastLogin_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.deletedAt AS deletedAt_13, t0.jobNotificationName AS jobNotificationName_14, t0.jobNotificationFrequency AS jobNotificationFrequency_15, t0.jobNotificationLastSentAt AS jobNotificationLastSentAt_16, t0.jobNotificationSetAt AS jobNotificationSetAt_17, t0.unsubscribeToken AS unsubscribeToken_18, t0.jobNotificationChannel AS jobNotificationChannel_19, t0.organizationId AS organizationId_20 FROM Users t0 WHERE t0.id = 657;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.userAgent AS userAgent_3,
  t0.device AS device_4,
  t0.os AS os_5,
  t0.osVersion AS osVersion_6,
  t0.routeName AS routeName_7,
  t0.url AS url_8,
  t0.method AS method_9,
  t0.status AS status_10,
  t0.appVersion AS appVersion_11,
  t0.data AS data_12,
  t0.formData AS formData_13,
  t0.IpAddress AS IpAddress_14,
  t0.createdAt AS createdAt_15,
  t0.updatedAt AS updatedAt_16,
  t0.deletedAt AS deletedAt_17,
  t0.userId AS userId_18,
  t0.organizationId AS organizationId_19,
  t0.requestId AS requestId_20
FROM
  HttpLogs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.userAgent AS userAgent_3, t0.device AS device_4, t0.os AS os_5, t0.osVersion AS osVersion_6, t0.routeName AS routeName_7, t0.url AS url_8, t0.method AS method_9, t0.status AS status_10, t0.appVersion AS appVersion_11, t0.data AS data_12, t0.formData AS formData_13, t0.IpAddress AS IpAddress_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deletedAt AS deletedAt_17, t0.userId AS userId_18, t0.organizationId AS organizationId_19, t0.requestId AS requestId_20 FROM HttpLogs t0 WHERE t0.id = 208346;

SELECT
  t0.id AS id_1,
  t0.createdAt AS createdAt_2,
  t0.updatedAt AS updatedAt_3,
  t0.deletedAt AS deletedAt_4,
  t0.roleId AS roleId_5,
  t0.organizationUserId AS organizationUserId_6
FROM
  OrganizationUserRoles t0
WHERE
  t0.organizationUserId = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.deletedAt AS deletedAt_4, t0.roleId AS roleId_5, t0.organizationUserId AS organizationUserId_6 FROM OrganizationUserRoles t0 WHERE t0.organizationUserId = 721 AND ((t0.deletedAt IS NULL));

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.identifier AS identifier_3,
  t0.sequence AS sequence_4,
  t0.locked AS locked_5,
  t0.visibility AS visibility_6,
  t0.createdAt AS createdAt_7,
  t0.updatedAt AS updatedAt_8,
  t0.deletedAt AS deletedAt_9,
  t0.organizationId AS organizationId_10,
  t0.masterRoleId AS masterRoleId_11
FROM
  Roles t0
WHERE
  t0.id = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.label AS label_2, t0.identifier AS identifier_3, t0.sequence AS sequence_4, t0.locked AS locked_5, t0.visibility AS visibility_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.deletedAt AS deletedAt_9, t0.organizationId AS organizationId_10, t0.masterRoleId AS masterRoleId_11 FROM Roles t0 WHERE t0.id = 2 AND ((t0.deletedAt IS NULL));