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.