GET https://evalcomp.dataccessor.com/admin/grid/8/situation/26/assignments/groups/2/edit

Query Metrics

7 Database Queries
7 Different statements
12.86 ms Query time
0 Invalid entities
299 Managed entities

Queries

Group similar statements

# Time Info
1 2.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.referential_id AS referential_id_3, t0.promotion_id AS promotion_id_4 FROM grid t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
2 0.95 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.id = ?
Parameters:
[
  "26"
]
3 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.situation_id AS situation_id_3 FROM situation_group t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
4 2.38 ms
SELECT s0_.id AS id_0, s0_.firstname AS firstname_1, s0_.lastname AS lastname_2, s0_.user_id AS user_id_3 FROM student s0_ INNER JOIN promotion_student p2_ ON s0_.id = p2_.student_id INNER JOIN promotion p1_ ON p1_.id = p2_.promotion_id WHERE p1_.id = ? ORDER BY s0_.lastname ASC
Parameters:
[
  10
]
5 0.93 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.user_id AS user_id_4 FROM student t0 INNER JOIN situation_group_student ON t0.id = situation_group_student.student_id WHERE situation_group_student.situation_group_id = ? ORDER BY t0.lastname ASC
Parameters:
[
  2
]
6 4.55 ms
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "admin_situation_group_edit"
  1
]
7 1.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM promotion t0 WHERE t0.id = ?
Parameters:
[
  10
]

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\Student 147
App\Entity\User 147
App\Entity\Grid 1
App\Entity\Referential 1
App\Entity\Promotion 1
App\Entity\Situation 1
App\Entity\SituationGroup 1

Entities Mapping

Class Mapping errors
App\Entity\Grid No errors.
App\Entity\Referential No errors.
App\Entity\Promotion No errors.
App\Entity\Situation No errors.
App\Entity\SituationSkill No errors.
App\Entity\Professor No errors.
App\Entity\Tutor No errors.
App\Entity\SituationGroup No errors.
App\Entity\Student No errors.
App\Entity\User No errors.
App\Entity\PageHelp No errors.