Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = ?

[
  8
]

SELECT
  t0.id AS id_1,
  t0.birth_date AS birth_date_2,
  t0.gender AS gender_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.created_at AS created_at_7,
  t0.user_id AS user_id_8
FROM
  patient t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = 8;

SELECT d0_.id AS id_0, d0_.first_name AS first_name_1, d0_.last_name AS last_name_2, d0_.phone AS phone_3, d0_.bio AS bio_4, d0_.photo_filename AS photo_filename_5, d0_.consultation_price AS consultation_price_6, d0_.is_verified AS is_verified_7, d0_.created_at AS created_at_8, u1_.id AS id_9, u1_.email AS email_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.phone AS phone_13, u1_.roles AS roles_14, u1_.password AS password_15, u1_.is_active AS is_active_16, u1_.created_at AS created_at_17, u1_.updated_at AS updated_at_18, s2_.id AS id_19, s2_.name AS name_20, s2_.slug AS slug_21, s2_.description AS description_22, m3_.id AS id_23, m3_.name AS name_24, m3_.slug AS slug_25, m3_.address AS address_26, m3_.city AS city_27, m3_.phone AS phone_28, m3_.email AS email_29, m3_.description AS description_30, d0_.user_id AS user_id_31, d0_.specialty_id AS specialty_id_32, d0_.medical_center_id AS medical_center_id_33 FROM doctor d0_ INNER JOIN `user` u1_ ON d0_.user_id = u1_.id INNER JOIN specialty s2_ ON d0_.specialty_id = s2_.id INNER JOIN medical_center m3_ ON d0_.medical_center_id = m3_.id WHERE d0_.is_verified = ? ORDER BY d0_.last_name ASC, d0_.first_name ASC

[
  1
]

SELECT
  d0_.id AS id_0,
  d0_.first_name AS first_name_1,
  d0_.last_name AS last_name_2,
  d0_.phone AS phone_3,
  d0_.bio AS bio_4,
  d0_.photo_filename AS photo_filename_5,
  d0_.consultation_price AS consultation_price_6,
  d0_.is_verified AS is_verified_7,
  d0_.created_at AS created_at_8,
  u1_.id AS id_9,
  u1_.email AS email_10,
  u1_.first_name AS first_name_11,
  u1_.last_name AS last_name_12,
  u1_.phone AS phone_13,
  u1_.roles AS roles_14,
  u1_.password AS password_15,
  u1_.is_active AS is_active_16,
  u1_.created_at AS created_at_17,
  u1_.updated_at AS updated_at_18,
  s2_.id AS id_19,
  s2_.name AS name_20,
  s2_.slug AS slug_21,
  s2_.description AS description_22,
  m3_.id AS id_23,
  m3_.name AS name_24,
  m3_.slug AS slug_25,
  m3_.address AS address_26,
  m3_.city AS city_27,
  m3_.phone AS phone_28,
  m3_.email AS email_29,
  m3_.description AS description_30,
  d0_.user_id AS user_id_31,
  d0_.specialty_id AS specialty_id_32,
  d0_.medical_center_id AS medical_center_id_33
FROM
  doctor d0_
  INNER JOIN `user` u1_ ON d0_.user_id = u1_.id
  INNER JOIN specialty s2_ ON d0_.specialty_id = s2_.id
  INNER JOIN medical_center m3_ ON d0_.medical_center_id = m3_.id
WHERE
  d0_.is_verified = ?
ORDER BY
  d0_.last_name ASC,
  d0_.first_name ASC

SELECT d0_.id AS id_0, d0_.first_name AS first_name_1, d0_.last_name AS last_name_2, d0_.phone AS phone_3, d0_.bio AS bio_4, d0_.photo_filename AS photo_filename_5, d0_.consultation_price AS consultation_price_6, d0_.is_verified AS is_verified_7, d0_.created_at AS created_at_8, u1_.id AS id_9, u1_.email AS email_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.phone AS phone_13, u1_.roles AS roles_14, u1_.password AS password_15, u1_.is_active AS is_active_16, u1_.created_at AS created_at_17, u1_.updated_at AS updated_at_18, s2_.id AS id_19, s2_.name AS name_20, s2_.slug AS slug_21, s2_.description AS description_22, m3_.id AS id_23, m3_.name AS name_24, m3_.slug AS slug_25, m3_.address AS address_26, m3_.city AS city_27, m3_.phone AS phone_28, m3_.email AS email_29, m3_.description AS description_30, d0_.user_id AS user_id_31, d0_.specialty_id AS specialty_id_32, d0_.medical_center_id AS medical_center_id_33 FROM doctor d0_ INNER JOIN `user` u1_ ON d0_.user_id = u1_.id INNER JOIN specialty s2_ ON d0_.specialty_id = s2_.id INNER JOIN medical_center m3_ ON d0_.medical_center_id = m3_.id WHERE d0_.is_verified = 1 ORDER BY d0_.last_name ASC, d0_.first_name ASC;

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.birth_date AS birth_date_13, t11.gender AS gender_14, t11.address AS address_15, t11.city AS city_16, t11.phone AS phone_17, t11.created_at AS created_at_18, t11.user_id AS user_id_19, t20.id AS id_21, t20.first_name AS first_name_22, t20.last_name AS last_name_23, t20.phone AS phone_24, t20.bio AS bio_25, t20.photo_filename AS photo_filename_26, t20.consultation_price AS consultation_price_27, t20.is_verified AS is_verified_28, t20.created_at AS created_at_29, t20.user_id AS user_id_30, t20.specialty_id AS specialty_id_31, t20.medical_center_id AS medical_center_id_32 FROM `user` t0 LEFT JOIN patient t11 ON t11.user_id = t0.id LEFT JOIN doctor t20 ON t20.user_id = t0.id WHERE t0.id = ?

[
  9
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.phone AS phone_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.birth_date AS birth_date_13,
  t11.gender AS gender_14,
  t11.address AS address_15,
  t11.city AS city_16,
  t11.phone AS phone_17,
  t11.created_at AS created_at_18,
  t11.user_id AS user_id_19,
  t20.id AS id_21,
  t20.first_name AS first_name_22,
  t20.last_name AS last_name_23,
  t20.phone AS phone_24,
  t20.bio AS bio_25,
  t20.photo_filename AS photo_filename_26,
  t20.consultation_price AS consultation_price_27,
  t20.is_verified AS is_verified_28,
  t20.created_at AS created_at_29,
  t20.user_id AS user_id_30,
  t20.specialty_id AS specialty_id_31,
  t20.medical_center_id AS medical_center_id_32
FROM
  `user` t0
  LEFT JOIN patient t11 ON t11.user_id = t0.id
  LEFT JOIN doctor t20 ON t20.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.birth_date AS birth_date_13, t11.gender AS gender_14, t11.address AS address_15, t11.city AS city_16, t11.phone AS phone_17, t11.created_at AS created_at_18, t11.user_id AS user_id_19, t20.id AS id_21, t20.first_name AS first_name_22, t20.last_name AS last_name_23, t20.phone AS phone_24, t20.bio AS bio_25, t20.photo_filename AS photo_filename_26, t20.consultation_price AS consultation_price_27, t20.is_verified AS is_verified_28, t20.created_at AS created_at_29, t20.user_id AS user_id_30, t20.specialty_id AS specialty_id_31, t20.medical_center_id AS medical_center_id_32 FROM `user` t0 LEFT JOIN patient t11 ON t11.user_id = t0.id LEFT JOIN doctor t20 ON t20.user_id = t0.id WHERE t0.id = 9;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM specialty t0 ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4
FROM
  specialty t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM specialty t0 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.description AS description_8 FROM medical_center t0 ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.description AS description_8
FROM
  medical_center t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.description AS description_8 FROM medical_center t0 ORDER BY t0.name ASC;