Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.17 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.51 ms
(23.59%)

SELECT c0_.id AS id_0, c0_.model AS model_1, c0_.version AS version_2, c0_.vin AS vin_3, c0_.license_plate AS license_plate_4, c0_.color AS color_5, c0_.km AS km_6, c0_.registration AS registration_7, c0_.deleted AS deleted_8, c0_.buy_price AS buy_price_9, c0_.sell_price_b2b AS sell_price_b2b_10, c0_.sell_price_b2c AS sell_price_b2c_11, c0_.brand_id AS brand_id_12, c0_.status_id AS status_id_13, c0_.fuel_id AS fuel_id_14 FROM car c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.model AS model_1,
  c0_.version AS version_2,
  c0_.vin AS vin_3,
  c0_.license_plate AS license_plate_4,
  c0_.color AS color_5,
  c0_.km AS km_6,
  c0_.registration AS registration_7,
  c0_.deleted AS deleted_8,
  c0_.buy_price AS buy_price_9,
  c0_.sell_price_b2b AS sell_price_b2b_10,
  c0_.sell_price_b2c AS sell_price_b2c_11,
  c0_.brand_id AS brand_id_12,
  c0_.status_id AS status_id_13,
  c0_.fuel_id AS fuel_id_14
FROM
  car c0_

SELECT c0_.id AS id_0, c0_.model AS model_1, c0_.version AS version_2, c0_.vin AS vin_3, c0_.license_plate AS license_plate_4, c0_.color AS color_5, c0_.km AS km_6, c0_.registration AS registration_7, c0_.deleted AS deleted_8, c0_.buy_price AS buy_price_9, c0_.sell_price_b2b AS sell_price_b2b_10, c0_.sell_price_b2c AS sell_price_b2c_11, c0_.brand_id AS brand_id_12, c0_.status_id AS status_id_13, c0_.fuel_id AS fuel_id_14 FROM car c0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 451)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\CustomerController->newNegotiation (line 139)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.45 ms
(20.68%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.company_name AS company_name_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.city AS city_7, t0.zip AS zip_8, t0.address AS address_9, t0.province AS province_10, t0.type_id AS type_id_11, t0.nationality_id AS nationality_id_12 FROM customer t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.company_name AS company_name_4,
  t0.fiscal_code AS fiscal_code_5,
  t0.vat AS vat_6,
  t0.city AS city_7,
  t0.zip AS zip_8,
  t0.address AS address_9,
  t0.province AS province_10,
  t0.type_id AS type_id_11,
  t0.nationality_id AS nationality_id_12
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.company_name AS company_name_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.city AS city_7, t0.zip AS zip_8, t0.address AS address_9, t0.province AS province_10, t0.type_id AS type_id_11, t0.nationality_id AS nationality_id_12 FROM customer t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.43 ms
(19.58%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Brand::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Brand->__get (line 153)
7	App\Entity\Brand->getName (line 40)
8	App\Form\CustomerNegotiationType->App\Form\{closure} (line 26)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->addChoiceView (line 158)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 233)
11	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::createView (line 123)
12	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
13	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
15	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
20	Symfony\Component\Form\Form->createView (line 888)
21	Symfony\Component\Form\Form->createView (line 891)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 451)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
25	App\Controller\CustomerController->newNegotiation (line 139)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.40 ms
(18.61%)

SELECT f0_.id AS id_0, f0_.name AS name_1 FROM fuel f0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1
FROM
  fuel f0_

SELECT f0_.id AS id_0, f0_.name AS name_1 FROM fuel f0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 451)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\CustomerController->newNegotiation (line 139)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.38 ms
(17.55%)

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM brand b0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  brand b0_

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM brand b0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 451)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\CustomerController->newNegotiation (line 139)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	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\Fuel	2
App\Entity\Customer	1
App\Entity\CustomerType	1
App\Entity\Car	1
App\Entity\Brand	1
App\Entity\CarStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\Customer	No errors.
App\Entity\CustomerType	No errors.
App\Entity\Nation	No errors.
App\Entity\Contract	No errors.
App\Entity\Preventive	No errors.
App\Entity\CustomerNegotiation	No errors.
App\Entity\Car	No errors.
App\Entity\Brand	No errors.
App\Entity\Fuel	No errors.
App\Entity\CarStatus	No errors.
App\Entity\CarPhoto	No errors.
App\Entity\ContractCar	No errors.
App\Entity\PreventiveCar	No errors.

Symfony Profiler

GET https://demolivio.garnockcode.ovh/customer/1/negotiations/new

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping