Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 133
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.capacity AS capacity_3,
  t0.floor AS floor_4,
  t0.name AS name_5,
  t0.building_id AS building_id_6,
  t7.id AS id_8,
  t7.duration_in_minutes AS duration_in_minutes_9,
  t7.length AS length_10,
  t7.tmp_count AS tmp_count_11,
  t7.start_time AS start_time_12,
  t7.end_time AS end_time_13,
  t7.group_ids AS group_ids_14,
  t7.sub_group_ids AS sub_group_ids_15,
  t7.phase_group_ids AS phase_group_ids_16,
  t7.ref_id AS ref_id_17,
  t7.phase_part AS phase_part_18,
  t7.group_id AS group_id_19,
  t7.sub_group_id AS sub_group_id_20,
  t7.lesson_id AS lesson_id_21,
  t7.department_id AS department_id_22,
  t7.teacher_id AS teacher_id_23,
  t7.phase_group_id AS phase_group_id_24,
  t7.room_id AS room_id_25,
  t7.selecting_class_time_id AS selecting_class_time_id_26
FROM
  room t0
  LEFT JOIN class_time t7 ON t7.room_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.id = 3;

SELECT DISTINCT r0_.id AS id_0 FROM room_type r0_ LIMIT 20

[]

SELECT
  DISTINCT r0_.id AS id_0
FROM
  room_type r0_
LIMIT
  20

SELECT DISTINCT r0_.id AS id_0 FROM room_type r0_ LIMIT 20;

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.room_id AS room_id_2 FROM room_type r0_ WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  5
  6
  7
  8
  9
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  25
  26
]

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.room_id AS room_id_2
FROM
  room_type r0_
WHERE
  r0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.room_id AS room_id_2 FROM room_type r0_ WHERE r0_.id IN (5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26);

SELECT count(r0_.id) AS sclr_0 FROM room_type r0_

[]

SELECT
  count(r0_.id) AS sclr_0
FROM
  room_type r0_

SELECT count(r0_.id) AS sclr_0 FROM room_type r0_;