Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.32 ms Query time

0 Invalid entities

8 Managed entities

11 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

1.32 ms

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.cohort_id AS cohort_id_23, t2.role AS role_24, t2.entrance_code AS entrance_code_25, t2.entrance_code_date AS entrance_code_date_26, t2.responsible_id AS responsible_id_27, t3.role AS role_28, t3.entrance_code AS entrance_code_29, t3.entrance_code_date AS entrance_code_date_30, t3.sector_id AS sector_id_31, t4.role AS role_32, t4.entrance_code AS entrance_code_33, t4.entrance_code_date AS entrance_code_date_34, t4.coordinator_id AS coordinator_id_35 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:

[
  1
]

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.cohort_id AS cohort_id_23,
  t2.role AS role_24,
  t2.entrance_code AS entrance_code_25,
  t2.entrance_code_date AS entrance_code_date_26,
  t2.responsible_id AS responsible_id_27,
  t3.role AS role_28,
  t3.entrance_code AS entrance_code_29,
  t3.entrance_code_date AS entrance_code_date_30,
  t3.sector_id AS sector_id_31,
  t4.role AS role_32,
  t4.entrance_code AS entrance_code_33,
  t4.entrance_code_date AS entrance_code_date_34,
  t4.coordinator_id AS coordinator_id_35
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.cohort_id AS cohort_id_23, t2.role AS role_24, t2.entrance_code AS entrance_code_25, t2.entrance_code_date AS entrance_code_date_26, t2.responsible_id AS responsible_id_27, t3.role AS role_28, t3.entrance_code AS entrance_code_29, t3.entrance_code_date AS entrance_code_date_30, t3.sector_id AS sector_id_31, t4.role AS role_32, t4.entrance_code AS entrance_code_33, t4.entrance_code_date AS entrance_code_date_34, t4.coordinator_id AS coordinator_id_35 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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 784)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 533)
4	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadOneToOneEntity (line 2530)
5	Doctrine\ORM\UnitOfWork->createEntity (line 104)
6	Doctrine\ORM\Cache\DefaultQueryCache->get (line 349)
7	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadAll (line 110)
8	Doctrine\ORM\EntityRepository->findBy (line 73)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 37)
10	App\Service\GlobalDataService->getNotificationsNews (line 35)
11	App\Twig\AppExtension->getGlobals (line 359)
12	Twig\ExtensionSet->getGlobals (line 900)
13	Twig\Environment->getGlobals (line 398)
14	Twig\Template->yield (line 358)
15	Twig\Template->display (line 373)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 333)
18	Twig\Environment->render (line 459)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 262)
22	App\Controller\HomeController->privacyPolicy (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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\FeedbackCategory	3
App\Entity\User	2
App\Entity\SiteSettings	1
App\Entity\Notification	1
App\Entity\Avatar	1

Entities Mapping

Class	Mapping errors
App\Entity\SiteSettings	No errors.
App\Entity\FeedbackCategory	No errors.
App\Entity\Feedback	No errors.
App\Entity\Notification	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\Message	No errors.
App\Entity\UserQuiz	No errors.
App\Entity\Calendar	No errors.
App\Entity\Course	No errors.
App\Entity\Quiz	No errors.
App\Entity\Sandbox	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\CourseCohort	No errors.
App\Entity\CohortInternship	No errors.
App\Entity\Faq	No errors.
App\Entity\QuizRow	No errors.
App\Entity\CourseModule	No errors.
App\Entity\CourseResource	No errors.
App\Entity\QuizTheme	No errors.
App\Entity\QuizShare	No errors.