Symfony Profiler

Query Metrics

7 Database Queries

3 Different statements

1.68 ms Query time

1 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.08 ms
(64.54%)

SELECT t0.id AS id_1, t0.price AS price_2, t0.date_update AS date_update_3, t0.currency AS currency_4, t0.type AS type_5, t0.date_create AS date_create_6, t0.vehicle_type_id AS vehicle_type_id_7 FROM vehicle_price t0 WHERE t0.vehicle_type_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.date_update AS date_update_3,
  t0.currency AS currency_4,
  t0.type AS type_5,
  t0.date_create AS date_create_6,
  t0.vehicle_type_id AS vehicle_type_id_7
FROM
  vehicle_price t0
WHERE
  t0.vehicle_type_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.date_update AS date_update_3, t0.currency AS currency_4, t0.type AS type_5, t0.date_create AS date_create_6, t0.vehicle_type_id AS vehicle_type_id_7 FROM vehicle_price t0 WHERE t0.vehicle_type_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 57)
8	App\Infrastructure\Invers\Dto\VehicleTypeDto::createFromEntity (line 24)
9	App\Infrastructure\Invers\Service\VehicleTypeService->App\Infrastructure\Invers\Service\{closure} (line 1)
10	array_map (line 24)
11	App\Infrastructure\Invers\Service\VehicleTypeService->vehicleTypeList (line 110)
12	App\Controller\Page\PageController->root (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.36 ms
(21.60%)

SELECT t0.id AS id_1, t0.street AS street_2, t0.country AS country_3, t0.zip AS zip_4, t0.city AS city_5, t0.state AS state_6, t0.altitude AS altitude_7, t0.name AS name_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10 FROM place t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.country AS country_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.altitude AS altitude_7,
  t0.name AS name_8,
  t0.longitude AS longitude_9,
  t0.latitude AS latitude_10
FROM
  place t0

SELECT t0.id AS id_1, t0.street AS street_2, t0.country AS country_3, t0.zip AS zip_4, t0.city AS city_5, t0.state AS state_6, t0.altitude AS altitude_7, t0.name AS name_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10 FROM place t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 37)
6	App\Repository\Place\PlaceRepository->findAll (line 25)
7	App\Domain\Place\Service\PlaceService->placeList (line 108)
8	App\Controller\Page\PageController->root (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.23 ms
(13.86%)

SELECT t0.id AS id_1, t0.date_update AS date_update_2, t0.technical_data AS technical_data_3, t0.type AS type_4, t0.date_create AS date_create_5 FROM vehicle_type t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_update AS date_update_2,
  t0.technical_data AS technical_data_3,
  t0.type AS type_4,
  t0.date_create AS date_create_5
FROM
  vehicle_type t0

SELECT t0.id AS id_1, t0.date_update AS date_update_2, t0.technical_data AS technical_data_3, t0.type AS type_4, t0.date_create AS date_create_5 FROM vehicle_type t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 37)
6	App\Repository\Vehicle\VehicleTypeRepository->findAll (line 22)
7	App\Infrastructure\Invers\Service\VehicleTypeService->vehicleTypeList (line 110)
8	App\Controller\Page\PageController->root (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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
App\Entity\Vehicle\VehicleType	5
App\Entity\Vehicle\VehiclePrice	4
App\Entity\Place\Place	3

Entities Mapping

Class	Mapping errors
App\Entity\Place\Place	No errors.
App\Entity\Vehicle\VehicleType	No errors.
App\Entity\Vehicle\Vehicle	No errors.
App\Entity\Vehicle\VehiclePrice	The field 'App\Entity\Vehicle\VehiclePrice#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

GET https://dev.uppio.sk/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping