Query Metrics
6
Database Queries
6
Different statements
495.42 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
331.95 ms (67.00%) |
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" 30965 ] |
86.99 ms (17.56%) |
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:
[
30965
]
|
74.97 ms (15.13%) |
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:
[
"30965"
]
|
0.58 ms (0.12%) |
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:
[
30965
]
|
0.48 ms (0.10%) |
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:
[
6
]
|
0.45 ms (0.09%) |
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:
[
650
]
|
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 |
|