Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.82 ms Query time

0 Invalid entities

Time▼

Count

Info

2.82 ms
(100.00%)

SELECT COUNT(*) FROM utilisateur_notification t0 WHERE t0.utilisateur_id IS NULL AND t0.lu = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  utilisateur_notification t0
WHERE
  t0.utilisateur_id IS NULL
  AND t0.lu = ?

SELECT COUNT(*) FROM utilisateur_notification t0 WHERE t0.utilisateur_id IS NULL AND t0.lu = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 906)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 255)
3	Doctrine\ORM\EntityRepository->count (line 154)
4	App\EventSubscriber\Common\Kernel\KernelSubscriber->setMenuGauche (line 111)
5	App\EventSubscriber\Common\Kernel\KernelSubscriber->onKernelController (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
10	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection
batch	doctrine.dbal.batch_connection
sittibase	doctrine.dbal.sittibase_connection
importcache	doctrine.dbal.importcache_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\RH\Paie\RHCondition	No errors.
App\Entity\Prestation\Service\PrestationService	No errors.
App\Entity\Client\Client	No errors.
App\Entity\Prestation\Prestation	No errors.
App\Entity\Prestation\Alerte\PrestationAlerte	No errors.
App\Entity\Prestation\PrestationVersion	No errors.
App\Entity\Client\ClientOnglet	No errors.
App\Entity\Security\Utilisateur\UtilisateurNotification	No errors.
App\Entity\Security\Droit\ListeDroitProfil	No errors.
App\Entity\Security\Droit\ListeDroitCategorie	No errors.
App\Entity\Security\Droit\ListeDroit	No errors.
App\Entity\Security\Utilisateur\Utilisateur	No errors.