Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.74 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.55 ms
(19.97%)

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

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_article_show' 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.55 ms
(19.93%)

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.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.updated_by_id AS updated_by_id_14, t0.created_by_id AS created_by_id_15, t0.article_category_id AS article_category_id_16 FROM article t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "le-projet-pedagogique-se-precise"
]

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.meta_title AS meta_title_9,
  t0.meta_description AS meta_description_10,
  t0.slug AS slug_11,
  t0.updated_at AS updated_at_12,
  t0.created_at AS created_at_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.article_category_id AS article_category_id_16
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

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.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.updated_by_id AS updated_by_id_14, t0.created_by_id AS created_by_id_15, t0.article_category_id AS article_category_id_16 FROM article t0 WHERE t0.slug = 'le-projet-pedagogique-se-precise' 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 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.45 ms
(16.54%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM article_category t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  article_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM article_category t0 WHERE t0.id = 2;

#	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\ArticleCategory::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\ArticleCategory->__get (line 44)
8	App\Entity\ArticleCategory->getName (line 1740)
9	Twig\Extension\CoreExtension::getAttribute (line 146)
10	__TwigTemplate_e64b01b9cd341191a0f1b619710d3b2c->block_body (line 442)
11	Twig\Template->yieldBlock (line 161)
12	__TwigTemplate_dbee90b237dd5c9606421d1c0cb8e2f1->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_1c5b35e503ca5dd112bc0de2726975ed->doDisplay (line 398)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_e64b01b9cd341191a0f1b619710d3b2c->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 154)
25	App\Controller\FrontController->showArticle (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.44 ms
(16.06%)

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, t0.schedules_days AS schedules_days_20, t0.schedules_hours AS schedules_hours_21 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,
  t0.schedules_days AS schedules_days_20,
  t0.schedules_hours AS schedules_hours_21
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, t0.schedules_days AS schedules_days_20, t0.schedules_hours AS schedules_hours_21 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.39 ms
(14.10%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.picture_name AS picture_name_4, t0.picture_size AS picture_size_5, t0.picture_updated_at AS picture_updated_at_6, t0.picture_alt AS picture_alt_7, t0.article_id AS article_id_8 FROM article_paragraph t0 WHERE t0.article_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.picture_name AS picture_name_4,
  t0.picture_size AS picture_size_5,
  t0.picture_updated_at AS picture_updated_at_6,
  t0.picture_alt AS picture_alt_7,
  t0.article_id AS article_id_8
FROM
  article_paragraph t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.picture_name AS picture_name_4, t0.picture_size AS picture_size_5, t0.picture_updated_at AS picture_updated_at_6, t0.picture_alt AS picture_alt_7, t0.article_id AS article_id_8 FROM article_paragraph t0 WHERE t0.article_id = 2;

#	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 183)
9	__TwigTemplate_e64b01b9cd341191a0f1b619710d3b2c->block_body (line 442)
10	Twig\Template->yieldBlock (line 161)
11	__TwigTemplate_dbee90b237dd5c9606421d1c0cb8e2f1->doDisplay (line 398)
12	Twig\Template->yield (line 56)
13	__TwigTemplate_1c5b35e503ca5dd112bc0de2726975ed->doDisplay (line 398)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_e64b01b9cd341191a0f1b619710d3b2c->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 154)
24	App\Controller\FrontController->showArticle (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.37 ms
(13.40%)

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.position AS position_6, t0.article_id AS article_id_7 FROM article_gallery_item t0 WHERE t0.article_id = ?

Parameters:

[
  2
]

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.position AS position_6,
  t0.article_id AS article_id_7
FROM
  article_gallery_item t0
WHERE
  t0.article_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.position AS position_6, t0.article_id AS article_id_7 FROM article_gallery_item t0 WHERE t0.article_id = 2;

#	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 247)
10	__TwigTemplate_e64b01b9cd341191a0f1b619710d3b2c->block_body (line 442)
11	Twig\Template->yieldBlock (line 161)
12	__TwigTemplate_dbee90b237dd5c9606421d1c0cb8e2f1->doDisplay (line 398)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_1c5b35e503ca5dd112bc0de2726975ed->doDisplay (line 398)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_e64b01b9cd341191a0f1b619710d3b2c->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 154)
25	App\Controller\FrontController->showArticle (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)

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.
Cofondateur\SocleTechniqueBundle\Entity\Blog\Article	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\User' specified on Cofondateur\SocleTechniqueBundle\Entity\Blog\Article#updatedBy is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Blog\Article	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\User' specified on App\Entity\Blog\Article#updatedBy is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Cofondateur\SocleTechniqueBundle\Entity\User	No errors.
App\Entity\ArticleCategory	No errors.
Cofondateur\SocleTechniqueBundle\Entity\Blog\ArticleParagraph	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\Blog\Article' specified on Cofondateur\SocleTechniqueBundle\Entity\Blog\ArticleParagraph#article is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Blog\ArticleParagraph	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\Blog\Article' specified on App\Entity\Blog\ArticleParagraph#article is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\ArticleGalleryItem	No errors.

Symfony Profiler

GET https://develop.la-vallee-enchantee.fr/actualite/le-projet-pedagogique-se-precise

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping