Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

2.21 ms Query time

1 Invalid entities

42 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.72 ms
(32.78%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.email_token AS email_token_8, t0.is_password_set AS is_password_set_9, t0.email_token_date AS email_token_date_10, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.email AS email_15, t11.phone AS phone_16, t11.user_id AS user_id_17, t11.function_id AS function_id_18, t11.address_id AS address_id_19, t0.default_btob_territory_id AS default_btob_territory_id_20, t0.default_btoc_territory_id AS default_btoc_territory_id_21, t0.login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  b"\x01žË9“À{©©±õ·\x12òõU"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.email_token AS email_token_8,
  t0.is_password_set AS is_password_set_9,
  t0.email_token_date AS email_token_date_10,
  t11.id AS id_12,
  t11.firstname AS firstname_13,
  t11.lastname AS lastname_14,
  t11.email AS email_15,
  t11.phone AS phone_16,
  t11.user_id AS user_id_17,
  t11.function_id AS function_id_18,
  t11.address_id AS address_id_19,
  t0.default_btob_territory_id AS default_btob_territory_id_20,
  t0.default_btoc_territory_id AS default_btoc_territory_id_21,
  t0.login_message_id AS login_message_id_22
FROM
  `user` t0
  LEFT JOIN profile t11 ON t11.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.email_token AS email_token_8, t0.is_password_set AS is_password_set_9, t0.email_token_date AS email_token_date_10, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.email AS email_15, t11.phone AS phone_16, t11.user_id AS user_id_17, t11.function_id AS function_id_18, t11.address_id AS address_id_19, t0.default_btob_territory_id AS default_btob_territory_id_20, t0.default_btoc_territory_id AS default_btoc_territory_id_21, t0.login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11.user_id = t0.id WHERE t0.id = 0x019ECB3993C07BA9A9B1F5B712F2F555;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.62 ms
(28.11%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.description AS description_3 FROM system_setting s0_ WHERE s0_.name = ?

Parameters:

[
  "api.gocad.username"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.value AS value_2,
  s0_.description AS description_3
FROM
  system_setting s0_
WHERE
  s0_.name = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.description AS description_3 FROM system_setting s0_ WHERE s0_.name = 'api.gocad.username';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Utils\gocad\Models\GocadSoapHelper->__construct (line 70)
7	ContainerCxxEtb5\getGocadSoapHelperService->do (line 29)
8	ContainerCxxEtb5\App_KernelDevDebugContainer::load (line 587)
9	ContainerCxxEtb5\getAuthenticatorService->do (line 36)
10	ContainerCxxEtb5\App_KernelDevDebugContainer::load (line 587)
11	ContainerCxxEtb5\getAuthenticator2Service->do (line 26)
12	ContainerCxxEtb5\App_KernelDevDebugContainer::load (line 587)
13	ContainerCxxEtb5\getSecurity_Authenticator_Manager_MainService->do (line 25)
14	ContainerCxxEtb5\App_KernelDevDebugContainer::load (line 587)
15	ContainerCxxEtb5\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
16	ContainerCxxEtb5\App_KernelDevDebugContainer::load (line 587)
17	ContainerCxxEtb5\getSecurity_Firewall_Map_Context_MainService->ContainerCxxEtb5\{closure} (line 39)
18	Symfony\Bundle\SecurityBundle\Security\FirewallContext::Symfony\Bundle\SecurityBundle\Debug\{closure} (line 60)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 70)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.53 ms
(23.84%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.social_reason AS social_reason_3, t0.enabled AS enabled_4, t0.iban AS iban_5, t0.bic AS bic_6, t0.bank_label AS bank_label_7, t0.sale_ref_id AS sale_ref_id_8, t0.type_id AS type_id_9, t0.address_id AS address_id_10 FROM billing_information t0 WHERE t0.sale_ref_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.social_reason AS social_reason_3,
  t0.enabled AS enabled_4,
  t0.iban AS iban_5,
  t0.bic AS bic_6,
  t0.bank_label AS bank_label_7,
  t0.sale_ref_id AS sale_ref_id_8,
  t0.type_id AS type_id_9,
  t0.address_id AS address_id_10
FROM
  billing_information t0
WHERE
  t0.sale_ref_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.social_reason AS social_reason_3, t0.enabled AS enabled_4, t0.iban AS iban_5, t0.bic AS bic_6, t0.bank_label AS bank_label_7, t0.sale_ref_id AS sale_ref_id_8, t0.type_id AS type_id_9, t0.address_id AS address_id_10 FROM billing_information t0 WHERE t0.sale_ref_id IN (2, 89, 90, 91, 92, 93, 94, 131, 143);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1037)
8	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
9	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
10	Doctrine\ORM\PersistentCollection->initialize (line 186)
11	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
12	App\Controller\AdministrationController->userSaleRef (line 993)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

0.34 ms
(15.28%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.social_reason AS social_reason_3, t0.commercial_name AS commercial_name_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.subscribed AS subscribed_8, t0.subscription AS subscription_9, t0.license_siv AS license_siv_10, t0.subscription_type AS subscription_type_11, t0.phone AS phone_12, t0.netsuite_id AS netsuite_id_13, t0.netsuite_periodicity AS netsuite_periodicity_14, t0.network_id AS network_id_15, t16.id AS id_17, t16.code AS code_18, t16.name AS name_19, t16.description AS description_20, t16.enabled AS enabled_21, t16.logo AS logo_22, t16.icon AS icon_23, t16.menu_logo AS menu_logo_24, t16.gocad_id AS gocad_id_25, t16.gocad_server_id AS gocad_server_id_26, t16.db_sources AS db_sources_27, t16.conditions_generales AS conditions_generales_28, t16.devis_payment_mode AS devis_payment_mode_29, t16.devis_legal_payment_mention AS devis_legal_payment_mention_30, t16.devis_bottom_page AS devis_bottom_page_31, t16.devis_logo AS devis_logo_32, t16.reduction AS reduction_33, t16.devis_code AS devis_code_34, t16.free_fiche AS free_fiche_35, t16.decimal_precision AS decimal_precision_36, t16.default_subscription_price_id AS default_subscription_price_id_37, t16.type_id AS type_id_38, t16.billing_information_id AS billing_information_id_39, t16.subscription_price_id AS subscription_price_id_40, t0.subscription_price_id AS subscription_price_id_41, t0.alternative_billing_information_id AS alternative_billing_information_id_42, t0.split_id AS split_id_43, t0.type_id AS type_id_44 FROM sale_ref t0 INNER JOIN network t16 ON t0.network_id = t16.id INNER JOIN user_sale_ref ON t0.id = user_sale_ref.sale_ref_id WHERE user_sale_ref.user_id = ?

Parameters:

[
  b"\x01žË?OŽsî¸à9Ãp·žV"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.social_reason AS social_reason_3,
  t0.commercial_name AS commercial_name_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.subscribed AS subscribed_8,
  t0.subscription AS subscription_9,
  t0.license_siv AS license_siv_10,
  t0.subscription_type AS subscription_type_11,
  t0.phone AS phone_12,
  t0.netsuite_id AS netsuite_id_13,
  t0.netsuite_periodicity AS netsuite_periodicity_14,
  t0.network_id AS network_id_15,
  t16.id AS id_17,
  t16.code AS code_18,
  t16.name AS name_19,
  t16.description AS description_20,
  t16.enabled AS enabled_21,
  t16.logo AS logo_22,
  t16.icon AS icon_23,
  t16.menu_logo AS menu_logo_24,
  t16.gocad_id AS gocad_id_25,
  t16.gocad_server_id AS gocad_server_id_26,
  t16.db_sources AS db_sources_27,
  t16.conditions_generales AS conditions_generales_28,
  t16.devis_payment_mode AS devis_payment_mode_29,
  t16.devis_legal_payment_mention AS devis_legal_payment_mention_30,
  t16.devis_bottom_page AS devis_bottom_page_31,
  t16.devis_logo AS devis_logo_32,
  t16.reduction AS reduction_33,
  t16.devis_code AS devis_code_34,
  t16.free_fiche AS free_fiche_35,
  t16.decimal_precision AS decimal_precision_36,
  t16.default_subscription_price_id AS default_subscription_price_id_37,
  t16.type_id AS type_id_38,
  t16.billing_information_id AS billing_information_id_39,
  t16.subscription_price_id AS subscription_price_id_40,
  t0.subscription_price_id AS subscription_price_id_41,
  t0.alternative_billing_information_id AS alternative_billing_information_id_42,
  t0.split_id AS split_id_43,
  t0.type_id AS type_id_44
FROM
  sale_ref t0
  INNER JOIN network t16 ON t0.network_id = t16.id
  INNER JOIN user_sale_ref ON t0.id = user_sale_ref.sale_ref_id
WHERE
  user_sale_ref.user_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.social_reason AS social_reason_3, t0.commercial_name AS commercial_name_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.subscribed AS subscribed_8, t0.subscription AS subscription_9, t0.license_siv AS license_siv_10, t0.subscription_type AS subscription_type_11, t0.phone AS phone_12, t0.netsuite_id AS netsuite_id_13, t0.netsuite_periodicity AS netsuite_periodicity_14, t0.network_id AS network_id_15, t16.id AS id_17, t16.code AS code_18, t16.name AS name_19, t16.description AS description_20, t16.enabled AS enabled_21, t16.logo AS logo_22, t16.icon AS icon_23, t16.menu_logo AS menu_logo_24, t16.gocad_id AS gocad_id_25, t16.gocad_server_id AS gocad_server_id_26, t16.db_sources AS db_sources_27, t16.conditions_generales AS conditions_generales_28, t16.devis_payment_mode AS devis_payment_mode_29, t16.devis_legal_payment_mention AS devis_legal_payment_mention_30, t16.devis_bottom_page AS devis_bottom_page_31, t16.devis_logo AS devis_logo_32, t16.reduction AS reduction_33, t16.devis_code AS devis_code_34, t16.free_fiche AS free_fiche_35, t16.decimal_precision AS decimal_precision_36, t16.default_subscription_price_id AS default_subscription_price_id_37, t16.type_id AS type_id_38, t16.billing_information_id AS billing_information_id_39, t16.subscription_price_id AS subscription_price_id_40, t0.subscription_price_id AS subscription_price_id_41, t0.alternative_billing_information_id AS alternative_billing_information_id_42, t0.split_id AS split_id_43, t0.type_id AS type_id_44 FROM sale_ref t0 INNER JOIN network t16 ON t0.network_id = t16.id INNER JOIN user_sale_ref ON t0.id = user_sale_ref.sale_ref_id WHERE user_sale_ref.user_id = 0x019ECB3F4F8E73EEB8E039C370B79E56;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Controller\AdministrationController->userSaleRef (line 993)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Address	10
App\Entity\BillingInformation	10
App\Entity\SaleRef	9
App\Entity\Referential	5
App\Entity\SystemSetting	2
App\Entity\User	2
App\Entity\Profile	2
App\Entity\Network	1
App\Entity\Price	1

Entities Mapping

Class	Mapping errors
App\Entity\SystemSetting	No errors.
App\Entity\User	The association App\Entity\User#loginMessage refers to the inverse side field App\Entity\LoginMessage#viewedUsers which does not exist.
App\Entity\Profile	No errors.
App\Entity\Referential	No errors.
App\Entity\RefProfileFunction	No errors.
App\Entity\Address	No errors.
App\Entity\Territory	No errors.
App\Entity\LoginMessage	No errors.
App\Entity\SaleRef	No errors.
App\Entity\UserConnections	No errors.
App\Entity\Network	No errors.
App\Entity\Price	No errors.
App\Entity\RefNetworkType	No errors.
App\Entity\BillingInformation	No errors.
App\Entity\RefMapType	No errors.
App\Entity\RefSaleRefType	No errors.
App\Entity\PriceGrid	No errors.
App\Entity\NetworkFixedFee	No errors.
App\Entity\RefBillingInformation	No errors.

Symfony Profiler

POST https://dev-requeteur.optindata.fr/admin/users/019ecb3f-4f8e-73ee-b8e0-39c370b79e56/saleRef?r=admin%2Fusers%2F019ecb3f-4f8e-73ee-b8e0-39c370b79e56%2FsaleRef

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping