Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

10.23 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.00 ms
(39.06%)

SELECT t0_.title AS title_0, t0_.startup AS startup_1, t0_.duration AS duration_2, t0_.periode AS periode_3, t0_.language AS language_4, t0_.about AS about_5, t0_.objective AS objective_6, t0_.prerequired AS prerequired_7, t0_.learn AS learn_8, t0_.career AS career_9, t0_.project AS project_10, t0_.id AS id_11, t0_.idnum AS idnum_12, t0_.enabled AS enabled_13, t0_.slug AS slug_14, t0_.created AS created_15, t0_.updated AS updated_16, t0_.file_name AS file_name_17, t0_.file_url AS file_url_18, t0_.category_id AS category_id_19, t0_.level_id AS level_id_20, t0_.program_id AS program_id_21 FROM training t0_ WHERE t0_.slug = ? LIMIT 1

Parameters:

[
  "microsoft-365-productivite-organisationnelle"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.title AS title_0,
  t0_.startup AS startup_1,
  t0_.duration AS duration_2,
  t0_.periode AS periode_3,
  t0_.language AS language_4,
  t0_.about AS about_5,
  t0_.objective AS objective_6,
  t0_.prerequired AS prerequired_7,
  t0_.learn AS learn_8,
  t0_.career AS career_9,
  t0_.project AS project_10,
  t0_.id AS id_11,
  t0_.idnum AS idnum_12,
  t0_.enabled AS enabled_13,
  t0_.slug AS slug_14,
  t0_.created AS created_15,
  t0_.updated AS updated_16,
  t0_.file_name AS file_name_17,
  t0_.file_url AS file_url_18,
  t0_.category_id AS category_id_19,
  t0_.level_id AS level_id_20,
  t0_.program_id AS program_id_21
FROM
  training t0_
WHERE
  t0_.slug = ?
LIMIT
  1

SELECT t0_.title AS title_0, t0_.startup AS startup_1, t0_.duration AS duration_2, t0_.periode AS periode_3, t0_.language AS language_4, t0_.about AS about_5, t0_.objective AS objective_6, t0_.prerequired AS prerequired_7, t0_.learn AS learn_8, t0_.career AS career_9, t0_.project AS project_10, t0_.id AS id_11, t0_.idnum AS idnum_12, t0_.enabled AS enabled_13, t0_.slug AS slug_14, t0_.created AS created_15, t0_.updated AS updated_16, t0_.file_name AS file_name_17, t0_.file_url AS file_url_18, t0_.category_id AS category_id_19, t0_.level_id AS level_id_20, t0_.program_id AS program_id_21 FROM training t0_ WHERE t0_.slug = 'microsoft-365-productivite-organisationnelle' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Shared\BaseRepository->findByFields (line 101)
7	App\Repository\Shared\BaseRepository->findOne (line 116)
8	App\Controller\Frontend\Training\TrainingController->register (line 40)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

3.02 ms
(29.54%)

SELECT t0_.title AS title_0, t0_.startup AS startup_1, t0_.duration AS duration_2, t0_.periode AS periode_3, t0_.language AS language_4, t0_.about AS about_5, t0_.objective AS objective_6, t0_.prerequired AS prerequired_7, t0_.learn AS learn_8, t0_.career AS career_9, t0_.project AS project_10, t0_.id AS id_11, t0_.idnum AS idnum_12, t0_.enabled AS enabled_13, t0_.slug AS slug_14, t0_.created AS created_15, t0_.updated AS updated_16, t0_.file_name AS file_name_17, t0_.file_url AS file_url_18, t0_.category_id AS category_id_19, t0_.level_id AS level_id_20, t0_.program_id AS program_id_21 FROM training t0_ LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id WHERE t0_.enabled = true ORDER BY t1_.name ASC, t0_.title ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.title AS title_0,
  t0_.startup AS startup_1,
  t0_.duration AS duration_2,
  t0_.periode AS periode_3,
  t0_.language AS language_4,
  t0_.about AS about_5,
  t0_.objective AS objective_6,
  t0_.prerequired AS prerequired_7,
  t0_.learn AS learn_8,
  t0_.career AS career_9,
  t0_.project AS project_10,
  t0_.id AS id_11,
  t0_.idnum AS idnum_12,
  t0_.enabled AS enabled_13,
  t0_.slug AS slug_14,
  t0_.created AS created_15,
  t0_.updated AS updated_16,
  t0_.file_name AS file_name_17,
  t0_.file_url AS file_url_18,
  t0_.category_id AS category_id_19,
  t0_.level_id AS level_id_20,
  t0_.program_id AS program_id_21
FROM
  training t0_
  LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id
WHERE
  t0_.enabled = true
ORDER BY
  t1_.name ASC,
  t0_.title ASC

SELECT t0_.title AS title_0, t0_.startup AS startup_1, t0_.duration AS duration_2, t0_.periode AS periode_3, t0_.language AS language_4, t0_.about AS about_5, t0_.objective AS objective_6, t0_.prerequired AS prerequired_7, t0_.learn AS learn_8, t0_.career AS career_9, t0_.project AS project_10, t0_.id AS id_11, t0_.idnum AS idnum_12, t0_.enabled AS enabled_13, t0_.slug AS slug_14, t0_.created AS created_15, t0_.updated AS updated_16, t0_.file_name AS file_name_17, t0_.file_url AS file_url_18, t0_.category_id AS category_id_19, t0_.level_id AS level_id_20, t0_.program_id AS program_id_21 FROM training t0_ LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id WHERE t0_.enabled = true ORDER BY t1_.name ASC, t0_.title ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Components\Training\Training\TrainingFormRegister->getFormView (line 120)
21	App\Components\Training\Training\TrainingFormRegister->initializeForm (line 95)
22	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 199)
23	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 108)
24	Symfony\UX\TwigComponent\ComponentFactory->create (line 84)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_bfb7b98a59fbedb8e548af63456acf4c->block_content (line 88)
28	Twig\Template->yieldBlock (line 446)
29	__TwigTemplate_f16b8672e65512743c9449fa73d7c6f2->doDisplay (line 112)
30	Twig\Template->yield (line 402)
31	__TwigTemplate_bfb7b98a59fbedb8e548af63456acf4c->doDisplay (line 53)
32	Twig\Template->yield (line 402)
33	Twig\Template->display (line 358)
34	Twig\Template->render (line 373)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\Frontend\Training\TrainingController->register (line 45)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
45	require_once (line 32)
46	require_once (line 5)

1.98 ms
(19.35%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.idnum AS idnum_3, t0.enabled AS enabled_4, t0.slug AS slug_5 FROM training_category t0 WHERE t0.id = ?

Parameters:

[
  "019c0da6-da36-734a-8209-c32478a1a446"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.idnum AS idnum_3,
  t0.enabled AS enabled_4,
  t0.slug AS slug_5
FROM
  training_category t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.idnum AS idnum_3, t0.enabled AS enabled_4, t0.slug AS slug_5 FROM training_category t0 WHERE t0.id = '019c0da6-da36-734a-8209-c32478a1a446';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Training\TrainingCategory::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Training\TrainingCategory->__get (line 153)
7	App\Entity\Training\TrainingCategory->getName (line 63)
8	App\Form\Training\TrainingSubscriberType->{closure:App\Form\Training\TrainingSubscriberType::buildForm():44} (line 45)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->addChoiceViewsGroupedByCallable (line 252)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::createView (line 83)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
19	Symfony\Component\Form\Form->createView (line 892)
20	Symfony\Component\Form\Form->createView (line 895)
21	App\Components\Training\Training\TrainingFormRegister->getFormView (line 120)
22	App\Components\Training\Training\TrainingFormRegister->initializeForm (line 95)
23	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 199)
24	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 108)
25	Symfony\UX\TwigComponent\ComponentFactory->create (line 84)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
28	__TwigTemplate_bfb7b98a59fbedb8e548af63456acf4c->block_content (line 88)
29	Twig\Template->yieldBlock (line 446)
30	__TwigTemplate_f16b8672e65512743c9449fa73d7c6f2->doDisplay (line 112)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_bfb7b98a59fbedb8e548af63456acf4c->doDisplay (line 53)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
41	App\Controller\Frontend\Training\TrainingController->register (line 45)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 193)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
46	require_once (line 32)
47	require_once (line 5)

1.23 ms
(12.05%)

SELECT t0.title AS title_1, t0.startup AS startup_2, t0.duration AS duration_3, t0.periode AS periode_4, t0.language AS language_5, t0.about AS about_6, t0.objective AS objective_7, t0.prerequired AS prerequired_8, t0.learn AS learn_9, t0.career AS career_10, t0.project AS project_11, t0.id AS id_12, t0.idnum AS idnum_13, t0.enabled AS enabled_14, t0.slug AS slug_15, t0.created AS created_16, t0.updated AS updated_17, t0.file_name AS file_name_18, t0.file_url AS file_url_19, t0.category_id AS category_id_20, t0.level_id AS level_id_21, t0.program_id AS program_id_22 FROM training t0 WHERE t0.slug = ? AND t0.enabled = ? LIMIT 1

Parameters:

[
  "microsoft-365-productivite-organisationnelle"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.startup AS startup_2,
  t0.duration AS duration_3,
  t0.periode AS periode_4,
  t0.language AS language_5,
  t0.about AS about_6,
  t0.objective AS objective_7,
  t0.prerequired AS prerequired_8,
  t0.learn AS learn_9,
  t0.career AS career_10,
  t0.project AS project_11,
  t0.id AS id_12,
  t0.idnum AS idnum_13,
  t0.enabled AS enabled_14,
  t0.slug AS slug_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.file_name AS file_name_18,
  t0.file_url AS file_url_19,
  t0.category_id AS category_id_20,
  t0.level_id AS level_id_21,
  t0.program_id AS program_id_22
FROM
  training t0
WHERE
  t0.slug = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.title AS title_1, t0.startup AS startup_2, t0.duration AS duration_3, t0.periode AS periode_4, t0.language AS language_5, t0.about AS about_6, t0.objective AS objective_7, t0.prerequired AS prerequired_8, t0.learn AS learn_9, t0.career AS career_10, t0.project AS project_11, t0.id AS id_12, t0.idnum AS idnum_13, t0.enabled AS enabled_14, t0.slug AS slug_15, t0.created AS created_16, t0.updated AS updated_17, t0.file_name AS file_name_18, t0.file_url AS file_url_19, t0.category_id AS category_id_20, t0.level_id AS level_id_21, t0.program_id AS program_id_22 FROM training t0 WHERE t0.slug = 'microsoft-365-productivite-organisationnelle' AND t0.enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Components\Training\Training\TrainingFormRegister->instantiateForm (line 51)
5	App\Components\Training\Training\TrainingFormRegister->getForm (line 196)
6	App\Components\Training\Training\TrainingFormRegister->getFormView (line 120)
7	App\Components\Training\Training\TrainingFormRegister->initializeForm (line 95)
8	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 199)
9	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 108)
10	Symfony\UX\TwigComponent\ComponentFactory->create (line 84)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
13	__TwigTemplate_bfb7b98a59fbedb8e548af63456acf4c->block_content (line 88)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_f16b8672e65512743c9449fa73d7c6f2->doDisplay (line 112)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_bfb7b98a59fbedb8e548af63456acf4c->doDisplay (line 53)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\Frontend\Training\TrainingController->register (line 45)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Training\Training	10
App\Entity\Training\TrainingProgram	10
App\Entity\Training\TrainingCategory	4
App\Entity\Training\TrainingLevel	2

Entities Mapping

Class	Mapping errors
App\Entity\Training\Training	No errors.
App\Entity\Training\TrainingCategory	No errors.
App\Entity\Training\TrainingLevel	No errors.
App\Entity\Training\TrainingProgram	No errors.
App\Entity\Training\TrainingFormat	No errors.
App\Entity\Setting\Tag	No errors.
App\Entity\Training\TrainingSubscriber	No errors.

Symfony Profiler

GET https://test.icesacademy.org/en/trainings/microsoft-365-productivite-organisationnelle/register

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping