Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.locale AS locale_6,
  t0.username AS username_7,
  t0.fullname AS fullname_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.locale AS locale_6, t0.username AS username_7, t0.fullname AS fullname_8 FROM user t0 WHERE t0.id = 26;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.logo AS logo_4,
  t0.email AS email_5,
  t0.email_password AS email_password_6,
  t0.email_smtp_host AS email_smtp_host_7,
  t0.email_smtp_port AS email_smtp_port_8,
  t0.invoice_number_counter AS invoice_number_counter_9,
  t0.is_maintenance_mode AS is_maintenance_mode_10,
  t0.currency AS currency_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.u_date AS u_date_16
FROM
  settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.logo AS logo_4, t0.email AS email_5, t0.email_password AS email_password_6, t0.email_smtp_host AS email_smtp_host_7, t0.email_smtp_port AS email_smtp_port_8, t0.invoice_number_counter AS invoice_number_counter_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.currency AS currency_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.u_date AS u_date_16 FROM settings t0 LIMIT 1;

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  sales s0_
  LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id
  LEFT JOIN user u2_ ON s0_.seller_id = u2_.id
  LEFT JOIN product p3_ ON p1_.product_id = p3_.id
  LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id
  LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id
  LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id
WHERE
  (
    s0_.deleted = ?
    OR s0_.deleted IS NULL
  )
  AND s0_.visible = ?
  AND w4_.id = ?

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sales s0_ LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id LEFT JOIN user u2_ ON s0_.seller_id = u2_.id LEFT JOIN product p3_ ON p1_.product_id = p3_.id LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id WHERE (s0_.deleted = 0 OR s0_.deleted IS NULL) AND s0_.visible = 1 AND w4_.id = '7';

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  sales s0_
  LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id
  LEFT JOIN user u2_ ON s0_.seller_id = u2_.id
  LEFT JOIN product p3_ ON p1_.product_id = p3_.id
  LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id
  LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id
  LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id
WHERE
  (
    s0_.deleted = ?
    OR s0_.deleted IS NULL
  )
  AND s0_.visible = ?
  AND w4_.id = ?
ORDER BY
  s0_.id DESC
LIMIT
  25

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM sales s0_ LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id LEFT JOIN user u2_ ON s0_.seller_id = u2_.id LEFT JOIN product p3_ ON p1_.product_id = p3_.id LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id WHERE (s0_.deleted = 0 OR s0_.deleted IS NULL) AND s0_.visible = 1 AND w4_.id = '7' ORDER BY s0_.id DESC LIMIT 25;

SELECT
  s0_.id AS id_0,
  s0_.invoice_number AS invoice_number_1,
  s0_.total_purchase_price AS total_purchase_price_2,
  s0_.sales_date AS sales_date_3,
  s0_.delivery_date AS delivery_date_4,
  s0_.due_date AS due_date_5,
  s0_.valid_date AS valid_date_6,
  s0_.description AS description_7,
  s0_.shipping_notes AS shipping_notes_8,
  s0_.payment_notes AS payment_notes_9,
  s0_.status AS status_10,
  s0_.visible AS visible_11,
  s0_.deleted AS deleted_12,
  s0_.created_at AS created_at_13,
  s0_.updated_at AS updated_at_14,
  s0_.created_by AS created_by_15,
  s0_.updated_by AS updated_by_16,
  s0_.u_date AS u_date_17,
  s0_.seller_id AS seller_id_18,
  s0_.warehouse_id AS warehouse_id_19,
  s0_.customer_id AS customer_id_20,
  s0_.invoice_id AS invoice_id_21
FROM
  sales s0_
  LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id
  LEFT JOIN user u2_ ON s0_.seller_id = u2_.id
  LEFT JOIN product p3_ ON p1_.product_id = p3_.id
  LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id
  LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id
  LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id
WHERE
  (
    s0_.deleted = ?
    OR s0_.deleted IS NULL
  )
  AND s0_.visible = ?
  AND w4_.id = ?
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_purchase_price AS total_purchase_price_2, s0_.sales_date AS sales_date_3, s0_.delivery_date AS delivery_date_4, s0_.due_date AS due_date_5, s0_.valid_date AS valid_date_6, s0_.description AS description_7, s0_.shipping_notes AS shipping_notes_8, s0_.payment_notes AS payment_notes_9, s0_.status AS status_10, s0_.visible AS visible_11, s0_.deleted AS deleted_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14, s0_.created_by AS created_by_15, s0_.updated_by AS updated_by_16, s0_.u_date AS u_date_17, s0_.seller_id AS seller_id_18, s0_.warehouse_id AS warehouse_id_19, s0_.customer_id AS customer_id_20, s0_.invoice_id AS invoice_id_21 FROM sales s0_ LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id LEFT JOIN user u2_ ON s0_.seller_id = u2_.id LEFT JOIN product p3_ ON p1_.product_id = p3_.id LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id WHERE (s0_.deleted = 0 OR s0_.deleted IS NULL) AND s0_.visible = 1 AND w4_.id = '7' AND s0_.id IN (1764, 1763, 1762, 1761, 1760, 1759, 1758, 1757, 1756, 1755, 1754, 1753, 1752, 1751, 1750, 1749, 1748, 1747, 1746, 1745, 1744, 1743, 1742, 1741, 1740) ORDER BY s0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 104;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.locale AS locale_6,
  t0.username AS username_7,
  t0.fullname AS fullname_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.locale AS locale_6, t0.username AS username_7, t0.fullname AS fullname_8 FROM user t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1764;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1782;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.locale AS locale_6,
  t0.username AS username_7,
  t0.fullname AS fullname_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.locale AS locale_6, t0.username AS username_7, t0.fullname AS fullname_8 FROM user t0 WHERE t0.id = 25;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1763;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1781;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1762;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1780;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1761;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1078;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1760;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1779;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.locale AS locale_6,
  t0.username AS username_7,
  t0.fullname AS fullname_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.locale AS locale_6, t0.username AS username_7, t0.fullname AS fullname_8 FROM user t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1759;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1778;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1758;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1757;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1296;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1756;