Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

21.17 ms Query time

2 Invalid entities

7 Managed entities

Queries

Group similar statements

aplizV2 connection

#▲	Time	Info
1	15.95 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.recoveryDelay AS recoveryDelay_29, t0.defaultFundersDelay AS defaultFundersDelay_30, t0.useQuote AS useQuote_31, t0.useAI AS useAI_32, t0.useAssetUrl AS useAssetUrl_33, t0.withoutPartnerVr AS withoutPartnerVr_34, t0.useMicrosoftAuth AS useMicrosoftAuth_35, t0.useGoogleAuth AS useGoogleAuth_36, t0.useAccounting AS useAccounting_37, t0.usePartnerDeals AS usePartnerDeals_38, t0.useContractLots AS useContractLots_39, t0.useProlong AS useProlong_40, t0.useElliPro AS useElliPro_41, t0.useCreditsafe AS useCreditsafe_42, t0.useEbicsExport AS useEbicsExport_43, t0.useEbicsImport AS useEbicsImport_44, t0.liOnScheduler AS liOnScheduler_45, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_46, t0.ibanOnClientSign AS ibanOnClientSign_47, t0.bankAccountRef AS bankAccountRef_48, t0.paymentJournalRef AS paymentJournalRef_49, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_50, t0.canManagePartnerFee AS canManagePartnerFee_51, t0.autoReject AS autoReject_52, t0.extraSignCheck AS extraSignCheck_53, t0.blockedSirens AS blockedSirens_54, t0.slug AS slug_55, t0.primaryColor AS primaryColor_56, t0.secondaryColor AS secondaryColor_57, t0.fixedAssetCode AS fixedAssetCode_58, t0.lossCalculationBase AS lossCalculationBase_59, t0.creditCardLink AS creditCardLink_60 FROM tenant t0 WHERE t0.idTenant = ? Parameters: [`1`] View formatted query View runnable query Explain query 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.recoveryDelay AS recoveryDelay_29, t0.defaultFundersDelay AS defaultFundersDelay_30, t0.useQuote AS useQuote_31, t0.useAI AS useAI_32, t0.useAssetUrl AS useAssetUrl_33, t0.withoutPartnerVr AS withoutPartnerVr_34, t0.useMicrosoftAuth AS useMicrosoftAuth_35, t0.useGoogleAuth AS useGoogleAuth_36, t0.useAccounting AS useAccounting_37, t0.usePartnerDeals AS usePartnerDeals_38, t0.useContractLots AS useContractLots_39, t0.useProlong AS useProlong_40, t0.useElliPro AS useElliPro_41, t0.useCreditsafe AS useCreditsafe_42, t0.useEbicsExport AS useEbicsExport_43, t0.useEbicsImport AS useEbicsImport_44, t0.liOnScheduler AS liOnScheduler_45, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_46, t0.ibanOnClientSign AS ibanOnClientSign_47, t0.bankAccountRef AS bankAccountRef_48, t0.paymentJournalRef AS paymentJournalRef_49, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_50, t0.canManagePartnerFee AS canManagePartnerFee_51, t0.autoReject AS autoReject_52, t0.extraSignCheck AS extraSignCheck_53, t0.blockedSirens AS blockedSirens_54, t0.slug AS slug_55, t0.primaryColor AS primaryColor_56, t0.secondaryColor AS secondaryColor_57, t0.fixedAssetCode AS fixedAssetCode_58, t0.lossCalculationBase AS lossCalculationBase_59, t0.creditCardLink AS creditCardLink_60 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.recoveryDelay AS recoveryDelay_29, t0.defaultFundersDelay AS defaultFundersDelay_30, t0.useQuote AS useQuote_31, t0.useAI AS useAI_32, t0.useAssetUrl AS useAssetUrl_33, t0.withoutPartnerVr AS withoutPartnerVr_34, t0.useMicrosoftAuth AS useMicrosoftAuth_35, t0.useGoogleAuth AS useGoogleAuth_36, t0.useAccounting AS useAccounting_37, t0.usePartnerDeals AS usePartnerDeals_38, t0.useContractLots AS useContractLots_39, t0.useProlong AS useProlong_40, t0.useElliPro AS useElliPro_41, t0.useCreditsafe AS useCreditsafe_42, t0.useEbicsExport AS useEbicsExport_43, t0.useEbicsImport AS useEbicsImport_44, t0.liOnScheduler AS liOnScheduler_45, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_46, t0.ibanOnClientSign AS ibanOnClientSign_47, t0.bankAccountRef AS bankAccountRef_48, t0.paymentJournalRef AS paymentJournalRef_49, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_50, t0.canManagePartnerFee AS canManagePartnerFee_51, t0.autoReject AS autoReject_52, t0.extraSignCheck AS extraSignCheck_53, t0.blockedSirens AS blockedSirens_54, t0.slug AS slug_55, t0.primaryColor AS primaryColor_56, t0.secondaryColor AS secondaryColor_57, t0.fixedAssetCode AS fixedAssetCode_58, t0.lossCalculationBase AS lossCalculationBase_59, t0.creditCardLink AS creditCardLink_60 FROM tenant t0 WHERE t0.idTenant = 1;
2	5.22 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`] View formatted query View runnable query Explain query 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;

#▲

Time

Info

15.95 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.recoveryDelay AS recoveryDelay_29, t0.defaultFundersDelay AS defaultFundersDelay_30, t0.useQuote AS useQuote_31, t0.useAI AS useAI_32, t0.useAssetUrl AS useAssetUrl_33, t0.withoutPartnerVr AS withoutPartnerVr_34, t0.useMicrosoftAuth AS useMicrosoftAuth_35, t0.useGoogleAuth AS useGoogleAuth_36, t0.useAccounting AS useAccounting_37, t0.usePartnerDeals AS usePartnerDeals_38, t0.useContractLots AS useContractLots_39, t0.useProlong AS useProlong_40, t0.useElliPro AS useElliPro_41, t0.useCreditsafe AS useCreditsafe_42, t0.useEbicsExport AS useEbicsExport_43, t0.useEbicsImport AS useEbicsImport_44, t0.liOnScheduler AS liOnScheduler_45, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_46, t0.ibanOnClientSign AS ibanOnClientSign_47, t0.bankAccountRef AS bankAccountRef_48, t0.paymentJournalRef AS paymentJournalRef_49, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_50, t0.canManagePartnerFee AS canManagePartnerFee_51, t0.autoReject AS autoReject_52, t0.extraSignCheck AS extraSignCheck_53, t0.blockedSirens AS blockedSirens_54, t0.slug AS slug_55, t0.primaryColor AS primaryColor_56, t0.secondaryColor AS secondaryColor_57, t0.fixedAssetCode AS fixedAssetCode_58, t0.lossCalculationBase AS lossCalculationBase_59, t0.creditCardLink AS creditCardLink_60 FROM tenant t0 WHERE t0.idTenant = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

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.recoveryDelay AS recoveryDelay_29,
  t0.defaultFundersDelay AS defaultFundersDelay_30,
  t0.useQuote AS useQuote_31,
  t0.useAI AS useAI_32,
  t0.useAssetUrl AS useAssetUrl_33,
  t0.withoutPartnerVr AS withoutPartnerVr_34,
  t0.useMicrosoftAuth AS useMicrosoftAuth_35,
  t0.useGoogleAuth AS useGoogleAuth_36,
  t0.useAccounting AS useAccounting_37,
  t0.usePartnerDeals AS usePartnerDeals_38,
  t0.useContractLots AS useContractLots_39,
  t0.useProlong AS useProlong_40,
  t0.useElliPro AS useElliPro_41,
  t0.useCreditsafe AS useCreditsafe_42,
  t0.useEbicsExport AS useEbicsExport_43,
  t0.useEbicsImport AS useEbicsImport_44,
  t0.liOnScheduler AS liOnScheduler_45,
  t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_46,
  t0.ibanOnClientSign AS ibanOnClientSign_47,
  t0.bankAccountRef AS bankAccountRef_48,
  t0.paymentJournalRef AS paymentJournalRef_49,
  t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_50,
  t0.canManagePartnerFee AS canManagePartnerFee_51,
  t0.autoReject AS autoReject_52,
  t0.extraSignCheck AS extraSignCheck_53,
  t0.blockedSirens AS blockedSirens_54,
  t0.slug AS slug_55,
  t0.primaryColor AS primaryColor_56,
  t0.secondaryColor AS secondaryColor_57,
  t0.fixedAssetCode AS fixedAssetCode_58,
  t0.lossCalculationBase AS lossCalculationBase_59,
  t0.creditCardLink AS creditCardLink_60
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.recoveryDelay AS recoveryDelay_29, t0.defaultFundersDelay AS defaultFundersDelay_30, t0.useQuote AS useQuote_31, t0.useAI AS useAI_32, t0.useAssetUrl AS useAssetUrl_33, t0.withoutPartnerVr AS withoutPartnerVr_34, t0.useMicrosoftAuth AS useMicrosoftAuth_35, t0.useGoogleAuth AS useGoogleAuth_36, t0.useAccounting AS useAccounting_37, t0.usePartnerDeals AS usePartnerDeals_38, t0.useContractLots AS useContractLots_39, t0.useProlong AS useProlong_40, t0.useElliPro AS useElliPro_41, t0.useCreditsafe AS useCreditsafe_42, t0.useEbicsExport AS useEbicsExport_43, t0.useEbicsImport AS useEbicsImport_44, t0.liOnScheduler AS liOnScheduler_45, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_46, t0.ibanOnClientSign AS ibanOnClientSign_47, t0.bankAccountRef AS bankAccountRef_48, t0.paymentJournalRef AS paymentJournalRef_49, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_50, t0.canManagePartnerFee AS canManagePartnerFee_51, t0.autoReject AS autoReject_52, t0.extraSignCheck AS extraSignCheck_53, t0.blockedSirens AS blockedSirens_54, t0.slug AS slug_55, t0.primaryColor AS primaryColor_56, t0.secondaryColor AS secondaryColor_57, t0.fixedAssetCode AS fixedAssetCode_58, t0.lossCalculationBase AS lossCalculationBase_59, t0.creditCardLink AS creditCardLink_60 FROM tenant t0 WHERE t0.idTenant = 1;

5.22 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
]

View formatted query View runnable query Explain query

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;

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	6
App\Entity\AplizV2\Tenant	1

Entities Mapping

v1 entity manager

No loaded entities.

aplizV2 entity manager

Class	Mapping errors
App\Entity\AplizV2\Tenant	No errors.
App\Entity\AplizV2\Entity	No errors.
App\Entity\AplizV2\User	No errors.
App\Entity\AplizV2\Contract	No errors.
App\Entity\AplizV2\TenantParam	No errors.
App\Entity\AplizV2\CustomField	No errors.
App\Entity\AplizV2\Partner	No errors.
App\Entity\AplizV2\Client	No errors.
App\Entity\AplizV2\Funder	No errors.
App\Entity\AplizV2\Prospect	The field 'App\Entity\AplizV2\Prospect#turnover' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\AplizV2\Prospect#equity' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\AplizV2\UserPartner	No errors.
App\Entity\AplizV2\Notification	The mappings App\Entity\AplizV2\Notification#transferfrom and App\Entity\AplizV2\User#notifications are inconsistent with each other.
App\Entity\AplizV2\Funding	No errors.
App\Entity\AplizV2\Invoicing	No errors.
App\Entity\AplizV2\Supplier	No errors.
App\Entity\AplizV2\ContractLot	No errors.
App\Entity\AplizV2\Envelope	No errors.
App\Entity\AplizV2\Signatory	No errors.
App\Entity\AplizV2\Element	No errors.
App\Entity\AplizV2\Invoice	No errors.
App\Entity\AplizV2\Document	No errors.
App\Entity\AplizV2\ContractAsset	No errors.
App\Entity\AplizV2\Note	No errors.
App\Entity\AplizV2\FundingParam	No errors.
App\Entity\AplizV2\Amendment	No errors.
App\Entity\AplizV2\SupplierInvoice	No errors.

Symfony Profiler

GET https://ns2.fiimatdev.fr/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

aplizV2 connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

v1 entity manager

aplizV2 entity manager

Entities Mapping

v1 entity manager

aplizV2 entity manager