GET https://dev.fcsprint2.nl/api/appexercise/get/5119?p=api%2Fappexercise%2Fget%2F5119

Query Metrics

5 Database Queries
5 Different statements
10.89 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
9.77 ms
(89.77%)
1
"COMMIT"
Parameters:
[]
0.40 ms
(3.66%)
1
SELECT a0_.created_at AS created_at_0, a0_.updated_at AS updated_at_1, a0_.active AS active_2, a0_.exportdata AS exportdata_3, a0_.id AS id_4, a0_.uuid AS uuid_5, a0_.old_id AS old_id_6, a0_.applicationname AS applicationname_7, a0_.language AS language_8, a0_.exercisetitle AS exercisetitle_9, a0_.main_object AS main_object_10, a0_.requestsfrom AS requestsfrom_11, a0_.user_id AS user_id_12, a0_.application_id AS application_id_13, a0_.dataset AS dataset_14 FROM app_exercise a0_ WHERE a0_.id = ?
Parameters:
[
  "5119"
]
0.30 ms
(2.75%)
1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.app_exercise_id AS app_exercise_id_3 FROM app_exercise_amount t0 WHERE t0.app_exercise_id = ?
Parameters:
[
  5119
]
0.26 ms
(2.42%)
1
UPDATE app_exercise_amount SET amount = ? WHERE id = ?
Parameters:
[
  43
  3224
]
0.15 ms
(1.41%)
1
"START TRANSACTION"
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\AppExercise 1
App\Entity\User 1
App\Entity\AppExerciseRequestAmount 1
App\Entity\Application 1

Entities Mapping

Class Mapping errors
App\Entity\TimeStamped No errors.
App\Entity\AppExercise No errors.
App\Entity\User No errors.
App\Entity\Application No errors.
App\Entity\AppExerciseRequestAmount No errors.
App\Entity\AppExerciseData No errors.
App\Entity\Rating No errors.