GET https://sih.2vr1.com/clinician/patient/13/clinical-data

Query Metrics

2 Database Queries
2 Different statements
0.77 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.29 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.47 ms
SELECT t0.id AS id_1, t0.access_code AS access_code_2, t0.initials AS initials_3, t0.date_of_birth AS date_of_birth_4, t0.gender AS gender_5, t0.email AS email_6, t0.symptom_onset_date AS symptom_onset_date_7, t0.is_demo AS is_demo_8, t0.created_at AS created_at_9, t0.last_access_at AS last_access_at_10, t0.intervention_date AS intervention_date_11, t0.clinician_id AS clinician_id_12, t13.id AS id_14, t13.bern_score AS bern_score_15, t13.previous_therapeutics AS previous_therapeutics_16, t13.mri_findings AS mri_findings_17, t13.surgery_dates AS surgery_dates_18, t13.leak_location AS leak_location_19, t13.diagnosis AS diagnosis_20, t13.notes AS notes_21, t13.updated_at AS updated_at_22, t13.patient_id AS patient_id_23 FROM patient t0 LEFT JOIN clinical_data t13 ON t13.patient_id = t0.id WHERE t0.id = ?
Parameters:
[
  "13"
]

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\User 1
App\Entity\Patient 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Patient No errors.
App\Entity\ClinicalData No errors.
App\Entity\QuestionnaireSession No errors.
App\Entity\DailySymptom No errors.
App\Entity\Treatment No errors.