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 = 0x1F0CBAC58EE46BD0A63803645F2B4DCB;

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 = 0x1F0CB91DCD346E169BD5AD196E6CF814;

SELECT
  s0_.stable_product_count AS stable_product_count_0,
  s0_.total AS total_1
FROM
  scale_product_count s0_
  LEFT JOIN scale s1_ ON s0_.scale_id = s1_.id
WHERE
  s0_.product_id = ?
  AND (
    s1_.weight IS NULL
    OR s1_.weight <> 0
  )

SELECT s0_.stable_product_count AS stable_product_count_0, s0_.total AS total_1 FROM scale_product_count s0_ LEFT JOIN scale s1_ ON s0_.scale_id = s1_.id WHERE s0_.product_id = '1f0cb9df-3ebd-64fe-87de-b73c876eb90f' AND (s1_.weight IS NULL OR s1_.weight <> 0);

UPDATE
  scale_product_count
SET
  stable_product_count_updated_at = ?
WHERE
  id = ?

UPDATE scale_product_count SET stable_product_count_updated_at = '2025-12-06T03:15:38+00:00' WHERE id = 0x1F0CC6DF8E7161B4A82BC1CA0FF4CB1B;

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 = 0x1F0CBAC58EE46BD0A63803645F2B4DCB;

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

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 = 0x1F0CB91DCD346E169BD5AD196E6CF814;

"COMMIT"

"COMMIT";

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

UPDATE `board` SET last_connected_at = '2025-12-06 03:15:38' WHERE id = 0x1F0CB91DCD346E169BD5AD196E6CF814;

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 = 'SN3TG1ET2' 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 = ?
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 = 'SN3TG1ET2' LIMIT 1;

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 = 0x1F0CB9DF3EBD64FE87DEB73C876EB90F;

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 = 0x1F0CC6DEE78C61FA8E8C41343EB912B7;

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

UPDATE scale SET weight = 530, last_update = '2025-12-06 03:15:38' WHERE id = 0x1F0CBAC58EE46BD0A63803645F2B4DCB;

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 = 0x1F0CC6DEE78C61FA8E8C41343EB912B7;

"START TRANSACTION"

"START TRANSACTION";