Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

4.46 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.00 ms
(22.36%)

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_1102f5d56c0b2563a2e30ff6e7384826->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 156)
27	App\Controller\FrontController->whoAreWe (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.98 ms
(22.03%)

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_1102f5d56c0b2563a2e30ff6e7384826->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 156)
27	App\Controller\FrontController->whoAreWe (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.54 ms
(11.99%)

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

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_who_are_we' 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.46 ms
(10.26%)

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 AS image_alt_5, t0.title_fr AS title_fr_6, t0.title_en AS title_en_7, t0.text_fr AS text_fr_8, t0.text_en AS text_en_9, t0.cta_link_fr AS cta_link_fr_10, t0.cta_link_en AS cta_link_en_11, t0.cta_text_fr AS cta_text_fr_12, t0.cta_text_en AS cta_text_en_13, t0.cta_external_fr AS cta_external_fr_14, t0.cta_external_en AS cta_external_en_15, t0.who_we_are_our_values_id AS who_we_are_our_values_id_16, t0.who_we_are_id AS who_we_are_id_17 FROM who_we_are_paragraph t0 WHERE t0.who_we_are_our_values_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 AS image_alt_5,
  t0.title_fr AS title_fr_6,
  t0.title_en AS title_en_7,
  t0.text_fr AS text_fr_8,
  t0.text_en AS text_en_9,
  t0.cta_link_fr AS cta_link_fr_10,
  t0.cta_link_en AS cta_link_en_11,
  t0.cta_text_fr AS cta_text_fr_12,
  t0.cta_text_en AS cta_text_en_13,
  t0.cta_external_fr AS cta_external_fr_14,
  t0.cta_external_en AS cta_external_en_15,
  t0.who_we_are_our_values_id AS who_we_are_our_values_id_16,
  t0.who_we_are_id AS who_we_are_id_17
FROM
  who_we_are_paragraph t0
WHERE
  t0.who_we_are_our_values_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 AS image_alt_5, t0.title_fr AS title_fr_6, t0.title_en AS title_en_7, t0.text_fr AS text_fr_8, t0.text_en AS text_en_9, t0.cta_link_fr AS cta_link_fr_10, t0.cta_link_en AS cta_link_en_11, t0.cta_text_fr AS cta_text_fr_12, t0.cta_text_en AS cta_text_en_13, t0.cta_external_fr AS cta_external_fr_14, t0.cta_external_en AS cta_external_en_15, t0.who_we_are_our_values_id AS who_we_are_our_values_id_16, t0.who_we_are_id AS who_we_are_id_17 FROM who_we_are_paragraph t0 WHERE t0.who_we_are_our_values_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 159)
9	__TwigTemplate_1102f5d56c0b2563a2e30ff6e7384826->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_1102f5d56c0b2563a2e30ff6e7384826->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 156)
24	App\Controller\FrontController->whoAreWe (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
(9.54%)

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.histo_title_fr AS histo_title_fr_5, t0.histo_title_en AS histo_title_en_6, t0.histo_text_fr AS histo_text_fr_7, t0.histo_text_en AS histo_text_en_8, t0.histo_image1_name AS histo_image1_name_9, t0.histo_image1_size AS histo_image1_size_10, t0.histo_image1_updated_at AS histo_image1_updated_at_11, t0.histo_image1_alt AS histo_image1_alt_12, t0.histo_image2_name AS histo_image2_name_13, t0.histo_image2_size AS histo_image2_size_14, t0.histo_image2_updated_at AS histo_image2_updated_at_15, t0.histo_image2_alt AS histo_image2_alt_16, t0.our_values_title_fr AS our_values_title_fr_17, t0.our_values_title_en AS our_values_title_en_18, t0.our_values_description_fr AS our_values_description_fr_19, t0.our_values_description_en AS our_values_description_en_20, t0.skill_title_fr AS skill_title_fr_21, t0.skill_title_en AS skill_title_en_22, t0.skill_description_fr AS skill_description_fr_23, t0.skill_description_en AS skill_description_en_24, t0.h1 AS h1_25, t0.h1_en AS h1_en_26, t0.meta_title_en AS meta_title_en_27, t0.meta_description_en AS meta_description_en_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30 FROM who_we_are 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.histo_title_fr AS histo_title_fr_5,
  t0.histo_title_en AS histo_title_en_6,
  t0.histo_text_fr AS histo_text_fr_7,
  t0.histo_text_en AS histo_text_en_8,
  t0.histo_image1_name AS histo_image1_name_9,
  t0.histo_image1_size AS histo_image1_size_10,
  t0.histo_image1_updated_at AS histo_image1_updated_at_11,
  t0.histo_image1_alt AS histo_image1_alt_12,
  t0.histo_image2_name AS histo_image2_name_13,
  t0.histo_image2_size AS histo_image2_size_14,
  t0.histo_image2_updated_at AS histo_image2_updated_at_15,
  t0.histo_image2_alt AS histo_image2_alt_16,
  t0.our_values_title_fr AS our_values_title_fr_17,
  t0.our_values_title_en AS our_values_title_en_18,
  t0.our_values_description_fr AS our_values_description_fr_19,
  t0.our_values_description_en AS our_values_description_en_20,
  t0.skill_title_fr AS skill_title_fr_21,
  t0.skill_title_en AS skill_title_en_22,
  t0.skill_description_fr AS skill_description_fr_23,
  t0.skill_description_en AS skill_description_en_24,
  t0.h1 AS h1_25,
  t0.h1_en AS h1_en_26,
  t0.meta_title_en AS meta_title_en_27,
  t0.meta_description_en AS meta_description_en_28,
  t0.meta_title AS meta_title_29,
  t0.meta_description AS meta_description_30
FROM
  who_we_are 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.histo_title_fr AS histo_title_fr_5, t0.histo_title_en AS histo_title_en_6, t0.histo_text_fr AS histo_text_fr_7, t0.histo_text_en AS histo_text_en_8, t0.histo_image1_name AS histo_image1_name_9, t0.histo_image1_size AS histo_image1_size_10, t0.histo_image1_updated_at AS histo_image1_updated_at_11, t0.histo_image1_alt AS histo_image1_alt_12, t0.histo_image2_name AS histo_image2_name_13, t0.histo_image2_size AS histo_image2_size_14, t0.histo_image2_updated_at AS histo_image2_updated_at_15, t0.histo_image2_alt AS histo_image2_alt_16, t0.our_values_title_fr AS our_values_title_fr_17, t0.our_values_title_en AS our_values_title_en_18, t0.our_values_description_fr AS our_values_description_fr_19, t0.our_values_description_en AS our_values_description_en_20, t0.skill_title_fr AS skill_title_fr_21, t0.skill_title_en AS skill_title_en_22, t0.skill_description_fr AS skill_description_fr_23, t0.skill_description_en AS skill_description_en_24, t0.h1 AS h1_25, t0.h1_en AS h1_en_26, t0.meta_title_en AS meta_title_en_27, t0.meta_description_en AS meta_description_en_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30 FROM who_we_are 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 154)
6	App\Controller\FrontController->whoAreWe (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.39 ms
(8.78%)

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 AS image_alt_5, t0.title_fr AS title_fr_6, t0.title_en AS title_en_7, t0.text_fr AS text_fr_8, t0.text_en AS text_en_9, t0.cta_link_fr AS cta_link_fr_10, t0.cta_link_en AS cta_link_en_11, t0.cta_text_fr AS cta_text_fr_12, t0.cta_text_en AS cta_text_en_13, t0.cta_external_fr AS cta_external_fr_14, t0.cta_external_en AS cta_external_en_15, t0.who_we_are_our_values_id AS who_we_are_our_values_id_16, t0.who_we_are_id AS who_we_are_id_17 FROM who_we_are_paragraph t0 WHERE t0.who_we_are_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 AS image_alt_5,
  t0.title_fr AS title_fr_6,
  t0.title_en AS title_en_7,
  t0.text_fr AS text_fr_8,
  t0.text_en AS text_en_9,
  t0.cta_link_fr AS cta_link_fr_10,
  t0.cta_link_en AS cta_link_en_11,
  t0.cta_text_fr AS cta_text_fr_12,
  t0.cta_text_en AS cta_text_en_13,
  t0.cta_external_fr AS cta_external_fr_14,
  t0.cta_external_en AS cta_external_en_15,
  t0.who_we_are_our_values_id AS who_we_are_our_values_id_16,
  t0.who_we_are_id AS who_we_are_id_17
FROM
  who_we_are_paragraph t0
WHERE
  t0.who_we_are_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 AS image_alt_5, t0.title_fr AS title_fr_6, t0.title_en AS title_en_7, t0.text_fr AS text_fr_8, t0.text_en AS text_en_9, t0.cta_link_fr AS cta_link_fr_10, t0.cta_link_en AS cta_link_en_11, t0.cta_text_fr AS cta_text_fr_12, t0.cta_text_en AS cta_text_en_13, t0.cta_external_fr AS cta_external_fr_14, t0.cta_external_en AS cta_external_en_15, t0.who_we_are_our_values_id AS who_we_are_our_values_id_16, t0.who_we_are_id AS who_we_are_id_17 FROM who_we_are_paragraph t0 WHERE t0.who_we_are_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 267)
9	__TwigTemplate_1102f5d56c0b2563a2e30ff6e7384826->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_1102f5d56c0b2563a2e30ff6e7384826->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 156)
24	App\Controller\FrontController->whoAreWe (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.34 ms
(7.66%)

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.position AS position_7, t0.who_we_are_id AS who_we_are_id_8 FROM skill t0 WHERE t0.who_we_are_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.position AS position_7,
  t0.who_we_are_id AS who_we_are_id_8
FROM
  skill t0
WHERE
  t0.who_we_are_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.position AS position_7, t0.who_we_are_id AS who_we_are_id_8 FROM skill t0 WHERE t0.who_we_are_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 1187)
9	Twig\Extension\CoreExtension::length (line 354)
10	__TwigTemplate_1102f5d56c0b2563a2e30ff6e7384826->block_body (line 442)
11	Twig\Template->yieldBlock (line 161)
12	__TwigTemplate_82e8cde62745696c550e25190aa336ab->doDisplay (line 398)
13	Twig\Template->yield (line 58)
14	__TwigTemplate_9f6e1f6469fa6d39196e92144a4e3156->doDisplay (line 398)
15	Twig\Template->yield (line 56)
16	__TwigTemplate_1102f5d56c0b2563a2e30ff6e7384826->doDisplay (line 398)
17	Twig\Template->yield (line 354)
18	Twig\Template->display (line 369)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 156)
25	App\Controller\FrontController->whoAreWe (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.33 ms
(7.37%)

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)

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\WhoWeAre	The mappings App\Entity\WhoWeAre#ourValuesParagraphs and App\Entity\WhoWeAreParagraph#whoWeAreOurValues are inconsistent with each other.
App\Entity\WhoWeAreParagraph	The association App\Entity\WhoWeAreParagraph#whoWeAreOurValues refers to the inverse side field App\Entity\WhoWeAre#ourValuesParagraph which does not exist.
App\Entity\Skill	No errors.
App\Entity\Application	No errors.
App\Entity\Achievement	No errors.
App\Entity\Product	No errors.
App\Entity\Documentation	The mappings App\Entity\Documentation#approachAsi1 and App\Entity\Approach#asie1Documentations are inconsistent with each other.
App\Entity\DownloadProduct	No errors.

Symfony Profiler

GET https://ravanat-new.asb-digital.fr/en/who-we-are

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping