Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.51 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.17 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.github_repo_url AS github_repo_url_4, t0.status AS status_5, t0.created_at AS created_at_6 FROM project t0 ORDER BY t0.created_at DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.github_repo_url AS github_repo_url_4,
  t0.status AS status_5,
  t0.created_at AS created_at_6
FROM
  project t0
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.github_repo_url AS github_repo_url_4, t0.status AS status_5, t0.created_at AS created_at_6 FROM project t0 ORDER BY t0.created_at DESC;

#	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\ProjectController->index (line 21)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.18 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.generated_prompt AS generated_prompt_5, t0.git_branch AS git_branch_6, t0.last_commit_sha AS last_commit_sha_7, t0.last_checked_at AS last_checked_at_8, t0.created_at AS created_at_9, t0.project_id AS project_id_10, t0.agent_id AS agent_id_11 FROM task t0 WHERE t0.project_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.generated_prompt AS generated_prompt_5,
  t0.git_branch AS git_branch_6,
  t0.last_commit_sha AS last_commit_sha_7,
  t0.last_checked_at AS last_checked_at_8,
  t0.created_at AS created_at_9,
  t0.project_id AS project_id_10,
  t0.agent_id AS agent_id_11
FROM
  task t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.generated_prompt AS generated_prompt_5, t0.git_branch AS git_branch_6, t0.last_commit_sha AS last_commit_sha_7, t0.last_checked_at AS last_checked_at_8, t0.created_at AS created_at_9, t0.project_id AS project_id_10, t0.agent_id AS agent_id_11 FROM task t0 WHERE t0.project_id = 2;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_d4addb4f2f3e3e60ba3727a9043e0acd::block_body (line 229)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_45b091a29405714f51f3abce55e8bf05->doDisplay (line 105)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_d4addb4f2f3e3e60ba3727a9043e0acd->doDisplay (line 54)
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 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\ProjectController->index (line 20)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.16 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.generated_prompt AS generated_prompt_5, t0.git_branch AS git_branch_6, t0.last_commit_sha AS last_commit_sha_7, t0.last_checked_at AS last_checked_at_8, t0.created_at AS created_at_9, t0.project_id AS project_id_10, t0.agent_id AS agent_id_11 FROM task t0 WHERE t0.project_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.generated_prompt AS generated_prompt_5,
  t0.git_branch AS git_branch_6,
  t0.last_commit_sha AS last_commit_sha_7,
  t0.last_checked_at AS last_checked_at_8,
  t0.created_at AS created_at_9,
  t0.project_id AS project_id_10,
  t0.agent_id AS agent_id_11
FROM
  task t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.generated_prompt AS generated_prompt_5, t0.git_branch AS git_branch_6, t0.last_commit_sha AS last_commit_sha_7, t0.last_checked_at AS last_checked_at_8, t0.created_at AS created_at_9, t0.project_id AS project_id_10, t0.agent_id AS agent_id_11 FROM task t0 WHERE t0.project_id = 1;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_d4addb4f2f3e3e60ba3727a9043e0acd::block_body (line 229)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_45b091a29405714f51f3abce55e8bf05->doDisplay (line 105)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_d4addb4f2f3e3e60ba3727a9043e0acd->doDisplay (line 54)
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 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\ProjectController->index (line 20)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Project	2
App\Entity\Task	1
App\Entity\Agent	1

Entities Mapping

Class	Mapping errors
App\Entity\Project	No errors.
App\Entity\Task	No errors.
App\Entity\Agent	No errors.

Symfony Profiler

GET https://pagodevia.adrien-pago-portfolio.fr/projects

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping