Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

6.20 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.99 ms
(32.14%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.position AS position_4, t0.nb AS nb_5, t0.affiche AS affiche_6, t0.affiche_nom AS affiche_nom_7, t0.affiche_logo AS affiche_logo_8, t0.deleted AS deleted_9, t0.societe_id AS societe_id_10 FROM niveau_mecenat t0 WHERE t0.societe_id IS NULL AND t0.deleted = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.nom AS nom_3,
  t0.position AS position_4,
  t0.nb AS nb_5,
  t0.affiche AS affiche_6,
  t0.affiche_nom AS affiche_nom_7,
  t0.affiche_logo AS affiche_logo_8,
  t0.deleted AS deleted_9,
  t0.societe_id AS societe_id_10
FROM
  niveau_mecenat t0
WHERE
  t0.societe_id IS NULL
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.position AS position_4, t0.nb AS nb_5, t0.affiche AS affiche_6, t0.affiche_nom AS affiche_nom_7, t0.affiche_logo AS affiche_logo_8, t0.deleted AS deleted_9, t0.societe_id AS societe_id_10 FROM niveau_mecenat t0 WHERE t0.societe_id IS NULL AND t0.deleted = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 49)
5	App\EventSubscriber\GlobalContextSubscriber->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 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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)

0.88 ms
(14.18%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.espace_id AS espace_id_4 FROM parametre_espace t0 WHERE t0.espace_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.valeur AS valeur_3,
  t0.espace_id AS espace_id_4
FROM
  parametre_espace t0
WHERE
  t0.espace_id IS NULL

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.espace_id AS espace_id_4 FROM parametre_espace t0 WHERE t0.espace_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 88)
5	App\Service\InfoServices->getInfo (line 73)
6	App\Twig\GlobalVariableExtension->getGlobals (line 332)
7	Twig\ExtensionSet->getGlobals (line 824)
8	Twig\Environment->getGlobals (line 389)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
17	App\Controller\LoginController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.88 ms
(14.16%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.deleted AS deleted_6, t0.societe_id AS societe_id_7 FROM type_mecenat t0 WHERE t0.societe_id IS NULL AND t0.deleted = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.nom AS nom_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.deleted AS deleted_6,
  t0.societe_id AS societe_id_7
FROM
  type_mecenat t0
WHERE
  t0.societe_id IS NULL
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.deleted AS deleted_6, t0.societe_id AS societe_id_7 FROM type_mecenat t0 WHERE t0.societe_id IS NULL AND t0.deleted = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 50)
5	App\EventSubscriber\GlobalContextSubscriber->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 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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)

0.87 ms
(13.97%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.type AS type_3, t0.nom AS nom_4, t0.valeur AS valeur_5, t0.deduction_fiscale AS deduction_fiscale_6, t0.description AS description_7, t0.personnalise AS personnalise_8, t0.created_at AS created_at_9, t0.deleted AS deleted_10, t0.societe_id AS societe_id_11, t0.projet_id AS projet_id_12, t0.niveau_id AS niveau_id_13 FROM formule t0 WHERE t0.societe_id IS NULL AND t0.deleted = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.type AS type_3,
  t0.nom AS nom_4,
  t0.valeur AS valeur_5,
  t0.deduction_fiscale AS deduction_fiscale_6,
  t0.description AS description_7,
  t0.personnalise AS personnalise_8,
  t0.created_at AS created_at_9,
  t0.deleted AS deleted_10,
  t0.societe_id AS societe_id_11,
  t0.projet_id AS projet_id_12,
  t0.niveau_id AS niveau_id_13
FROM
  formule t0
WHERE
  t0.societe_id IS NULL
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.type AS type_3, t0.nom AS nom_4, t0.valeur AS valeur_5, t0.deduction_fiscale AS deduction_fiscale_6, t0.description AS description_7, t0.personnalise AS personnalise_8, t0.created_at AS created_at_9, t0.deleted AS deleted_10, t0.societe_id AS societe_id_11, t0.projet_id AS projet_id_12, t0.niveau_id AS niveau_id_13 FROM formule t0 WHERE t0.societe_id IS NULL AND t0.deleted = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 53)
5	App\EventSubscriber\GlobalContextSubscriber->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 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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)

0.81 ms
(13.10%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.deleted AS deleted_4, t0.societe_id AS societe_id_5, t0.projet_id AS projet_id_6 FROM type_contrepartie t0 WHERE t0.societe_id IS NULL AND t0.deleted = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.nom AS nom_3,
  t0.deleted AS deleted_4,
  t0.societe_id AS societe_id_5,
  t0.projet_id AS projet_id_6
FROM
  type_contrepartie t0
WHERE
  t0.societe_id IS NULL
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.deleted AS deleted_4, t0.societe_id AS societe_id_5, t0.projet_id AS projet_id_6 FROM type_contrepartie t0 WHERE t0.societe_id IS NULL AND t0.deleted = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 52)
5	App\EventSubscriber\GlobalContextSubscriber->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 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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)

0.77 ms
(12.44%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.deleted AS deleted_4, t0.couleur AS couleur_5, t0.societe_id AS societe_id_6 FROM source t0 WHERE t0.societe_id IS NULL AND t0.deleted = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.nom AS nom_3,
  t0.deleted AS deleted_4,
  t0.couleur AS couleur_5,
  t0.societe_id AS societe_id_6
FROM
  source t0
WHERE
  t0.societe_id IS NULL
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.deleted AS deleted_4, t0.couleur AS couleur_5, t0.societe_id AS societe_id_6 FROM source t0 WHERE t0.societe_id IS NULL AND t0.deleted = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 128)
5	App\Service\InfoServices->getInfo (line 73)
6	App\Twig\GlobalVariableExtension->getGlobals (line 332)
7	Twig\ExtensionSet->getGlobals (line 824)
8	Twig\Environment->getGlobals (line 389)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
17	App\Controller\LoginController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Bundle\ProjetBundle\Entity\NiveauMecenat	No errors.
App\Bundle\AdminBundle\Entity\Societe	No errors.
App\Bundle\ProjetBundle\Entity\TypeMecenat	No errors.
App\Bundle\ProjetBundle\Entity\TypeContrepartie	No errors.
App\Bundle\ProjetBundle\Entity\Projet	The association App\Bundle\ProjetBundle\Entity\Projet#presentation refers to the inverse side field App\Bundle\ProjetBundle\Entity\ProjetPresentation#societe which does not exist.
App\Bundle\ProjetBundle\Entity\Formule	No errors.
App\Bundle\PortailBundle\Entity\ParametreEspace	The association App\Bundle\PortailBundle\Entity\ParametreEspace#espace refers to the inverse side field App\Bundle\PortailBundle\Entity\Espace#parametres which does not exist.
App\Bundle\PortailBundle\Entity\Espace	No errors.
App\Bundle\CommercialBundle\Entity\Source	The association App\Bundle\CommercialBundle\Entity\Source#societe refers to the inverse side field App\Bundle\AdminBundle\Entity\Societe#sources which does not exist.

Symfony Profiler

GET https://demo.fundup.fr/index.php/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping