Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.58 ms Query time

7 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.68 ms

SELECT e0_.estimate_work_id AS estimate_work_id_0, e0_.created_at AS created_at_1, e0_.deleted_at AS deleted_at_2, e0_.key AS key_3, e0_.quantity_real AS quantity_real_4, e0_.quantity AS quantity_5, e0_.price AS price_6, e0_.amount AS amount_7, e0_.estimate_id AS estimate_id_8, e0_.work_id AS work_id_9 FROM estimate_estimates_works e0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.estimate_work_id AS estimate_work_id_0,
  e0_.created_at AS created_at_1,
  e0_.deleted_at AS deleted_at_2,
  e0_.key AS key_3,
  e0_.quantity_real AS quantity_real_4,
  e0_.quantity AS quantity_5,
  e0_.price AS price_6,
  e0_.amount AS amount_7,
  e0_.estimate_id AS estimate_id_8,
  e0_.work_id AS work_id_9
FROM
  estimate_estimates_works e0_

SELECT e0_.estimate_work_id AS estimate_work_id_0, e0_.created_at AS created_at_1, e0_.deleted_at AS deleted_at_2, e0_.key AS key_3, e0_.quantity_real AS quantity_real_4, e0_.quantity AS quantity_5, e0_.price AS price_6, e0_.amount AS amount_7, e0_.estimate_id AS estimate_id_8, e0_.work_id AS work_id_9 FROM estimate_estimates_works e0_;

#	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 202)
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	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.90 ms

SELECT m0_.material_id AS material_id_0, m0_.created_at AS created_at_1, m0_.deleted_at AS deleted_at_2, m0_.key AS key_3, m0_.name AS name_4, m0_.type_id AS type_id_5, m0_.group_id AS group_id_6 FROM material_materials m0_ WHERE (m0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.material_id AS material_id_0,
  m0_.created_at AS created_at_1,
  m0_.deleted_at AS deleted_at_2,
  m0_.key AS key_3,
  m0_.name AS name_4,
  m0_.type_id AS type_id_5,
  m0_.group_id AS group_id_6
FROM
  material_materials m0_
WHERE
  (m0_.deleted_at IS NULL)

SELECT m0_.material_id AS material_id_0, m0_.created_at AS created_at_1, m0_.deleted_at AS deleted_at_2, m0_.key AS key_3, m0_.name AS name_4, m0_.type_id AS type_id_5, m0_.group_id AS group_id_6 FROM material_materials m0_ WHERE (m0_.deleted_at IS NULL);

#	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 202)
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	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	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
Material\Entity\Material	1
Material\Entity\Group	1

Entities Mapping

Class	Mapping errors
Estimate\Entity\EstimateMaterial	The field 'Estimate\Entity\EstimateMaterial#quantityReal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'Estimate\Entity\EstimateMaterial#quantity' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'Estimate\Entity\EstimateMaterial#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'Estimate\Entity\EstimateMaterial#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Estimate\Entity\EstimateWork	The field 'Estimate\Entity\EstimateWork#quantityReal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'Estimate\Entity\EstimateWork#quantity' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'Estimate\Entity\EstimateWork#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'Estimate\Entity\EstimateWork#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Material\Entity\Material	The field Material\Entity\Material#prices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Material\Entity\Price#material does not contain the required 'inversedBy: "prices"' attribute.
Estimate\Entity\Estimate	No errors.
Work\Entity\Work	The field Work\Entity\Work#prices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Work\Entity\Price#work does not contain the required 'inversedBy: "prices"' attribute.
Material\Entity\Type	No errors.
Material\Entity\GroupTree	No errors.
Material\Entity\Group	The association Material\Entity\Group#materials refers to the owning side field Material\Entity\Material#material which does not exist.
Work\Entity\WorkMaterial	The field 'Work\Entity\WorkMaterial#count' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Material\Entity\Price	The field 'Material\Entity\Price#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

GET http://admin-symfony-review.kube-dev.ugol.click/estimate-material/new

Configuration Settings

Theme

Page Width