Symfony Profiler

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 = ?
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 = 102 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 = ?
  AND t0.is_closed = ?
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 = 102 AND t0.is_closed = 0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.created_at AS created_at_3,
  t0.user AS user_4,
  t0.station_id AS station_id_5
FROM
  user_station t0
WHERE
  t0.user = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.station_id AS station_id_5 FROM user_station t0 WHERE t0.user = 102 ORDER BY t0.id DESC LIMIT 1;

SELECT
  w0_.id AS id_0,
  w0_.sender_name AS sender_name_1,
  w0_.sender_phone_number AS sender_phone_number_2,
  w0_.receiver_name AS receiver_name_3,
  w0_.receiver_phone_number AS receiver_phone_number_4,
  w0_.created_at AS created_at_5,
  w0_.is_collected AS is_collected_6,
  w0_.is_received AS is_received_7,
  w0_.received_at AS received_at_8,
  w0_.percel_count AS percel_count_9,
  w0_.longitude AS longitude_10,
  w0_.latitude AS latitude_11,
  w0_.parcel_value AS parcel_value_12,
  w0_.from_station_id AS from_station_id_13,
  w0_.to_station_id AS to_station_id_14,
  w0_.created_by AS created_by_15,
  w0_.received_by AS received_by_16,
  w0_.organization_id AS organization_id_17
FROM
  way_bill w0_
  INNER JOIN transaction t1_ ON w0_.id = t1_.way_bill_id
WHERE
  w0_.from_station_id = ?
ORDER BY
  w0_.id DESC
LIMIT
  20

SELECT w0_.id AS id_0, w0_.sender_name AS sender_name_1, w0_.sender_phone_number AS sender_phone_number_2, w0_.receiver_name AS receiver_name_3, w0_.receiver_phone_number AS receiver_phone_number_4, w0_.created_at AS created_at_5, w0_.is_collected AS is_collected_6, w0_.is_received AS is_received_7, w0_.received_at AS received_at_8, w0_.percel_count AS percel_count_9, w0_.longitude AS longitude_10, w0_.latitude AS latitude_11, w0_.parcel_value AS parcel_value_12, w0_.from_station_id AS from_station_id_13, w0_.to_station_id AS to_station_id_14, w0_.created_by AS created_by_15, w0_.received_by AS received_by_16, w0_.organization_id AS organization_id_17 FROM way_bill w0_ INNER JOIN transaction t1_ ON w0_.id = t1_.way_bill_id WHERE w0_.from_station_id = 17 ORDER BY w0_.id DESC LIMIT 20;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1060628;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1060551;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1060359;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1059588;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1058903;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1058895;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1058848;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1058639;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.is_consignee AS is_consignee_2,
  t0.consignee_national_id AS consignee_national_id_3,
  t0.collector_name AS collector_name_4,
  t0.national_id AS national_id_5,
  t0.created_at AS created_at_6,
  t0.waybill_id AS waybill_id_7,
  t0.created_by AS created_by_8
FROM
  collected_parcel t0
WHERE
  t0.waybill_id = ?

SELECT t0.id AS id_1, t0.is_consignee AS is_consignee_2, t0.consignee_national_id AS consignee_national_id_3, t0.collector_name AS collector_name_4, t0.national_id AS national_id_5, t0.created_at AS created_at_6, t0.waybill_id AS waybill_id_7, t0.created_by AS created_by_8 FROM collected_parcel t0 WHERE t0.waybill_id = 1058606;