Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.branch_ref_key AS branch_ref_key_3,
  t0.branch_id AS branch_id_4,
  t0.branch_code AS branch_code_5,
  t0.branch_name AS branch_name_6,
  t0.address AS address_7,
  t0.postel AS postel_8,
  t0.update_by AS update_by_9,
  t0.update_date AS update_date_10,
  t0.flag_status AS flag_status_11,
  t0.flag_show_product_cost AS flag_show_product_cost_12,
  t0.flag_show_product_balance AS flag_show_product_balance_13,
  t0.province_key AS province_key_14
FROM
  branch t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.branch_ref_key AS branch_ref_key_3, t0.branch_id AS branch_id_4, t0.branch_code AS branch_code_5, t0.branch_name AS branch_name_6, t0.address AS address_7, t0.postel AS postel_8, t0.update_by AS update_by_9, t0.update_date AS update_date_10, t0.flag_status AS flag_status_11, t0.flag_show_product_cost AS flag_show_product_cost_12, t0.flag_show_product_balance AS flag_show_product_balance_13, t0.province_key AS province_key_14 FROM branch t0 WHERE t0.ref_id = '62dfab5bc9e6c' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report (
  report_date, total_cost, total_sale,
  ref_id, flag_status, branch_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO sale_report (report_date, total_cost, total_sale, ref_id, flag_status, branch_id) VALUES ('2024-11-16 08:31:43', 6741, 7715, '6738a10566f88', 1, 16);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fc49413' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (106, 128, NULL, 0.74, 1, 9726, 4);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.ref_id AS ref_id_1,
  p0_.qty AS qty_2,
  p0_.cost AS cost_3,
  p0_.price AS price_4,
  p0_.update_date AS update_date_5,
  p0_.update_by AS update_by_6,
  p0_.flag_status AS flag_status_7,
  p0_.flag_visibility AS flag_visibility_8,
  p0_.branch_id AS branch_id_9,
  p0_.product_id AS product_id_10
FROM
  product_branch p0_
WHERE
  p0_.branch_id = ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = 16 AND p0_.product_id = 4;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -4072.03 WHERE id = 1591;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fc4c01b' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (105, 126, NULL, 1.39, 1, 9726, 7);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.ref_id AS ref_id_1,
  p0_.qty AS qty_2,
  p0_.cost AS cost_3,
  p0_.price AS price_4,
  p0_.update_date AS update_date_5,
  p0_.update_by AS update_by_6,
  p0_.flag_status AS flag_status_7,
  p0_.flag_visibility AS flag_visibility_8,
  p0_.branch_id AS branch_id_9,
  p0_.product_id AS product_id_10
FROM
  product_branch p0_
WHERE
  p0_.branch_id = ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = 16 AND p0_.product_id = 7;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -2077.91 WHERE id = 1594;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fc9349d' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (125, 140, NULL, 9.23, 1, 9726, 65);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.ref_id AS ref_id_1,
  p0_.qty AS qty_2,
  p0_.cost AS cost_3,
  p0_.price AS price_4,
  p0_.update_date AS update_date_5,
  p0_.update_by AS update_by_6,
  p0_.flag_status AS flag_status_7,
  p0_.flag_visibility AS flag_visibility_8,
  p0_.branch_id AS branch_id_9,
  p0_.product_id AS product_id_10
FROM
  product_branch p0_
WHERE
  p0_.branch_id = ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = 16 AND p0_.product_id = 17;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -4071.15 WHERE id = 1604;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fc85655' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (113, 133, NULL, 10.76, 1, 9726, 58);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.ref_id AS ref_id_1,
  p0_.qty AS qty_2,
  p0_.cost AS cost_3,
  p0_.price AS price_4,
  p0_.update_date AS update_date_5,
  p0_.update_by AS update_by_6,
  p0_.flag_status AS flag_status_7,
  p0_.flag_visibility AS flag_visibility_8,
  p0_.branch_id AS branch_id_9,
  p0_.product_id AS product_id_10
FROM
  product_branch p0_
WHERE
  p0_.branch_id = ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = 16 AND p0_.product_id = 3;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -7824.42 WHERE id = 1590;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fca451a' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (106, 123, NULL, 4.31, 1, 9726, 75);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.ref_id AS ref_id_1,
  p0_.qty AS qty_2,
  p0_.cost AS cost_3,
  p0_.price AS price_4,
  p0_.update_date AS update_date_5,
  p0_.update_by AS update_by_6,
  p0_.flag_status AS flag_status_7,
  p0_.flag_visibility AS flag_visibility_8,
  p0_.branch_id AS branch_id_9,
  p0_.product_id AS product_id_10
FROM
  product_branch p0_
WHERE
  p0_.branch_id = ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = 16 AND p0_.product_id = 4;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -4076.34 WHERE id = 1591;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fc81a19' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (134, 151, NULL, 14.6, 1, 9726, 56);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.ref_id AS ref_id_1,
  p0_.qty AS qty_2,
  p0_.cost AS cost_3,
  p0_.price AS price_4,
  p0_.update_date AS update_date_5,
  p0_.update_by AS update_by_6,
  p0_.flag_status AS flag_status_7,
  p0_.flag_visibility AS flag_visibility_8,
  p0_.branch_id AS branch_id_9,
  p0_.product_id AS product_id_10
FROM
  product_branch p0_
WHERE
  p0_.branch_id = ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = 16 AND p0_.product_id = 5;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -3766.21 WHERE id = 1592;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fca3248' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (64, 79, NULL, 0.97, 1, 9726, 74);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.ref_id AS ref_id_1,
  p0_.qty AS qty_2,
  p0_.cost AS cost_3,
  p0_.price AS price_4,
  p0_.update_date AS update_date_5,
  p0_.update_by AS update_by_6,
  p0_.flag_status AS flag_status_7,
  p0_.flag_visibility AS flag_visibility_8,
  p0_.branch_id AS branch_id_9,
  p0_.product_id AS product_id_10
FROM
  product_branch p0_
WHERE
  p0_.branch_id = ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.ref_id AS ref_id_1, p0_.qty AS qty_2, p0_.cost AS cost_3, p0_.price AS price_4, p0_.update_date AS update_date_5, p0_.update_by AS update_by_6, p0_.flag_status AS flag_status_7, p0_.flag_visibility AS flag_visibility_8, p0_.branch_id AS branch_id_9, p0_.product_id AS product_id_10 FROM product_branch p0_ WHERE p0_.branch_id = 16 AND p0_.product_id = 90;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -345.22 WHERE id = 1637;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.product_name AS product_name_3,
  t0.model AS model_4,
  t0.barcode_no AS barcode_no_5,
  t0.comment AS comment_6,
  t0.qty AS qty_7,
  t0.update_by AS update_by_8,
  t0.update_date AS update_date_9,
  t0.flag_status AS flag_status_10,
  t0.flag_visibility AS flag_visibility_11,
  t0.cost AS cost_12,
  t0.sale_price AS sale_price_13,
  t0.unit AS unit_14,
  t0.is_join AS is_join_15,
  t0.join_with_product AS join_with_product_16,
  t0.sort_index AS sort_index_17,
  t0.is_favorite AS is_favorite_18,
  t0.category_id AS category_id_19,
  t0.sale_type_id AS sale_type_id_20
FROM
  product t0
WHERE
  t0.ref_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.product_name AS product_name_3, t0.model AS model_4, t0.barcode_no AS barcode_no_5, t0.comment AS comment_6, t0.qty AS qty_7, t0.update_by AS update_by_8, t0.update_date AS update_date_9, t0.flag_status AS flag_status_10, t0.flag_visibility AS flag_visibility_11, t0.cost AS cost_12, t0.sale_price AS sale_price_13, t0.unit AS unit_14, t0.is_join AS is_join_15, t0.join_with_product AS join_with_product_16, t0.sort_index AS sort_index_17, t0.is_favorite AS is_favorite_18, t0.category_id AS category_id_19, t0.sale_type_id AS sale_type_id_20 FROM product t0 WHERE t0.ref_id = '6178c3fc9aed1' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sale_report_detail (
  cost, price, vat, qty, flag_status,
  sale_report_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sale_report_detail (cost, price, vat, qty, flag_status, sale_report_id, product_id) VALUES (95, 110, NULL, 0.98, 1, 9726, 69);

"COMMIT"

"COMMIT";