Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

41.00 ms Query time

0 Invalid entities

7 Managed entities

Queries

Group similar statements

aplizV2 connection

#▲	Time	Info
1	30.76 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.useQuote AS useQuote_30, t0.useAI AS useAI_31, t0.useAssetUrl AS useAssetUrl_32, t0.withoutPartnerVr AS withoutPartnerVr_33, t0.useMicrosoftAuth AS useMicrosoftAuth_34, t0.useGoogleAuth AS useGoogleAuth_35, t0.useAccounting AS useAccounting_36, t0.usePartnerDeals AS usePartnerDeals_37, t0.useContractLots AS useContractLots_38, t0.useProlong AS useProlong_39, t0.useElliPro AS useElliPro_40, t0.useCreditsafe AS useCreditsafe_41, t0.useEbicsExport AS useEbicsExport_42, t0.useEbicsImport AS useEbicsImport_43, t0.liOnScheduler AS liOnScheduler_44, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_45, t0.ibanOnClientSign AS ibanOnClientSign_46, t0.bankAccountRef AS bankAccountRef_47, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_48, t0.canManagePartnerFee AS canManagePartnerFee_49, t0.autoReject AS autoReject_50, t0.extraSignCheck AS extraSignCheck_51, t0.blockedSirens AS blockedSirens_52, t0.slug AS slug_53, t0.primaryColor AS primaryColor_54, t0.secondaryColor AS secondaryColor_55, t0.fixedAssetCode AS fixedAssetCode_56 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.useQuote AS useQuote_30, t0.useAI AS useAI_31, t0.useAssetUrl AS useAssetUrl_32, t0.withoutPartnerVr AS withoutPartnerVr_33, t0.useMicrosoftAuth AS useMicrosoftAuth_34, t0.useGoogleAuth AS useGoogleAuth_35, t0.useAccounting AS useAccounting_36, t0.usePartnerDeals AS usePartnerDeals_37, t0.useContractLots AS useContractLots_38, t0.useProlong AS useProlong_39, t0.useElliPro AS useElliPro_40, t0.useCreditsafe AS useCreditsafe_41, t0.useEbicsExport AS useEbicsExport_42, t0.useEbicsImport AS useEbicsImport_43, t0.liOnScheduler AS liOnScheduler_44, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_45, t0.ibanOnClientSign AS ibanOnClientSign_46, t0.bankAccountRef AS bankAccountRef_47, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_48, t0.canManagePartnerFee AS canManagePartnerFee_49, t0.autoReject AS autoReject_50, t0.extraSignCheck AS extraSignCheck_51, t0.blockedSirens AS blockedSirens_52, t0.slug AS slug_53, t0.primaryColor AS primaryColor_54, t0.secondaryColor AS secondaryColor_55, t0.fixedAssetCode AS fixedAssetCode_56 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.useQuote AS useQuote_30, t0.useAI AS useAI_31, t0.useAssetUrl AS useAssetUrl_32, t0.withoutPartnerVr AS withoutPartnerVr_33, t0.useMicrosoftAuth AS useMicrosoftAuth_34, t0.useGoogleAuth AS useGoogleAuth_35, t0.useAccounting AS useAccounting_36, t0.usePartnerDeals AS usePartnerDeals_37, t0.useContractLots AS useContractLots_38, t0.useProlong AS useProlong_39, t0.useElliPro AS useElliPro_40, t0.useCreditsafe AS useCreditsafe_41, t0.useEbicsExport AS useEbicsExport_42, t0.useEbicsImport AS useEbicsImport_43, t0.liOnScheduler AS liOnScheduler_44, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_45, t0.ibanOnClientSign AS ibanOnClientSign_46, t0.bankAccountRef AS bankAccountRef_47, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_48, t0.canManagePartnerFee AS canManagePartnerFee_49, t0.autoReject AS autoReject_50, t0.extraSignCheck AS extraSignCheck_51, t0.blockedSirens AS blockedSirens_52, t0.slug AS slug_53, t0.primaryColor AS primaryColor_54, t0.secondaryColor AS secondaryColor_55, t0.fixedAssetCode AS fixedAssetCode_56 FROM tenant t0 WHERE t0.idTenant = 1;
2	10.24 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

30.76 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.useQuote AS useQuote_30, t0.useAI AS useAI_31, t0.useAssetUrl AS useAssetUrl_32, t0.withoutPartnerVr AS withoutPartnerVr_33, t0.useMicrosoftAuth AS useMicrosoftAuth_34, t0.useGoogleAuth AS useGoogleAuth_35, t0.useAccounting AS useAccounting_36, t0.usePartnerDeals AS usePartnerDeals_37, t0.useContractLots AS useContractLots_38, t0.useProlong AS useProlong_39, t0.useElliPro AS useElliPro_40, t0.useCreditsafe AS useCreditsafe_41, t0.useEbicsExport AS useEbicsExport_42, t0.useEbicsImport AS useEbicsImport_43, t0.liOnScheduler AS liOnScheduler_44, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_45, t0.ibanOnClientSign AS ibanOnClientSign_46, t0.bankAccountRef AS bankAccountRef_47, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_48, t0.canManagePartnerFee AS canManagePartnerFee_49, t0.autoReject AS autoReject_50, t0.extraSignCheck AS extraSignCheck_51, t0.blockedSirens AS blockedSirens_52, t0.slug AS slug_53, t0.primaryColor AS primaryColor_54, t0.secondaryColor AS secondaryColor_55, t0.fixedAssetCode AS fixedAssetCode_56 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.useQuote AS useQuote_30,
  t0.useAI AS useAI_31,
  t0.useAssetUrl AS useAssetUrl_32,
  t0.withoutPartnerVr AS withoutPartnerVr_33,
  t0.useMicrosoftAuth AS useMicrosoftAuth_34,
  t0.useGoogleAuth AS useGoogleAuth_35,
  t0.useAccounting AS useAccounting_36,
  t0.usePartnerDeals AS usePartnerDeals_37,
  t0.useContractLots AS useContractLots_38,
  t0.useProlong AS useProlong_39,
  t0.useElliPro AS useElliPro_40,
  t0.useCreditsafe AS useCreditsafe_41,
  t0.useEbicsExport AS useEbicsExport_42,
  t0.useEbicsImport AS useEbicsImport_43,
  t0.liOnScheduler AS liOnScheduler_44,
  t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_45,
  t0.ibanOnClientSign AS ibanOnClientSign_46,
  t0.bankAccountRef AS bankAccountRef_47,
  t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_48,
  t0.canManagePartnerFee AS canManagePartnerFee_49,
  t0.autoReject AS autoReject_50,
  t0.extraSignCheck AS extraSignCheck_51,
  t0.blockedSirens AS blockedSirens_52,
  t0.slug AS slug_53,
  t0.primaryColor AS primaryColor_54,
  t0.secondaryColor AS secondaryColor_55,
  t0.fixedAssetCode AS fixedAssetCode_56
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.useQuote AS useQuote_30, t0.useAI AS useAI_31, t0.useAssetUrl AS useAssetUrl_32, t0.withoutPartnerVr AS withoutPartnerVr_33, t0.useMicrosoftAuth AS useMicrosoftAuth_34, t0.useGoogleAuth AS useGoogleAuth_35, t0.useAccounting AS useAccounting_36, t0.usePartnerDeals AS usePartnerDeals_37, t0.useContractLots AS useContractLots_38, t0.useProlong AS useProlong_39, t0.useElliPro AS useElliPro_40, t0.useCreditsafe AS useCreditsafe_41, t0.useEbicsExport AS useEbicsExport_42, t0.useEbicsImport AS useEbicsImport_43, t0.liOnScheduler AS liOnScheduler_44, t0.alwaysFunderAutoScoring AS alwaysFunderAutoScoring_45, t0.ibanOnClientSign AS ibanOnClientSign_46, t0.bankAccountRef AS bankAccountRef_47, t0.scoringMethodAutoAccept AS scoringMethodAutoAccept_48, t0.canManagePartnerFee AS canManagePartnerFee_49, t0.autoReject AS autoReject_50, t0.extraSignCheck AS extraSignCheck_51, t0.blockedSirens AS blockedSirens_52, t0.slug AS slug_53, t0.primaryColor AS primaryColor_54, t0.secondaryColor AS secondaryColor_55, t0.fixedAssetCode AS fixedAssetCode_56 FROM tenant t0 WHERE t0.idTenant = 1;

10.24 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.

Symfony Profiler

GET https://www.fiimatdev.fr/login

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