Symfony Profiler

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

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.id = 118;

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.qty AS qty_3,
  t0.cost AS cost_4,
  t0.price AS price_5,
  t0.update_date AS update_date_6,
  t0.update_by AS update_by_7,
  t0.flag_status AS flag_status_8,
  t0.flag_visibility AS flag_visibility_9,
  t0.branch_id AS branch_id_10,
  t0.product_id AS product_id_11
FROM
  product_branch t0
WHERE
  t0.branch_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.qty AS qty_3, t0.cost AS cost_4, t0.price AS price_5, t0.update_date AS update_date_6, t0.update_by AS update_by_7, t0.flag_status AS flag_status_8, t0.flag_visibility AS flag_visibility_9, t0.branch_id AS branch_id_10, t0.product_id AS product_id_11 FROM product_branch t0 WHERE t0.branch_id = 8 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.price AS price_3,
  t0.qty AS qty_4,
  t0.recieve_qty AS recieve_qty_5,
  t0.flag_status AS flag_status_6,
  t0.product_transfer_id AS product_transfer_id_7,
  t0.product_id AS product_id_8
FROM
  product_transfer_detail t0
WHERE
  t0.product_transfer_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.price AS price_3, t0.qty AS qty_4, t0.recieve_qty AS recieve_qty_5, t0.flag_status AS flag_status_6, t0.product_transfer_id AS product_transfer_id_7, t0.product_id AS product_id_8 FROM product_transfer_detail t0 WHERE t0.product_transfer_id = 23;

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 = '614ff459d2c29' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.lastname AS lastname_4,
  u0_.flag_status AS flag_status_5,
  u0_.id_card_no AS id_card_no_6,
  u0_.pic AS pic_7,
  u0_.address AS address_8,
  u0_.province AS province_9,
  u0_.name AS name_10,
  u0_.ref_id AS ref_id_11,
  u0_.passkey AS passkey_12,
  u0_.branch_id AS branch_id_13,
  u0_.app_role_id AS app_role_id_14
FROM
  user u0_
WHERE
  u0_.branch_id = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.lastname AS lastname_4, u0_.flag_status AS flag_status_5, u0_.id_card_no AS id_card_no_6, u0_.pic AS pic_7, u0_.address AS address_8, u0_.province AS province_9, u0_.name AS name_10, u0_.ref_id AS ref_id_11, u0_.passkey AS passkey_12, u0_.branch_id AS branch_id_13, u0_.app_role_id AS app_role_id_14 FROM user u0_ WHERE u0_.branch_id = 8;

SELECT
  t0.id AS id_1,
  t0.transfer_date AS transfer_date_2,
  t0.transfer_by AS transfer_by_3,
  t0.comment AS comment_4,
  t0.transfer_status AS transfer_status_5,
  t0.receive_date AS receive_date_6,
  t0.ref_id AS ref_id_7,
  t0.move_from_id AS move_from_id_8,
  t0.move_to_id AS move_to_id_9
FROM
  product_transfer t0
WHERE
  t0.move_to_id = ?
  AND t0.transfer_status = ?

SELECT t0.id AS id_1, t0.transfer_date AS transfer_date_2, t0.transfer_by AS transfer_by_3, t0.comment AS comment_4, t0.transfer_status AS transfer_status_5, t0.receive_date AS receive_date_6, t0.ref_id AS ref_id_7, t0.move_from_id AS move_from_id_8, t0.move_to_id AS move_to_id_9 FROM product_transfer t0 WHERE t0.move_to_id = 8 AND t0.transfer_status = 0;

SELECT
  t0.id AS id_1,
  t0.ref_id AS ref_id_2,
  t0.category_name AS category_name_3,
  t0.flag_status AS flag_status_4
FROM
  category t0

SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.category_name AS category_name_3, t0.flag_status AS flag_status_4 FROM category t0;