Symfony Profiler

Query Metrics

71 Database Queries

11 Different statements

87.14 ms Query time

2 Invalid entities

202 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

39.47 ms
(45.29%)

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 {#2017
    __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)

15.30 ms
(17.56%)

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 {#2043
    __toString(): "019a6d93-a0f6-763c-99e2-4e4514ce8b57"
  }
  Symfony\Component\Uid\UuidV7 {#1917
    __toString(): "019a6d94-8555-7a56-88b5-49899a7563ab"
  }
  Symfony\Component\Uid\UuidV7 {#2022
    __toString(): "019a6d96-504c-7c70-8797-93b9482e462a"
  }
  Symfony\Component\Uid\UuidV7 {#2070
    __toString(): "019a6d94-9283-722f-9ca9-13df4df2e439"
  }
  Symfony\Component\Uid\UuidV7 {#2091
    __toString(): "019a6d96-e7c8-782e-a3c5-b5696f480b6c"
  }
  Symfony\Component\Uid\UuidV7 {#2077
    __toString(): "019a6d94-7340-7e6f-b06d-490f6bde9ccc"
  }
  Symfony\Component\Uid\UuidV7 {#2050
    __toString(): "019a6d95-dff6-72d0-bb81-51d383916282"
  }
  Symfony\Component\Uid\UuidV7 {#2084
    __toString(): "019a6d94-5f77-7afc-a67e-8f8f3ac5b2b5"
  }
  Symfony\Component\Uid\UuidV7 {#2102
    __toString(): "019a6d94-d87d-78cf-ae47-d153067511c0"
  }
  Symfony\Component\Uid\UuidV7 {#2147
    __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.58 ms
(7.55%)

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)

5.68 ms
(6.51%)

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.42 ms
(5.07%)

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 {#2025
    __toString(): "019a6d93-9247-7aec-b81f-c0bfaabc3d20"
  }
  Symfony\Component\Uid\UuidV7 {#2306
    __toString(): "019a6d97-bce4-712a-8f16-d43b63ba89c1"
  }
  Symfony\Component\Uid\UuidV7 {#2304
    __toString(): "019a6d98-0c70-78e2-8b4d-c783d43b22af"
  }
  Symfony\Component\Uid\UuidV7 {#2329
    __toString(): "019a6d97-f963-72e3-aabf-161e29c780ce"
  }
  Symfony\Component\Uid\UuidV7 {#2336
    __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)

3.66 ms
(4.20%)

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:

[
  "019a4f1d-a48e-743b-8177-635d0c53d684"
]

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 = '019a4f1d-a48e-743b-8177-635d0c53d684' 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.10 ms
(3.56%)

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:

[
  "019a4f1d-a48e-743b-8177-635d0c53d684"
]

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 = '019a4f1d-a48e-743b-8177-635d0c53d684';

#	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.42 ms
(2.78%)

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 {#2675
    __toString(): "019a3ae7-6cda-704b-99dc-3beff703f697"
  }
  Symfony\Component\Uid\UuidV7 {#2906
    __toString(): "019a4ea0-7c12-77c5-94c1-971345e3da5e"
  }
  Symfony\Component\Uid\UuidV7 {#2904
    __toString(): "019a4ea2-22fe-701e-8be9-1b9aa463677f"
  }
  Symfony\Component\Uid\UuidV7 {#2936
    __toString(): "019a4ea2-3342-726d-986c-0a1c65eae610"
  }
  Symfony\Component\Uid\UuidV7 {#2943
    __toString(): "019a4ea2-9ba5-7716-896a-a7e5a30d2e89"
  }
  Symfony\Component\Uid\UuidV7 {#2950
    __toString(): "019a4ea1-ac3e-7d0a-9f85-e07abd1935a8"
  }
  Symfony\Component\Uid\UuidV7 {#2957
    __toString(): "019a4ea2-d2e2-77b2-bdcb-88f9928cbaee"
  }
  Symfony\Component\Uid\UuidV7 {#2964
    __toString(): "019a4ea2-6eda-7c08-9ee6-873481ab2e2f"
  }
  Symfony\Component\Uid\UuidV7 {#2971
    __toString(): "019a4ea1-d377-79ca-8026-f3b1966f7554"
  }
  Symfony\Component\Uid\UuidV7 {#2918
    __toString(): "019a4ea0-5617-7d30-b2bc-487a92c8125e"
  }
  Symfony\Component\Uid\UuidV7 {#2925
    __toString(): "019a6d02-4105-7006-9bdd-96e22400876d"
  }
  Symfony\Component\Uid\UuidV7 {#3017
    __toString(): "019a6d02-6e03-7876-8b3e-dd1aee2d68f7"
  }
  Symfony\Component\Uid\UuidV7 {#3024
    __toString(): "019a6d02-3360-77c0-bc1f-4f33f423b628"
  }
  Symfony\Component\Uid\UuidV7 {#3031
    __toString(): "019a6d02-7b6f-74b9-910d-fd3b59ccdf68"
  }
  Symfony\Component\Uid\UuidV7 {#3038
    __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.41 ms
(2.77%)

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.16 ms
(2.48%)

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 {#2663
    __toString(): "019a4e9f-cf5d-7ed8-ba1b-eea466d387e9"
  }
  Symfony\Component\Uid\UuidV7 {#2661
    __toString(): "019a6d1b-155d-7811-99a4-6bd2fc930b1c"
  }
  Symfony\Component\Uid\UuidV7 {#2664
    __toString(): "019a6d1b-fe58-79d9-8e4c-5bc33187b75b"
  }
  Symfony\Component\Uid\UuidV7 {#2711
    __toString(): "019a6d1c-204e-7ffc-9274-b01ff6a77ae5"
  }
  Symfony\Component\Uid\UuidV7 {#2718
    __toString(): "019a6d1b-a2af-7acf-8435-fba50cb28ecc"
  }
  Symfony\Component\Uid\UuidV7 {#2725
    __toString(): "019a6d1b-d3ca-795e-975e-bdb04035af56"
  }
  Symfony\Component\Uid\UuidV7 {#2732
    __toString(): "019a6d1b-8a12-7c7e-af05-0d7da39aca97"
  }
  Symfony\Component\Uid\UuidV7 {#2739
    __toString(): "019a6d1b-ba3f-78a9-842a-dc38c32cfe86"
  }
  Symfony\Component\Uid\UuidV7 {#2746
    __toString(): "019a6d1b-e8df-7a27-85b8-1cad0c73012c"
  }
  Symfony\Component\Uid\UuidV7 {#2753
    __toString(): "019a6d1c-128b-7ab4-b855-cd3be8f11744"
  }
  Symfony\Component\Uid\UuidV7 {#2693
    __toString(): "019a7845-c96b-7583-beb2-7af4de7a4462"
  }
  Symfony\Component\Uid\UuidV7 {#2760
    __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)

1.95 ms
(2.24%)

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:

[
  "019a4f18-4176-72b5-9f18-25587d3a4f94"
]

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 = '019a4f18-4176-72b5-9f18-25587d3a4f94';

#	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)

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	37
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/019a4f1d-a48e-743b-8177-635d0c53d684/items

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping