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 = '61496139bd592' 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 16:33:21', 7531, 8833, '67377a487d671', 1, 5);

"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 = '6178c3fc460db' 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.32, 1, 9721, 1);

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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -6924.63 WHERE id = 285;

"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, 5.32, 1, 9721, 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 = 5 AND p0_.product_id = 5;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -7223.52 WHERE id = 299;

"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, 0.83, 1, 9721, 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 = 5 AND p0_.product_id = 8;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -11983.62 WHERE id = 797;

"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, 0.81, 1, 9721, 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 = 5 AND p0_.product_id = 17;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -887.45 WHERE id = 327;

"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, 1.23, 1, 9721, 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 = 5 AND p0_.product_id = 4;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -8825.43 WHERE id = 804;

"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 = '6178c3fcbea6b' 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, 167, NULL, 0.16, 1, 9721, 96);

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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -1347.94 WHERE id = 467;

"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 = '6178c3fc5610a' 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, 145, NULL, 1.11, 1, 9721, 17);

"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 = 5 AND p0_.product_id = 17;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_branch
SET
  qty = ?
WHERE
  id = ?

UPDATE product_branch SET qty = -888.56 WHERE id = 327;

"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, 0.65, 1, 9721, 7);

"COMMIT"

"COMMIT";