Symfony Profiler

Query Metrics

45 Database Queries

17 Different statements

41.83 ms Query time

0 Invalid entities

308 Managed entities

Queries


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.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.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 = ? 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.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.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.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.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.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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
"START TRANSACTION"
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 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 = ?
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 = ?
SAVEPOINT DOCTRINE_2
UPDATE scale SET weight = ?, last_update = ? WHERE id = ?
RELEASE SAVEPOINT DOCTRINE_2
"COMMIT"
SELECT COALESCE(SUM(COALESCE(stable_product_count, total)), 0) as total 
                        FROM scale_product_count 
                        WHERE 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 = ?
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 = ?
"START TRANSACTION"
UPDATE `board` SET last_connected_at = ? WHERE id = ?
"COMMIT"

#▲	Time	Info
1	5.49 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7^n^›K+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098375E6E5E9B4B2B5D0E671059;
2	2.40 ms	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 Parameters: [`"SN4TG1ET5"`] View formatted query View runnable query Explain query 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 = 'SN4TG1ET5' LIMIT 1;
3	1.29 ms	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 Parameters: [`"SN4TG1ET5"`] View formatted query View runnable query Explain query 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 = 'SN4TG1ET5' LIMIT 1;
4	0.37 ms	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 Parameters: [`"SN4TG1ET5"`] View formatted query View runnable query Explain query 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 = 'SN4TG1ET5' LIMIT 1;
5	2.06 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7^n^›K+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098375E6E5E9B4B2B5D0E671059;
6	2.78 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zaÖ‡Ë+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A61D687CB2B5D0E671059;
7	1.32 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zaÖ‡Ë+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A61D687CB2B5D0E671059;
8	0.96 ms	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 = ? Parameters: [`b""" \x1F\x0F\n Ê\n ÌkÔ²‡Õ\vØ—E¤ """`] View formatted query View runnable query Explain query 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 = 0x1F0F0ACA0ACC6BD4B287D50BD89745A4;
9	0.54 ms	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 = ? Parameters: [`b""" \x1F\x0F\n Ê\n ÌkÔ²‡Õ\vØ—E¤ """`] View formatted query View runnable query Explain query 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 = 0x1F0F0ACA0ACC6BD4B287D50BD89745A4;
10	1.04 ms	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 = ? Parameters: [`b""" \x01›Ç\n –!{Ì\x11Ãömä¦d """`] View formatted query View runnable query Explain query 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 = 0x019BC70A96217BCC8111C3F66DE4A664;
11	0.95 ms	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 = ? Parameters: [`b""" \x01›Ç\n –!}\x10\x11ÃömúæQ """`] View formatted query View runnable query Explain query 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 = 0x019BC70A96217D108111C3F66DFAE651;
12	0.72 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7yiÀ“X+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377969C093582B5D0E671059;
13	0.37 ms	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 = ? Parameters: [b"\x1F\x0E°˜7ym\x12ˆ`+]\x0Eg\x10Y"] View formatted query View runnable query Explain query 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 = 0x1F0EB09837796D1288602B5D0E671059;
14	0.98 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7yn¶Ä+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB09837796EB6ADC42B5D0E671059;
15	0.40 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7yo.‹€+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB09837796F2E8B802B5D0E671059;
16	0.54 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7yo¦”Ÿ+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB09837796FA6949F2B5D0E671059;
17	0.32 ms	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 = ? Parameters: [b"\x1F\x0E°˜7z`(\x11+]\x0Eg\x10Y"] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A602881112B5D0E671059;
18	0.31 ms	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 = ? Parameters: [b"\x1F\x0E°˜7z`–„¿+]\x0Eg\x10Y"] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A609684BF2B5D0E671059;
19	0.34 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7za\x0E´“+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A610EB4932B5D0E671059;
20	0.76 ms	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 = ? Parameters: [`b""" \x01›Ç\n –!~T\x11Ãön\x07Ž7 """`] View formatted query View runnable query Explain query 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 = 0x019BC70A96217E548111C3F66E078D37;
21	0.32 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zb0¿È+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A6230BFC82B5D0E671059;
22	0.32 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zbv‰\x12+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A627689122B5D0E671059;
23	0.37 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zbÆ±C+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A62C6B1432B5D0E671059;
24	0.66 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zc ´\x0F+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A6320B40F2B5D0E671059;
25	0.32 ms	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 = ? Parameters: [`b""" \x01›Ç\n –!\x7FX\x11Ãön_8W """`] View formatted query View runnable query Explain query 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 = 0x019BC70A96217F588111C3F66E5F3857;
26	0.41 ms	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 = ? Parameters: [`b""" \x01›Ç\n –"p¥¸0Âˆ:ádí """`] View formatted query View runnable query Explain query 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 = 0x019BC70A962270A5B830C2883AE164ED;
27	0.42 ms	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 = ? Parameters: [`b""" \x01›Ç\n –"q‘¸0Âˆ;žÛô """`] View formatted query View runnable query Explain query 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 = 0x019BC70A96227191B830C2883B9EDBF4;
28	0.46 ms	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 = ? Parameters: [`b""" \x01›Ç\n –"ré¸0Âˆ<VD– """`] View formatted query View runnable query Explain query 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 = 0x019BC70A962272E9B830C2883C564496;
29	0.75 ms	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 = ? Parameters: [`b"\x01›Æì÷àtË“/s\x08ªµù‚"`] View formatted query View runnable query Explain query 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 = 0x019BC6ECF7E074CB932F7308AAB5F982;
30	0.67 ms	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 = ? Parameters: [`b"\x01œ¯\|W½\x7F]¦5)¼Â\x14y"`] View formatted query View runnable query Explain query 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 = 0x019CAF7C57BD7F5DA68F3529BCC21479;
31	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
32	0.47 ms	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 Parameters: [`Symfony\Component\Uid\UuidV7 {#2072 __toString(): "019d1a52-3ad4-72c3-9d4e-d76fddabbe48" }`] View formatted query View runnable query 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 = '019d1a52-3ad4-72c3-9d4e-d76fddabbe48' FOR UPDATE;
33	0.43 ms	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 = ? Parameters: [`b""" \x01›Ç\n –!~T\x11Ãön\x07Ž7 """`] View formatted query View runnable query Explain query 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 = 0x019BC70A96217E548111C3F66E078D37;
34	0.25 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zb0¿È+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A6230BFC82B5D0E671059;
35	0.25 ms	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 = ? Parameters: [`b"\x1F\x0E°˜7zbv‰\x12+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query 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 = 0x1F0EB098377A627689122B5D0E671059;
36	0.17 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
37	1.77 ms	UPDATE scale SET weight = ?, last_update = ? WHERE id = ? Parameters: [`1593 "2026-04-21 04:28:15" b"\x1F\x0E°˜7zaÖ‡Ë+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query UPDATE scale SET weight = ?, last_update = ? WHERE id = ? UPDATE scale SET weight = 1593, last_update = '2026-04-21 04:28:15' WHERE id = 0x1F0EB098377A61D687CB2B5D0E671059;
38	0.36 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
39	2.51 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
40	1.10 ms	SELECT COALESCE(SUM(COALESCE(stable_product_count, total)), 0) as total FROM scale_product_count WHERE product_id = ? Parameters: [`b"\x01œ¯\|W½\x7F]¦5)¼Â\x14y"`] View formatted query View runnable query Explain query 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 = 0x019CAF7C57BD7F5DA68F3529BCC21479;
41	0.55 ms	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 = ? Parameters: [`b"\x01œ¯{¢øwY„c\tŽ™Ç›ä"`] View formatted query View runnable query Explain query 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 = 0x019CAF7BA2F877598463098E99C79BE4;
42	0.62 ms	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 = ? Parameters: [`b"\x01œ¯\|ó”wú¶ ›oÁJ€Y"`] View formatted query View runnable query Explain query 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 = 0x019CAF7CF39477FAB6209B6FC14A8059;
43	0.23 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
44	1.13 ms	UPDATE `board` SET last_connected_at = ? WHERE id = ? Parameters: [`"2026-04-21 04:28:15" b"\x1F\x0E°˜7^n^›K+]\x0Eg\x10Y"`] View formatted query View runnable query Explain query UPDATE `board` SET last_connected_at = ? WHERE id = ? UPDATE `board` SET last_connected_at = '2026-04-21 04:28:15' WHERE id = 0x1F0EB098375E6E5E9B4B2B5D0E671059;
45	3.12 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Scale	150
App\Entity\ScaleProductCount	150
App\Entity\Product	3
App\Entity\Updatable	3
App\Entity\Board	1
App\Entity\Shelf	1

Entities Mapping

Class	Mapping errors
App\Entity\Board	No errors.
App\Entity\Scale	No errors.
App\Entity\User	No errors.
App\Entity\Shelf	No errors.
App\Entity\Product	No errors.
App\Entity\ScaleProductCount	No errors.
App\Entity\Updatable	No errors.
App\Entity\Event	No errors.

Symfony Profiler

POST http://api.grand-littoral.tekshelf.fr/api/esp/boards/SN4TG1ET5/weights?apiKey=1f0eb098-375e-6e5e-9b4b-2b5d0e671059

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping