Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

49.96 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

29.96 ms
(59.96%)

SELECT COUNT(*) FROM reservation t0 WHERE t0.is_valide = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  reservation t0
WHERE
  t0.is_valide = ?

SELECT COUNT(*) FROM reservation t0 WHERE t0.is_valide = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->count (line 92)
4	App\Twig\Components\MenuLeft->getReservationsEnAttenteCount (line 21)
5	Twig\Extension\CoreExtension->getAttribute (line 1913)
6	__TwigTemplate_2fcf4eafbd8d0166fcada66350b30d04::doDisplay (line 158)
7	Twig\Template->yield (line 402)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
13	__TwigTemplate_03b470ec692a7ca31a1b7fd6c9d0c6af->doDisplay (line 164)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_540adb15aebc71f41698f929c52881a6->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
24	App\Controller\ReservationController->admin (line 77)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

10.08 ms
(20.17%)

SELECT t0.id AS id_1, t0.date_reservation AS date_reservation_2, t0.creneau AS creneau_3, t0.etage AS etage_4, t0.salle_debriefing AS salle_debriefing_5, t0.salles_simulation AS salles_simulation_6, t0.simulateurs AS simulateurs_7, t0.salles_procedurales AS salles_procedurales_8, t0.created_at AS created_at_9, t0.is_valide AS is_valide_10, t0.reference AS reference_11 FROM reservation t0 WHERE t0.is_valide = ? ORDER BY t0.created_at ASC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_reservation AS date_reservation_2,
  t0.creneau AS creneau_3,
  t0.etage AS etage_4,
  t0.salle_debriefing AS salle_debriefing_5,
  t0.salles_simulation AS salles_simulation_6,
  t0.simulateurs AS simulateurs_7,
  t0.salles_procedurales AS salles_procedurales_8,
  t0.created_at AS created_at_9,
  t0.is_valide AS is_valide_10,
  t0.reference AS reference_11
FROM
  reservation t0
WHERE
  t0.is_valide = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.date_reservation AS date_reservation_2, t0.creneau AS creneau_3, t0.etage AS etage_4, t0.salle_debriefing AS salle_debriefing_5, t0.salles_simulation AS salles_simulation_6, t0.simulateurs AS simulateurs_7, t0.salles_procedurales AS salles_procedurales_8, t0.created_at AS created_at_9, t0.is_valide AS is_valide_10, t0.reference AS reference_11 FROM reservation t0 WHERE t0.is_valide = 0 ORDER BY t0.created_at ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\ReservationController->admin (line 67)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

9.93 ms
(19.87%)

SELECT t0.id AS id_1, t0.date_reservation AS date_reservation_2, t0.creneau AS creneau_3, t0.etage AS etage_4, t0.salle_debriefing AS salle_debriefing_5, t0.salles_simulation AS salles_simulation_6, t0.simulateurs AS simulateurs_7, t0.salles_procedurales AS salles_procedurales_8, t0.created_at AS created_at_9, t0.is_valide AS is_valide_10, t0.reference AS reference_11 FROM reservation t0 WHERE t0.is_valide = ? ORDER BY t0.date_reservation ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_reservation AS date_reservation_2,
  t0.creneau AS creneau_3,
  t0.etage AS etage_4,
  t0.salle_debriefing AS salle_debriefing_5,
  t0.salles_simulation AS salles_simulation_6,
  t0.simulateurs AS simulateurs_7,
  t0.salles_procedurales AS salles_procedurales_8,
  t0.created_at AS created_at_9,
  t0.is_valide AS is_valide_10,
  t0.reference AS reference_11
FROM
  reservation t0
WHERE
  t0.is_valide = ?
ORDER BY
  t0.date_reservation ASC

SELECT t0.id AS id_1, t0.date_reservation AS date_reservation_2, t0.creneau AS creneau_3, t0.etage AS etage_4, t0.salle_debriefing AS salle_debriefing_5, t0.salles_simulation AS salles_simulation_6, t0.simulateurs AS simulateurs_7, t0.salles_procedurales AS salles_procedurales_8, t0.created_at AS created_at_9, t0.is_valide AS is_valide_10, t0.reference AS reference_11 FROM reservation t0 WHERE t0.is_valide = 1 ORDER BY t0.date_reservation ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\ReservationController->admin (line 72)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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\Reservation	7

Entities Mapping

Class	Mapping errors
App\Entity\Reservation	No errors.

Symfony Profiler

GET https://www.app-lms.fr/reservation/admin

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping