GET https://dev.fcsprint2.nl/api/rating/get?appname=sums_v2&exerciseid=1361&language=nl_NL&p=api%2Frating%2Fget

Query Metrics

1 Database Queries
1 Different statements
2.12 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 2.12 ms
SELECT r0_.id AS id_0, r0_.language AS language_1, r0_.amount AS amount_2, r1_.id AS id_3, r1_.line_type AS line_type_4, r1_.line_condition AS line_condition_5, r1_.formula AS formula_6, a2_.id AS id_7 FROM rating r0_ LEFT JOIN rating_line r1_ ON r0_.id = r1_.rating_id LEFT JOIN application a3_ ON r0_.application_id = a3_.id AND (a3_.dirname = ?) LEFT JOIN app_exercise a2_ ON r0_.app_exercise_id = a2_.id WHERE a3_.dirname = ? AND (r0_.language = ? OR r0_.language = ?)
Parameters:
[
  "sums_v2"
  "sums_v2"
  "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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
App\Entity\TimeStamped No errors.
App\Entity\Rating No errors.
App\Entity\RatingLine No errors.
App\Entity\Application No errors.
App\Entity\AppExercise No errors.