Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

3.25 ms Query time

1 Invalid entities

36 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.15 ms
(35.39%)

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:

[
  7
]

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 = 7;

#	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 825)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
12	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
14	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
15	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->normalize (line 87)
18	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
19	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
20	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
21	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
22	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
23	Symfony\Component\Serializer\Serializer->normalize (line 131)
24	Symfony\Component\Serializer\Serializer->serialize (line 44)
25	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
26	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
27	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
28	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.74 ms
(22.68%)

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.lot_number AS lot_number_2, s0_.created_at AS created_at_3, s0_.expire_at AS expire_at_4, s0_.quantite_disponible AS quantite_disponible_5, s0_.quantite_initial AS quantite_initial_6, u1_.id AS id_7, u1_.username AS username_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.nom_prenom AS nom_prenom_11, u1_.created_at AS created_at_12, u1_.is_enabled AS is_enabled_13, u1_.zone AS zone_14, u1_.last_activity_at AS last_activity_at_15, u1_.total_commandes_value AS total_commandes_value_16, u1_.total_stock_value AS total_stock_value_17, u1_.paiement_left AS paiement_left_18, u1_.has_device AS has_device_19, u1_.is_admin AS is_admin_20, u1_.phone_number AS phone_number_21, u1_.last_livraison_at AS last_livraison_at_22, u1_.code_collaborateur AS code_collaborateur_23, u1_.last_update_at AS last_update_at_24, u1_.adresse AS adresse_25, u1_.total_commission AS total_commission_26, u1_.total_survente AS total_survente_27, u1_.initial_command_value AS initial_command_value_28, u1_.category_name AS category_name_29, p2_.id AS id_30, p2_.code AS code_31, p2_.designation AS designation_32, p2_.description AS description_33, p2_.unit AS unit_34, p2_.price AS price_35, p2_.filename AS filename_36, p2_.color AS color_37, p2_.survente AS survente_38, p2_.is_enabled AS is_enabled_39, p2_.code_barre AS code_barre_40, p2_.price_ht AS price_ht_41, p2_.last_update_at AS last_update_at_42, s0_.commercial_id AS commercial_id_43, s0_.product_id AS product_id_44, u1_.utilisateur_role_id AS utilisateur_role_id_45 FROM stock_commercial s0_ INNER JOIN utilisateur u1_ ON s0_.commercial_id = u1_.id INNER JOIN product p2_ ON s0_.product_id = p2_.id ORDER BY s0_.id ASC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.lot_number AS lot_number_2,
  s0_.created_at AS created_at_3,
  s0_.expire_at AS expire_at_4,
  s0_.quantite_disponible AS quantite_disponible_5,
  s0_.quantite_initial AS quantite_initial_6,
  u1_.id AS id_7,
  u1_.username AS username_8,
  u1_.roles AS roles_9,
  u1_.password AS password_10,
  u1_.nom_prenom AS nom_prenom_11,
  u1_.created_at AS created_at_12,
  u1_.is_enabled AS is_enabled_13,
  u1_.zone AS zone_14,
  u1_.last_activity_at AS last_activity_at_15,
  u1_.total_commandes_value AS total_commandes_value_16,
  u1_.total_stock_value AS total_stock_value_17,
  u1_.paiement_left AS paiement_left_18,
  u1_.has_device AS has_device_19,
  u1_.is_admin AS is_admin_20,
  u1_.phone_number AS phone_number_21,
  u1_.last_livraison_at AS last_livraison_at_22,
  u1_.code_collaborateur AS code_collaborateur_23,
  u1_.last_update_at AS last_update_at_24,
  u1_.adresse AS adresse_25,
  u1_.total_commission AS total_commission_26,
  u1_.total_survente AS total_survente_27,
  u1_.initial_command_value AS initial_command_value_28,
  u1_.category_name AS category_name_29,
  p2_.id AS id_30,
  p2_.code AS code_31,
  p2_.designation AS designation_32,
  p2_.description AS description_33,
  p2_.unit AS unit_34,
  p2_.price AS price_35,
  p2_.filename AS filename_36,
  p2_.color AS color_37,
  p2_.survente AS survente_38,
  p2_.is_enabled AS is_enabled_39,
  p2_.code_barre AS code_barre_40,
  p2_.price_ht AS price_ht_41,
  p2_.last_update_at AS last_update_at_42,
  s0_.commercial_id AS commercial_id_43,
  s0_.product_id AS product_id_44,
  u1_.utilisateur_role_id AS utilisateur_role_id_45
FROM
  stock_commercial s0_
  INNER JOIN utilisateur u1_ ON s0_.commercial_id = u1_.id
  INNER JOIN product p2_ ON s0_.product_id = p2_.id
ORDER BY
  s0_.id ASC
LIMIT
  20

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.lot_number AS lot_number_2, s0_.created_at AS created_at_3, s0_.expire_at AS expire_at_4, s0_.quantite_disponible AS quantite_disponible_5, s0_.quantite_initial AS quantite_initial_6, u1_.id AS id_7, u1_.username AS username_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.nom_prenom AS nom_prenom_11, u1_.created_at AS created_at_12, u1_.is_enabled AS is_enabled_13, u1_.zone AS zone_14, u1_.last_activity_at AS last_activity_at_15, u1_.total_commandes_value AS total_commandes_value_16, u1_.total_stock_value AS total_stock_value_17, u1_.paiement_left AS paiement_left_18, u1_.has_device AS has_device_19, u1_.is_admin AS is_admin_20, u1_.phone_number AS phone_number_21, u1_.last_livraison_at AS last_livraison_at_22, u1_.code_collaborateur AS code_collaborateur_23, u1_.last_update_at AS last_update_at_24, u1_.adresse AS adresse_25, u1_.total_commission AS total_commission_26, u1_.total_survente AS total_survente_27, u1_.initial_command_value AS initial_command_value_28, u1_.category_name AS category_name_29, p2_.id AS id_30, p2_.code AS code_31, p2_.designation AS designation_32, p2_.description AS description_33, p2_.unit AS unit_34, p2_.price AS price_35, p2_.filename AS filename_36, p2_.color AS color_37, p2_.survente AS survente_38, p2_.is_enabled AS is_enabled_39, p2_.code_barre AS code_barre_40, p2_.price_ht AS price_ht_41, p2_.last_update_at AS last_update_at_42, s0_.commercial_id AS commercial_id_43, s0_.product_id AS product_id_44, u1_.utilisateur_role_id AS utilisateur_role_id_45 FROM stock_commercial s0_ INNER JOIN utilisateur u1_ ON s0_.commercial_id = u1_.id INNER JOIN product p2_ ON s0_.product_id = p2_.id ORDER BY s0_.id ASC LIMIT 20;

#	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 151)
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.70 ms
(21.57%)

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM stock_commercial s0_ INNER JOIN utilisateur u1_ ON s0_.commercial_id = u1_.id INNER JOIN product p2_ ON s0_.product_id = p2_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  stock_commercial s0_
  INNER JOIN utilisateur u1_ ON s0_.commercial_id = u1_.id
  INNER JOIN product p2_ ON s0_.product_id = p2_.id

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM stock_commercial s0_ INNER JOIN utilisateur u1_ ON s0_.commercial_id = u1_.id INNER JOIN product p2_ ON s0_.product_id = p2_.id;

#	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.66 ms
(20.37%)

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.id = ?

Parameters:

[
  1
]

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.id = ?

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.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\StockCommercial	20
App\Entity\Product	7
App\Entity\Utilisateur	4
App\Entity\Session	3
App\Entity\UtilisateurRole	2

Entities Mapping

Class	Mapping 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.
App\Entity\Product	No errors.

Symfony Profiler

GET https://nutrizaza.dev/api/data/stock-commercial?itemsPerPage=20&order%5BpercentDisponible%5D=desc&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping