Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.85 ms Query time

1 Invalid entities

25 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.70 ms
(37.76%)

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:

[
  "CCL00631"
]

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 = 'CCL00631' 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)

0.61 ms
(33.01%)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.designation AS designation_2, p0_.description AS description_3, p0_.unit AS unit_4, p0_.price AS price_5, p0_.filename AS filename_6, p0_.color AS color_7, p0_.survente AS survente_8, p0_.is_enabled AS is_enabled_9, p0_.code_barre AS code_barre_10, p0_.price_ht AS price_ht_11, p0_.last_update_at AS last_update_at_12 FROM product p0_ ORDER BY p0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.designation AS designation_2,
  p0_.description AS description_3,
  p0_.unit AS unit_4,
  p0_.price AS price_5,
  p0_.filename AS filename_6,
  p0_.color AS color_7,
  p0_.survente AS survente_8,
  p0_.is_enabled AS is_enabled_9,
  p0_.code_barre AS code_barre_10,
  p0_.price_ht AS price_ht_11,
  p0_.last_update_at AS last_update_at_12
FROM
  product p0_
ORDER BY
  p0_.id ASC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.designation AS designation_2, p0_.description AS description_3, p0_.unit AS unit_4, p0_.price AS price_5, p0_.filename AS filename_6, p0_.color AS color_7, p0_.survente AS survente_8, p0_.is_enabled AS is_enabled_9, p0_.code_barre AS code_barre_10, p0_.price_ht AS price_ht_11, p0_.last_update_at AS last_update_at_12 FROM product p0_ 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 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.54 ms
(29.23%)

SELECT count(*) AS sclr_0 FROM product p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  product p0_

SELECT count(*) AS sclr_0 FROM product p0_;

#	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)

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\Product	23
App\Entity\Utilisateur	1
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.
App\Entity\Product	No errors.

Symfony Profiler

GET https://nutrizaza.dev/api/products

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping