Symfony Profiler

Query Metrics

21 Database Queries

11 Different statements

9.91 ms Query time

1 Invalid entities

37 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.20 ms
(32.24%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_updated_at AS image_updated_at_5, t0.image_alt AS image_alt_6, t0.resume AS resume_7, t0.paragraph_title AS paragraph_title_8, t0.paragraph_description AS paragraph_description_9, t0.strength_left_title AS strength_left_title_10, t0.strength_right_title AS strength_right_title_11, t0.contact_sub_title AS contact_sub_title_12, t0.contact_title AS contact_title_13, t0.contact_text AS contact_text_14, t0.contact_cta_text AS contact_cta_text_15, t0.contact_cta_link AS contact_cta_link_16, t0.contact_cta_external AS contact_cta_external_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.slug AS slug_20, t0.position AS position_21, t0.category_id AS category_id_22 FROM product t0 WHERE t0.category_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.image_size AS image_size_4,
  t0.image_updated_at AS image_updated_at_5,
  t0.image_alt AS image_alt_6,
  t0.resume AS resume_7,
  t0.paragraph_title AS paragraph_title_8,
  t0.paragraph_description AS paragraph_description_9,
  t0.strength_left_title AS strength_left_title_10,
  t0.strength_right_title AS strength_right_title_11,
  t0.contact_sub_title AS contact_sub_title_12,
  t0.contact_title AS contact_title_13,
  t0.contact_text AS contact_text_14,
  t0.contact_cta_text AS contact_cta_text_15,
  t0.contact_cta_link AS contact_cta_link_16,
  t0.contact_cta_external AS contact_cta_external_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.slug AS slug_20,
  t0.position AS position_21,
  t0.category_id AS category_id_22
FROM
  product t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_updated_at AS image_updated_at_5, t0.image_alt AS image_alt_6, t0.resume AS resume_7, t0.paragraph_title AS paragraph_title_8, t0.paragraph_description AS paragraph_description_9, t0.strength_left_title AS strength_left_title_10, t0.strength_right_title AS strength_right_title_11, t0.contact_sub_title AS contact_sub_title_12, t0.contact_title AS contact_title_13, t0.contact_text AS contact_text_14, t0.contact_cta_text AS contact_cta_text_15, t0.contact_cta_link AS contact_cta_link_16, t0.contact_cta_external AS contact_cta_external_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.slug AS slug_20, t0.position AS position_21, t0.category_id AS category_id_22 FROM product t0 WHERE t0.category_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 100)
4	App\Twig\AppExtension->getProducts (line 254)
5	__TwigTemplate_cd473503ffcacadb20166fc3393bd219->block_header (line 431)
6	Twig\Template->yieldBlock (line 57)
7	__TwigTemplate_cd473503ffcacadb20166fc3393bd219->doDisplay (line 387)
8	Twig\Template->yield (line 162)
9	__TwigTemplate_2a1d2afa898b7093c58305eafc05959d->doDisplay (line 387)
10	Twig\Template->yield (line 57)
11	__TwigTemplate_b05e43d7378bfd52a981a58937fc3b43->doDisplay (line 387)
12	Twig\Template->yield (line 53)
13	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
22	App\Controller\FrontController->index (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.86 ms
(18.81%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.resume AS resume_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.image_updated_at AS image_updated_at_7, t0.image_alt AS image_alt_8, t0.sub_title AS sub_title_9, t0.page_title AS page_title_10, t0.description AS description_11, t0.seo_sub_title AS seo_sub_title_12, t0.seo_title AS seo_title_13, t0.seo_text AS seo_text_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.slug AS slug_17 FROM product_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.resume AS resume_4,
  t0.image_name AS image_name_5,
  t0.image_size AS image_size_6,
  t0.image_updated_at AS image_updated_at_7,
  t0.image_alt AS image_alt_8,
  t0.sub_title AS sub_title_9,
  t0.page_title AS page_title_10,
  t0.description AS description_11,
  t0.seo_sub_title AS seo_sub_title_12,
  t0.seo_title AS seo_title_13,
  t0.seo_text AS seo_text_14,
  t0.meta_title AS meta_title_15,
  t0.meta_description AS meta_description_16,
  t0.slug AS slug_17
FROM
  product_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.resume AS resume_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.image_updated_at AS image_updated_at_7, t0.image_alt AS image_alt_8, t0.sub_title AS sub_title_9, t0.page_title AS page_title_10, t0.description AS description_11, t0.seo_sub_title AS seo_sub_title_12, t0.seo_title AS seo_title_13, t0.seo_text AS seo_text_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.slug AS slug_17 FROM product_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 95)
5	App\Twig\AppExtension->getProductCategories (line 233)
6	__TwigTemplate_cd473503ffcacadb20166fc3393bd219->block_header (line 431)
7	Twig\Template->yieldBlock (line 57)
8	__TwigTemplate_cd473503ffcacadb20166fc3393bd219->doDisplay (line 387)
9	Twig\Template->yield (line 162)
10	__TwigTemplate_2a1d2afa898b7093c58305eafc05959d->doDisplay (line 387)
11	Twig\Template->yield (line 57)
12	__TwigTemplate_b05e43d7378bfd52a981a58937fc3b43->doDisplay (line 387)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 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 77)
23	App\Controller\FrontController->index (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.87 ms
(8.80%)

SELECT t0.id AS id_1, t0.color AS color_2, t0.name AS name_3, t0.category_id AS category_id_4 FROM blog_category t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.name AS name_3,
  t0.category_id AS category_id_4
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.color AS color_2, t0.name AS name_3, t0.category_id AS category_id_4 FROM blog_category t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\BlogCategory::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\BlogCategory->__get (line 51)
8	App\Entity\BlogCategory->getColor (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 664)
10	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->block_body (line 431)
11	Twig\Template->yieldBlock (line 167)
12	__TwigTemplate_2a1d2afa898b7093c58305eafc05959d->doDisplay (line 387)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_b05e43d7378bfd52a981a58937fc3b43->doDisplay (line 387)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 320)
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 77)
25	App\Controller\FrontController->index (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.65 ms
(6.60%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.published AS published_4, t0.picture_name AS picture_name_5, t0.picture_size AS picture_size_6, t0.picture_updated_at AS picture_updated_at_7, t0.picture_alt AS picture_alt_8, t0.created_at AS created_at_9, t0.slug AS slug_10, t0.position AS position_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.category_id AS category_id_14 FROM article t0 WHERE t0.published = ? ORDER BY t0.created_at DESC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.summary AS summary_3,
  t0.published AS published_4,
  t0.picture_name AS picture_name_5,
  t0.picture_size AS picture_size_6,
  t0.picture_updated_at AS picture_updated_at_7,
  t0.picture_alt AS picture_alt_8,
  t0.created_at AS created_at_9,
  t0.slug AS slug_10,
  t0.position AS position_11,
  t0.meta_title AS meta_title_12,
  t0.meta_description AS meta_description_13,
  t0.category_id AS category_id_14
FROM
  article t0
WHERE
  t0.published = ?
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.published AS published_4, t0.picture_name AS picture_name_5, t0.picture_size AS picture_size_6, t0.picture_updated_at AS picture_updated_at_7, t0.picture_alt AS picture_alt_8, t0.created_at AS created_at_9, t0.slug AS slug_10, t0.position AS position_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.category_id AS category_id_14 FROM article t0 WHERE t0.published = 1 ORDER BY t0.created_at DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 75)
4	App\Controller\FrontController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.65 ms
(6.56%)

SELECT t0.id AS id_1, t0.about_sub_title AS about_sub_title_2, t0.about_title AS about_title_3, t0.about_text AS about_text_4, t0.about_cta_text AS about_cta_text_5, t0.about_cta_link AS about_cta_link_6, t0.about_cta_external AS about_cta_external_7, t0.about_image1_name AS about_image1_name_8, t0.about_image1_size AS about_image1_size_9, t0.about_image1_updated_at AS about_image1_updated_at_10, t0.about_image1_alt AS about_image1_alt_11, t0.about_image2_name AS about_image2_name_12, t0.about_image2_size AS about_image2_size_13, t0.about_image2_updated_at AS about_image2_updated_at_14, t0.about_image2_alt AS about_image2_alt_15, t0.risk_sub_title AS risk_sub_title_16, t0.risk_title AS risk_title_17, t0.risk_text AS risk_text_18, t0.risk_cta_text1 AS risk_cta_text1_19, t0.risk_cta_link1 AS risk_cta_link1_20, t0.risk_cta_external1 AS risk_cta_external1_21, t0.risk_cta_text2 AS risk_cta_text2_22, t0.risk_cta_link2 AS risk_cta_link2_23, t0.risk_cta_external2 AS risk_cta_external2_24, t0.risk_image1_name AS risk_image1_name_25, t0.risk_image1_size AS risk_image1_size_26, t0.risk_image1_updated_at AS risk_image1_updated_at_27, t0.risk_image1_alt AS risk_image1_alt_28, t0.risk_image2_name AS risk_image2_name_29, t0.risk_image2_size AS risk_image2_size_30, t0.risk_image2_updated_at AS risk_image2_updated_at_31, t0.risk_image2_alt AS risk_image2_alt_32, t0.meta_title AS meta_title_33, t0.meta_description AS meta_description_34 FROM homepage t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.about_sub_title AS about_sub_title_2,
  t0.about_title AS about_title_3,
  t0.about_text AS about_text_4,
  t0.about_cta_text AS about_cta_text_5,
  t0.about_cta_link AS about_cta_link_6,
  t0.about_cta_external AS about_cta_external_7,
  t0.about_image1_name AS about_image1_name_8,
  t0.about_image1_size AS about_image1_size_9,
  t0.about_image1_updated_at AS about_image1_updated_at_10,
  t0.about_image1_alt AS about_image1_alt_11,
  t0.about_image2_name AS about_image2_name_12,
  t0.about_image2_size AS about_image2_size_13,
  t0.about_image2_updated_at AS about_image2_updated_at_14,
  t0.about_image2_alt AS about_image2_alt_15,
  t0.risk_sub_title AS risk_sub_title_16,
  t0.risk_title AS risk_title_17,
  t0.risk_text AS risk_text_18,
  t0.risk_cta_text1 AS risk_cta_text1_19,
  t0.risk_cta_link1 AS risk_cta_link1_20,
  t0.risk_cta_external1 AS risk_cta_external1_21,
  t0.risk_cta_text2 AS risk_cta_text2_22,
  t0.risk_cta_link2 AS risk_cta_link2_23,
  t0.risk_cta_external2 AS risk_cta_external2_24,
  t0.risk_image1_name AS risk_image1_name_25,
  t0.risk_image1_size AS risk_image1_size_26,
  t0.risk_image1_updated_at AS risk_image1_updated_at_27,
  t0.risk_image1_alt AS risk_image1_alt_28,
  t0.risk_image2_name AS risk_image2_name_29,
  t0.risk_image2_size AS risk_image2_size_30,
  t0.risk_image2_updated_at AS risk_image2_updated_at_31,
  t0.risk_image2_alt AS risk_image2_alt_32,
  t0.meta_title AS meta_title_33,
  t0.meta_description AS meta_description_34
FROM
  homepage t0

SELECT t0.id AS id_1, t0.about_sub_title AS about_sub_title_2, t0.about_title AS about_title_3, t0.about_text AS about_text_4, t0.about_cta_text AS about_cta_text_5, t0.about_cta_link AS about_cta_link_6, t0.about_cta_external AS about_cta_external_7, t0.about_image1_name AS about_image1_name_8, t0.about_image1_size AS about_image1_size_9, t0.about_image1_updated_at AS about_image1_updated_at_10, t0.about_image1_alt AS about_image1_alt_11, t0.about_image2_name AS about_image2_name_12, t0.about_image2_size AS about_image2_size_13, t0.about_image2_updated_at AS about_image2_updated_at_14, t0.about_image2_alt AS about_image2_alt_15, t0.risk_sub_title AS risk_sub_title_16, t0.risk_title AS risk_title_17, t0.risk_text AS risk_text_18, t0.risk_cta_text1 AS risk_cta_text1_19, t0.risk_cta_link1 AS risk_cta_link1_20, t0.risk_cta_external1 AS risk_cta_external1_21, t0.risk_cta_text2 AS risk_cta_text2_22, t0.risk_cta_link2 AS risk_cta_link2_23, t0.risk_cta_external2 AS risk_cta_external2_24, t0.risk_image1_name AS risk_image1_name_25, t0.risk_image1_size AS risk_image1_size_26, t0.risk_image1_updated_at AS risk_image1_updated_at_27, t0.risk_image1_alt AS risk_image1_alt_28, t0.risk_image2_name AS risk_image2_name_29, t0.risk_image2_size AS risk_image2_size_30, t0.risk_image2_updated_at AS risk_image2_updated_at_31, t0.risk_image2_alt AS risk_image2_alt_32, t0.meta_title AS meta_title_33, t0.meta_description AS meta_description_34 FROM homepage t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 19)
5	Cofondateur\SocleTechniqueBundle\Repository\LoneEntityRepository->findUnique (line 74)
6	App\Controller\FrontController->index (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.55 ms
(5.57%)

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.text AS text_6, t0.position AS position_7, t0.homepage_id AS homepage_id_8 FROM homepage_about_icon t0 WHERE t0.homepage_id = ? ORDER BY t0.position ASC

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.text AS text_6,
  t0.position AS position_7,
  t0.homepage_id AS homepage_id_8
FROM
  homepage_about_icon t0
WHERE
  t0.homepage_id = ?
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 AS image_alt_5, t0.text AS text_6, t0.position AS position_7, t0.homepage_id AS homepage_id_8 FROM homepage_about_icon t0 WHERE t0.homepage_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
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 258)
9	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->block_body (line 431)
10	Twig\Template->yieldBlock (line 167)
11	__TwigTemplate_2a1d2afa898b7093c58305eafc05959d->doDisplay (line 387)
12	Twig\Template->yield (line 57)
13	__TwigTemplate_b05e43d7378bfd52a981a58937fc3b43->doDisplay (line 387)
14	Twig\Template->yield (line 53)
15	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 77)
24	App\Controller\FrontController->index (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.54 ms
(5.47%)

SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.description AS description_4, t0.paragraph_sub_title AS paragraph_sub_title_5, t0.paragraph_title AS paragraph_title_6, t0.second_paragraph_sub_title AS second_paragraph_sub_title_7, t0.second_paragraph_title AS second_paragraph_title_8, t0.second_paragraph_description AS second_paragraph_description_9, t0.last_section_word AS last_section_word_10, t0.last_section_sub_title AS last_section_sub_title_11, t0.last_section_title AS last_section_title_12, t0.last_section_text AS last_section_text_13, t0.last_section_cta_text AS last_section_cta_text_14, t0.last_section_cta_link AS last_section_cta_link_15, t0.last_section_cta_external AS last_section_cta_external_16, t0.image_name AS image_name_17, t0.image_size AS image_size_18, t0.image_updated_at AS image_updated_at_19, t0.image_alt AS image_alt_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22 FROM security_page t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sub_title AS sub_title_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.paragraph_sub_title AS paragraph_sub_title_5,
  t0.paragraph_title AS paragraph_title_6,
  t0.second_paragraph_sub_title AS second_paragraph_sub_title_7,
  t0.second_paragraph_title AS second_paragraph_title_8,
  t0.second_paragraph_description AS second_paragraph_description_9,
  t0.last_section_word AS last_section_word_10,
  t0.last_section_sub_title AS last_section_sub_title_11,
  t0.last_section_title AS last_section_title_12,
  t0.last_section_text AS last_section_text_13,
  t0.last_section_cta_text AS last_section_cta_text_14,
  t0.last_section_cta_link AS last_section_cta_link_15,
  t0.last_section_cta_external AS last_section_cta_external_16,
  t0.image_name AS image_name_17,
  t0.image_size AS image_size_18,
  t0.image_updated_at AS image_updated_at_19,
  t0.image_alt AS image_alt_20,
  t0.meta_title AS meta_title_21,
  t0.meta_description AS meta_description_22
FROM
  security_page t0

SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.description AS description_4, t0.paragraph_sub_title AS paragraph_sub_title_5, t0.paragraph_title AS paragraph_title_6, t0.second_paragraph_sub_title AS second_paragraph_sub_title_7, t0.second_paragraph_title AS second_paragraph_title_8, t0.second_paragraph_description AS second_paragraph_description_9, t0.last_section_word AS last_section_word_10, t0.last_section_sub_title AS last_section_sub_title_11, t0.last_section_title AS last_section_title_12, t0.last_section_text AS last_section_text_13, t0.last_section_cta_text AS last_section_cta_text_14, t0.last_section_cta_link AS last_section_cta_link_15, t0.last_section_cta_external AS last_section_cta_external_16, t0.image_name AS image_name_17, t0.image_size AS image_size_18, t0.image_updated_at AS image_updated_at_19, t0.image_alt AS image_alt_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22 FROM security_page t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 19)
5	Cofondateur\SocleTechniqueBundle\Repository\LoneEntityRepository->findUnique (line 107)
6	App\Twig\AppExtension->getSecurityPage (line 319)
7	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->block_body (line 431)
8	Twig\Template->yieldBlock (line 167)
9	__TwigTemplate_2a1d2afa898b7093c58305eafc05959d->doDisplay (line 387)
10	Twig\Template->yield (line 57)
11	__TwigTemplate_b05e43d7378bfd52a981a58937fc3b43->doDisplay (line 387)
12	Twig\Template->yield (line 53)
13	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
22	App\Controller\FrontController->index (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.44 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 AS image_alt_5, t0.link AS link_6, t0.position AS position_7 FROM logo_client 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 AS image_alt_5,
  t0.link AS link_6,
  t0.position AS position_7
FROM
  logo_client 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 AS image_alt_5, t0.link AS link_6, t0.position AS position_7 FROM logo_client t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 90)
4	App\Twig\AppExtension->getClients (line 736)
5	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->block_body (line 431)
6	Twig\Template->yieldBlock (line 167)
7	__TwigTemplate_2a1d2afa898b7093c58305eafc05959d->doDisplay (line 387)
8	Twig\Template->yield (line 57)
9	__TwigTemplate_b05e43d7378bfd52a981a58937fc3b43->doDisplay (line 387)
10	Twig\Template->yield (line 53)
11	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 320)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
20	App\Controller\FrontController->index (line 178)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.44 ms
(4.42%)

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 FROM seopage t0 WHERE t0.route = ? LIMIT 1

Parameters:

[
  "app_homepage"
]

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
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 FROM seopage t0 WHERE t0.route = 'app_homepage' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
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.44 ms
(4.40%)

SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.description AS description_4, t0.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.cta_external AS cta_external_7, t0.pagination_legend AS pagination_legend_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.image_updated_at AS image_updated_at_11, t0.image_alt AS image_alt_12, t0.position AS position_13, t0.homepage_id AS homepage_id_14 FROM homepage_slider_slide t0 WHERE t0.homepage_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sub_title AS sub_title_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.cta_text AS cta_text_5,
  t0.cta_link AS cta_link_6,
  t0.cta_external AS cta_external_7,
  t0.pagination_legend AS pagination_legend_8,
  t0.image_name AS image_name_9,
  t0.image_size AS image_size_10,
  t0.image_updated_at AS image_updated_at_11,
  t0.image_alt AS image_alt_12,
  t0.position AS position_13,
  t0.homepage_id AS homepage_id_14
FROM
  homepage_slider_slide t0
WHERE
  t0.homepage_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.description AS description_4, t0.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.cta_external AS cta_external_7, t0.pagination_legend AS pagination_legend_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.image_updated_at AS image_updated_at_11, t0.image_alt AS image_alt_12, t0.position AS position_13, t0.homepage_id AS homepage_id_14 FROM homepage_slider_slide t0 WHERE t0.homepage_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
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 87)
8	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->block_body (line 431)
9	Twig\Template->yieldBlock (line 167)
10	__TwigTemplate_2a1d2afa898b7093c58305eafc05959d->doDisplay (line 387)
11	Twig\Template->yield (line 57)
12	__TwigTemplate_b05e43d7378bfd52a981a58937fc3b43->doDisplay (line 387)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_287c1bc96241d14a176c99ceb8d5a481->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 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 77)
23	App\Controller\FrontController->index (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.26 ms
(2.66%)

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 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\LogoClient	11
App\Entity\Product	8
App\Entity\HomepageAboutIcon	4
App\Entity\Blog\Article	3
App\Entity\BlogCategory	3
App\Entity\ProductCategory	3
App\Entity\HomepageSliderSlide	2
App\Entity\SiteSettings	1
App\Entity\Homepage	1
App\Entity\SecurityPage	1

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\Homepage	No errors.
App\Entity\HomepageSliderSlide	No errors.
App\Entity\HomepageAboutIcon	No errors.
App\Entity\Blog\Article	No errors.
App\Entity\BlogCategory	The association App\Entity\BlogCategory#category refers to the inverse side field App\Entity\BlogCategory#blogs which does not exist.
App\Entity\Blog\ArticleParagraph	No errors.
App\Entity\BlogGalleryItem	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Product	No errors.
App\Entity\ProductGalleryMedia	No errors.
App\Entity\Paragraph	No errors.
App\Entity\ProductDatatable	No errors.
App\Entity\ProductStrengthBullet	No errors.
App\Entity\ProductStrengthParagraph	No errors.
App\Entity\DownloadFile	No errors.
App\Entity\ProductTestimonial	No errors.
App\Entity\SecurityPage	No errors.
App\Entity\LogoClient	No errors.

Symfony Profiler

GET https://stileco.asb-digital.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping