Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.lastname AS lastname_6,
  t0.phone AS phone_7,
  t0.address AS address_8,
  t0.created_at AS created_at_9,
  t0.birth_date AS birth_date_10,
  t0.entity_type AS entity_type_11,
  t0.reset_token AS reset_token_12,
  t0.token_expires_at AS token_expires_at_13,
  t0.use_temporary_email AS use_temporary_email_14,
  t0.notify_clinica AS notify_clinica_15,
  t0.clinic_notification_email AS clinic_notification_email_16
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.phone AS phone_7, t0.address AS address_8, t0.created_at AS created_at_9, t0.birth_date AS birth_date_10, t0.entity_type AS entity_type_11, t0.reset_token AS reset_token_12, t0.token_expires_at AS token_expires_at_13, t0.use_temporary_email AS use_temporary_email_14, t0.notify_clinica AS notify_clinica_15, t0.clinic_notification_email AS clinic_notification_email_16 FROM user t0 WHERE t0.id = 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.name AS name_4,
  u0_.lastname AS lastname_5,
  u0_.phone AS phone_6,
  u0_.address AS address_7,
  u0_.created_at AS created_at_8,
  u0_.birth_date AS birth_date_9,
  u0_.entity_type AS entity_type_10,
  u0_.reset_token AS reset_token_11,
  u0_.token_expires_at AS token_expires_at_12,
  u0_.use_temporary_email AS use_temporary_email_13,
  u0_.notify_clinica AS notify_clinica_14,
  u0_.clinic_notification_email AS clinic_notification_email_15
FROM
  user u0_
WHERE
  u0_.roles LIKE ?
  OR u0_.roles LIKE ?
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.lastname AS lastname_5, u0_.phone AS phone_6, u0_.address AS address_7, u0_.created_at AS created_at_8, u0_.birth_date AS birth_date_9, u0_.entity_type AS entity_type_10, u0_.reset_token AS reset_token_11, u0_.token_expires_at AS token_expires_at_12, u0_.use_temporary_email AS use_temporary_email_13, u0_.notify_clinica AS notify_clinica_14, u0_.clinic_notification_email AS clinic_notification_email_15 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_PROVIDER%' OR u0_.roles LIKE '%ROLE_ADMIN%' ORDER BY u0_.name ASC;

SELECT
  DISTINCT a0_.status AS status_0
FROM
  appointments a0_
WHERE
  a0_.status IS NOT NULL
ORDER BY
  a0_.status ASC

SELECT DISTINCT a0_.status AS status_0 FROM appointments a0_ WHERE a0_.status IS NOT NULL ORDER BY a0_.status ASC;

SELECT
  a0_.id AS id_0,
  a0_.status AS status_1,
  a0_.notes AS notes_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4,
  a0_.cancel_token AS cancel_token_5,
  a0_.reprogram_token AS reprogram_token_6,
  a0_.tipo_estudio AS tipo_estudio_7,
  a0_.payment_method AS payment_method_8,
  a0_.payment_status AS payment_status_9,
  a0_.monto_imaging_pro AS monto_imaging_pro_10,
  h1_.id AS id_11,
  h1_.fecha AS fecha_12,
  h1_.hora AS hora_13,
  h1_.estado AS estado_14,
  u2_.id AS id_15,
  u2_.email AS email_16,
  u2_.roles AS roles_17,
  u2_.password AS password_18,
  u2_.name AS name_19,
  u2_.lastname AS lastname_20,
  u2_.phone AS phone_21,
  u2_.address AS address_22,
  u2_.created_at AS created_at_23,
  u2_.birth_date AS birth_date_24,
  u2_.entity_type AS entity_type_25,
  u2_.reset_token AS reset_token_26,
  u2_.token_expires_at AS token_expires_at_27,
  u2_.use_temporary_email AS use_temporary_email_28,
  u2_.notify_clinica AS notify_clinica_29,
  u2_.clinic_notification_email AS clinic_notification_email_30,
  u3_.id AS id_31,
  u3_.email AS email_32,
  u3_.roles AS roles_33,
  u3_.password AS password_34,
  u3_.name AS name_35,
  u3_.lastname AS lastname_36,
  u3_.phone AS phone_37,
  u3_.address AS address_38,
  u3_.created_at AS created_at_39,
  u3_.birth_date AS birth_date_40,
  u3_.entity_type AS entity_type_41,
  u3_.reset_token AS reset_token_42,
  u3_.token_expires_at AS token_expires_at_43,
  u3_.use_temporary_email AS use_temporary_email_44,
  u3_.notify_clinica AS notify_clinica_45,
  u3_.clinic_notification_email AS clinic_notification_email_46,
  a0_.patient_id AS patient_id_47,
  a0_.provider_id AS provider_id_48,
  a0_.horario_id AS horario_id_49
FROM
  appointments a0_
  LEFT JOIN horario h1_ ON a0_.horario_id = h1_.id
  LEFT JOIN user u2_ ON a0_.patient_id = u2_.id
  LEFT JOIN user u3_ ON a0_.provider_id = u3_.id
WHERE
  a0_.status = ?
ORDER BY
  h1_.fecha DESC,
  h1_.hora DESC

SELECT a0_.id AS id_0, a0_.status AS status_1, a0_.notes AS notes_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.cancel_token AS cancel_token_5, a0_.reprogram_token AS reprogram_token_6, a0_.tipo_estudio AS tipo_estudio_7, a0_.payment_method AS payment_method_8, a0_.payment_status AS payment_status_9, a0_.monto_imaging_pro AS monto_imaging_pro_10, h1_.id AS id_11, h1_.fecha AS fecha_12, h1_.hora AS hora_13, h1_.estado AS estado_14, u2_.id AS id_15, u2_.email AS email_16, u2_.roles AS roles_17, u2_.password AS password_18, u2_.name AS name_19, u2_.lastname AS lastname_20, u2_.phone AS phone_21, u2_.address AS address_22, u2_.created_at AS created_at_23, u2_.birth_date AS birth_date_24, u2_.entity_type AS entity_type_25, u2_.reset_token AS reset_token_26, u2_.token_expires_at AS token_expires_at_27, u2_.use_temporary_email AS use_temporary_email_28, u2_.notify_clinica AS notify_clinica_29, u2_.clinic_notification_email AS clinic_notification_email_30, u3_.id AS id_31, u3_.email AS email_32, u3_.roles AS roles_33, u3_.password AS password_34, u3_.name AS name_35, u3_.lastname AS lastname_36, u3_.phone AS phone_37, u3_.address AS address_38, u3_.created_at AS created_at_39, u3_.birth_date AS birth_date_40, u3_.entity_type AS entity_type_41, u3_.reset_token AS reset_token_42, u3_.token_expires_at AS token_expires_at_43, u3_.use_temporary_email AS use_temporary_email_44, u3_.notify_clinica AS notify_clinica_45, u3_.clinic_notification_email AS clinic_notification_email_46, a0_.patient_id AS patient_id_47, a0_.provider_id AS provider_id_48, a0_.horario_id AS horario_id_49 FROM appointments a0_ LEFT JOIN horario h1_ ON a0_.horario_id = h1_.id LEFT JOIN user u2_ ON a0_.patient_id = u2_.id LEFT JOIN user u3_ ON a0_.provider_id = u3_.id WHERE a0_.status = 'confirmada' ORDER BY h1_.fecha DESC, h1_.hora DESC;