Symfony Profiler

• Request / Response
• Performance
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 3
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.app_key AS app_key_3 FROM app_keys t0 WHERE t0.app_key = ? LIMIT 1

[
  "9ee854f8-c40c-40ef-9f96-a9fe59d69e23"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.app_key AS app_key_3
FROM
  app_keys t0
WHERE
  t0.app_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.app_key AS app_key_3 FROM app_keys t0 WHERE t0.app_key = '9ee854f8-c40c-40ef-9f96-a9fe59d69e23' LIMIT 1;

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

[
  "274fd884-808b-4024-9eb7-07689279ea25"
]

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

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 = '274fd884-808b-4024-9eb7-07689279ea25' LIMIT 1;

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, t0.doctor_id AS doctor_id_7 FROM user t0 WHERE t0.id = ?

[
  1
]

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,
  t0.doctor_id AS doctor_id_7
FROM
  user t0
WHERE
  t0.id = ?

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, t0.doctor_id AS doctor_id_7 FROM user t0 WHERE t0.id = 1;

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

[
  "274fd884-808b-4024-9eb7-07689279ea25"
]

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

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 = '274fd884-808b-4024-9eb7-07689279ea25' LIMIT 1;

SELECT u0_.id AS id_0, u0_.subscription_date AS subscription_date_1, u0_.subscription_end_date AS subscription_end_date_2, u0_.amount_paid AS amount_paid_3, u0_.status AS status_4, u0_.user_id AS user_id_5, u0_.plan_id AS plan_id_6, u0_.subscription_order_id AS subscription_order_id_7 FROM user_subscription u0_ WHERE u0_.user_id = ? AND u0_.status = ? AND u0_.subscription_end_date >= ? ORDER BY u0_.subscription_end_date DESC LIMIT 1

[
  1
  "active"
  "2026-08-17 13:14:00"
]

SELECT
  u0_.id AS id_0,
  u0_.subscription_date AS subscription_date_1,
  u0_.subscription_end_date AS subscription_end_date_2,
  u0_.amount_paid AS amount_paid_3,
  u0_.status AS status_4,
  u0_.user_id AS user_id_5,
  u0_.plan_id AS plan_id_6,
  u0_.subscription_order_id AS subscription_order_id_7
FROM
  user_subscription u0_
WHERE
  u0_.user_id = ?
  AND u0_.status = ?
  AND u0_.subscription_end_date >= ?
ORDER BY
  u0_.subscription_end_date DESC
LIMIT
  1

SELECT u0_.id AS id_0, u0_.subscription_date AS subscription_date_1, u0_.subscription_end_date AS subscription_end_date_2, u0_.amount_paid AS amount_paid_3, u0_.status AS status_4, u0_.user_id AS user_id_5, u0_.plan_id AS plan_id_6, u0_.subscription_order_id AS subscription_order_id_7 FROM user_subscription u0_ WHERE u0_.user_id = 1 AND u0_.status = 'active' AND u0_.subscription_end_date >= '2026-08-17 13:14:00' ORDER BY u0_.subscription_end_date DESC LIMIT 1;

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

[
  "274fd884-808b-4024-9eb7-07689279ea25"
]

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

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 = '274fd884-808b-4024-9eb7-07689279ea25' LIMIT 1;

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.sync_updated_on AS sync_updated_on_14, t0.is_default AS is_default_15, t0.code AS code_16, t0.diabetic AS diabetic_17, t0.smoker AS smoker_18, t0.ref_id AS ref_id_19, t0.doctor_id AS doctor_id_20, t0.user_id AS user_id_21 FROM patient t0 WHERE t0.guid = ? LIMIT 1

[
  "3e3d4fb0-fb3d-452a-bebf-24b71615dab8"
]

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.sync_updated_on AS sync_updated_on_14,
  t0.is_default AS is_default_15,
  t0.code AS code_16,
  t0.diabetic AS diabetic_17,
  t0.smoker AS smoker_18,
  t0.ref_id AS ref_id_19,
  t0.doctor_id AS doctor_id_20,
  t0.user_id AS user_id_21
FROM
  patient t0
WHERE
  t0.guid = ?
LIMIT
  1

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.sync_updated_on AS sync_updated_on_14, t0.is_default AS is_default_15, t0.code AS code_16, t0.diabetic AS diabetic_17, t0.smoker AS smoker_18, t0.ref_id AS ref_id_19, t0.doctor_id AS doctor_id_20, t0.user_id AS user_id_21 FROM patient t0 WHERE t0.guid = '3e3d4fb0-fb3d-452a-bebf-24b71615dab8' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO patient (name, age, gender, height, weight, mobile, aadhar_id, address, history, remark, guid, last_modified, sync_updated_on, is_default, code, diabetic, smoker, ref_id, doctor_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "khem1"
  23
  "male"
  "174"
  "78"
  null
  null
  null
  ""
  ""
  "3e3d4fb0-fb3d-452a-bebf-24b71615dab8"
  "2026-08-17 13:14:00"
  "2026-08-17 13:14:00"
  0
  "4"
  null
  0
  null
  null
  1
]

INSERT INTO patient (
  name, age, gender, height, weight, mobile,
  aadhar_id, address, history, remark,
  guid, last_modified, sync_updated_on,
  is_default, code, diabetic, smoker,
  ref_id, doctor_id, user_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO patient (name, age, gender, height, weight, mobile, aadhar_id, address, history, remark, guid, last_modified, sync_updated_on, is_default, code, diabetic, smoker, ref_id, doctor_id, user_id) VALUES ('khem1', 23, 'male', '174', '78', NULL, NULL, NULL, '', '', '3e3d4fb0-fb3d-452a-bebf-24b71615dab8', '2026-08-17 13:14:00', '2026-08-17 13:14:00', 0, '4', NULL, 0, NULL, NULL, 1);

"COMMIT"

[]

"COMMIT"

"COMMIT";