Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

71.80 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

54.03 ms

SELECT count(DISTINCT g0_.id) AS sclr_0 FROM gr_grants g0_ WHERE g0_.category_of_funding_activity LIKE ? AND g0_.close_date > ?

Parameters:

[
  "%health%"
  "2026-02-20 22:19:40"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT g0_.id) AS sclr_0
FROM
  gr_grants g0_
WHERE
  g0_.category_of_funding_activity LIKE ?
  AND g0_.close_date > ?

SELECT count(DISTINCT g0_.id) AS sclr_0 FROM gr_grants g0_ WHERE g0_.category_of_funding_activity LIKE '%health%' AND g0_.close_date > '2026-02-20 22:19:40';

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGoWLtlK\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\GrantController->search (line 115)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

5.15 ms

SELECT DISTINCT g0_.id AS id_0, g0_.close_date AS close_date_1 FROM gr_grants g0_ WHERE g0_.category_of_funding_activity LIKE ? AND g0_.close_date > ? ORDER BY g0_.close_date ASC LIMIT 25

Parameters:

[
  "%health%"
  "2026-02-20 22:19:40"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.close_date AS close_date_1
FROM
  gr_grants g0_
WHERE
  g0_.category_of_funding_activity LIKE ?
  AND g0_.close_date > ?
ORDER BY
  g0_.close_date ASC
LIMIT
  25

SELECT DISTINCT g0_.id AS id_0, g0_.close_date AS close_date_1 FROM gr_grants g0_ WHERE g0_.category_of_funding_activity LIKE '%health%' AND g0_.close_date > '2026-02-20 22:19:40' ORDER BY g0_.close_date ASC LIMIT 25;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGoWLtlK\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\GrantController->search (line 115)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

9.21 ms

SELECT g0_.agency_code AS agency_code_0, g0_.agency_name AS agency_name_1, COUNT(g0_.id) AS sclr_2 FROM gr_grants g0_ WHERE g0_.agency_code IS NOT NULL AND g0_.close_date > ? GROUP BY g0_.agency_code, g0_.agency_name ORDER BY sclr_2 DESC

Parameters:

[
  "2026-02-20 22:19:40"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.agency_code AS agency_code_0,
  g0_.agency_name AS agency_name_1,
  COUNT(g0_.id) AS sclr_2
FROM
  gr_grants g0_
WHERE
  g0_.agency_code IS NOT NULL
  AND g0_.close_date > ?
GROUP BY
  g0_.agency_code,
  g0_.agency_name
ORDER BY
  sclr_2 DESC

SELECT g0_.agency_code AS agency_code_0, g0_.agency_name AS agency_name_1, COUNT(g0_.id) AS sclr_2 FROM gr_grants g0_ WHERE g0_.agency_code IS NOT NULL AND g0_.close_date > '2026-02-20 22:19:40' GROUP BY g0_.agency_code, g0_.agency_name ORDER BY sclr_2 DESC;

#	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\GrantRepository->getAgencies (line 177)
7	App\Controller\GrantController->search (line 128)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

3.41 ms

SELECT g0_.state_code AS state_code_0, COUNT(g0_.id) AS sclr_1 FROM gr_grants g0_ WHERE g0_.state_code IS NOT NULL AND g0_.close_date > ? GROUP BY g0_.state_code ORDER BY sclr_1 DESC

Parameters:

[
  "2026-02-20 22:19:40"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.state_code AS state_code_0,
  COUNT(g0_.id) AS sclr_1
FROM
  gr_grants g0_
WHERE
  g0_.state_code IS NOT NULL
  AND g0_.close_date > ?
GROUP BY
  g0_.state_code
ORDER BY
  sclr_1 DESC

SELECT g0_.state_code AS state_code_0, COUNT(g0_.id) AS sclr_1 FROM gr_grants g0_ WHERE g0_.state_code IS NOT NULL AND g0_.close_date > '2026-02-20 22:19:40' GROUP BY g0_.state_code ORDER BY sclr_1 DESC;

#	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\GrantRepository->getStates (line 189)
7	App\Controller\GrantController->search (line 129)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Grant	No errors.

Symfony Profiler

GET https://grantarchive.com/grants?category=health

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping