Symfony Profiler

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

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 = 17 ORDER BY t0.created_at DESC;

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

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 = 17 ORDER BY t0.date DESC;

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 = ?

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 = 17;

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

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 = 1 ORDER BY p0_.created_at DESC;

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 = ?

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 = 1;