Symfony Profiler

SELECT
  t0.idTenant AS idTenant_1,
  t0.name AS name_2,
  t0.legalForm AS legalForm_3,
  t0.activityCode AS activityCode_4,
  t0.status AS status_5,
  t0.siren AS siren_6,
  t0.siret AS siret_7,
  t0.vatNumber AS vatNumber_8,
  t0.firstname AS firstname_9,
  t0.lastname AS lastname_10,
  t0.phone AS phone_11,
  t0.email AS email_12,
  t0.web AS web_13,
  t0.refSepa AS refSepa_14,
  t0.logo AS logo_15,
  t0.docslogo AS docslogo_16,
  t0.idPayeeBC AS idPayeeBC_17,
  t0.idPayerBC AS idPayerBC_18,
  t0.registration AS registration_19,
  t0.footer AS footer_20,
  t0.header AS header_21,
  t0.contractFooter AS contractFooter_22,
  t0.allMustSign AS allMustSign_23,
  t0.transferFeeVendor AS transferFeeVendor_24,
  t0.transferFeeBuyer AS transferFeeBuyer_25,
  t0.transferFee AS transferFee_26,
  t0.recoveryFee AS recoveryFee_27,
  t0.recoveryFeeCodes AS recoveryFeeCodes_28,
  t0.documentProvider AS documentProvider_29,
  t0.recoveryDelay AS recoveryDelay_30,
  t0.maxElementInvoices AS maxElementInvoices_31,
  t0.defaultFundersDelay AS defaultFundersDelay_32,
  t0.target AS target_33,
  t0.useQuote AS useQuote_34,
  t0.useAI AS useAI_35,
  t0.useAssetUrl AS useAssetUrl_36,
  t0.withoutPartnerVr AS withoutPartnerVr_37,
  t0.useMicrosoftAuth AS useMicrosoftAuth_38,
  t0.useGoogleAuth AS useGoogleAuth_39,
  t0.useAccounting AS useAccounting_40,
  t0.usePartnerDeals AS usePartnerDeals_41,
  t0.useContractLots AS useContractLots_42,
  t0.useProlong AS useProlong_43,
  t0.useElliPro AS useElliPro_44,
  t0.useCreditsafe AS useCreditsafe_45,
  t0.useEbicsExport AS useEbicsExport_46,
  t0.useEbicsImport AS useEbicsImport_47,
  t0.liOnScheduler AS liOnScheduler_48,
  t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_49,
  t0.ibanOnClientSign AS ibanOnClientSign_50,
  t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_51,
  t0.canManagePartnerFee AS canManagePartnerFee_52,
  t0.autoReject AS autoReject_53,
  t0.extraSignCheck AS extraSignCheck_54,
  t0.blockedSirens AS blockedSirens_55,
  t0.slug AS slug_56,
  t0.primaryColor AS primaryColor_57,
  t0.secondaryColor AS secondaryColor_58,
  t0.fixedAssetCode AS fixedAssetCode_59,
  t0.lossCalculationBase AS lossCalculationBase_60,
  t0.clientBalanceCalcMode AS clientBalanceCalcMode_61,
  t0.clientBalanceSurcharge AS clientBalanceSurcharge_62,
  t0.creditCardLink AS creditCardLink_63,
  t0.postingGroups AS postingGroups_64
FROM
  tenant t0
WHERE
  t0.idTenant = ?

SELECT t0.idTenant AS idTenant_1, t0.name AS name_2, t0.legalForm AS legalForm_3, t0.activityCode AS activityCode_4, t0.status AS status_5, t0.siren AS siren_6, t0.siret AS siret_7, t0.vatNumber AS vatNumber_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.phone AS phone_11, t0.email AS email_12, t0.web AS web_13, t0.refSepa AS refSepa_14, t0.logo AS logo_15, t0.docslogo AS docslogo_16, t0.idPayeeBC AS idPayeeBC_17, t0.idPayerBC AS idPayerBC_18, t0.registration AS registration_19, t0.footer AS footer_20, t0.header AS header_21, t0.contractFooter AS contractFooter_22, t0.allMustSign AS allMustSign_23, t0.transferFeeVendor AS transferFeeVendor_24, t0.transferFeeBuyer AS transferFeeBuyer_25, t0.transferFee AS transferFee_26, t0.recoveryFee AS recoveryFee_27, t0.recoveryFeeCodes AS recoveryFeeCodes_28, t0.documentProvider AS documentProvider_29, t0.recoveryDelay AS recoveryDelay_30, t0.maxElementInvoices AS maxElementInvoices_31, t0.defaultFundersDelay AS defaultFundersDelay_32, t0.target AS target_33, t0.useQuote AS useQuote_34, t0.useAI AS useAI_35, t0.useAssetUrl AS useAssetUrl_36, t0.withoutPartnerVr AS withoutPartnerVr_37, t0.useMicrosoftAuth AS useMicrosoftAuth_38, t0.useGoogleAuth AS useGoogleAuth_39, t0.useAccounting AS useAccounting_40, t0.usePartnerDeals AS usePartnerDeals_41, t0.useContractLots AS useContractLots_42, t0.useProlong AS useProlong_43, t0.useElliPro AS useElliPro_44, t0.useCreditsafe AS useCreditsafe_45, t0.useEbicsExport AS useEbicsExport_46, t0.useEbicsImport AS useEbicsImport_47, t0.liOnScheduler AS liOnScheduler_48, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_49, t0.ibanOnClientSign AS ibanOnClientSign_50, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_51, t0.canManagePartnerFee AS canManagePartnerFee_52, t0.autoReject AS autoReject_53, t0.extraSignCheck AS extraSignCheck_54, t0.blockedSirens AS blockedSirens_55, t0.slug AS slug_56, t0.primaryColor AS primaryColor_57, t0.secondaryColor AS secondaryColor_58, t0.fixedAssetCode AS fixedAssetCode_59, t0.lossCalculationBase AS lossCalculationBase_60, t0.clientBalanceCalcMode AS clientBalanceCalcMode_61, t0.clientBalanceSurcharge AS clientBalanceSurcharge_62, t0.creditCardLink AS creditCardLink_63, t0.postingGroups AS postingGroups_64 FROM tenant t0 WHERE t0.idTenant = 1;

SELECT
  t0.idTenantParam AS idTenantParam_1,
  t0.code AS code_2,
  t0.json AS json_3,
  t0.label AS label_4,
  t0.idTenant AS idTenant_5
FROM
  tenantParam t0
WHERE
  t0.idTenant = ?

SELECT t0.idTenantParam AS idTenantParam_1, t0.code AS code_2, t0.json AS json_3, t0.label AS label_4, t0.idTenant AS idTenant_5 FROM tenantParam t0 WHERE t0.idTenant = 1;

