Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

20.29 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.98 ms
(44.27%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, subject_code_2 FROM (SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.subject_code AS subject_code_2, c0_.course_number AS course_number_3, c0_.status AS status_4, c0_.d7_nid AS d7_nid_5, c0_.loaded_from AS loaded_from_6 FROM course c0_ WHERE c0_.status = ?) dctrn_result_inner ORDER BY subject_code_2 ASC) dctrn_result LIMIT 30 OFFSET 1560

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      subject_code_2
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.slug AS slug_1,
          c0_.subject_code AS subject_code_2,
          c0_.course_number AS course_number_3,
          c0_.status AS status_4,
          c0_.d7_nid AS d7_nid_5,
          c0_.loaded_from AS loaded_from_6
        FROM
          course c0_
        WHERE
          c0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      subject_code_2 ASC
  ) dctrn_result
LIMIT
  30 OFFSET 1560

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, subject_code_2 FROM (SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.subject_code AS subject_code_2, c0_.course_number AS course_number_3, c0_.status AS status_4, c0_.d7_nid AS d7_nid_5, c0_.loaded_from AS loaded_from_6 FROM course c0_ WHERE c0_.status = 1) dctrn_result_inner ORDER BY subject_code_2 ASC) dctrn_result LIMIT 30 OFFSET 1560;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 252)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 238)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 407)
11	Pagerfanta\Pagerfanta->getIterator (line 351)
12	__TwigTemplate_68cf5b620c76ddb3283a8db1e56b6bad->block_content (line 171)
13	Twig\Template->displayBlock (line 135)
14	__TwigTemplate_5e0c6ab78a4db9e173c79578d180ea7a->block_page (line 171)
15	Twig\Template->displayBlock (line 219)
16	__TwigTemplate_ffdc5521cb50f22f553e9538a0a6f2cc->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 51)
19	__TwigTemplate_5e0c6ab78a4db9e173c79578d180ea7a->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_68cf5b620c76ddb3283a8db1e56b6bad->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 243)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 999)
30	App\Controller\CoordinatorPageController->coordinatorCourseTable (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

5.45 ms
(26.86%)

SELECT DISTINCT c0_.subject_code AS subject_code_0 FROM course c0_ WHERE c0_.status = ? ORDER BY c0_.subject_code ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.subject_code AS subject_code_0
FROM
  course c0_
WHERE
  c0_.status = ?
ORDER BY
  c0_.subject_code ASC

SELECT DISTINCT c0_.subject_code AS subject_code_0 FROM course c0_ WHERE c0_.status = 1 ORDER BY c0_.subject_code ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 55)
7	App\Repository\CourseRepository->getActiveSubjectChoices (line 24)
8	App\Service\FormOptionsService->getSubjectCodeOptions (line 1008)
9	App\Controller\CoordinatorPageController->coordinatorCourseTable (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.99 ms
(19.69%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.subject_code AS subject_code_2, c0_.course_number AS course_number_3, c0_.status AS status_4, c0_.d7_nid AS d7_nid_5, c0_.loaded_from AS loaded_from_6 FROM course c0_ WHERE c0_.status = ? ORDER BY c0_.subject_code ASC) dctrn_result) dctrn_table

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.slug AS slug_1,
          c0_.subject_code AS subject_code_2,
          c0_.course_number AS course_number_3,
          c0_.status AS status_4,
          c0_.d7_nid AS d7_nid_5,
          c0_.loaded_from AS loaded_from_6
        FROM
          course c0_
        WHERE
          c0_.status = ?
        ORDER BY
          c0_.subject_code ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.subject_code AS subject_code_2, c0_.course_number AS course_number_3, c0_.status AS status_4, c0_.d7_nid AS d7_nid_5, c0_.loaded_from AS loaded_from_6 FROM course c0_ WHERE c0_.status = 1 ORDER BY c0_.subject_code ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 42)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 285)
9	Pagerfanta\Pagerfanta->getNbResults (line 314)
10	Pagerfanta\Pagerfanta->calculateNbPages (line 296)
11	Pagerfanta\Pagerfanta->getNbPages (line 202)
12	Pagerfanta\Pagerfanta->currentPageOutOfRange (line 197)
13	Pagerfanta\Pagerfanta->notAllowedCurrentPageOutOfRange (line 188)
14	Pagerfanta\Pagerfanta->filterOutOfRangeCurrentPage (line 170)
15	Pagerfanta\Pagerfanta->filterCurrentPage (line 157)
16	Pagerfanta\Pagerfanta->setCurrentPage (line 65)
17	Pagerfanta\Pagerfanta::createForCurrentPageWithMaxPerPage (line 997)
18	App\Controller\CoordinatorPageController->coordinatorCourseTable (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.79 ms
(3.91%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.id = ?

Parameters:

[
  b"\x01òñ¬ò¬t▄Ü-TYbÜØã"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.id = 0x0195A4AA95AA74DC9A2D5459629A9DC6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.60 ms
(2.93%)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.subject_code AS subject_code_2, c0_.course_number AS course_number_3, c0_.status AS status_4, c0_.d7_nid AS d7_nid_5, c0_.loaded_from AS loaded_from_6 FROM course c0_ WHERE c0_.status = ? AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.subject_code ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.subject_code AS subject_code_2,
  c0_.course_number AS course_number_3,
  c0_.status AS status_4,
  c0_.d7_nid AS d7_nid_5,
  c0_.loaded_from AS loaded_from_6
FROM
  course c0_
WHERE
  c0_.status = ?
  AND c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  c0_.subject_code ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.subject_code AS subject_code_2, c0_.course_number AS course_number_3, c0_.status AS status_4, c0_.d7_nid AS d7_nid_5, c0_.loaded_from AS loaded_from_6 FROM course c0_ WHERE c0_.status = 1 AND c0_.id IN (1279, 1278, 1277, 1276, 1275, 1274, 1273, 1272, 1271, 1270, 1269, 1282, 1283, 1284, 1297, 1296, 1295, 1294, 1293, 1292, 1291, 1290, 1289, 1288, 1287, 1286, 1285, 1268, 1329, 1360) ORDER BY c0_.subject_code ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 252)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 238)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 407)
11	Pagerfanta\Pagerfanta->getIterator (line 351)
12	__TwigTemplate_68cf5b620c76ddb3283a8db1e56b6bad->block_content (line 171)
13	Twig\Template->displayBlock (line 135)
14	__TwigTemplate_5e0c6ab78a4db9e173c79578d180ea7a->block_page (line 171)
15	Twig\Template->displayBlock (line 219)
16	__TwigTemplate_ffdc5521cb50f22f553e9538a0a6f2cc->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 51)
19	__TwigTemplate_5e0c6ab78a4db9e173c79578d180ea7a->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_68cf5b620c76ddb3283a8db1e56b6bad->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 243)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 999)
30	App\Controller\CoordinatorPageController->coordinatorCourseTable (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.47 ms
(2.34%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "kfan64"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.username = 'kfan64' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 38)
4	App\Security\DevAuthenticator->authenticate (line 60)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 66)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Evaluation	No errors.
App\Entity\Note	No errors.
App\Entity\Affiliation	No errors.
App\Entity\Course	No errors.

Symfony Profiler

GET https://www.tc.innovation.registrar.gatech.edu/secure/coordinator/course?direction=asc&orderby=subjectCode&page=53

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping