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

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;

UPDATE
  scale_product_count
SET
  stable_product_count_updated_at = ?
WHERE
  id = ?

UPDATE scale_product_count SET stable_product_count_updated_at = '2025-12-06T05:44:31+00:00' WHERE id = 0x1F0CC6E0729069F8ADCBE5C30CA9D2EE;

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

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 = '1f0cb9e0-23f9-648c-9690-6f354a7a2d01' AND (s1_.weight IS NULL OR s1_.weight <> 0);

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

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";

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;

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

UPDATE scale SET weight = 1217, last_update = '2025-12-06 05:44:31' WHERE id = 0x1F0CC5F54FA56506903FA116253870FF;

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

UPDATE `board` SET last_connected_at = '2025-12-06 05:44:31' WHERE id = 0x1F0CB91DCD346E169BD5AD196E6CF814;

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;

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

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";