Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.mrd_id AS mrd_id_1,
          c0_.patient_category AS patient_category_2,
          c0_.family_history AS family_history_3,
          c0_.medical_history AS medical_history_4,
          c0_.medicine_history AS medicine_history_5,
          c0_.abha_number AS abha_number_6,
          c0_.current_disease_history AS current_disease_history_7,
          c0_.is_lab AS is_lab_8,
          c0_.confirmed_diagnosis AS confirmed_diagnosis_9,
          c0_.temparature AS temparature_10,
          c0_.cns AS cns_11,
          c0_.endrocine AS endrocine_12,
          c0_.excretory AS excretory_13,
          c0_.pulse AS pulse_14,
          c0_.bp_upper AS bp_upper_15,
          c0_.bp_lower AS bp_lower_16,
          c0_.respiration AS respiration_17,
          c0_.auscultation AS auscultation_18,
          c0_.local_examination AS local_examination_19,
          c0_.is_medicine AS is_medicine_20,
          c0_.is_ward AS is_ward_21,
          c0_.follow_up_date AS follow_up_date_22,
          c0_.is_pm_done AS is_pm_done_23,
          c0_.is_death_cert_gen AS is_death_cert_gen_24,
          c0_.is_birth_cert_gen AS is_birth_cert_gen_25,
          c0_.is_closed AS is_closed_26,
          c0_.is_reopened AS is_reopened_27,
          c0_.is_opinion AS is_opinion_28,
          c0_.is_referral AS is_referral_29,
          c0_.emergency_staff_notes AS emergency_staff_notes_30,
          c0_.pharmacy_staff_notes AS pharmacy_staff_notes_31,
          c0_.ward_staff_notes AS ward_staff_notes_32,
          c0_.pharmacy_patient_notes AS pharmacy_patient_notes_33,
          c0_.closure_reason AS closure_reason_34,
          c0_.created_at AS created_at_35,
          c0_.updated_at AS updated_at_36,
          c0_.lab_test_status AS lab_test_status_37,
          c0_.case_medicine_status AS case_medicine_status_38,
          c0_.ward_medicine_status AS ward_medicine_status_39
        FROM
          cases c0_
          LEFT JOIN case_referrals c1_ ON c0_.id = c1_.case_id
        WHERE
          c0_.doctor_id = ?
          OR (
            (
              c1_.doctor_id = ?
              AND c1_.is_opinion = 0
            )
          )
        ORDER BY
          c0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.mrd_id AS mrd_id_1, c0_.patient_category AS patient_category_2, c0_.family_history AS family_history_3, c0_.medical_history AS medical_history_4, c0_.medicine_history AS medicine_history_5, c0_.abha_number AS abha_number_6, c0_.current_disease_history AS current_disease_history_7, c0_.is_lab AS is_lab_8, c0_.confirmed_diagnosis AS confirmed_diagnosis_9, c0_.temparature AS temparature_10, c0_.cns AS cns_11, c0_.endrocine AS endrocine_12, c0_.excretory AS excretory_13, c0_.pulse AS pulse_14, c0_.bp_upper AS bp_upper_15, c0_.bp_lower AS bp_lower_16, c0_.respiration AS respiration_17, c0_.auscultation AS auscultation_18, c0_.local_examination AS local_examination_19, c0_.is_medicine AS is_medicine_20, c0_.is_ward AS is_ward_21, c0_.follow_up_date AS follow_up_date_22, c0_.is_pm_done AS is_pm_done_23, c0_.is_death_cert_gen AS is_death_cert_gen_24, c0_.is_birth_cert_gen AS is_birth_cert_gen_25, c0_.is_closed AS is_closed_26, c0_.is_reopened AS is_reopened_27, c0_.is_opinion AS is_opinion_28, c0_.is_referral AS is_referral_29, c0_.emergency_staff_notes AS emergency_staff_notes_30, c0_.pharmacy_staff_notes AS pharmacy_staff_notes_31, c0_.ward_staff_notes AS ward_staff_notes_32, c0_.pharmacy_patient_notes AS pharmacy_patient_notes_33, c0_.closure_reason AS closure_reason_34, c0_.created_at AS created_at_35, c0_.updated_at AS updated_at_36, c0_.lab_test_status AS lab_test_status_37, c0_.case_medicine_status AS case_medicine_status_38, c0_.ward_medicine_status AS ward_medicine_status_39 FROM cases c0_ LEFT JOIN case_referrals c1_ ON c0_.id = c1_.case_id WHERE c0_.doctor_id = 40 OR ((c1_.doctor_id = 40 AND c1_.is_opinion = 0)) ORDER BY c0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.password_old1 AS password_old1_4,
  t0.password_old2 AS password_old2_5,
  t0.password_md5 AS password_md5_6,
  t0.is_active AS is_active_7,
  t0.token AS token_8,
  t0.roles AS roles_9,
  t0.last_login AS last_login_10,
  t0.auth_code AS auth_code_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.profile_id AS profile_id_14
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.password_old1 AS password_old1_4, t0.password_old2 AS password_old2_5, t0.password_md5 AS password_md5_6, t0.is_active AS is_active_7, t0.token AS token_8, t0.roles AS roles_9, t0.last_login AS last_login_10, t0.auth_code AS auth_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.profile_id AS profile_id_14 FROM users t0 WHERE t0.id = 40;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.message AS message_3,
  t0.is_read AS is_read_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6
FROM
  notifications t0
WHERE
  t0.user_id = ?
  AND t0.is_read = ?
ORDER BY
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.type AS type_2, t0.message AS message_3, t0.is_read AS is_read_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6 FROM notifications t0 WHERE t0.user_id = 40 AND t0.is_read = 0 ORDER BY t0.created_at DESC LIMIT 5;