Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.57 ms Query time

0 Invalid entities

0 Managed entities

Time▼

Count

Info

1.24 ms
(78.86%)

SELECT p0_.status AS status_0, COUNT(p0_.id) AS sclr_1 FROM project p0_ GROUP BY p0_.status

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.status AS status_0,
  COUNT(p0_.id) AS sclr_1
FROM
  project p0_
GROUP BY
  p0_.status

SELECT p0_.status AS status_0, COUNT(p0_.id) AS sclr_1 FROM project p0_ GROUP BY p0_.status;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ProjectRepository->countByStatus (line 50)
7	App\Service\DashboardService->getProjectStatusData (line 53)
8	App\Controller\DashboardController->reports (line 109)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.20 ms
(12.54%)

SELECT a0_.status AS status_0, COUNT(a0_.id) AS sclr_1 FROM activity a0_ GROUP BY a0_.status

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.status AS status_0,
  COUNT(a0_.id) AS sclr_1
FROM
  activity a0_
GROUP BY
  a0_.status

SELECT a0_.status AS status_0, COUNT(a0_.id) AS sclr_1 FROM activity a0_ GROUP BY a0_.status;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActivityRepository->countByStatus (line 86)
7	App\Service\DashboardService->getActivityStatusData (line 77)
8	App\Controller\DashboardController->reports (line 110)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.13 ms
(8.60%)

SELECT i0_.category AS category_0, COUNT(i0_.id) AS sclr_1 FROM indicator i0_ GROUP BY i0_.category

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.category AS category_0,
  COUNT(i0_.id) AS sclr_1
FROM
  indicator i0_
GROUP BY
  i0_.category

SELECT i0_.category AS category_0, COUNT(i0_.id) AS sclr_1 FROM indicator i0_ GROUP BY i0_.category;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\IndicatorRepository->countByCategory (line 61)
7	App\Service\DashboardService->getIndicatorCategoryData (line 101)
8	App\Controller\DashboardController->reports (line 111)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects