https://openrpg.ru/

Query Metrics

5 Database Queries
2 Different statements
2.77 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.04 ms
SELECT t0.id AS id_1, t0.promts AS promts_2, t0.is_base AS is_base_3, t0.default_location_id AS default_location_id_4, t0.name AS name_5, t0.save_version AS save_version_6, t0.description AS description_7, t0.background AS background_8, t0.is_public AS is_public_9, t0.settings AS settings_10, t0.created_date AS created_date_11, t0.edited_date AS edited_date_12, t0.published_date AS published_date_13, t0.created_by AS created_by_14, t0.badges AS badges_15 FROM world t0
Parameters:
[]
2 0.90 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.hidden_description AS hidden_description_5, t0.glued_to AS glued_to_6, t0.type AS type_7, t0.world_id AS world_id_8 FROM locations t0 WHERE t0.world_id = ?
Parameters:
[
  "0a92ca98-143a-4f93-80ac-837f059c04fb"
]
3 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.hidden_description AS hidden_description_5, t0.glued_to AS glued_to_6, t0.type AS type_7, t0.world_id AS world_id_8 FROM locations t0 WHERE t0.world_id = ?
Parameters:
[
  "1f08324f-a43c-6512-ba48-bdbb9e4425d7"
]
4 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.hidden_description AS hidden_description_5, t0.glued_to AS glued_to_6, t0.type AS type_7, t0.world_id AS world_id_8 FROM locations t0 WHERE t0.world_id = ?
Parameters:
[
  "28f0c28e-4793-46b0-ad02-c07c73859fbd"
]
5 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.hidden_description AS hidden_description_5, t0.glued_to AS glued_to_6, t0.type AS type_7, t0.world_id AS world_id_8 FROM locations t0 WHERE t0.world_id = ?
Parameters:
[
  "e0a8d052-1420-414f-9f37-ad3f81bddfd8"
]

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\World
  • The field App\Entity\World#persons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Person\Person#world does not contain the required 'inversedBy="persons"' attribute.
App\Entity\Person\Person No errors.
App\Entity\Location\Location No errors.
App\Entity\Tag No errors.