Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

1.93 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.57 ms
(29.48%)

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.link AS link_3, s0_.target AS target_4, s0_.priority AS priority_5, s0_.start_date AS start_date_6, s0_.end_date AS end_date_7, s0_.notice_type AS notice_type_8, s0_.type AS type_9, s0_.status AS status_10 FROM setting__notice s0_ WHERE s0_.status = ? ORDER BY s0_.priority ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.description AS description_2,
  s0_.link AS link_3,
  s0_.target AS target_4,
  s0_.priority AS priority_5,
  s0_.start_date AS start_date_6,
  s0_.end_date AS end_date_7,
  s0_.notice_type AS notice_type_8,
  s0_.type AS type_9,
  s0_.status AS status_10
FROM
  setting__notice s0_
WHERE
  s0_.status = ?
ORDER BY
  s0_.priority ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.link AS link_3, s0_.target AS target_4, s0_.priority AS priority_5, s0_.start_date AS start_date_6, s0_.end_date AS end_date_7, s0_.notice_type AS notice_type_8, s0_.type AS type_9, s0_.status AS status_10 FROM setting__notice s0_ WHERE s0_.status = 1 ORDER BY s0_.priority ASC;

#	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 234)
7	App\Controller\WebController->indexAction (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 7)

0.53 ms
(27.47%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.year AS year_3, t0.code AS code_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.test_date AS test_date_7, t0.type AS type_8, t0.enable AS enable_9 FROM calendar__semester t0 WHERE t0.enable = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.year AS year_3,
  t0.code AS code_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.test_date AS test_date_7,
  t0.type AS type_8,
  t0.enable AS enable_9
FROM
  calendar__semester t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.year AS year_3, t0.code AS code_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.test_date AS test_date_7, t0.type AS type_8, t0.enable AS enable_9 FROM calendar__semester t0 WHERE t0.enable = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 240)
4	App\Controller\WebController->indexAction (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 7)

0.30 ms
(15.57%)

SELECT t0.id AS id_1, t0.slot AS slot_2, t0.merit_serial_start AS merit_serial_start_3, t0.merit_serial_end AS merit_serial_end_4, t0.merit_marks_high AS merit_marks_high_5, t0.merit_marks_low AS merit_marks_low_6, t0.sdate AS sdate_7, t0.edate AS edate_8, t0.enable AS enable_9, t0.semester_id AS semester_id_10, t0.program_id AS program_id_11 FROM admission__waiting_result t0 WHERE t0.semester_id IN (?) AND t0.enable = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slot AS slot_2,
  t0.merit_serial_start AS merit_serial_start_3,
  t0.merit_serial_end AS merit_serial_end_4,
  t0.merit_marks_high AS merit_marks_high_5,
  t0.merit_marks_low AS merit_marks_low_6,
  t0.sdate AS sdate_7,
  t0.edate AS edate_8,
  t0.enable AS enable_9,
  t0.semester_id AS semester_id_10,
  t0.program_id AS program_id_11
FROM
  admission__waiting_result t0
WHERE
  t0.semester_id IN (?)
  AND t0.enable = ?

SELECT t0.id AS id_1, t0.slot AS slot_2, t0.merit_serial_start AS merit_serial_start_3, t0.merit_serial_end AS merit_serial_end_4, t0.merit_marks_high AS merit_marks_high_5, t0.merit_marks_low AS merit_marks_low_6, t0.sdate AS sdate_7, t0.edate AS edate_8, t0.enable AS enable_9, t0.semester_id AS semester_id_10, t0.program_id AS program_id_11 FROM admission__waiting_result t0 WHERE t0.semester_id IN (26) AND t0.enable = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 241)
4	App\Controller\WebController->indexAction (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 7)

0.27 ms
(13.92%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.year AS year_2, c0_.code AS code_3, c0_.start_date AS start_date_4, c0_.end_date AS end_date_5, c0_.test_date AS test_date_6, c0_.type AS type_7, c0_.enable AS enable_8 FROM calendar__semester c0_ WHERE c0_.enable = ? ORDER BY c0_.year DESC LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.year AS year_2,
  c0_.code AS code_3,
  c0_.start_date AS start_date_4,
  c0_.end_date AS end_date_5,
  c0_.test_date AS test_date_6,
  c0_.type AS type_7,
  c0_.enable AS enable_8
FROM
  calendar__semester c0_
WHERE
  c0_.enable = ?
ORDER BY
  c0_.year DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.year AS year_2, c0_.code AS code_3, c0_.start_date AS start_date_4, c0_.end_date AS end_date_5, c0_.test_date AS test_date_6, c0_.type AS type_7, c0_.enable AS enable_8 FROM calendar__semester c0_ WHERE c0_.enable = 1 ORDER BY c0_.year DESC LIMIT 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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 202)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 264)
21	App\Controller\WebController->indexAction (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 7)

0.26 ms
(13.55%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.value AS value_4, t0.type AS type_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.visibility AS visibility_8 FROM setting__config t0 WHERE t0.visibility = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.value AS value_4,
  t0.type AS type_5,
  t0.start_date AS start_date_6,
  t0.end_date AS end_date_7,
  t0.visibility AS visibility_8
FROM
  setting__config t0
WHERE
  t0.visibility = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.value AS value_4, t0.type AS type_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.visibility AS visibility_8 FROM setting__config t0 WHERE t0.visibility = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 775)
4	App\Controller\WebController->updateAccountSession (line 237)
5	App\Controller\WebController->indexAction (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 7)

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\Setting\Config	7
App\Entity\Setting\Notice	4
App\Entity\Calendar\Semester	1

Entities Mapping

Class	Mapping errors
App\Entity\Setting\Notice	No errors.
App\Entity\Setting\Config	No errors.
App\Entity\Calendar\Semester	No errors.
App\Entity\Calendar\SemesterCalendar	No errors.
App\Entity\Custodian\SemesterRoom	No errors.
App\Entity\Web\Ads	No errors.
App\Entity\Custodian\ProctorRequest	No errors.
App\Entity\Admission\WaitingResult	No errors.
App\Entity\Education\Program	No errors.

Symfony Profiler

GET https://admissions.northsouth.edu/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping