Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.transaction_type AS transaction_type_2,
  t0.transaction_id AS transaction_id_3,
  t0.transaction_time AS transaction_time_4,
  t0.transaction_amount AS transaction_amount_5,
  t0.short_code AS short_code_6,
  t0.bill_reference_number AS bill_reference_number_7,
  t0.invoice_number AS invoice_number_8,
  t0.account_balance AS account_balance_9,
  t0.third_party_transaction_id AS third_party_transaction_id_10,
  t0.msisdn AS msisdn_11,
  t0.first_name AS first_name_12,
  t0.middle_name AS middle_name_13,
  t0.last_name AS last_name_14,
  t0.is_complete AS is_complete_15,
  t0.created_at AS created_at_16,
  t0.is_used AS is_used_17,
  t0.is_seen AS is_seen_18,
  t0.read_at AS read_at_19,
  t0.used_at AS used_at_20,
  t0.completed_at AS completed_at_21,
  t0.seen_from_ip AS seen_from_ip_22,
  t0.mpesa_from_ip AS mpesa_from_ip_23,
  t0.completed_mpesa_from_ip AS completed_mpesa_from_ip_24,
  t0.is_validated AS is_validated_25
FROM
  neema.mpesa_transaction_verification t0
WHERE
  t0.transaction_id = ?
ORDER BY
  (
    SELECT
      0
  ) OFFSET 0
ROWS
  FETCH NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.transaction_type AS transaction_type_2, t0.transaction_id AS transaction_id_3, t0.transaction_time AS transaction_time_4, t0.transaction_amount AS transaction_amount_5, t0.short_code AS short_code_6, t0.bill_reference_number AS bill_reference_number_7, t0.invoice_number AS invoice_number_8, t0.account_balance AS account_balance_9, t0.third_party_transaction_id AS third_party_transaction_id_10, t0.msisdn AS msisdn_11, t0.first_name AS first_name_12, t0.middle_name AS middle_name_13, t0.last_name AS last_name_14, t0.is_complete AS is_complete_15, t0.created_at AS created_at_16, t0.is_used AS is_used_17, t0.is_seen AS is_seen_18, t0.read_at AS read_at_19, t0.used_at AS used_at_20, t0.completed_at AS completed_at_21, t0.seen_from_ip AS seen_from_ip_22, t0.mpesa_from_ip AS mpesa_from_ip_23, t0.completed_mpesa_from_ip AS completed_mpesa_from_ip_24, t0.is_validated AS is_validated_25 FROM neema.mpesa_transaction_verification t0 WHERE t0.transaction_id = 'TEA56MY7E7' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO neema.mpesa_transaction (
  transaction_type, transaction_id,
  transaction_time, transaction_amount,
  short_code, bill_reference_number,
  invoice_number, account_balance,
  third_party_transaction_id, msisdn,
  first_name, middle_name, last_name,
  is_complete, created_at, is_used,
  is_seen, read_at, used_at, completed_at,
  seen_from_ip, mpesa_from_ip, completed_mpesa_from_ip,
  is_validated
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO neema.mpesa_transaction (transaction_type, transaction_id, transaction_time, transaction_amount, short_code, bill_reference_number, invoice_number, account_balance, third_party_transaction_id, msisdn, first_name, middle_name, last_name, is_complete, created_at, is_used, is_seen, read_at, used_at, completed_at, seen_from_ip, mpesa_from_ip, completed_mpesa_from_ip, is_validated) VALUES ('Customer Merchant Payment', 'TEA56MY7E7', '2025-05-10 14:45:39.000000', 300, 7256331, '', NULL, 4077.45, NULL, '254743349983', 'sarah', 'wangui', 'riungu', 1, '2025-05-10 11:45:40.955705', 0, 0, NULL, NULL, NULL, NULL, NULL, '196.201.214.200', 1);

"COMMIT"

"COMMIT";