Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.54 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.92 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.address AS address_2, s0_.city AS city_3, s0_.zip_code AS zip_code_4, s0_.state AS state_5, s0_.country AS country_6, s0_.phone AS phone_7, s0_.price AS price_8, s0_.administrative_costs AS administrative_costs_9, s0_.image_path AS image_path_10, s0_.banner AS banner_11, s0_.fallback_color_from AS fallback_color_from_12, s0_.fallback_color_to AS fallback_color_to_13, s0_.banner_blur AS banner_blur_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.merchant_id AS merchant_id_17 FROM space s0_ ORDER BY s0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.address AS address_2,
  s0_.city AS city_3,
  s0_.zip_code AS zip_code_4,
  s0_.state AS state_5,
  s0_.country AS country_6,
  s0_.phone AS phone_7,
  s0_.price AS price_8,
  s0_.administrative_costs AS administrative_costs_9,
  s0_.image_path AS image_path_10,
  s0_.banner AS banner_11,
  s0_.fallback_color_from AS fallback_color_from_12,
  s0_.fallback_color_to AS fallback_color_to_13,
  s0_.banner_blur AS banner_blur_14,
  s0_.created_at AS created_at_15,
  s0_.updated_at AS updated_at_16,
  s0_.merchant_id AS merchant_id_17
FROM
  space s0_
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.address AS address_2, s0_.city AS city_3, s0_.zip_code AS zip_code_4, s0_.state AS state_5, s0_.country AS country_6, s0_.phone AS phone_7, s0_.price AS price_8, s0_.administrative_costs AS administrative_costs_9, s0_.image_path AS image_path_10, s0_.banner AS banner_11, s0_.fallback_color_from AS fallback_color_from_12, s0_.fallback_color_to AS fallback_color_to_13, s0_.banner_blur AS banner_blur_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.merchant_id AS merchant_id_17 FROM space s0_ ORDER BY s0_.id 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\SpaceRepository->getSpaces (line 132)
7	App\Controller\Open\SpaceController->index (line 64)
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 7)

0.97 ms

SELECT t0_.id AS id_0, t0_.entity_class AS entity_class_1, t0_.entity_id AS entity_id_2, t0_.price AS price_3, t0_.fromDate AS fromDate_4, t0_.toDate AS toDate_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM temporary_price t0_ WHERE t0_.entity_class = ? AND t0_.entity_id = ? AND t0_.fromDate <= ? AND t0_.toDate >= ?

Parameters:

[
  "Space"
  "34399160-edb0-4ad9-811b-49fb01c84be5"
  "2026-06-19 20:13:18"
  "2026-06-19 20:13:18"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.entity_class AS entity_class_1,
  t0_.entity_id AS entity_id_2,
  t0_.price AS price_3,
  t0_.fromDate AS fromDate_4,
  t0_.toDate AS toDate_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7
FROM
  temporary_price t0_
WHERE
  t0_.entity_class = ?
  AND t0_.entity_id = ?
  AND t0_.fromDate <= ?
  AND t0_.toDate >= ?

SELECT t0_.id AS id_0, t0_.entity_class AS entity_class_1, t0_.entity_id AS entity_id_2, t0_.price AS price_3, t0_.fromDate AS fromDate_4, t0_.toDate AS toDate_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM temporary_price t0_ WHERE t0_.entity_class = 'Space' AND t0_.entity_id = '34399160-edb0-4ad9-811b-49fb01c84be5' AND t0_.fromDate <= '2026-06-19 20:13:18' AND t0_.toDate >= '2026-06-19 20:13:18';

#	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\TemporaryPriceRepository->findByEntityAndEntityIdAndDate (line 108)
7	App\Service\Manager\SpaceManager->findFinallyPrice (line 210)
8	App\Serializer\SpaceNormalizer->rewriteFinalPriceIfTemporaryPriceExist (line 109)
9	App\Serializer\SpaceNormalizer->normalize (line 43)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Serializer->normalize (line 152)
12	Symfony\Component\Serializer\Serializer->normalize (line 170)
13	Symfony\Component\Serializer\Serializer->serialize (line 131)
14	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
15	App\Controller\AbstractApiController->serialize (line 82)
16	App\Controller\Open\SpaceController->index (line 69)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 7)

0.64 ms

SELECT t0_.id AS id_0, t0_.entity_class AS entity_class_1, t0_.entity_id AS entity_id_2, t0_.price AS price_3, t0_.fromDate AS fromDate_4, t0_.toDate AS toDate_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM temporary_price t0_ WHERE t0_.entity_class = ? AND t0_.entity_id = ? AND t0_.fromDate <= ? AND t0_.toDate >= ?

Parameters:

[
  "Space"
  "998814f6-7087-460d-8bb5-bb755f6bb115"
  "2026-06-19 20:13:18"
  "2026-06-19 20:13:18"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.entity_class AS entity_class_1,
  t0_.entity_id AS entity_id_2,
  t0_.price AS price_3,
  t0_.fromDate AS fromDate_4,
  t0_.toDate AS toDate_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7
FROM
  temporary_price t0_
WHERE
  t0_.entity_class = ?
  AND t0_.entity_id = ?
  AND t0_.fromDate <= ?
  AND t0_.toDate >= ?

SELECT t0_.id AS id_0, t0_.entity_class AS entity_class_1, t0_.entity_id AS entity_id_2, t0_.price AS price_3, t0_.fromDate AS fromDate_4, t0_.toDate AS toDate_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM temporary_price t0_ WHERE t0_.entity_class = 'Space' AND t0_.entity_id = '998814f6-7087-460d-8bb5-bb755f6bb115' AND t0_.fromDate <= '2026-06-19 20:13:18' AND t0_.toDate >= '2026-06-19 20:13:18';

#	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\TemporaryPriceRepository->findByEntityAndEntityIdAndDate (line 108)
7	App\Service\Manager\SpaceManager->findFinallyPrice (line 210)
8	App\Serializer\SpaceNormalizer->rewriteFinalPriceIfTemporaryPriceExist (line 109)
9	App\Serializer\SpaceNormalizer->normalize (line 43)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Serializer->normalize (line 152)
12	Symfony\Component\Serializer\Serializer->normalize (line 170)
13	Symfony\Component\Serializer\Serializer->serialize (line 131)
14	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
15	App\Controller\AbstractApiController->serialize (line 82)
16	App\Controller\Open\SpaceController->index (line 69)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 7)

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\Space	2
App\Entity\Merchant	2

Entities Mapping

Class	Mapping errors
App\Entity\Space	No errors.
App\Entity\Merchant	No errors.
App\Entity\User	No errors.
App\Entity\Room	No errors.
App\Entity\TemporaryPrice	No errors.

Symfony Profiler

GET https://ticket-sales.dracoder.com/api/open/space/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping