Symfony Profiler

Query Metrics

65 Database Queries

10 Different statements

46.87 ms Query time

5 Invalid entities

141 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

36.93 ms
(78.80%)

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.72 ms
(10.07%)

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_766cd7e292d8e05d895b27c42858fa00->{closure:__TwigTemplate_766cd7e292d8e05d895b27c42858fa00::doDisplay():71} (line 1)
11	array_filter (line 1807)
12	Twig\Extension\CoreExtension::filter (line 71)
13	__TwigTemplate_766cd7e292d8e05d895b27c42858fa00->doDisplay (line 393)
14	Twig\Template->yield (line 238)
15	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->block_body (line 437)
16	Twig\Template->yieldBlock (line 151)
17	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->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.71 ms
(3.66%)

SELECT COUNT(DISTINCT t.id)
    FROM training t
    INNER JOIN certification c on c.id = t.certification_id
    WHERE t.type = 'professional'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT t.id)
FROM
  training t
  INNER JOIN certification c on c.id = t.certification_id
WHERE
  t.type = 'professional'

SELECT COUNT(DISTINCT t.id)
    FROM training t
    INNER JOIN certification c on c.id = t.certification_id
    WHERE t.type = 'professional';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 96)
2	App\Repository\TrainingProfessionalRepository->countCertified (line 30)
3	App\Twig\Runtime\HomeExtensionRuntime->{closure:App\Twig\Runtime\HomeExtensionRuntime::getTotalCertifiedTraining():27} (line 47)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():44} (line 111)
5	Symfony\Component\Cache\LockRegistry::compute (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 52)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 27)
11	App\Twig\Runtime\HomeExtensionRuntime->getTotalCertifiedTraining (line 106)
12	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->block_body (line 437)
13	Twig\Template->yieldBlock (line 151)
14	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->doDisplay (line 393)
17	Twig\Template->yield (line 349)
18	Twig\Template->display (line 364)
19	Twig\Template->render (line 35)
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 28)
25	App\Controller\IndexController->__invoke (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require (line 7)

1.71 ms
(3.64%)

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.41 ms
(0.87%)

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_b5595d22ab44336ebc0f52783fbb7d1e->doDisplay (line 393)
12	Twig\Template->yield (line 87)
13	__TwigTemplate_549c1a19f6dd47ae72a0970c0e770b27->doDisplay (line 393)
14	Twig\Template->yield (line 248)
15	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->block_body (line 437)
16	Twig\Template->yieldBlock (line 151)
17	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->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.40 ms
(0.86%)

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:

[
  11
]

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 = 11;

#	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_ec0d0c36da6e960e65ed77270e0f118e->doDisplay (line 393)
11	Twig\Template->yield (line 83)
12	__TwigTemplate_22effb7a1c8613bfc598630e8a4c0f10->doDisplay (line 393)
13	Twig\Template->yield (line 263)
14	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->block_body (line 437)
15	Twig\Template->yieldBlock (line 151)
16	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->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.31 ms
(0.65%)

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.27 ms
(0.57%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.sub_title AS sub_title_18, t0.show_on_home_page AS show_on_home_page_19, t0.format AS format_20, t0.collective_face_to_face_hours AS collective_face_to_face_hours_21, t0.individual_face_to_face_hours AS individual_face_to_face_hours_22, t0.individual_videoconference_hours AS individual_videoconference_hours_23, t0.collective_videoconference_hours AS collective_videoconference_hours_24, t0.elearning_hours AS elearning_hours_25, t0.face_to_face_hours_text AS face_to_face_hours_text_26, t0.min_period AS min_period_27, t0.max_period AS max_period_28, t0.public AS public_29, t0.prerequisites AS prerequisites_30, t0.cpf AS cpf_31, t0.cpf_link AS cpf_link_32, t0.pdf_name AS pdf_name_33, t0.pdf_mime_type AS pdf_mime_type_34, t0.created_by_id AS created_by_id_35, t0.category_id AS category_id_36, t0.certification_id AS certification_id_37, t0.type FROM training t0 WHERE t0.show_on_home_page = ? AND t0.type IN ('professional') 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.code AS code_3,
  t0.slug_history AS slug_history_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.status AS status_7,
  t0.satisfaction_rate AS satisfaction_rate_8,
  t0.completion_rate AS completion_rate_9,
  t0.featured_on_search AS featured_on_search_10,
  t0.pixels AS pixels_11,
  t0.updated_at AS updated_at_12,
  t0.seo_title AS seo_title_13,
  t0.seo_description AS seo_description_14,
  t0.seo_canonical AS seo_canonical_15,
  t0.seo_indexed AS seo_indexed_16,
  t0.slug AS slug_17,
  t0.sub_title AS sub_title_18,
  t0.show_on_home_page AS show_on_home_page_19,
  t0.format AS format_20,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_21,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_22,
  t0.individual_videoconference_hours AS individual_videoconference_hours_23,
  t0.collective_videoconference_hours AS collective_videoconference_hours_24,
  t0.elearning_hours AS elearning_hours_25,
  t0.face_to_face_hours_text AS face_to_face_hours_text_26,
  t0.min_period AS min_period_27,
  t0.max_period AS max_period_28,
  t0.public AS public_29,
  t0.prerequisites AS prerequisites_30,
  t0.cpf AS cpf_31,
  t0.cpf_link AS cpf_link_32,
  t0.pdf_name AS pdf_name_33,
  t0.pdf_mime_type AS pdf_mime_type_34,
  t0.created_by_id AS created_by_id_35,
  t0.category_id AS category_id_36,
  t0.certification_id AS certification_id_37,
  t0.type
FROM
  training t0
WHERE
  t0.show_on_home_page = ?
  AND t0.type IN ('professional')
LIMIT
  3

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.sub_title AS sub_title_18, t0.show_on_home_page AS show_on_home_page_19, t0.format AS format_20, t0.collective_face_to_face_hours AS collective_face_to_face_hours_21, t0.individual_face_to_face_hours AS individual_face_to_face_hours_22, t0.individual_videoconference_hours AS individual_videoconference_hours_23, t0.collective_videoconference_hours AS collective_videoconference_hours_24, t0.elearning_hours AS elearning_hours_25, t0.face_to_face_hours_text AS face_to_face_hours_text_26, t0.min_period AS min_period_27, t0.max_period AS max_period_28, t0.public AS public_29, t0.prerequisites AS prerequisites_30, t0.cpf AS cpf_31, t0.cpf_link AS cpf_link_32, t0.pdf_name AS pdf_name_33, t0.pdf_mime_type AS pdf_mime_type_34, t0.created_by_id AS created_by_id_35, t0.category_id AS category_id_36, t0.certification_id AS certification_id_37, t0.type FROM training t0 WHERE t0.show_on_home_page = 1 AND t0.type IN ('professional') 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.25 ms
(0.53%)

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 68)
5	App\Twig\Runtime\MenuExtensionRuntime->getCmsPages (line 271)
6	__TwigTemplate_5028b06c55d52e946822d9d8a6abcbe5->doDisplay (line 393)
7	Twig\Template->yield (line 119)
8	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->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)

0.16 ms
(0.34%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.value AS value_4 FROM parameter t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "TOTAL_LEARNERS"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.value AS value_4
FROM
  parameter t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.value AS value_4 FROM parameter t0 WHERE t0.code = 'TOTAL_LEARNERS' 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 39)
5	App\Twig\Runtime\HomeExtensionRuntime->{closure:App\Twig\Runtime\HomeExtensionRuntime::getTotalLearners():36} (line 47)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():44} (line 111)
7	Symfony\Component\Cache\LockRegistry::compute (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 52)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 36)
13	App\Twig\Runtime\HomeExtensionRuntime->getTotalLearners (line 109)
14	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->block_body (line 437)
15	Twig\Template->yieldBlock (line 151)
16	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_b845e1dfb0ca4e9454fefcd92ea5ca0a->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)

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
App\Entity\Parameter	1

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\TrainingProfessional	The association App\Entity\TrainingProfessional#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\User	No errors.
App\Entity\Certification	No errors.
App\Entity\TrainingObjective	No errors.
App\Entity\FAQ	No errors.
App\Entity\Trainer\Trainer	No errors.
App\Entity\TrainingProgramPart	The association App\Entity\TrainingProgramPart#training refers to the inverse side field App\Entity\Training#trainingProgramParts which does not exist.
App\Entity\Financing	No errors.
App\Entity\Session	The association App\Entity\Session#training refers to the inverse side field App\Entity\Training#sessions which does not exist.
App\Entity\TrainingCityChild	The association App\Entity\TrainingCityChild#training refers to the inverse side field App\Entity\Training#trainingCityChildren which does not exist.
App\Entity\Cms\CmsPage	No errors.
App\Entity\Parameter	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