Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

14.25 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.36 ms
(72.69%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_3 FROM (SELECT i0_.id AS id_0, i0_.dapip_id AS dapip_id_1, i0_.usg_id AS usg_id_2, i0_.name AS name_3, i0_.state AS state_4, i0_.address AS address_5, i0_.status AS status_6, i0_.d7_nid AS d7_nid_7, i0_.loaded_from AS loaded_from_8 FROM institution i0_ WHERE i0_.status = ?) dctrn_result_inner ORDER BY name_3 ASC) dctrn_result LIMIT 30 OFFSET 3120

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_3
    FROM
      (
        SELECT
          i0_.id AS id_0,
          i0_.dapip_id AS dapip_id_1,
          i0_.usg_id AS usg_id_2,
          i0_.name AS name_3,
          i0_.state AS state_4,
          i0_.address AS address_5,
          i0_.status AS status_6,
          i0_.d7_nid AS d7_nid_7,
          i0_.loaded_from AS loaded_from_8
        FROM
          institution i0_
        WHERE
          i0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      name_3 ASC
  ) dctrn_result
LIMIT
  30 OFFSET 3120

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_3 FROM (SELECT i0_.id AS id_0, i0_.dapip_id AS dapip_id_1, i0_.usg_id AS usg_id_2, i0_.name AS name_3, i0_.state AS state_4, i0_.address AS address_5, i0_.status AS status_6, i0_.d7_nid AS d7_nid_7, i0_.loaded_from AS loaded_from_8 FROM institution i0_ WHERE i0_.status = 1) dctrn_result_inner ORDER BY name_3 ASC) dctrn_result LIMIT 30 OFFSET 3120;

#	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 433)
12	__TwigTemplate_03da51d325b1018b6156f50afad3edce->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_03da51d325b1018b6156f50afad3edce->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 538)
30	App\Controller\ObserverPageController->observerInstitutionTable (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)

1.80 ms
(12.63%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT i0_.id AS id_0, i0_.dapip_id AS dapip_id_1, i0_.usg_id AS usg_id_2, i0_.name AS name_3, i0_.state AS state_4, i0_.address AS address_5, i0_.status AS status_6, i0_.d7_nid AS d7_nid_7, i0_.loaded_from AS loaded_from_8 FROM institution i0_ WHERE i0_.status = ? ORDER BY i0_.name 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
          i0_.id AS id_0,
          i0_.dapip_id AS dapip_id_1,
          i0_.usg_id AS usg_id_2,
          i0_.name AS name_3,
          i0_.state AS state_4,
          i0_.address AS address_5,
          i0_.status AS status_6,
          i0_.d7_nid AS d7_nid_7,
          i0_.loaded_from AS loaded_from_8
        FROM
          institution i0_
        WHERE
          i0_.status = ?
        ORDER BY
          i0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT i0_.id AS id_0, i0_.dapip_id AS dapip_id_1, i0_.usg_id AS usg_id_2, i0_.name AS name_3, i0_.state AS state_4, i0_.address AS address_5, i0_.status AS status_6, i0_.d7_nid AS d7_nid_7, i0_.loaded_from AS loaded_from_8 FROM institution i0_ WHERE i0_.status = 1 ORDER BY i0_.name 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 536)
18	App\Controller\ObserverPageController->observerInstitutionTable (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.81 ms
(5.72%)

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.80 ms
(5.61%)

SELECT i0_.id AS id_0, i0_.dapip_id AS dapip_id_1, i0_.usg_id AS usg_id_2, i0_.name AS name_3, i0_.state AS state_4, i0_.address AS address_5, i0_.status AS status_6, i0_.d7_nid AS d7_nid_7, i0_.loaded_from AS loaded_from_8 FROM institution i0_ WHERE i0_.status = ? AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.dapip_id AS dapip_id_1,
  i0_.usg_id AS usg_id_2,
  i0_.name AS name_3,
  i0_.state AS state_4,
  i0_.address AS address_5,
  i0_.status AS status_6,
  i0_.d7_nid AS d7_nid_7,
  i0_.loaded_from AS loaded_from_8
FROM
  institution i0_
WHERE
  i0_.status = ?
  AND i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.dapip_id AS dapip_id_1, i0_.usg_id AS usg_id_2, i0_.name AS name_3, i0_.state AS state_4, i0_.address AS address_5, i0_.status AS status_6, i0_.d7_nid AS d7_nid_7, i0_.loaded_from AS loaded_from_8 FROM institution i0_ WHERE i0_.status = 1 AND i0_.id IN (2182, 3234, 597, 2500, 2565, 3125, 2738, 3253, 3216, 3312, 70, 984, 2615, 3350, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3358, 3359, 3360, 3361, 3362, 3363, 3406, 1059, 1534) ORDER BY i0_.name 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 433)
12	__TwigTemplate_03da51d325b1018b6156f50afad3edce->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_03da51d325b1018b6156f50afad3edce->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 538)
30	App\Controller\ObserverPageController->observerInstitutionTable (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.48 ms
(3.35%)

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\Institution	No errors.

Symfony Profiler

GET https://www.tc.innovation.registrar.gatech.edu/secure/observer/institution?page=105

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping