Query Metrics
50
Database Queries
5
Different statements
21.21 ms
Query time
0
Invalid entities
141
Managed entities
Queries
| #▲ | 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 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Patient | No errors. |
| App\Entity\QuestionnaireSession | No errors. |
| App\Entity\DailySymptom | No errors. |
| App\Entity\Treatment | No errors. |
| App\Entity\ClinicalData | No errors. |
| App\Entity\SF36Response | No errors. |
| App\Entity\HIT6Response | No errors. |
| App\Entity\MSQResponse | No errors. |
| App\Entity\THIResponse | No errors. |
| App\Entity\DHIResponse | No errors. |
| App\Entity\SSQ5Response | No errors. |
| App\Entity\HADSResponse | No errors. |
| App\Entity\MFI20Response | No errors. |