Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.91 ms Query time

5 Invalid entities

41 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.27 ms

SELECT e0_.estimate_id AS estimate_id_0, e0_.created_at AS created_at_1, e0_.deleted_at AS deleted_at_2, e0_.key AS key_3, e0_.name AS name_4, e0_.project_id AS project_id_5 FROM estimate_estimates e0_ WHERE (e0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.estimate_id AS estimate_id_0,
  e0_.created_at AS created_at_1,
  e0_.deleted_at AS deleted_at_2,
  e0_.key AS key_3,
  e0_.name AS name_4,
  e0_.project_id AS project_id_5
FROM
  estimate_estimates e0_
WHERE
  (e0_.deleted_at IS NULL)

SELECT e0_.estimate_id AS estimate_id_0, e0_.created_at AS created_at_1, e0_.deleted_at AS deleted_at_2, e0_.key AS key_3, e0_.name AS name_4, e0_.project_id AS project_id_5 FROM estimate_estimates e0_ WHERE (e0_.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)

0.65 ms

SELECT w0_.work_id AS work_id_0, w0_.created_at AS created_at_1, w0_.deleted_at AS deleted_at_2, w0_.key AS key_3, w0_.name AS name_4, w0_.type_id AS type_id_5, w0_.group_id AS group_id_6 FROM work_works w0_ WHERE (w0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.work_id AS work_id_0,
  w0_.created_at AS created_at_1,
  w0_.deleted_at AS deleted_at_2,
  w0_.key AS key_3,
  w0_.name AS name_4,
  w0_.type_id AS type_id_5,
  w0_.group_id AS group_id_6
FROM
  work_works w0_
WHERE
  (w0_.deleted_at IS NULL)

SELECT w0_.work_id AS work_id_0, w0_.created_at AS created_at_1, w0_.deleted_at AS deleted_at_2, w0_.key AS key_3, w0_.name AS name_4, w0_.type_id AS type_id_5, w0_.group_id AS group_id_6 FROM work_works w0_ WHERE (w0_.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
Work\Entity\Work	30
Work\Entity\Group	11

Entities Mapping

Class	Mapping errors
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.
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.
Project\Entity\Project	No errors.
Work\Entity\Type	No errors.
Work\Entity\GroupTree	No errors.
Work\Entity\Group	The field Work\Entity\Group#works is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Work\Entity\Work#group does not contain the required 'inversedBy: "works"' attribute.
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.
Work\Entity\Price	The field 'Work\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-work/new

Configuration Settings

Theme

Page Width