Symfony Profiler

Query Metrics

127 Database Queries

4 Different statements

36.86 ms Query time

1 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.23 ms
(38.59%)

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 200)
5	App\Service\Livraison\LivraisonImportServices->checkCommercialExistence (line 55)
6	App\Service\Livraison\LivraisonImportServices->checkExistence (line 31)
7	App\Controller\Data\LivraisonController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

11.64 ms
(31.58%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.description AS description_4, t0.unit AS unit_5, t0.price AS price_6, t0.filename AS filename_7, t0.color AS color_8, t0.survente AS survente_9, t0.is_enabled AS is_enabled_10, t0.code_barre AS code_barre_11, t0.price_ht AS price_ht_12, t0.last_update_at AS last_update_at_13 FROM product t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "KB08"
]

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.description AS description_4,
  t0.unit AS unit_5,
  t0.price AS price_6,
  t0.filename AS filename_7,
  t0.color AS color_8,
  t0.survente AS survente_9,
  t0.is_enabled AS is_enabled_10,
  t0.code_barre AS code_barre_11,
  t0.price_ht AS price_ht_12,
  t0.last_update_at AS last_update_at_13
FROM
  product t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.description AS description_4, t0.unit AS unit_5, t0.price AS price_6, t0.filename AS filename_7, t0.color AS color_8, t0.survente AS survente_9, t0.is_enabled AS is_enabled_10, t0.code_barre AS code_barre_11, t0.price_ht AS price_ht_12, t0.last_update_at AS last_update_at_13 FROM product t0 WHERE t0.code = 'KB08' 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 210)
5	App\Service\Livraison\LivraisonImportServices->checkProductExistence (line 56)
6	App\Service\Livraison\LivraisonImportServices->checkExistence (line 31)
7	App\Controller\Data\LivraisonController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

10.39 ms
(28.18%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.facture_ref AS facture_ref_3, t0.created_at AS created_at_4, t0.total_value AS total_value_5, t0.livraison_at AS livraison_at_6, t0.commercial_id AS commercial_id_7 FROM livraison t0 WHERE t0.facture_ref = ? LIMIT 1

Parameters:

[
  "BL202501"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.facture_ref AS facture_ref_3,
  t0.created_at AS created_at_4,
  t0.total_value AS total_value_5,
  t0.livraison_at AS livraison_at_6,
  t0.commercial_id AS commercial_id_7
FROM
  livraison t0
WHERE
  t0.facture_ref = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.facture_ref AS facture_ref_3, t0.created_at AS created_at_4, t0.total_value AS total_value_5, t0.livraison_at AS livraison_at_6, t0.commercial_id AS commercial_id_7 FROM livraison t0 WHERE t0.facture_ref = 'BL202501' 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 192)
5	App\Service\Livraison\LivraisonImportServices->checkLivraisonExistence (line 54)
6	App\Service\Livraison\LivraisonImportServices->checkExistence (line 31)
7	App\Controller\Data\LivraisonController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.61 ms
(1.65%)

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 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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	7
App\Entity\Product	7
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.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Product	No errors.

Symfony Profiler

POST https://nutrizaza.dev/api/data/livraisons/check/existence

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping