Symfony Profiler

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.username = ?
LIMIT
  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.username = 'lab1' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_login_history (
  user_ip, file_url, login_attempts,
  logged_in_at, user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO user_login_history (user_ip, file_url, login_attempts, logged_in_at, user_id) VALUES ('27.61.170.189', NULL, 0, '2025-07-14 23:12:49', 41);

UPDATE
  users
SET
  last_login = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE users SET last_login = '2025-07-14 23:12:49', updated_at = '2025-07-14 23:12:49' WHERE id = 41;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.father_name AS father_name_4,
  t0.mother_name AS mother_name_5,
  t0.gender AS gender_6,
  t0.photo AS photo_7,
  t0.local_address AS local_address_8,
  t0.permanent_address AS permanent_address_9,
  t0.dob AS dob_10,
  t0.dor AS dor_11,
  t0.email_otp_verify AS email_otp_verify_12,
  t0.mobile_otp_verify AS mobile_otp_verify_13,
  t0.adhar_num AS adhar_num_14,
  t0.pan_num AS pan_num_15,
  t0.email AS email_16,
  t0.temp_email AS temp_email_17,
  t0.temp_mobile_no AS temp_mobile_no_18,
  t0.email_otp AS email_otp_19,
  t0.mobile AS mobile_20,
  t0.mobile_otp AS mobile_otp_21,
  t0.emp_sen_num AS emp_sen_num_22,
  t0.gpf_cpf_num AS gpf_cpf_num_23,
  t0.contract_num AS contract_num_24,
  t0.is_update AS is_update_25,
  t0.quota_type AS quota_type_26,
  t0.job_type AS job_type_27,
  t0.bank_name AS bank_name_28,
  t0.bank_branch AS bank_branch_29,
  t0.bank_branch_address AS bank_branch_address_30,
  t0.bank_account AS bank_account_31,
  t0.bank_ifs_code AS bank_ifs_code_32,
  t0.reg_num AS reg_num_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35,
  t36.id AS id_37,
  t36.username AS username_38,
  t36.password AS password_39,
  t36.password_old1 AS password_old1_40,
  t36.password_old2 AS password_old2_41,
  t36.password_md5 AS password_md5_42,
  t36.is_active AS is_active_43,
  t36.token AS token_44,
  t36.roles AS roles_45,
  t36.last_login AS last_login_46,
  t36.auth_code AS auth_code_47,
  t36.created_at AS created_at_48,
  t36.updated_at AS updated_at_49,
  t36.profile_id AS profile_id_50,
  t0.hospital_id AS hospital_id_51,
  t0.doctor_category_id AS doctor_category_id_52,
  t0.ward_id AS ward_id_53,
  t0.designation_setting_id AS designation_setting_id_54
FROM
  staff_profiles t0
  LEFT JOIN users t36 ON t36.profile_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.father_name AS father_name_4, t0.mother_name AS mother_name_5, t0.gender AS gender_6, t0.photo AS photo_7, t0.local_address AS local_address_8, t0.permanent_address AS permanent_address_9, t0.dob AS dob_10, t0.dor AS dor_11, t0.email_otp_verify AS email_otp_verify_12, t0.mobile_otp_verify AS mobile_otp_verify_13, t0.adhar_num AS adhar_num_14, t0.pan_num AS pan_num_15, t0.email AS email_16, t0.temp_email AS temp_email_17, t0.temp_mobile_no AS temp_mobile_no_18, t0.email_otp AS email_otp_19, t0.mobile AS mobile_20, t0.mobile_otp AS mobile_otp_21, t0.emp_sen_num AS emp_sen_num_22, t0.gpf_cpf_num AS gpf_cpf_num_23, t0.contract_num AS contract_num_24, t0.is_update AS is_update_25, t0.quota_type AS quota_type_26, t0.job_type AS job_type_27, t0.bank_name AS bank_name_28, t0.bank_branch AS bank_branch_29, t0.bank_branch_address AS bank_branch_address_30, t0.bank_account AS bank_account_31, t0.bank_ifs_code AS bank_ifs_code_32, t0.reg_num AS reg_num_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t36.id AS id_37, t36.username AS username_38, t36.password AS password_39, t36.password_old1 AS password_old1_40, t36.password_old2 AS password_old2_41, t36.password_md5 AS password_md5_42, t36.is_active AS is_active_43, t36.token AS token_44, t36.roles AS roles_45, t36.last_login AS last_login_46, t36.auth_code AS auth_code_47, t36.created_at AS created_at_48, t36.updated_at AS updated_at_49, t36.profile_id AS profile_id_50, t0.hospital_id AS hospital_id_51, t0.doctor_category_id AS doctor_category_id_52, t0.ward_id AS ward_id_53, t0.designation_setting_id AS designation_setting_id_54 FROM staff_profiles t0 LEFT JOIN users t36 ON t36.profile_id = t0.id WHERE t0.id = 41;

INSERT INTO user_activity_log (
  user_id, hospital_id, action, file_path,
  created_date, updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO user_activity_log (user_id, hospital_id, action, file_path, created_date, updated_at) VALUES (41, 5, 'POST', '41_14-07-2025.csv', '2025-07-14 23:12:49', '2025-07-14 23:12:49');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";