Symfony Profiler

Query Metrics

21 Database Queries

10 Different statements

20.01 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.60 ms
(33.01%)

SELECT pg.id AS pg_id, pg.name AS pg_name, p.name AS p_name, p.in_short AS p_short, pp.value AS value FROM goods.proposal_parameter pp INNER JOIN goods.parameter p ON p.id = pp.parameter_id INNER JOIN goods.parameters_group pg ON pg.id = p.parameters_group_id WHERE pp.proposal_id = ? ORDER BY pg.id ASC, p.id ASC

Parameters:

[
  "d74dd3d4-8819-4bbd-beda-44591753650c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  pg.id AS pg_id,
  pg.name AS pg_name,
  p.name AS p_name,
  p.in_short AS p_short,
  pp.value AS value
FROM
  goods.proposal_parameter pp
  INNER JOIN goods.parameter p ON p.id = pp.parameter_id
  INNER JOIN goods.parameters_group pg ON pg.id = p.parameters_group_id
WHERE
  pp.proposal_id = ?
ORDER BY
  pg.id ASC,
  p.id ASC

SELECT pg.id AS pg_id, pg.name AS pg_name, p.name AS p_name, p.in_short AS p_short, pp.value AS value FROM goods.proposal_parameter pp INNER JOIN goods.parameter p ON p.id = pp.parameter_id INNER JOIN goods.parameters_group pg ON pg.id = p.parameters_group_id WHERE pp.proposal_id = 'd74dd3d4-8819-4bbd-beda-44591753650c' ORDER BY pg.id ASC, p.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 91)
3	App\Repository\Goods\ProposalRepository->getProposalSpecs (line 1086)
4	App\Service\CatalogService->getItemData (line 1197)
5	App\Service\CatalogService->getCatalogCards (line 74)
6	App\Service\CatalogService->getCatalogData (line 27)
7	App\Controller\CatalogController->indexAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.57 ms
(12.85%)

SELECT id, name, parent_id FROM goods.category

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name,
  parent_id
FROM
  goods.category

SELECT id, name, parent_id FROM goods.category;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1260)
3	App\Service\CatalogService->generateCategoryTree (line 59)
4	App\Service\CatalogService->__construct (line 44)
5	ContainerX31rIfS\getCatalogServiceService::do (line 612)
6	ContainerX31rIfS\App_KernelDevDebugContainer->load (line 403)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 60)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
11	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
12	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

2.56 ms
(12.81%)

SELECT MIN(p.price) AS min_price, MAX(p.price) AS max_price FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN (?, ?, ?, ?))

Parameters:

[
  "d4982eaa-8475-417a-9609-1281e8d65780"
  "958f909b-c59c-42e5-b7b7-c4a399d2fe0c"
  "ea168356-1e34-45df-99c9-d82ebd6824bf"
  "790916a7-bd91-48dd-886b-adafad846b86"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(p.price) AS min_price,
  MAX(p.price) AS max_price
FROM
  goods.proposal p
WHERE
  (NOT p.is_archive)
  AND (NOT p.is_private)
  AND (
    p.category_id IN (?, ?, ?, ?)
  )

SELECT MIN(p.price) AS min_price, MAX(p.price) AS max_price FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN ('d4982eaa-8475-417a-9609-1281e8d65780', '958f909b-c59c-42e5-b7b7-c4a399d2fe0c', 'ea168356-1e34-45df-99c9-d82ebd6824bf', '790916a7-bd91-48dd-886b-adafad846b86'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 245)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAssociative (line 69)
4	App\Repository\Goods\ProposalRepository->getPriceRangeByCategory (line 1245)
5	App\Service\CatalogService->getCategoryPriceRange (line 70)
6	App\Service\CatalogService->getCatalogData (line 27)
7	App\Controller\CatalogController->indexAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.98 ms
(9.90%)

SELECT COUNT(id) AS total, MIN(price)::int AS start_price, MAX(price)::int AS end_price FROM trade.auction_offer WHERE proposal_id = ? GROUP BY proposal_id

Parameters:

[
  "d74dd3d4-8819-4bbd-beda-44591753650c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id) AS total,
  MIN(price):: int AS start_price,
  MAX(price):: int AS end_price
FROM
  trade.auction_offer
WHERE
  proposal_id = ?
GROUP BY
  proposal_id

SELECT COUNT(id) AS total, MIN(price)::int AS start_price, MAX(price)::int AS end_price FROM trade.auction_offer WHERE proposal_id = 'd74dd3d4-8819-4bbd-beda-44591753650c' GROUP BY proposal_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1129)
3	App\Service\CatalogService->getProposalOffers (line 1038)
4	App\Service\CatalogService->getItemData (line 1197)
5	App\Service\CatalogService->getCatalogCards (line 74)
6	App\Service\CatalogService->getCatalogData (line 27)
7	App\Controller\CatalogController->indexAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.93 ms
(9.63%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.is_archive AS is_archive_5, t0.date_add AS date_add_6, t0.end_date AS end_date_7, t0.is_private AS is_private_8, t0.items_count AS items_count_9, t0.delivery_method AS delivery_method_10, t0.payload AS payload_11, t0.category_id AS category_id_12, t0.item_id AS item_id_13, t0.owner_id AS owner_id_14 FROM goods.proposal t0 WHERE t0.id = ?

Parameters:

[
  "d74dd3d4-8819-4bbd-beda-44591753650c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.description AS description_4,
  t0.is_archive AS is_archive_5,
  t0.date_add AS date_add_6,
  t0.end_date AS end_date_7,
  t0.is_private AS is_private_8,
  t0.items_count AS items_count_9,
  t0.delivery_method AS delivery_method_10,
  t0.payload AS payload_11,
  t0.category_id AS category_id_12,
  t0.item_id AS item_id_13,
  t0.owner_id AS owner_id_14
FROM
  goods.proposal t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.is_archive AS is_archive_5, t0.date_add AS date_add_6, t0.end_date AS end_date_7, t0.is_private AS is_private_8, t0.items_count AS items_count_9, t0.delivery_method AS delivery_method_10, t0.payload AS payload_11, t0.category_id AS category_id_12, t0.item_id AS item_id_13, t0.owner_id AS owner_id_14 FROM goods.proposal t0 WHERE t0.id = 'd74dd3d4-8819-4bbd-beda-44591753650c';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 1024)
6	App\Service\CatalogService->getItemData (line 1197)
7	App\Service\CatalogService->getCatalogCards (line 74)
8	App\Service\CatalogService->getCatalogData (line 27)
9	App\Controller\CatalogController->indexAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.22 ms
(6.11%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = ?

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#965
    __toString(): "a94c1907-f056-4542-a3de-aacdd561b656"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.surname AS surname_2,
  p0_.patronymic AS patronymic_3,
  p0_.gender AS gender_4,
  p0_.birthdate AS birthdate_5,
  p0_.email AS email_6,
  p0_.phone AS phone_7,
  p0_.avatar AS avatar_8,
  p0_.user_id AS user_id_9
FROM
  account.person p0_
WHERE
  p0_.user_id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = 'a94c1907-f056-4542-a3de-aacdd561b656';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 19)
7	App\Repository\Account\PersonRepository->findOneByUser (line 86)
8	App\Service\PersonService->App\Service\{closure} (line 48)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
10	Symfony\Component\Cache\LockRegistry::compute (line 104)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 99)
16	App\Service\PersonService->getPersonCard (line 1173)
17	App\Service\CatalogService->getProposalPerson (line 1047)
18	App\Service\CatalogService->getItemData (line 1197)
19	App\Service\CatalogService->getCatalogCards (line 74)
20	App\Service\CatalogService->getCatalogData (line 27)
21	App\Controller\CatalogController->indexAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.19 ms
(5.97%)

SELECT p.id FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN (?, ?, ?, ?)) AND (p.price >= ?) AND (p.price <= ?) ORDER BY p.date_add DESC LIMIT 20

Parameters:

[
  "d4982eaa-8475-417a-9609-1281e8d65780"
  "958f909b-c59c-42e5-b7b7-c4a399d2fe0c"
  "ea168356-1e34-45df-99c9-d82ebd6824bf"
  "790916a7-bd91-48dd-886b-adafad846b86"
  0
  1000000
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.id
FROM
  goods.proposal p
WHERE
  (NOT p.is_archive)
  AND (NOT p.is_private)
  AND (
    p.category_id IN (?, ?, ?, ?)
  )
  AND (p.price >= ?)
  AND (p.price <= ?)
ORDER BY
  p.date_add DESC
LIMIT
  20

SELECT p.id FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN ('d4982eaa-8475-417a-9609-1281e8d65780', '958f909b-c59c-42e5-b7b7-c4a399d2fe0c', 'ea168356-1e34-45df-99c9-d82ebd6824bf', '790916a7-bd91-48dd-886b-adafad846b86')) AND (p.price >= 0) AND (p.price <= 1000000) ORDER BY p.date_add DESC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 334)
3	Doctrine\DBAL\Query\QueryBuilder->fetchFirstColumn (line 37)
4	App\Repository\Goods\ProposalRepository->getProposalIdsByCategory (line 1239)
5	App\Service\CatalogService->getCategoryProposals (line 1191)
6	App\Service\CatalogService->getCatalogCards (line 74)
7	App\Service\CatalogService->getCatalogData (line 27)
8	App\Controller\CatalogController->indexAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.92 ms
(4.62%)

SELECT cnt FROM counters.proposal_view WHERE id = ?

Parameters:

[
  "d74dd3d4-8819-4bbd-beda-44591753650c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  cnt
FROM
  counters.proposal_view
WHERE
  id = ?

SELECT cnt FROM counters.proposal_view WHERE id = 'd74dd3d4-8819-4bbd-beda-44591753650c';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 38)
2	App\Service\CounterService->get (line 1046)
3	App\Service\CatalogService->getItemData (line 1197)
4	App\Service\CatalogService->getCatalogCards (line 74)
5	App\Service\CatalogService->getCatalogData (line 27)
6	App\Controller\CatalogController->indexAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.62 ms
(3.07%)

SELECT avatar FROM account.person WHERE user_id = ?

Parameters:

[
  "a94c1907-f056-4542-a3de-aacdd561b656"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  avatar
FROM
  account.person
WHERE
  user_id = ?

SELECT avatar FROM account.person WHERE user_id = 'a94c1907-f056-4542-a3de-aacdd561b656';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 68)
3	App\Service\PersonService->getAvatar (line 92)
4	App\Service\PersonService->App\Service\{closure} (line 48)
5	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
6	Symfony\Component\Cache\LockRegistry::compute (line 104)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 99)
12	App\Service\PersonService->getPersonCard (line 1173)
13	App\Service\CatalogService->getProposalPerson (line 1047)
14	App\Service\CatalogService->getItemData (line 1197)
15	App\Service\CatalogService->getCatalogCards (line 74)
16	App\Service\CatalogService->getCatalogData (line 27)
17	App\Controller\CatalogController->indexAction (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.41 ms
(2.03%)

SELECT COUNT(id) AS new FROM trade.auction_offer WHERE (proposal_id = ?) AND (state = 0) GROUP BY proposal_id

Parameters:

[
  "d74dd3d4-8819-4bbd-beda-44591753650c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id) AS new
FROM
  trade.auction_offer
WHERE
  (proposal_id = ?)
  AND (state = 0)
GROUP BY
  proposal_id

SELECT COUNT(id) AS new FROM trade.auction_offer WHERE (proposal_id = 'd74dd3d4-8819-4bbd-beda-44591753650c') AND (state = 0) GROUP BY proposal_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1144)
3	App\Service\CatalogService->getProposalOffers (line 1038)
4	App\Service\CatalogService->getItemData (line 1197)
5	App\Service\CatalogService->getCatalogCards (line 74)
6	App\Service\CatalogService->getCatalogData (line 27)
7	App\Controller\CatalogController->indexAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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.

Entities Mapping

Class	Mapping errors
App\Entity\Goods\Proposal	The field App\Entity\Goods\Proposal#parameters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Goods\ProposalParameter#proposal does not contain the required 'inversedBy="parameters"' attribute.
App\Entity\Goods\Category	The field App\Entity\Goods\Category#manufacturers is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Dictionary\Manufacturer#categories does not contain the required 'mappedBy="manufacturers"' attribute.
App\Entity\Goods\Item	No errors.
App\Entity\Account\User	No errors.
App\Entity\Goods\ProposalParameter	No errors.
App\Entity\Account\Person	No errors.

Symfony Profiler

GET http://sch.ener.ru/catalog/d4982eaa-8475-417a-9609-1281e8d65780

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping