Symfony Profiler

Query Metrics

56 Database Queries

6 Different statements

6.18 ms Query time

1 Invalid entities

1998 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.26 ms
(68.95%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.address AS address_3,
  t0.zip_code AS zip_code_4,
  t0.city AS city_5,
  t0.image_name AS image_name_6,
  t0.updated_at AS updated_at_7,
  t0.phone_number AS phone_number_8,
  t0.information AS information_9,
  t0.amenities AS amenities_10,
  t0.google_map_link AS google_map_link_11
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 367)
5	Proxies\__CG__\App\Entity\Place::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Place->__get (line 100)
8	App\Entity\Place->getSlug (line 100)
9	App\EventSubscriber\SitemapSubscriber->registerTrainingsUrls (line 45)
10	App\EventSubscriber\SitemapSubscriber->populate (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 160)
15	Presta\SitemapBundle\Service\AbstractGenerator->populate (line 56)
16	Presta\SitemapBundle\Service\Generator->fetch (line 71)
17	Presta\SitemapBundle\Controller\SitemapController->sectionAction (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require (line 7)

0.58 ms
(9.32%)

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

Parameters:

[]

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

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;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 137)
6	App\EventSubscriber\SitemapSubscriber->registerCmsPages (line 47)
7	App\EventSubscriber\SitemapSubscriber->populate (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 160)
12	Presta\SitemapBundle\Service\AbstractGenerator->populate (line 56)
13	Presta\SitemapBundle\Service\Generator->fetch (line 71)
14	Presta\SitemapBundle\Controller\SitemapController->sectionAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require (line 7)

0.45 ms
(7.30%)

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

Parameters:

[]

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

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;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 78)
6	App\EventSubscriber\SitemapSubscriber->registerTrainingsUrls (line 45)
7	App\EventSubscriber\SitemapSubscriber->populate (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 160)
12	Presta\SitemapBundle\Service\AbstractGenerator->populate (line 56)
13	Presta\SitemapBundle\Service\Generator->fetch (line 71)
14	Presta\SitemapBundle\Controller\SitemapController->sectionAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require (line 7)

0.38 ms
(6.10%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.seo_title AS seo_title_3, t0.seo_description AS seo_description_4, t0.seo_canonical AS seo_canonical_5, t0.seo_indexed AS seo_indexed_6, t0.training_id AS training_id_7, t0.place_id AS place_id_8 FROM training_city_child t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.seo_title AS seo_title_3,
  t0.seo_description AS seo_description_4,
  t0.seo_canonical AS seo_canonical_5,
  t0.seo_indexed AS seo_indexed_6,
  t0.training_id AS training_id_7,
  t0.place_id AS place_id_8
FROM
  training_city_child t0

SELECT t0.id AS id_1, t0.description AS description_2, t0.seo_title AS seo_title_3, t0.seo_description AS seo_description_4, t0.seo_canonical AS seo_canonical_5, t0.seo_indexed AS seo_indexed_6, t0.training_id AS training_id_7, t0.place_id AS place_id_8 FROM training_city_child t0;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 93)
6	App\EventSubscriber\SitemapSubscriber->registerTrainingsUrls (line 45)
7	App\EventSubscriber\SitemapSubscriber->populate (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 160)
12	Presta\SitemapBundle\Service\AbstractGenerator->populate (line 56)
13	Presta\SitemapBundle\Service\Generator->fetch (line 71)
14	Presta\SitemapBundle\Controller\SitemapController->sectionAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require (line 7)

0.34 ms
(5.46%)

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

Parameters:

[]

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

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;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 119)
6	App\EventSubscriber\SitemapSubscriber->registerListingPagesUrls (line 46)
7	App\EventSubscriber\SitemapSubscriber->populate (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 160)
12	Presta\SitemapBundle\Service\AbstractGenerator->populate (line 56)
13	Presta\SitemapBundle\Service\Generator->fetch (line 71)
14	Presta\SitemapBundle\Controller\SitemapController->sectionAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require (line 7)

0.18 ms
(2.86%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.author AS author_5, t0.summary AS summary_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.state AS state_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_canonical AS seo_canonical_13, t0.seo_indexed AS seo_indexed_14, t0.category_id AS category_id_15 FROM article t0 WHERE t0.state = ?

Parameters:

[
  "ONLINE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image_name AS image_name_4,
  t0.author AS author_5,
  t0.summary AS summary_6,
  t0.content AS content_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.state AS state_10,
  t0.seo_title AS seo_title_11,
  t0.seo_description AS seo_description_12,
  t0.seo_canonical AS seo_canonical_13,
  t0.seo_indexed AS seo_indexed_14,
  t0.category_id AS category_id_15
FROM
  article t0
WHERE
  t0.state = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.author AS author_5, t0.summary AS summary_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.state AS state_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_canonical AS seo_canonical_13, t0.seo_indexed AS seo_indexed_14, t0.category_id AS category_id_15 FROM article t0 WHERE t0.state = 'ONLINE';

#	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 56)
5	App\EventSubscriber\SitemapSubscriber->registerArticlesUrls (line 44)
6	App\EventSubscriber\SitemapSubscriber->populate (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 160)
11	Presta\SitemapBundle\Service\AbstractGenerator->populate (line 56)
12	Presta\SitemapBundle\Service\Generator->fetch (line 71)
13	Presta\SitemapBundle\Controller\SitemapController->sectionAction (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\TrainingCityChild	1215
App\Entity\Training	289
App\Entity\Article	193
App\Entity\ListingPage	139
App\Entity\Place	51
App\Entity\Certification	46
App\Entity\ArticleCategory	36
App\Entity\TrainingCategory	24
App\Entity\User	5

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\ArticleCategory	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\TrainingObjective	No errors.
App\Entity\Financing	No errors.
App\Entity\TrainingProgramPart	No errors.
App\Entity\Place	No errors.
App\Entity\Session	No errors.
App\Entity\TrainingCityChild	No errors.
App\Entity\FAQ	No errors.
App\Entity\Trainer\Trainer	No errors.
App\Entity\PlacePicture	No errors.
App\Entity\ListingPage	No errors.
App\Entity\Cms\CmsPage	No errors.

Symfony Profiler

GET https://preprod-website.kaza-senza.com/sitemap.articles.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping