https://staging-hospital.7mantra.in/cases/view-data/aKcWj8pHbtAmZ5XD1i0cB_U_

Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 1.84 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
]

cnmgts connection

# Time Info
1 0.48 ms
SELECT artefact_id, key_material FROM cnmgts_abha_consent_request WHERE id = ? ORDER BY id DESC LIMIT 1
Parameters:
[
  "40"
]
2 5.88 ms
INSERT INTO `cnmgts_abha_service`(
			`request_id`,
			`demographic_details`,
			`callback_url`,
			`status`
		) VALUES (
			'Hospital',
			'a:2:{s:10:"artefactId";s:36:"714aad6d-9dd4-4796-ba4c-d2eb67d45635";s:11:"keyMaterial";s:694:"a:4:{s:10:"privateKey";s:44:"DEgVGOJDGch1waaw1M9gIAJQVRLe31Xp0AaFKq+XEAA=";s:9:"publicKey";s:88:"BCH/E3pJNUbATgKV+S+BgNYW9zEO5tgUiAGgP03WDSrtAndqcW5XQrmEVqroASUEv7Zu3mMfe8mpZHzHmwG7IEI=";s:13:"x509PublicKey";s:412:"MIIBMTCB6gYHKoZIzj0CATCB3gIBATArBgcqhkjOPQEBAiB/////////////////////////////////////////7TBEBCAqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqYSRShRAQge0Je0Je0Je0Je0Je0Je0Je0Je0Je0Je0JgtenHcQyGQEQQQqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq0kWiCuGaG4oIa04B7dLHdI0UySPU1+bXxhsinpxaJ+ztPZAiAQAAAAAAAAAAAAAAAAAAAAFN753qL3nNZYEmMaXPXT7QIBCANCAAQh/xN6STVGwE4ClfkvgYDWFvcxDubYFIgBoD9N1g0q7QJ3anFuV0K5hFaq6AElBL+2bt5jH3vJqWR8x5sBuyBC";s:5:"nonce";s:44:"4YXX1tt8KvnZSF9eqFkNRGIsnBdmTOBbDTiG0Yk/wsY=";}";}',
			'https://staging-abdm.7mantra.in/m3/data-decryption',
			'2'
		)
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.