GET http://beta.cea-cct.iasgroup.io/api/specifications?_limit=25&states=draft%2Cpublished

Query Metrics

8 Database Queries
8 Different statements
3.34 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.56 ms
SELECT t0.id AS id_1, t0.fullname AS fullname_2, t0.role AS role_3, t0.username AS username_4 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "TTT"
]
2 0.56 ms
SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.title AS title_2, s0_.state AS state_3, s0_.subject AS subject_4, s0_.is_available_to_all AS is_available_to_all_5, s0_.lock_renewed_at AS lock_renewed_at_6, s0_.updated_at AS updated_at_7, s0_.updated_by AS updated_by_8, s0_.project_id AS project_id_9, s0_.document_model_id AS document_model_id_10, s0_.prestation_type_id AS prestation_type_id_11, s0_.lock_user_id AS lock_user_id_12 FROM specification s0_ WHERE s0_.state IN (?, ?)
Parameters:
[
  "draft"
  "published"
]
3 0.40 ms
SELECT t0.id AS id_1, t0.level AS level_2, t0.specification_id AS specification_id_3, t0.user_id AS user_id_4 FROM specification_access_user t0 WHERE t0.specification_id = ?
Parameters:
[
  1
]
4 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived_at AS archived_at_3 FROM project t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived_at AS archived_at_3 FROM document_model t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived_at AS archived_at_3 FROM prestation_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived_at AS archived_at_3, t0.parent_id AS parent_id_4 FROM unit t0 INNER JOIN specification_unit ON t0.id = specification_unit.unit_id WHERE specification_unit.specification_id = ?
Parameters:
[
  1
]
8 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived_at AS archived_at_3 FROM center t0 INNER JOIN specification_center ON t0.id = specification_center.center_id WHERE specification_center.specification_id = ?
Parameters:
[
  1
]

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.