SELECT
  t0.idPartner AS idPartner_1,
  t0.name AS name_2,
  t0.migV1locked AS migV1locked_3,
  t0.agreementV1Locked AS agreementV1Locked_4,
  t0.attachmentInsurance AS attachmentInsurance_5,
  t0.autoFundingParams AS autoFundingParams_6,
  t0.canSignOnDevice AS canSignOnDevice_7,
  t0.canSignWithSales AS canSignWithSales_8,
  t0.useDefaultAsset AS useDefaultAsset_9,
  t0.useDeLay AS useDeLay_10,
  t0.prefillContract AS prefillContract_11,
  t0.updateDate AS updateDate_12,
  t0.insertDate AS insertDate_13,
  t0.startDate AS startDate_14,
  t0.endDate AS endDate_15,
  t0.legalForm AS legalForm_16,
  t0.activityCode AS activityCode_17,
  t0.activitySector AS activitySector_18,
  t0.country AS country_19,
  t0.status AS status_20,
  t0.type AS type_21,
  t0.typeOfService AS typeOfService_22,
  t0.phone AS phone_23,
  t0.autoAccept AS autoAccept_24,
  t0.autoReject AS autoReject_25,
  t0.email AS email_26,
  t0.web AS web_27,
  t0.logo AS logo_28,
  t0.idPayeeBC AS idPayeeBC_29,
  t0.idPayerBC AS idPayerBC_30,
  t0.siren AS siren_31,
  t0.vatNumber AS vatNumber_32,
  t0.registration AS registration_33,
  t0.agreementRegistration AS agreementRegistration_34,
  t0.defaultFinancialProduct AS defaultFinancialProduct_35,
  t0.defaultFinancialScheme AS defaultFinancialScheme_36,
  t0.renewalBalanceCalcMode AS renewalBalanceCalcMode_37,
  t0.renewalBalanceFee AS renewalBalanceFee_38,
  t0.nonRenewalBalanceFee AS nonRenewalBalanceFee_39,
  t0.nonRenewalBalanceCalcMode AS nonRenewalBalanceCalcMode_40,
  t0.nonRenewalSurcharge AS nonRenewalSurcharge_41,
  t0.renewalSurcharge AS renewalSurcharge_42,
  t0.renewalMandatedSurcharge AS renewalMandatedSurcharge_43,
  t0.nonRenewalIndemnity AS nonRenewalIndemnity_44,
  t0.defaultPartnerContact AS defaultPartnerContact_45,
  t0.target AS target_46,
  t0.potential AS potential_47,
  t0.segment AS segment_48,
  t0.risk AS risk_49,
  t0.createContractAtStatus AS createContractAtStatus_50,
  t0.docusignAuto AS docusignAuto_51,
  t0.emptyRentalChain AS emptyRentalChain_52,
  t0.docusignAutoAtStatus AS docusignAutoAtStatus_53,
  t0.hasClientSpace AS hasClientSpace_54,
  t0.useDeals AS useDeals_55,
  t0.useHamonLaw AS useHamonLaw_56,
  t0.notUseAutoMailHamon AS notUseAutoMailHamon_57,
  t0.hasPartnerSpace AS hasPartnerSpace_58,
  t0.canCancelEnvelope AS canCancelEnvelope_59,
  t0.canSignWithoutApproval AS canSignWithoutApproval_60,
  t0.needClientDocsOnSign AS needClientDocsOnSign_61,
  t0.canUseCapacity AS canUseCapacity_62,
  t0.canCancelInsurance AS canCancelInsurance_63,
  t0.canCancelProlong AS canCancelProlong_64,
  t0.canUsePaymentOffset AS canUsePaymentOffset_65,
  t0.canRenewContract AS canRenewContract_66,
  t0.stopPrintContract AS stopPrintContract_67,
  t0.activeLockedForSales AS activeLockedForSales_68,
  t0.displayPartnerSpaceInsInfo AS displayPartnerSpaceInsInfo_69,
  t0.sendDocsToClientAfterSigned AS sendDocsToClientAfterSigned_70,
  t0.paymentCondition AS paymentCondition_71,
  t0.paymentMode AS paymentMode_72,
  t0.comment AS comment_73,
  t0.active AS active_74,
  t0.canUseAssetOnCalc AS canUseAssetOnCalc_75,
  t0.useSepaDate AS useSepaDate_76,
  t0.rewardsOnPreComp AS rewardsOnPreComp_77,
  t0.useMultiStages AS useMultiStages_78,
  t0.riskSharing AS riskSharing_79,
  t0.paidAfterCAL AS paidAfterCAL_80,
  t0.wantToSeeHomeMap AS wantToSeeHomeMap_81,
  t0.oauth2 AS oauth2_82,
  t0.clientSecret AS clientSecret_83,
  t0.clientId AS clientId_84,
  t0.tenantId AS tenantId_85,
  t0.slug AS slug_86,
  t0.invoiceLogo AS invoiceLogo_87,
  t0.spaceLogo AS spaceLogo_88,
  t0.spaceFavicon AS spaceFavicon_89,
  t0.spacePrimaryColor AS spacePrimaryColor_90,
  t0.spaceSecondaryColor AS spaceSecondaryColor_91,
  t0.contractLogo AS contractLogo_92,
  t0.bdcLogo AS bdcLogo_93,
  t0.bdcAgree AS bdcAgree_94,
  t0.agreeLogo AS agreeLogo_95,
  t0.addressContract AS addressContract_96,
  t0.addressAgree AS addressAgree_97,
  t0.addressInvoice AS addressInvoice_98,
  t0.addressBdc AS addressBdc_99,
  t0.welcomeAddon AS welcomeAddon_100,
  t0.footer AS footer_101,
  t0.header AS header_102,
  t0.vendorPostingGroup AS vendorPostingGroup_103,
  t0.acceptThresholdEL AS acceptThresholdEL_104,
  t0.acceptThresholdCS AS acceptThresholdCS_105,
  t0.acceptAmount AS acceptAmount_106,
  t0.rejectThresholdEL AS rejectThresholdEL_107,
  t0.rejectThresholdCS AS rejectThresholdCS_108,
  t0.useGracePeriod AS useGracePeriod_109,
  t0.gracePeriodMax AS gracePeriodMax_110,
  t0.noInsuranceOnGracePeriod AS noInsuranceOnGracePeriod_111,
  t0.noLiOnGracePeriod AS noLiOnGracePeriod_112,
  t0.canViewRewards AS canViewRewards_113,
  t0.canViewAcceptRate AS canViewAcceptRate_114,
  t0.hasProlongationCommission AS hasProlongationCommission_115,
  t0.prolongationCommission AS prolongationCommission_116,
  t0.prolongationCommissionAllin AS prolongationCommissionAllin_117,
  t0.prolongationCommissionFrequency AS prolongationCommissionFrequency_118,
  t0.prolongationCommissionTarget AS prolongationCommissionTarget_119,
  t0.idLeasLiaison AS idLeasLiaison_120,
  t0.idLeasSale AS idLeasSale_121,
  t0.idPartnerScheme AS idPartnerScheme_122,
  t0.idContractTemplate AS idContractTemplate_123,
  t0.idPvTemplate AS idPvTemplate_124,
  t0.idSepaTemplate AS idSepaTemplate_125,
  t0.idCgvTemplate AS idCgvTemplate_126,
  t0.idAnnexTemplate AS idAnnexTemplate_127,
  t0.idBdcTemplate AS idBdcTemplate_128
