Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

22.03 ms Query time

2 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

aplizV2 connection

Time▼	Count	Info
16.59 ms (75.34%)	1	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.target AS target_31, t0.useQuote AS useQuote_32, t0.useAI AS useAI_33, t0.useAssetUrl AS useAssetUrl_34, t0.withoutPartnerVr AS withoutPartnerVr_35, t0.useMicrosoftAuth AS useMicrosoftAuth_36, t0.useGoogleAuth AS useGoogleAuth_37, t0.useAccounting AS useAccounting_38, t0.usePartnerDeals AS usePartnerDeals_39, t0.useContractLots AS useContractLots_40, t0.useProlong AS useProlong_41, t0.useElliPro AS useElliPro_42, t0.useCreditsafe AS useCreditsafe_43, t0.useEbicsExport AS useEbicsExport_44, t0.useEbicsImport AS useEbicsImport_45, t0.liOnScheduler AS liOnScheduler_46, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_47, t0.ibanOnClientSign AS ibanOnClientSign_48, t0.bankAccountRef AS bankAccountRef_49, t0.paymentJournalRef AS paymentJournalRef_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.creditCardLink AS creditCardLink_61, t0.postingGroups AS postingGroups_62 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.target AS target_31, t0.useQuote AS useQuote_32, t0.useAI AS useAI_33, t0.useAssetUrl AS useAssetUrl_34, t0.withoutPartnerVr AS withoutPartnerVr_35, t0.useMicrosoftAuth AS useMicrosoftAuth_36, t0.useGoogleAuth AS useGoogleAuth_37, t0.useAccounting AS useAccounting_38, t0.usePartnerDeals AS usePartnerDeals_39, t0.useContractLots AS useContractLots_40, t0.useProlong AS useProlong_41, t0.useElliPro AS useElliPro_42, t0.useCreditsafe AS useCreditsafe_43, t0.useEbicsExport AS useEbicsExport_44, t0.useEbicsImport AS useEbicsImport_45, t0.liOnScheduler AS liOnScheduler_46, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_47, t0.ibanOnClientSign AS ibanOnClientSign_48, t0.bankAccountRef AS bankAccountRef_49, t0.paymentJournalRef AS paymentJournalRef_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.creditCardLink AS creditCardLink_61, t0.postingGroups AS postingGroups_62 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.target AS target_31, t0.useQuote AS useQuote_32, t0.useAI AS useAI_33, t0.useAssetUrl AS useAssetUrl_34, t0.withoutPartnerVr AS withoutPartnerVr_35, t0.useMicrosoftAuth AS useMicrosoftAuth_36, t0.useGoogleAuth AS useGoogleAuth_37, t0.useAccounting AS useAccounting_38, t0.usePartnerDeals AS usePartnerDeals_39, t0.useContractLots AS useContractLots_40, t0.useProlong AS useProlong_41, t0.useElliPro AS useElliPro_42, t0.useCreditsafe AS useCreditsafe_43, t0.useEbicsExport AS useEbicsExport_44, t0.useEbicsImport AS useEbicsImport_45, t0.liOnScheduler AS liOnScheduler_46, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_47, t0.ibanOnClientSign AS ibanOnClientSign_48, t0.bankAccountRef AS bankAccountRef_49, t0.paymentJournalRef AS paymentJournalRef_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.creditCardLink AS creditCardLink_61, t0.postingGroups AS postingGroups_62 FROM tenant t0 WHERE t0.idTenant = 1;
5.43 ms (24.66%)	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 = ? 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▼

Count

Info

16.59 ms
(75.34%)

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.target AS target_31, t0.useQuote AS useQuote_32, t0.useAI AS useAI_33, t0.useAssetUrl AS useAssetUrl_34, t0.withoutPartnerVr AS withoutPartnerVr_35, t0.useMicrosoftAuth AS useMicrosoftAuth_36, t0.useGoogleAuth AS useGoogleAuth_37, t0.useAccounting AS useAccounting_38, t0.usePartnerDeals AS usePartnerDeals_39, t0.useContractLots AS useContractLots_40, t0.useProlong AS useProlong_41, t0.useElliPro AS useElliPro_42, t0.useCreditsafe AS useCreditsafe_43, t0.useEbicsExport AS useEbicsExport_44, t0.useEbicsImport AS useEbicsImport_45, t0.liOnScheduler AS liOnScheduler_46, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_47, t0.ibanOnClientSign AS ibanOnClientSign_48, t0.bankAccountRef AS bankAccountRef_49, t0.paymentJournalRef AS paymentJournalRef_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.creditCardLink AS creditCardLink_61, t0.postingGroups AS postingGroups_62 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.target AS target_31,
  t0.useQuote AS useQuote_32,
  t0.useAI AS useAI_33,
  t0.useAssetUrl AS useAssetUrl_34,
  t0.withoutPartnerVr AS withoutPartnerVr_35,
  t0.useMicrosoftAuth AS useMicrosoftAuth_36,
  t0.useGoogleAuth AS useGoogleAuth_37,
  t0.useAccounting AS useAccounting_38,
  t0.usePartnerDeals AS usePartnerDeals_39,
  t0.useContractLots AS useContractLots_40,
  t0.useProlong AS useProlong_41,
  t0.useElliPro AS useElliPro_42,
  t0.useCreditsafe AS useCreditsafe_43,
  t0.useEbicsExport AS useEbicsExport_44,
  t0.useEbicsImport AS useEbicsImport_45,
  t0.liOnScheduler AS liOnScheduler_46,
  t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_47,
  t0.ibanOnClientSign AS ibanOnClientSign_48,
  t0.bankAccountRef AS bankAccountRef_49,
  t0.paymentJournalRef AS paymentJournalRef_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.creditCardLink AS creditCardLink_61,
  t0.postingGroups AS postingGroups_62
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.target AS target_31, t0.useQuote AS useQuote_32, t0.useAI AS useAI_33, t0.useAssetUrl AS useAssetUrl_34, t0.withoutPartnerVr AS withoutPartnerVr_35, t0.useMicrosoftAuth AS useMicrosoftAuth_36, t0.useGoogleAuth AS useGoogleAuth_37, t0.useAccounting AS useAccounting_38, t0.usePartnerDeals AS usePartnerDeals_39, t0.useContractLots AS useContractLots_40, t0.useProlong AS useProlong_41, t0.useElliPro AS useElliPro_42, t0.useCreditsafe AS useCreditsafe_43, t0.useEbicsExport AS useEbicsExport_44, t0.useEbicsImport AS useEbicsImport_45, t0.liOnScheduler AS liOnScheduler_46, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_47, t0.ibanOnClientSign AS ibanOnClientSign_48, t0.bankAccountRef AS bankAccountRef_49, t0.paymentJournalRef AS paymentJournalRef_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.creditCardLink AS creditCardLink_61, t0.postingGroups AS postingGroups_62 FROM tenant t0 WHERE t0.idTenant = 1;

5.43 ms
(24.66%)

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://bbs.fiimatdev.fr/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

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