Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.97 ms Query time

4 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.94 ms
(38.97%)

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_.work_id IN (?)) AND (w0_.deleted_at IS NULL)

Parameters:

[
  "17"
]

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_.work_id IN (?)
  )
  AND (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_.work_id IN ('17')) AND (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	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1002)
12	Symfony\Component\Form\Form->submit (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Form->submit (line 493)
15	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
16	Symfony\Component\Form\Form->handleRequest (line 414)
17	EasyCorp\Bundle\EasyAdminBundle\Factory\FormFactory->createFiltersForm (line 71)
18	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository->addFilterClause (line 205)
19	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository->createQueryBuilder (line 66)
20	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->createIndexQueryBuilder (line 524)
21	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 137)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

1.91 ms
(38.38%)

SELECT DISTINCT w0_.price_id AS price_id_0 FROM work_prices w0_ WHERE (w0_.work_id = (?)) AND (w0_.deleted_at IS NULL) LIMIT 20

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT w0_.price_id AS price_id_0
FROM
  work_prices w0_
WHERE
  (
    w0_.work_id = (?)
  )
  AND (w0_.deleted_at IS NULL)
LIMIT
  20

SELECT DISTINCT w0_.price_id AS price_id_0 FROM work_prices w0_ WHERE (w0_.work_id = (17)) AND (w0_.deleted_at IS NULL) LIMIT 20;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.64 ms
(12.94%)

SELECT count(*) AS sclr_0 FROM work_prices w0_ WHERE (w0_.work_id = (?)) AND (w0_.deleted_at IS NULL)

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  work_prices w0_
WHERE
  (
    w0_.work_id = (?)
  )
  AND (w0_.deleted_at IS NULL)

SELECT count(*) AS sclr_0 FROM work_prices w0_ WHERE (w0_.work_id = (17)) AND (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	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 72)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.48 ms
(9.70%)

SELECT w0_.price_id AS price_id_0, w0_.created_at AS created_at_1, w0_.deleted_at AS deleted_at_2, w0_.key AS key_3, w0_.price AS price_4, w0_.current AS current_5, w0_.work_id AS work_id_6 FROM work_prices w0_ WHERE (w0_.work_id = (?) AND w0_.price_id IN (?)) AND (w0_.deleted_at IS NULL)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.price_id AS price_id_0,
  w0_.created_at AS created_at_1,
  w0_.deleted_at AS deleted_at_2,
  w0_.key AS key_3,
  w0_.price AS price_4,
  w0_.current AS current_5,
  w0_.work_id AS work_id_6
FROM
  work_prices w0_
WHERE
  (
    w0_.work_id = (?)
    AND w0_.price_id IN (?)
  )
  AND (w0_.deleted_at IS NULL)

SELECT w0_.price_id AS price_id_0, w0_.created_at AS created_at_1, w0_.deleted_at AS deleted_at_2, w0_.key AS key_3, w0_.price AS price_4, w0_.current AS current_5, w0_.work_id AS work_id_6 FROM work_prices w0_ WHERE (w0_.work_id = (17) AND w0_.price_id IN (17)) AND (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	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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	1
Work\Entity\Group	1
Work\Entity\Price	1

Entities Mapping

Class	Mapping errors
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.
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.
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.

Symfony Profiler

GET http://admin-symfony-review.kube-dev.ugol.click/work-price?filters%5Bwork%5D%5Bcomparison%5D=%3D&filters%5Bwork%5D%5Bvalue%5D=17

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping