Symfony Profiler

"COMMIT"

"COMMIT";

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

UPDATE transaction SET cash_amount = 200, is_paid = 1, paid_by = 'sender', payment_method = 'CASH' WHERE id = 950754;

SELECT
  t0.id AS id_1,
  t0.drawer_cash AS drawer_cash_2,
  t0.account_date AS account_date_3,
  t0.is_closed AS is_closed_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.station_daily_account AS station_daily_account_7,
  t0.closed_by AS closed_by_8
FROM
  daily_account t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.drawer_cash AS drawer_cash_2, t0.account_date AS account_date_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.station_daily_account AS station_daily_account_7, t0.closed_by AS closed_by_8 FROM daily_account t0 WHERE t0.user_id = 109 ORDER BY t0.id DESC 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 = '950795' 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 = ?
  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 = 2 AND t0.auth_type = 'PROD' LIMIT 1;

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 = 109;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.number AS number_3,
  t0.is_in_delivery AS is_in_delivery_4,
  t0.created_at AS created_at_5,
  t0.way_bill_id AS way_bill_id_6
FROM
  parcel t0
WHERE
  t0.way_bill_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.number AS number_3, t0.is_in_delivery AS is_in_delivery_4, t0.created_at AS created_at_5, t0.way_bill_id AS way_bill_id_6 FROM parcel t0 WHERE t0.way_bill_id = '950795';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.client AS client_3,
  t0.supplier_code AS supplier_code_4,
  t0.created_at AS created_at_5,
  t0.station AS station_6
FROM
  tims_station t0
WHERE
  t0.station = ?
  AND t0.client = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.client AS client_3, t0.supplier_code AS supplier_code_4, t0.created_at AS created_at_5, t0.station AS station_6 FROM tims_station t0 WHERE t0.station = 2 AND t0.client = 'WEB' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.amount AS amount_3,
  t0.sms AS sms_4,
  t0.recepient AS recepient_5,
  t0.created_at AS created_at_6,
  t0.status_code AS status_code_7,
  t0.manually_sent AS manually_sent_8,
  t0.action AS action_9,
  t0.message_id AS message_id_10,
  t0.transaction_id AS transaction_id_11,
  t0.organization_id AS organization_id_12,
  t0.created_by AS created_by_13
FROM
  sms t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.amount AS amount_3, t0.sms AS sms_4, t0.recepient AS recepient_5, t0.created_at AS created_at_6, t0.status_code AS status_code_7, t0.manually_sent AS manually_sent_8, t0.action AS action_9, t0.message_id AS message_id_10, t0.transaction_id AS transaction_id_11, t0.organization_id AS organization_id_12, t0.created_by AS created_by_13 FROM sms t0 WHERE t0.transaction_id = 950754;