Symfony Profiler

Query Metrics

15 Database Queries

6 Different statements

6,48 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3,65 ms
(56,32%)

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1

Parameters:

[
  "perspektiva"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\PageController->apartment3 (line 107)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0,75 ms
(11,53%)

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = ? AND a0_.residential_development = ?

Parameters:

[
  2
  "perspektiva"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  apartment a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.room_count = ?
  AND a0_.residential_development = ?

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = 2 AND a0_.residential_development = 'perspektiva';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 802)
7	App\Service\Pagination\EntityPaginator->getCount (line 67)
8	App\Service\Pagination\EntityPaginator->getPagination (line 37)
9	App\Controller\PageController->apartment3 (line 120)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0,69 ms
(10,71%)

SELECT a0_.id AS id_0, a0_.residential_development AS residential_development_1, a0_.room_count AS room_count_2, a0_.price AS price_3, a0_.square AS square_4, a0_.floor AS floor_5, a0_.business AS business_6, a0_.tags AS tags_7, a0_.side_window AS side_window_8, a0_.images AS images_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.extra_data AS extra_data_12, a0_.deleted_at AS deleted_at_13 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = ? AND a0_.residential_development = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.price ASC

Parameters:

[
  2
  "perspektiva"
  92
  91
  40
  95
  93
  39
  16
  38
  23
  94
  90
  35
  36
  37
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.residential_development AS residential_development_1,
  a0_.room_count AS room_count_2,
  a0_.price AS price_3,
  a0_.square AS square_4,
  a0_.floor AS floor_5,
  a0_.business AS business_6,
  a0_.tags AS tags_7,
  a0_.side_window AS side_window_8,
  a0_.images AS images_9,
  a0_.created_at AS created_at_10,
  a0_.updated_at AS updated_at_11,
  a0_.extra_data AS extra_data_12,
  a0_.deleted_at AS deleted_at_13
FROM
  apartment a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.room_count = ?
  AND a0_.residential_development = ?
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.price ASC

SELECT a0_.id AS id_0, a0_.residential_development AS residential_development_1, a0_.room_count AS room_count_2, a0_.price AS price_3, a0_.square AS square_4, a0_.floor AS floor_5, a0_.business AS business_6, a0_.tags AS tags_7, a0_.side_window AS side_window_8, a0_.images AS images_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.extra_data AS extra_data_12, a0_.deleted_at AS deleted_at_13 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = 2 AND a0_.residential_development = 'perspektiva' AND a0_.id IN (92, 91, 40, 95, 93, 39, 16, 38, 23, 94, 90, 35, 36, 37, 15) ORDER BY a0_.price ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
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	Container42ek7Bb\PaginatorProxyBa079e5->paginate (line 20)
15	App\Service\Pagination\EntityPaginator->getPagination (line 39)
16	App\Controller\PageController->apartment3 (line 120)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0,52 ms
(7,99%)

SELECT DISTINCT a0_.id AS id_0, a0_.price AS price_1 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = ? AND a0_.residential_development = ? ORDER BY a0_.price ASC LIMIT 15

Parameters:

[
  2
  "perspektiva"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.price AS price_1
FROM
  apartment a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.room_count = ?
  AND a0_.residential_development = ?
ORDER BY
  a0_.price ASC
LIMIT
  15

SELECT DISTINCT a0_.id AS id_0, a0_.price AS price_1 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = 2 AND a0_.residential_development = 'perspektiva' ORDER BY a0_.price ASC LIMIT 15;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
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	Container42ek7Bb\PaginatorProxyBa079e5->paginate (line 20)
15	App\Service\Pagination\EntityPaginator->getPagination (line 39)
16	App\Controller\PageController->apartment3 (line 120)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0,47 ms
(7,21%)

SELECT DISTINCT a0_.room_count AS room_count_0 FROM apartment a0_ WHERE a0_.residential_development = ? ORDER BY room_count_0 ASC

Parameters:

[
  "perspektiva"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.room_count AS room_count_0
FROM
  apartment a0_
WHERE
  a0_.residential_development = ?
ORDER BY
  room_count_0 ASC

SELECT DISTINCT a0_.room_count AS room_count_0 FROM apartment a0_ WHERE a0_.residential_development = 'perspektiva' ORDER BY room_count_0 ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 701)
6	App\Repository\ApartmentRepository->getUniqueRoomCounts (line 35)
7	App\Controller\PageController->getUniqueRoomCounts (line 160)
8	App\Controller\PageController->apartment3 (line 127)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0,40 ms
(6,23%)

SELECT COUNT(a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.business = 1 AND a0_.residential_development = ?

Parameters:

[
  "perspektiva"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  apartment a0_
WHERE
  a0_.business = 1
  AND a0_.residential_development = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.business = 1 AND a0_.residential_development = 'perspektiva';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 802)
7	App\Repository\ApartmentRepository->hasBusiness (line 48)
8	App\Controller\PageController->apartment3 (line 128)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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
App\Entity\Apartment	15
App\Entity\ResidentialDevData	1

Entities Mapping

Class	Mapping errors
App\Entity\ResidentialDevData	No errors.
App\Entity\Apartment	No errors.

Symfony Profiler

GET https://xn--1--3lc1a.xn--p1ai/perspektiva/3-komnatnye-kvartiry

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping