Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

129.46 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

101.75 ms
(78.60%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.on_going AS on_going_4, p0_.image AS image_5, p0_.github_link AS github_link_6, p1_.id AS id_7, p1_.description AS description_8, p1_.link AS link_9, p1_.locale AS locale_10, t2_.id AS id_11, t2_.name AS name_12, p1_.translatable_id AS translatable_id_13 FROM project p0_ LEFT JOIN project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN project_tool p3_ ON p0_.id = p3_.project_id LEFT JOIN tool t2_ ON t2_.id = p3_.tool_id ORDER BY p0_.on_going DESC, p0_.end_date DESC, p0_.start_date DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.start_date AS start_date_2,
  p0_.end_date AS end_date_3,
  p0_.on_going AS on_going_4,
  p0_.image AS image_5,
  p0_.github_link AS github_link_6,
  p1_.id AS id_7,
  p1_.description AS description_8,
  p1_.link AS link_9,
  p1_.locale AS locale_10,
  t2_.id AS id_11,
  t2_.name AS name_12,
  p1_.translatable_id AS translatable_id_13
FROM
  project p0_
  LEFT JOIN project_translation p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN project_tool p3_ ON p0_.id = p3_.project_id
  LEFT JOIN tool t2_ ON t2_.id = p3_.tool_id
ORDER BY
  p0_.on_going DESC,
  p0_.end_date DESC,
  p0_.start_date DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.on_going AS on_going_4, p0_.image AS image_5, p0_.github_link AS github_link_6, p1_.id AS id_7, p1_.description AS description_8, p1_.link AS link_9, p1_.locale AS locale_10, t2_.id AS id_11, t2_.name AS name_12, p1_.translatable_id AS translatable_id_13 FROM project p0_ LEFT JOIN project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN project_tool p3_ ON p0_.id = p3_.project_id LEFT JOIN tool t2_ ON t2_.id = p3_.tool_id ORDER BY p0_.on_going DESC, p0_.end_date DESC, p0_.start_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 28)
7	App\Repository\ProjectRepository->getProjects (line 29)
8	App\Controller\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

12.63 ms
(9.75%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_date AS start_date_2, e0_.end_date AS end_date_3, e1_.id AS id_4, e1_.description AS description_5, e1_.job AS job_6, e1_.link AS link_7, e1_.locale AS locale_8, t2_.id AS id_9, t2_.name AS name_10, e1_.translatable_id AS translatable_id_11 FROM experience e0_ LEFT JOIN experience_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN experience_tool e3_ ON e0_.id = e3_.experience_id LEFT JOIN tool t2_ ON t2_.id = e3_.tool_id ORDER BY e0_.start_date DESC, e0_.end_date DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.start_date AS start_date_2,
  e0_.end_date AS end_date_3,
  e1_.id AS id_4,
  e1_.description AS description_5,
  e1_.job AS job_6,
  e1_.link AS link_7,
  e1_.locale AS locale_8,
  t2_.id AS id_9,
  t2_.name AS name_10,
  e1_.translatable_id AS translatable_id_11
FROM
  experience e0_
  LEFT JOIN experience_translation e1_ ON e0_.id = e1_.translatable_id
  LEFT JOIN experience_tool e3_ ON e0_.id = e3_.experience_id
  LEFT JOIN tool t2_ ON t2_.id = e3_.tool_id
ORDER BY
  e0_.start_date DESC,
  e0_.end_date DESC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_date AS start_date_2, e0_.end_date AS end_date_3, e1_.id AS id_4, e1_.description AS description_5, e1_.job AS job_6, e1_.link AS link_7, e1_.locale AS locale_8, t2_.id AS id_9, t2_.name AS name_10, e1_.translatable_id AS translatable_id_11 FROM experience e0_ LEFT JOIN experience_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN experience_tool e3_ ON e0_.id = e3_.experience_id LEFT JOIN tool t2_ ON t2_.id = e3_.tool_id ORDER BY e0_.start_date DESC, e0_.end_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 27)
7	App\Repository\ExperienceRepository->getExperiences (line 30)
8	App\Controller\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

11.55 ms
(8.92%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.school AS school_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM diploma_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school AS school_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  diploma_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school AS school_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM diploma_translation t0 WHERE t0.translatable_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1660)
10	Twig\Extension\CoreExtension::getAttribute (line 473)
11	__TwigTemplate_2ef4772075d64daf86dd3f38d7f909de->block_main (line 431)
12	Twig\Template->yieldBlock (line 101)
13	__TwigTemplate_6fb9247e6ad6dff0f1b5741473c82a8c->doDisplay (line 387)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_2ef4772075d64daf86dd3f38d7f909de->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 320)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
24	App\Controller\HomeController->index (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

3.53 ms
(2.72%)

SELECT d0_.id AS id_0, d0_.start_date AS start_date_1, d0_.end_date AS end_date_2, d0_.city AS city_3 FROM diploma d0_ ORDER BY d0_.start_date DESC, d0_.end_date DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.start_date AS start_date_1,
  d0_.end_date AS end_date_2,
  d0_.city AS city_3
FROM
  diploma d0_
ORDER BY
  d0_.start_date DESC,
  d0_.end_date DESC

SELECT d0_.id AS id_0, d0_.start_date AS start_date_1, d0_.end_date AS end_date_2, d0_.city AS city_3 FROM diploma d0_ ORDER BY d0_.start_date DESC, d0_.end_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 24)
7	App\Repository\DiplomaRepository->getDiplomas (line 31)
8	App\Controller\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\Project	No errors.
App\Entity\ProjectTranslation	No errors.
App\Entity\Tool	No errors.
App\Entity\Experience	No errors.
App\Entity\ExperienceTranslation	No errors.
App\Entity\Diploma	No errors.
App\Entity\DiplomaTranslation	No errors.

Symfony Profiler

GET http://richardcrete.fr/fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping