Redirect 302 redirect from POST @groups_items_add (d1c24f)

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
45b718

Query Metrics

71 Database Queries
11 Different statements
71.61 ms Query time
2 Invalid entities
202 Managed entities

Queries

Group similar statements

#▲ Time Info
1 5.46 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.19 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 2.96 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 6.44 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 0.73 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 {#2017
    __toString(): "019a25f6-ac86-711e-b92b-8a6654477e0e"
  }
]
View formatted query    View runnable query    View query backtrace
6 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 {#2043
    __toString(): "019a6d93-a0f6-763c-99e2-4e4514ce8b57"
  }
]
View formatted query    View runnable query    View query backtrace
7 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 {#1917
    __toString(): "019a6d94-8555-7a56-88b5-49899a7563ab"
  }
]
View formatted query    View runnable query    View query backtrace
8 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 {#2022
    __toString(): "019a6d96-504c-7c70-8797-93b9482e462a"
  }
]
View formatted query    View runnable query    View query backtrace
9 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 {#2070
    __toString(): "019a6d94-9283-722f-9ca9-13df4df2e439"
  }
]
View formatted query    View runnable query    View query backtrace
10 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 {#2091
    __toString(): "019a6d96-e7c8-782e-a3c5-b5696f480b6c"
  }
]
View formatted query    View runnable query    View query backtrace
11 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 {#2077
    __toString(): "019a6d94-7340-7e6f-b06d-490f6bde9ccc"
  }
]
View formatted query    View runnable query    View query backtrace
12 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 {#2050
    __toString(): "019a6d95-dff6-72d0-bb81-51d383916282"
  }
]
View formatted query    View runnable query    View query backtrace
13 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 {#2084
    __toString(): "019a6d94-5f77-7afc-a67e-8f8f3ac5b2b5"
  }
]
View formatted query    View runnable query    View query backtrace
14 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 {#2102
    __toString(): "019a6d94-d87d-78cf-ae47-d153067511c0"
  }
]
View formatted query    View runnable query    View query backtrace
15 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 {#2147
    __toString(): "019a6d94-e4ba-7029-8feb-22bdca143d99"
  }
]
View formatted query    View runnable query    View query backtrace
16 9.51 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 {#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
17 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 {#2025
    __toString(): "019a6d93-9247-7aec-b81f-c0bfaabc3d20"
  }
]
View formatted query    View runnable query    View query backtrace
18 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 {#2306
    __toString(): "019a6d97-bce4-712a-8f16-d43b63ba89c1"
  }
]
View formatted query    View runnable query    View query backtrace
19 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 {#2304
    __toString(): "019a6d98-0c70-78e2-8b4d-c783d43b22af"
  }
]
View formatted query    View runnable query    View query backtrace
20 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 {#2329
    __toString(): "019a6d97-f963-72e3-aabf-161e29c780ce"
  }
]
View formatted query    View runnable query    View query backtrace
21 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 {#2336
    __toString(): "019a6d98-1902-7388-aec0-d4829919a330"
  }
]
View formatted query    View runnable query    View query backtrace
22 1.69 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 {#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
23 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 {#2055
    __toString(): "019a6d93-5c9a-75b9-a948-3745ddd3dbb4"
  }
]
View formatted query    View runnable query    View query backtrace
24 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 {#2376
    __toString(): "019a6d99-032f-7400-a01e-a595bbb237ca"
  }
]
View formatted query    View runnable query    View query backtrace
25 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 {#2374
    __toString(): "019a6d99-385c-7959-b2b6-1c50bb634f77"
  }
]
View formatted query    View runnable query    View query backtrace
26 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 {#2399
    __toString(): "019a6d99-e3f4-722e-a3ce-823469de9db6"
  }
]
View formatted query    View runnable query    View query backtrace
27 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 {#2406
    __toString(): "019a6d99-8d05-74b3-a48d-acd1b7143536"
  }
]
View formatted query    View runnable query    View query backtrace
28 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 {#2413
    __toString(): "019a6d9a-2cc5-7c01-bd5b-a5918375517a"
  }
]
View formatted query    View runnable query    View query backtrace
29 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 {#2420
    __toString(): "019a6d99-d64c-7b19-bba9-551ed008224e"
  }
]
View formatted query    View runnable query    View query backtrace
30 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 {#2427
    __toString(): "019a6d9a-367f-72ee-9b6f-119dea44e0d2"
  }
]
View formatted query    View runnable query    View query backtrace
31 0.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 = ? ORDER BY c0_.name ASC
Parameters: 
[
  Symfony\Component\Uid\UuidV7 {#2434
    __toString(): "019a6d99-471c-7a20-ba01-bcea8476f7a8"
  }
]
View formatted query    View runnable query    View query backtrace
32 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 {#2441
    __toString(): "019a6d99-8125-7dcd-8402-400d6383e5cc"
  }
]
View formatted query    View runnable query    View query backtrace
33 2.01 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 {#2055
    __toString(): "019a6d93-5c9a-75b9-a948-3745ddd3dbb4"
  }
  Symfony\Component\Uid\UuidV7 {#2376
    __toString(): "019a6d99-032f-7400-a01e-a595bbb237ca"
  }
  Symfony\Component\Uid\UuidV7 {#2374
    __toString(): "019a6d99-385c-7959-b2b6-1c50bb634f77"
  }
  Symfony\Component\Uid\UuidV7 {#2399
    __toString(): "019a6d99-e3f4-722e-a3ce-823469de9db6"
  }
  Symfony\Component\Uid\UuidV7 {#2406
    __toString(): "019a6d99-8d05-74b3-a48d-acd1b7143536"
  }
  Symfony\Component\Uid\UuidV7 {#2413
    __toString(): "019a6d9a-2cc5-7c01-bd5b-a5918375517a"
  }
  Symfony\Component\Uid\UuidV7 {#2420
    __toString(): "019a6d99-d64c-7b19-bba9-551ed008224e"
  }
  Symfony\Component\Uid\UuidV7 {#2427
    __toString(): "019a6d9a-367f-72ee-9b6f-119dea44e0d2"
  }
  Symfony\Component\Uid\UuidV7 {#2434
    __toString(): "019a6d99-471c-7a20-ba01-bcea8476f7a8"
  }
  Symfony\Component\Uid\UuidV7 {#2441
    __toString(): "019a6d99-8125-7dcd-8402-400d6383e5cc"
  }
]
View formatted query    View runnable query    View query backtrace
34 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 {#2057
    __toString(): "019a6d93-77c8-725e-9098-dfea447579ee"
  }
]
View formatted query    View runnable query    View query backtrace
35 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 {#2577
    __toString(): "019a6d9e-8e9e-773d-b72a-0c845036922e"
  }
]
View formatted query    View runnable query    View query backtrace
36 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 {#2575
    __toString(): "019a6d9f-427d-7c5c-8cc7-34658a89ce69"
  }
]
View formatted query    View runnable query    View query backtrace
37 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 {#2600
    __toString(): "019a6d9f-81b2-7fa9-9315-1dfddb26e8d4"
  }
]
View formatted query    View runnable query    View query backtrace
38 0.44 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 {#2607
    __toString(): "019a6d9f-5841-70fb-ac27-cb892cfdae2e"
  }
]
View formatted query    View runnable query    View query backtrace
39 1.72 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 {#2057
    __toString(): "019a6d93-77c8-725e-9098-dfea447579ee"
  }
  Symfony\Component\Uid\UuidV7 {#2577
    __toString(): "019a6d9e-8e9e-773d-b72a-0c845036922e"
  }
  Symfony\Component\Uid\UuidV7 {#2575
    __toString(): "019a6d9f-427d-7c5c-8cc7-34658a89ce69"
  }
  Symfony\Component\Uid\UuidV7 {#2600
    __toString(): "019a6d9f-81b2-7fa9-9315-1dfddb26e8d4"
  }
  Symfony\Component\Uid\UuidV7 {#2607
    __toString(): "019a6d9f-5841-70fb-ac27-cb892cfdae2e"
  }
]
View formatted query    View runnable query    View query backtrace
40 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 {#2009
    __toString(): "019a25f6-962b-7181-9a5a-4a44b68a72d4"
  }
]
View formatted query    View runnable query    View query backtrace
41 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 {#2663
    __toString(): "019a4e9f-cf5d-7ed8-ba1b-eea466d387e9"
  }
]
View formatted query    View runnable query    View query backtrace
42 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 {#2661
    __toString(): "019a6d1b-155d-7811-99a4-6bd2fc930b1c"
  }
]
View formatted query    View runnable query    View query backtrace
43 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 {#2664
    __toString(): "019a6d1b-fe58-79d9-8e4c-5bc33187b75b"
  }
]
View formatted query    View runnable query    View query backtrace
44 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 {#2711
    __toString(): "019a6d1c-204e-7ffc-9274-b01ff6a77ae5"
  }
]
View formatted query    View runnable query    View query backtrace
45 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 {#2718
    __toString(): "019a6d1b-a2af-7acf-8435-fba50cb28ecc"
  }
]
View formatted query    View runnable query    View query backtrace
46 0.42 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 {#2725
    __toString(): "019a6d1b-d3ca-795e-975e-bdb04035af56"
  }
]
View formatted query    View runnable query    View query backtrace
47 0.43 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 {#2732
    __toString(): "019a6d1b-8a12-7c7e-af05-0d7da39aca97"
  }
]
View formatted query    View runnable query    View query backtrace
48 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 {#2739
    __toString(): "019a6d1b-ba3f-78a9-842a-dc38c32cfe86"
  }
]
View formatted query    View runnable query    View query backtrace
49 0.43 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 {#2746
    __toString(): "019a6d1b-e8df-7a27-85b8-1cad0c73012c"
  }
]
View formatted query    View runnable query    View query backtrace
50 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 {#2753
    __toString(): "019a6d1c-128b-7ab4-b855-cd3be8f11744"
  }
]
View formatted query    View runnable query    View query backtrace
51 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 {#2693
    __toString(): "019a7845-c96b-7583-beb2-7af4de7a4462"
  }
]
View formatted query    View runnable query    View query backtrace
52 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 {#2760
    __toString(): "019a7845-ddf3-77ae-bad6-943b1babf3f1"
  }
]
View formatted query    View runnable query    View query backtrace
53 1.88 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 {#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
54 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 {#2675
    __toString(): "019a3ae7-6cda-704b-99dc-3beff703f697"
  }
]
View formatted query    View runnable query    View query backtrace
55 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 {#2906
    __toString(): "019a4ea0-7c12-77c5-94c1-971345e3da5e"
  }
]
View formatted query    View runnable query    View query backtrace
56 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 {#2904
    __toString(): "019a4ea2-22fe-701e-8be9-1b9aa463677f"
  }
]
View formatted query    View runnable query    View query backtrace
57 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 {#2936
    __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 {#2943
    __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 {#2950
    __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 {#2957
    __toString(): "019a4ea2-d2e2-77b2-bdcb-88f9928cbaee"
  }
]
View formatted query    View runnable query    View query backtrace
61 1.28 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 {#2964
    __toString(): "019a4ea2-6eda-7c08-9ee6-873481ab2e2f"
  }
]
View formatted query    View runnable query    View query backtrace
62 0.46 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 {#2971
    __toString(): "019a4ea1-d377-79ca-8026-f3b1966f7554"
  }
]
View formatted query    View runnable query    View query backtrace
63 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 {#2918
    __toString(): "019a4ea0-5617-7d30-b2bc-487a92c8125e"
  }
]
View formatted query    View runnable query    View query backtrace
64 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 {#2925
    __toString(): "019a6d02-4105-7006-9bdd-96e22400876d"
  }
]
View formatted query    View runnable query    View query backtrace
65 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 {#3017
    __toString(): "019a6d02-6e03-7876-8b3e-dd1aee2d68f7"
  }
]
View formatted query    View runnable query    View query backtrace
66 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 {#3024
    __toString(): "019a6d02-3360-77c0-bc1f-4f33f423b628"
  }
]
View formatted query    View runnable query    View query backtrace
67 0.67 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 {#3031
    __toString(): "019a6d02-7b6f-74b9-910d-fd3b59ccdf68"
  }
]
View formatted query    View runnable query    View query backtrace
68 0.46 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 {#3038
    __toString(): "019a6d02-97c0-7a02-b7ac-a857bb4abe88"
  }
]
View formatted query    View runnable query    View query backtrace
69 2.10 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 {#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
70 1.98 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 1.67 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 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.