Symfony Profiler

Query Metrics

13 Database Queries

8 Different statements

3.43 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.66 ms
(19.29%)

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM documentation_category t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2,
  t0.name_en AS name_en_3
FROM
  documentation_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3 FROM documentation_category t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\DocumentationCategory::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\DocumentationCategory->__get (line 72)
8	App\Entity\DocumentationCategory->getName (line 1740)
9	Twig\Extension\CoreExtension::getAttribute (line 100)
10	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->block__download_documentation_documentations_row (line 442)
11	Twig\Template->yieldBlock (line 146)
12	Twig\Template->displayBlock (line 48)
13	Symfony\Bridge\Twig\Form\TwigRendererEngine->renderBlock (line 243)
14	Symfony\Component\Form\FormRenderer->searchAndRenderBlock (line 1832)
15	__TwigTemplate_014926622f027291ada462d1a0870992->block_form_rest (line 442)
16	Twig\Template->yieldBlock (line 146)
17	Twig\Template->displayBlock (line 48)
18	Symfony\Bridge\Twig\Form\TwigRendererEngine->renderBlock (line 243)
19	Symfony\Component\Form\FormRenderer->searchAndRenderBlock (line 80)
20	__TwigTemplate_08ae2f1c94238cb0beba6d6ee6577d50->doDisplay (line 398)
21	Twig\Template->yield (line 232)
22	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->block_body (line 442)
23	Twig\Template->yieldBlock (line 161)
24	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
25	Twig\Template->yield (line 58)
26	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
27	Twig\Template->yield (line 59)
28	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->doDisplay (line 398)
29	Twig\Template->yield (line 354)
30	Twig\Template->display (line 369)
31	Twig\Template->render (line 38)
32	Twig\TemplateWrapper->render (line 306)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 416)
37	App\Controller\FrontController->documentations (line 178)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.59 ms
(17.12%)

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 59)
18	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->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 416)
27	App\Controller\FrontController->documentations (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.52 ms
(15.16%)

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 59)
18	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->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 416)
27	App\Controller\FrontController->documentations (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.50 ms
(14.58%)

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_documentations"
]

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_documentations' 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.36 ms
(10.50%)

SELECT d0_.id AS id_0, d0_.title_fr AS title_fr_1, d0_.title_en AS title_en_2, d0_.description_fr AS description_fr_3, d0_.description_en AS description_en_4, d0_.doc_name AS doc_name_5, d0_.doc_size AS doc_size_6, d0_.doc_updated_at AS doc_updated_at_7, d0_.doc_en_name AS doc_en_name_8, d0_.doc_en_size AS doc_en_size_9, d0_.doc_en_updated_at AS doc_en_updated_at_10, d0_.image_name AS image_name_11, d0_.image_size AS image_size_12, d0_.image_updated_at AS image_updated_at_13, d0_.image_alt_fr AS image_alt_fr_14, d0_.image_alt_en AS image_alt_en_15, d0_.position AS position_16, d0_.documentation_category_id AS documentation_category_id_17 FROM documentation d0_ ORDER BY d0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.title_fr AS title_fr_1,
  d0_.title_en AS title_en_2,
  d0_.description_fr AS description_fr_3,
  d0_.description_en AS description_en_4,
  d0_.doc_name AS doc_name_5,
  d0_.doc_size AS doc_size_6,
  d0_.doc_updated_at AS doc_updated_at_7,
  d0_.doc_en_name AS doc_en_name_8,
  d0_.doc_en_size AS doc_en_size_9,
  d0_.doc_en_updated_at AS doc_en_updated_at_10,
  d0_.image_name AS image_name_11,
  d0_.image_size AS image_size_12,
  d0_.image_updated_at AS image_updated_at_13,
  d0_.image_alt_fr AS image_alt_fr_14,
  d0_.image_alt_en AS image_alt_en_15,
  d0_.position AS position_16,
  d0_.documentation_category_id AS documentation_category_id_17
FROM
  documentation d0_
ORDER BY
  d0_.position ASC

SELECT d0_.id AS id_0, d0_.title_fr AS title_fr_1, d0_.title_en AS title_en_2, d0_.description_fr AS description_fr_3, d0_.description_en AS description_en_4, d0_.doc_name AS doc_name_5, d0_.doc_size AS doc_size_6, d0_.doc_updated_at AS doc_updated_at_7, d0_.doc_en_name AS doc_en_name_8, d0_.doc_en_size AS doc_en_size_9, d0_.doc_en_updated_at AS doc_en_updated_at_10, d0_.image_name AS image_name_11, d0_.image_size AS image_size_12, d0_.image_updated_at AS image_updated_at_13, d0_.image_alt_fr AS image_alt_fr_14, d0_.image_alt_en AS image_alt_en_15, d0_.position AS position_16, d0_.documentation_category_id AS documentation_category_id_17 FROM documentation d0_ ORDER BY d0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 453)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 82)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 99)
15	Symfony\Component\Form\ResolvedFormType->buildForm (line 76)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 97)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 76)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 85)
20	Symfony\Component\Form\FormBuilder->create (line 212)
21	Symfony\Component\Form\FormBuilder->resolveChildren (line 165)
22	Symfony\Component\Form\FormBuilder->getForm (line 28)
23	Symfony\Component\Form\FormFactory->create (line 323)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 369)
25	App\Controller\FrontController->documentations (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.29 ms
(8.46%)

SELECT d0_.id AS id_0, d0_.title_fr AS title_fr_1, d0_.title_en AS title_en_2, d0_.description_fr AS description_fr_3, d0_.description_en AS description_en_4, d0_.doc_name AS doc_name_5, d0_.doc_size AS doc_size_6, d0_.doc_updated_at AS doc_updated_at_7, d0_.doc_en_name AS doc_en_name_8, d0_.doc_en_size AS doc_en_size_9, d0_.doc_en_updated_at AS doc_en_updated_at_10, d0_.image_name AS image_name_11, d0_.image_size AS image_size_12, d0_.image_updated_at AS image_updated_at_13, d0_.image_alt_fr AS image_alt_fr_14, d0_.image_alt_en AS image_alt_en_15, d0_.position AS position_16, d0_.documentation_category_id AS documentation_category_id_17 FROM documentation d0_ WHERE d0_.id IS NOT NULL ORDER BY d0_.documentation_category_id ASC, d0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.title_fr AS title_fr_1,
  d0_.title_en AS title_en_2,
  d0_.description_fr AS description_fr_3,
  d0_.description_en AS description_en_4,
  d0_.doc_name AS doc_name_5,
  d0_.doc_size AS doc_size_6,
  d0_.doc_updated_at AS doc_updated_at_7,
  d0_.doc_en_name AS doc_en_name_8,
  d0_.doc_en_size AS doc_en_size_9,
  d0_.doc_en_updated_at AS doc_en_updated_at_10,
  d0_.image_name AS image_name_11,
  d0_.image_size AS image_size_12,
  d0_.image_updated_at AS image_updated_at_13,
  d0_.image_alt_fr AS image_alt_fr_14,
  d0_.image_alt_en AS image_alt_en_15,
  d0_.position AS position_16,
  d0_.documentation_category_id AS documentation_category_id_17
FROM
  documentation d0_
WHERE
  d0_.id IS NOT NULL
ORDER BY
  d0_.documentation_category_id ASC,
  d0_.position ASC

SELECT d0_.id AS id_0, d0_.title_fr AS title_fr_1, d0_.title_en AS title_en_2, d0_.description_fr AS description_fr_3, d0_.description_en AS description_en_4, d0_.doc_name AS doc_name_5, d0_.doc_size AS doc_size_6, d0_.doc_updated_at AS doc_updated_at_7, d0_.doc_en_name AS doc_en_name_8, d0_.doc_en_size AS doc_en_size_9, d0_.doc_en_updated_at AS doc_en_updated_at_10, d0_.image_name AS image_name_11, d0_.image_size AS image_size_12, d0_.image_updated_at AS image_updated_at_13, d0_.image_alt_fr AS image_alt_fr_14, d0_.image_alt_en AS image_alt_en_15, d0_.position AS position_16, d0_.documentation_category_id AS documentation_category_id_17 FROM documentation d0_ WHERE d0_.id IS NOT NULL ORDER BY d0_.documentation_category_id ASC, d0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 166)
7	App\Repository\DocumentationRepository->search (line 139)
8	App\Services\AppService->getDocumentations (line 84)
9	App\Twig\AppExtension->getDocumentations (line 87)
10	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->block__download_documentation_documentations_row (line 442)
11	Twig\Template->yieldBlock (line 146)
12	Twig\Template->displayBlock (line 48)
13	Symfony\Bridge\Twig\Form\TwigRendererEngine->renderBlock (line 243)
14	Symfony\Component\Form\FormRenderer->searchAndRenderBlock (line 1832)
15	__TwigTemplate_014926622f027291ada462d1a0870992->block_form_rest (line 442)
16	Twig\Template->yieldBlock (line 146)
17	Twig\Template->displayBlock (line 48)
18	Symfony\Bridge\Twig\Form\TwigRendererEngine->renderBlock (line 243)
19	Symfony\Component\Form\FormRenderer->searchAndRenderBlock (line 80)
20	__TwigTemplate_08ae2f1c94238cb0beba6d6ee6577d50->doDisplay (line 398)
21	Twig\Template->yield (line 232)
22	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->block_body (line 442)
23	Twig\Template->yieldBlock (line 161)
24	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
25	Twig\Template->yield (line 58)
26	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
27	Twig\Template->yield (line 59)
28	__TwigTemplate_a4481d1e0455e9f09a8e678db0670a4b->doDisplay (line 398)
29	Twig\Template->yield (line 354)
30	Twig\Template->display (line 369)
31	Twig\Template->render (line 38)
32	Twig\TemplateWrapper->render (line 306)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 416)
37	App\Controller\FrontController->documentations (line 178)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.28 ms
(8.08%)

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.23 ms
(6.80%)

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.h1 AS h1_5, t0.h1_en AS h1_en_6, t0.meta_title_en AS meta_title_en_7, t0.meta_description_en AS meta_description_en_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10 FROM documentation_page 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.h1 AS h1_5,
  t0.h1_en AS h1_en_6,
  t0.meta_title_en AS meta_title_en_7,
  t0.meta_description_en AS meta_description_en_8,
  t0.meta_title AS meta_title_9,
  t0.meta_description AS meta_description_10
FROM
  documentation_page 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.h1 AS h1_5, t0.h1_en AS h1_en_6, t0.meta_title_en AS meta_title_en_7, t0.meta_description_en AS meta_description_en_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10 FROM documentation_page 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 366)
6	App\Controller\FrontController->documentations (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)

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\DocumentationPage	No errors.
App\Entity\Documentation	The mappings App\Entity\Documentation#approachAsi1 and App\Entity\Approach#asie1Documentations are inconsistent with each other.
App\Entity\DocumentationCategory	No errors.
App\Entity\DownloadDocumentation	No errors.
App\Entity\Product	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\Application	No errors.
App\Entity\Achievement	No errors.
App\Entity\DownloadProduct	No errors.

Symfony Profiler

GET https://ravanat-new.asb-digital.fr/en/documentation

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping