Symfony Profiler

Query Metrics

71 Database Queries

11 Different statements

75.35 ms Query time

2 Invalid entities

207 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

31.68 ms
(42.04%)

SELECT c0_.uuid AS uuid_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.full_name AS full_name_3, c0_.path AS path_4, c0_.parent_uuid AS parent_uuid_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7 FROM catalogs c0_ WHERE c0_.parent_uuid = ? ORDER BY c0_.name ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#2092
    __toString(): "019a25f6-ac86-711e-b92b-8a6654477e0e"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  c0_.uuid AS uuid_0,
  c0_.name AS name_1,
  c0_.name_en AS name_en_2,
  c0_.full_name AS full_name_3,
  c0_.path AS path_4,
  c0_.parent_uuid AS parent_uuid_5,
  c0_.created_by AS created_by_6,
  c0_.updated_by AS updated_by_7
FROM
  catalogs c0_
WHERE
  c0_.parent_uuid = ?
ORDER BY
  c0_.name ASC

SELECT c0_.uuid AS uuid_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.full_name AS full_name_3, c0_.path AS path_4, c0_.parent_uuid AS parent_uuid_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7 FROM catalogs c0_ WHERE c0_.parent_uuid = '019a25f6-ac86-711e-b92b-8a6654477e0e' ORDER BY c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\CatalogRepository->findChildren (line 43)
7	App\Controller\GroupController->items (line 111)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

11.34 ms
(15.06%)

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t1_.value ASC, i0_.name ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#2118
    __toString(): "019a6d93-a0f6-763c-99e2-4e4514ce8b57"
  }
  Symfony\Component\Uid\UuidV7 {#1992
    __toString(): "019a6d94-8555-7a56-88b5-49899a7563ab"
  }
  Symfony\Component\Uid\UuidV7 {#2097
    __toString(): "019a6d96-504c-7c70-8797-93b9482e462a"
  }
  Symfony\Component\Uid\UuidV7 {#2145
    __toString(): "019a6d94-9283-722f-9ca9-13df4df2e439"
  }
  Symfony\Component\Uid\UuidV7 {#2166
    __toString(): "019a6d96-e7c8-782e-a3c5-b5696f480b6c"
  }
  Symfony\Component\Uid\UuidV7 {#2152
    __toString(): "019a6d94-7340-7e6f-b06d-490f6bde9ccc"
  }
  Symfony\Component\Uid\UuidV7 {#2125
    __toString(): "019a6d95-dff6-72d0-bb81-51d383916282"
  }
  Symfony\Component\Uid\UuidV7 {#2159
    __toString(): "019a6d94-5f77-7afc-a67e-8f8f3ac5b2b5"
  }
  Symfony\Component\Uid\UuidV7 {#2177
    __toString(): "019a6d94-d87d-78cf-ae47-d153067511c0"
  }
  Symfony\Component\Uid\UuidV7 {#2222
    __toString(): "019a6d94-e4ba-7029-8feb-22bdca143d99"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  i0_.uuid AS uuid_0,
  i0_.name AS name_1,
  i0_.name_en AS name_en_2,
  i0_.look_type_season AS look_type_season_3,
  t1_.uuid AS uuid_4,
  t1_.value AS value_5,
  c2_.uuid AS uuid_6,
  c2_.name AS name_7,
  c2_.name_en AS name_en_8,
  c2_.full_name AS full_name_9,
  c2_.path AS path_10,
  i0_.catalog_uuid AS catalog_uuid_11,
  i0_.layer_uuid AS layer_uuid_12,
  i0_.created_by AS created_by_13,
  i0_.updated_by AS updated_by_14,
  t1_.created_by AS created_by_15,
  t1_.updated_by AS updated_by_16,
  c2_.parent_uuid AS parent_uuid_17,
  c2_.created_by AS created_by_18,
  c2_.updated_by AS updated_by_19
FROM
  items i0_
  LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid
  INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid
WHERE
  i0_.catalog_uuid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t1_.value ASC,
  i0_.name ASC

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN ('019a6d93-a0f6-763c-99e2-4e4514ce8b57', '019a6d94-8555-7a56-88b5-49899a7563ab', '019a6d96-504c-7c70-8797-93b9482e462a', '019a6d94-9283-722f-9ca9-13df4df2e439', '019a6d96-e7c8-782e-a3c5-b5696f480b6c', '019a6d94-7340-7e6f-b06d-490f6bde9ccc', '019a6d95-dff6-72d0-bb81-51d383916282', '019a6d94-5f77-7afc-a67e-8f8f3ac5b2b5', '019a6d94-d87d-78cf-ae47-d153067511c0', '019a6d94-e4ba-7029-8feb-22bdca143d99') ORDER BY t1_.value ASC, i0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\ItemRepository->findByCatalogs (line 71)
7	App\Controller\GroupController->items (line 116)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

6.59 ms
(8.74%)

SELECT c0_.uuid AS uuid_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.full_name AS full_name_3, c0_.path AS path_4, c0_.parent_uuid AS parent_uuid_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7 FROM catalogs c0_ WHERE c0_.parent_uuid IS NULL ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.uuid AS uuid_0,
  c0_.name AS name_1,
  c0_.name_en AS name_en_2,
  c0_.full_name AS full_name_3,
  c0_.path AS path_4,
  c0_.parent_uuid AS parent_uuid_5,
  c0_.created_by AS created_by_6,
  c0_.updated_by AS updated_by_7
FROM
  catalogs c0_
WHERE
  c0_.parent_uuid IS NULL
ORDER BY
  c0_.name ASC

SELECT c0_.uuid AS uuid_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.full_name AS full_name_3, c0_.path AS path_4, c0_.parent_uuid AS parent_uuid_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7 FROM catalogs c0_ WHERE c0_.parent_uuid IS NULL ORDER BY c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\CatalogRepository->findChildren (line 43)
7	App\Controller\GroupController->items (line 107)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

6.24 ms
(8.28%)

SELECT t0.uuid AS uuid_1, t0.username AS username_2, t0.email AS email_3, t0.timezone AS timezone_4, t0.password_hash AS password_hash_5, t0.password_changed_at AS password_changed_at_6, t0.is_active AS is_active_7, t0.is_admin AS is_admin_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM users t0 WHERE t0.uuid = ?

Parameters:

[
  "019a737a-e670-7415-ab36-5ec0bb1437d5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.timezone AS timezone_4,
  t0.password_hash AS password_hash_5,
  t0.password_changed_at AS password_changed_at_6,
  t0.is_active AS is_active_7,
  t0.is_admin AS is_admin_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10
FROM
  users t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.username AS username_2, t0.email AS email_3, t0.timezone AS timezone_4, t0.password_hash AS password_hash_5, t0.password_changed_at AS password_changed_at_6, t0.is_active AS is_active_7, t0.is_admin AS is_admin_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM users t0 WHERE t0.uuid = '019a737a-e670-7415-ab36-5ec0bb1437d5';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

4.12 ms
(5.46%)

SELECT t0.uuid AS uuid_1, t0.gender AS gender_2, t0.style_uuid AS style_uuid_3, t0.life_sphere_uuid AS life_sphere_uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6 FROM groups t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "019a4f20-62ed-7741-aa70-c3c566b450cc"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.gender AS gender_2,
  t0.style_uuid AS style_uuid_3,
  t0.life_sphere_uuid AS life_sphere_uuid_4,
  t0.created_by AS created_by_5,
  t0.updated_by AS updated_by_6
FROM
groups
  t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.uuid AS uuid_1, t0.gender AS gender_2, t0.style_uuid AS style_uuid_3, t0.life_sphere_uuid AS life_sphere_uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6 FROM groups t0 WHERE t0.uuid = '019a4f20-62ed-7741-aa70-c3c566b450cc' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

3.39 ms
(4.50%)

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN (?, ?, ?, ?, ?) ORDER BY t1_.value ASC, i0_.name ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#2100
    __toString(): "019a6d93-9247-7aec-b81f-c0bfaabc3d20"
  }
  Symfony\Component\Uid\UuidV7 {#2380
    __toString(): "019a6d97-bce4-712a-8f16-d43b63ba89c1"
  }
  Symfony\Component\Uid\UuidV7 {#2378
    __toString(): "019a6d98-0c70-78e2-8b4d-c783d43b22af"
  }
  Symfony\Component\Uid\UuidV7 {#2403
    __toString(): "019a6d97-f963-72e3-aabf-161e29c780ce"
  }
  Symfony\Component\Uid\UuidV7 {#2410
    __toString(): "019a6d98-1902-7388-aec0-d4829919a330"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  i0_.uuid AS uuid_0,
  i0_.name AS name_1,
  i0_.name_en AS name_en_2,
  i0_.look_type_season AS look_type_season_3,
  t1_.uuid AS uuid_4,
  t1_.value AS value_5,
  c2_.uuid AS uuid_6,
  c2_.name AS name_7,
  c2_.name_en AS name_en_8,
  c2_.full_name AS full_name_9,
  c2_.path AS path_10,
  i0_.catalog_uuid AS catalog_uuid_11,
  i0_.layer_uuid AS layer_uuid_12,
  i0_.created_by AS created_by_13,
  i0_.updated_by AS updated_by_14,
  t1_.created_by AS created_by_15,
  t1_.updated_by AS updated_by_16,
  c2_.parent_uuid AS parent_uuid_17,
  c2_.created_by AS created_by_18,
  c2_.updated_by AS updated_by_19
FROM
  items i0_
  LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid
  INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid
WHERE
  i0_.catalog_uuid IN (?, ?, ?, ?, ?)
ORDER BY
  t1_.value ASC,
  i0_.name ASC

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN ('019a6d93-9247-7aec-b81f-c0bfaabc3d20', '019a6d97-bce4-712a-8f16-d43b63ba89c1', '019a6d98-0c70-78e2-8b4d-c783d43b22af', '019a6d97-f963-72e3-aabf-161e29c780ce', '019a6d98-1902-7388-aec0-d4829919a330') ORDER BY t1_.value ASC, i0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\ItemRepository->findByCatalogs (line 71)
7	App\Controller\GroupController->items (line 116)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

2.99 ms
(3.97%)

SELECT t0.uuid AS uuid_1, t0.group_uuid AS group_uuid_2, t0.item_uuid AS item_uuid_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5 FROM group_items t0 WHERE t0.group_uuid = ?

Parameters:

[
  "019a4f20-62ed-7741-aa70-c3c566b450cc"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.group_uuid AS group_uuid_2,
  t0.item_uuid AS item_uuid_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5
FROM
  group_items t0
WHERE
  t0.group_uuid = ?

SELECT t0.uuid AS uuid_1, t0.group_uuid AS group_uuid_2, t0.item_uuid AS item_uuid_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5 FROM group_items t0 WHERE t0.group_uuid = '019a4f20-62ed-7741-aa70-c3c566b450cc';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\GroupController->items (line 100)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

2.74 ms
(3.64%)

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4 FROM styles t0 WHERE t0.uuid = ?

Parameters:

[
  "019a4f1b-1679-7dab-9873-422008f430f6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.created_by AS created_by_3,
  t0.updated_by AS updated_by_4
FROM
  styles t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4 FROM styles t0 WHERE t0.uuid = '019a4f1b-1679-7dab-9873-422008f430f6';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\Style::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Style->__get (line 153)
7	App\Entity\Style->getName (line 40)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_3cf11879844a21e3a4b1962e7cedfd31::block_body (line 112)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_586c414a5ac3fc2cb8836f62b4071f2d->doDisplay (line 123)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_3cf11879844a21e3a4b1962e7cedfd31->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\GroupController->items (line 130)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

2.24 ms
(2.97%)

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t1_.value ASC, i0_.name ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#2749
    __toString(): "019a3ae7-6cda-704b-99dc-3beff703f697"
  }
  Symfony\Component\Uid\UuidV7 {#2979
    __toString(): "019a4ea0-7c12-77c5-94c1-971345e3da5e"
  }
  Symfony\Component\Uid\UuidV7 {#2977
    __toString(): "019a4ea2-22fe-701e-8be9-1b9aa463677f"
  }
  Symfony\Component\Uid\UuidV7 {#3009
    __toString(): "019a4ea2-3342-726d-986c-0a1c65eae610"
  }
  Symfony\Component\Uid\UuidV7 {#3016
    __toString(): "019a4ea2-9ba5-7716-896a-a7e5a30d2e89"
  }
  Symfony\Component\Uid\UuidV7 {#3023
    __toString(): "019a4ea1-ac3e-7d0a-9f85-e07abd1935a8"
  }
  Symfony\Component\Uid\UuidV7 {#3030
    __toString(): "019a4ea2-d2e2-77b2-bdcb-88f9928cbaee"
  }
  Symfony\Component\Uid\UuidV7 {#3037
    __toString(): "019a4ea2-6eda-7c08-9ee6-873481ab2e2f"
  }
  Symfony\Component\Uid\UuidV7 {#3044
    __toString(): "019a4ea1-d377-79ca-8026-f3b1966f7554"
  }
  Symfony\Component\Uid\UuidV7 {#2991
    __toString(): "019a4ea0-5617-7d30-b2bc-487a92c8125e"
  }
  Symfony\Component\Uid\UuidV7 {#2998
    __toString(): "019a6d02-4105-7006-9bdd-96e22400876d"
  }
  Symfony\Component\Uid\UuidV7 {#3090
    __toString(): "019a6d02-6e03-7876-8b3e-dd1aee2d68f7"
  }
  Symfony\Component\Uid\UuidV7 {#3097
    __toString(): "019a6d02-3360-77c0-bc1f-4f33f423b628"
  }
  Symfony\Component\Uid\UuidV7 {#3104
    __toString(): "019a6d02-7b6f-74b9-910d-fd3b59ccdf68"
  }
  Symfony\Component\Uid\UuidV7 {#3111
    __toString(): "019a6d02-97c0-7a02-b7ac-a857bb4abe88"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  i0_.uuid AS uuid_0,
  i0_.name AS name_1,
  i0_.name_en AS name_en_2,
  i0_.look_type_season AS look_type_season_3,
  t1_.uuid AS uuid_4,
  t1_.value AS value_5,
  c2_.uuid AS uuid_6,
  c2_.name AS name_7,
  c2_.name_en AS name_en_8,
  c2_.full_name AS full_name_9,
  c2_.path AS path_10,
  i0_.catalog_uuid AS catalog_uuid_11,
  i0_.layer_uuid AS layer_uuid_12,
  i0_.created_by AS created_by_13,
  i0_.updated_by AS updated_by_14,
  t1_.created_by AS created_by_15,
  t1_.updated_by AS updated_by_16,
  c2_.parent_uuid AS parent_uuid_17,
  c2_.created_by AS created_by_18,
  c2_.updated_by AS updated_by_19
FROM
  items i0_
  LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid
  INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid
WHERE
  i0_.catalog_uuid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t1_.value ASC,
  i0_.name ASC

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN ('019a3ae7-6cda-704b-99dc-3beff703f697', '019a4ea0-7c12-77c5-94c1-971345e3da5e', '019a4ea2-22fe-701e-8be9-1b9aa463677f', '019a4ea2-3342-726d-986c-0a1c65eae610', '019a4ea2-9ba5-7716-896a-a7e5a30d2e89', '019a4ea1-ac3e-7d0a-9f85-e07abd1935a8', '019a4ea2-d2e2-77b2-bdcb-88f9928cbaee', '019a4ea2-6eda-7c08-9ee6-873481ab2e2f', '019a4ea1-d377-79ca-8026-f3b1966f7554', '019a4ea0-5617-7d30-b2bc-487a92c8125e', '019a6d02-4105-7006-9bdd-96e22400876d', '019a6d02-6e03-7876-8b3e-dd1aee2d68f7', '019a6d02-3360-77c0-bc1f-4f33f423b628', '019a6d02-7b6f-74b9-910d-fd3b59ccdf68', '019a6d02-97c0-7a02-b7ac-a857bb4abe88') ORDER BY t1_.value ASC, i0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\ItemRepository->findByCatalogs (line 71)
7	App\Controller\GroupController->items (line 116)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

2.13 ms
(2.83%)

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4 FROM life_spheres t0 WHERE t0.uuid = ?

Parameters:

[
  "019a2614-7124-7c3c-a5be-9568ff9f27b7"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.created_by AS created_by_3,
  t0.updated_by AS updated_by_4
FROM
  life_spheres t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4 FROM life_spheres t0 WHERE t0.uuid = '019a2614-7124-7c3c-a5be-9568ff9f27b7';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\LifeSphere::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\LifeSphere->__get (line 153)
7	App\Entity\LifeSphere->getName (line 40)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_3cf11879844a21e3a4b1962e7cedfd31::block_body (line 114)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_586c414a5ac3fc2cb8836f62b4071f2d->doDisplay (line 123)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_3cf11879844a21e3a4b1962e7cedfd31->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\GroupController->items (line 130)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.89 ms
(2.51%)

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t1_.value ASC, i0_.name ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#2737
    __toString(): "019a4e9f-cf5d-7ed8-ba1b-eea466d387e9"
  }
  Symfony\Component\Uid\UuidV7 {#2735
    __toString(): "019a6d1b-155d-7811-99a4-6bd2fc930b1c"
  }
  Symfony\Component\Uid\UuidV7 {#2738
    __toString(): "019a6d1b-fe58-79d9-8e4c-5bc33187b75b"
  }
  Symfony\Component\Uid\UuidV7 {#2785
    __toString(): "019a6d1c-204e-7ffc-9274-b01ff6a77ae5"
  }
  Symfony\Component\Uid\UuidV7 {#2792
    __toString(): "019a6d1b-a2af-7acf-8435-fba50cb28ecc"
  }
  Symfony\Component\Uid\UuidV7 {#2799
    __toString(): "019a6d1b-d3ca-795e-975e-bdb04035af56"
  }
  Symfony\Component\Uid\UuidV7 {#2806
    __toString(): "019a6d1b-8a12-7c7e-af05-0d7da39aca97"
  }
  Symfony\Component\Uid\UuidV7 {#2813
    __toString(): "019a6d1b-ba3f-78a9-842a-dc38c32cfe86"
  }
  Symfony\Component\Uid\UuidV7 {#2820
    __toString(): "019a6d1b-e8df-7a27-85b8-1cad0c73012c"
  }
  Symfony\Component\Uid\UuidV7 {#2827
    __toString(): "019a6d1c-128b-7ab4-b855-cd3be8f11744"
  }
  Symfony\Component\Uid\UuidV7 {#2767
    __toString(): "019a7845-c96b-7583-beb2-7af4de7a4462"
  }
  Symfony\Component\Uid\UuidV7 {#2834
    __toString(): "019a7845-ddf3-77ae-bad6-943b1babf3f1"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  i0_.uuid AS uuid_0,
  i0_.name AS name_1,
  i0_.name_en AS name_en_2,
  i0_.look_type_season AS look_type_season_3,
  t1_.uuid AS uuid_4,
  t1_.value AS value_5,
  c2_.uuid AS uuid_6,
  c2_.name AS name_7,
  c2_.name_en AS name_en_8,
  c2_.full_name AS full_name_9,
  c2_.path AS path_10,
  i0_.catalog_uuid AS catalog_uuid_11,
  i0_.layer_uuid AS layer_uuid_12,
  i0_.created_by AS created_by_13,
  i0_.updated_by AS updated_by_14,
  t1_.created_by AS created_by_15,
  t1_.updated_by AS updated_by_16,
  c2_.parent_uuid AS parent_uuid_17,
  c2_.created_by AS created_by_18,
  c2_.updated_by AS updated_by_19
FROM
  items i0_
  LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid
  INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid
WHERE
  i0_.catalog_uuid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t1_.value ASC,
  i0_.name ASC

SELECT i0_.uuid AS uuid_0, i0_.name AS name_1, i0_.name_en AS name_en_2, i0_.look_type_season AS look_type_season_3, t1_.uuid AS uuid_4, t1_.value AS value_5, c2_.uuid AS uuid_6, c2_.name AS name_7, c2_.name_en AS name_en_8, c2_.full_name AS full_name_9, c2_.path AS path_10, i0_.catalog_uuid AS catalog_uuid_11, i0_.layer_uuid AS layer_uuid_12, i0_.created_by AS created_by_13, i0_.updated_by AS updated_by_14, t1_.created_by AS created_by_15, t1_.updated_by AS updated_by_16, c2_.parent_uuid AS parent_uuid_17, c2_.created_by AS created_by_18, c2_.updated_by AS updated_by_19 FROM items i0_ LEFT JOIN tx_layers t1_ ON i0_.layer_uuid = t1_.uuid INNER JOIN catalogs c2_ ON i0_.catalog_uuid = c2_.uuid WHERE i0_.catalog_uuid IN ('019a4e9f-cf5d-7ed8-ba1b-eea466d387e9', '019a6d1b-155d-7811-99a4-6bd2fc930b1c', '019a6d1b-fe58-79d9-8e4c-5bc33187b75b', '019a6d1c-204e-7ffc-9274-b01ff6a77ae5', '019a6d1b-a2af-7acf-8435-fba50cb28ecc', '019a6d1b-d3ca-795e-975e-bdb04035af56', '019a6d1b-8a12-7c7e-af05-0d7da39aca97', '019a6d1b-ba3f-78a9-842a-dc38c32cfe86', '019a6d1b-e8df-7a27-85b8-1cad0c73012c', '019a6d1c-128b-7ab4-b855-cd3be8f11744', '019a7845-c96b-7583-beb2-7af4de7a4462', '019a7845-ddf3-77ae-bad6-943b1babf3f1') ORDER BY t1_.value ASC, i0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\ItemRepository->findByCatalogs (line 71)
7	App\Controller\GroupController->items (line 116)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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
App\Entity\Item	78
App\Entity\Catalog	59
App\Entity\GroupItem	42
App\Entity\Layer	22
App\Entity\User	3
App\Entity\Group	1
App\Entity\Style	1
App\Entity\LifeSphere	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Group	The field App\Entity\Group#groupItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\GroupItem#group does not contain the required 'inversedBy: "groupItems"' attribute.
App\Entity\Style	No errors.
App\Entity\LifeSphere	No errors.
App\Entity\GroupItem	No errors.
App\Entity\Item	No errors.
App\Entity\GroupItemCharacteristicValue	No errors.
App\Entity\GroupItemNomenclature	No errors.
App\Entity\Length	No errors.
App\Entity\TxSilhouette	No errors.
App\Entity\Catalog	No errors.
App\Entity\Layer	No errors.
App\Entity\Nomenclature	The field App\Entity\Nomenclature#characteristicValues is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NomenclatureCharacteristicValue#nomenclature does not contain the required 'inversedBy: "characteristicValues"' attribute.

Symfony Profiler

GET https://capsule.amodus.ru/groups/019a4f20-62ed-7741-aa70-c3c566b450cc/items

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping