Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

7.17 ms Query time

0 Invalid entities

2 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

3.74 ms
(52.11%)

SELECT t0_.id AS id_0, t0_.created_at AS created_at_1, c1_.id AS id_2, c1_.grade AS grade_3, c1_.letter AS letter_4, c1_.custom_group AS custom_group_5, u2_.id AS id_6, u2_.uuid AS uuid_7, s3_.id AS id_8, s3_.name AS name_9, s3_.city AS city_10, s3_.county AS county_11, t0_.teacher_classroom_id AS teacher_classroom_id_12, t0_.user_id AS user_id_13 FROM teacher_classroom_student t0_ LEFT JOIN user_entity_table u2_ ON t0_.user_id = u2_.id LEFT JOIN teacher_classroom t4_ ON t0_.teacher_classroom_id = t4_.id LEFT JOIN classroom c1_ ON t4_.classroom_id = c1_.id LEFT JOIN school s3_ ON c1_.school_id = s3_.id WHERE c1_.school_id = ? AND c1_.school_year_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.created_at AS created_at_1,
  c1_.id AS id_2,
  c1_.grade AS grade_3,
  c1_.letter AS letter_4,
  c1_.custom_group AS custom_group_5,
  u2_.id AS id_6,
  u2_.uuid AS uuid_7,
  s3_.id AS id_8,
  s3_.name AS name_9,
  s3_.city AS city_10,
  s3_.county AS county_11,
  t0_.teacher_classroom_id AS teacher_classroom_id_12,
  t0_.user_id AS user_id_13
FROM
  teacher_classroom_student t0_
  LEFT JOIN user_entity_table u2_ ON t0_.user_id = u2_.id
  LEFT JOIN teacher_classroom t4_ ON t0_.teacher_classroom_id = t4_.id
  LEFT JOIN classroom c1_ ON t4_.classroom_id = c1_.id
  LEFT JOIN school s3_ ON c1_.school_id = s3_.id
WHERE
  c1_.school_id = ?
  AND c1_.school_year_id = ?

SELECT t0_.id AS id_0, t0_.created_at AS created_at_1, c1_.id AS id_2, c1_.grade AS grade_3, c1_.letter AS letter_4, c1_.custom_group AS custom_group_5, u2_.id AS id_6, u2_.uuid AS uuid_7, s3_.id AS id_8, s3_.name AS name_9, s3_.city AS city_10, s3_.county AS county_11, t0_.teacher_classroom_id AS teacher_classroom_id_12, t0_.user_id AS user_id_13 FROM teacher_classroom_student t0_ LEFT JOIN user_entity_table u2_ ON t0_.user_id = u2_.id LEFT JOIN teacher_classroom t4_ ON t0_.teacher_classroom_id = t4_.id LEFT JOIN classroom c1_ ON t4_.classroom_id = c1_.id LEFT JOIN school s3_ ON c1_.school_id = s3_.id WHERE c1_.school_id = 1 AND c1_.school_year_id = 1;

#	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 56)
7	App\Service\Classroom\SchoolData->getAllBySchoolForSchools (line 90)
8	App\Service\Classroom\SchoolData->getAllBySchools (line 51)
9	App\Controller\InternalController->App\Controller\{closure} (line 30)
10	App\Controller\AbstractBizziController->tc (line 48)
11	App\Controller\InternalController->schools_students_in_classrooms (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

2.09 ms
(29.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.county AS county_4, t0.sid AS sid_5 FROM school 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.city AS city_3,
  t0.county AS county_4,
  t0.sid AS sid_5
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.county AS county_4, t0.sid AS sid_5 FROM school t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 81)
7	App\Service\Classroom\SchoolData->getAllBySchools (line 51)
8	App\Controller\InternalController->App\Controller\{closure} (line 30)
9	App\Controller\AbstractBizziController->tc (line 48)
10	App\Controller\InternalController->schools_students_in_classrooms (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.94 ms
(13.18%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.beginning_at AS beginning_at_2, s0_.ending_at AS ending_at_3 FROM school_year s0_ WHERE s0_.beginning_at < ? AND s0_.ending_at > ?

Parameters:

[
  "2025-08-20 00:00:02"
  "2025-08-20 00:00:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.beginning_at AS beginning_at_2,
  s0_.ending_at AS ending_at_3
FROM
  school_year s0_
WHERE
  s0_.beginning_at < ?
  AND s0_.ending_at > ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.beginning_at AS beginning_at_2, s0_.ending_at AS ending_at_3 FROM school_year s0_ WHERE s0_.beginning_at < '2025-08-20 00:00:02' AND s0_.ending_at > '2025-08-20 00:00:02';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 29)
7	App\Repository\SchoolYearRepository->findOneByDate (line 20)
8	App\Service\Classroom\SchoolYear->active (line 54)
9	App\Service\Classroom\SchoolData->getAllBySchoolForSchools (line 90)
10	App\Service\Classroom\SchoolData->getAllBySchools (line 51)
11	App\Controller\InternalController->App\Controller\{closure} (line 30)
12	App\Controller\AbstractBizziController->tc (line 48)
13	App\Controller\InternalController->schools_students_in_classrooms (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.40 ms
(5.57%)

SET search_path TO bws_dev_pyp

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  search_path TO bws_dev_pyp

SET search_path TO bws_dev_pyp;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 81)
3	App\Service\WorkspaceSwitch->switchPGSQLSchema (line 65)
4	App\Service\WorkspaceSwitch->switchWorkspace (line 59)
5	App\Service\WorkspaceSwitch->switch (line 53)
6	App\EventListener\WorkspaceListener->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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

2 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
app_entity_workspace	2

Entities Mapping

Class	Mapping errors
App\Entity\Workspace	No errors.
App\Entity\School	No errors.
App\Entity\Classroom	No errors.
App\Entity\SchoolGroup	No errors.
App\Entity\SchoolYear	No errors.
App\Entity\TeacherClassroomStudent	No errors.
App\Entity\User	No errors.
App\Entity\TeacherClassroom	No errors.

Symfony Profiler

POST https://dev-pyp-bizzi-api.izzi.digital/internal/schools/studens-in-classrooms

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Entities Mapping