GET https://lafiaa.pro/medecins/5/rendez-vous/confirmation?date=2026-10-14&time=10%3A30

Query Metrics

5 Database Queries
5 Different statements
1.78 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.44 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.bio AS bio_5, t0.photo_filename AS photo_filename_6, t0.consultation_price AS consultation_price_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.user_id AS user_id_10, t0.specialty_id AS specialty_id_11, t0.medical_center_id AS medical_center_id_12 FROM doctor t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
2 0.45 ms
SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = ? AND a0_.day_of_week = ? AND a0_.is_active = ? ORDER BY a0_.start_time ASC
Parameters:
[
  5
  3
  1
]
3 0.32 ms
SELECT t0.id AS id_1, t0.appointment_date AS appointment_date_2, t0.appointment_time AS appointment_time_3, t0.status AS status_4, t0.reason AS reason_5, t0.created_at AS created_at_6, t0.patient_id AS patient_id_7, t0.doctor_id AS doctor_id_8 FROM appointment t0 WHERE t0.doctor_id = ? AND t0.appointment_date = ?
Parameters:
[
  5
  "2026-10-14"
]
4 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM specialty t0 WHERE t0.id = ?
Parameters:
[
  12
]
5 0.29 ms
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 WHERE t0.id = ?
Parameters:
[
  5
]

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\Availability 2
App\Entity\Doctor 1
App\Entity\User 1
App\Entity\Specialty 1
App\Entity\MedicalCenter 1

Entities Mapping

Class Mapping errors
App\Entity\Doctor No errors.
App\Entity\User No errors.
App\Entity\Specialty No errors.
App\Entity\MedicalCenter No errors.
App\Entity\Availability No errors.
App\Entity\Appointment No errors.
App\Entity\Patient No errors.