Symfony Profiler

Query Metrics

4 Database Queries

1 Different statements

74.53 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

19.93 ms

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.page AS page_3,
  t0.number AS number_4,
  t0.title AS title_5,
  t0.pipe AS pipe_6,
  t0.author AS author_7,
  t0.text1 AS text1_8,
  t0.text2 AS text2_9,
  t0.illustration AS illustration_10,
  t0.notes AS notes_11,
  t0.change AS change_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.navigation1 AS navigation1_15,
  t0.navigation2 AS navigation2_16,
  t0.lang AS lang_17,
  t0.url AS url_18
FROM
  history t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history 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 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 202)
7	App\Controller\MainController->showCildhood (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

18.21 ms

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.page AS page_3,
  t0.number AS number_4,
  t0.title AS title_5,
  t0.pipe AS pipe_6,
  t0.author AS author_7,
  t0.text1 AS text1_8,
  t0.text2 AS text2_9,
  t0.illustration AS illustration_10,
  t0.notes AS notes_11,
  t0.change AS change_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.navigation1 AS navigation1_15,
  t0.navigation2 AS navigation2_16,
  t0.lang AS lang_17,
  t0.url AS url_18
FROM
  history t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history t0 WHERE t0.id = '2';

#	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 203)
7	App\Controller\MainController->showCildhood (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

18.03 ms

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history t0 WHERE t0.id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.page AS page_3,
  t0.number AS number_4,
  t0.title AS title_5,
  t0.pipe AS pipe_6,
  t0.author AS author_7,
  t0.text1 AS text1_8,
  t0.text2 AS text2_9,
  t0.illustration AS illustration_10,
  t0.notes AS notes_11,
  t0.change AS change_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.navigation1 AS navigation1_15,
  t0.navigation2 AS navigation2_16,
  t0.lang AS lang_17,
  t0.url AS url_18
FROM
  history t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history t0 WHERE t0.id = '3';

#	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 204)
7	App\Controller\MainController->showCildhood (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

18.35 ms

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history t0 WHERE t0.id = ?

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.page AS page_3,
  t0.number AS number_4,
  t0.title AS title_5,
  t0.pipe AS pipe_6,
  t0.author AS author_7,
  t0.text1 AS text1_8,
  t0.text2 AS text2_9,
  t0.illustration AS illustration_10,
  t0.notes AS notes_11,
  t0.change AS change_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.navigation1 AS navigation1_15,
  t0.navigation2 AS navigation2_16,
  t0.lang AS lang_17,
  t0.url AS url_18
FROM
  history t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.page AS page_3, t0.number AS number_4, t0.title AS title_5, t0.pipe AS pipe_6, t0.author AS author_7, t0.text1 AS text1_8, t0.text2 AS text2_9, t0.illustration AS illustration_10, t0.notes AS notes_11, t0.change AS change_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.navigation1 AS navigation1_15, t0.navigation2 AS navigation2_16, t0.lang AS lang_17, t0.url AS url_18 FROM history t0 WHERE t0.id = '4';

#	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 205)
7	App\Controller\MainController->showCildhood (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\History	No errors.

Symfony Profiler

GET http://elisebisschop.fr/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CSearchController%253A%253AsearchForm

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping