Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

6.22 ms Query time

0 Invalid entities

16 Managed entities

11 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

2.50 ms
(40.13%)

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = ?

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_5,
  t0.username AS username_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.email AS email_11,
  t0.activated AS activated_12,
  t0.tmp_code AS tmp_code_13,
  t0.tmp_code_date AS tmp_code_date_14,
  t0.signature AS signature_15,
  t0.uuid AS uuid_16,
  t0.phone_number AS phone_number_17,
  t0.avatar_id AS avatar_id_18,
  t0.dtype,
  t1.password_save AS password_save_19,
  t1.documents AS documents_20,
  t1.diploma AS diploma_21,
  t1.tutorial_completed AS tutorial_completed_22,
  t1.financial_aid AS financial_aid_23,
  t1.cohort_id AS cohort_id_24,
  t2.role AS role_25,
  t2.entrance_code AS entrance_code_26,
  t2.entrance_code_date AS entrance_code_date_27,
  t2.responsible_id AS responsible_id_28,
  t3.role AS role_29,
  t3.entrance_code AS entrance_code_30,
  t3.entrance_code_date AS entrance_code_date_31,
  t3.sector_id AS sector_id_32,
  t4.role AS role_33,
  t4.entrance_code AS entrance_code_34,
  t4.entrance_code_date AS entrance_code_date_35,
  t4.coordinator_id AS coordinator_id_36
FROM
  user t0
  LEFT JOIN trainee t1 ON t0.id = t1.id
  LEFT JOIN coordinator t2 ON t0.id = t2.id
  LEFT JOIN responsible t3 ON t0.id = t3.id
  LEFT JOIN trainer t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = 24;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 782)
3	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadOneToOneEntity (line 533)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2535)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
10	Doctrine\ORM\EntityManager->find (line 366)
11	Doctrine\ORM\EntityRepository->find (line 86)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findById (line 77)
14	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
16	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
17	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 179)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

1.06 ms
(17.01%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_pinned AS is_pinned_5, t0.is_solved AS is_solved_6, t0.tags AS tags_7, t0.category_id AS category_id_8, t0.author_id AS author_id_9 FROM forum_topic t0 WHERE t0.id = ?

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.is_pinned AS is_pinned_5,
  t0.is_solved AS is_solved_6,
  t0.tags AS tags_7,
  t0.category_id AS category_id_8,
  t0.author_id AS author_id_9
FROM
  forum_topic t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_pinned AS is_pinned_5, t0.is_solved AS is_solved_6, t0.tags AS tags_7, t0.category_id AS category_id_8, t0.author_id AS author_id_9 FROM forum_topic t0 WHERE t0.id = '4';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findById (line 77)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 179)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
13	Symfony\Component\HttpKernel\Kernel->handle (line 143)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

0.99 ms
(15.85%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_solution AS is_solution_4, t0.topic_id AS topic_id_5, t0.author_id AS author_id_6 FROM forum_post t0 WHERE t0.topic_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_solution AS is_solution_4,
  t0.topic_id AS topic_id_5,
  t0.author_id AS author_id_6
FROM
  forum_post t0
WHERE
  t0.topic_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_solution AS is_solution_4, t0.topic_id AS topic_id_5, t0.author_id AS author_id_6 FROM forum_post t0 WHERE t0.topic_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_30c1859c14fa0a89330869eda3ef750a->block_forum_content (line 155)
9	Twig\Template->yieldBlock (line 458)
10	__TwigTemplate_e4e54e205992d6df0fa3b6fda96d74c5->block_main (line 210)
11	Twig\Template->yieldBlock (line 458)
12	__TwigTemplate_7aed9e1713ffbd6c111e226867730668->block_body (line 454)
13	Twig\Template->yieldBlock (line 458)
14	__TwigTemplate_7aed9e1713ffbd6c111e226867730668->doDisplay (line 204)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_e4e54e205992d6df0fa3b6fda96d74c5->doDisplay (line 57)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_30c1859c14fa0a89330869eda3ef750a->doDisplay (line 54)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
27	App\Controller\ForumController->show (line 91)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
30	Symfony\Component\HttpKernel\Kernel->handle (line 143)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 5)

0.88 ms
(14.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3
FROM
  theme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = 4;

#	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::getProxy():217} (line 223)
4	App\Entity\Theme::getPath (line 41)
5	App\Service\GlobalDataService->getPlatformThemePath (line 94)
6	App\Twig\AppExtension->getGlobals (line 43)
7	Twig\ExtensionSet->getGlobals (line 365)
8	Twig\Environment->getGlobals (line 908)
9	Twig\Template->yield (line 406)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
17	App\Controller\ForumController->show (line 91)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

0.80 ms
(12.92%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM forum_category 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.slug AS slug_3
FROM
  forum_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM forum_category t0 WHERE t0.id = 1;

#	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::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1801)
5	__TwigTemplate_30c1859c14fa0a89330869eda3ef750a::block_forum_content (line 92)
6	Twig\Template->yieldBlock (line 458)
7	__TwigTemplate_e4e54e205992d6df0fa3b6fda96d74c5->block_main (line 210)
8	Twig\Template->yieldBlock (line 458)
9	__TwigTemplate_7aed9e1713ffbd6c111e226867730668->block_body (line 454)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_7aed9e1713ffbd6c111e226867730668->doDisplay (line 204)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_e4e54e205992d6df0fa3b6fda96d74c5->doDisplay (line 57)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_30c1859c14fa0a89330869eda3ef750a->doDisplay (line 54)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
24	App\Controller\ForumController->show (line 91)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
27	Symfony\Component\HttpKernel\Kernel->handle (line 143)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	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

11 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
non_strict	7
read_only	4

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	3
App\Entity\FeedbackCategory	3
App\Entity\Avatar	2
App\Entity\ForumPost	2
App\Entity\SiteSettings	1
App\Entity\Theme	1
App\Entity\ForumTopic	1
App\Entity\ForumCategory	1
App\Entity\Cohort	1
App\Entity\Notification	1

Entities Mapping

Class	Mapping errors
App\Entity\SiteSettings	No errors.
App\Entity\Theme	No errors.
App\Entity\ForumTopic	No errors.
App\Entity\ForumCategory	No errors.
App\Entity\User	No errors.
App\Entity\Trainee	No errors.
App\Entity\Coordinator	No errors.
App\Entity\Responsible	No errors.
App\Entity\Trainer	No errors.
App\Entity\Avatar	No errors.
App\Entity\Cohort	No errors.
App\Entity\Sector	No errors.
App\Entity\Notification	No errors.
App\Entity\Feedback	No errors.
App\Entity\Message	No errors.
App\Entity\UserQuiz	No errors.
App\Entity\Calendar	No errors.
App\Entity\RssFeed	No errors.
App\Entity\CourseTrainee	No errors.
App\Entity\SurveyTrainee	No errors.
App\Entity\TraineeResource	No errors.
App\Entity\Internship	No errors.
App\Entity\TraineeCourseFavorite	No errors.
App\Entity\TraineeInternship	No errors.
App\Entity\ForumPost	No errors.
App\Entity\FeedbackCategory	No errors.
App\Entity\Course	No errors.
App\Entity\Quiz	No errors.

GET https://forum.trainizer.fr/robots.txt/topic/4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Managed Entities

default entity manager

Entities Mapping