Query Metrics
18
Database Queries
9
Different statements
143.52 ms
Query time
0
Invalid entities
70
Managed entities
Queries
aplizV2 connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 30.74 ms |
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 = ?
Parameters:
[
1
]
|
| 2 | 6.49 ms |
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 = ?
Parameters:
[
1
]
|
| 3 | 6.20 ms |
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')
Parameters:
[
21908
]
|
| 4 | 6.01 ms |
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
Parameters:
[
21908
]
|
| 5 | 6.38 ms |
SELECT t0.idContract AS idContract_1, t0.name AS name_2, t0.type AS type_3, t0.status AS status_4, t0.statusV1 AS statusV1_5, t0.signatureStatus AS signatureStatus_6, t0.signedClient AS signedClient_7, t0.signedTenant AS signedTenant_8, t0.signedFunder AS signedFunder_9, t0.subStatus AS subStatus_10, t0.externalReference AS externalReference_11, t0.externalLabel AS externalLabel_12, t0.registration AS registration_13, t0.managementType AS managementType_14, t0.clientScore AS clientScore_15, t0.insertDate AS insertDate_16, t0.updateDate AS updateDate_17, t0.submitDate AS submitDate_18, t0.acceptDate AS acceptDate_19, t0.selectFunderDate AS selectFunderDate_20, t0.activationDate AS activationDate_21, t0.startDate AS startDate_22, t0.endDate AS endDate_23, t0.rejectDate AS rejectDate_24, t0.cancelledDate AS cancelledDate_25, t0.closedDate AS closedDate_26, t0.expirationDate AS expirationDate_27, t0.pvDate AS pvDate_28, t0.sepaDate AS sepaDate_29, t0.estimatedDeliveryDate AS estimatedDeliveryDate_30, t0.firstPaymentDate AS firstPaymentDate_31, t0.deliveryDate AS deliveryDate_32, t0.cessionDate AS cessionDate_33, t0.lastRentDate AS lastRentDate_34, t0.signDatePartner AS signDatePartner_35, t0.signDateClient AS signDateClient_36, t0.signDateFunder AS signDateFunder_37, t0.signDateTenant AS signDateTenant_38, t0.sentDateClient AS sentDateClient_39, t0.sentDateFunder AS sentDateFunder_40, t0.sentDateTenant AS sentDateTenant_41, t0.partnerValidationDate AS partnerValidationDate_42, t0.prolongEndDate AS prolongEndDate_43, t0.selectedProlongEndDate AS selectedProlongEndDate_44, t0.installDate AS installDate_45, t0.supplierInvoiceReference AS supplierInvoiceReference_46, t0.supplierInvoiceDate AS supplierInvoiceDate_47, t0.bdc AS bdc_48, t0.vad AS vad_49, t0.prolongated AS prolongated_50, t0.complianceStatus AS complianceStatus_51, t0.complianceDate AS complianceDate_52, t0.dateCheckCNI AS dateCheckCNI_53, t0.dateCheckIBAN AS dateCheckIBAN_54, t0.dateCheckSignedContract AS dateCheckSignedContract_55, t0.dateCheckLIFEE AS dateCheckLIFEE_56, t0.dateCheckSignedPV AS dateCheckSignedPV_57, t0.dateCheckDatePV AS dateCheckDatePV_58, t0.dateCheckSupplierInvoice AS dateCheckSupplierInvoice_59, t0.dateCheckFunder AS dateCheckFunder_60, t0.dateCheckDateCession AS dateCheckDateCession_61, t0.dateCheckAmount AS dateCheckAmount_62, t0.dateCheckAssets AS dateCheckAssets_63, t0.directSales AS directSales_64, t0.gracePeriodDate AS gracePeriodDate_65, t0.depositBankDate AS depositBankDate_66, t0.assetURL AS assetURL_67, t0.customField1 AS customField1_68, t0.customField2 AS customField2_69, t0.customField3 AS customField3_70, t0.customField4 AS customField4_71, t0.customField5 AS customField5_72, t0.conditionOthersText AS conditionOthersText_73, t0.conditionalAccept AS conditionalAccept_74, t0.conditionCosme AS conditionCosme_75, t0.conditionsPvt AS conditionsPvt_76, t0.conditionsPvtWithoutRisk AS conditionsPvtWithoutRisk_77, t0.conditionLowerFinancedAmount AS conditionLowerFinancedAmount_78, t0.conditionEr AS conditionEr_79, t0.conditionErpRate AS conditionErpRate_80, t0.conditionVr AS conditionVr_81, t0.conditionOthers AS conditionOthers_82, t0.conditionWithGuarantee AS conditionWithGuarantee_83, t0.conditionGuaranteeRate AS conditionGuaranteeRate_84, t0.operationContext AS operationContext_85, t0.operationRequirements AS operationRequirements_86, t0.operationFinancials AS operationFinancials_87, t0.operationGuarantees AS operationGuarantees_88, t0.operationSummary AS operationSummary_89, t0.signedContractAzureId AS signedContractAzureId_90, t0.supInfos AS supInfos_91, t0.extraInfos AS extraInfos_92, t0.migrLocked AS migrLocked_93, t0.supplierPaidAfterCAL AS supplierPaidAfterCAL_94, t0.refUpsell AS refUpsell_95, t0.amountUpsell AS amountUpsell_96, t0.fixedAsset AS fixedAsset_97, t0.dateOnboardingMailSent AS dateOnboardingMailSent_98, t0.idUserCheckCNI AS idUserCheckCNI_99, t0.idUserCheckIBAN AS idUserCheckIBAN_100, t0.idUserCheckSignedContract AS idUserCheckSignedContract_101, t0.idUserCheckLIFEE AS idUserCheckLIFEE_102, t0.idUserCheckSignedPV AS idUserCheckSignedPV_103, t0.idUserCheckDatePV AS idUserCheckDatePV_104, t0.idUserCheckSupplierInvoice AS idUserCheckSupplierInvoice_105, t0.idUserCheckFunder AS idUserCheckFunder_106, t0.idUserCheckDateCession AS idUserCheckDateCession_107, t0.idUserCheckAmount AS idUserCheckAmount_108, t0.idUserCheckAssets AS idUserCheckAssets_109, t0.idFunding AS idFunding_110, t0.idInvoicing AS idInvoicing_111, t0.idClientMainContact AS idClientMainContact_112, t0.idPartnerSales AS idPartnerSales_113, t0.idPartnerADV AS idPartnerADV_114, t0.idLeasSales AS idLeasSales_115, t0.idLeasADV AS idLeasADV_116, t0.idFunder AS idFunder_117, t0.idPartner AS idPartner_118, t0.idClient AS idClient_119, t0.idTenant AS idTenant_120, t0.idSupplier AS idSupplier_121, t0.idContractLot AS idContractLot_122, t0.idEnvelope AS idEnvelope_123 FROM contract t0 WHERE t0.idContract = ? LIMIT 1
Parameters:
[
"2010"
]
|
| 6 | 6.11 ms |
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')
Parameters:
[
5859
]
|
| 7 | 6.00 ms |
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
Parameters:
[
5859
]
|
| 8 | 6.06 ms |
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')
Parameters:
[
18454
]
|
| 9 | 5.96 ms |
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
Parameters:
[
18454
]
|
| 10 | 6.17 ms |
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')
Parameters:
[
28
]
|
| 11 | 6.02 ms |
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
Parameters:
[
28
]
|
| 12 | 6.19 ms |
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')
Parameters:
[
6549
]
|
| 13 | 6.01 ms |
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
Parameters:
[
6549
]
|
| 14 | 9.48 ms |
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.code = ? AND t0.type IN ('tenant', 'partner', 'client', 'funder') LIMIT 1
Parameters:
[
"APLIZ"
]
|
| 15 | 6.09 ms |
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
Parameters:
[
5047
]
|
| 16 | 6.24 ms |
SELECT t0.idFunder AS idFunder_1, t0.name AS name_2, t0.registration AS registration_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.phone AS phone_6, t0.vatNumber AS vatNumber_7, t0.email AS email_8, t0.web AS web_9, t0.apiUrl AS apiUrl_10, t0.apiKey AS apiKey_11, t0.idPayeeBC AS idPayeeBC_12, t0.idPayerBC AS idPayerBC_13, t0.siren AS siren_14, t0.active AS active_15, t0.captiveSigner AS captiveSigner_16, t0.updateDate AS updateDate_17, t0.insertDate AS insertDate_18, t0.legalForm AS legalForm_19, t0.activityCode AS activityCode_20, t0.retroCom AS retroCom_21, t0.sepaRef AS sepaRef_22, t0.apiCode AS apiCode_23, t0.creditLimit AS creditLimit_24, t0.defaultExpiration AS defaultExpiration_25, t0.allMustSign AS allMustSign_26, t0.hasApi AS hasApi_27, t0.hasUpdate AS hasUpdate_28, t0.groupedBBK AS groupedBBK_29, t0.invWithAssetsDetails AS invWithAssetsDetails_30, t0.needAssetsList AS needAssetsList_31, t0.docSendMode AS docSendMode_32, t0.docSendRecipient AS docSendRecipient_33, t0.blockedNafs AS blockedNafs_34 FROM funder t0 ORDER BY t0.name ASC
Parameters:
[] |
| 17 | 11.17 ms |
SELECT t0.idFunding AS idFunding_1, t0.financedAmountExclTax AS financedAmountExclTax_2, t0.durationInMonths AS durationInMonths_3, t0.frequency AS frequency_4, t0.coefficient AS coefficient_5, t0.apr AS apr_6, t0.withoutFEE AS withoutFEE_7, t0.withoutINS AS withoutINS_8, t0.withoutLI AS withoutLI_9, t0.custom AS custom_10, t0.supplierPrice AS supplierPrice_11, t0.paymentExclTax AS paymentExclTax_12, t0.paymentTaxRate AS paymentTaxRate_13, t0.paymentInMonthsExclTax AS paymentInMonthsExclTax_14, t0.annualRate AS annualRate_15, t0.gracePeriodDuration AS gracePeriodDuration_16, t0.delay AS delay_17, t0.financialProduct AS financialProduct_18, t0.financialScheme AS financialScheme_19, t0.assetIsNew AS assetIsNew_20, t0.assetAge AS assetAge_21, t0.ratesTables AS ratesTables_22, t0.defaultFrequency AS defaultFrequency_23, t0.defaultDuration AS defaultDuration_24, t0.defaultAnnualRate AS defaultAnnualRate_25, t0.defaultResidualValue AS defaultResidualValue_26, t0.hasUsedAssets AS hasUsedAssets_27, t0.vrValue AS vrValue_28, t0.vrMode AS vrMode_29, t0.maxVrValue AS maxVrValue_30, t0.minVrValue AS minVrValue_31, t0.vrValueType AS vrValueType_32, t0.vrEditablePartner AS vrEditablePartner_33, t0.hasFirstPayment AS hasFirstPayment_34, t0.firstPaymentValueType AS firstPaymentValueType_35, t0.firstPaymentValue AS firstPaymentValue_36, t0.maxFirstPaymentValue AS maxFirstPaymentValue_37, t0.hasMaintenance AS hasMaintenance_38, t0.maintenanceHidden AS maintenanceHidden_39, t0.maintenanceValue AS maintenanceValue_40, t0.maintenanceValueType AS maintenanceValueType_41, t0.maintenanceLabel AS maintenanceLabel_42, t0.openingFeeAmount AS openingFeeAmount_43, t0.yearlyFeeAmount AS yearlyFeeAmount_44, t0.insuranceRate AS insuranceRate_45, t0.insuranceHidden AS insuranceHidden_46, t0.insuranceFrequency AS insuranceFrequency_47, t0.insuranceReversalRate AS insuranceReversalRate_48, t0.hasRewards AS hasRewards_49, t0.rewards AS rewards_50, t0.rewardsFrequency AS rewardsFrequency_51, t0.rewardsTarget AS rewardsTarget_52, t0.hasRetroComPartner AS hasRetroComPartner_53, t0.retroComPartner AS retroComPartner_54, t0.retroComPartnerFrequency AS retroComPartnerFrequency_55, t0.retroComPartnerTarget AS retroComPartnerTarget_56, t0.hasYearlyRetroComPartner AS hasYearlyRetroComPartner_57, t0.yearlyRetroComPartner AS yearlyRetroComPartner_58, t0.yearlyRetroComPartnerFrequency AS yearlyRetroComPartnerFrequency_59, t0.yearlyRetroComPartnerTarget AS yearlyRetroComPartnerTarget_60, t0.hasLiCommission AS hasLiCommission_61, t0.liCommission AS liCommission_62, t0.liCommissionFrequency AS liCommissionFrequency_63, t0.liCommissionTarget AS liCommissionTarget_64, t0.hasInsuranceCommission AS hasInsuranceCommission_65, t0.insuranceCommission AS insuranceCommission_66, t0.insuranceCommissionFrequency AS insuranceCommissionFrequency_67, t0.insuranceCommissionTarget AS insuranceCommissionTarget_68, t0.hasOpeningFeeCommission AS hasOpeningFeeCommission_69, t0.openingFeeCommission AS openingFeeCommission_70, t0.openingFeeCommissionFrequency AS openingFeeCommissionFrequency_71, t0.openingFeeCommissionTarget AS openingFeeCommissionTarget_72, t0.hasFundingMarginCommission AS hasFundingMarginCommission_73, t0.fundingMarginCommission AS fundingMarginCommission_74, t0.fundingMarginCommissionFrequency AS fundingMarginCommissionFrequency_75, t0.fundingMarginCommissionTarget AS fundingMarginCommissionTarget_76, t0.hasYearlyFeeCommission AS hasYearlyFeeCommission_77, t0.yearlyFeeCommission AS yearlyFeeCommission_78, t0.yearlyFeeCommissionFrequency AS yearlyFeeCommissionFrequency_79, t0.yearlyFeeCommissionTarget AS yearlyFeeCommissionTarget_80, t0.prolongationValue AS prolongationValue_81, t0.prolongationValueType AS prolongationValueType_82, t0.hasProlongationCommission AS hasProlongationCommission_83, t0.prolongationCommission AS prolongationCommission_84, t0.prolongationCommissionFrequency AS prolongationCommissionFrequency_85, t0.prolongationCommissionTarget AS prolongationCommissionTarget_86, t0.rate AS rate_87, t0.amount AS amount_88, t0.margin AS margin_89, t0.marginRate AS marginRate_90, t0.marginPercentage AS marginPercentage_91, t0.renewalSurchargeRate AS renewalSurchargeRate_92, t0.nonRenewalSurchargeRate AS nonRenewalSurchargeRate_93, t0.reference AS reference_94, t0.remainingBalanceCalc AS remainingBalanceCalc_95, t0.defaultSimulation AS defaultSimulation_96, t97.idContract AS idContract_98, t97.name AS name_99, t97.type AS type_100, t97.status AS status_101, t97.statusV1 AS statusV1_102, t97.signatureStatus AS signatureStatus_103, t97.signedClient AS signedClient_104, t97.signedTenant AS signedTenant_105, t97.signedFunder AS signedFunder_106, t97.subStatus AS subStatus_107, t97.externalReference AS externalReference_108, t97.externalLabel AS externalLabel_109, t97.registration AS registration_110, t97.managementType AS managementType_111, t97.clientScore AS clientScore_112, t97.insertDate AS insertDate_113, t97.updateDate AS updateDate_114, t97.submitDate AS submitDate_115, t97.acceptDate AS acceptDate_116, t97.selectFunderDate AS selectFunderDate_117, t97.activationDate AS activationDate_118, t97.startDate AS startDate_119, t97.endDate AS endDate_120, t97.rejectDate AS rejectDate_121, t97.cancelledDate AS cancelledDate_122, t97.closedDate AS closedDate_123, t97.expirationDate AS expirationDate_124, t97.pvDate AS pvDate_125, t97.sepaDate AS sepaDate_126, t97.estimatedDeliveryDate AS estimatedDeliveryDate_127, t97.firstPaymentDate AS firstPaymentDate_128, t97.deliveryDate AS deliveryDate_129, t97.cessionDate AS cessionDate_130, t97.lastRentDate AS lastRentDate_131, t97.signDatePartner AS signDatePartner_132, t97.signDateClient AS signDateClient_133, t97.signDateFunder AS signDateFunder_134, t97.signDateTenant AS signDateTenant_135, t97.sentDateClient AS sentDateClient_136, t97.sentDateFunder AS sentDateFunder_137, t97.sentDateTenant AS sentDateTenant_138, t97.partnerValidationDate AS partnerValidationDate_139, t97.prolongEndDate AS prolongEndDate_140, t97.selectedProlongEndDate AS selectedProlongEndDate_141, t97.installDate AS installDate_142, t97.supplierInvoiceReference AS supplierInvoiceReference_143, t97.supplierInvoiceDate AS supplierInvoiceDate_144, t97.bdc AS bdc_145, t97.vad AS vad_146, t97.prolongated AS prolongated_147, t97.complianceStatus AS complianceStatus_148, t97.complianceDate AS complianceDate_149, t97.dateCheckCNI AS dateCheckCNI_150, t97.dateCheckIBAN AS dateCheckIBAN_151, t97.dateCheckSignedContract AS dateCheckSignedContract_152, t97.dateCheckLIFEE AS dateCheckLIFEE_153, t97.dateCheckSignedPV AS dateCheckSignedPV_154, t97.dateCheckDatePV AS dateCheckDatePV_155, t97.dateCheckSupplierInvoice AS dateCheckSupplierInvoice_156, t97.dateCheckFunder AS dateCheckFunder_157, t97.dateCheckDateCession AS dateCheckDateCession_158, t97.dateCheckAmount AS dateCheckAmount_159, t97.dateCheckAssets AS dateCheckAssets_160, t97.directSales AS directSales_161, t97.gracePeriodDate AS gracePeriodDate_162, t97.depositBankDate AS depositBankDate_163, t97.assetURL AS assetURL_164, t97.customField1 AS customField1_165, t97.customField2 AS customField2_166, t97.customField3 AS customField3_167, t97.customField4 AS customField4_168, t97.customField5 AS customField5_169, t97.conditionOthersText AS conditionOthersText_170, t97.conditionalAccept AS conditionalAccept_171, t97.conditionCosme AS conditionCosme_172, t97.conditionsPvt AS conditionsPvt_173, t97.conditionsPvtWithoutRisk AS conditionsPvtWithoutRisk_174, t97.conditionLowerFinancedAmount AS conditionLowerFinancedAmount_175, t97.conditionEr AS conditionEr_176, t97.conditionErpRate AS conditionErpRate_177, t97.conditionVr AS conditionVr_178, t97.conditionOthers AS conditionOthers_179, t97.conditionWithGuarantee AS conditionWithGuarantee_180, t97.conditionGuaranteeRate AS conditionGuaranteeRate_181, t97.operationContext AS operationContext_182, t97.operationRequirements AS operationRequirements_183, t97.operationFinancials AS operationFinancials_184, t97.operationGuarantees AS operationGuarantees_185, t97.operationSummary AS operationSummary_186, t97.signedContractAzureId AS signedContractAzureId_187, t97.supInfos AS supInfos_188, t97.extraInfos AS extraInfos_189, t97.migrLocked AS migrLocked_190, t97.supplierPaidAfterCAL AS supplierPaidAfterCAL_191, t97.refUpsell AS refUpsell_192, t97.amountUpsell AS amountUpsell_193, t97.fixedAsset AS fixedAsset_194, t97.dateOnboardingMailSent AS dateOnboardingMailSent_195, t97.idUserCheckCNI AS idUserCheckCNI_196, t97.idUserCheckIBAN AS idUserCheckIBAN_197, t97.idUserCheckSignedContract AS idUserCheckSignedContract_198, t97.idUserCheckLIFEE AS idUserCheckLIFEE_199, t97.idUserCheckSignedPV AS idUserCheckSignedPV_200, t97.idUserCheckDatePV AS idUserCheckDatePV_201, t97.idUserCheckSupplierInvoice AS idUserCheckSupplierInvoice_202, t97.idUserCheckFunder AS idUserCheckFunder_203, t97.idUserCheckDateCession AS idUserCheckDateCession_204, t97.idUserCheckAmount AS idUserCheckAmount_205, t97.idUserCheckAssets AS idUserCheckAssets_206, t97.idFunding AS idFunding_207, t97.idInvoicing AS idInvoicing_208, t97.idClientMainContact AS idClientMainContact_209, t97.idPartnerSales AS idPartnerSales_210, t97.idPartnerADV AS idPartnerADV_211, t97.idLeasSales AS idLeasSales_212, t97.idLeasADV AS idLeasADV_213, t97.idFunder AS idFunder_214, t97.idPartner AS idPartner_215, t97.idClient AS idClient_216, t97.idTenant AS idTenant_217, t97.idSupplier AS idSupplier_218, t97.idContractLot AS idContractLot_219, t97.idEnvelope AS idEnvelope_220, t0.idPartnerScheme AS idPartnerScheme_221, t222.idPartnerScheme AS idPartnerScheme_223, t222.insertDate AS insertDate_224, t222.updateDate AS updateDate_225, t222.startDate AS startDate_226, t222.endDate AS endDate_227, t222.code AS code_228, t222.codeScheme AS codeScheme_229, t222.name AS name_230, t222.active AS active_231, t222.useStage AS useStage_232, t222.visiblePartner AS visiblePartner_233, t222.defaultSimulation AS defaultSimulation_234, t222.contractType AS contractType_235, t222.idMongo AS idMongo_236, t222.ratesTables AS ratesTables_237, t222.defaultFrequency AS defaultFrequency_238, t222.defaultRentInput AS defaultRentInput_239, t222.defaultDuration AS defaultDuration_240, t222.defaultFreeDuration AS defaultFreeDuration_241, t222.defaultAnnualRate AS defaultAnnualRate_242, t222.gracePeriodRates AS gracePeriodRates_243, t222.defaultResidualValue AS defaultResidualValue_244, t222.hasUsedAssets AS hasUsedAssets_245, t222.renew AS renew_246, t222.withoutLI AS withoutLI_247, t222.vrMode AS vrMode_248, t222.maxVrValue AS maxVrValue_249, t222.minVrValue AS minVrValue_250, t222.vrValueType AS vrValueType_251, t222.vrTable AS vrTable_252, t222.vrEditablePartner AS vrEditablePartner_253, t222.hasFirstPayment AS hasFirstPayment_254, t222.firstPaymentValueType AS firstPaymentValueType_255, t222.maxFirstPaymentValue AS maxFirstPaymentValue_256, t222.minMaintenanceValue AS minMaintenanceValue_257, t222.maxMaintenanceValue AS maxMaintenanceValue_258, t222.maintenanceValue AS maintenanceValue_259, t222.maintenanceValueType AS maintenanceValueType_260, t222.maintenanceLabel AS maintenanceLabel_261, t222.maintenanceHidden AS maintenanceHidden_262, t222.openingFeeValue AS openingFeeValue_263, t222.openingFeeValueType AS openingFeeValueType_264, t222.yearlyFeeAmount AS yearlyFeeAmount_265, t222.insuranceRate AS insuranceRate_266, t222.insuranceReversalRate AS insuranceReversalRate_267, t222.insuranceHidden AS insuranceHidden_268, t222.insuranceFrequency AS insuranceFrequency_269, t222.hasRewards AS hasRewards_270, t222.rewards AS rewards_271, t222.rewardsFrequency AS rewardsFrequency_272, t222.rewardsTarget AS rewardsTarget_273, t222.hasRetroComPartner AS hasRetroComPartner_274, t222.retroComPartner AS retroComPartner_275, t222.retroComPartnerFrequency AS retroComPartnerFrequency_276, t222.retroComPartnerTarget AS retroComPartnerTarget_277, t222.hasYearlyRetroComPartner AS hasYearlyRetroComPartner_278, t222.yearlyRetroComPartner AS yearlyRetroComPartner_279, t222.yearlyRetroComPartnerFrequency AS yearlyRetroComPartnerFrequency_280, t222.yearlyRetroComPartnerTarget AS yearlyRetroComPartnerTarget_281, t222.hasLiCommission AS hasLiCommission_282, t222.liCommission AS liCommission_283, t222.liCommissionFrequency AS liCommissionFrequency_284, t222.liCommissionTarget AS liCommissionTarget_285, t222.hasInsuranceCommission AS hasInsuranceCommission_286, t222.insuranceCommission AS insuranceCommission_287, t222.insuranceCommissionFrequency AS insuranceCommissionFrequency_288, t222.insuranceCommissionTarget AS insuranceCommissionTarget_289, t222.hasOpeningFeeCommission AS hasOpeningFeeCommission_290, t222.openingFeeCommission AS openingFeeCommission_291, t222.openingFeeCommissionFrequency AS openingFeeCommissionFrequency_292, t222.openingFeeCommissionTarget AS openingFeeCommissionTarget_293, t222.hasFundingMarginCommission AS hasFundingMarginCommission_294, t222.fundingMarginCommission AS fundingMarginCommission_295, t222.fundingMarginCommissionFrequency AS fundingMarginCommissionFrequency_296, t222.fundingMarginCommissionTarget AS fundingMarginCommissionTarget_297, t222.hasYearlyFeeCommission AS hasYearlyFeeCommission_298, t222.yearlyFeeCommission AS yearlyFeeCommission_299, t222.yearlyFeeCommissionFrequency AS yearlyFeeCommissionFrequency_300, t222.yearlyFeeCommissionTarget AS yearlyFeeCommissionTarget_301, t222.resaleValue AS resaleValue_302, t222.resaleValueType AS resaleValueType_303, t222.guaranteeRate AS guaranteeRate_304, t222.erpRate AS erpRate_305, t222.resaleTarget AS resaleTarget_306, t222.idPartner AS idPartner_307 FROM funding t0 LEFT JOIN contract t97 ON t97.idFunding = t0.idFunding LEFT JOIN partnerScheme t222 ON t0.idPartnerScheme = t222.idPartnerScheme WHERE t0.idFunding = ?
Parameters:
[
41877
]
|
| 18 | 6.20 ms |
SELECT t0.idFundingParam AS idFundingParam_1, t0.registration AS registration_2, t0.name AS name_3, t0.status AS status_4, t0.infos AS infos_5, t0.managementType AS managementType_6, t0.contractRegistration AS contractRegistration_7, t0.fundRegistration AS fundRegistration_8, t0.rate AS rate_9, t0.amount AS amount_10, t0.margin AS margin_11, t0.residualValue AS residualValue_12, t0.residualValueType AS residualValueType_13, t0.reference AS reference_14, t0.frontReference AS frontReference_15, t0.internalReference AS internalReference_16, t0.requestStartDate AS requestStartDate_17, t0.dueDate AS dueDate_18, t0.acceptDate AS acceptDate_19, t0.expirationDate AS expirationDate_20, t0.insertDate AS insertDate_21, t0.api_ids AS api_ids_22, t0.byApi AS byApi_23, t0.idUser AS idUser_24, t0.idFunderScheme AS idFunderScheme_25, t0.idMaterial AS idMaterial_26, t0.idFunder4Partner AS idFunder4Partner_27, t0.idContract AS idContract_28, t0.idFunder AS idFunder_29 FROM fundingParam t0 WHERE t0.idContract = ?
Parameters:
[
2010
]
|
Database Connections
| Name | Service |
|---|---|
| v1 | doctrine.dbal.v1_connection |
| aplizV2 | doctrine.dbal.aplizV2_connection |
Entity Managers
| Name | Service |
|---|---|
| v1 | doctrine.orm.v1_entity_manager |
| aplizV2 | doctrine.orm.aplizV2_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
v1 entity manager
| Class | Amount of managed objects |
|---|
aplizV2 entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\AplizV2\Funder | 23 |
| App\Entity\AplizV2\TenantParam | 13 |
| App\Entity\AplizV2\UserPartner | 10 |
| App\Entity\AplizV2\Partner | 8 |
| App\Entity\AplizV2\User | 6 |
| App\Entity\AplizV2\FundingParam | 3 |
| App\Entity\AplizV2\Client | 2 |
| App\Entity\AplizV2\Tenant | 1 |
| App\Entity\AplizV2\Contract | 1 |
| App\Entity\AplizV2\Funding | 1 |
| App\Entity\AplizV2\Invoicing | 1 |
| App\Entity\AplizV2\PartnerScheme | 1 |
Entities Mapping
v1 entity manager
No loaded entities.