GET https://sih.2vr1.com/clinician/statistics

Query Metrics

50 Database Queries
5 Different statements
21.21 ms Query time
0 Invalid entities
141 Managed entities

Queries

Group similar statements

# Time Info
1 0.30 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.56 ms
SELECT p0_.id AS id_0, p0_.access_code AS access_code_1, p0_.initials AS initials_2, p0_.date_of_birth AS date_of_birth_3, p0_.gender AS gender_4, p0_.email AS email_5, p0_.symptom_onset_date AS symptom_onset_date_6, p0_.is_demo AS is_demo_7, p0_.created_at AS created_at_8, p0_.last_access_at AS last_access_at_9, p0_.intervention_date AS intervention_date_10, p0_.clinician_id AS clinician_id_11 FROM patient p0_ WHERE p0_.clinician_id = ? ORDER BY p0_.created_at DESC
Parameters:
[
  1
]
3 0.36 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  17
]
4 0.29 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  13
]
5 0.23 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  8
]
6 0.20 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  5
]
7 0.20 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  12
]
8 0.52 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  3
]
9 0.29 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  10
]
10 0.25 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  15
]
11 0.23 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  6
]
12 0.21 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  1
]
13 0.21 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  9
]
14 0.21 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  2
]
15 0.21 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  11
]
16 0.30 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  7
]
17 0.22 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  4
]
18 0.21 ms
SELECT t0.id AS id_1, t0.bern_score AS bern_score_2, t0.previous_therapeutics AS previous_therapeutics_3, t0.mri_findings AS mri_findings_4, t0.surgery_dates AS surgery_dates_5, t0.leak_location AS leak_location_6, t0.diagnosis AS diagnosis_7, t0.notes AS notes_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10 FROM clinical_data t0 WHERE t0.patient_id = ?
Parameters:
[
  14
]
19 0.27 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  17
]
20 0.82 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  17
]
21 0.27 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  13
]
22 0.72 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  13
]
23 0.27 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  8
]
24 0.74 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  8
]
25 0.32 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  5
]
26 0.86 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  5
]
27 0.38 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  12
]
28 0.83 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  12
]
29 0.30 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  3
]
30 0.67 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  3
]
31 0.29 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  10
]
32 0.74 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  10
]
33 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  15
]
34 0.67 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  15
]
35 0.27 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  6
]
36 0.66 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  6
]
37 0.27 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  1
]
38 0.71 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  1
]
39 0.30 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  9
]
40 0.78 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  9
]
41 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  2
]
42 0.68 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  2
]
43 0.27 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  11
]
44 0.68 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  11
]
45 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  7
]
46 0.70 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  7
]
47 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  4
]
48 0.67 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  4
]
49 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.created_by_id AS created_by_id_7 FROM treatment t0 WHERE t0.patient_id = ? ORDER BY t0.date DESC
Parameters:
[
  14
]
50 0.67 ms
SELECT t0.id AS id_1, t0.session_type AS session_type_2, t0.session_label AS session_label_3, t0.completed_at AS completed_at_4, t0.created_at AS created_at_5, t0.is_complete AS is_complete_6, t0.eva_quality_of_life AS eva_quality_of_life_7, t0.average_headache_days_per_month AS average_headache_days_per_month_8, t0.headache_intensity_eva AS headache_intensity_eva_9, t0.patient_id AS patient_id_10, t11.id AS id_12, t11.answers AS answers_13, t11.physical_functioning AS physical_functioning_14, t11.role_physical AS role_physical_15, t11.bodily_pain AS bodily_pain_16, t11.general_health AS general_health_17, t11.vitality AS vitality_18, t11.social_functioning AS social_functioning_19, t11.role_emotional AS role_emotional_20, t11.mental_health AS mental_health_21, t11.pcs AS pcs_22, t11.mcs AS mcs_23, t11.session_id AS session_id_24, t25.id AS id_26, t25.answers AS answers_27, t25.total_score AS total_score_28, t25.session_id AS session_id_29, t30.id AS id_31, t30.answers AS answers_32, t30.role_restriction AS role_restriction_33, t30.role_prevention AS role_prevention_34, t30.emotional_function AS emotional_function_35, t30.session_id AS session_id_36, t37.id AS id_38, t37.answers AS answers_39, t37.total_score AS total_score_40, t37.functional_subscale AS functional_subscale_41, t37.emotional_subscale AS emotional_subscale_42, t37.catastrophic_subscale AS catastrophic_subscale_43, t37.session_id AS session_id_44, t45.id AS id_46, t45.answers AS answers_47, t45.total_score AS total_score_48, t45.physical_subscale AS physical_subscale_49, t45.functional_subscale AS functional_subscale_50, t45.emotional_subscale AS emotional_subscale_51, t45.session_id AS session_id_52, t53.id AS id_54, t53.answers AS answers_55, t53.mean_score AS mean_score_56, t53.session_id AS session_id_57, t58.id AS id_59, t58.answers AS answers_60, t58.anxiety_score AS anxiety_score_61, t58.depression_score AS depression_score_62, t58.anxiety_category AS anxiety_category_63, t58.depression_category AS depression_category_64, t58.session_id AS session_id_65, t66.id AS id_67, t66.answers AS answers_68, t66.general_fatigue AS general_fatigue_69, t66.physical_fatigue AS physical_fatigue_70, t66.reduced_activity AS reduced_activity_71, t66.reduced_motivation AS reduced_motivation_72, t66.mental_fatigue AS mental_fatigue_73, t66.session_id AS session_id_74 FROM questionnaire_session t0 LEFT JOIN sf36_response t11 ON t11.session_id = t0.id LEFT JOIN hit6_response t25 ON t25.session_id = t0.id LEFT JOIN msqresponse t30 ON t30.session_id = t0.id LEFT JOIN thiresponse t37 ON t37.session_id = t0.id LEFT JOIN dhiresponse t45 ON t45.session_id = t0.id LEFT JOIN ssq5_response t53 ON t53.session_id = t0.id LEFT JOIN hadsresponse t58 ON t58.session_id = t0.id LEFT JOIN mfi20_response t66 ON t66.session_id = t0.id WHERE t0.patient_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  14
]

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\QuestionnaireSession 31
App\Entity\HIT6Response 30
App\Entity\HADSResponse 30
App\Entity\Treatment 19
App\Entity\Patient 16
App\Entity\ClinicalData 14
App\Entity\User 1