Query Metrics
6
Database Queries
6
Different statements
187.70 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
185.65 ms (98.91%) |
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:
[ "App\Entity\Correction" 89545 ] |
0.68 ms (0.36%) |
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:
[
"89545"
]
|
0.50 ms (0.27%) |
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:
[
89545
]
|
0.44 ms (0.24%) |
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:
[
89545
]
|
0.27 ms (0.14%) |
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:
[
423
]
|
0.15 ms (0.08%) |
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:
[
9
]
|
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 |
|