GET https://dev.fcsprint2.nl/api/datasets/get/nl_NL?p=api%2Fdatasets%2Fget%2Fnl_NL

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.fullname AS fullname_3, t0.azure_id AS azure_id_4, t0.azure_refresh_token AS azure_refresh_token_5, t0.roles AS roles_6, t0.used AS used_7, t0.last_used AS last_used_8, t0.password AS password_9, t0.progress AS progress_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.active AS active_13, t0.exportdata AS exportdata_14, t0.user_id AS user_id_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2015
]
2 3.37 ms
SELECT a0_.id AS id_0, a0_.exercisetitle AS exercisetitle_1 FROM app_exercise a0_ INNER JOIN application a1_ ON a0_.application_id = a1_.id AND (a1_.dirname = ?) WHERE a0_.active = ? AND a0_.language = ? ORDER BY a0_.exercisetitle ASC
Parameters:
[
  "datasets"
  1
  "nl_NL"
]

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