Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.bar_code AS bar_code_3,
  t0.weight AS weight_4,
  t0.net_weight AS net_weight_5,
  t0.image_url AS image_url_6,
  t0.brand AS brand_7,
  t0.counts AS counts_8,
  t0.price AS price_9,
  t0.section AS section_10,
  t0.total_count AS total_count_11,
  t0.min_product AS min_product_12,
  t0.max_product AS max_product_13,
  t0.expiring_offset AS expiring_offset_14,
  t0.is_sensitive AS is_sensitive_15,
  t0.deleted_at AS deleted_at_16,
  t0.out_of_stock_date AS out_of_stock_date_17,
  t0.updatable_id AS updatable_id_18
FROM
  product t0
  INNER JOIN scale_product ON t0.id = scale_product.product_id
WHERE
  scale_product.scale_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.bar_code AS bar_code_3, t0.weight AS weight_4, t0.net_weight AS net_weight_5, t0.image_url AS image_url_6, t0.brand AS brand_7, t0.counts AS counts_8, t0.price AS price_9, t0.section AS section_10, t0.total_count AS total_count_11, t0.min_product AS min_product_12, t0.max_product AS max_product_13, t0.expiring_offset AS expiring_offset_14, t0.is_sensitive AS is_sensitive_15, t0.deleted_at AS deleted_at_16, t0.out_of_stock_date AS out_of_stock_date_17, t0.updatable_id AS updatable_id_18 FROM product t0 INNER JOIN scale_product ON t0.id = scale_product.product_id WHERE scale_product.scale_id = 0x1F0D1D63EF646496A16D99EE270BEE8F;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.serial_number AS serial_number_3,
  t0.version AS version_4,
  t0.mode AS mode_5,
  t0.last_connected_at AS last_connected_at_6
FROM
  `board` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.serial_number AS serial_number_3, t0.version AS version_4, t0.mode AS mode_5, t0.last_connected_at AS last_connected_at_6 FROM `board` t0 WHERE t0.id = 0x1F0D1D612E116BBAA7C4BB38D7FA354A;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.suspicious_events AS suspicious_events_2,
  t0.restock AS restock_3,
  t0.total AS total_4,
  t0.events AS events_5,
  t0.stable_product_count AS stable_product_count_6,
  t0.stable_product_count_updated_at AS stable_product_count_updated_at_7,
  t0.scale_id AS scale_id_8,
  t0.product_id AS product_id_9
FROM
  scale_product_count t0
WHERE
  t0.scale_id = ?

SELECT t0.id AS id_1, t0.suspicious_events AS suspicious_events_2, t0.restock AS restock_3, t0.total AS total_4, t0.events AS events_5, t0.stable_product_count AS stable_product_count_6, t0.stable_product_count_updated_at AS stable_product_count_updated_at_7, t0.scale_id AS scale_id_8, t0.product_id AS product_id_9 FROM scale_product_count t0 WHERE t0.scale_id = 0x1F0D1D63EF646496A16D99EE270BEE8F;

SELECT
  t0.id AS id_1,
  t0.password AS password_2,
  t0.email AS email_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.roles AS roles_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.last_connected_at AS last_connected_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.password AS password_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.roles AS roles_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connected_at AS last_connected_at_9, t0.deleted_at AS deleted_at_10 FROM user t0 WHERE t0.email = 'TEST' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.scale_order AS scale_order_2,
  t0.weight AS weight_3,
  t0.port_index AS port_index_4,
  t0.last_update AS last_update_5,
  t0.board_id AS board_id_6,
  t0.shelf_id AS shelf_id_7
FROM
  scale t0
WHERE
  t0.board_id = ?

SELECT t0.id AS id_1, t0.scale_order AS scale_order_2, t0.weight AS weight_3, t0.port_index AS port_index_4, t0.last_update AS last_update_5, t0.board_id AS board_id_6, t0.shelf_id AS shelf_id_7 FROM scale t0 WHERE t0.board_id = 0x1F0D1D612E116BBAA7C4BB38D7FA354A;

UPDATE
  scale
SET
  weight = ?,
  last_update = ?
WHERE
  id = ?

UPDATE scale SET weight = 191, last_update = '2026-01-24 20:49:31' WHERE id = 0x1F0D1D63EF646496A16D99EE270BEE8F;

