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 = '62afbdd6e1a88' 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-15 11:46:12', 7887, 9266, '67373ec5b070a', 1, 15);

"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 = '6178c3fcc0495' 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 (127, 162, NULL, 3.13, 1, 9714, 97);

"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 = 15 AND p0_.product_id = 96;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -3774.62 WHERE id = 1560;

"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 = '6178c3fc788de' 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 (65, 85, NULL, 1, 1, 9714, 50);

"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 = 15 AND p0_.product_id = 50;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -122 WHERE id = 1548;

"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, 6.69, 1, 9714, 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 = 15 AND p0_.product_id = 4;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -6550.85 WHERE id = 1511;

"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, 6.23, 1, 9714, 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 = 15 AND p0_.product_id = 5;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -2361.51 WHERE id = 1512;

"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 = '6178c3fc83823' 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 (140, 159, NULL, 13, 1, 9714, 57);

"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 = 15 AND p0_.product_id = 8;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -11059.74 WHERE id = 1515;

"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 = '617eaa9829bf3' 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 (110, 140, NULL, 1, 1, 9714, 124);

"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 = 15 AND p0_.product_id = 124;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -264 WHERE id = 1576;

"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, 11.24, 1, 9714, 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 = 15 AND p0_.product_id = 3;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -10138.75 WHERE id = 1510;

"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 = '6178c3fc87226' 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, 121, NULL, 1.61, 1, 9714, 59);

"COMMIT"

"COMMIT";