Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

17 Database Queries

7 Different statements

8.94 ms Query time

0 Invalid entities

70 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.56 ms
(39.78%)

SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?

Parameters:

[
  394
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.extension AS extension_2,
  t0.nom AS nom_3,
  t0.uuid AS uuid_4,
  t0.page_id AS page_id_5
FROM
  fichier_page t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 394;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	App\Entity\Page->getFichiers (line 131)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_96694d3e670413a7ab8137a677b2b71a::block_body (line 339)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_e51a941bf396c8b46995f6aa1f4f2312->doDisplay (line 338)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_96694d3e670413a7ab8137a677b2b71a->doDisplay (line 55)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\CoreController->index (line 40)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.19 ms
(13.27%)

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.exemple AS exemple_3, p0_.date AS date_4, p0_.date_modif AS date_modif_5, p0_.statut AS statut_6, p0_.categorie_id AS categorie_id_7, p0_.auteur_id AS auteur_id_8, p0_.user_modif_id AS user_modif_id_9 FROM page p0_ WHERE p0_.statut = ? ORDER BY p0_.id DESC LIMIT 10

Parameters:

[
  "Active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.contenu AS contenu_2,
  p0_.exemple AS exemple_3,
  p0_.date AS date_4,
  p0_.date_modif AS date_modif_5,
  p0_.statut AS statut_6,
  p0_.categorie_id AS categorie_id_7,
  p0_.auteur_id AS auteur_id_8,
  p0_.user_modif_id AS user_modif_id_9
FROM
  page p0_
WHERE
  p0_.statut = ?
ORDER BY
  p0_.id DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.exemple AS exemple_3, p0_.date AS date_4, p0_.date_modif AS date_modif_5, p0_.statut AS statut_6, p0_.categorie_id AS categorie_id_7, p0_.auteur_id AS auteur_id_8, p0_.user_modif_id AS user_modif_id_9 FROM page p0_ WHERE p0_.statut = 'Active' ORDER BY p0_.id DESC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PageRepository->findDernieresPages (line 27)
7	App\Controller\CoreController->index (line 34)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.17 ms
(13.06%)

SELECT c0_.experience AS experience_0, COUNT(p1_.id) AS sclr_1 FROM page p1_ INNER JOIN categorie c0_ ON p1_.categorie_id = c0_.id GROUP BY c0_.experience

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.experience AS experience_0,
  COUNT(p1_.id) AS sclr_1
FROM
  page p1_
  INNER JOIN categorie c0_ ON p1_.categorie_id = c0_.id
GROUP BY
  c0_.experience

SELECT c0_.experience AS experience_0, COUNT(p1_.id) AS sclr_1 FROM page p1_ INNER JOIN categorie c0_ ON p1_.categorie_id = c0_.id GROUP BY c0_.experience;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PageRepository->findNombreTotalPagesParCategorie (line 47)
7	App\Controller\CoreController->index (line 38)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.03 ms
(11.48%)

SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.niveau = ? ORDER BY t0.description ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.experience AS experience_2,
  t0.description AS description_3,
  t0.niveau AS niveau_4,
  t0.favori AS favori_5,
  t0.categorie_mere_id AS categorie_mere_id_6
FROM
  categorie t0
WHERE
  t0.niveau = ?
ORDER BY
  t0.description ASC

SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.niveau = 1 ORDER BY t0.description ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\CoreController->index (line 26)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.85 ms
(9.54%)

SELECT COUNT(p0_.id) AS sclr_0 FROM page p0_ WHERE p0_.statut LIKE ?

Parameters:

[
  "Demande%approbation"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  page p0_
WHERE
  p0_.statut LIKE ?

SELECT COUNT(p0_.id) AS sclr_0 FROM page p0_ WHERE p0_.statut LIKE 'Demande%approbation';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\PageRepository->findNombrePagesApprobation (line 37)
8	App\Controller\CoreController->index (line 35)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.63 ms
(7.08%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.last_login AS last_login_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  42
]

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.email AS email_5,
  t0.enabled AS enabled_6,
  t0.salt AS salt_7,
  t0.last_login AS last_login_8
FROM
  user 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.email AS email_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.last_login AS last_login_8 FROM user t0 WHERE t0.id = 42;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 229)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 134)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():70} (line 73)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 42)
14	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 65)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 176)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.52 ms
(5.78%)

SELECT t0.id AS id_1, t0.mot AS mot_2 FROM mot_cle t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.mot AS mot_2
FROM
  mot_cle t0

SELECT t0.id AS id_1, t0.mot AS mot_2 FROM mot_cle t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\CoreController->index (line 28)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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\MotCle	27
App\Entity\Categorie	23
App\Entity\Page	10
App\Entity\User	7
App\Entity\FichierPage	3

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Page	No errors.
App\Entity\Categorie	No errors.
App\Entity\MotCle	No errors.
App\Entity\FichierPage	No errors.

Symfony Profiler

GET https://bdc.concept-erp.info/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping