https://staging-hospital.7mantra.in/cases/consent/n1kjw_24szB9lsEPlfW5Nq1Y

Query Metrics

5 Database Queries
5 Different statements
5.42 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.11 ms
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
]
2 1.07 ms
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
]
3 1.30 ms
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
]
4 0.87 ms
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

# Time Info
1 1.07 ms
SELECT * FROM cnmgts_abha_consent_request ORDER BY id DESC
Parameters:
[]

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\Patient 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\Village No errors.
App\Entity\DeathCause No errors.
App\Entity\District No errors.
App\Entity\Taluka No errors.