UPDATE
  `board`
SET
  last_connected_at = ?
WHERE
  id = ?

UPDATE `board` SET last_connected_at = '2026-01-24 20:49:31' WHERE id = 0x1F0D1D612E116BBAA7C4BB38D7FA354A;

SELECT
  t0.id AS id_1,
  t0.aisle AS aisle_2,
  t0.position AS position_3,
  t0.storey AS storey_4,
  t0.section AS section_5
FROM
  shelf t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.aisle AS aisle_2, t0.position AS position_3, t0.storey AS storey_4, t0.section AS section_5 FROM shelf t0 WHERE t0.id = 0x1F0D5126184C6D5E872E719DB673F588;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.serial_number AS serial_number_3,
  t0.version AS version_4,
  t0.mode AS mode_5,
  t0.last_connected_at AS last_connected_at_6
FROM
  `board` t0
WHERE
  t0.serial_number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.serial_number AS serial_number_3, t0.version AS version_4, t0.mode AS mode_5, t0.last_connected_at AS last_connected_at_6 FROM `board` t0 WHERE t0.serial_number = 'TEST' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.suspicious_events AS suspicious_events_1,
  s0_.restock AS restock_2,
  s0_.total AS total_3,
  s0_.events AS events_4,
  s0_.stable_product_count AS stable_product_count_5,
  s0_.stable_product_count_updated_at AS stable_product_count_updated_at_6,
  s0_.scale_id AS scale_id_7,
  s0_.product_id AS product_id_8
FROM
  scale_product_count s0_
WHERE
  s0_.id = ? FOR
UPDATE

SELECT s0_.id AS id_0, s0_.suspicious_events AS suspicious_events_1, s0_.restock AS restock_2, s0_.total AS total_3, s0_.events AS events_4, s0_.stable_product_count AS stable_product_count_5, s0_.stable_product_count_updated_at AS stable_product_count_updated_at_6, s0_.scale_id AS scale_id_7, s0_.product_id AS product_id_8 FROM scale_product_count s0_ WHERE s0_.id = '019bc7a8-c5ab-71c3-85f7-d37c84b68332' FOR UPDATE;

SELECT
  COALESCE(
    SUM(
      COALESCE(stable_product_count, total)
    ),
    0
  ) as total
FROM
  scale_product_count
WHERE
  product_id = ?

SELECT COALESCE(SUM(COALESCE(stable_product_count, total)), 0) as total 
                        FROM scale_product_count 
                        WHERE product_id = 0x019BC7A42F2B77C6B18C76D8FFA27D70;

SELECT
  t0.id AS id_1,
  t0.scale_order AS scale_order_2,
  t0.weight AS weight_3,
  t0.port_index AS port_index_4,
  t0.last_update AS last_update_5,
  t0.board_id AS board_id_6,
  t0.shelf_id AS shelf_id_7
FROM
  scale t0
WHERE
  t0.shelf_id = ?

SELECT t0.id AS id_1, t0.scale_order AS scale_order_2, t0.weight AS weight_3, t0.port_index AS port_index_4, t0.last_update AS last_update_5, t0.board_id AS board_id_6, t0.shelf_id AS shelf_id_7 FROM scale t0 WHERE t0.shelf_id = 0x1F0D5126184C6D5E872E719DB673F588;

"START TRANSACTION"

"START TRANSACTION";

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

SELECT
  t0.id AS id_1,
  t0.suspicious_events AS suspicious_events_2,
  t0.restock AS restock_3,
  t0.total AS total_4,
  t0.events AS events_5,
  t0.stable_product_count AS stable_product_count_6,
  t0.stable_product_count_updated_at AS stable_product_count_updated_at_7,
  t0.scale_id AS scale_id_8,
  t0.product_id AS product_id_9
FROM
  scale_product_count t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.suspicious_events AS suspicious_events_2, t0.restock AS restock_3, t0.total AS total_4, t0.events AS events_5, t0.stable_product_count AS stable_product_count_6, t0.stable_product_count_updated_at AS stable_product_count_updated_at_7, t0.scale_id AS scale_id_8, t0.product_id AS product_id_9 FROM scale_product_count t0 WHERE t0.product_id = 0x019BC7A42F2B77C6B18C76D8FFA27D70;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;