Query Metrics
317
Database Queries
14
Different statements
90.51 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
18.18 ms (20.08%) |
50 |
SELECT t0.id AS id_1, t0.is_surgery_advised AS is_surgery_advised_2, t0.is_complications AS is_complications_3, t0.status AS status_4, t0.discharge_reason AS discharge_reason_5, t0.is_for_pm AS is_for_pm_6, t0.discharge_note AS discharge_note_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.case_id AS case_id_10, t0.ward_id AS ward_id_11, t12.id AS id_13, t12.baby_gender AS baby_gender_14, t12.is_abortion AS is_abortion_15, t12.bp_systolic AS bp_systolic_16, t12.bp_diastolic AS bp_diastolic_17, t12.baby_temp AS baby_temp_18, t12.uterus_pos AS uterus_pos_19, t12.nipple_pos AS nipple_pos_20, t12.delivery_type AS delivery_type_21, t12.baby_status AS baby_status_22, t12.baby_weight AS baby_weight_23, t12.is_cried_after_birth AS is_cried_after_birth_24, t12.is_passed_stool AS is_passed_stool_25, t12.is_diarrhea AS is_diarrhea_26, t12.is_pnemonia AS is_pnemonia_27, t12.is_preterm AS is_preterm_28, t12.is_asphaxia AS is_asphaxia_29, t12.is_malaria AS is_malaria_30, t12.is_congenital_detected AS is_congenital_detected_31, t12.is_injury AS is_injury_32, t12.is_mr AS is_mr_33, t12.is_ncd AS is_ncd_34, t12.is_vomitting AS is_vomitting_35, t12.is_activeness AS is_activeness_36, t12.respiration AS respiration_37, t12.is_diptheria AS is_diptheria_38, t12.is_tetanus AS is_tetanus_39, t12.is_pertusis AS is_pertusis_40, t12.is_meningitis AS is_meningitis_41, t12.is_aids AS is_aids_42, t12.is_convulsions AS is_convulsions_43, t12.is_breast_suckling AS is_breast_suckling_44, t12.is_chest_in_side AS is_chest_in_side_45, t12.is_jaundice AS is_jaundice_46, t12.umbilical_cord AS umbilical_cord_47, t12.is_sepsis AS is_sepsis_48, t12.other_complications AS other_complications_49, t12.is_bath_after_birth AS is_bath_after_birth_50, t12.remarks AS remarks_51, t12.created_at AS created_at_52, t12.case_id AS case_id_53, t12.ward_bed_id AS ward_bed_id_54, t12.danger_sign_id AS danger_sign_id_55, t12.child_id AS child_id_56, t12.child_case_id AS child_case_id_57 FROM ward_beds t0 LEFT JOIN delivery_details t12 ON t12.ward_bed_id = t0.id WHERE t0.case_id = ?
Parameters:
[
2118
]
|
|
15.32 ms (16.93%) |
50 |
SELECT t0.id AS id_1, t0.corpse_sender AS corpse_sender_2, t0.place_corpse_sent AS place_corpse_sent_3, t0.place_corpse_sent_distance AS place_corpse_sent_distance_4, t0.corpse_bringer AS corpse_bringer_5, t0.corpse_identifier AS corpse_identifier_6, t0.exam_begun_at AS exam_begun_at_7, t0.exam_ended_at AS exam_ended_at_8, t0.accompany_report_substance AS accompany_report_substance_9, t0.place_examined AS place_examined_10, t0.distance_from_place AS distance_from_place_11, t0.why_not_sent_to_hospital AS why_not_sent_to_hospital_12, t0.sex_apparent_age_race_caste AS sex_apparent_age_race_caste_13, t0.desc_cloth_ornam AS desc_cloth_ornam_14, t0.cond_cloth AS cond_cloth_15, t0.special_marks_on_skin AS special_marks_on_skin_16, t0.newly_born_infant_details AS newly_born_infant_details_17, t0.body_condition AS body_condition_18, t0.regar_mortis AS regar_mortis_19, t0.decomp_signs_extents AS decomp_signs_extents_20, t0.features AS features_21, t0.skin_cond AS skin_cond_22, t0.external_genitals_injuries AS external_genitals_injuries_23, t0.limb_position AS limb_position_24, t0.surface_wounds_injuries AS surface_wounds_injuries_25, t0.cond_subcutaneous_tissues AS cond_subcutaneous_tissues_26, t0.other_injuries AS other_injuries_27, t0.sure_ante_mortem AS sure_ante_mortem_28, t0.head_injuries_under_scalp AS head_injuries_under_scalp_29, t0.skull_vault_base AS skull_vault_base_30, t0.brain_details AS brain_details_31, t0.thorax_walls_ribs_cartilages AS thorax_walls_ribs_cartilages_32, t0.pleura AS pleura_33, t0.larynx_trachea_bronchi AS larynx_trachea_bronchi_34, t0.right_lung AS right_lung_35, t0.left_lung AS left_lung_36, t0.pericardium AS pericardium_37, t0.heart AS heart_38, t0.large_vessels AS large_vessels_39, t0.heart_additional_remarks AS heart_additional_remarks_40, t0.abdomen_walls AS abdomen_walls_41, t0.peritoneum AS peritoneum_42, t0.cavity AS cavity_43, t0.bucal_cavity_teeth_tongue_pharynx AS bucal_cavity_teeth_tongue_pharynx_44, t0.desophagus AS desophagus_45, t0.stomach AS stomach_46, t0.small_intestine AS small_intestine_47, t0.large_intestine AS large_intestine_48, t0.liver_gall_bladder AS liver_gall_bladder_49, t0.pancreas_suprarenals AS pancreas_suprarenals_50, t0.spleen AS spleen_51, t0.kidneys AS kidneys_52, t0.bladder AS bladder_53, t0.generations_organs AS generations_organs_54, t0.stomach_additional_remarks AS stomach_additional_remarks_55, t0.retained_viscera_details AS retained_viscera_details_56, t0.spine_spinal_cord AS spine_spinal_cord_57, t0.death_cause_opinion AS death_cause_opinion_58, t0.created_at AS created_at_59, t0.updated_at AS updated_at_60, t0.case_id AS case_id_61, t0.created_by_id AS created_by_id_62, t0.updated_by_id AS updated_by_id_63 FROM post_mortem_reports t0 WHERE t0.case_id = ?
Parameters:
[
2118
]
|
|
11.52 ms (12.73%) |
50 |
SELECT t0.id AS id_1, t0.baby_gender AS baby_gender_2, t0.is_abortion AS is_abortion_3, t0.bp_systolic AS bp_systolic_4, t0.bp_diastolic AS bp_diastolic_5, t0.baby_temp AS baby_temp_6, t0.uterus_pos AS uterus_pos_7, t0.nipple_pos AS nipple_pos_8, t0.delivery_type AS delivery_type_9, t0.baby_status AS baby_status_10, t0.baby_weight AS baby_weight_11, t0.is_cried_after_birth AS is_cried_after_birth_12, t0.is_passed_stool AS is_passed_stool_13, t0.is_diarrhea AS is_diarrhea_14, t0.is_pnemonia AS is_pnemonia_15, t0.is_preterm AS is_preterm_16, t0.is_asphaxia AS is_asphaxia_17, t0.is_malaria AS is_malaria_18, t0.is_congenital_detected AS is_congenital_detected_19, t0.is_injury AS is_injury_20, t0.is_mr AS is_mr_21, t0.is_ncd AS is_ncd_22, t0.is_vomitting AS is_vomitting_23, t0.is_activeness AS is_activeness_24, t0.respiration AS respiration_25, t0.is_diptheria AS is_diptheria_26, t0.is_tetanus AS is_tetanus_27, t0.is_pertusis AS is_pertusis_28, t0.is_meningitis AS is_meningitis_29, t0.is_aids AS is_aids_30, t0.is_convulsions AS is_convulsions_31, t0.is_breast_suckling AS is_breast_suckling_32, t0.is_chest_in_side AS is_chest_in_side_33, t0.is_jaundice AS is_jaundice_34, t0.umbilical_cord AS umbilical_cord_35, t0.is_sepsis AS is_sepsis_36, t0.other_complications AS other_complications_37, t0.is_bath_after_birth AS is_bath_after_birth_38, t0.remarks AS remarks_39, t0.created_at AS created_at_40, t0.case_id AS case_id_41, t0.ward_bed_id AS ward_bed_id_42, t0.danger_sign_id AS danger_sign_id_43, t0.child_id AS child_id_44, t0.child_case_id AS child_case_id_45 FROM delivery_details t0 WHERE t0.case_id = ?
Parameters:
[
2118
]
|
|
9.24 ms (10.20%) |
50 |
SELECT t0.id AS id_1, t0.immediate_cause AS immediate_cause_2, t0.antecedent_cause_b AS antecedent_cause_b_3, t0.antecedent_cause_c AS antecedent_cause_c_4, t0.other_significant_conditions AS other_significant_conditions_5, t0.on_set_interval AS on_set_interval_6, t0.how_injury_occurred AS how_injury_occurred_7, t0.manner_of_death AS manner_of_death_8, t0.is_pregnancy_death AS is_pregnancy_death_9, t0.is_delivery AS is_delivery_10, t0.died_at AS died_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.case_id AS case_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM death_certificates t0 WHERE t0.case_id = ?
Parameters:
[
2118
]
|
|
9.02 ms (9.96%) |
50 |
SELECT t0.id AS id_1, t0.brought_by AS brought_by_2, t0.office_letter_ref AS office_letter_ref_3, t0.date_brought AS date_brought_4, t0.examined_at AS examined_at_5, t0.id_mark1 AS id_mark1_6, t0.id_mark2 AS id_mark2_7, t0.created_at AS created_at_8, t0.case_id AS case_id_9 FROM injured_info t0 WHERE t0.case_id = ?
Parameters:
[
2118
]
|
|
8.71 ms (9.63%) |
1 |
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
Parameters:
[ 40 40 ] |
|
7.94 ms (8.77%) |
50 |
SELECT t0.id AS id_1, t0.reg_num AS reg_num_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.case_id AS case_id_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM birth_certificates t0 WHERE t0.case_id = ?
Parameters:
[
2118
]
|
|
3.57 ms (3.94%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_35 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, c1_.id AS id_40, c1_.expert_opinion AS expert_opinion_41, c1_.email AS email_42, c1_.is_opinion AS is_opinion_43, c1_.is_other AS is_other_44, c1_.notes AS notes_45, c1_.created_at AS created_at_46, c1_.updated_at AS updated_at_47 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))) dctrn_result_inner ORDER BY created_at_35 DESC) dctrn_result LIMIT 50
Parameters:
[ 40 40 ] |
|
2.94 ms (3.25%) |
10 |
SELECT t0.id AS id_1, t0.uh_id AS uh_id_2, t0.first_name AS first_name_3, t0.middle_name AS middle_name_4, t0.last_name AS last_name_5, t0.father_husband_name AS father_husband_name_6, t0.photo AS photo_7, t0.gender AS gender_8, t0.marital_status AS marital_status_9, t0.dob AS dob_10, t0.house_plot_no AS house_plot_no_11, t0.address AS address_12, t0.pincode AS pincode_13, t0.mobile AS mobile_14, t0.email AS email_15, t0.adhar_num AS adhar_num_16, t0.bpl_num AS bpl_num_17, t0.health_id_number AS health_id_number_18, t0.health_address AS health_address_19, t0.abpm_jay AS abpm_jay_20, t0.occupation AS occupation_21, t0.family_income AS family_income_22, t0.is_active AS is_active_23, t0.bank_name AS bank_name_24, t0.bank_branch AS bank_branch_25, t0.bank_branch_address AS bank_branch_address_26, t0.bank_account AS bank_account_27, t0.bank_ifs_code AS bank_ifs_code_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.member_code AS member_code_31, t0.is_alive AS is_alive_32, t0.expired_at AS expired_at_33, t0.hospital_id AS hospital_id_34, t0.village_id AS village_id_35, t0.death_cause_id AS death_cause_id_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38 FROM patients t0 WHERE t0.id = ?
Parameters:
[
1855
]
|
|
1.26 ms (1.40%) |
1 |
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, c0_.hospital_id AS hospital_id_40, c0_.patient_id AS patient_id_41, c0_.doctor_id AS doctor_id_42, c0_.prev_case_id AS prev_case_id_43, c0_.disease_category_id AS disease_category_id_44, c0_.icd10_cause_group_id AS icd10_cause_group_id_45, c0_.icd10_cause_sub_group_id AS icd10_cause_sub_group_id_46, c0_.icd10_disease_id AS icd10_disease_id_47, c0_.created_by AS created_by_48, c0_.updated_by AS updated_by_49 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))) AND c0_.id IN (?) ORDER BY c0_.created_at DESC
Parameters:
[ 40 40 [ 2118 2117 2116 2115 2114 2113 2112 2111 2110 2109 2108 2107 2106 2105 2104 2103 2102 2101 2100 2099 2098 2097 2096 2095 2094 2093 2092 2091 2090 2089 2088 2087 2086 2085 2084 2083 2082 2081 2080 2079 2078 2077 2076 2075 2074 2073 2072 2071 2069 2068 ] ] |
|
0.95 ms (1.05%) |
1 |
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 = ?
Parameters:
[
40
]
|
|
0.80 ms (0.88%) |
1 |
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
Parameters:
[ 40 0 ] |
|
0.68 ms (0.75%) |
1 |
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 = ?
Parameters:
[
40
]
|
|
0.39 ms (0.43%) |
1 |
SELECT t0.id AS id_1, t0.h_num AS h_num_2, t0.reg_num AS reg_num_3, t0.abha_num AS abha_num_4, t0.reg_date AS reg_date_5, t0.abha_date AS abha_date_6, t0.hip_id AS hip_id_7, t0.hip_name AS hip_name_8, t0.hiu_id AS hiu_id_9, t0.hiu_name AS hiu_name_10, t0.name AS name_11, t0.type AS type_12, t0.level AS level_13, t0.code AS code_14, t0.is_active AS is_active_15, t0.address AS address_16, t0.pincode AS pincode_17, t0.phone AS phone_18, t0.email AS email_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.district_id AS district_id_24, t0.taluka_id AS taluka_id_25, t0.village_id AS village_id_26 FROM hospitals t0 WHERE t0.id = ?
Parameters:
[
5
]
|
cnmgts connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| cnmgts | doctrine.dbal.cnmgts_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\StaffProfile | No errors. |
| App\Entity\UserLoginHistory | No errors. |
| App\Entity\Cases | No errors. |
| App\Entity\CaseReferral | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Hospital | No errors. |
| App\Entity\DoctorCategory | No errors. |
| App\Entity\Ward | No errors. |
| App\Entity\DesignationSetting | No errors. |
| App\Entity\StaffServiceOrder | No errors. |
| App\Entity\StaffEducation | No errors. |
| App\Entity\StaffFamilyMember | No errors. |
| App\Entity\StaffWorkExperience | No errors. |
| App\Entity\StaffTraining | No errors. |
| App\Entity\StaffSalaryHistory | No errors. |
| App\Entity\StaffDeputation | No errors. |
| App\Entity\StaffComplaint | No errors. |
| App\Entity\StaffLeaveAllotment | No errors. |
| App\Entity\Patient | No errors. |
| App\Entity\DiseaseCategory | No errors. |
| App\Entity\Icd10CauseGroup | No errors. |
| App\Entity\Icd10CauseSubGroup | No errors. |
| App\Entity\Icd10Disease | No errors. |
| App\Entity\CaseClinicalPattern | No errors. |
| App\Entity\CaseProvisionalExamination | No errors. |
| App\Entity\CaseProvisionalDiagnosis | No errors. |
| App\Entity\CaseSymptom | No errors. |
| App\Entity\CaseNcd | No errors. |
| App\Entity\CaseLaboratory | No errors. |
| App\Entity\WardBed | No errors. |
| App\Entity\DeliveryDetail | No errors. |
| App\Entity\InjuredInfo | No errors. |
| App\Entity\PostMortemReport | No errors. |
| App\Entity\DeathCertificate | No errors. |
| App\Entity\BirthCertificate | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Taluka | No errors. |
| App\Entity\Village | No errors. |
| App\Entity\PncHighRisk | No errors. |
| App\Entity\DeathCause | No errors. |