Symfony Profiler

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

Query Metrics

SELECT s0_.id AS id_0, s0_.full_name AS full_name_1, s0_.office AS office_2, s0_.building AS building_3, s0_.description AS description_4, s0_.image AS image_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s1_.id AS id_8, s1_.name AS name_9, p2_.id AS id_10, p2_.name AS name_11, s0_.specialty_id AS specialty_id_12 FROM staff s0_ LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id LEFT JOIN position p2_ ON p2_.id = s3_.position_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC

[
  2
]

SELECT
  s0_.id AS id_0,
  s0_.full_name AS full_name_1,
  s0_.office AS office_2,
  s0_.building AS building_3,
  s0_.description AS description_4,
  s0_.image AS image_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s1_.id AS id_8,
  s1_.name AS name_9,
  p2_.id AS id_10,
  p2_.name AS name_11,
  s0_.specialty_id AS specialty_id_12
FROM
  staff s0_
  LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id
  LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id
  LEFT JOIN position p2_ ON p2_.id = s3_.position_id
WHERE
  s0_.id IN (?)
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.full_name AS full_name_1, s0_.office AS office_2, s0_.building AS building_3, s0_.description AS description_4, s0_.image AS image_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s1_.id AS id_8, s1_.name AS name_9, p2_.id AS id_10, p2_.name AS name_11, s0_.specialty_id AS specialty_id_12 FROM staff s0_ LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id LEFT JOIN position p2_ ON p2_.id = s3_.position_id WHERE s0_.id IN (2) ORDER BY s0_.id ASC;

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM staff s0_ LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id LEFT JOIN position p2_ ON p2_.id = s3_.position_id ORDER BY s0_.id ASC LIMIT 25

[]

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  staff s0_
  LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id
  LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id
  LEFT JOIN position p2_ ON p2_.id = s3_.position_id
ORDER BY
  s0_.id ASC
LIMIT
  25

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM staff s0_ LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id LEFT JOIN position p2_ ON p2_.id = s3_.position_id ORDER BY s0_.id ASC LIMIT 25;