Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.transaction_id AS transaction_id_1,
  m0_.transaction_type AS transaction_type_2,
  m0_.transaction_time AS transaction_time_3,
  m0_.transaction_amount AS transaction_amount_4,
  m0_.ref_number AS ref_number_5,
  m0_.short_code AS short_code_6,
  m0_.balance AS balance_7,
  m0_.msisdn AS msisdn_8,
  m0_.first_name AS first_name_9,
  m0_.middle_name AS middle_name_10,
  m0_.last_name AS last_name_11,
  m0_.created_at AS created_at_12,
  m0_.is_used AS is_used_13
FROM
  mpesa m0_
WHERE
  m0_.is_used = 0
  AND m0_.short_code = 4022961

SELECT m0_.id AS id_0, m0_.transaction_id AS transaction_id_1, m0_.transaction_type AS transaction_type_2, m0_.transaction_time AS transaction_time_3, m0_.transaction_amount AS transaction_amount_4, m0_.ref_number AS ref_number_5, m0_.short_code AS short_code_6, m0_.balance AS balance_7, m0_.msisdn AS msisdn_8, m0_.first_name AS first_name_9, m0_.middle_name AS middle_name_10, m0_.last_name AS last_name_11, m0_.created_at AS created_at_12, m0_.is_used AS is_used_13 FROM mpesa m0_ WHERE m0_.is_used = 0 AND m0_.short_code = 4022961;

"COMMIT"

"COMMIT";

INSERT INTO mpesa_transaction (
  created_at, mpesa_id, transaction_id,
  created_by
)
VALUES
  (?, ?, ?, ?)

INSERT INTO mpesa_transaction (created_at, mpesa_id, transaction_id, created_by) VALUES ('2025-03-18 12:20:35', 183440, 1059622, 69);

UPDATE
  transaction
SET
  cash_amount = ?,
  mpesa_amount = ?,
  is_complete = ?,
  is_paid = ?,
  paid_by = ?,
  payment_method = ?
WHERE
  id = ?

UPDATE transaction SET cash_amount = 0, mpesa_amount = 200, is_complete = 1, is_paid = 1, paid_by = 'OTHER', payment_method = 'MPESA' WHERE id = 1059622;

SELECT
  t0.id AS id_1,
  t0.paybill AS paybill_2,
  t0.consumer_key AS consumer_key_3,
  t0.consumer_secret AS consumer_secret_4,
  t0.pass_key AS pass_key_5,
  t0.token AS token_6,
  t0.token_updated_at AS token_updated_at_7,
  t0.auth_type AS auth_type_8,
  t0.short_code_type AS short_code_type_9,
  t0.station AS station_10
FROM
  mpesa_auth t0
WHERE
  t0.station = ?
  AND t0.auth_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.paybill AS paybill_2, t0.consumer_key AS consumer_key_3, t0.consumer_secret AS consumer_secret_4, t0.pass_key AS pass_key_5, t0.token AS token_6, t0.token_updated_at AS token_updated_at_7, t0.auth_type AS auth_type_8, t0.short_code_type AS short_code_type_9, t0.station AS station_10 FROM mpesa_auth t0 WHERE t0.station = 1 AND t0.auth_type = 'PROD' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.cash_amount AS cash_amount_3,
  t0.mpesa_amount AS mpesa_amount_4,
  t0.tax_percentage AS tax_percentage_5,
  t0.tax_amount AS tax_amount_6,
  t0.gross_amount AS gross_amount_7,
  t0.station_expenses AS station_expenses_8,
  t0.station_balance AS station_balance_9,
  t0.expenses AS expenses_10,
  t0.balance AS balance_11,
  t0.created_at AS created_at_12,
  t0.is_cancelled AS is_cancelled_13,
  t0.is_complete AS is_complete_14,
  t0.is_paid AS is_paid_15,
  t0.paid_by AS paid_by_16,
  t0.mpesa_payment_phone AS mpesa_payment_phone_17,
  t0.payment_method AS payment_method_18,
  t0.pin_number AS pin_number_19,
  t0.cu_invoice_number AS cu_invoice_number_20,
  t0.cu_invoice_number_credit AS cu_invoice_number_credit_21,
  t0.cu_serial_number AS cu_serial_number_22,
  t0.is_final AS is_final_23,
  t0.way_bill_id AS way_bill_id_24,
  t0.created_by AS created_by_25,
  t0.organization_id AS organization_id_26,
  t0.daily_account_id AS daily_account_id_27
FROM
  transaction t0
WHERE
  t0.way_bill_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.cash_amount AS cash_amount_3, t0.mpesa_amount AS mpesa_amount_4, t0.tax_percentage AS tax_percentage_5, t0.tax_amount AS tax_amount_6, t0.gross_amount AS gross_amount_7, t0.station_expenses AS station_expenses_8, t0.station_balance AS station_balance_9, t0.expenses AS expenses_10, t0.balance AS balance_11, t0.created_at AS created_at_12, t0.is_cancelled AS is_cancelled_13, t0.is_complete AS is_complete_14, t0.is_paid AS is_paid_15, t0.paid_by AS paid_by_16, t0.mpesa_payment_phone AS mpesa_payment_phone_17, t0.payment_method AS payment_method_18, t0.pin_number AS pin_number_19, t0.cu_invoice_number AS cu_invoice_number_20, t0.cu_invoice_number_credit AS cu_invoice_number_credit_21, t0.cu_serial_number AS cu_serial_number_22, t0.is_final AS is_final_23, t0.way_bill_id AS way_bill_id_24, t0.created_by AS created_by_25, t0.organization_id AS organization_id_26, t0.daily_account_id AS daily_account_id_27 FROM transaction t0 WHERE t0.way_bill_id = '1059663' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.created_at AS created_at_4,
  t0.roles AS roles_5,
  t0.email AS email_6,
  t0.person_id AS person_id_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = 69;

SELECT
  m0_.id AS id_0,
  m0_.transaction_id AS transaction_id_1,
  m0_.transaction_type AS transaction_type_2,
  m0_.transaction_time AS transaction_time_3,
  m0_.transaction_amount AS transaction_amount_4,
  m0_.ref_number AS ref_number_5,
  m0_.short_code AS short_code_6,
  m0_.balance AS balance_7,
  m0_.msisdn AS msisdn_8,
  m0_.first_name AS first_name_9,
  m0_.middle_name AS middle_name_10,
  m0_.last_name AS last_name_11,
  m0_.created_at AS created_at_12,
  m0_.is_used AS is_used_13
FROM
  mpesa m0_
WHERE
  m0_.is_used = 0
  AND m0_.short_code = 4022961
  AND m0_.id IN (?)

SELECT m0_.id AS id_0, m0_.transaction_id AS transaction_id_1, m0_.transaction_type AS transaction_type_2, m0_.transaction_time AS transaction_time_3, m0_.transaction_amount AS transaction_amount_4, m0_.ref_number AS ref_number_5, m0_.short_code AS short_code_6, m0_.balance AS balance_7, m0_.msisdn AS msisdn_8, m0_.first_name AS first_name_9, m0_.middle_name AS middle_name_10, m0_.last_name AS last_name_11, m0_.created_at AS created_at_12, m0_.is_used AS is_used_13 FROM mpesa m0_ WHERE m0_.is_used = 0 AND m0_.short_code = 4022961 AND m0_.id IN ('183440');

SELECT
  t0.id AS id_1,
  t0.transaction_id AS transaction_id_2,
  t0.transaction_type AS transaction_type_3,
  t0.transaction_time AS transaction_time_4,
  t0.transaction_amount AS transaction_amount_5,
  t0.ref_number AS ref_number_6,
  t0.short_code AS short_code_7,
  t0.balance AS balance_8,
  t0.msisdn AS msisdn_9,
  t0.first_name AS first_name_10,
  t0.middle_name AS middle_name_11,
  t0.last_name AS last_name_12,
  t0.created_at AS created_at_13,
  t0.is_used AS is_used_14
FROM
  mpesa t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.transaction_id AS transaction_id_2, t0.transaction_type AS transaction_type_3, t0.transaction_time AS transaction_time_4, t0.transaction_amount AS transaction_amount_5, t0.ref_number AS ref_number_6, t0.short_code AS short_code_7, t0.balance AS balance_8, t0.msisdn AS msisdn_9, t0.first_name AS first_name_10, t0.middle_name AS middle_name_11, t0.last_name AS last_name_12, t0.created_at AS created_at_13, t0.is_used AS is_used_14 FROM mpesa t0 WHERE t0.id = 183440 LIMIT 1;

UPDATE
  mpesa
SET
  is_used = ?
WHERE
  id = ?

UPDATE mpesa SET is_used = 1 WHERE id = 183440;