Symfony Profiler

Query Metrics

55 Database Queries

22 Different statements

8.00 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.51 ms
(18.84%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  43
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  sub_thematic_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = 43;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\SubThematic->findTranslationByLocale (line 138)
10	App\Entity\SubThematic->doTranslate (line 75)
11	App\Entity\SubThematic->translate (line 55)
12	App\Entity\SubThematic->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 568)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.97 ms
(12.12%)

SELECT t0.id AS id_1, t0.year_start AS year_start_2, t0.year_end AS year_end_3, t0.number_of_theses AS number_of_theses_4, t0.number_of_masters AS number_of_masters_5, t0.link AS link_6, t0.image AS image_7, t0.studied_zone AS studied_zone_8, t0.budget_id AS budget_id_9 FROM project t0 WHERE t0.id = ?

Parameters:

[
  "37"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year_start AS year_start_2,
  t0.year_end AS year_end_3,
  t0.number_of_theses AS number_of_theses_4,
  t0.number_of_masters AS number_of_masters_5,
  t0.link AS link_6,
  t0.image AS image_7,
  t0.studied_zone AS studied_zone_8,
  t0.budget_id AS budget_id_9
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.year_start AS year_start_2, t0.year_end AS year_end_3, t0.number_of_theses AS number_of_theses_4, t0.number_of_masters AS number_of_masters_5, t0.link AS link_6, t0.image AS image_7, t0.studied_zone AS studied_zone_8, t0.budget_id AS budget_id_9 FROM project t0 WHERE t0.id = '37';

#	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 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.67 ms
(8.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM compartment_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  34
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  compartment_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM compartment_translation t0 WHERE t0.translatable_id = 34;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Compartment->findTranslationByLocale (line 138)
10	App\Entity\Compartment->doTranslate (line 75)
11	App\Entity\Compartment->translate (line 55)
12	App\Entity\Compartment->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 353)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.62 ms
(7.68%)

SELECT t0.id AS id_1, t0.domain_id AS domain_id_2 FROM sub_domain t0 INNER JOIN researcher_sub_domain ON t0.id = researcher_sub_domain.sub_domain_id WHERE researcher_sub_domain.researcher_id = ?

Parameters:

[
  153
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.domain_id AS domain_id_2
FROM
  sub_domain t0
  INNER JOIN researcher_sub_domain ON t0.id = researcher_sub_domain.sub_domain_id
WHERE
  researcher_sub_domain.researcher_id = ?

SELECT t0.id AS id_1, t0.domain_id AS domain_id_2 FROM sub_domain t0 INNER JOIN researcher_sub_domain ON t0.id = researcher_sub_domain.sub_domain_id WHERE researcher_sub_domain.researcher_id = 153;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 159)
9	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
10	Twig\Template->yieldBlock (line 82)
11	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
22	App\Controller\ProjectController->singleProject (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.40 ms
(5.01%)

SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1
FROM
  thematic t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = 7;

#	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\Thematic::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Thematic->__get (line 20)
8	App\Entity\Thematic->getTranslations (line 189)
9	App\Entity\Thematic->findTranslationByLocale (line 138)
10	App\Entity\Thematic->doTranslate (line 75)
11	App\Entity\Thematic->translate (line 51)
12	App\Entity\Thematic->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 562)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.38 ms
(4.75%)

SELECT t0.id AS id_1, t0.practitioner_partner_id AS practitioner_partner_id_2 FROM sub_practitioner_partner t0 INNER JOIN project_sub_practitioner_partner ON t0.id = project_sub_practitioner_partner.sub_practitioner_partner_id WHERE project_sub_practitioner_partner.project_id = ? ORDER BY t0.practitioner_partner_id ASC

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.practitioner_partner_id AS practitioner_partner_id_2
FROM
  sub_practitioner_partner t0
  INNER JOIN project_sub_practitioner_partner ON t0.id = project_sub_practitioner_partner.sub_practitioner_partner_id
WHERE
  project_sub_practitioner_partner.project_id = ?
ORDER BY
  t0.practitioner_partner_id ASC

SELECT t0.id AS id_1, t0.practitioner_partner_id AS practitioner_partner_id_2 FROM sub_practitioner_partner t0 INNER JOIN project_sub_practitioner_partner ON t0.id = project_sub_practitioner_partner.sub_practitioner_partner_id WHERE project_sub_practitioner_partner.project_id = 37 ORDER BY t0.practitioner_partner_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 522)
8	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
9	Twig\Template->yieldBlock (line 82)
10	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
21	App\Controller\ProjectController->singleProject (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.37 ms
(4.60%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM thematic_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  thematic_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM thematic_translation t0 WHERE t0.translatable_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Thematic->findTranslationByLocale (line 138)
10	App\Entity\Thematic->doTranslate (line 75)
11	App\Entity\Thematic->translate (line 51)
12	App\Entity\Thematic->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 562)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.32 ms
(3.97%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_organization_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  52
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  funding_organization_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_organization_translation t0 WHERE t0.translatable_id = 52;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\FundingOrganization->findTranslationByLocale (line 138)
10	App\Entity\FundingOrganization->doTranslate (line 75)
11	App\Entity\FundingOrganization->translate (line 55)
12	App\Entity\FundingOrganization->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 264)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.30 ms
(3.75%)

SELECT t0.id AS id_1, t0.funding_category_id AS funding_category_id_2 FROM funding_organization t0 INNER JOIN project_funding_organization ON t0.id = project_funding_organization.funding_organization_id WHERE project_funding_organization.project_id = ? ORDER BY t0.funding_category_id ASC

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.funding_category_id AS funding_category_id_2
FROM
  funding_organization t0
  INNER JOIN project_funding_organization ON t0.id = project_funding_organization.funding_organization_id
WHERE
  project_funding_organization.project_id = ?
ORDER BY
  t0.funding_category_id ASC

SELECT t0.id AS id_1, t0.funding_category_id AS funding_category_id_2 FROM funding_organization t0 INNER JOIN project_funding_organization ON t0.id = project_funding_organization.funding_organization_id WHERE project_funding_organization.project_id = 37 ORDER BY t0.funding_category_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 252)
8	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
9	Twig\Template->yieldBlock (line 82)
10	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
21	App\Controller\ProjectController->singleProject (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.24 ms
(3.00%)

SELECT t0.id AS id_1, t0.continent_id AS continent_id_2 FROM country t0 INNER JOIN project_country ON t0.id = project_country.country_id WHERE project_country.project_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.continent_id AS continent_id_2
FROM
  country t0
  INNER JOIN project_country ON t0.id = project_country.country_id
WHERE
  project_country.project_id = ?

SELECT t0.id AS id_1, t0.continent_id AS continent_id_2 FROM country t0 INNER JOIN project_country ON t0.id = project_country.country_id WHERE project_country.project_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 390)
9	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
10	Twig\Template->yieldBlock (line 82)
11	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
22	App\Controller\ProjectController->singleProject (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.23 ms
(2.92%)

SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1
FROM
  funding t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = 16;

#	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\Funding::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Funding->__get (line 20)
8	App\Entity\Funding->getTranslations (line 189)
9	App\Entity\Funding->findTranslationByLocale (line 138)
10	App\Entity\Funding->doTranslate (line 75)
11	App\Entity\Funding->translate (line 51)
12	App\Entity\Funding->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 258)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.23 ms
(2.90%)

