Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

10.16 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.29 ms
(32.36%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.titre AS titre_3, t0.parent1_id AS parent1_id_4, t0.parent2_id AS parent2_id_5 FROM portee t0 ORDER BY t0.date DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.titre AS titre_3,
  t0.parent1_id AS parent1_id_4,
  t0.parent2_id AS parent2_id_5
FROM
  portee t0
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.date AS date_2, t0.titre AS titre_3, t0.parent1_id AS parent1_id_4, t0.parent2_id AS parent2_id_5 FROM portee t0 ORDER BY t0.date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 42)
4	App\Controller\MainController->portees (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

2.75 ms
(27.02%)

SELECT t0.id AS id_1, t0.sexe AS sexe_2, t0.naissance AS naissance_3, t0.description AS description_4, t0.nom AS nom_5, t0.proprietaire AS proprietaire_6 FROM parents t0 WHERE t0.id = ?

Parameters:

[
  "8925a510-601c-4186-b1a9-1e6b340ea9a8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sexe AS sexe_2,
  t0.naissance AS naissance_3,
  t0.description AS description_4,
  t0.nom AS nom_5,
  t0.proprietaire AS proprietaire_6
FROM
  parents t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sexe AS sexe_2, t0.naissance AS naissance_3, t0.description AS description_4, t0.nom AS nom_5, t0.proprietaire AS proprietaire_6 FROM parents t0 WHERE t0.id = '8925a510-601c-4186-b1a9-1e6b340ea9a8';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
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\Parents::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Parents->__get (line 62)
8	App\Entity\Parents->getNom (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 119)
10	__TwigTemplate_6f36be87d509aced3c247de921895ced->block_body (line 437)
11	Twig\Template->yieldBlock (line 177)
12	__TwigTemplate_7163f8a836ce45c525419f02098eb9cc->doDisplay (line 393)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_6f36be87d509aced3c247de921895ced->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
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 49)
23	App\Controller\MainController->portees (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)

2.59 ms
(25.47%)

SELECT COUNT(*) FROM chaton t0 WHERE t0.portee_id = ?

Parameters:

[
  "41a05d10-0520-4f2e-bcff-76f8b1b4dcfd"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  chaton t0
WHERE
  t0.portee_id = ?

SELECT COUNT(*) FROM chaton t0 WHERE t0.portee_id = '41a05d10-0520-4f2e-bcff-76f8b1b4dcfd';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 863)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 139)
3	Doctrine\ORM\EntityRepository->count (line 46)
4	App\Controller\MainController->portees (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.54 ms
(15.15%)

SELECT COUNT(*) FROM chaton t0 WHERE t0.portee_id = ? AND t0.dispo = ?

Parameters:

[
  "41a05d10-0520-4f2e-bcff-76f8b1b4dcfd"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  chaton t0
WHERE
  t0.portee_id = ?
  AND t0.dispo = ?

SELECT COUNT(*) FROM chaton t0 WHERE t0.portee_id = '41a05d10-0520-4f2e-bcff-76f8b1b4dcfd' AND t0.dispo = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 863)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 139)
3	Doctrine\ORM\EntityRepository->count (line 47)
4	App\Controller\MainController->portees (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Portee	No errors.
App\Entity\Parents	No errors.
App\Entity\Chaton	No errors.

Symfony Profiler

GET http://elevage-des-gnomes-normands.imanora.fr/nos-portees

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping