POST https://biobt.sarabit.com/mobile/user/api/patient/patientsync

Query Metrics

87 Database Queries
8 Different statements
40.43 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 8.12 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM super_admin t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "7813a71d-9aa2-4347-98ba-f8fe144c7ae8"
]
2 1.68 ms
SELECT t0.id AS id_1, t0.auth_key AS auth_key_2, t0.roles AS roles_3, t0.user_id AS user_id_4 FROM user_auth_keys t0 WHERE t0.auth_key = ? LIMIT 1
Parameters:
[
  "7813a71d-9aa2-4347-98ba-f8fe144c7ae8"
]
3 1.50 ms
SELECT t0.id AS id_1, t0.auth_key AS auth_key_2, t0.roles AS roles_3, t0.user_id AS user_id_4 FROM user_auth_keys t0 WHERE t0.auth_key = ? LIMIT 1
Parameters:
[
  "7813a71d-9aa2-4347-98ba-f8fe144c7ae8"
]
4 0.79 ms
SELECT t0.id AS id_1, t0.mobile AS mobile_2, t0.name AS name_3, t0.app_mode AS app_mode_4, t0.is_deleted AS is_deleted_5, t0.email AS email_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  17
]
5 1.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "8f549b32-d94c-44a5-aca5-f1cf883121ec"
]
6 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
7 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "22e4d61a-6707-4790-b61b-1a93eafc2958"
]
8 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
9 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "696aac83-54f5-40d1-be00-e214747fdac6"
]
10 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
11 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "f533488f-9772-4502-8776-f7b1d165f0cb"
]
12 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
13 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "bd3e5137-3257-454f-a609-8a0f5e489c59"
]
14 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
15 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "5dbbf484-2499-4b6a-9646-137f0177148c"
]
16 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
17 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "ec2a83ff-9f30-4561-b191-4020b7e753a8"
]
18 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
19 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "0c5f1d1f-68f6-43b8-ba45-8349f71e4904"
]
20 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
21 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "3299942e-5568-4f58-a5f5-750046048a6c"
]
22 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
23 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "9a5403d9-8b6b-4587-8978-7f7d22a962ee"
]
24 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
25 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "ad795178-f98b-4569-a07a-6d4123cbc1c1"
]
26 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
27 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "bbf5616e-b846-4c50-ab60-9acd4b660d9a"
]
28 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
29 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "4cff46cf-8cba-43b9-a3e8-faa075c4880a"
]
30 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
31 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "b9159b2d-443b-4042-bfe1-0de3e833feb7"
]
32 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
33 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "e2843750-f0e7-40b6-9cc1-cff8c34f4f96"
]
34 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
35 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "84063402-3cdc-4877-9b3a-97029462dc79"
]
36 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
37 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "34e24a17-4853-4cbf-9fa5-90b492a0ed3e"
]
38 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
39 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "d9e6a8f6-063e-4a2e-a012-3cd78e729260"
]
40 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
41 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "7b673b70-b36b-4a6f-8112-36573b484c38"
]
42 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
43 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "5d9710fc-628e-41d2-ae13-d7b4f8059793"
]
44 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
45 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "2394eea2-eeee-4c36-9a6e-3c5462914456"
]
46 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
47 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "262eaad5-14dd-4002-ad45-a9cbb82e3276"
]
48 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
49 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "1b47a3b3-7eb0-4e72-afcc-9b67f8072591"
]
50 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
51 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "be8bceba-2461-429c-a488-c0ced649bd99"
]
52 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
53 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "cff89c8c-0af3-4bd4-9218-2dd4de6545b1"
]
54 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
55 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "c82997f5-3905-4fc8-be0e-61ba9b47ce12"
]
56 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
57 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.is_default AS is_default_14, t0.code AS code_15, t0.diabetic AS diabetic_16, t0.smoker AS smoker_17, t0.ref_id AS ref_id_18, t0.doctor_id AS doctor_id_19, t0.user_id AS user_id_20 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "1ebea418-35ef-4d2b-9994-976db29f601e"
]
58 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.designation AS designation_3, t0.designation2 AS designation2_4, t0.guid AS guid_5, t0.last_modified AS last_modified_6, t0.is_default AS is_default_7, t0.user_id AS user_id_8 FROM user_doctor t0 WHERE t0.user_id = ? AND t0.is_default = ? LIMIT 1
Parameters:
[
  17
  1
]
59 0.15 ms
"START TRANSACTION"
Parameters:
[]
60 0.83 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:04:30"
  44
]
61 0.33 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:40:29"
  51
]
62 0.24 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 13:00:53"
  36
]
63 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 15:02:46"
  58
]
64 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 13:08:23"
  39
]
65 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:06:00"
  45
]
66 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:49:05"
  52
]
67 0.23 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:56:25"
  55
]
68 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:27:56"
  48
]
69 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 13:16:26"
  41
]
70 0.25 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:35:30"
  50
]
71 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:21:14"
  47
]
72 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 16:16:05"
  59
]
73 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-08-31 16:54:47"
  33
]
74 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 12:33:46"
  34
]
75 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:50:36"
  53
]
76 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 13:03:15"
  37
]
77 0.20 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:29:55"
  49
]
78 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 12:57:17"
  35
]
79 0.20 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:51:58"
  54
]
80 0.24 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 13:12:08"
  40
]
81 0.22 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:09:46"
  46
]
82 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 13:05:29"
  38
]
83 0.20 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 14:03:16"
  43
]
84 0.20 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 15:00:39"
  56
]
85 0.23 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 15:01:31"
  57
]
86 0.21 ms
UPDATE patient SET last_modified = ? WHERE id = ?
Parameters:
[
  "2024-09-01 13:57:12"
  42
]
87 0.13 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_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\SuperAdmin No errors.
App\Entity\UserAuthKeys No errors.
App\Entity\User
  • The mappings App\Entity\User#ecgRecords and App\Entity\EcgRecord#user are inconsistent with each other.
App\Entity\UserOtpKeys No errors.
App\Entity\UserDoctor No errors.
App\Entity\Patient
  • The mappings App\Entity\Patient#ecgRecords and App\Entity\EcgRecord#patient are inconsistent with each other.
App\Entity\EcgRecord
  • The association App\Entity\EcgRecord#user refers to the inverse side field App\Entity\User#ecgReacords which does not exist.
  • The association App\Entity\EcgRecord#patient refers to the inverse side field App\Entity\Patient#ecgReacords which does not exist.
App\Entity\HolterRecords No errors.
App\Entity\Enquiry No errors.
App\Entity\RrGluData No errors.