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

Query Metrics

6 Database Queries
6 Different statements
176.80 ms Query time
1 Invalid entities
  • Grouped Statements
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Show all queries

Time Count Info
174.62 ms
(98.77%)
1
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:
0 of 0
[ "App\Entity\Correction" 42084 ]
0.71 ms
(0.40%)
1
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:
0 of 0
[ "42084" ]
0.54 ms
(0.31%)
1
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:
0 of 0
[ 42084 ]
0.48 ms
(0.27%)
1
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:
0 of 0
[ 42084 ]
0.23 ms
(0.13%)
1
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:
0 of 0
[ 199 ]
0.21 ms
(0.12%)
1
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:
0 of 0
[ 6 ]