Symfony Profiler

Query Metrics

15 Database Queries

5 Different statements

5.47 ms Query time

0 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.37 ms
(25.06%)

SELECT l0_.id AS id_0, l0_.nom_produit AS nom_produit_1, l0_.qte AS qte_2, l0_.prix AS prix_3, l0_.ordonance AS ordonance_4, l0_.ordre AS ordre_5, l0_.created_at AS created_at_6, l0_.deleted_at AS deleted_at_7, l0_.status AS status_8, l0_.choix AS choix_9, l0_.id_demande_id AS id_demande_id_10 FROM ligne_demande l0_ WHERE l0_.status = 1 AND (l0_.created_at BETWEEN ? AND ?) AND (l0_.id NOT IN (SELECT r1_.id_demande_id AS sclr_11 FROM reponse_demande r1_ WHERE r1_.id_pharmacie_id = ? AND r1_.status = 1)) ORDER BY l0_.id DESC

Parameters:

[
  "2026-08-12 16:07:20"
  "2026-08-13 16:07:20"
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.nom_produit AS nom_produit_1,
  l0_.qte AS qte_2,
  l0_.prix AS prix_3,
  l0_.ordonance AS ordonance_4,
  l0_.ordre AS ordre_5,
  l0_.created_at AS created_at_6,
  l0_.deleted_at AS deleted_at_7,
  l0_.status AS status_8,
  l0_.choix AS choix_9,
  l0_.id_demande_id AS id_demande_id_10
FROM
  ligne_demande l0_
WHERE
  l0_.status = 1
  AND (
    l0_.created_at BETWEEN ?
    AND ?
  )
  AND (
    l0_.id NOT IN (
      SELECT
        r1_.id_demande_id AS sclr_11
      FROM
        reponse_demande r1_
      WHERE
        r1_.id_pharmacie_id = ?
        AND r1_.status = 1
    )
  )
ORDER BY
  l0_.id DESC

SELECT l0_.id AS id_0, l0_.nom_produit AS nom_produit_1, l0_.qte AS qte_2, l0_.prix AS prix_3, l0_.ordonance AS ordonance_4, l0_.ordre AS ordre_5, l0_.created_at AS created_at_6, l0_.deleted_at AS deleted_at_7, l0_.status AS status_8, l0_.choix AS choix_9, l0_.id_demande_id AS id_demande_id_10 FROM ligne_demande l0_ WHERE l0_.status = 1 AND (l0_.created_at BETWEEN '2026-08-12 16:07:20' AND '2026-08-13 16:07:20') AND (l0_.id NOT IN (SELECT r1_.id_demande_id AS sclr_11 FROM reponse_demande r1_ WHERE r1_.id_pharmacie_id = 13 AND r1_.status = 1)) ORDER BY l0_.id DESC;

#	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 61)
7	App\Repository\LigneDemandeRepository->findListeDemandePharmacieBy (line 67)
8	App\Controller\ConfigController->liste_commandepharmacie (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.11 ms
(20.36%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.adresse AS adresse_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.frais_livraison AS frais_livraison_6, t0.created_at AS created_at_7, t0.deleted_at AS deleted_at_8, t0.status AS status_9, t0.ordre AS ordre_10, t0.ville AS ville_11, t0.livraison AS livraison_12, t0.id_status_id AS id_status_id_13, t0.id_client_id AS id_client_id_14 FROM demande_produit t0 WHERE t0.id = ?

Parameters:

[
  726
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.adresse AS adresse_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5,
  t0.frais_livraison AS frais_livraison_6,
  t0.created_at AS created_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.status AS status_9,
  t0.ordre AS ordre_10,
  t0.ville AS ville_11,
  t0.livraison AS livraison_12,
  t0.id_status_id AS id_status_id_13,
  t0.id_client_id AS id_client_id_14
FROM
  demande_produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.adresse AS adresse_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.frais_livraison AS frais_livraison_6, t0.created_at AS created_at_7, t0.deleted_at AS deleted_at_8, t0.status AS status_9, t0.ordre AS ordre_10, t0.ville AS ville_11, t0.livraison AS livraison_12, t0.id_status_id AS id_status_id_13, t0.id_client_id AS id_client_id_14 FROM demande_produit t0 WHERE t0.id = 726;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\DemandeProduit::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\DemandeProduit->__get (line 95)
8	App\Entity\DemandeProduit->getIdClient (line 91)
9	App\Controller\ConfigController->liste_commandepharmacie (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.01 ms
(18.37%)

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commentaire AS commentaire_3, t0.disponible AS disponible_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_pharmacie_id AS id_pharmacie_id_8, t0.id_user_id AS id_user_id_9, t0.id_demande_id AS id_demande_id_10 FROM reponse_demande t0 WHERE t0.id_demande_id = ? LIMIT 1

Parameters:

[
  789
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.commentaire AS commentaire_3,
  t0.disponible AS disponible_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.status AS status_7,
  t0.id_pharmacie_id AS id_pharmacie_id_8,
  t0.id_user_id AS id_user_id_9,
  t0.id_demande_id AS id_demande_id_10
FROM
  reponse_demande t0
WHERE
  t0.id_demande_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commentaire AS commentaire_3, t0.disponible AS disponible_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_pharmacie_id AS id_pharmacie_id_8, t0.id_user_id AS id_user_id_9, t0.id_demande_id AS id_demande_id_10 FROM reponse_demande t0 WHERE t0.id_demande_id = 789 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 78)
5	App\Controller\ConfigController->liste_commandepharmacie (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.00 ms
(18.21%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.password_default AS password_default_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.one_connexion AS one_connexion_10, t0.roles AS roles_11, t0.fcm_token AS fcm_token_12, t0.id_statut_id AS id_statut_id_13, t0.id_restaurant_id AS id_restaurant_id_14, t0.id_pharmacie_id AS id_pharmacie_id_15 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "citecaisse@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.password AS password_6,
  t0.password_default AS password_default_7,
  t0.created_at AS created_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.one_connexion AS one_connexion_10,
  t0.roles AS roles_11,
  t0.fcm_token AS fcm_token_12,
  t0.id_statut_id AS id_statut_id_13,
  t0.id_restaurant_id AS id_restaurant_id_14,
  t0.id_pharmacie_id AS id_pharmacie_id_15
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.password_default AS password_default_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.one_connexion AS one_connexion_10, t0.roles AS roles_11, t0.fcm_token AS fcm_token_12, t0.id_statut_id AS id_statut_id_13, t0.id_restaurant_id AS id_restaurant_id_14, t0.id_pharmacie_id AS id_pharmacie_id_15 FROM `user` t0 WHERE t0.email = 'citecaisse@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
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 196)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
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 83)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.99 ms
(18.00%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.roles AS roles_7, t0.created_at AS created_at_8, t0.deteled_at AS deteled_at_9, t0.status AS status_10, t0.fcm_token AS fcm_token_11 FROM client t0 WHERE t0.id = ?

Parameters:

[
  1348
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.password AS password_6,
  t0.roles AS roles_7,
  t0.created_at AS created_at_8,
  t0.deteled_at AS deteled_at_9,
  t0.status AS status_10,
  t0.fcm_token AS fcm_token_11
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.roles AS roles_7, t0.created_at AS created_at_8, t0.deteled_at AS deteled_at_9, t0.status AS status_10, t0.fcm_token AS fcm_token_11 FROM client t0 WHERE t0.id = 1348;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Client::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Client->__get (line 67)
8	App\Entity\Client->getLastName (line 91)
9	App\Controller\ConfigController->liste_commandepharmacie (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\LigneDemande	4
App\Entity\DemandeProduit	4
App\Entity\ReponseDemande	4
App\Entity\Client	4
App\Entity\User	2
App\Entity\Pharmacie	2
App\Entity\StatusUser	1
App\Entity\StatusCommande	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\StatusUser	No errors.
App\Entity\Restaurant	No errors.
App\Entity\Pharmacie	No errors.
App\Entity\LigneDemande	No errors.
App\Entity\ReponseDemande	No errors.
App\Entity\DemandeProduit	No errors.
App\Entity\StatusCommande	No errors.
App\Entity\Client	No errors.

Symfony Profiler

POST http://webhook-food.esn-niger.com/api/config/listeDemande/pharmacie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping