POST https://capsule.amodus.ru/groups/019a4f1d-a48e-743b-8177-635d0c53d684/items/019a6d90-e68c-718b-9393-66acf744f7cd/delete

Query Metrics

9 Database Queries
9 Different statements
27.18 ms Query time
2 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 5.79 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"
]
2 3.32 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"
]
3 3.09 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.look_type_season AS look_type_season_4, t0.catalog_uuid AS catalog_uuid_5, t0.layer_uuid AS layer_uuid_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM items t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "019a6d90-e68c-718b-9393-66acf744f7cd"
]
4 3.07 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 = ? AND t0.item_uuid = ? LIMIT 1
Parameters:
[
  "019a4f1d-a48e-743b-8177-635d0c53d684"
  "019a6d90-e68c-718b-9393-66acf744f7cd"
]
5 3.07 ms
SELECT t0.group_item_uuid AS group_item_uuid_1, t0.characteristic_value_uuid AS characteristic_value_uuid_2, t0.characteristic_uuid AS characteristic_uuid_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5 FROM group_item_characteristic_values t0 WHERE t0.group_item_uuid = ?
Parameters:
[
  "019c56ca-0b49-784f-9891-ac768e213bd2"
]
6 2.18 ms
SELECT t0.group_item_uuid AS group_item_uuid_1, t0.nomenclature_uuid AS nomenclature_uuid_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4 FROM group_item_nomenclatures t0 WHERE t0.group_item_uuid = ?
Parameters:
[
  "019c56ca-0b49-784f-9891-ac768e213bd2"
]
7 0.39 ms
"START TRANSACTION"
Parameters:
[]
8 4.10 ms
DELETE FROM group_items WHERE uuid = ?
Parameters:
[
  "019c56ca-0b49-784f-9891-ac768e213bd2"
]
9 2.16 ms
"COMMIT"
Parameters:
[]

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\User 2
App\Entity\Group 1
App\Entity\Style 1
App\Entity\LifeSphere 1
App\Entity\Item 1
App\Entity\Catalog 1
App\Entity\Layer 1
App\Entity\GroupItem 0

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\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.
App\Entity\GroupItemCharacteristicValue No errors.
App\Entity\GroupItemNomenclature No errors.
App\Entity\Length No errors.
App\Entity\TxSilhouette No errors.
App\Entity\CharacteristicValue No errors.
App\Entity\Characteristic No errors.