https://staging-hospital.7mantra.in/cases/data-request/SGLvJ3MlwA56ZQ3p0BT9eGzz

Query Metrics

3 Database Queries
3 Different statements
3.44 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.04 ms
(30.39%)
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
]

cnmgts connection

Time Count Info
1.66 ms
(48.45%)
1
INSERT INTO `cnmgts_abha_service`(
			`request_id`,
			`demographic_details`,
			`callback_url`,
			`status`
		) VALUES (
			'Hospital',
			'a:5:{s:10:"artefactId";s:36:"ec95d2e8-d4fe-4cb6-8d8e-deba5e1d9dd7";s:4:"from";s:10:"2024-09-01";s:2:"to";s:10:"2025-07-09";s:6:"expiry";s:10:"2025-07-16";s:11:"keyMaterial";s:694:"a:4:{s:10:"privateKey";s:44:"D5CdU9zqGQGHDphekyR+ZE8cnvzth+DOjbBz+7fibJk=";s:9:"publicKey";s:88:"BDA56dtYg1S6jvIBL6eeuUJz8Rn5tjuYqize+6OSt8CRe6Y2IEAK7l4rsUkLaPXMa8EJT1De5joVxw6uE0SLrrY=";s:13:"x509PublicKey";s:412:"MIIBMTCB6gYHKoZIzj0CATCB3gIBATArBgcqhkjOPQEBAiB/////////////////////////////////////////7TBEBCAqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqYSRShRAQge0Je0Je0Je0Je0Je0Je0Je0Je0Je0Je0JgtenHcQyGQEQQQqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq0kWiCuGaG4oIa04B7dLHdI0UySPU1+bXxhsinpxaJ+ztPZAiAQAAAAAAAAAAAAAAAAAAAAFN753qL3nNZYEmMaXPXT7QIBCANCAAQwOenbWINUuo7yAS+nnrlCc/EZ+bY7mKos3vujkrfAkXumNiBACu5eK7FJC2j1zGvBCU9Q3uY6FccOrhNEi662";s:5:"nonce";s:44:"Td3Dzx7LFIbzuPD+YO0+5Tq3yqcYYYT+hurqdkm5wCs=";}";}',
			'https://staging-hospital.7mantra.in/m3/cm-request',
			'2'
		)
Parameters:
[]
0.73 ms
(21.16%)
1
SELECT artefact_id, request_from, request_to, expiry_date, key_material FROM cnmgts_abha_consent_request WHERE id = ? ORDER BY id DESC LIMIT 1
Parameters:
[
  "26"
]

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\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.