Query Metrics
2
Database Queries
2
Different statements
18.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
17.83 ms (97.30%) |
1 |
SELECT d0_.id AS id_0, d0_.value AS value_1, d0_.obsolete AS obsolete_2, d0_.data_item_id AS data_item_id_3, d0_.data_column_id AS data_column_id_4 FROM data_item_column d0_ INNER JOIN data_item_column d1_ ON (d0_.data_item_id = d1_.data_item_id) INNER JOIN data_item_column d2_ ON (d0_.data_item_id = d2_.data_item_id) WHERE d0_.data_column_id = ? AND d1_.data_column_id = ? AND d2_.data_column_id = ? AND d2_.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d0_.value = ? AND d1_.value >= ? GROUP BY d0_.data_item_id ORDER BY d1_.value DESC
Parameters:
[ 141 134 140 1 13 25 28 35 38 52 60 62 64 67 72 73 74 75 84 "1" 1788307200 ]
|
||||||||||||||||||||||||||||||||
|
0.49 ms (2.70%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.csv_header AS csv_header_3, d0_.mandatory AS mandatory_4, d0_.field_type AS field_type_5, d0_.log_enabled AS log_enabled_6, d0_.internal_key AS internal_key_7, d0_.data_type_id AS data_type_id_8 FROM data_column d0_ WHERE d0_.data_type_id = ? AND d0_.internal_key IN (?, ?, ?, ?, ?, ?)
Parameters:
[ "3" "date_archivage" "code_isin" "langue" "id_doctype" "type_document" "titre_document" ]
|
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\DataColumn | No errors. |
| App\Entity\DataType | No errors. |
| App\Entity\DataItemColumn | No errors. |
| App\Entity\DataItem | No errors. |