Symfony Profiler

Query Metrics

13 Database Queries

10 Different statements

5.17 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.09 ms
(21.14%)

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 INNER JOIN user_sale_ref ON t0.id = user_sale_ref.user_id WHERE user_sale_ref.sale_ref_id = ?

Parameters:

[
  1987
]

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
  INNER JOIN user_sale_ref ON t0.id = user_sale_ref.user_id
WHERE
  user_sale_ref.sale_ref_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 INNER JOIN user_sale_ref ON t0.id = user_sale_ref.user_id WHERE user_sale_ref.sale_ref_id = 1987;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 70)
7	Doctrine\Common\Collections\AbstractLazyCollection->contains (line 361)
8	Doctrine\ORM\PersistentCollection->contains (line 120)
9	App\Security\Authenticator->App\Security\{closure} (line 45)
10	Symfony\Component\Security\Http\Authenticator\Passport\Credentials\CustomCredentials->executeCustomChecker (line 86)
11	Symfony\Component\Security\Http\EventListener\CheckCredentialsListener->checkPassport (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
22	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
23	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
24	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
25	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.90 ms
(17.38%)

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.social_reason AS social_reason_2, s0_.commercial_name AS commercial_name_3, s0_.enabled AS enabled_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.subscribed AS subscribed_7, s0_.subscription AS subscription_8, s0_.license_siv AS license_siv_9, s0_.subscription_type AS subscription_type_10, s0_.phone AS phone_11, s0_.netsuite_id AS netsuite_id_12, s0_.netsuite_periodicity AS netsuite_periodicity_13, s0_.network_id AS network_id_14, s0_.subscription_price_id AS subscription_price_id_15, s0_.alternative_billing_information_id AS alternative_billing_information_id_16, s0_.split_id AS split_id_17, s0_.type_id AS type_id_18 FROM sale_ref s0_ WHERE EXISTS (SELECT 1 FROM user_sale_ref u1_ WHERE u1_.sale_ref_id = s0_.id AND u1_.user_id IN (?)) ORDER BY s0_.id ASC

Parameters:

[
  b"\x01›sîOqošfV”ó°ž"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.social_reason AS social_reason_2,
  s0_.commercial_name AS commercial_name_3,
  s0_.enabled AS enabled_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.subscribed AS subscribed_7,
  s0_.subscription AS subscription_8,
  s0_.license_siv AS license_siv_9,
  s0_.subscription_type AS subscription_type_10,
  s0_.phone AS phone_11,
  s0_.netsuite_id AS netsuite_id_12,
  s0_.netsuite_periodicity AS netsuite_periodicity_13,
  s0_.network_id AS network_id_14,
  s0_.subscription_price_id AS subscription_price_id_15,
  s0_.alternative_billing_information_id AS alternative_billing_information_id_16,
  s0_.split_id AS split_id_17,
  s0_.type_id AS type_id_18
FROM
  sale_ref s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      user_sale_ref u1_
    WHERE
      u1_.sale_ref_id = s0_.id
      AND u1_.user_id IN (?)
  )
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.social_reason AS social_reason_2, s0_.commercial_name AS commercial_name_3, s0_.enabled AS enabled_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.subscribed AS subscribed_7, s0_.subscription AS subscription_8, s0_.license_siv AS license_siv_9, s0_.subscription_type AS subscription_type_10, s0_.phone AS phone_11, s0_.netsuite_id AS netsuite_id_12, s0_.netsuite_periodicity AS netsuite_periodicity_13, s0_.network_id AS network_id_14, s0_.subscription_price_id AS subscription_price_id_15, s0_.alternative_billing_information_id AS alternative_billing_information_id_16, s0_.split_id AS split_id_17, s0_.type_id AS type_id_18 FROM sale_ref s0_ WHERE EXISTS (SELECT 1 FROM user_sale_ref u1_ WHERE u1_.sale_ref_id = s0_.id AND u1_.user_id IN (0x019B73EEAD4F716F8F9A665694F3B09E)) ORDER BY s0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 30)
7	App\Repository\SaleRefRepository->findByUser (line 107)
8	App\Security\Authenticator->authenticate (line 74)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
16	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.85 ms
(16.36%)

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.username = ? LIMIT 1

Parameters:

[
  "CADON"
]

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.username = ?
LIMIT
  1

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.username = 'CADON' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 100)
5	App\Security\Authenticator->authenticate (line 74)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.68 ms
(13.07%)

INSERT INTO user_connections (date, user_id) VALUES (?, ?)

Parameters:

[
  "2026-04-16 10:14:14"
  b"\x01›sîOqošfV”ó°ž"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO user_connections (date, user_id)
VALUES
  (?, ?)

INSERT INTO user_connections (date, user_id) VALUES ('2026-04-16 10:14:14', 0x019B73EEAD4F716F8F9A665694F3B09E);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 131)
7	App\Security\Authenticator->authenticate (line 74)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.55 ms
(10.54%)

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

0.42 ms
(8.18%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.logo AS logo_6, t0.icon AS icon_7, t0.gocad_id AS gocad_id_8, t0.gocad_server_id AS gocad_server_id_9, t0.db_sources AS db_sources_10, t0.conditions_generales AS conditions_generales_11, t0.devis_payment_mode AS devis_payment_mode_12, t0.devis_legal_payment_mention AS devis_legal_payment_mention_13, t0.devis_bottom_page AS devis_bottom_page_14, t0.devis_logo AS devis_logo_15, t0.reduction AS reduction_16, t0.devis_code AS devis_code_17, t0.free_fiche AS free_fiche_18, t0.decimal_precision AS decimal_precision_19, t0.default_subscription_price_id AS default_subscription_price_id_20, t0.type_id AS type_id_21, t0.billing_information_id AS billing_information_id_22, t0.subscription_price_id AS subscription_price_id_23 FROM network t0 WHERE t0.id IN (?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.logo AS logo_6,
  t0.icon AS icon_7,
  t0.gocad_id AS gocad_id_8,
  t0.gocad_server_id AS gocad_server_id_9,
  t0.db_sources AS db_sources_10,
  t0.conditions_generales AS conditions_generales_11,
  t0.devis_payment_mode AS devis_payment_mode_12,
  t0.devis_legal_payment_mention AS devis_legal_payment_mention_13,
  t0.devis_bottom_page AS devis_bottom_page_14,
  t0.devis_logo AS devis_logo_15,
  t0.reduction AS reduction_16,
  t0.devis_code AS devis_code_17,
  t0.free_fiche AS free_fiche_18,
  t0.decimal_precision AS decimal_precision_19,
  t0.default_subscription_price_id AS default_subscription_price_id_20,
  t0.type_id AS type_id_21,
  t0.billing_information_id AS billing_information_id_22,
  t0.subscription_price_id AS subscription_price_id_23
FROM
  network t0
WHERE
  t0.id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.logo AS logo_6, t0.icon AS icon_7, t0.gocad_id AS gocad_id_8, t0.gocad_server_id AS gocad_server_id_9, t0.db_sources AS db_sources_10, t0.conditions_generales AS conditions_generales_11, t0.devis_payment_mode AS devis_payment_mode_12, t0.devis_legal_payment_mention AS devis_legal_payment_mention_13, t0.devis_bottom_page AS devis_bottom_page_14, t0.devis_logo AS devis_logo_15, t0.reduction AS reduction_16, t0.devis_code AS devis_code_17, t0.free_fiche AS free_fiche_18, t0.decimal_precision AS decimal_precision_19, t0.default_subscription_price_id AS default_subscription_price_id_20, t0.type_id AS type_id_21, t0.billing_information_id AS billing_information_id_22, t0.subscription_price_id AS subscription_price_id_23 FROM network t0 WHERE t0.id IN (9, 10, 11, 12, 17);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2620)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
7	Doctrine\ORM\AbstractQuery->execute (line 689)
8	Doctrine\ORM\AbstractQuery->getResult (line 30)
9	App\Repository\SaleRefRepository->findByUser (line 107)
10	App\Security\Authenticator->authenticate (line 74)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.30 ms
(5.78%)

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 (1987, 2188, 2242, 2362, 2372, 2373, 2527, 2536, 2856, 2863);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2654)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2630)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 168)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 940)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2620)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
11	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
12	Doctrine\ORM\AbstractQuery->execute (line 689)
13	Doctrine\ORM\AbstractQuery->getResult (line 30)
14	App\Repository\SaleRefRepository->findByUser (line 107)
15	App\Security\Authenticator->authenticate (line 74)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
20	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
21	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
22	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
23	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
24	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
25	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
26	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.20 ms
(3.90%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM system_setting t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "api.map.clientId"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.description AS description_4
FROM
  system_setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM system_setting t0 WHERE t0.name = 'api.map.clientId' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 151)
5	App\Security\Authenticator->geoptisTokenMap (line 184)
6	App\Security\Authenticator->onAuthenticationSuccess (line 91)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 244)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 230)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.12 ms
(2.34%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 131)
5	App\Security\Authenticator->authenticate (line 74)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.07 ms
(1.31%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 131)
4	App\Security\Authenticator->authenticate (line 74)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 185)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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.

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\BillingInformation	No errors.
App\Entity\RefMapType	No errors.
App\Entity\RefSaleRefType	No errors.
App\Entity\RefNetworkType	No errors.
App\Entity\PriceGrid	No errors.
App\Entity\RefBillingInformation	No errors.

Symfony Profiler

POST https://v2-dev-requeteur.optindata.fr/security/login?r=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping