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_
          INNER JOIN case_lab_tests c1_ ON c0_.id = c1_.case_id
          INNER JOIN lab_tests l2_ ON c1_.lab_test_id = l2_.id
        WHERE
          c0_.is_lab = 1
          AND l2_.is_general = 0
          AND c0_.hospital_id = ?
        ORDER BY
          c1_.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_ INNER JOIN case_lab_tests c1_ ON c0_.id = c1_.case_id INNER JOIN lab_tests l2_ ON c1_.lab_test_id = l2_.id WHERE c0_.is_lab = 1 AND l2_.is_general = 0 AND c0_.hospital_id = 5 ORDER BY c1_.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 = 41;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.father_name AS father_name_4,
  t0.mother_name AS mother_name_5,
  t0.gender AS gender_6,
  t0.photo AS photo_7,
  t0.local_address AS local_address_8,
  t0.permanent_address AS permanent_address_9,
  t0.dob AS dob_10,
  t0.dor AS dor_11,
  t0.email_otp_verify AS email_otp_verify_12,
  t0.mobile_otp_verify AS mobile_otp_verify_13,
  t0.adhar_num AS adhar_num_14,
  t0.pan_num AS pan_num_15,
  t0.email AS email_16,
  t0.temp_email AS temp_email_17,
  t0.temp_mobile_no AS temp_mobile_no_18,
  t0.email_otp AS email_otp_19,
  t0.mobile AS mobile_20,
  t0.mobile_otp AS mobile_otp_21,
  t0.emp_sen_num AS emp_sen_num_22,
  t0.gpf_cpf_num AS gpf_cpf_num_23,
  t0.contract_num AS contract_num_24,
  t0.is_update AS is_update_25,
  t0.quota_type AS quota_type_26,
  t0.job_type AS job_type_27,
  t0.bank_name AS bank_name_28,
  t0.bank_branch AS bank_branch_29,
  t0.bank_branch_address AS bank_branch_address_30,
  t0.bank_account AS bank_account_31,
  t0.bank_ifs_code AS bank_ifs_code_32,
  t0.reg_num AS reg_num_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35,
  t36.id AS id_37,
  t36.username AS username_38,
  t36.password AS password_39,
  t36.password_old1 AS password_old1_40,
  t36.password_old2 AS password_old2_41,
  t36.password_md5 AS password_md5_42,
  t36.is_active AS is_active_43,
  t36.token AS token_44,
  t36.roles AS roles_45,
  t36.last_login AS last_login_46,
  t36.auth_code AS auth_code_47,
  t36.created_at AS created_at_48,
  t36.updated_at AS updated_at_49,
  t36.profile_id AS profile_id_50,
  t0.hospital_id AS hospital_id_51,
  t0.doctor_category_id AS doctor_category_id_52,
  t0.ward_id AS ward_id_53,
  t0.designation_setting_id AS designation_setting_id_54
FROM
  staff_profiles t0
  LEFT JOIN users t36 ON t36.profile_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.father_name AS father_name_4, t0.mother_name AS mother_name_5, t0.gender AS gender_6, t0.photo AS photo_7, t0.local_address AS local_address_8, t0.permanent_address AS permanent_address_9, t0.dob AS dob_10, t0.dor AS dor_11, t0.email_otp_verify AS email_otp_verify_12, t0.mobile_otp_verify AS mobile_otp_verify_13, t0.adhar_num AS adhar_num_14, t0.pan_num AS pan_num_15, t0.email AS email_16, t0.temp_email AS temp_email_17, t0.temp_mobile_no AS temp_mobile_no_18, t0.email_otp AS email_otp_19, t0.mobile AS mobile_20, t0.mobile_otp AS mobile_otp_21, t0.emp_sen_num AS emp_sen_num_22, t0.gpf_cpf_num AS gpf_cpf_num_23, t0.contract_num AS contract_num_24, t0.is_update AS is_update_25, t0.quota_type AS quota_type_26, t0.job_type AS job_type_27, t0.bank_name AS bank_name_28, t0.bank_branch AS bank_branch_29, t0.bank_branch_address AS bank_branch_address_30, t0.bank_account AS bank_account_31, t0.bank_ifs_code AS bank_ifs_code_32, t0.reg_num AS reg_num_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t36.id AS id_37, t36.username AS username_38, t36.password AS password_39, t36.password_old1 AS password_old1_40, t36.password_old2 AS password_old2_41, t36.password_md5 AS password_md5_42, t36.is_active AS is_active_43, t36.token AS token_44, t36.roles AS roles_45, t36.last_login AS last_login_46, t36.auth_code AS auth_code_47, t36.created_at AS created_at_48, t36.updated_at AS updated_at_49, t36.profile_id AS profile_id_50, t0.hospital_id AS hospital_id_51, t0.doctor_category_id AS doctor_category_id_52, t0.ward_id AS ward_id_53, t0.designation_setting_id AS designation_setting_id_54 FROM staff_profiles t0 LEFT JOIN users t36 ON t36.profile_id = t0.id WHERE t0.id = 41;

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 = 41 AND t0.is_read = 0 ORDER BY t0.created_at DESC LIMIT 5;