Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

4.79 ms Query time

1 Invalid entities

38 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.62 ms
(33.80%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom_prenom AS nom_prenom_5, t0.created_at AS created_at_6, t0.is_enabled AS is_enabled_7, t0.zone AS zone_8, t0.last_activity_at AS last_activity_at_9, t0.total_commandes_value AS total_commandes_value_10, t0.total_stock_value AS total_stock_value_11, t0.paiement_left AS paiement_left_12, t0.has_device AS has_device_13, t0.is_admin AS is_admin_14, t0.phone_number AS phone_number_15, t0.last_livraison_at AS last_livraison_at_16, t0.code_collaborateur AS code_collaborateur_17, t0.last_update_at AS last_update_at_18, t0.adresse AS adresse_19, t0.total_commission AS total_commission_20, t0.total_survente AS total_survente_21, t0.initial_command_value AS initial_command_value_22, t0.category_name AS category_name_23, t0.utilisateur_role_id AS utilisateur_role_id_24 FROM utilisateur t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "CL01125"
]

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.nom_prenom AS nom_prenom_5,
  t0.created_at AS created_at_6,
  t0.is_enabled AS is_enabled_7,
  t0.zone AS zone_8,
  t0.last_activity_at AS last_activity_at_9,
  t0.total_commandes_value AS total_commandes_value_10,
  t0.total_stock_value AS total_stock_value_11,
  t0.paiement_left AS paiement_left_12,
  t0.has_device AS has_device_13,
  t0.is_admin AS is_admin_14,
  t0.phone_number AS phone_number_15,
  t0.last_livraison_at AS last_livraison_at_16,
  t0.code_collaborateur AS code_collaborateur_17,
  t0.last_update_at AS last_update_at_18,
  t0.adresse AS adresse_19,
  t0.total_commission AS total_commission_20,
  t0.total_survente AS total_survente_21,
  t0.initial_command_value AS initial_command_value_22,
  t0.category_name AS category_name_23,
  t0.utilisateur_role_id AS utilisateur_role_id_24
FROM
  utilisateur t0
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.nom_prenom AS nom_prenom_5, t0.created_at AS created_at_6, t0.is_enabled AS is_enabled_7, t0.zone AS zone_8, t0.last_activity_at AS last_activity_at_9, t0.total_commandes_value AS total_commandes_value_10, t0.total_stock_value AS total_stock_value_11, t0.paiement_left AS paiement_left_12, t0.has_device AS has_device_13, t0.is_admin AS is_admin_14, t0.phone_number AS phone_number_15, t0.last_livraison_at AS last_livraison_at_16, t0.code_collaborateur AS code_collaborateur_17, t0.last_update_at AS last_update_at_18, t0.adresse AS adresse_19, t0.total_commission AS total_commission_20, t0.total_survente AS total_survente_21, t0.initial_command_value AS initial_command_value_22, t0.category_name AS category_name_23, t0.utilisateur_role_id AS utilisateur_role_id_24 FROM utilisateur t0 WHERE t0.username = 'CL01125' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 101)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 149)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.30 ms
(27.20%)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.phone_number AS phone_number_2, p0_.created_at AS created_at_3, p0_.designation AS designation_4, p0_.description AS description_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.last_command_at AS last_command_at_8, p0_.update_at AS update_at_9, p0_.total_commandes_value AS total_commandes_value_10, ST_AsBinary(p0_.localisation) AS localisation_11, u1_.id AS id_12, u1_.username AS username_13, u1_.roles AS roles_14, u1_.password AS password_15, u1_.nom_prenom AS nom_prenom_16, u1_.created_at AS created_at_17, u1_.is_enabled AS is_enabled_18, u1_.zone AS zone_19, u1_.last_activity_at AS last_activity_at_20, u1_.total_commandes_value AS total_commandes_value_21, u1_.total_stock_value AS total_stock_value_22, u1_.paiement_left AS paiement_left_23, u1_.has_device AS has_device_24, u1_.is_admin AS is_admin_25, u1_.phone_number AS phone_number_26, u1_.last_livraison_at AS last_livraison_at_27, u1_.code_collaborateur AS code_collaborateur_28, u1_.last_update_at AS last_update_at_29, u1_.adresse AS adresse_30, u1_.total_commission AS total_commission_31, u1_.total_survente AS total_survente_32, u1_.initial_command_value AS initial_command_value_33, u1_.category_name AS category_name_34, p0_.created_by_id AS created_by_id_35, u1_.utilisateur_role_id AS utilisateur_role_id_36 FROM point_of_sale p0_ LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id WHERE p0_.update_at >= ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC

Parameters:

[
  "2025-09-10 00:00:00"
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.phone_number AS phone_number_2,
  p0_.created_at AS created_at_3,
  p0_.designation AS designation_4,
  p0_.description AS description_5,
  p0_.latitude AS latitude_6,
  p0_.longitude AS longitude_7,
  p0_.last_command_at AS last_command_at_8,
  p0_.update_at AS update_at_9,
  p0_.total_commandes_value AS total_commandes_value_10,
  ST_AsBinary(p0_.localisation) AS localisation_11,
  u1_.id AS id_12,
  u1_.username AS username_13,
  u1_.roles AS roles_14,
  u1_.password AS password_15,
  u1_.nom_prenom AS nom_prenom_16,
  u1_.created_at AS created_at_17,
  u1_.is_enabled AS is_enabled_18,
  u1_.zone AS zone_19,
  u1_.last_activity_at AS last_activity_at_20,
  u1_.total_commandes_value AS total_commandes_value_21,
  u1_.total_stock_value AS total_stock_value_22,
  u1_.paiement_left AS paiement_left_23,
  u1_.has_device AS has_device_24,
  u1_.is_admin AS is_admin_25,
  u1_.phone_number AS phone_number_26,
  u1_.last_livraison_at AS last_livraison_at_27,
  u1_.code_collaborateur AS code_collaborateur_28,
  u1_.last_update_at AS last_update_at_29,
  u1_.adresse AS adresse_30,
  u1_.total_commission AS total_commission_31,
  u1_.total_survente AS total_survente_32,
  u1_.initial_command_value AS initial_command_value_33,
  u1_.category_name AS category_name_34,
  p0_.created_by_id AS created_by_id_35,
  u1_.utilisateur_role_id AS utilisateur_role_id_36
FROM
  point_of_sale p0_
  LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id
  LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id
WHERE
  p0_.update_at >= ?
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.phone_number AS phone_number_2, p0_.created_at AS created_at_3, p0_.designation AS designation_4, p0_.description AS description_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.last_command_at AS last_command_at_8, p0_.update_at AS update_at_9, p0_.total_commandes_value AS total_commandes_value_10, ST_AsBinary(p0_.localisation) AS localisation_11, u1_.id AS id_12, u1_.username AS username_13, u1_.roles AS roles_14, u1_.password AS password_15, u1_.nom_prenom AS nom_prenom_16, u1_.created_at AS created_at_17, u1_.is_enabled AS is_enabled_18, u1_.zone AS zone_19, u1_.last_activity_at AS last_activity_at_20, u1_.total_commandes_value AS total_commandes_value_21, u1_.total_stock_value AS total_stock_value_22, u1_.paiement_left AS paiement_left_23, u1_.has_device AS has_device_24, u1_.is_admin AS is_admin_25, u1_.phone_number AS phone_number_26, u1_.last_livraison_at AS last_livraison_at_27, u1_.code_collaborateur AS code_collaborateur_28, u1_.last_update_at AS last_update_at_29, u1_.adresse AS adresse_30, u1_.total_commission AS total_commission_31, u1_.total_survente AS total_survente_32, u1_.initial_command_value AS initial_command_value_33, u1_.category_name AS category_name_34, p0_.created_by_id AS created_by_id_35, u1_.utilisateur_role_id AS utilisateur_role_id_36 FROM point_of_sale p0_ LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id WHERE p0_.update_at >= '2025-09-10 00:00:00' AND p0_.id IN (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32) ORDER BY p0_.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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 83)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.97 ms
(20.22%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.is_enabled AS is_enabled_4, t0.device_id AS device_id_5, t0.signal_id AS signal_id_6, t0.disable_at AS disable_at_7, t0.utilisateur_id AS utilisateur_id_8 FROM session t0 WHERE t0.utilisateur_id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.created_at AS created_at_3,
  t0.is_enabled AS is_enabled_4,
  t0.device_id AS device_id_5,
  t0.signal_id AS signal_id_6,
  t0.disable_at AS disable_at_7,
  t0.utilisateur_id AS utilisateur_id_8
FROM
  session t0
WHERE
  t0.utilisateur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.is_enabled AS is_enabled_4, t0.device_id AS device_id_5, t0.signal_id AS signal_id_6, t0.disable_at AS disable_at_7, t0.utilisateur_id AS utilisateur_id_8 FROM session t0 WHERE t0.utilisateur_id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 30)
8	App\Serializer\CommercialNormalizer->normalize (line 50)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
10	Symfony\Component\Serializer\Serializer->normalize (line 110)
11	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalizeRawCollection (line 81)
12	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
13	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
14	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 226)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 26)
18	App\Serializer\PointOfSaleNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
20	Symfony\Component\Serializer\Serializer->normalize (line 87)
21	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
22	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
23	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
24	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
25	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
26	Symfony\Component\Serializer\Serializer->normalize (line 131)
27	Symfony\Component\Serializer\Serializer->serialize (line 44)
28	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
29	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
30	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
31	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.50 ms
(10.50%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM point_of_sale p0_ LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id WHERE p0_.update_at >= ?

Parameters:

[
  "2025-09-10 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  point_of_sale p0_
  LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id
  LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id
WHERE
  p0_.update_at >= ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM point_of_sale p0_ LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id WHERE p0_.update_at >= '2025-09-10 00:00:00';

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 64)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 87)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.40 ms
(8.28%)

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM point_of_sale p0_ LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id WHERE p0_.update_at >= ? ORDER BY p0_.id ASC LIMIT 30

Parameters:

[
  "2025-09-10 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  point_of_sale p0_
  LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id
  LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id
WHERE
  p0_.update_at >= ?
ORDER BY
  p0_.id ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM point_of_sale p0_ LEFT JOIN point_of_sale_utilisateur p2_ ON p0_.id = p2_.point_of_sale_id LEFT JOIN utilisateur u1_ ON u1_.id = p2_.utilisateur_id WHERE p0_.update_at >= '2025-09-10 00:00:00' ORDER BY p0_.id ASC LIMIT 30;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 83)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\PointOfSale	30
App\Entity\Utilisateur	4
App\Entity\Session	3
App\Entity\UtilisateurRole	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\UtilisateurRole	No errors.
App\Entity\Session	No errors.
App\Entity\PointOfSale	No errors.
App\Entity\StockCommercial	No errors.
App\Entity\Livraison	No errors.
App\Entity\Commande	No errors.
App\Entity\MiscellaneousStock	No errors.
App\Entity\StockMouvement	No errors.
App\Entity\MiscellaneousMouvement	No errors.
App\Entity\Ajustement	No errors.
App\Entity\Retour	No errors.
App\Entity\Paiement	No errors.
App\Entity\TrackingDevice	No errors.
App\Entity\Zone	No errors.
App\Entity\ImportHistory	The mappings App\Entity\ImportHistory#createdBy and App\Entity\Utilisateur#importHistories are inconsistent with each other. If association App\Entity\ImportHistory#createdBy is many-to-one, then the inversed side App\Entity\Utilisateur#importHistories has to be one-to-many.
App\Entity\MiscellaneousLivraison	No errors.

Symfony Profiler

GET https://nutrizaza.dev/api/pos?page=1&updateAt%5Bafter%5D=2025-09-10%2000%3A00%3A00.000

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping