Symfony Profiler

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

INSERT INTO event (
  id, location, created_at, alert_types,
  difference_weight, difference_product,
  total_after_by_location, total_after_global,
  product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO event (id, location, created_at, alert_types, difference_weight, difference_product, total_after_by_location, total_after_global, product_id) VALUES (0x1F0D26B05DD8679CA23AABB81CBF1069, '{\"aisle\":\"1\",\"position\":\"1\",\"storey\":\"4\",\"section\":1}', '2025-12-06 06:15:54', '[]', -848, -2, 10, 10, 0x1F0CB9D784B568608DB585354B4187A7);

SELECT
  e0_.id AS id_0,
  e0_.location AS location_1,
  e0_.created_at AS created_at_2,
  e0_.alert_types AS alert_types_3,
  e0_.difference_weight AS difference_weight_4,
  e0_.difference_product AS difference_product_5,
  e0_.total_after_by_location AS total_after_by_location_6,
  e0_.total_after_global AS total_after_global_7,
  e0_.product_id AS product_id_8
FROM
  event e0_
WHERE
  e0_.product_id = ?
  AND e0_.created_at >= ?
  AND JSON_UNQUOTE(
    JSON_EXTRACT(e0_.location, '$.aisle')
  ) = ?
  AND JSON_UNQUOTE(
    JSON_EXTRACT(e0_.location, '$.position')
  ) = ?
  AND JSON_UNQUOTE(
    JSON_EXTRACT(e0_.location, '$.storey')
  ) = ?
  AND JSON_UNQUOTE(
    JSON_EXTRACT(e0_.location, '$.section')
  ) = ?
ORDER BY
  e0_.created_at DESC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.location AS location_1, e0_.created_at AS created_at_2, e0_.alert_types AS alert_types_3, e0_.difference_weight AS difference_weight_4, e0_.difference_product AS difference_product_5, e0_.total_after_by_location AS total_after_by_location_6, e0_.total_after_global AS total_after_global_7, e0_.product_id AS product_id_8 FROM event e0_ WHERE e0_.product_id = 0x1F0CB9D784B568608DB585354B4187A7 AND e0_.created_at >= '2025-12-06 06:14:54' AND JSON_UNQUOTE(JSON_EXTRACT(e0_.location, '$.aisle')) = '1' AND JSON_UNQUOTE(JSON_EXTRACT(e0_.location, '$.position')) = '1' AND JSON_UNQUOTE(JSON_EXTRACT(e0_.location, '$.storey')) = '4' AND JSON_UNQUOTE(JSON_EXTRACT(e0_.location, '$.section')) = '1' ORDER BY e0_.created_at DESC LIMIT 1;

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

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

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.scope AS scope_3,
  t0.resources AS resources_4,
  t0.value AS value_5,
  t0.updated_at AS updated_at_6,
  t0.identifier AS identifier_7,
  t0.display AS display_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  setting t0
WHERE
  t0.identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.scope AS scope_3, t0.resources AS resources_4, t0.value AS value_5, t0.updated_at AS updated_at_6, t0.identifier AS identifier_7, t0.display AS display_8, t0.updated_by_id AS updated_by_id_9 FROM setting t0 WHERE t0.identifier = 'suspicious_event_period' LIMIT 1;

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 = '1f0cb9d7-84b5-6860-8db5-85354b4187a7' 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-06T06:15:54+00:00' WHERE id = 0x1F0CC6DB6DC765FCB7FE91CF1021FC0E;

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 = 'SN3TG1ET4' 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.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 = 0x1F0CBB7DCB72691899B9335E62E528D3;

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

"COMMIT"

"COMMIT";

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

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

UPDATE `board` SET last_connected_at = '2025-12-06 06:15:55' WHERE id = 0x1F0CB920E3416882BA270D9DCC3364F8;

UPDATE
  scale_product_count
SET
  suspicious_events = ?,
  restock = ?,
  total = ?,
  stable_product_count = ?,
  stable_product_count_updated_at = ?
WHERE
  id = ?

UPDATE scale_product_count SET suspicious_events = '[{\"amount\":2.0,\"removedAt\":\"2025-12-06T06:15:54+00:00\",\"expiredAt\":\"2025-12-06T06:16:54+00:00\",\"state\":\"IN_PROGRESS\"}]', restock = '[{\"state\":\"CONFIRMED\",\"amount\":7.0,\"expiredAt\":\"2026-01-27T15:21:51+00:00\",\"restockedAt\":\"2025-11-28T15:21:51+00:00\"},{\"state\":\"IN_PROGRESS\",\"amount\":2.0,\"expiredAt\":\"2026-02-03T15:25:49+00:00\",\"restockedAt\":\"2025-12-05T15:25:49+00:00\"}]', total = 10, stable_product_count = 10, stable_product_count_updated_at = '2025-12-06T06:15:54+00:00' WHERE id = 0x1F0CC6DB6DD76E34B25D91CF1021FC0E;

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

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

UPDATE scale SET weight = 928, last_update = '2025-12-06 06:15:55' WHERE id = 0x1F0CBB7DCB72691899B9335E62E528D3;

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

"START TRANSACTION"

"START TRANSACTION";