Symfony Profiler

Query Metrics

63 Database Queries

8 Different statements

71.90 ms Query time

1 Invalid entities

140 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

64.40 ms
(89.57%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.image_name AS image_name_3, a0_.author AS author_4, a0_.summary AS summary_5, a0_.content AS content_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.state AS state_9, a0_.seo_title AS seo_title_10, a0_.seo_description AS seo_description_11, a0_.seo_canonical AS seo_canonical_12, a0_.seo_indexed AS seo_indexed_13, a0_.category_id AS category_id_14 FROM article a0_ WHERE a0_.state = ? ORDER BY RANDOM() ASC LIMIT 4

Parameters:

[
  "ONLINE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.image_name AS image_name_3,
  a0_.author AS author_4,
  a0_.summary AS summary_5,
  a0_.content AS content_6,
  a0_.created_at AS created_at_7,
  a0_.updated_at AS updated_at_8,
  a0_.state AS state_9,
  a0_.seo_title AS seo_title_10,
  a0_.seo_description AS seo_description_11,
  a0_.seo_canonical AS seo_canonical_12,
  a0_.seo_indexed AS seo_indexed_13,
  a0_.category_id AS category_id_14
FROM
  article a0_
WHERE
  a0_.state = ?
ORDER BY
  RANDOM() ASC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.image_name AS image_name_3, a0_.author AS author_4, a0_.summary AS summary_5, a0_.content AS content_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.state AS state_9, a0_.seo_title AS seo_title_10, a0_.seo_description AS seo_description_11, a0_.seo_canonical AS seo_canonical_12, a0_.seo_indexed AS seo_indexed_13, a0_.category_id AS category_id_14 FROM article a0_ WHERE a0_.state = 'ONLINE' ORDER BY RANDOM() ASC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 37)
7	App\Repository\ArticleRepository->findForHomePage (line 30)
8	App\Controller\IndexController->__invoke (line 183)
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)

4.41 ms
(6.13%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_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.updated_at AS updated_at_3,
  t0.place_id AS place_id_4
FROM
  place_picture t0
WHERE
  t0.place_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.place_id AS place_id_4 FROM place_picture t0 WHERE t0.place_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
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 1202)
9	Twig\Extension\CoreExtension::length (line 71)
10	__TwigTemplate_321434dcef42c409d5fb6ed893499564->{closure:__TwigTemplate_321434dcef42c409d5fb6ed893499564::doDisplay():71} (line 1)
11	array_filter (line 1807)
12	Twig\Extension\CoreExtension::filter (line 71)
13	__TwigTemplate_321434dcef42c409d5fb6ed893499564->doDisplay (line 393)
14	Twig\Template->yield (line 238)
15	__TwigTemplate_bb32bab61535c9fa6efcaaadc9762074->block_body (line 437)
16	Twig\Template->yieldBlock (line 138)
17	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_bb32bab61535c9fa6efcaaadc9762074->doDisplay (line 393)
20	Twig\Template->yield (line 349)
21	Twig\Template->display (line 364)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 306)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
28	App\Controller\IndexController->__invoke (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require (line 7)

1.37 ms
(1.90%)

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

Parameters:

[]

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

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;

#	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 29)
6	App\Controller\IndexController->__invoke (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require (line 7)

0.48 ms
(0.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = ?

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.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification 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\Certification::{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\Certification->__get (line 78)
8	App\Entity\Certification->getName (line 63)
9	App\Entity\Certification->__toString (line 113)
10	Twig\Runtime\EscaperRuntime->escape (line 259)
11	__TwigTemplate_08e8f7c5fd9dc971d5aa9d4f5901df9c->doDisplay (line 393)
12	Twig\Template->yield (line 87)
13	__TwigTemplate_5e4c6f73a636f6a63c7a5da8f9d8475a->doDisplay (line 393)
14	Twig\Template->yield (line 248)
15	__TwigTemplate_bb32bab61535c9fa6efcaaadc9762074->block_body (line 437)
16	Twig\Template->yieldBlock (line 138)
17	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_bb32bab61535c9fa6efcaaadc9762074->doDisplay (line 393)
20	Twig\Template->yield (line 349)
21	Twig\Template->display (line 364)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 306)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
28	App\Controller\IndexController->__invoke (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require (line 7)

0.42 ms
(0.59%)

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.ebook_title AS ebook_title_5, t0.ebook_sub_title AS ebook_sub_title_6, t0.pdf_name AS pdf_name_7, t0.pdf_mime_type AS pdf_mime_type_8 FROM article_category t0 WHERE t0.id = ?

Parameters:

[
  20
]

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.ebook_title AS ebook_title_5,
  t0.ebook_sub_title AS ebook_sub_title_6,
  t0.pdf_name AS pdf_name_7,
  t0.pdf_mime_type AS pdf_mime_type_8
FROM
  article_category t0
WHERE
  t0.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.ebook_title AS ebook_title_5, t0.ebook_sub_title AS ebook_sub_title_6, t0.pdf_name AS pdf_name_7, t0.pdf_mime_type AS pdf_mime_type_8 FROM article_category t0 WHERE t0.id = 20;

#	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\ArticleCategory::{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\ArticleCategory->__get (line 117)
8	App\Entity\ArticleCategory->getImageName (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 64)
10	__TwigTemplate_a897fed3d3a7c35bb0d2b3f0654691c7->doDisplay (line 393)
11	Twig\Template->yield (line 83)
12	__TwigTemplate_316e3d3cf4aa00fa9d2f5fb96cf8c348->doDisplay (line 393)
13	Twig\Template->yield (line 263)
14	__TwigTemplate_bb32bab61535c9fa6efcaaadc9762074->block_body (line 437)
15	Twig\Template->yieldBlock (line 138)
16	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_bb32bab61535c9fa6efcaaadc9762074->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
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 28)
27	App\Controller\IndexController->__invoke (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require (line 7)

0.30 ms
(0.42%)

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 WHERE t0.show_on_home_page = ? LIMIT 3

Parameters:

[
  1
]

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
WHERE
  t0.show_on_home_page = ?
LIMIT
  3

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 WHERE t0.show_on_home_page = 1 LIMIT 3;

#	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 31)
5	App\Controller\IndexController->__invoke (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require (line 7)

0.29 ms
(0.40%)

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

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.total_trainings AS total_trainings_5
FROM
  training_category 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.total_trainings AS total_trainings_5 FROM training_category 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 32)
6	App\Controller\IndexController->__invoke (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require (line 7)

0.23 ms
(0.33%)

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 54)
10	__TwigTemplate_bb32bab61535c9fa6efcaaadc9762074->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 28)
19	App\Controller\IndexController->__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\Place	51
App\Entity\PlacePicture	51
App\Entity\TrainingCategory	24
App\Entity\Article	4
App\Entity\ArticleCategory	4
App\Entity\Training	3
App\Entity\Certification	3

Entities Mapping

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

Symfony Profiler

GET https://preprod-website.kaza-senza.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping