Query Metrics
11
Database Queries
6
Different statements
112.45 ms
Query time
0
Invalid entities
27
Managed entities
Queries
aplizV2 connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 23.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 | 5.88 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.16 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:
[
"36800"
]
|
| 4 | 5.92 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:
[
20482
]
|
| 5 | 5.87 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:
[
20482
]
|
| 6 | 5.99 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:
[
6401
]
|
| 7 | 5.85 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:
[
6401
]
|
| 8 | 6.00 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:
[
5784
]
|
| 9 | 6.04 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:
[
7159
]
|
| 10 | 5.85 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:
[
7159
]
|
| 11 | 35.16 ms |
SELECT t0.idElementLine AS idElementLine_1, t0.date AS date_2, t0.paymentDate AS paymentDate_3, t0.postponedDate AS postponedDate_4, t0.amount AS amount_5, t0.interest AS interest_6, t0.taxPercentage AS taxPercentage_7, t0.creditMemo AS creditMemo_8, t0.idMongo AS idMongo_9, t0.idInvoiceBC AS idInvoiceBC_10, t0.noInvoiceBC AS noInvoiceBC_11, t0.ccnOrigin AS ccnOrigin_12, t0.statusInvoiceBC AS statusInvoiceBC_13, t0.rejectCause AS rejectCause_14, t0.representCount AS representCount_15, t0.lastRepresentDate AS lastRepresentDate_16, t0.rejectDate AS rejectDate_17, t0.mailSentDate AS mailSentDate_18, t0.invoiceRegistration AS invoiceRegistration_19, t0.idInvoice AS idInvoice_20, t0.idElement AS idElement_21 FROM elementLine t0 WHERE t0.idElementLine = ? LIMIT 1
Parameters:
[
"9043106"
]
|
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\TenantParam | 13 |
| App\Entity\AplizV2\User | 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\UserPartner | 1 |
| App\Entity\AplizV2\Partner | 1 |
| App\Entity\AplizV2\Funder | 1 |
| App\Entity\AplizV2\ElementLine | 1 |
| App\Entity\AplizV2\Element | 1 |
Entities Mapping
v1 entity manager
No loaded entities.