GET http://gilbertdupont.v2.celaneo.com/corporate-finance

Query Metrics

2 Database Queries
2 Different statements
18.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
17.78 ms
(97.03%)
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.54 ms
(2.97%)
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.