Symfony Profiler

Query Metrics

24 Database Queries

7 Different statements

18.63 ms Query time

3 Invalid entities

34 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.04 ms
(48.54%)

SELECT t0.prop_id AS prop_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.name AS name_4, t0.key AS key_5, t0.prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0.prop_id = statement_parameters_items_props.prop_id WHERE statement_parameters_items_props.parameter_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.prop_id AS prop_id_1,
  t0.created_at AS created_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.name AS name_4,
  t0.key AS key_5,
  t0.prop_type_id AS prop_type_id_6
FROM
  statement_props t0
  INNER JOIN statement_parameters_items_props ON t0.prop_id = statement_parameters_items_props.prop_id
WHERE
  statement_parameters_items_props.parameter_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.prop_id AS prop_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.name AS name_4, t0.key AS key_5, t0.prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0.prop_id = statement_parameters_items_props.prop_id WHERE statement_parameters_items_props.parameter_id = 21 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 329)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 279)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 159)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 115)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 149)
13	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

4.04 ms
(21.69%)

SELECT DISTINCT s0_.parameter_id AS parameter_id_0 FROM statement_parameters s0_ WHERE (s0_.deleted_at IS NULL) LIMIT 20 OFFSET 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.parameter_id AS parameter_id_0
FROM
  statement_parameters s0_
WHERE
  (s0_.deleted_at IS NULL)
LIMIT
  20
OFFSET
  20

SELECT DISTINCT s0_.parameter_id AS parameter_id_0 FROM statement_parameters s0_ WHERE (s0_.deleted_at IS NULL) LIMIT 20 OFFSET 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)

1.79 ms
(9.62%)

SELECT t0.formula_id AS formula_id_1, t0.class AS class_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5 FROM statement_formulas t0 WHERE t0.formula_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.formula_id AS formula_id_1,
  t0.class AS class_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5
FROM
  statement_formulas t0
WHERE
  t0.formula_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.formula_id AS formula_id_1, t0.class AS class_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5 FROM statement_formulas t0 WHERE t0.formula_id = 5 AND ((t0.deleted_at IS NULL));

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Statement\Entity\Formula::getName (line 16)
5	Statement\Entity\Formula->__toString (line 53)
6	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->formatAsString (line 289)
7	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 261)
8	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 155)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 115)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 149)
11	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.50 ms
(8.03%)

SELECT t0.parameter_id AS parameter_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.name AS name_4, t0.key AS key_5, t0.parameter_type_id AS parameter_type_id_6, t0.unit_id AS unit_id_7, t0.formula_id AS formula_id_8, t0.calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0.parameter_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.parameter_id AS parameter_id_1,
  t0.created_at AS created_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.name AS name_4,
  t0.key AS key_5,
  t0.parameter_type_id AS parameter_type_id_6,
  t0.unit_id AS unit_id_7,
  t0.formula_id AS formula_id_8,
  t0.calculate_parameter_id AS calculate_parameter_id_9
FROM
  statement_parameters t0
WHERE
  t0.parameter_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.parameter_id AS parameter_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.name AS name_4, t0.key AS key_5, t0.parameter_type_id AS parameter_type_id_6, t0.unit_id AS unit_id_7, t0.formula_id AS formula_id_8, t0.calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0.parameter_id = 1 AND ((t0.deleted_at IS NULL));

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Statement\Entity\Parameter::getName (line 16)
5	Statement\Entity\Parameter->__toString (line 73)
6	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->formatAsString (line 289)
7	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 261)
8	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 155)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 115)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 149)
11	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.27 ms
(6.79%)

SELECT t0.parameter_type_id AS parameter_type_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.name AS name_4, t0.key AS key_5 FROM statement_parameters_types t0 WHERE t0.parameter_type_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.parameter_type_id AS parameter_type_id_1,
  t0.created_at AS created_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.name AS name_4,
  t0.key AS key_5
FROM
  statement_parameters_types t0
WHERE
  t0.parameter_type_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.parameter_type_id AS parameter_type_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.name AS name_4, t0.key AS key_5 FROM statement_parameters_types t0 WHERE t0.parameter_type_id = 2 AND ((t0.deleted_at IS NULL));

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Statement\Entity\ParameterType::getName (line 16)
5	Statement\Entity\ParameterType->__toString (line 38)
6	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->formatAsString (line 289)
7	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 261)
8	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 155)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 115)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 149)
11	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.59 ms
(3.16%)

SELECT s0_.parameter_id AS parameter_id_0, s0_.created_at AS created_at_1, s0_.deleted_at AS deleted_at_2, s0_.name AS name_3, s0_.key AS key_4, s0_.parameter_type_id AS parameter_type_id_5, s0_.unit_id AS unit_id_6, s0_.formula_id AS formula_id_7, s0_.calculate_parameter_id AS calculate_parameter_id_8 FROM statement_parameters s0_ WHERE (s0_.parameter_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (s0_.deleted_at IS NULL)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.parameter_id AS parameter_id_0,
  s0_.created_at AS created_at_1,
  s0_.deleted_at AS deleted_at_2,
  s0_.name AS name_3,
  s0_.key AS key_4,
  s0_.parameter_type_id AS parameter_type_id_5,
  s0_.unit_id AS unit_id_6,
  s0_.formula_id AS formula_id_7,
  s0_.calculate_parameter_id AS calculate_parameter_id_8
FROM
  statement_parameters s0_
WHERE
  (
    s0_.parameter_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.parameter_id AS parameter_id_0, s0_.created_at AS created_at_1, s0_.deleted_at AS deleted_at_2, s0_.name AS name_3, s0_.key AS key_4, s0_.parameter_type_id AS parameter_type_id_5, s0_.unit_id AS unit_id_6, s0_.formula_id AS formula_id_7, s0_.calculate_parameter_id AS calculate_parameter_id_8 FROM statement_parameters s0_ WHERE (s0_.parameter_id IN (21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32)) AND (s0_.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)

0.40 ms
(2.17%)

SELECT count(*) AS sclr_0 FROM statement_parameters s0_ WHERE (s0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  statement_parameters s0_
WHERE
  (s0_.deleted_at IS NULL)

SELECT count(*) AS sclr_0 FROM statement_parameters s0_ WHERE (s0_.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)

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
Statement\Entity\Parameter	15
Statement\Entity\Prop	8
Statement\Entity\Formula	6
Statement\Entity\ParameterType	2
Shared\Entity\Unit	2
Statement\Entity\PropType	1

Entities Mapping

Class	Mapping errors
Statement\Entity\Parameter	The association Statement\Entity\Parameter#type refers to the inverse side field Statement\Entity\ParameterType#parameters which does not exist. The association Statement\Entity\Parameter#items refers to the owning side field Statement\Entity\ItemParameter#parametr which does not exist. The association Statement\Entity\Parameter#workParameters refers to the owning side field Work\Entity\ItemParameter#parametr which does not exist.
Statement\Entity\ParameterType	No errors.
Shared\Entity\Unit	No errors.
Statement\Entity\Formula	The field Statement\Entity\Formula#parameters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Statement\Entity\FormulaParameter#formula does not contain the required 'inversedBy: "parameters"' attribute.
Statement\Entity\ItemParameter	The mappings Statement\Entity\ItemParameter#parameter and Statement\Entity\Parameter#items are inconsistent with each other. The association Statement\Entity\ItemParameter#values refers to the owning side field Statement\Entity\ItemParameterValue#itemParametr which does not exist.
Work\Entity\ItemParameter	No errors.
Statement\Entity\Prop	No errors.
Statement\Entity\FormulaParameter	No errors.
Statement\Entity\PropType	No errors.

Symfony Profiler

GET https://admin-symfony-review.kube-dev.ugol.click/parameter?page=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping