Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.95 ms Query time

1 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.36 ms

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)

0.32 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.is_admin AS is_admin_4 FROM utilisateur_role t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.is_admin AS is_admin_4
FROM
  utilisateur_role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.is_admin AS is_admin_4 FROM utilisateur_role 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 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\Entity\UtilisateurRole::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\UtilisateurRole->__get (line 71)
8	App\Entity\UtilisateurRole->getCode (line 406)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 780)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 226)
16	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 25)
17	App\Serializer\CommercialNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->normalize (line 131)
20	Symfony\Component\Serializer\Serializer->serialize (line 44)
21	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 33)
22	App\Controller\Data\AdminController->myInfo (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.28 ms

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:

[
  1
]

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

#	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 131)
11	Symfony\Component\Serializer\Serializer->serialize (line 44)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 33)
13	App\Controller\Data\AdminController->myInfo (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\Utilisateur	1
App\Entity\UtilisateurRole	1

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.

Symfony Profiler

GET https://nutrizaza.dev/api/data/admin/my-info

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping