Redirect 302 redirect from POST @groups_items_add (13dd53)

GET https://capsule.amodus.ru/groups/019a4f1d-a48e-743b-8177-635d0c53d684/items

Response
200 OK
Browse referrer URL
IP
136.169.214.91
Profiled on
Token
1c32a1

Query Metrics

71 Database Queries
11 Different statements
83.46 ms Query time
2 Invalid entities
201 Managed entities

Queries

Group similar statements

#▲ Time Info
1 5.94 ms 
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
2 3.69 ms 
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
3 3.40 ms 
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
4 8.62 ms 
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
5 1.11 ms 
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 {#2002
    __toString(): "019a25f6-ac86-711e-b92b-8a6654477e0e"
  }
]
View formatted query    View runnable query    View query backtrace
6 0.86 ms 
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 {#2028
    __toString(): "019a6d93-a0f6-763c-99e2-4e4514ce8b57"
  }
]
View formatted query    View runnable query    View query backtrace
7 0.81 ms 
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 {#1902
    __toString(): "019a6d94-8555-7a56-88b5-49899a7563ab"
  }
]
View formatted query    View runnable query    View query backtrace
8 0.70 ms 
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 {#2007
    __toString(): "019a6d96-504c-7c70-8797-93b9482e462a"
  }
]
View formatted query    View runnable query    View query backtrace
9 0.72 ms 
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 {#2055
    __toString(): "019a6d94-9283-722f-9ca9-13df4df2e439"
  }
]
View formatted query    View runnable query    View query backtrace
10 0.71 ms 
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 {#2076
    __toString(): "019a6d96-e7c8-782e-a3c5-b5696f480b6c"
  }
]
View formatted query    View runnable query    View query backtrace
11 0.68 ms 
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 {#2062
    __toString(): "019a6d94-7340-7e6f-b06d-490f6bde9ccc"
  }
]
View formatted query    View runnable query    View query backtrace
12 0.80 ms 
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 {#2035
    __toString(): "019a6d95-dff6-72d0-bb81-51d383916282"
  }
]
View formatted query    View runnable query    View query backtrace
13 0.85 ms 
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 {#2069
    __toString(): "019a6d94-5f77-7afc-a67e-8f8f3ac5b2b5"
  }
]
View formatted query    View runnable query    View query backtrace
14 0.72 ms 
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 {#2087
    __toString(): "019a6d94-d87d-78cf-ae47-d153067511c0"
  }
]
View formatted query    View runnable query    View query backtrace
15 0.59 ms 
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 {#2132
    __toString(): "019a6d94-e4ba-7029-8feb-22bdca143d99"
  }
]
View formatted query    View runnable query    View query backtrace
16 9.48 ms 
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 {#2028
    __toString(): "019a6d93-a0f6-763c-99e2-4e4514ce8b57"
  }
  Symfony\Component\Uid\UuidV7 {#1902
    __toString(): "019a6d94-8555-7a56-88b5-49899a7563ab"
  }
  Symfony\Component\Uid\UuidV7 {#2007
    __toString(): "019a6d96-504c-7c70-8797-93b9482e462a"
  }
  Symfony\Component\Uid\UuidV7 {#2055
    __toString(): "019a6d94-9283-722f-9ca9-13df4df2e439"
  }
  Symfony\Component\Uid\UuidV7 {#2076
    __toString(): "019a6d96-e7c8-782e-a3c5-b5696f480b6c"
  }
  Symfony\Component\Uid\UuidV7 {#2062
    __toString(): "019a6d94-7340-7e6f-b06d-490f6bde9ccc"
  }
  Symfony\Component\Uid\UuidV7 {#2035
    __toString(): "019a6d95-dff6-72d0-bb81-51d383916282"
  }
  Symfony\Component\Uid\UuidV7 {#2069
    __toString(): "019a6d94-5f77-7afc-a67e-8f8f3ac5b2b5"
  }
  Symfony\Component\Uid\UuidV7 {#2087
    __toString(): "019a6d94-d87d-78cf-ae47-d153067511c0"
  }
  Symfony\Component\Uid\UuidV7 {#2132
    __toString(): "019a6d94-e4ba-7029-8feb-22bdca143d99"
  }
]
View formatted query    View runnable query    View query backtrace
17 1.12 ms 
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 {#2010
    __toString(): "019a6d93-9247-7aec-b81f-c0bfaabc3d20"
  }
]
View formatted query    View runnable query    View query backtrace
18 0.69 ms 
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 {#2291
    __toString(): "019a6d97-bce4-712a-8f16-d43b63ba89c1"
  }
]
View formatted query    View runnable query    View query backtrace
19 0.76 ms 
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 {#2289
    __toString(): "019a6d98-0c70-78e2-8b4d-c783d43b22af"
  }
]
View formatted query    View runnable query    View query backtrace
20 0.75 ms 
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 {#2314
    __toString(): "019a6d97-f963-72e3-aabf-161e29c780ce"
  }
]
View formatted query    View runnable query    View query backtrace
21 0.57 ms 
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 {#2321
    __toString(): "019a6d98-1902-7388-aec0-d4829919a330"
  }
]
View formatted query    View runnable query    View query backtrace
22 2.14 ms 
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 {#2010
    __toString(): "019a6d93-9247-7aec-b81f-c0bfaabc3d20"
  }
  Symfony\Component\Uid\UuidV7 {#2291
    __toString(): "019a6d97-bce4-712a-8f16-d43b63ba89c1"
  }
  Symfony\Component\Uid\UuidV7 {#2289
    __toString(): "019a6d98-0c70-78e2-8b4d-c783d43b22af"
  }
  Symfony\Component\Uid\UuidV7 {#2314
    __toString(): "019a6d97-f963-72e3-aabf-161e29c780ce"
  }
  Symfony\Component\Uid\UuidV7 {#2321
    __toString(): "019a6d98-1902-7388-aec0-d4829919a330"
  }
]
View formatted query    View runnable query    View query backtrace
23 0.60 ms 
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 {#2040
    __toString(): "019a6d93-5c9a-75b9-a948-3745ddd3dbb4"
  }
]
View formatted query    View runnable query    View query backtrace
24 0.60 ms 
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 {#2361
    __toString(): "019a6d99-032f-7400-a01e-a595bbb237ca"
  }
]
View formatted query    View runnable query    View query backtrace
25 0.58 ms 
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 {#2359
    __toString(): "019a6d99-385c-7959-b2b6-1c50bb634f77"
  }
]
View formatted query    View runnable query    View query backtrace
26 0.72 ms 
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 {#2384
    __toString(): "019a6d99-e3f4-722e-a3ce-823469de9db6"
  }
]
View formatted query    View runnable query    View query backtrace
27 0.58 ms 
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 {#2391
    __toString(): "019a6d99-8d05-74b3-a48d-acd1b7143536"
  }
]
View formatted query    View runnable query    View query backtrace
28 0.55 ms 
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 {#2398
    __toString(): "019a6d9a-2cc5-7c01-bd5b-a5918375517a"
  }
]
View formatted query    View runnable query    View query backtrace
29 0.48 ms 
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 {#2405
    __toString(): "019a6d99-d64c-7b19-bba9-551ed008224e"
  }
]
View formatted query    View runnable query    View query backtrace
30 0.50 ms 
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 {#2412
    __toString(): "019a6d9a-367f-72ee-9b6f-119dea44e0d2"
  }
]
View formatted query    View runnable query    View query backtrace
31 0.51 ms 
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 {#2419
    __toString(): "019a6d99-471c-7a20-ba01-bcea8476f7a8"
  }
]
View formatted query    View runnable query    View query backtrace
32 0.58 ms 
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 {#2426
    __toString(): "019a6d99-8125-7dcd-8402-400d6383e5cc"
  }
]
View formatted query    View runnable query    View query backtrace
33 2.37 ms 
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 {#2040
    __toString(): "019a6d93-5c9a-75b9-a948-3745ddd3dbb4"
  }
  Symfony\Component\Uid\UuidV7 {#2361
    __toString(): "019a6d99-032f-7400-a01e-a595bbb237ca"
  }
  Symfony\Component\Uid\UuidV7 {#2359
    __toString(): "019a6d99-385c-7959-b2b6-1c50bb634f77"
  }
  Symfony\Component\Uid\UuidV7 {#2384
    __toString(): "019a6d99-e3f4-722e-a3ce-823469de9db6"
  }
  Symfony\Component\Uid\UuidV7 {#2391
    __toString(): "019a6d99-8d05-74b3-a48d-acd1b7143536"
  }
  Symfony\Component\Uid\UuidV7 {#2398
    __toString(): "019a6d9a-2cc5-7c01-bd5b-a5918375517a"
  }
  Symfony\Component\Uid\UuidV7 {#2405
    __toString(): "019a6d99-d64c-7b19-bba9-551ed008224e"
  }
  Symfony\Component\Uid\UuidV7 {#2412
    __toString(): "019a6d9a-367f-72ee-9b6f-119dea44e0d2"
  }
  Symfony\Component\Uid\UuidV7 {#2419
    __toString(): "019a6d99-471c-7a20-ba01-bcea8476f7a8"
  }
  Symfony\Component\Uid\UuidV7 {#2426
    __toString(): "019a6d99-8125-7dcd-8402-400d6383e5cc"
  }
]
View formatted query    View runnable query    View query backtrace
34 0.85 ms 
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 {#2042
    __toString(): "019a6d93-77c8-725e-9098-dfea447579ee"
  }
]
View formatted query    View runnable query    View query backtrace
35 0.71 ms 
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 {#2562
    __toString(): "019a6d9e-8e9e-773d-b72a-0c845036922e"
  }
]
View formatted query    View runnable query    View query backtrace
36 0.58 ms 
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 {#2560
    __toString(): "019a6d9f-427d-7c5c-8cc7-34658a89ce69"
  }
]
View formatted query    View runnable query    View query backtrace
37 0.56 ms 
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 {#2585
    __toString(): "019a6d9f-81b2-7fa9-9315-1dfddb26e8d4"
  }
]
View formatted query    View runnable query    View query backtrace
38 0.63 ms 
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 {#2592
    __toString(): "019a6d9f-5841-70fb-ac27-cb892cfdae2e"
  }
]
View formatted query    View runnable query    View query backtrace
39 1.97 ms 
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 {#2042
    __toString(): "019a6d93-77c8-725e-9098-dfea447579ee"
  }
  Symfony\Component\Uid\UuidV7 {#2562
    __toString(): "019a6d9e-8e9e-773d-b72a-0c845036922e"
  }
  Symfony\Component\Uid\UuidV7 {#2560
    __toString(): "019a6d9f-427d-7c5c-8cc7-34658a89ce69"
  }
  Symfony\Component\Uid\UuidV7 {#2585
    __toString(): "019a6d9f-81b2-7fa9-9315-1dfddb26e8d4"
  }
  Symfony\Component\Uid\UuidV7 {#2592
    __toString(): "019a6d9f-5841-70fb-ac27-cb892cfdae2e"
  }
]
View formatted query    View runnable query    View query backtrace
40 0.60 ms 
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 {#1994
    __toString(): "019a25f6-962b-7181-9a5a-4a44b68a72d4"
  }
]
View formatted query    View runnable query    View query backtrace
41 0.55 ms 
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 {#2648
    __toString(): "019a4e9f-cf5d-7ed8-ba1b-eea466d387e9"
  }
]
View formatted query    View runnable query    View query backtrace
42 0.63 ms 
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 {#2646
    __toString(): "019a6d1b-155d-7811-99a4-6bd2fc930b1c"
  }
]
View formatted query    View runnable query    View query backtrace
43 0.56 ms 
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 {#2649
    __toString(): "019a6d1b-fe58-79d9-8e4c-5bc33187b75b"
  }
]
View formatted query    View runnable query    View query backtrace
44 0.57 ms 
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 {#2696
    __toString(): "019a6d1c-204e-7ffc-9274-b01ff6a77ae5"
  }
]
View formatted query    View runnable query    View query backtrace
45 0.47 ms 
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 {#2703
    __toString(): "019a6d1b-a2af-7acf-8435-fba50cb28ecc"
  }
]
View formatted query    View runnable query    View query backtrace
46 0.45 ms 
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 {#2710
    __toString(): "019a6d1b-d3ca-795e-975e-bdb04035af56"
  }
]
View formatted query    View runnable query    View query backtrace
47 0.47 ms 
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 {#2717
    __toString(): "019a6d1b-8a12-7c7e-af05-0d7da39aca97"
  }
]
View formatted query    View runnable query    View query backtrace
48 0.49 ms 
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 {#2724
    __toString(): "019a6d1b-ba3f-78a9-842a-dc38c32cfe86"
  }
]
View formatted query    View runnable query    View query backtrace
49 0.54 ms 
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 {#2731
    __toString(): "019a6d1b-e8df-7a27-85b8-1cad0c73012c"
  }
]
View formatted query    View runnable query    View query backtrace
50 0.53 ms 
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 {#2738
    __toString(): "019a6d1c-128b-7ab4-b855-cd3be8f11744"
  }
]
View formatted query    View runnable query    View query backtrace
51 0.55 ms 
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 {#2678
    __toString(): "019a7845-c96b-7583-beb2-7af4de7a4462"
  }
]
View formatted query    View runnable query    View query backtrace
52 0.52 ms 
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 {#2745
    __toString(): "019a7845-ddf3-77ae-bad6-943b1babf3f1"
  }
]
View formatted query    View runnable query    View query backtrace
53 2.16 ms 
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 {#2648
    __toString(): "019a4e9f-cf5d-7ed8-ba1b-eea466d387e9"
  }
  Symfony\Component\Uid\UuidV7 {#2646
    __toString(): "019a6d1b-155d-7811-99a4-6bd2fc930b1c"
  }
  Symfony\Component\Uid\UuidV7 {#2649
    __toString(): "019a6d1b-fe58-79d9-8e4c-5bc33187b75b"
  }
  Symfony\Component\Uid\UuidV7 {#2696
    __toString(): "019a6d1c-204e-7ffc-9274-b01ff6a77ae5"
  }
  Symfony\Component\Uid\UuidV7 {#2703
    __toString(): "019a6d1b-a2af-7acf-8435-fba50cb28ecc"
  }
  Symfony\Component\Uid\UuidV7 {#2710
    __toString(): "019a6d1b-d3ca-795e-975e-bdb04035af56"
  }
  Symfony\Component\Uid\UuidV7 {#2717
    __toString(): "019a6d1b-8a12-7c7e-af05-0d7da39aca97"
  }
  Symfony\Component\Uid\UuidV7 {#2724
    __toString(): "019a6d1b-ba3f-78a9-842a-dc38c32cfe86"
  }
  Symfony\Component\Uid\UuidV7 {#2731
    __toString(): "019a6d1b-e8df-7a27-85b8-1cad0c73012c"
  }
  Symfony\Component\Uid\UuidV7 {#2738
    __toString(): "019a6d1c-128b-7ab4-b855-cd3be8f11744"
  }
  Symfony\Component\Uid\UuidV7 {#2678
    __toString(): "019a7845-c96b-7583-beb2-7af4de7a4462"
  }
  Symfony\Component\Uid\UuidV7 {#2745
    __toString(): "019a7845-ddf3-77ae-bad6-943b1babf3f1"
  }
]
View formatted query    View runnable query    View query backtrace
54 0.66 ms 
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 {#2660
    __toString(): "019a3ae7-6cda-704b-99dc-3beff703f697"
  }
]
View formatted query    View runnable query    View query backtrace
55 0.57 ms 
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 {#2891
    __toString(): "019a4ea0-7c12-77c5-94c1-971345e3da5e"
  }
]
View formatted query    View runnable query    View query backtrace
56 0.54 ms 
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 {#2889
    __toString(): "019a4ea2-22fe-701e-8be9-1b9aa463677f"
  }
]
View formatted query    View runnable query    View query backtrace
57 0.53 ms 
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 {#2921
    __toString(): "019a4ea2-3342-726d-986c-0a1c65eae610"
  }
]
View formatted query    View runnable query    View query backtrace
58 0.50 ms 
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 {#2928
    __toString(): "019a4ea2-9ba5-7716-896a-a7e5a30d2e89"
  }
]
View formatted query    View runnable query    View query backtrace
59 0.50 ms 
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 {#2935
    __toString(): "019a4ea1-ac3e-7d0a-9f85-e07abd1935a8"
  }
]
View formatted query    View runnable query    View query backtrace
60 0.49 ms 
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 {#2942
    __toString(): "019a4ea2-d2e2-77b2-bdcb-88f9928cbaee"
  }
]
View formatted query    View runnable query    View query backtrace
61 0.55 ms 
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 {#2949
    __toString(): "019a4ea2-6eda-7c08-9ee6-873481ab2e2f"
  }
]
View formatted query    View runnable query    View query backtrace
62 0.49 ms 
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 {#2956
    __toString(): "019a4ea1-d377-79ca-8026-f3b1966f7554"
  }
]
View formatted query    View runnable query    View query backtrace
63 0.58 ms 
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 {#2903
    __toString(): "019a4ea0-5617-7d30-b2bc-487a92c8125e"
  }
]
View formatted query    View runnable query    View query backtrace
64 0.55 ms 
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 {#2910
    __toString(): "019a6d02-4105-7006-9bdd-96e22400876d"
  }
]
View formatted query    View runnable query    View query backtrace
65 0.51 ms 
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 {#3002
    __toString(): "019a6d02-6e03-7876-8b3e-dd1aee2d68f7"
  }
]
View formatted query    View runnable query    View query backtrace
66 0.75 ms 
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 {#3009
    __toString(): "019a6d02-3360-77c0-bc1f-4f33f423b628"
  }
]
View formatted query    View runnable query    View query backtrace
67 0.61 ms 
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 {#3016
    __toString(): "019a6d02-7b6f-74b9-910d-fd3b59ccdf68"
  }
]
View formatted query    View runnable query    View query backtrace
68 0.60 ms 
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 {#3023
    __toString(): "019a6d02-97c0-7a02-b7ac-a857bb4abe88"
  }
]
View formatted query    View runnable query    View query backtrace
69 2.37 ms 
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 {#2660
    __toString(): "019a3ae7-6cda-704b-99dc-3beff703f697"
  }
  Symfony\Component\Uid\UuidV7 {#2891
    __toString(): "019a4ea0-7c12-77c5-94c1-971345e3da5e"
  }
  Symfony\Component\Uid\UuidV7 {#2889
    __toString(): "019a4ea2-22fe-701e-8be9-1b9aa463677f"
  }
  Symfony\Component\Uid\UuidV7 {#2921
    __toString(): "019a4ea2-3342-726d-986c-0a1c65eae610"
  }
  Symfony\Component\Uid\UuidV7 {#2928
    __toString(): "019a4ea2-9ba5-7716-896a-a7e5a30d2e89"
  }
  Symfony\Component\Uid\UuidV7 {#2935
    __toString(): "019a4ea1-ac3e-7d0a-9f85-e07abd1935a8"
  }
  Symfony\Component\Uid\UuidV7 {#2942
    __toString(): "019a4ea2-d2e2-77b2-bdcb-88f9928cbaee"
  }
  Symfony\Component\Uid\UuidV7 {#2949
    __toString(): "019a4ea2-6eda-7c08-9ee6-873481ab2e2f"
  }
  Symfony\Component\Uid\UuidV7 {#2956
    __toString(): "019a4ea1-d377-79ca-8026-f3b1966f7554"
  }
  Symfony\Component\Uid\UuidV7 {#2903
    __toString(): "019a4ea0-5617-7d30-b2bc-487a92c8125e"
  }
  Symfony\Component\Uid\UuidV7 {#2910
    __toString(): "019a6d02-4105-7006-9bdd-96e22400876d"
  }
  Symfony\Component\Uid\UuidV7 {#3002
    __toString(): "019a6d02-6e03-7876-8b3e-dd1aee2d68f7"
  }
  Symfony\Component\Uid\UuidV7 {#3009
    __toString(): "019a6d02-3360-77c0-bc1f-4f33f423b628"
  }
  Symfony\Component\Uid\UuidV7 {#3016
    __toString(): "019a6d02-7b6f-74b9-910d-fd3b59ccdf68"
  }
  Symfony\Component\Uid\UuidV7 {#3023
    __toString(): "019a6d02-97c0-7a02-b7ac-a857bb4abe88"
  }
]
View formatted query    View runnable query    View query backtrace
70 2.44 ms 
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
71 2.09 ms 
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

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 36
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.