https://beehive.zaw.uni-heidelberg.de/dev/info/78730

Query Metrics

6 Database Queries
6 Different statements
169.34 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.source AS source_1, t0.text AS text_2, t0.position AS position_3, t0.description AS description_4, t0.compilationPage AS compilationPage_5, t0.compilationIndex AS compilationIndex_6, t0.status AS status_7, t0.creator AS creator_8, t0.created AS created_9, t0.sortPage AS sortPage_10, t0.sortSide AS sortSide_11, t0.sortFragment AS sortFragment_12, t0.sortColumn AS sortColumn_13, t0.sortLine AS sortLine_14, t0.sortSystem AS sortSystem_15, t0.sortUser AS sortUser_16, t0.sort AS sort_17, t0.id AS id_18, t0.edition_id AS edition_id_19, t0.compilation_id AS compilation_id_20 FROM correction t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "78730"
]
2 167.80 ms
SELECT l0_.action AS action_0, l0_.logged_at AS logged_at_1, l0_.object_id AS object_id_2, l0_.object_class AS object_class_3, l0_.version AS version_4, l0_.data AS data_5, l0_.username AS username_6, l0_.id AS id_7 FROM log l0_ WHERE l0_.object_class = ? AND l0_.object_id = ? ORDER BY l0_.version DESC
Parameters:
[
  "App\Entity\Correction"
  78730
]
3 0.42 ms
SELECT t0.category AS category_1, t0.description AS description_2, t0.cleared AS cleared_3, t0.id AS id_4, t0.correction_id AS correction_id_5 FROM task t0 WHERE t0.correction_id = ?
Parameters:
[
  78730
]
4 0.13 ms
SELECT t0.sort AS sort_1, t0.title AS title_2, t0.collection AS collection_3, t0.volume AS volume_4, t0.remark AS remark_5, t0.material AS material_6, t0.id AS id_7 FROM edition t0 WHERE t0.id = ?
Parameters:
[
  470
]
5 0.13 ms
SELECT t0.volume AS volume_1, t0.fascicle AS fascicle_2, t0.title AS title_3, t0.collection AS collection_4, t0.item AS item_5, t0.short AS short_6, t0.start AS start_7, t0.end AS end_8, t0.publication AS publication_9, t0.id AS id_10 FROM compilation t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 0.27 ms
SELECT t0.hgv AS hgv_1, t0.tm AS tm_2, t0.ddb AS ddb_3, t0.dclp AS dclp_4, t0.id AS id_5 FROM register t0 INNER JOIN correction_register ON t0.id = correction_register.register_id WHERE correction_register.correction_id = ?
Parameters:
[
  78730
]

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\Correction No errors.
App\Entity\Edition No errors.
App\Entity\Compilation No errors.
App\Entity\Task No errors.
App\Entity\IndexEntry No errors.
App\Entity\Register No errors.
App\Entity\Log No errors.
App\Entity\Docket
  • The association App\Entity\Docket#compilation refers to the inverse side field App\Entity\Compilation#dockets which does not exist.