Query Metrics

12 Database Queries
6 Different statements
13.04 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 4.55 ms
SELECT t0.description AS description_1, t0.title AS title_2, t0.value AS value_3, t0.section AS section_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.estate_id AS estate_id_8, t0.type_id AS type_id_9, t0.assurance_id AS assurance_id_10, t0.life_assurance_id AS life_assurance_id_11, t0.bank_chest_id AS bank_chest_id_12, t0.organisation_id AS organisation_id_13, t0.property_id AS property_id_14, t0.vehicle_id AS vehicle_id_15, t0.financial_account_id AS financial_account_id_16, t0.art_work_id AS art_work_id_17, t0.furniture_id AS furniture_id_18, t0.jewelry_id AS jewelry_id_19, t0.title_and_value_id AS title_and_value_id_20, t0.half_community_debt_id AS half_community_debt_id_21, t0.personal_debt_id AS personal_debt_id_22, t0.succession_charge_id AS succession_charge_id_23, t0.donation_id AS donation_id_24 FROM "inventories" t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "0192899c-9ce2-701a-a850-bc78610d662e"
]
2 2.49 ms
SELECT t0.name AS name_3, t0.description AS description_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type, t1.liability_categories AS liability_categories_8, t2.asset_categories AS asset_categories_9 FROM "inventory_types" t0 LEFT JOIN "liability_types" t1 ON t0.id = t1.id LEFT JOIN "asset_types" t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  "0191ff35-23e6-7fb0-8bb3-97947d5ff4bc"
]
3 1.65 ms
SELECT t0.name AS name_1, t0.address AS address_2, t0.value AS value_3, t0.expertise_required_by_heir AS expertise_required_by_heir_4, t0.type AS type_5, t0.usufruct_accretion_clause AS usufruct_accretion_clause_6, t0.full_ownership_accretion_clause AS full_ownership_accretion_clause_7, t0.usufruct_reversion_clause AS usufruct_reversion_clause_8, t0.continued_usufruct AS continued_usufruct_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM properties t0 WHERE t0.id = ?
Parameters:
[
  "0192899c-9ce3-724f-b8e5-217599a78ba3"
]
4 1.18 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.inventory_id AS inventory_id_4, t0.document_id AS document_id_5, t0.type_id AS type_id_6 FROM "inventory_documents" t0 WHERE t0.inventory_id = ?
Parameters:
[
  "0192899c-9ce2-701a-a850-bc78610d662e"
]
5 1.01 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.section AS section_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.inventory_type_id AS inventory_type_id_7, t0.inventory_document_id AS inventory_document_id_8 FROM "inventory_document_types" t0 WHERE t0.id = ?
Parameters:
[
  "0192058a-620d-7d0a-9184-6fdc587f5fee"
]
6 0.48 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.name AS name_3, t0.size AS size_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM "media_objects" t0 WHERE t0.id = ?
Parameters:
[
  "01928afe-be70-7d8b-90fa-d7fa7cd6b278"
]
7 0.37 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.section AS section_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.inventory_type_id AS inventory_type_id_7, t0.inventory_document_id AS inventory_document_id_8 FROM "inventory_document_types" t0 WHERE t0.id = ?
Parameters:
[
  "0192058b-23fa-7ec4-86c4-5d0374722248"
]
8 0.25 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.name AS name_3, t0.size AS size_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM "media_objects" t0 WHERE t0.id = ?
Parameters:
[
  "01928afe-be71-7fd5-a7bd-468ef64fd87e"
]
9 0.24 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.section AS section_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.inventory_type_id AS inventory_type_id_7, t0.inventory_document_id AS inventory_document_id_8 FROM "inventory_document_types" t0 WHERE t0.id = ?
Parameters:
[
  "0192058b-e21a-7df3-bf2c-1d843d3ccf21"
]
10 0.23 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.name AS name_3, t0.size AS size_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM "media_objects" t0 WHERE t0.id = ?
Parameters:
[
  "01928afe-be72-7891-99cd-a277fdba6b1e"
]
11 0.27 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.section AS section_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.inventory_type_id AS inventory_type_id_7, t0.inventory_document_id AS inventory_document_id_8 FROM "inventory_document_types" t0 WHERE t0.id = ?
Parameters:
[
  "0192058c-7f3d-7bab-8d7d-436e0bf626f9"
]
12 0.30 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.name AS name_3, t0.size AS size_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM "media_objects" t0 WHERE t0.id = ?
Parameters:
[
  "01928afe-be72-7891-99cd-a277feabbac6"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Estate\Inventory No errors.
App\Entity\Estate\Estate No errors.
App\Entity\Inventory\InventoryType No errors.
App\Entity\Estate\Inventories\Asset\Assurance No errors.
App\Entity\Estate\Inventories\Asset\LifeAssurance No errors.
App\Entity\Estate\Inventories\Asset\BankChest No errors.
App\Entity\Estate\Inventories\Asset\Organisation No errors.
App\Entity\Estate\Inventories\Asset\Property No errors.
App\Entity\Estate\Inventories\Asset\Vehicle No errors.
App\Entity\Estate\Inventories\Asset\FinancialAccount No errors.
App\Entity\Estate\Inventories\Asset\ArtWork No errors.
App\Entity\Estate\Inventories\Asset\Furniture No errors.
App\Entity\Estate\Inventories\Asset\Jewelry No errors.
App\Entity\Estate\Inventories\Asset\Title No errors.
App\Entity\Estate\Inventories\Liability\HalfCommunityDebt No errors.
App\Entity\Estate\Inventories\Liability\PersonalDebt No errors.
App\Entity\Estate\Inventories\Liability\SuccessionCharge No errors.
App\Entity\Estate\Inventories\Liability\Donation No errors.
App\Entity\Estate\InventoryDocument
  • The association App\Entity\Estate\InventoryDocument#type refers to the inverse side field App\Entity\Inventory\InventoryDocumentType#documents which does not exist.
App\Entity\Inventory\LiabilityType No errors.
App\Entity\Inventory\AssetType No errors.
App\Entity\Inventory\InventoryDocumentType
  • The field App\Entity\Inventory\InventoryDocumentType#inventoryDocument is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Estate\InventoryDocument#type does not contain the required 'mappedBy="inventoryDocument"' attribute.
  • If association App\Entity\Inventory\InventoryDocumentType#inventoryDocument is many-to-one, then the inversed side App\Entity\Estate\InventoryDocument#type has to be one-to-many.
App\Entity\Estate\EstateInventoryType No errors.
App\Entity\Estate\UserInventory No errors.
App\Entity\Other\MediaObject No errors.