Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sku AS sku_3,
  t0.pricce AS pricce_4,
  t0.weight AS weight_5,
  t0.description AS description_6,
  t0.created AS created_7,
  t0.cost AS cost_8,
  t0.pvp AS pvp_9,
  t0.is_virtual AS is_virtual_10,
  t0.min_sale_inventory_qty AS min_sale_inventory_qty_11,
  t0.media AS media_12,
  t0.inventory_quantity AS inventory_quantity_13,
  t0.ean AS ean_14,
  t0.image_name AS image_name_15,
  t0.is_active AS is_active_16,
  t0.product_url AS product_url_17,
  t0.image_url AS image_url_18,
  t0.category_description AS category_description_19,
  t0.parent_id AS parent_id_20,
  t0.store_id AS store_id_21,
  t0.tax_id AS tax_id_22
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.pricce AS pricce_4, t0.weight AS weight_5, t0.description AS description_6, t0.created AS created_7, t0.cost AS cost_8, t0.pvp AS pvp_9, t0.is_virtual AS is_virtual_10, t0.min_sale_inventory_qty AS min_sale_inventory_qty_11, t0.media AS media_12, t0.inventory_quantity AS inventory_quantity_13, t0.ean AS ean_14, t0.image_name AS image_name_15, t0.is_active AS is_active_16, t0.product_url AS product_url_17, t0.image_url AS image_url_18, t0.category_description AS category_description_19, t0.parent_id AS parent_id_20, t0.store_id AS store_id_21, t0.tax_id AS tax_id_22 FROM product t0 WHERE t0.id = '6058';

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  center t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM center t0 WHERE t0.id = 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.created_at AS created_at_3,
  s0_.section_key AS section_key_4,
  s0_.is_crossdocking AS is_crossdocking_5,
  s0_.center_id AS center_id_6,
  s0_.parent_id AS parent_id_7,
  s0_.section_type_id AS section_type_id_8
FROM
  section s0_
WHERE
  s0_.center_id = ?
  AND s0_.is_crossdocking = 1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.created_at AS created_at_3, s0_.section_key AS section_key_4, s0_.is_crossdocking AS is_crossdocking_5, s0_.center_id AS center_id_6, s0_.parent_id AS parent_id_7, s0_.section_type_id AS section_type_id_8 FROM section s0_ WHERE s0_.center_id = 1 AND s0_.is_crossdocking = 1;

SELECT
  o0_.id AS id_0,
  o0_.external_market_id AS external_market_id_1,
  o0_.external_ship_id AS external_ship_id_2,
  o0_.imported_at AS imported_at_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.shipped_at AS shipped_at_6,
  o0_.error_on AS error_on_7,
  o0_.finished_at AS finished_at_8,
  o0_.canceled_at AS canceled_at_9,
  o0_.ship_from_name AS ship_from_name_10,
  o0_.ship_from_vat AS ship_from_vat_11,
  o0_.ship_from_phone AS ship_from_phone_12,
  o0_.ship_from_address AS ship_from_address_13,
  o0_.ship_from_zip_code AS ship_from_zip_code_14,
  o0_.ship_from_city AS ship_from_city_15,
  o0_.ship_from_country AS ship_from_country_16,
  o0_.ship_to_name AS ship_to_name_17,
  o0_.ship_to_vat AS ship_to_vat_18,
  o0_.ship_to_email AS ship_to_email_19,
  o0_.ship_to_phone AS ship_to_phone_20,
  o0_.ship_to_address AS ship_to_address_21,
  o0_.ship_to_zip_code AS ship_to_zip_code_22,
  o0_.ship_to_city AS ship_to_city_23,
  o0_.ship_to_country AS ship_to_country_24,
  o0_.volumes AS volumes_25,
  o0_.weight AS weight_26,
  o0_.refund AS refund_27,
  o0_.refund_value AS refund_value_28,
  o0_.back AS back_29,
  o0_.internal_reference AS internal_reference_30,
  o0_.obs AS obs_31,
  o0_.response_market AS response_market_32,
  o0_.total_price AS total_price_33,
  o0_.shipping_cost AS shipping_cost_34,
  o0_.deleted_at AS deleted_at_35,
  o0_.is_refund_received AS is_refund_received_36,
  o0_.shipping_description AS shipping_description_37,
  o0_.issuet_at AS issuet_at_38,
  o0_.completed_at AS completed_at_39,
  o0_.error_on_issue AS error_on_issue_40,
  o0_.is_gift AS is_gift_41,
  o0_.refund_received_at AS refund_received_at_42,
  o0_.external_ship_cost AS external_ship_cost_43,
  o0_.discount_value AS discount_value_44,
  o0_.store_id AS store_id_45,
  o0_.ship_provider_id AS ship_provider_id_46,
  o0_.market_store_id AS market_store_id_47,
  o0_.status_id AS status_id_48,
  o0_.store_ship_provider_id AS store_ship_provider_id_49,
  o0_.created_by_id AS created_by_id_50,
  o0_.ship_provider_status_id AS ship_provider_status_id_51
FROM
  `order` o0_
  INNER JOIN order_line o1_ ON o0_.id = o1_.store_order_id
  INNER JOIN STATUS s2_ ON o0_.status_id = s2_.id
WHERE
  o1_.product_id = ?
  AND s2_.id = 3
ORDER BY
  o0_.created_at ASC

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN order_line o1_ ON o0_.id = o1_.store_order_id INNER JOIN STATUS s2_ ON o0_.status_id = s2_.id WHERE o1_.product_id = 6058 AND s2_.id = 3 ORDER BY o0_.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.tax AS tax_4,
  t0.discount AS discount_5,
  t0.created_at AS created_at_6,
  t0.description AS description_7,
  t0.product_cost_unit AS product_cost_unit_8,
  t0.store_order_id AS store_order_id_9,
  t0.product_id AS product_id_10
FROM
  order_line t0
WHERE
  t0.store_order_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.tax AS tax_4, t0.discount AS discount_5, t0.created_at AS created_at_6, t0.description AS description_7, t0.product_cost_unit AS product_cost_unit_8, t0.store_order_id AS store_order_id_9, t0.product_id AS product_id_10 FROM order_line t0 WHERE t0.store_order_id = 23429;

SELECT
  COUNT(c0_.qty) AS sclr_0
FROM
  crossdocking c0_
WHERE
  c0_.order_line_id = ?
  AND c0_.product_id = ?

SELECT COUNT(c0_.qty) AS sclr_0 FROM crossdocking c0_ WHERE c0_.order_line_id = 29431 AND c0_.product_id = 6058;

SELECT
  t0.id AS id_1,
  t0.qty AS qty_2,
  t0.external_ship_id AS external_ship_id_3,
  t0.created_at AS created_at_4,
  t0.issue_at AS issue_at_5,
  t0.weight AS weight_6,
  t0.reference AS reference_7,
  t0.code_invoice AS code_invoice_8,
  t0.order_line_id AS order_line_id_9,
  t0.store_ship_provider_id AS store_ship_provider_id_10
FROM
  partial_line_track t0
WHERE
  t0.order_line_id = ?

SELECT t0.id AS id_1, t0.qty AS qty_2, t0.external_ship_id AS external_ship_id_3, t0.created_at AS created_at_4, t0.issue_at AS issue_at_5, t0.weight AS weight_6, t0.reference AS reference_7, t0.code_invoice AS code_invoice_8, t0.order_line_id AS order_line_id_9, t0.store_ship_provider_id AS store_ship_provider_id_10 FROM partial_line_track t0 WHERE t0.order_line_id = 29431;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.tax AS tax_4,
  t0.discount AS discount_5,
  t0.created_at AS created_at_6,
  t0.description AS description_7,
  t0.product_cost_unit AS product_cost_unit_8,
  t0.store_order_id AS store_order_id_9,
  t0.product_id AS product_id_10
FROM
  order_line t0
WHERE
  t0.store_order_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.tax AS tax_4, t0.discount AS discount_5, t0.created_at AS created_at_6, t0.description AS description_7, t0.product_cost_unit AS product_cost_unit_8, t0.store_order_id AS store_order_id_9, t0.product_id AS product_id_10 FROM order_line t0 WHERE t0.store_order_id = 26313;

SELECT
  COUNT(c0_.qty) AS sclr_0
FROM
  crossdocking c0_
WHERE
  c0_.order_line_id = ?
  AND c0_.product_id = ?

SELECT COUNT(c0_.qty) AS sclr_0 FROM crossdocking c0_ WHERE c0_.order_line_id = 33245 AND c0_.product_id = 6058;

SELECT
  t0.id AS id_1,
  t0.qty AS qty_2,
  t0.external_ship_id AS external_ship_id_3,
  t0.created_at AS created_at_4,
  t0.issue_at AS issue_at_5,
  t0.weight AS weight_6,
  t0.reference AS reference_7,
  t0.code_invoice AS code_invoice_8,
  t0.order_line_id AS order_line_id_9,
  t0.store_ship_provider_id AS store_ship_provider_id_10
FROM
  partial_line_track t0
WHERE
  t0.order_line_id = ?

SELECT t0.id AS id_1, t0.qty AS qty_2, t0.external_ship_id AS external_ship_id_3, t0.created_at AS created_at_4, t0.issue_at AS issue_at_5, t0.weight AS weight_6, t0.reference AS reference_7, t0.code_invoice AS code_invoice_8, t0.order_line_id AS order_line_id_9, t0.store_ship_provider_id AS store_ship_provider_id_10 FROM partial_line_track t0 WHERE t0.order_line_id = 33245;

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.created_at AS created_at_2,
  c0_.qty AS qty_3,
  c0_.price AS price_4,
  c0_.description AS description_5,
  c0_.is_ready AS is_ready_6,
  c0_.preparation_at AS preparation_at_7,
  c0_.separate_at AS separate_at_8,
  c0_.product_id AS product_id_9,
  c0_.store_order_id AS store_order_id_10,
  c0_.order_line_id AS order_line_id_11,
  c0_.partial_line_track_id AS partial_line_track_id_12
FROM
  crossdocking c0_
WHERE
  c0_.order_line_id = ?

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.order_line_id = 33245;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO crossdocking (
  created, created_at, qty, price, description,
  is_ready, preparation_at, separate_at,
  product_id, store_order_id, order_line_id,
  partial_line_track_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO crossdocking (created, created_at, qty, price, description, is_ready, preparation_at, separate_at, product_id, store_order_id, order_line_id, partial_line_track_id) VALUES (NULL, '2026-06-08 10:56:45', 1, NULL, NULL, 0, NULL, NULL, 6058, 26313, 33245, NULL);

INSERT INTO crossdocking_audit (
  TYPE, object_id, discriminator, transaction_hash,
  diffs, blame_id, blame_user, blame_user_fqdn,
  blame_user_firewall, ip, created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO crossdocking_audit (TYPE, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES ('insert', '43254', NULL, '8bedfe9cf02df4d415d8af1931454cf5656905bc', '{\"@source\":{\"id\":43254,\"class\":\"App\\\\Entity\\\\Crossdocking\",\"label\":\"App\\\\Entity\\\\Crossdocking#43254\",\"table\":\"crossdocking\"},\"createdAt\":{\"new\":\"2026-06-08 10:56:45\"},\"qty\":{\"new\":1},\"isReady\":{\"new\":false},\"product\":{\"new\":{\"id\":6058,\"class\":\"App\\\\Entity\\\\Product\",\"label\":\"Maquina Lavar Lou\\u00e7a Siemens SN-97-TX-02-CE 4242003970379\",\"table\":\"product\"}},\"storeOrder\":{\"new\":{\"id\":26313,\"class\":\"App\\\\Entity\\\\Order\",\"label\":\"66451\",\"table\":\"order\"}},\"orderLine\":{\"new\":{\"id\":33245,\"class\":\"App\\\\Entity\\\\OrderLine\",\"label\":\"Maquina Lavar Lou\\u00e7a Siemens SN-97-TX-02-CE\",\"table\":\"order_line\"}}}', '2', 'antonio', 'DH\\Auditor\\User\\User', 'main', '148.69.201.10', '2026-06-08 10:56:45.802574');

"COMMIT"

"COMMIT";

SELECT
  i0_.id AS id_0,
  i0_.quantity AS quantity_1,
  i0_.created_at AS created_at_2,
  i0_.section_id AS section_id_3,
  i0_.product_id AS product_id_4
FROM
  inventory i0_
WHERE
  i0_.section_id = ?
  AND i0_.product_id = ?

SELECT i0_.id AS id_0, i0_.quantity AS quantity_1, i0_.created_at AS created_at_2, i0_.section_id AS section_id_3, i0_.product_id AS product_id_4 FROM inventory i0_ WHERE i0_.section_id = 21 AND i0_.product_id = 6058;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO tracking_inventory (
  TYPE, quantity, description, quantity_picked,
  created_at, updated_at, product_id,
  section_id, inventory_id, order_line_id,
  partial_line_track_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO tracking_inventory (TYPE, quantity, description, quantity_picked, created_at, updated_at, product_id, section_id, inventory_id, order_line_id, partial_line_track_id) VALUES ('IN', 1, NULL, 0, '2026-06-08 10:56:45', '2026-06-08 10:56:45', 6058, 21, 13660, NULL, NULL);

UPDATE
  order_line
SET
  discount = ?
WHERE
  id = ?

UPDATE order_line SET discount = 0 WHERE id = 29430;

UPDATE
  order_line
SET
  discount = ?
WHERE
  id = ?

UPDATE order_line SET discount = 0 WHERE id = 29431;

UPDATE
  order_line
SET
  discount = ?
WHERE
  id = ?

UPDATE order_line SET discount = 0 WHERE id = 29432;

UPDATE
  order_line
SET
  discount = ?
WHERE
  id = ?

UPDATE order_line SET discount = 0 WHERE id = 29433;

UPDATE
  order_line
SET
  discount = ?
WHERE
  id = ?

UPDATE order_line SET discount = 0 WHERE id = 33245;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sku AS sku_3,
  t0.pricce AS pricce_4,
  t0.weight AS weight_5,
  t0.description AS description_6,
  t0.created AS created_7,
  t0.cost AS cost_8,
  t0.pvp AS pvp_9,
  t0.is_virtual AS is_virtual_10,
  t0.min_sale_inventory_qty AS min_sale_inventory_qty_11,
  t0.media AS media_12,
  t0.inventory_quantity AS inventory_quantity_13,
  t0.ean AS ean_14,
  t0.image_name AS image_name_15,
  t0.is_active AS is_active_16,
  t0.product_url AS product_url_17,
  t0.image_url AS image_url_18,
  t0.category_description AS category_description_19,
  t0.parent_id AS parent_id_20,
  t0.store_id AS store_id_21,
  t0.tax_id AS tax_id_22
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.pricce AS pricce_4, t0.weight AS weight_5, t0.description AS description_6, t0.created AS created_7, t0.cost AS cost_8, t0.pvp AS pvp_9, t0.is_virtual AS is_virtual_10, t0.min_sale_inventory_qty AS min_sale_inventory_qty_11, t0.media AS media_12, t0.inventory_quantity AS inventory_quantity_13, t0.ean AS ean_14, t0.image_name AS image_name_15, t0.is_active AS is_active_16, t0.product_url AS product_url_17, t0.image_url AS image_url_18, t0.category_description AS category_description_19, t0.parent_id AS parent_id_20, t0.store_id AS store_id_21, t0.tax_id AS tax_id_22 FROM product t0 WHERE t0.id = 5604;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sku AS sku_3,
  t0.pricce AS pricce_4,
  t0.weight AS weight_5,
  t0.description AS description_6,
  t0.created AS created_7,
  t0.cost AS cost_8,
  t0.pvp AS pvp_9,
  t0.is_virtual AS is_virtual_10,
  t0.min_sale_inventory_qty AS min_sale_inventory_qty_11,
  t0.media AS media_12,
  t0.inventory_quantity AS inventory_quantity_13,
  t0.ean AS ean_14,
  t0.image_name AS image_name_15,
  t0.is_active AS is_active_16,
  t0.product_url AS product_url_17,
  t0.image_url AS image_url_18,
  t0.category_description AS category_description_19,
  t0.parent_id AS parent_id_20,
  t0.store_id AS store_id_21,
  t0.tax_id AS tax_id_22
FROM
  product t0
WHERE
  t0.id = ?