Symfony Profiler

Query Metrics

17 Database Queries

15 Different statements

8.75 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.11 ms
(12.69%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.image_name AS image_name_4,
  t0.image_size AS image_size_5,
  t0.image_updated_at AS image_updated_at_6,
  t0.image_alt_fr AS image_alt_fr_7,
  t0.image_alt_en AS image_alt_en_8,
  t0.logo_name AS logo_name_9,
  t0.logo_size AS logo_size_10,
  t0.logo_updated_at AS logo_updated_at_11,
  t0.logo_alt_fr AS logo_alt_fr_12,
  t0.logo_alt_en AS logo_alt_en_13,
  t0.intro_fr AS intro_fr_14,
  t0.intro_en AS intro_en_15,
  t0.content_fr AS content_fr_16,
  t0.content_en AS content_en_17,
  t0.slug_en AS slug_en_18,
  t0.h1 AS h1_19,
  t0.h1_en AS h1_en_20,
  t0.meta_title_en AS meta_title_en_21,
  t0.meta_description_en AS meta_description_en_22,
  t0.meta_title AS meta_title_23,
  t0.meta_description AS meta_description_24,
  t0.slug AS slug_25,
  t0.position AS position_26
FROM
  application t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 169)
4	App\Services\AppService->getApplications (line 94)
5	App\Twig\AppExtension->getApplications (line 121)
6	__TwigTemplate_0b694ca5d916c2fb50e38bdfda953db4->doDisplay (line 398)
7	Twig\Template->yield (line 62)
8	__TwigTemplate_86838716ca71f102475b0af1273ab0b6->doDisplay (line 398)
9	Twig\Template->yield (line 178)
10	__TwigTemplate_21e3f334c25a6f18746d8558663e1674->block_header (line 442)
11	Twig\Template->yieldBlock (line 53)
12	__TwigTemplate_21e3f334c25a6f18746d8558663e1674->doDisplay (line 398)
13	Twig\Template->yield (line 156)
14	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
15	Twig\Template->yield (line 58)
16	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
19	Twig\Template->yield (line 354)
20	Twig\Template->display (line 369)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 328)
27	App\Controller\FrontController->approach (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.08 ms
(12.37%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.title_fr AS title_fr_7, t0.title_en AS title_en_8, t0.intro_fr AS intro_fr_9, t0.intro_en AS intro_en_10, t0.content_fr AS content_fr_11, t0.content_en AS content_en_12, t0.documentation_intro_fr AS documentation_intro_fr_13, t0.documentation_intro_en AS documentation_intro_en_14, t0.slug_en AS slug_en_15, t0.h1 AS h1_16, t0.h1_en AS h1_en_17, t0.meta_title_en AS meta_title_en_18, t0.meta_description_en AS meta_description_en_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.slug AS slug_22, t0.position AS position_23 FROM product t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_updated_at AS image_updated_at_4,
  t0.image_alt_fr AS image_alt_fr_5,
  t0.image_alt_en AS image_alt_en_6,
  t0.title_fr AS title_fr_7,
  t0.title_en AS title_en_8,
  t0.intro_fr AS intro_fr_9,
  t0.intro_en AS intro_en_10,
  t0.content_fr AS content_fr_11,
  t0.content_en AS content_en_12,
  t0.documentation_intro_fr AS documentation_intro_fr_13,
  t0.documentation_intro_en AS documentation_intro_en_14,
  t0.slug_en AS slug_en_15,
  t0.h1 AS h1_16,
  t0.h1_en AS h1_en_17,
  t0.meta_title_en AS meta_title_en_18,
  t0.meta_description_en AS meta_description_en_19,
  t0.meta_title AS meta_title_20,
  t0.meta_description AS meta_description_21,
  t0.slug AS slug_22,
  t0.position AS position_23
FROM
  product t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.title_fr AS title_fr_7, t0.title_en AS title_en_8, t0.intro_fr AS intro_fr_9, t0.intro_en AS intro_en_10, t0.content_fr AS content_fr_11, t0.content_en AS content_en_12, t0.documentation_intro_fr AS documentation_intro_fr_13, t0.documentation_intro_en AS documentation_intro_en_14, t0.slug_en AS slug_en_15, t0.h1 AS h1_16, t0.h1_en AS h1_en_17, t0.meta_title_en AS meta_title_en_18, t0.meta_description_en AS meta_description_en_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.slug AS slug_22, t0.position AS position_23 FROM product t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 163)
4	App\Services\AppService->getProducts (line 89)
5	App\Twig\AppExtension->getProducts (line 148)
6	__TwigTemplate_0b694ca5d916c2fb50e38bdfda953db4->doDisplay (line 398)
7	Twig\Template->yield (line 62)
8	__TwigTemplate_86838716ca71f102475b0af1273ab0b6->doDisplay (line 398)
9	Twig\Template->yield (line 178)
10	__TwigTemplate_21e3f334c25a6f18746d8558663e1674->block_header (line 442)
11	Twig\Template->yieldBlock (line 53)
12	__TwigTemplate_21e3f334c25a6f18746d8558663e1674->doDisplay (line 398)
13	Twig\Template->yield (line 156)
14	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
15	Twig\Template->yield (line 58)
16	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
19	Twig\Template->yield (line 354)
20	Twig\Template->display (line 369)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 328)
27	App\Controller\FrontController->approach (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.60 ms
(6.80%)

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7, t0.meta_title_en AS meta_title_en_8, t0.meta_description_en AS meta_description_en_9, t0.h1_en AS h1_en_10 FROM seopage t0 WHERE t0.route = ? LIMIT 1

Parameters:

[
  "front_approach"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.page_name AS page_name_2,
  t0.route AS route_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.h1_enabled AS h1_enabled_6,
  t0.h1 AS h1_7,
  t0.meta_title_en AS meta_title_en_8,
  t0.meta_description_en AS meta_description_en_9,
  t0.h1_en AS h1_en_10
FROM
  seopage t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7, t0.meta_title_en AS meta_title_en_8, t0.meta_description_en AS meta_description_en_9, t0.h1_en AS h1_en_10 FROM seopage t0 WHERE t0.route = 'front_approach' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 36)
4	Cofondateur\SocleTechniqueBundle\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.60 ms
(6.80%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_amerique ON t0.id = approach_documentation_amerique.documentation_id WHERE approach_documentation_amerique.approach_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.description_fr AS description_fr_4,
  t0.description_en AS description_en_5,
  t0.doc_name AS doc_name_6,
  t0.doc_size AS doc_size_7,
  t0.doc_updated_at AS doc_updated_at_8,
  t0.doc_en_name AS doc_en_name_9,
  t0.doc_en_size AS doc_en_size_10,
  t0.doc_en_updated_at AS doc_en_updated_at_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.position AS position_17,
  t0.documentation_category_id AS documentation_category_id_18
FROM
  documentation t0
  INNER JOIN approach_documentation_amerique ON t0.id = approach_documentation_amerique.documentation_id
WHERE
  approach_documentation_amerique.approach_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_amerique ON t0.id = approach_documentation_amerique.documentation_id WHERE approach_documentation_amerique.approach_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 217)
8	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
9	Twig\Template->yieldBlock (line 161)
10	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
11	Twig\Template->yield (line 58)
12	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
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 328)
23	App\Controller\FrontController->approach (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.58 ms
(6.64%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_europe ON t0.id = approach_documentation_europe.documentation_id WHERE approach_documentation_europe.approach_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.description_fr AS description_fr_4,
  t0.description_en AS description_en_5,
  t0.doc_name AS doc_name_6,
  t0.doc_size AS doc_size_7,
  t0.doc_updated_at AS doc_updated_at_8,
  t0.doc_en_name AS doc_en_name_9,
  t0.doc_en_size AS doc_en_size_10,
  t0.doc_en_updated_at AS doc_en_updated_at_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.position AS position_17,
  t0.documentation_category_id AS documentation_category_id_18
FROM
  documentation t0
  INNER JOIN approach_documentation_europe ON t0.id = approach_documentation_europe.documentation_id
WHERE
  approach_documentation_europe.approach_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_europe ON t0.id = approach_documentation_europe.documentation_id WHERE approach_documentation_europe.approach_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 259)
8	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
9	Twig\Template->yieldBlock (line 161)
10	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
11	Twig\Template->yield (line 58)
12	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
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 328)
23	App\Controller\FrontController->approach (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.57 ms
(6.46%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_qatar ON t0.id = approach_documentation_qatar.documentation_id WHERE approach_documentation_qatar.approach_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.description_fr AS description_fr_4,
  t0.description_en AS description_en_5,
  t0.doc_name AS doc_name_6,
  t0.doc_size AS doc_size_7,
  t0.doc_updated_at AS doc_updated_at_8,
  t0.doc_en_name AS doc_en_name_9,
  t0.doc_en_size AS doc_en_size_10,
  t0.doc_en_updated_at AS doc_en_updated_at_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.position AS position_17,
  t0.documentation_category_id AS documentation_category_id_18
FROM
  documentation t0
  INNER JOIN approach_documentation_qatar ON t0.id = approach_documentation_qatar.documentation_id
WHERE
  approach_documentation_qatar.approach_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_qatar ON t0.id = approach_documentation_qatar.documentation_id WHERE approach_documentation_qatar.approach_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 428)
8	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
9	Twig\Template->yieldBlock (line 161)
10	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
11	Twig\Template->yield (line 58)
12	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
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 328)
23	App\Controller\FrontController->approach (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.55 ms
(6.32%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_asie3 ON t0.id = approach_documentation_asie3.documentation_id WHERE approach_documentation_asie3.approach_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.description_fr AS description_fr_4,
  t0.description_en AS description_en_5,
  t0.doc_name AS doc_name_6,
  t0.doc_size AS doc_size_7,
  t0.doc_updated_at AS doc_updated_at_8,
  t0.doc_en_name AS doc_en_name_9,
  t0.doc_en_size AS doc_en_size_10,
  t0.doc_en_updated_at AS doc_en_updated_at_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.position AS position_17,
  t0.documentation_category_id AS documentation_category_id_18
FROM
  documentation t0
  INNER JOIN approach_documentation_asie3 ON t0.id = approach_documentation_asie3.documentation_id
WHERE
  approach_documentation_asie3.approach_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_asie3 ON t0.id = approach_documentation_asie3.documentation_id WHERE approach_documentation_asie3.approach_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 386)
8	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
9	Twig\Template->yieldBlock (line 161)
10	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
11	Twig\Template->yield (line 58)
12	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
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 328)
23	App\Controller\FrontController->approach (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.53 ms
(6.07%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_asie1 ON t0.id = approach_documentation_asie1.documentation_id WHERE approach_documentation_asie1.approach_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.description_fr AS description_fr_4,
  t0.description_en AS description_en_5,
  t0.doc_name AS doc_name_6,
  t0.doc_size AS doc_size_7,
  t0.doc_updated_at AS doc_updated_at_8,
  t0.doc_en_name AS doc_en_name_9,
  t0.doc_en_size AS doc_en_size_10,
  t0.doc_en_updated_at AS doc_en_updated_at_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.position AS position_17,
  t0.documentation_category_id AS documentation_category_id_18
FROM
  documentation t0
  INNER JOIN approach_documentation_asie1 ON t0.id = approach_documentation_asie1.documentation_id
WHERE
  approach_documentation_asie1.approach_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_asie1 ON t0.id = approach_documentation_asie1.documentation_id WHERE approach_documentation_asie1.approach_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 301)
8	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
9	Twig\Template->yieldBlock (line 161)
10	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
11	Twig\Template->yield (line 58)
12	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
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 328)
23	App\Controller\FrontController->approach (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.50 ms
(5.77%)

SELECT t0.id AS id_1, t0.sub_title_fr AS sub_title_fr_2, t0.sub_title_en AS sub_title_en_3, t0.title_fr AS title_fr_4, t0.title_en AS title_en_5, t0.paragraph_fr AS paragraph_fr_6, t0.paragraph_en AS paragraph_en_7, t0.cta_link AS cta_link_8, t0.cta_text_fr AS cta_text_fr_9, t0.cta_text_en AS cta_text_en_10, t0.cta_external AS cta_external_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.url_youtube_original AS url_youtube_original_17, t0.url_youtube_embed AS url_youtube_embed_18, t0.approach_production_id AS approach_production_id_19, t0.approach_controle_id AS approach_controle_id_20, t0.approach_factory_recipe_id AS approach_factory_recipe_id_21 FROM approach_paragraph t0 WHERE t0.approach_production_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sub_title_fr AS sub_title_fr_2,
  t0.sub_title_en AS sub_title_en_3,
  t0.title_fr AS title_fr_4,
  t0.title_en AS title_en_5,
  t0.paragraph_fr AS paragraph_fr_6,
  t0.paragraph_en AS paragraph_en_7,
  t0.cta_link AS cta_link_8,
  t0.cta_text_fr AS cta_text_fr_9,
  t0.cta_text_en AS cta_text_en_10,
  t0.cta_external AS cta_external_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.url_youtube_original AS url_youtube_original_17,
  t0.url_youtube_embed AS url_youtube_embed_18,
  t0.approach_production_id AS approach_production_id_19,
  t0.approach_controle_id AS approach_controle_id_20,
  t0.approach_factory_recipe_id AS approach_factory_recipe_id_21
FROM
  approach_paragraph t0
WHERE
  t0.approach_production_id = ?

SELECT t0.id AS id_1, t0.sub_title_fr AS sub_title_fr_2, t0.sub_title_en AS sub_title_en_3, t0.title_fr AS title_fr_4, t0.title_en AS title_en_5, t0.paragraph_fr AS paragraph_fr_6, t0.paragraph_en AS paragraph_en_7, t0.cta_link AS cta_link_8, t0.cta_text_fr AS cta_text_fr_9, t0.cta_text_en AS cta_text_en_10, t0.cta_external AS cta_external_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.url_youtube_original AS url_youtube_original_17, t0.url_youtube_embed AS url_youtube_embed_18, t0.approach_production_id AS approach_production_id_19, t0.approach_controle_id AS approach_controle_id_20, t0.approach_factory_recipe_id AS approach_factory_recipe_id_21 FROM approach_paragraph t0 WHERE t0.approach_production_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 484)
9	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
10	Twig\Template->yieldBlock (line 161)
11	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
12	Twig\Template->yield (line 58)
13	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
16	Twig\Template->yield (line 354)
17	Twig\Template->display (line 369)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 306)
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 328)
24	App\Controller\FrontController->approach (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.49 ms
(5.62%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_asie2 ON t0.id = approach_documentation_asie2.documentation_id WHERE approach_documentation_asie2.approach_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.description_fr AS description_fr_4,
  t0.description_en AS description_en_5,
  t0.doc_name AS doc_name_6,
  t0.doc_size AS doc_size_7,
  t0.doc_updated_at AS doc_updated_at_8,
  t0.doc_en_name AS doc_en_name_9,
  t0.doc_en_size AS doc_en_size_10,
  t0.doc_en_updated_at AS doc_en_updated_at_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.position AS position_17,
  t0.documentation_category_id AS documentation_category_id_18
FROM
  documentation t0
  INNER JOIN approach_documentation_asie2 ON t0.id = approach_documentation_asie2.documentation_id
WHERE
  approach_documentation_asie2.approach_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.doc_name AS doc_name_6, t0.doc_size AS doc_size_7, t0.doc_updated_at AS doc_updated_at_8, t0.doc_en_name AS doc_en_name_9, t0.doc_en_size AS doc_en_size_10, t0.doc_en_updated_at AS doc_en_updated_at_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.position AS position_17, t0.documentation_category_id AS documentation_category_id_18 FROM documentation t0 INNER JOIN approach_documentation_asie2 ON t0.id = approach_documentation_asie2.documentation_id WHERE approach_documentation_asie2.approach_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 344)
8	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
9	Twig\Template->yieldBlock (line 161)
10	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
11	Twig\Template->yield (line 58)
12	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
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 328)
23	App\Controller\FrontController->approach (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.49 ms
(5.59%)

SELECT t0.id AS id_1, t0.sub_title_fr AS sub_title_fr_2, t0.sub_title_en AS sub_title_en_3, t0.title_fr AS title_fr_4, t0.title_en AS title_en_5, t0.paragraph_fr AS paragraph_fr_6, t0.paragraph_en AS paragraph_en_7, t0.cta_link AS cta_link_8, t0.cta_text_fr AS cta_text_fr_9, t0.cta_text_en AS cta_text_en_10, t0.cta_external AS cta_external_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.url_youtube_original AS url_youtube_original_17, t0.url_youtube_embed AS url_youtube_embed_18, t0.approach_production_id AS approach_production_id_19, t0.approach_controle_id AS approach_controle_id_20, t0.approach_factory_recipe_id AS approach_factory_recipe_id_21 FROM approach_paragraph t0 WHERE t0.approach_controle_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sub_title_fr AS sub_title_fr_2,
  t0.sub_title_en AS sub_title_en_3,
  t0.title_fr AS title_fr_4,
  t0.title_en AS title_en_5,
  t0.paragraph_fr AS paragraph_fr_6,
  t0.paragraph_en AS paragraph_en_7,
  t0.cta_link AS cta_link_8,
  t0.cta_text_fr AS cta_text_fr_9,
  t0.cta_text_en AS cta_text_en_10,
  t0.cta_external AS cta_external_11,
  t0.image_name AS image_name_12,
  t0.image_size AS image_size_13,
  t0.image_updated_at AS image_updated_at_14,
  t0.image_alt_fr AS image_alt_fr_15,
  t0.image_alt_en AS image_alt_en_16,
  t0.url_youtube_original AS url_youtube_original_17,
  t0.url_youtube_embed AS url_youtube_embed_18,
  t0.approach_production_id AS approach_production_id_19,
  t0.approach_controle_id AS approach_controle_id_20,
  t0.approach_factory_recipe_id AS approach_factory_recipe_id_21
FROM
  approach_paragraph t0
WHERE
  t0.approach_controle_id = ?

SELECT t0.id AS id_1, t0.sub_title_fr AS sub_title_fr_2, t0.sub_title_en AS sub_title_en_3, t0.title_fr AS title_fr_4, t0.title_en AS title_en_5, t0.paragraph_fr AS paragraph_fr_6, t0.paragraph_en AS paragraph_en_7, t0.cta_link AS cta_link_8, t0.cta_text_fr AS cta_text_fr_9, t0.cta_text_en AS cta_text_en_10, t0.cta_external AS cta_external_11, t0.image_name AS image_name_12, t0.image_size AS image_size_13, t0.image_updated_at AS image_updated_at_14, t0.image_alt_fr AS image_alt_fr_15, t0.image_alt_en AS image_alt_en_16, t0.url_youtube_original AS url_youtube_original_17, t0.url_youtube_embed AS url_youtube_embed_18, t0.approach_production_id AS approach_production_id_19, t0.approach_controle_id AS approach_controle_id_20, t0.approach_factory_recipe_id AS approach_factory_recipe_id_21 FROM approach_paragraph t0 WHERE t0.approach_controle_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 659)
9	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
10	Twig\Template->yieldBlock (line 161)
11	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
12	Twig\Template->yield (line 58)
13	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
16	Twig\Template->yield (line 354)
17	Twig\Template->display (line 369)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 306)
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 328)
24	App\Controller\FrontController->approach (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.43 ms
(4.92%)

SELECT t0.id AS id_1, t0.banner_name AS banner_name_2, t0.banner_size AS banner_size_3, t0.banner_updated_at AS banner_updated_at_4, t0.europe_text AS europe_text_5, t0.amerique_text AS amerique_text_6, t0.asie1_text AS asie1_text_7, t0.asie2_text AS asie2_text_8, t0.asie3_text AS asie3_text_9, t0.qatar_text AS qatar_text_10, t0.specific_offers_intro_fr AS specific_offers_intro_fr_11, t0.specific_offers_intro_en AS specific_offers_intro_en_12, t0.h1 AS h1_13, t0.h1_en AS h1_en_14, t0.meta_title_en AS meta_title_en_15, t0.meta_description_en AS meta_description_en_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18 FROM approach t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.banner_name AS banner_name_2,
  t0.banner_size AS banner_size_3,
  t0.banner_updated_at AS banner_updated_at_4,
  t0.europe_text AS europe_text_5,
  t0.amerique_text AS amerique_text_6,
  t0.asie1_text AS asie1_text_7,
  t0.asie2_text AS asie2_text_8,
  t0.asie3_text AS asie3_text_9,
  t0.qatar_text AS qatar_text_10,
  t0.specific_offers_intro_fr AS specific_offers_intro_fr_11,
  t0.specific_offers_intro_en AS specific_offers_intro_en_12,
  t0.h1 AS h1_13,
  t0.h1_en AS h1_en_14,
  t0.meta_title_en AS meta_title_en_15,
  t0.meta_description_en AS meta_description_en_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18
FROM
  approach t0

SELECT t0.id AS id_1, t0.banner_name AS banner_name_2, t0.banner_size AS banner_size_3, t0.banner_updated_at AS banner_updated_at_4, t0.europe_text AS europe_text_5, t0.amerique_text AS amerique_text_6, t0.asie1_text AS asie1_text_7, t0.asie2_text AS asie2_text_8, t0.asie3_text AS asie3_text_9, t0.qatar_text AS qatar_text_10, t0.specific_offers_intro_fr AS specific_offers_intro_fr_11, t0.specific_offers_intro_en AS specific_offers_intro_en_12, t0.h1 AS h1_13, t0.h1_en AS h1_en_14, t0.meta_title_en AS meta_title_en_15, t0.meta_description_en AS meta_description_en_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18 FROM approach t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 19)
5	Cofondateur\SocleTechniqueBundle\Repository\LoneEntityRepository->findUnique (line 326)
6	App\Controller\FrontController->approach (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.43 ms
(4.88%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 41)
5	Cofondateur\SocleTechniqueBundle\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.40 ms
(4.59%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.approach_id AS approach_id_6 FROM approach_specific_offer t0 WHERE t0.approach_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.description_fr AS description_fr_4,
  t0.description_en AS description_en_5,
  t0.approach_id AS approach_id_6
FROM
  approach_specific_offer t0
WHERE
  t0.approach_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.approach_id AS approach_id_6 FROM approach_specific_offer t0 WHERE t0.approach_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1039)
9	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
10	Twig\Template->yieldBlock (line 161)
11	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
12	Twig\Template->yield (line 58)
13	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
16	Twig\Template->yield (line 354)
17	Twig\Template->display (line 369)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 306)
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 328)
24	App\Controller\FrontController->approach (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.39 ms
(4.48%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.legend AS legend_7, t0.approach_specific_offer_id AS approach_specific_offer_id_8 FROM approach_specific_offer_images t0 WHERE t0.approach_specific_offer_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_updated_at AS image_updated_at_4,
  t0.image_alt_fr AS image_alt_fr_5,
  t0.image_alt_en AS image_alt_en_6,
  t0.legend AS legend_7,
  t0.approach_specific_offer_id AS approach_specific_offer_id_8
FROM
  approach_specific_offer_images t0
WHERE
  t0.approach_specific_offer_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.legend AS legend_7, t0.approach_specific_offer_id AS approach_specific_offer_id_8 FROM approach_specific_offer_images t0 WHERE t0.approach_specific_offer_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1097)
8	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->block_body (line 442)
9	Twig\Template->yieldBlock (line 161)
10	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
11	Twig\Template->yield (line 58)
12	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_bb3b9d2cd51dec442cee0bb0f52c49ca->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
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 328)
23	App\Controller\FrontController->approach (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
Cofondateur\SocleTechniqueBundle\Entity\SEOPage	No errors.
App\Entity\SEOPage	No errors.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\Approach	The association App\Entity\Approach#asie1Documentations refers to the inverse side field App\Entity\Documentation#approachAsie1 which does not exist.
App\Entity\Documentation	The mappings App\Entity\Documentation#approachAsi1 and App\Entity\Approach#asie1Documentations are inconsistent with each other.
App\Entity\ApproachParagraph	No errors.
App\Entity\ApproachSpecificOffer	No errors.
App\Entity\Application	No errors.
App\Entity\Achievement	No errors.
App\Entity\Product	No errors.
App\Entity\DownloadProduct	No errors.
App\Entity\DocumentationCategory	No errors.
App\Entity\DownloadDocumentation	No errors.
App\Entity\ApproachSpecificOfferImages	No errors.

Symfony Profiler

GET https://ravanat-new.asb-digital.fr/fr/demarche

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping