Symfony Profiler

Query Metrics

30 Database Queries

6 Different statements

19.24 ms Query time

2 Invalid entities

109 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.79 ms
(35.31%)

SELECT t0.project_item_parameter_id AS project_item_parameter_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.project_item_id AS project_item_id_4, t0.parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0.project_item_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.project_item_parameter_id AS project_item_parameter_id_1,
  t0.created_at AS created_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.project_item_id AS project_item_id_4,
  t0.parameter_id AS parameter_id_5
FROM
  project_projects_items_parameters t0
WHERE
  t0.project_item_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.project_item_parameter_id AS project_item_parameter_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.project_item_id AS project_item_id_4, t0.parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0.project_item_id = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
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)

6.30 ms
(32.72%)

SELECT t0.item_id AS item_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_items t0 WHERE t0.item_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.item_id AS item_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_items t0
WHERE
  t0.item_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.item_id AS item_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_items t0 WHERE t0.item_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\Item::getName (line 16)
5	Statement\Entity\Item->__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)

2.48 ms
(12.89%)

SELECT DISTINCT p0_.project_item_id AS project_item_id_0 FROM project_projects_items p0_ WHERE (p0_.project_id = (?)) AND (p0_.deleted_at IS NULL) LIMIT 20

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.project_item_id AS project_item_id_0
FROM
  project_projects_items p0_
WHERE
  (
    p0_.project_id = (?)
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  20

SELECT DISTINCT p0_.project_item_id AS project_item_id_0 FROM project_projects_items p0_ WHERE (p0_.project_id = (1)) AND (p0_.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)

2.26 ms
(11.72%)

SELECT p0_.project_id AS project_id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2, p0_.name AS name_3, p0_.key AS key_4, p0_.updated_at AS updated_at_5 FROM project_projects p0_ WHERE (p0_.project_id IN (?)) AND (p0_.deleted_at IS NULL)

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.project_id AS project_id_0,
  p0_.created_at AS created_at_1,
  p0_.deleted_at AS deleted_at_2,
  p0_.name AS name_3,
  p0_.key AS key_4,
  p0_.updated_at AS updated_at_5
FROM
  project_projects p0_
WHERE
  (
    p0_.project_id IN (?)
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.project_id AS project_id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2, p0_.name AS name_3, p0_.key AS key_4, p0_.updated_at AS updated_at_5 FROM project_projects p0_ WHERE (p0_.project_id IN ('1')) AND (p0_.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)

0.72 ms
(3.73%)

SELECT p0_.project_item_id AS project_item_id_0, p0_.name AS name_1, p0_.level AS level_2, p0_.created_at AS created_at_3, p0_.deleted_at AS deleted_at_4, p0_.key AS key_5, p0_.project_id AS project_id_6, p0_.item_id AS item_id_7, p0_.parent_id AS parent_id_8 FROM project_projects_items p0_ WHERE (p0_.project_id = (?) AND p0_.project_item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.deleted_at IS NULL)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.project_item_id AS project_item_id_0,
  p0_.name AS name_1,
  p0_.level AS level_2,
  p0_.created_at AS created_at_3,
  p0_.deleted_at AS deleted_at_4,
  p0_.key AS key_5,
  p0_.project_id AS project_id_6,
  p0_.item_id AS item_id_7,
  p0_.parent_id AS parent_id_8
FROM
  project_projects_items p0_
WHERE
  (
    p0_.project_id = (?)
    AND p0_.project_item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.project_item_id AS project_item_id_0, p0_.name AS name_1, p0_.level AS level_2, p0_.created_at AS created_at_3, p0_.deleted_at AS deleted_at_4, p0_.key AS key_5, p0_.project_id AS project_id_6, p0_.item_id AS item_id_7, p0_.parent_id AS parent_id_8 FROM project_projects_items p0_ WHERE (p0_.project_id = (1) AND p0_.project_item_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15)) AND (p0_.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.70 ms
(3.63%)

SELECT count(*) AS sclr_0 FROM project_projects_items p0_ WHERE (p0_.project_id = (?)) AND (p0_.deleted_at IS NULL)

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  project_projects_items p0_
WHERE
  (
    p0_.project_id = (?)
  )
  AND (p0_.deleted_at IS NULL)

SELECT count(*) AS sclr_0 FROM project_projects_items p0_ WHERE (p0_.project_id = (1)) AND (p0_.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
Project\Entity\ProjectItemParameter	57
Statement\Entity\Parameter	25
Project\Entity\ProjectItem	14
Statement\Entity\Item	12
Project\Entity\Project	1

Entities Mapping

Class	Mapping errors
Project\Entity\ProjectItemTree	No errors.
Project\Entity\ProjectItem	No errors.
Project\Entity\Project	No errors.
Statement\Entity\Item	No errors.
Project\Entity\ProjectItemParameter	No errors.
Statement\Entity\Prop	No errors.
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.
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.
Project\Entity\ProjectItemParameterValue	No errors.

Symfony Profiler

GET https://admin-symfony-review.kube-dev.ugol.click/project-item?filters%5Bproject%5D%5Bcomparison%5D=%3D&filters%5Bproject%5D%5Bvalue%5D=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping