Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

7.07 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.00 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.azure_id AS azure_id_5, t0.username AS username_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.department AS department_9, t0.job_title AS job_title_10, t0.azure_groups AS azure_groups_11, t12.id AS id_13, t12.firstname AS firstname_14, t12.lastname AS lastname_15, t12.user_id AS user_id_16, t17.id AS id_18, t17.firstname AS firstname_19, t17.lastname AS lastname_20, t17.user_id AS user_id_21, t22.id AS id_23, t22.firstname AS firstname_24, t22.lastname AS lastname_25, t22.company AS company_26, t22.user_id AS user_id_27 FROM user t0 LEFT JOIN student t12 ON t12.user_id = t0.id LEFT JOIN professor t17 ON t17.user_id = t0.id LEFT JOIN tutor t22 ON t22.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  68
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.azure_id AS azure_id_5,
  t0.username AS username_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.department AS department_9,
  t0.job_title AS job_title_10,
  t0.azure_groups AS azure_groups_11,
  t12.id AS id_13,
  t12.firstname AS firstname_14,
  t12.lastname AS lastname_15,
  t12.user_id AS user_id_16,
  t17.id AS id_18,
  t17.firstname AS firstname_19,
  t17.lastname AS lastname_20,
  t17.user_id AS user_id_21,
  t22.id AS id_23,
  t22.firstname AS firstname_24,
  t22.lastname AS lastname_25,
  t22.company AS company_26,
  t22.user_id AS user_id_27
FROM
  user t0
  LEFT JOIN student t12 ON t12.user_id = t0.id
  LEFT JOIN professor t17 ON t17.user_id = t0.id
  LEFT JOIN tutor t22 ON t22.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.azure_id AS azure_id_5, t0.username AS username_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.department AS department_9, t0.job_title AS job_title_10, t0.azure_groups AS azure_groups_11, t12.id AS id_13, t12.firstname AS firstname_14, t12.lastname AS lastname_15, t12.user_id AS user_id_16, t17.id AS id_18, t17.firstname AS firstname_19, t17.lastname AS lastname_20, t17.user_id AS user_id_21, t22.id AS id_23, t22.firstname AS firstname_24, t22.lastname AS lastname_25, t22.company AS company_26, t22.user_id AS user_id_27 FROM user t0 LEFT JOIN student t12 ON t12.user_id = t0.id LEFT JOIN professor t17 ON t17.user_id = t0.id LEFT JOIN tutor t22 ON t22.user_id = t0.id WHERE t0.id = 68;

#	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\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():74} (line 77)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Bundle\SecurityBundle\Security->getToken (line 97)
14	Symfony\Bundle\SecurityBundle\Security->getUser (line 52)
15	App\State\Provider\Professor\ProfessorMeetingRequestsProvider->provide (line 27)
16	ApiPlatform\State\CallableProvider->provide (line 43)
17	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
18	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
20	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
21	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
23	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
24	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
25	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
26	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
27	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
28	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 191)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

5.07 ms

SELECT m0_.id AS id_0, m0_.message AS message_1, m0_.status AS status_2, m0_.requested_at AS requested_at_3, m0_.reply AS reply_4, m0_.responded_at AS responded_at_5, m0_.situation_id AS situation_id_6, m0_.student_id AS student_id_7, m0_.evaluator_id AS evaluator_id_8 FROM meeting_request m0_ WHERE m0_.evaluator_id = ? ORDER BY m0_.requested_at DESC

Parameters:

[
  181
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.message AS message_1,
  m0_.status AS status_2,
  m0_.requested_at AS requested_at_3,
  m0_.reply AS reply_4,
  m0_.responded_at AS responded_at_5,
  m0_.situation_id AS situation_id_6,
  m0_.student_id AS student_id_7,
  m0_.evaluator_id AS evaluator_id_8
FROM
  meeting_request m0_
WHERE
  m0_.evaluator_id = ?
ORDER BY
  m0_.requested_at DESC

SELECT m0_.id AS id_0, m0_.message AS message_1, m0_.status AS status_2, m0_.requested_at AS requested_at_3, m0_.reply AS reply_4, m0_.responded_at AS responded_at_5, m0_.situation_id AS situation_id_6, m0_.student_id AS student_id_7, m0_.evaluator_id AS evaluator_id_8 FROM meeting_request m0_ WHERE m0_.evaluator_id = 181 ORDER BY m0_.requested_at DESC;

#	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\MeetingRequestRepository->findByEvaluator (line 50)
7	App\State\Provider\Professor\ProfessorMeetingRequestsProvider->provide (line 32)
8	ApiPlatform\State\CallableProvider->provide (line 43)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	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\User	1
App\Entity\Professor	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Student	No errors.
App\Entity\Professor	No errors.
App\Entity\Tutor	No errors.
App\Entity\MeetingRequest	No errors.
App\Entity\Situation	No errors.

Symfony Profiler

GET https://evalcomp.dataccessor.com/api/professor/meeting-requests

Configuration Settings

Theme

Page Width