Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.79 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.84 ms
(30.27%)

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)

0.73 ms
(26.35%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_1 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.status AS status_2, d0_.d7_nid AS d7_nid_3, d0_.loaded_from AS loaded_from_4 FROM department d0_ WHERE d0_.status = ?) dctrn_result_inner ORDER BY name_1 ASC) dctrn_result LIMIT 30 OFFSET 30

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_1
    FROM
      (
        SELECT
          d0_.id AS id_0,
          d0_.name AS name_1,
          d0_.status AS status_2,
          d0_.d7_nid AS d7_nid_3,
          d0_.loaded_from AS loaded_from_4
        FROM
          department d0_
        WHERE
          d0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      name_1 ASC
  ) dctrn_result
LIMIT
  30 OFFSET 30

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_1 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.status AS status_2, d0_.d7_nid AS d7_nid_3, d0_.loaded_from AS loaded_from_4 FROM department d0_ WHERE d0_.status = 1) dctrn_result_inner ORDER BY name_1 ASC) dctrn_result LIMIT 30 OFFSET 30;

#	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 292)
12	__TwigTemplate_e71886798aa4e6d073d5e7f0b0be4908->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_e71886798aa4e6d073d5e7f0b0be4908->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 461)
30	App\Controller\ObserverPageController->observerDepartmentTable (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.65 ms
(23.16%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.status AS status_2, d0_.d7_nid AS d7_nid_3, d0_.loaded_from AS loaded_from_4 FROM department d0_ WHERE d0_.status = ? ORDER BY d0_.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
          d0_.id AS id_0,
          d0_.name AS name_1,
          d0_.status AS status_2,
          d0_.d7_nid AS d7_nid_3,
          d0_.loaded_from AS loaded_from_4
        FROM
          department d0_
        WHERE
          d0_.status = ?
        ORDER BY
          d0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.status AS status_2, d0_.d7_nid AS d7_nid_3, d0_.loaded_from AS loaded_from_4 FROM department d0_ WHERE d0_.status = 1 ORDER BY d0_.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 459)
18	App\Controller\ObserverPageController->observerDepartmentTable (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.56 ms
(20.22%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.status AS status_2, d0_.d7_nid AS d7_nid_3, d0_.loaded_from AS loaded_from_4 FROM department d0_ WHERE d0_.status = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.status AS status_2,
  d0_.d7_nid AS d7_nid_3,
  d0_.loaded_from AS loaded_from_4
FROM
  department d0_
WHERE
  d0_.status = ?
  AND d0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.status AS status_2, d0_.d7_nid AS d7_nid_3, d0_.loaded_from AS loaded_from_4 FROM department d0_ WHERE d0_.status = 1 AND d0_.id IN (22, 53, 54, 52, 23, 59, 60, 61, 62, 63, 24, 64, 65, 66, 67, 68, 25, 26, 27, 28, 29, 46, 30, 31, 32, 55, 33, 34, 35, 56) ORDER BY d0_.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 292)
12	__TwigTemplate_e71886798aa4e6d073d5e7f0b0be4908->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_e71886798aa4e6d073d5e7f0b0be4908->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 461)
30	App\Controller\ObserverPageController->observerDepartmentTable (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)

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

Symfony Profiler

GET https://tc.innovation.registrar.gatech.edu/secure/observer/department?page=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping