Query Metrics
2
Database Queries
2
Different statements
502.09 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
501.89 ms (99.96%) |
1 |
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"
]
|
0.21 ms (0.04%) |
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 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 |
|
App\Entity\IndexEntry | No errors. |