https://beehive.zaw.uni-heidelberg.de/dev/hgv/23355

Query Metrics

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

Queries

Group similar statements

# Time Info
1 501.89 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, r1_.hgv AS hgv_18, r1_.tm AS tm_19, r1_.ddb AS ddb_20, r1_.dclp AS dclp_21, r1_.id AS id_22, t2_.category AS category_23, t2_.description AS description_24, t2_.cleared AS cleared_25, t2_.id AS id_26, e3_.sort AS sort_27, e3_.title AS title_28, e3_.collection AS collection_29, e3_.volume AS volume_30, e3_.remark AS remark_31, e3_.material AS material_32, e3_.id AS id_33, d4_.text AS text_34, d4_.position AS position_35, d4_.info AS info_36, d4_.type AS type_37, d4_.sort AS sort_38, d4_.compilationPage AS compilationPage_39, d4_.id AS id_40, c0_.edition_id AS edition_id_41, c0_.compilation_id AS compilation_id_42, t2_.correction_id AS correction_id_43, d4_.compilation_id AS compilation_id_44 FROM correction c0_ LEFT JOIN correction_register c5_ ON c0_.id = c5_.correction_id LEFT JOIN register r1_ ON r1_.id = c5_.register_id LEFT JOIN task t2_ ON c0_.id = t2_.correction_id INNER JOIN edition e3_ ON c0_.edition_id = e3_.id INNER JOIN compilation c6_ ON c0_.compilation_id = c6_.id LEFT JOIN edition_docket e7_ ON e3_.id = e7_.edition_id LEFT JOIN docket d4_ ON d4_.id = e7_.docket_id WHERE r1_.hgv = ? ORDER BY c0_.sort ASC
Parameters:
[
  "23355"
]
2 0.21 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 ORDER BY t0.collection ASC, t0.volume ASC
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.

Entities Mapping

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