SELECT t0.id AS id_1, t0.compartment_category_id AS compartment_category_id_2 FROM compartment t0 INNER JOIN project_compartment ON t0.id = project_compartment.compartment_id WHERE project_compartment.project_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.compartment_category_id AS compartment_category_id_2
FROM
  compartment t0
  INNER JOIN project_compartment ON t0.id = project_compartment.compartment_id
WHERE
  project_compartment.project_id = ?

SELECT t0.id AS id_1, t0.compartment_category_id AS compartment_category_id_2 FROM compartment t0 INNER JOIN project_compartment ON t0.id = project_compartment.compartment_id WHERE project_compartment.project_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 344)
9	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
10	Twig\Template->yieldBlock (line 82)
11	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
22	App\Controller\ProjectController->singleProject (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.22 ms
(2.80%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM country_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  country_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM country_translation t0 WHERE t0.translatable_id = 41;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Country->findTranslationByLocale (line 138)
10	App\Entity\Country->doTranslate (line 75)
11	App\Entity\Country->translate (line 55)
12	App\Entity\Country->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 399)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.22 ms
(2.76%)

SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.academic_partner_id AS academic_partner_id_3 FROM project_academic_partner_domain t0 WHERE t0.project_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.project_id AS project_id_2,
  t0.academic_partner_id AS academic_partner_id_3
FROM
  project_academic_partner_domain t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.academic_partner_id AS academic_partner_id_3 FROM project_academic_partner_domain t0 WHERE t0.project_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 500)
8	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
9	Twig\Template->yieldBlock (line 82)
10	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
21	App\Controller\ProjectController->singleProject (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.21 ms
(2.66%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  funding_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_translation t0 WHERE t0.translatable_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Funding->findTranslationByLocale (line 138)
10	App\Entity\Funding->doTranslate (line 75)
11	App\Entity\Funding->translate (line 51)
12	App\Entity\Funding->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 258)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.21 ms
(2.66%)

SELECT t0.id AS id_1 FROM approach t0 INNER JOIN project_approach ON t0.id = project_approach.approach_id WHERE project_approach.project_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1
FROM
  approach t0
  INNER JOIN project_approach ON t0.id = project_approach.approach_id
WHERE
  project_approach.project_id = ?

SELECT t0.id AS id_1 FROM approach t0 INNER JOIN project_approach ON t0.id = project_approach.approach_id WHERE project_approach.project_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 298)
9	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
10	Twig\Template->yieldBlock (line 82)
11	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
22	App\Controller\ProjectController->singleProject (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.20 ms
(2.55%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.workplace AS workplace_4, t0.ordre AS ordre_5, t0.laboratory_id AS laboratory_id_6 FROM researcher t0 INNER JOIN project_researcher ON t0.id = project_researcher.researcher_id WHERE project_researcher.project_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.workplace AS workplace_4,
  t0.ordre AS ordre_5,
  t0.laboratory_id AS laboratory_id_6
FROM
  researcher t0
  INNER JOIN project_researcher ON t0.id = project_researcher.researcher_id
WHERE
  project_researcher.project_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.workplace AS workplace_4, t0.ordre AS ordre_5, t0.laboratory_id AS laboratory_id_6 FROM researcher t0 INNER JOIN project_researcher ON t0.id = project_researcher.researcher_id WHERE project_researcher.project_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 423)
8	App\Entity\Project->researchersByLaboratory (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 134)
10	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
11	Twig\Template->yieldBlock (line 82)
12	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
23	App\Controller\ProjectController->singleProject (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.18 ms
(2.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM project_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  project_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM project_translation t0 WHERE t0.translatable_id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Project->findTranslationByLocale (line 138)
10	App\Entity\Project->doTranslate (line 75)
11	App\Entity\Project->translate (line 173)
12	App\Entity\Project->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 76)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_title (line 431)
15	Twig\Template->yieldBlock (line 59)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.14 ms
(1.77%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3
FROM
  laboratory t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = 2;

#	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\Laboratory::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Laboratory->__get (line 47)
8	App\Entity\Laboratory->getName (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 144)
10	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
11	Twig\Template->yieldBlock (line 82)
12	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
23	App\Controller\ProjectController->singleProject (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.13 ms
(1.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_domain_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  52
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  sub_domain_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_domain_translation t0 WHERE t0.translatable_id = 52;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\SubDomain->findTranslationByLocale (line 138)
10	App\Entity\SubDomain->doTranslate (line 75)
11	App\Entity\SubDomain->translate (line 49)
12	App\Entity\SubDomain->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 166)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.13 ms
(1.58%)

SELECT t0.id AS id_1, t0.thematic_id AS thematic_id_2 FROM sub_thematic t0 INNER JOIN project_sub_thematic ON t0.id = project_sub_thematic.sub_thematic_id WHERE project_sub_thematic.project_id = ? ORDER BY t0.thematic_id ASC

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.thematic_id AS thematic_id_2
FROM
  sub_thematic t0
  INNER JOIN project_sub_thematic ON t0.id = project_sub_thematic.sub_thematic_id
WHERE
  project_sub_thematic.project_id = ?
ORDER BY
  t0.thematic_id ASC

SELECT t0.id AS id_1, t0.thematic_id AS thematic_id_2 FROM sub_thematic t0 INNER JOIN project_sub_thematic ON t0.id = project_sub_thematic.sub_thematic_id WHERE project_sub_thematic.project_id = 37 ORDER BY t0.thematic_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 556)
8	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
9	Twig\Template->yieldBlock (line 82)
10	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
21	App\Controller\ProjectController->singleProject (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.12 ms
(1.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM approach_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  approach_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM approach_translation t0 WHERE t0.translatable_id = 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Approach->findTranslationByLocale (line 138)
10	App\Entity\Approach->doTranslate (line 75)
11	App\Entity\Approach->translate (line 51)
12	App\Entity\Approach->getName (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 307)
14	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->block_body (line 431)
15	Twig\Template->yieldBlock (line 82)
16	__TwigTemplate_37e1033cb8138fe941fb0edfe8a9d3d0->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_491a09329fd0a3d56f33c78be4356f0e->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\ProjectController->singleProject (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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\Budget	No errors.
App\Entity\Researcher	No errors.
App\Entity\Compartment	No errors.
App\Entity\Approach	No errors.
App\Entity\SubThematic	No errors.
App\Entity\SubPractitionerPartner	No errors.
App\Entity\FundingOrganization	No errors.
App\Entity\Country	No errors.
App\Entity\Region	No errors.
App\Entity\ProjectAcademicPartnerDomain	No errors.
App\Entity\ProjectTranslation	No errors.
App\Entity\Laboratory	No errors.
App\Entity\SubDomain	No errors.
App\Entity\Domain	No errors.
App\Entity\SubDomainTranslation	No errors.
App\Entity\Funding	No errors.
App\Entity\FundingOrganizationTranslation	No errors.
App\Entity\FundingTranslation	No errors.
App\Entity\ApproachTranslation	No errors.
App\Entity\CompartmentCategory	No errors.
App\Entity\CompartmentTranslation	No errors.
App\Entity\Continent	No errors.
App\Entity\CountryTranslation	No errors.
App\Entity\AcademicPartner	No errors.
App\Entity\PractitionerPartner	No errors.
App\Entity\Thematic	No errors.
App\Entity\SubThematicTranslation	No errors.
App\Entity\ThematicTranslation	No errors.

Symfony Profiler

GET https://h2o.ldiro-softwares.dev/projet/37

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping