Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.03 ms Query time

1 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.41 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.show_on_home_page AS show_on_home_page_5, t0.total_trainings AS total_trainings_6, t0.slug AS slug_7, t0.content AS content_8, t0.content2 AS content2_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_canonical AS seo_canonical_12, t0.seo_indexed AS seo_indexed_13, t0.place_id AS place_id_14 FROM listing_page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "formations-autocad-eligibles-cpf-opco-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.updated_at AS updated_at_4,
  t0.show_on_home_page AS show_on_home_page_5,
  t0.total_trainings AS total_trainings_6,
  t0.slug AS slug_7,
  t0.content AS content_8,
  t0.content2 AS content2_9,
  t0.seo_title AS seo_title_10,
  t0.seo_description AS seo_description_11,
  t0.seo_canonical AS seo_canonical_12,
  t0.seo_indexed AS seo_indexed_13,
  t0.place_id AS place_id_14
FROM
  listing_page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.show_on_home_page AS show_on_home_page_5, t0.total_trainings AS total_trainings_6, t0.slug AS slug_7, t0.content AS content_8, t0.content2 AS content2_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_canonical AS seo_canonical_12, t0.seo_indexed AS seo_indexed_13, t0.place_id AS place_id_14 FROM listing_page t0 WHERE t0.slug = 'formations-autocad-eligibles-cpf-opco-1' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require (line 7)

0.28 ms

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.pdf_name AS pdf_name_4, t0.pdf_mime_type AS pdf_mime_type_5, t0.updated_at AS updated_at_6, t0.show_on_home_page AS show_on_home_page_7, t0.featured_on_search AS featured_on_search_8, t0.price AS price_9, t0.cpf AS cpf_10, t0.collective_face_to_face_hours AS collective_face_to_face_hours_11, t0.individual_face_to_face_hours AS individual_face_to_face_hours_12, t0.individual_videoconference_hours AS individual_videoconference_hours_13, t0.collective_videoconference_hours AS collective_videoconference_hours_14, t0.elearning_hours AS elearning_hours_15, t0.format AS format_16, t0.description AS description_17, t0.min_period AS min_period_18, t0.max_period AS max_period_19, t0.public AS public_20, t0.prerequisites AS prerequisites_21, t0.code AS code_22, t0.face_to_face_hours_text AS face_to_face_hours_text_23, t0.satisfaction_rate AS satisfaction_rate_24, t0.cpf_link AS cpf_link_25, t0.completion_rate AS completion_rate_26, t0.slug_history AS slug_history_27, t0.sub_title AS sub_title_28, t0.pixels AS pixels_29, t0.status AS status_30, t0.seo_title AS seo_title_31, t0.seo_description AS seo_description_32, t0.seo_canonical AS seo_canonical_33, t0.seo_indexed AS seo_indexed_34, t0.certification_id AS certification_id_35, t0.category_id AS category_id_36, t0.created_by_id AS created_by_id_37 FROM training t0 INNER JOIN listing_page_training ON t0.id = listing_page_training.training_id WHERE listing_page_training.listing_page_id = ?

Parameters:

[
  82
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.pdf_name AS pdf_name_4,
  t0.pdf_mime_type AS pdf_mime_type_5,
  t0.updated_at AS updated_at_6,
  t0.show_on_home_page AS show_on_home_page_7,
  t0.featured_on_search AS featured_on_search_8,
  t0.price AS price_9,
  t0.cpf AS cpf_10,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_11,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_12,
  t0.individual_videoconference_hours AS individual_videoconference_hours_13,
  t0.collective_videoconference_hours AS collective_videoconference_hours_14,
  t0.elearning_hours AS elearning_hours_15,
  t0.format AS format_16,
  t0.description AS description_17,
  t0.min_period AS min_period_18,
  t0.max_period AS max_period_19,
  t0.public AS public_20,
  t0.prerequisites AS prerequisites_21,
  t0.code AS code_22,
  t0.face_to_face_hours_text AS face_to_face_hours_text_23,
  t0.satisfaction_rate AS satisfaction_rate_24,
  t0.cpf_link AS cpf_link_25,
  t0.completion_rate AS completion_rate_26,
  t0.slug_history AS slug_history_27,
  t0.sub_title AS sub_title_28,
  t0.pixels AS pixels_29,
  t0.status AS status_30,
  t0.seo_title AS seo_title_31,
  t0.seo_description AS seo_description_32,
  t0.seo_canonical AS seo_canonical_33,
  t0.seo_indexed AS seo_indexed_34,
  t0.certification_id AS certification_id_35,
  t0.category_id AS category_id_36,
  t0.created_by_id AS created_by_id_37
FROM
  training t0
  INNER JOIN listing_page_training ON t0.id = listing_page_training.training_id
WHERE
  listing_page_training.listing_page_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.pdf_name AS pdf_name_4, t0.pdf_mime_type AS pdf_mime_type_5, t0.updated_at AS updated_at_6, t0.show_on_home_page AS show_on_home_page_7, t0.featured_on_search AS featured_on_search_8, t0.price AS price_9, t0.cpf AS cpf_10, t0.collective_face_to_face_hours AS collective_face_to_face_hours_11, t0.individual_face_to_face_hours AS individual_face_to_face_hours_12, t0.individual_videoconference_hours AS individual_videoconference_hours_13, t0.collective_videoconference_hours AS collective_videoconference_hours_14, t0.elearning_hours AS elearning_hours_15, t0.format AS format_16, t0.description AS description_17, t0.min_period AS min_period_18, t0.max_period AS max_period_19, t0.public AS public_20, t0.prerequisites AS prerequisites_21, t0.code AS code_22, t0.face_to_face_hours_text AS face_to_face_hours_text_23, t0.satisfaction_rate AS satisfaction_rate_24, t0.cpf_link AS cpf_link_25, t0.completion_rate AS completion_rate_26, t0.slug_history AS slug_history_27, t0.sub_title AS sub_title_28, t0.pixels AS pixels_29, t0.status AS status_30, t0.seo_title AS seo_title_31, t0.seo_description AS seo_description_32, t0.seo_canonical AS seo_canonical_33, t0.seo_indexed AS seo_indexed_34, t0.certification_id AS certification_id_35, t0.category_id AS category_id_36, t0.created_by_id AS created_by_id_37 FROM training t0 INNER JOIN listing_page_training ON t0.id = listing_page_training.training_id WHERE listing_page_training.listing_page_id = 82;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 45)
9	App\Controller\ListingPage\ListingPageController->buildRelatedArticle (line 36)
10	App\Controller\ListingPage\ListingPageController->__invoke (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require (line 7)

0.13 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 INNER JOIN listing_page_training_category ON t0.id = listing_page_training_category.training_category_id WHERE listing_page_training_category.listing_page_id = ?

Parameters:

[
  82
]

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.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
  INNER JOIN listing_page_training_category ON t0.id = listing_page_training_category.training_category_id
WHERE
  listing_page_training_category.listing_page_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 INNER JOIN listing_page_training_category ON t0.id = listing_page_training_category.training_category_id WHERE listing_page_training_category.listing_page_id = 82;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 46)
9	App\Controller\ListingPage\ListingPageController->buildRelatedArticle (line 36)
10	App\Controller\ListingPage\ListingPageController->__invoke (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require (line 7)

0.22 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = ?

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.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 49)
5	App\Twig\Runtime\MenuExtensionRuntime->getCmsPages (line 179)
6	__TwigTemplate_c075e72bad17f8ebc2a69dec01d7de26->doDisplay (line 393)
7	Twig\Template->yield (line 106)
8	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
9	Twig\Template->yield (line 55)
10	__TwigTemplate_a624659ea50279da20dc5515701b20a4->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
19	App\Controller\ListingPage\ListingPageController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require (line 7)

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\ListingPage	1

Entities Mapping

Class	Mapping errors
App\Entity\ListingPage	No errors.
App\Entity\Place	No errors.
App\Entity\Training	The association App\Entity\Training#createdBy refers to the inverse side field App\Entity\User#trainings which does not exist.
App\Entity\TrainingCategory	No errors.
App\Entity\Certification	No errors.
App\Entity\User	No errors.
App\Entity\Cms\CmsPage	No errors.

Symfony Profiler

GET https://preprod-website.kaza-senza.com/page/formations-autocad-eligibles-cpf-opco-1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping