Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.51 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

3.83 ms

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM album a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  album a0_

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM album a0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerSP3wfa0\PaginatorProxy9cc2a8f->paginate (line 26)
16	App\Controller\GalleryController->index (line 181)
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.85 ms

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM album a0_ ORDER BY a0_.created_at DESC LIMIT 12 OFFSET 36

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created_at AS created_at_1
FROM
  album a0_
ORDER BY
  a0_.created_at DESC
LIMIT
  12 OFFSET 36

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM album a0_ ORDER BY a0_.created_at DESC LIMIT 12 OFFSET 36;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerSP3wfa0\PaginatorProxy9cc2a8f->paginate (line 26)
16	App\Controller\GalleryController->index (line 181)
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.83 ms

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.image_path AS image_path_3, a0_.created_at AS created_at_4 FROM album a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.image_path AS image_path_3,
  a0_.created_at AS created_at_4
FROM
  album a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.image_path AS image_path_3, a0_.created_at AS created_at_4 FROM album a0_ WHERE a0_.id IN (47, 39, 51, 41, 42, 44, 45, 46, 48, 49, 50, 40) ORDER BY a0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerSP3wfa0\PaginatorProxy9cc2a8f->paginate (line 26)
16	App\Controller\GalleryController->index (line 181)
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)

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

Symfony Profiler

GET https://capapoteentrenous.com/galerie?page=4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping