Query Metrics
3
Database Queries
3
Different statements
3.44 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 1.04 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.73 ms |
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"
]
|
2 | 1.66 ms |
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:
[] |
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. |