FROM
  partner t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.idPartner AS idPartner_1, t0.name AS name_2, t0.migV1locked AS migV1locked_3, t0.agreementV1Locked AS agreementV1Locked_4, t0.attachmentInsurance AS attachmentInsurance_5, t0.autoFundingParams AS autoFundingParams_6, t0.canSignOnDevice AS canSignOnDevice_7, t0.canSignWithSales AS canSignWithSales_8, t0.useDefaultAsset AS useDefaultAsset_9, t0.useDeLay AS useDeLay_10, t0.prefillContract AS prefillContract_11, t0.updateDate AS updateDate_12, t0.insertDate AS insertDate_13, t0.startDate AS startDate_14, t0.endDate AS endDate_15, t0.legalForm AS legalForm_16, t0.activityCode AS activityCode_17, t0.activitySector AS activitySector_18, t0.country AS country_19, t0.status AS status_20, t0.type AS type_21, t0.typeOfService AS typeOfService_22, t0.phone AS phone_23, t0.autoAccept AS autoAccept_24, t0.autoReject AS autoReject_25, t0.email AS email_26, t0.web AS web_27, t0.logo AS logo_28, t0.idPayeeBC AS idPayeeBC_29, t0.idPayerBC AS idPayerBC_30, t0.siren AS siren_31, t0.vatNumber AS vatNumber_32, t0.registration AS registration_33, t0.agreementRegistration AS agreementRegistration_34, t0.defaultFinancialProduct AS defaultFinancialProduct_35, t0.defaultFinancialScheme AS defaultFinancialScheme_36, t0.renewalBalanceCalcMode AS renewalBalanceCalcMode_37, t0.renewalBalanceFee AS renewalBalanceFee_38, t0.nonRenewalBalanceFee AS nonRenewalBalanceFee_39, t0.nonRenewalBalanceCalcMode AS nonRenewalBalanceCalcMode_40, t0.nonRenewalSurcharge AS nonRenewalSurcharge_41, t0.renewalSurcharge AS renewalSurcharge_42, t0.renewalMandatedSurcharge AS renewalMandatedSurcharge_43, t0.nonRenewalIndemnity AS nonRenewalIndemnity_44, t0.defaultPartnerContact AS defaultPartnerContact_45, t0.target AS target_46, t0.potential AS potential_47, t0.segment AS segment_48, t0.risk AS risk_49, t0.createContractAtStatus AS createContractAtStatus_50, t0.docusignAuto AS docusignAuto_51, t0.emptyRentalChain AS emptyRentalChain_52, t0.docusignAutoAtStatus AS docusignAutoAtStatus_53, t0.hasClientSpace AS hasClientSpace_54, t0.useDeals AS useDeals_55, t0.useHamonLaw AS useHamonLaw_56, t0.notUseAutoMailHamon AS notUseAutoMailHamon_57, t0.hasPartnerSpace AS hasPartnerSpace_58, t0.canCancelEnvelope AS canCancelEnvelope_59, t0.canSignWithoutApproval AS canSignWithoutApproval_60, t0.needClientDocsOnSign AS needClientDocsOnSign_61, t0.canUseCapacity AS canUseCapacity_62, t0.canCancelInsurance AS canCancelInsurance_63, t0.canCancelProlong AS canCancelProlong_64, t0.canUsePaymentOffset AS canUsePaymentOffset_65, t0.canRenewContract AS canRenewContract_66, t0.stopPrintContract AS stopPrintContract_67, t0.activeLockedForSales AS activeLockedForSales_68, t0.displayPartnerSpaceInsInfo AS displayPartnerSpaceInsInfo_69, t0.sendDocsToClientAfterSigned AS sendDocsToClientAfterSigned_70, t0.paymentCondition AS paymentCondition_71, t0.paymentMode AS paymentMode_72, t0.comment AS comment_73, t0.active AS active_74, t0.canUseAssetOnCalc AS canUseAssetOnCalc_75, t0.useSepaDate AS useSepaDate_76, t0.rewardsOnPreComp AS rewardsOnPreComp_77, t0.useMultiStages AS useMultiStages_78, t0.riskSharing AS riskSharing_79, t0.paidAfterCAL AS paidAfterCAL_80, t0.wantToSeeHomeMap AS wantToSeeHomeMap_81, t0.oauth2 AS oauth2_82, t0.clientSecret AS clientSecret_83, t0.clientId AS clientId_84, t0.tenantId AS tenantId_85, t0.slug AS slug_86, t0.invoiceLogo AS invoiceLogo_87, t0.spaceLogo AS spaceLogo_88, t0.spaceFavicon AS spaceFavicon_89, t0.spacePrimaryColor AS spacePrimaryColor_90, t0.spaceSecondaryColor AS spaceSecondaryColor_91, t0.contractLogo AS contractLogo_92, t0.bdcLogo AS bdcLogo_93, t0.bdcAgree AS bdcAgree_94, t0.agreeLogo AS agreeLogo_95, t0.addressContract AS addressContract_96, t0.addressAgree AS addressAgree_97, t0.addressInvoice AS addressInvoice_98, t0.addressBdc AS addressBdc_99, t0.welcomeAddon AS welcomeAddon_100, t0.footer AS footer_101, t0.header AS header_102, t0.vendorPostingGroup AS vendorPostingGroup_103, t0.acceptThresholdEL AS acceptThresholdEL_104, t0.acceptThresholdCS AS acceptThresholdCS_105, t0.acceptAmount AS acceptAmount_106, t0.rejectThresholdEL AS rejectThresholdEL_107, t0.rejectThresholdCS AS rejectThresholdCS_108, t0.useGracePeriod AS useGracePeriod_109, t0.gracePeriodMax AS gracePeriodMax_110, t0.noInsuranceOnGracePeriod AS noInsuranceOnGracePeriod_111, t0.noLiOnGracePeriod AS noLiOnGracePeriod_112, t0.canViewRewards AS canViewRewards_113, t0.canViewAcceptRate AS canViewAcceptRate_114, t0.hasProlongationCommission AS hasProlongationCommission_115, t0.prolongationCommission AS prolongationCommission_116, t0.prolongationCommissionAllin AS prolongationCommissionAllin_117, t0.prolongationCommissionFrequency AS prolongationCommissionFrequency_118, t0.prolongationCommissionTarget AS prolongationCommissionTarget_119, t0.idLeasLiaison AS idLeasLiaison_120, t0.idLeasSale AS idLeasSale_121, t0.idPartnerScheme AS idPartnerScheme_122, t0.idContractTemplate AS idContractTemplate_123, t0.idPvTemplate AS idPvTemplate_124, t0.idSepaTemplate AS idSepaTemplate_125, t0.idCgvTemplate AS idCgvTemplate_126, t0.idAnnexTemplate AS idAnnexTemplate_127, t0.idBdcTemplate AS idBdcTemplate_128 FROM partner t0 WHERE t0.slug = 'orisha' AND t0.active = 1 LIMIT 1;

SELECT
  t0.idUser AS idUser_1,
  t0.firstName AS firstName_2,
  t0.active AS active_3,
  t0.lastName AS lastName_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.mobile AS mobile_7,
  t0.site AS site_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.services AS services_11,
  t0.preferencesNotification AS preferencesNotification_12,
  t0.preferencesNotificationContract AS preferencesNotificationContract_13,
  t0.permissions AS permissions_14,
  t0.photo AS photo_15,
  t0.idSSO AS idSSO_16,
  t0.position AS position_17,
  t0.signatory AS signatory_18,
  t0.registration AS registration_19,
  t0.lastLogin AS lastLogin_20,
  t0.emailPurge AS emailPurge_21,
  t0.preferences AS preferences_22,
  t0.code AS code_23,
  t0.signature AS signature_24,
  t0.managerOf AS managerOf_25,
  t0.consentAccept AS consentAccept_26,
  t0.consentAcceptDate AS consentAcceptDate_27,
  t0.idTenant AS idTenant_28,
  t0.idClient AS idClient_29,
  t0.type
FROM
  user t0
WHERE
  t0.idUser = ?
  AND t0.type IN (
    'tenant', 'partner', 'client', 'funder'
  )

SELECT t0.idUser AS idUser_1, t0.firstName AS firstName_2, t0.active AS active_3, t0.lastName AS lastName_4, t0.email AS email_5, t0.phone AS phone_6, t0.mobile AS mobile_7, t0.site AS site_8, t0.password AS password_9, t0.roles AS roles_10, t0.services AS services_11, t0.preferencesNotification AS preferencesNotification_12, t0.preferencesNotificationContract AS preferencesNotificationContract_13, t0.permissions AS permissions_14, t0.photo AS photo_15, t0.idSSO AS idSSO_16, t0.position AS position_17, t0.signatory AS signatory_18, t0.registration AS registration_19, t0.lastLogin AS lastLogin_20, t0.emailPurge AS emailPurge_21, t0.preferences AS preferences_22, t0.code AS code_23, t0.signature AS signature_24, t0.managerOf AS managerOf_25, t0.consentAccept AS consentAccept_26, t0.consentAcceptDate AS consentAcceptDate_27, t0.idTenant AS idTenant_28, t0.idClient AS idClient_29, t0.type FROM user t0 WHERE t0.idUser = 15357 AND t0.type IN ('tenant', 'partner', 'client', 'funder');

SELECT
  t0.idUserPartner AS idUserPartner_1,
  t0.services AS services_2,
  t0.idPartner AS idPartner_3,
  t0.idUser AS idUser_4
FROM
  userPartner t0
WHERE
  t0.idUser IN (?)
ORDER BY
  t0.idUserPartner ASC

SELECT t0.idUserPartner AS idUserPartner_1, t0.services AS services_2, t0.idPartner AS idPartner_3, t0.idUser AS idUser_4 FROM userPartner t0 WHERE t0.idUser IN (15357) ORDER BY t0.idUserPartner ASC;

SELECT
  t0.idUser AS idUser_1,
  t0.firstName AS firstName_2,
  t0.active AS active_3,
  t0.lastName AS lastName_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.mobile AS mobile_7,
  t0.site AS site_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.services AS services_11,
  t0.preferencesNotification AS preferencesNotification_12,
  t0.preferencesNotificationContract AS preferencesNotificationContract_13,
  t0.permissions AS permissions_14,
  t0.photo AS photo_15,
  t0.idSSO AS idSSO_16,
  t0.position AS position_17,
  t0.signatory AS signatory_18,
  t0.registration AS registration_19,
  t0.lastLogin AS lastLogin_20,
  t0.emailPurge AS emailPurge_21,
  t0.preferences AS preferences_22,
  t0.code AS code_23,
  t0.signature AS signature_24,
  t0.managerOf AS managerOf_25,
  t0.consentAccept AS consentAccept_26,
  t0.consentAcceptDate AS consentAcceptDate_27,
  t0.idTenant AS idTenant_28,
  t0.idClient AS idClient_29,
  t0.type
FROM
  user t0
WHERE
  t0.idUser = ?
  AND t0.type IN (
    'tenant', 'partner', 'client', 'funder'
  )

SELECT t0.idUser AS idUser_1, t0.firstName AS firstName_2, t0.active AS active_3, t0.lastName AS lastName_4, t0.email AS email_5, t0.phone AS phone_6, t0.mobile AS mobile_7, t0.site AS site_8, t0.password AS password_9, t0.roles AS roles_10, t0.services AS services_11, t0.preferencesNotification AS preferencesNotification_12, t0.preferencesNotificationContract AS preferencesNotificationContract_13, t0.permissions AS permissions_14, t0.photo AS photo_15, t0.idSSO AS idSSO_16, t0.position AS position_17, t0.signatory AS signatory_18, t0.registration AS registration_19, t0.lastLogin AS lastLogin_20, t0.emailPurge AS emailPurge_21, t0.preferences AS preferences_22, t0.code AS code_23, t0.signature AS signature_24, t0.managerOf AS managerOf_25, t0.consentAccept AS consentAccept_26, t0.consentAcceptDate AS consentAcceptDate_27, t0.idTenant AS idTenant_28, t0.idClient AS idClient_29, t0.type FROM user t0 WHERE t0.idUser = 28 AND t0.type IN ('tenant', 'partner', 'client', 'funder');

SELECT
  t0.idUserPartner AS idUserPartner_1,
  t0.services AS services_2,
  t0.idPartner AS idPartner_3,
  t0.idUser AS idUser_4
FROM
  userPartner t0
WHERE
  t0.idUser IN (?)
ORDER BY
  t0.idUserPartner ASC

SELECT t0.idUserPartner AS idUserPartner_1, t0.services AS services_2, t0.idPartner AS idPartner_3, t0.idUser AS idUser_4 FROM userPartner t0 WHERE t0.idUser IN (28) ORDER BY t0.idUserPartner ASC;