Symfony Profiler

Query Metrics

12 Database Queries

11 Different statements

11.93 ms Query time

3 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.33 ms
(19.50%)

SELECT p0_.project_id AS project_id_0, p0_.name AS name_1 FROM project_projects p0_ WHERE (p0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.project_id AS project_id_0,
  p0_.name AS name_1
FROM
  project_projects p0_
WHERE
  (p0_.deleted_at IS NULL)

SELECT p0_.project_id AS project_id_0, p0_.name AS name_1 FROM project_projects p0_ WHERE (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	Project\Repository\ProjectRepository->adminFilterList (line 20)
7	Eadmin\Filter\Type\ProjectFilterType->__construct (line 28)
8	ContainerXE1rj4A\getProjectFilterTypeService->do (line 32)
9	ContainerXE1rj4A\Shared_KernelDevDebugContainer::load (line 757)
10	Symfony\Component\DependencyInjection\Container->getService (line 399)
11	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
12	Symfony\Component\Form\Extension\DependencyInjection\DependencyInjectionExtension->getType (line 43)
13	Symfony\Component\Form\FormRegistry->getType (line 64)
14	Symfony\Component\Form\FormFactory->createNamedBuilder (line 50)
15	Symfony\Component\Form\FormBuilder->create (line 80)
16	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
17	Symfony\Component\Form\FormBuilder->getForm (line 160)
18	Symfony\Component\Form\FormFactory->createNamed (line 31)
19	EasyCorp\Bundle\EasyAdminBundle\Factory\FormFactory->createFiltersForm (line 65)
20	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository->addFilterClause (line 205)
21	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository->createQueryBuilder (line 66)
22	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->createIndexQueryBuilder (line 524)
23	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 137)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.76 ms
(14.72%)

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:

[
  3
]

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 = 3 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	Project\Entity\ProjectItemParameter->__toString (line 54)
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.57 ms
(13.16%)

SELECT DISTINCT p0_.project_item_parameter_value_id AS project_item_parameter_value_id_0 FROM project_items_parameters_values p0_ WHERE (p0_.project_item_parameter_id = (?)) AND (p0_.deleted_at IS NULL) LIMIT 20

Parameters:

[
  44
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.project_item_parameter_value_id AS project_item_parameter_value_id_0
FROM
  project_items_parameters_values p0_
WHERE
  (
    p0_.project_item_parameter_id = (?)
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  20

SELECT DISTINCT p0_.project_item_parameter_value_id AS project_item_parameter_value_id_0 FROM project_items_parameters_values p0_ WHERE (p0_.project_item_parameter_id = (44)) 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)

1.52 ms
(12.71%)

SELECT t0.value_id AS value_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_values t0 WHERE t0.value_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.value_id AS value_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_values t0
WHERE
  t0.value_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.value_id AS value_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_values t0 WHERE t0.value_id = 3 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\Value::getName (line 16)
5	Statement\Entity\Value->__toString (line 30)
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.12 ms
(9.40%)

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:

[
  5
]

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 = 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\Item::getName (line 16)
5	Project\Entity\ProjectItem->__toString (line 84)
6	Eadmin\Field\Configurator\ProjectItemConfigurator->configure (line 25)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 115)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 149)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
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.88 ms
(7.37%)

SELECT p0_.project_item_parameter_id AS project_item_parameter_id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2, p0_.project_item_id AS project_item_id_3, p0_.parameter_id AS parameter_id_4 FROM project_projects_items_parameters p0_ WHERE (p0_.project_item_parameter_id IN (?)) AND (p0_.deleted_at IS NULL)

Parameters:

[
  "44"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.project_item_parameter_id AS project_item_parameter_id_0,
  p0_.created_at AS created_at_1,
  p0_.deleted_at AS deleted_at_2,
  p0_.project_item_id AS project_item_id_3,
  p0_.parameter_id AS parameter_id_4
FROM
  project_projects_items_parameters p0_
WHERE
  (
    p0_.project_item_parameter_id IN (?)
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.project_item_parameter_id AS project_item_parameter_id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2, p0_.project_item_id AS project_item_id_3, p0_.parameter_id AS parameter_id_4 FROM project_projects_items_parameters p0_ WHERE (p0_.project_item_parameter_id IN ('44')) 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.67 ms
(5.58%)

SELECT p0_.project_item_id AS project_item_id_0, p0_.name AS name_1 FROM project_projects_items p0_ WHERE (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
FROM
  project_projects_items p0_
WHERE
  (p0_.deleted_at IS NULL)

SELECT p0_.project_item_id AS project_item_id_0, p0_.name AS name_1 FROM project_projects_items p0_ WHERE (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	Project\Repository\ProjectItemRepository->adminFilterList (line 82)
7	Eadmin\Filter\Type\ProjectItemFilterType->__construct (line 28)
8	ContainerXE1rj4A\getProjectItemFilterTypeService->do (line 32)
9	ContainerXE1rj4A\Shared_KernelDevDebugContainer::load (line 757)
10	Symfony\Component\DependencyInjection\Container->getService (line 399)
11	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
12	Symfony\Component\Form\Extension\DependencyInjection\DependencyInjectionExtension->getType (line 43)
13	Symfony\Component\Form\FormRegistry->getType (line 64)
14	Symfony\Component\Form\FormFactory->createNamedBuilder (line 50)
15	Symfony\Component\Form\FormBuilder->create (line 80)
16	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
17	Symfony\Component\Form\FormBuilder->getForm (line 160)
18	Symfony\Component\Form\FormFactory->createNamed (line 31)
19	EasyCorp\Bundle\EasyAdminBundle\Factory\FormFactory->createFiltersForm (line 65)
20	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository->addFilterClause (line 205)
21	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository->createQueryBuilder (line 66)
22	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->createIndexQueryBuilder (line 524)
23	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 137)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.65 ms
(5.44%)

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

Parameters:

[
  44
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT count(*) AS sclr_0 FROM project_items_parameters_values p0_ WHERE (p0_.project_item_parameter_id = (44)) 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)

0.59 ms
(4.97%)

SELECT p0_.project_item_parameter_value_id AS project_item_parameter_value_id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2, p0_.string AS string_3, p0_.integer AS integer_4, p0_.float AS float_5, p0_.boolean AS boolean_6, p0_.project_item_parameter_id AS project_item_parameter_id_7, p0_.value_id AS value_id_8, p0_.enum_value_id AS enum_value_id_9 FROM project_items_parameters_values p0_ WHERE (p0_.project_item_parameter_id = (?) AND p0_.project_item_parameter_value_id IN (?, ?)) AND (p0_.deleted_at IS NULL)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.project_item_parameter_value_id AS project_item_parameter_value_id_0,
  p0_.created_at AS created_at_1,
  p0_.deleted_at AS deleted_at_2,
  p0_.string AS string_3,
  p0_.integer AS integer_4,
  p0_.float AS float_5,
  p0_.boolean AS boolean_6,
  p0_.project_item_parameter_id AS project_item_parameter_id_7,
  p0_.value_id AS value_id_8,
  p0_.enum_value_id AS enum_value_id_9
FROM
  project_items_parameters_values p0_
WHERE
  (
    p0_.project_item_parameter_id = (?)
    AND p0_.project_item_parameter_value_id IN (?, ?)
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.project_item_parameter_value_id AS project_item_parameter_value_id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2, p0_.string AS string_3, p0_.integer AS integer_4, p0_.float AS float_5, p0_.boolean AS boolean_6, p0_.project_item_parameter_id AS project_item_parameter_id_7, p0_.value_id AS value_id_8, p0_.enum_value_id AS enum_value_id_9 FROM project_items_parameters_values p0_ WHERE (p0_.project_item_parameter_id = (44) AND p0_.project_item_parameter_value_id IN (16, 47)) 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.45 ms
(3.81%)

SELECT t0.project_item_id AS project_item_id_1, t0.name AS name_2, t0.level AS level_3, t0.created_at AS created_at_4, t0.deleted_at AS deleted_at_5, t0.key AS key_6, t0.project_id AS project_id_7, t0.item_id AS item_id_8, t0.parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0.project_item_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.project_item_id AS project_item_id_1,
  t0.name AS name_2,
  t0.level AS level_3,
  t0.created_at AS created_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.key AS key_6,
  t0.project_id AS project_id_7,
  t0.item_id AS item_id_8,
  t0.parent_id AS parent_id_9
FROM
  project_projects_items t0
WHERE
  t0.project_item_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.project_item_id AS project_item_id_1, t0.name AS name_2, t0.level AS level_3, t0.created_at AS created_at_4, t0.deleted_at AS deleted_at_5, t0.key AS key_6, t0.project_id AS project_id_7, t0.item_id AS item_id_8, t0.parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0.project_item_id = 9 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	Project\Entity\ProjectItem::getProject (line 121)
5	Project\Entity\ProjectItemParameterValue->getProject (line 41)
6	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
7	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
8	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\CommonPreConfigurator->configure (line 60)
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.40 ms
(3.33%)

SELECT t0.project_id AS project_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.updated_at AS updated_at_6 FROM project_projects t0 WHERE t0.project_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.project_id AS project_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.updated_at AS updated_at_6
FROM
  project_projects t0
WHERE
  t0.project_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.project_id AS project_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.updated_at AS updated_at_6 FROM project_projects t0 WHERE t0.project_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	Project\Entity\Project::getName (line 16)
5	Eadmin\Field\Configurator\ProjectConfigurator->configure (line 29)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 115)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 149)
8	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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\ProjectItem	2
Project\Entity\ProjectItemParameterValue	2
Statement\Entity\Value	2
Project\Entity\ProjectItemParameter	1
Statement\Entity\Parameter	1
Project\Entity\Project	1
Statement\Entity\Item	1
Statement\Entity\ParameterType	1
Shared\Entity\Unit	1
Statement\Entity\Formula	1

Entities Mapping

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

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping