Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

1.93 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.83 ms
(43.01%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM user t0 WHERE t0.id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM user t0 WHERE t0.id = 15;

#	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 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 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 347)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 28)
15	App\Controller\AssociationController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.29 ms
(14.74%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ?

Parameters:

[
  "%DIOURBEL%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%';

#	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 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerPB1L61g\PaginatorProxyBa079e5->paginate (line 77)
16	App\Controller\AssociationController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.24 ms
(12.35%)

SELECT a0_.id AS id_0, a0_.recipisse AS recipisse_1, a0_.date_signature AS date_signature_2, a0_.denomination AS denomination_3, a0_.sigle AS sigle_4, a0_.adresse AS adresse_5, a0_.geolocalisation AS geolocalisation_6, a0_.nom_president AS nom_president_7, a0_.nom_secretaire AS nom_secretaire_8, a0_.telephone_secretaire AS telephone_secretaire_9, a0_.nom_tresorier AS nom_tresorier_10, a0_.telephone_tresorier AS telephone_tresorier_11, a0_.fichier_recipisse AS fichier_recipisse_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.objet AS objet_15, a0_.telephone_president AS telephone_president_16, a0_.is_file_detected AS is_file_detected_17, a0_.latitude AS latitude_18, a0_.longitude AS longitude_19, a0_.departement_id AS departement_id_20 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.date_signature DESC

Parameters:

[
  "%DIOURBEL%"
  351
  381
  382
  372
  373
  374
  375
  376
  369
  370
  366
  367
  362
  363
  352
  353
  350
  342
  498
  499
  500
  501
  497
  493
  494
  492
  484
  485
  486
  487
  488
  489
  490
  491
  472
  473
  474
  475
  476
  462
  461
  460
  458
  459
  456
  457
  454
  455
  447
  448
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.recipisse AS recipisse_1,
  a0_.date_signature AS date_signature_2,
  a0_.denomination AS denomination_3,
  a0_.sigle AS sigle_4,
  a0_.adresse AS adresse_5,
  a0_.geolocalisation AS geolocalisation_6,
  a0_.nom_president AS nom_president_7,
  a0_.nom_secretaire AS nom_secretaire_8,
  a0_.telephone_secretaire AS telephone_secretaire_9,
  a0_.nom_tresorier AS nom_tresorier_10,
  a0_.telephone_tresorier AS telephone_tresorier_11,
  a0_.fichier_recipisse AS fichier_recipisse_12,
  a0_.created_at AS created_at_13,
  a0_.updated_at AS updated_at_14,
  a0_.objet AS objet_15,
  a0_.telephone_president AS telephone_president_16,
  a0_.is_file_detected AS is_file_detected_17,
  a0_.latitude AS latitude_18,
  a0_.longitude AS longitude_19,
  a0_.departement_id AS departement_id_20
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  a0_.date_signature DESC

SELECT a0_.id AS id_0, a0_.recipisse AS recipisse_1, a0_.date_signature AS date_signature_2, a0_.denomination AS denomination_3, a0_.sigle AS sigle_4, a0_.adresse AS adresse_5, a0_.geolocalisation AS geolocalisation_6, a0_.nom_president AS nom_president_7, a0_.nom_secretaire AS nom_secretaire_8, a0_.telephone_secretaire AS telephone_secretaire_9, a0_.nom_tresorier AS nom_tresorier_10, a0_.telephone_tresorier AS telephone_tresorier_11, a0_.fichier_recipisse AS fichier_recipisse_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.objet AS objet_15, a0_.telephone_president AS telephone_president_16, a0_.is_file_detected AS is_file_detected_17, a0_.latitude AS latitude_18, a0_.longitude AS longitude_19, a0_.departement_id AS departement_id_20 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%' AND a0_.id IN (351, 381, 382, 372, 373, 374, 375, 376, 369, 370, 366, 367, 362, 363, 352, 353, 350, 342, 498, 499, 500, 501, 497, 493, 494, 492, 484, 485, 486, 487, 488, 489, 490, 491, 472, 473, 474, 475, 476, 462, 461, 460, 458, 459, 456, 457, 454, 455, 447, 448) ORDER BY a0_.date_signature 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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerPB1L61g\PaginatorProxyBa079e5->paginate (line 77)
16	App\Controller\AssociationController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.21 ms
(10.71%)

SELECT t0.id AS id_1, t0.nom_departement AS nom_departement_2 FROM departement t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_departement AS nom_departement_2
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_departement AS nom_departement_2 FROM departement t0 WHERE t0.id = 1;

#	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\Departement::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Departement->__get (line 39)
8	App\Entity\Departement->getNomDepartement (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 256)
10	__TwigTemplate_8002207a9ec69de3da6f51cba3dfdd1f->block_body (line 432)
11	Twig\Template->yieldBlock (line 302)
12	__TwigTemplate_ecdf506e1b9098cd402cfcd44bde6e5e->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_8002207a9ec69de3da6f51cba3dfdd1f->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 121)
23	App\Controller\AssociationController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.19 ms
(9.77%)

SELECT DISTINCT a0_.id AS id_0, a0_.date_signature AS date_signature_1 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ? ORDER BY a0_.date_signature DESC LIMIT 50

Parameters:

[
  "%DIOURBEL%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.date_signature AS date_signature_1
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?
ORDER BY
  a0_.date_signature DESC
LIMIT
  50

SELECT DISTINCT a0_.id AS id_0, a0_.date_signature AS date_signature_1 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%' ORDER BY a0_.date_signature DESC LIMIT 50;

#	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 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerPB1L61g\PaginatorProxyBa079e5->paginate (line 77)
16	App\Controller\AssociationController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.18 ms
(9.42%)

SELECT COUNT(a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ?

Parameters:

[
  "%DIOURBEL%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?

SELECT COUNT(a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%';

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 119)
8	App\Controller\AssociationController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Association	No errors.
App\Entity\Departement	No errors.

Symfony Profiler

GET https://gouv-diourbel.demarch.net/association?departement=DIOURBEL

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping