https://beehive.zaw.uni-heidelberg.de/dev/report/overview/3

Query Metrics

2 Database Queries
2 Different statements
5641.90 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 5641.49 ms
SELECT c0_.source AS source_0, c0_.text AS text_1, c0_.position AS position_2, c0_.description AS description_3, c0_.compilationPage AS compilationPage_4, c0_.compilationIndex AS compilationIndex_5, c0_.status AS status_6, c0_.creator AS creator_7, c0_.created AS created_8, c0_.sortPage AS sortPage_9, c0_.sortSide AS sortSide_10, c0_.sortFragment AS sortFragment_11, c0_.sortColumn AS sortColumn_12, c0_.sortLine AS sortLine_13, c0_.sortSystem AS sortSystem_14, c0_.sortUser AS sortUser_15, c0_.sort AS sort_16, c0_.id AS id_17, t1_.category AS category_18, t1_.description AS description_19, t1_.cleared AS cleared_20, t1_.id AS id_21, e2_.sort AS sort_22, e2_.title AS title_23, e2_.collection AS collection_24, e2_.volume AS volume_25, e2_.remark AS remark_26, e2_.material AS material_27, e2_.id AS id_28, c0_.edition_id AS edition_id_29, c0_.compilation_id AS compilation_id_30, t1_.correction_id AS correction_id_31 FROM correction c0_ LEFT JOIN task t1_ ON c0_.id = t1_.correction_id INNER JOIN edition e2_ ON c0_.edition_id = e2_.id INNER JOIN compilation c3_ ON c0_.compilation_id = c3_.id WHERE c3_.volume = ? ORDER BY e2_.sort ASC, c0_.sort ASC
Parameters:
[
  "3"
]
2 0.41 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
]

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\Task No errors.
App\Entity\Edition No errors.
App\Entity\Compilation No errors.
App\Entity\IndexEntry No errors.
App\Entity\Register 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.