Symfony Profiler

"COMMIT"

"COMMIT";

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;

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

INSERT INTO order_audit (TYPE, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES ('update', '23443', NULL, '3d095d0a95db65ff561dea7e3bad3d0fb8863f0f', '{\"externalShipId\":{\"new\":\"26001023443\"},\"issuetAt\":{\"new\":\"2026-04-09 13:59:51\"},\"shipProvider\":{\"old\":{\"id\":2,\"class\":\"App\\\\Entity\\\\ShipProvider\",\"label\":\"Zelo\",\"table\":\"ship_provider\"},\"new\":{\"id\":1,\"class\":\"App\\\\Entity\\\\ShipProvider\",\"label\":\"Loja\",\"table\":\"ship_provider\"}},\"status\":{\"old\":{\"id\":3,\"class\":\"App\\\\Entity\\\\Status\",\"label\":\"Aceite\\/Pago\",\"table\":\"status\"},\"new\":{\"id\":5,\"class\":\"App\\\\Entity\\\\Status\",\"label\":\"A Caminho\",\"table\":\"status\"}},\"storeShipProvider\":{\"old\":{\"id\":1,\"class\":\"App\\\\Entity\\\\StoreShipProvider\",\"label\":\"Express Zelo Zelo\",\"table\":\"store_ship_provider\"},\"new\":{\"id\":19,\"class\":\"App\\\\Entity\\\\StoreShipProvider\",\"label\":\"Entrega Interna na Rua Loja\",\"table\":\"store_ship_provider\"}}}', '2', 'antonio', 'DH\\Auditor\\User\\User', 'main', '188.80.55.240', '2026-04-09 13:59:51.955590');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_final AS is_final_3,
  t0.type AS type_4,
  t0.is_notification AS is_notification_5
FROM
  STATUS t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_final AS is_final_3, t0.type AS type_4, t0.is_notification AS is_notification_5 FROM STATUS t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.info_access AS info_access_2,
  t0.designation AS designation_3,
  t0.is_active AS is_active_4,
  t0.store_id AS store_id_5,
  t0.ship_provider_id AS ship_provider_id_6
FROM
  store_ship_provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.info_access AS info_access_2, t0.designation AS designation_3, t0.is_active AS is_active_4, t0.store_id AS store_id_5, t0.ship_provider_id AS ship_provider_id_6 FROM store_ship_provider t0 WHERE t0.id = '19';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.description AS description_4,
  t0.quantity_picked AS quantity_picked_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.product_id AS product_id_8,
  t0.section_id AS section_id_9,
  t0.inventory_id AS inventory_id_10,
  t0.order_line_id AS order_line_id_11,
  t0.partial_line_track_id AS partial_line_track_id_12
FROM
  tracking_inventory t0
WHERE
  t0.order_line_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.description AS description_4, t0.quantity_picked AS quantity_picked_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8, t0.section_id AS section_id_9, t0.inventory_id AS inventory_id_10, t0.order_line_id AS order_line_id_11, t0.partial_line_track_id AS partial_line_track_id_12 FROM tracking_inventory t0 WHERE t0.order_line_id = 29447;

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 ('update', '38300', NULL, '61643d4d32a24ff53f8b9ee5fdffc7f09d628091', '{\"partialLineTrack\":{\"new\":{\"id\":25642,\"class\":\"App\\\\Entity\\\\PartialLineTrack\",\"label\":\"App\\\\Entity\\\\PartialLineTrack#25642\",\"table\":\"partial_line_track\"}}}', '2', 'antonio', 'DH\\Auditor\\User\\User', 'main', '188.80.55.240', '2026-04-09 13:59:51.964544');

SELECT
  p0_.id AS id_0,
  p0_.qty AS qty_1,
  p0_.external_ship_id AS external_ship_id_2,
  p0_.created_at AS created_at_3,
  p0_.issue_at AS issue_at_4,
  p0_.weight AS weight_5,
  p0_.reference AS reference_6,
  p0_.code_invoice AS code_invoice_7,
  p0_.order_line_id AS order_line_id_8,
  p0_.store_ship_provider_id AS store_ship_provider_id_9
FROM
  partial_line_track p0_
  INNER JOIN order_line o1_ ON p0_.order_line_id = o1_.id
WHERE
  p0_.issue_at IS NULL
  AND p0_.store_ship_provider_id = ?
  AND o1_.store_order_id = ?

SELECT p0_.id AS id_0, p0_.qty AS qty_1, p0_.external_ship_id AS external_ship_id_2, p0_.created_at AS created_at_3, p0_.issue_at AS issue_at_4, p0_.weight AS weight_5, p0_.reference AS reference_6, p0_.code_invoice AS code_invoice_7, p0_.order_line_id AS order_line_id_8, p0_.store_ship_provider_id AS store_ship_provider_id_9 FROM partial_line_track p0_ INNER JOIN order_line o1_ ON p0_.order_line_id = o1_.id WHERE p0_.issue_at IS NULL AND p0_.store_ship_provider_id = 19 AND o1_.store_order_id = 23443;

UPDATE
  `order`
SET
  external_ship_id = ?,
  issuet_at = ?,
  ship_provider_id = ?,
  status_id = ?,
  store_ship_provider_id = ?
WHERE
  id = ?

UPDATE `order` SET external_ship_id = '26001023443', issuet_at = '2026-04-09 13:59:51', ship_provider_id = 1, status_id = 5, store_ship_provider_id = 19 WHERE id = 23443;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_at AS created_at_3,
  t0.qty AS qty_4,
  t0.price AS price_5,
  t0.description AS description_6,
  t0.is_ready AS is_ready_7,
  t0.preparation_at AS preparation_at_8,
  t0.separate_at AS separate_at_9,
  t0.product_id AS product_id_10,
  t0.store_order_id AS store_order_id_11,
  t0.order_line_id AS order_line_id_12,
  t0.partial_line_track_id AS partial_line_track_id_13
FROM
  crossdocking t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_at AS created_at_3, t0.qty AS qty_4, t0.price AS price_5, t0.description AS description_6, t0.is_ready AS is_ready_7, t0.preparation_at AS preparation_at_8, t0.separate_at AS separate_at_9, t0.product_id AS product_id_10, t0.store_order_id AS store_order_id_11, t0.order_line_id AS order_line_id_12, t0.partial_line_track_id AS partial_line_track_id_13 FROM crossdocking t0 WHERE t0.id = '38300';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.initials AS initials_4,
  t0.public_tracking AS public_tracking_5,
  t0.is_issue AS is_issue_6,
  t0.is_events AS is_events_7,
  t0.is_internal AS is_internal_8
FROM
  ship_provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.initials AS initials_4, t0.public_tracking AS public_tracking_5, t0.is_issue AS is_issue_6, t0.is_events AS is_events_7, t0.is_internal AS is_internal_8 FROM ship_provider t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.external_market_id AS external_market_id_2,
  t0.external_ship_id AS external_ship_id_3,
  t0.imported_at AS imported_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.shipped_at AS shipped_at_7,
  t0.error_on AS error_on_8,
  t0.finished_at AS finished_at_9,
  t0.canceled_at AS canceled_at_10,
  t0.ship_from_name AS ship_from_name_11,
  t0.ship_from_vat AS ship_from_vat_12,
  t0.ship_from_phone AS ship_from_phone_13,
  t0.ship_from_address AS ship_from_address_14,
  t0.ship_from_zip_code AS ship_from_zip_code_15,
  t0.ship_from_city AS ship_from_city_16,
  t0.ship_from_country AS ship_from_country_17,
  t0.ship_to_name AS ship_to_name_18,
  t0.ship_to_vat AS ship_to_vat_19,
  t0.ship_to_email AS ship_to_email_20,
  t0.ship_to_phone AS ship_to_phone_21,
  t0.ship_to_address AS ship_to_address_22,
  t0.ship_to_zip_code AS ship_to_zip_code_23,
  t0.ship_to_city AS ship_to_city_24,
  t0.ship_to_country AS ship_to_country_25,
  t0.volumes AS volumes_26,
  t0.weight AS weight_27,
  t0.refund AS refund_28,
  t0.refund_value AS refund_value_29,
  t0.back AS back_30,
  t0.internal_reference AS internal_reference_31,
  t0.obs AS obs_32,
  t0.response_market AS response_market_33,
  t0.total_price AS total_price_34,
  t0.shipping_cost AS shipping_cost_35,
  t0.deleted_at AS deleted_at_36,
  t0.is_refund_received AS is_refund_received_37,
  t0.shipping_description AS shipping_description_38,
  t0.issuet_at AS issuet_at_39,
  t0.completed_at AS completed_at_40,
  t0.error_on_issue AS error_on_issue_41,
  t0.is_gift AS is_gift_42,
  t0.refund_received_at AS refund_received_at_43,
  t0.external_ship_cost AS external_ship_cost_44,
  t0.discount_value AS discount_value_45,
  t0.store_id AS store_id_46,
  t0.ship_provider_id AS ship_provider_id_47,
  t0.market_store_id AS market_store_id_48,
  t0.status_id AS status_id_49,
  t0.store_ship_provider_id AS store_ship_provider_id_50,
  t0.created_by_id AS created_by_id_51,
  t0.ship_provider_status_id AS ship_provider_status_id_52
FROM
  `order` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_market_id AS external_market_id_2, t0.external_ship_id AS external_ship_id_3, t0.imported_at AS imported_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shipped_at AS shipped_at_7, t0.error_on AS error_on_8, t0.finished_at AS finished_at_9, t0.canceled_at AS canceled_at_10, t0.ship_from_name AS ship_from_name_11, t0.ship_from_vat AS ship_from_vat_12, t0.ship_from_phone AS ship_from_phone_13, t0.ship_from_address AS ship_from_address_14, t0.ship_from_zip_code AS ship_from_zip_code_15, t0.ship_from_city AS ship_from_city_16, t0.ship_from_country AS ship_from_country_17, t0.ship_to_name AS ship_to_name_18, t0.ship_to_vat AS ship_to_vat_19, t0.ship_to_email AS ship_to_email_20, t0.ship_to_phone AS ship_to_phone_21, t0.ship_to_address AS ship_to_address_22, t0.ship_to_zip_code AS ship_to_zip_code_23, t0.ship_to_city AS ship_to_city_24, t0.ship_to_country AS ship_to_country_25, t0.volumes AS volumes_26, t0.weight AS weight_27, t0.refund AS refund_28, t0.refund_value AS refund_value_29, t0.back AS back_30, t0.internal_reference AS internal_reference_31, t0.obs AS obs_32, t0.response_market AS response_market_33, t0.total_price AS total_price_34, t0.shipping_cost AS shipping_cost_35, t0.deleted_at AS deleted_at_36, t0.is_refund_received AS is_refund_received_37, t0.shipping_description AS shipping_description_38, t0.issuet_at AS issuet_at_39, t0.completed_at AS completed_at_40, t0.error_on_issue AS error_on_issue_41, t0.is_gift AS is_gift_42, t0.refund_received_at AS refund_received_at_43, t0.external_ship_cost AS external_ship_cost_44, t0.discount_value AS discount_value_45, t0.store_id AS store_id_46, t0.ship_provider_id AS ship_provider_id_47, t0.market_store_id AS market_store_id_48, t0.status_id AS status_id_49, t0.store_ship_provider_id AS store_ship_provider_id_50, t0.created_by_id AS created_by_id_51, t0.ship_provider_status_id AS ship_provider_status_id_52 FROM `order` t0 WHERE t0.id = 23443;

INSERT INTO partial_line_track (
  qty, external_ship_id, created_at,
  issue_at, weight, reference, code_invoice,
  order_line_id, store_ship_provider_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO partial_line_track (qty, external_ship_id, created_at, issue_at, weight, reference, code_invoice, order_line_id, store_ship_provider_id) VALUES (1, NULL, '2026-04-09 13:59:51', NULL, '1', '', NULL, 29447, 19);

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 = 7664;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.logosmall AS logosmall_4,
  t0.icon AS icon_5,
  t0.favicon AS favicon_6,
  t0.is_cross_docking AS is_cross_docking_7
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.logosmall AS logosmall_4, t0.icon AS icon_5, t0.favicon AS favicon_6, t0.is_cross_docking AS is_cross_docking_7 FROM settings t0 WHERE t0.id = 1;

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 = 23443;

UPDATE
  crossdocking
SET
  partial_line_track_id = ?
WHERE
  id = ?

UPDATE crossdocking SET partial_line_track_id = 25642 WHERE id = 38300;

UPDATE
  partial_line_track
SET
  external_ship_id = ?,
  issue_at = ?
WHERE
  id = ?

UPDATE partial_line_track SET external_ship_id = '26001023443', issue_at = '2026-04-09 13:59:51' WHERE id = 25642;

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 = 29447;

UPDATE
  order_line
SET
  discount = ?
WHERE
  id = ?

UPDATE order_line SET discount = 0 WHERE id = 29447;

UPDATE
  `order`
SET
  issuet_at = ?
WHERE
  id = ?

UPDATE `order` SET issuet_at = '2026-04-09 13:59:51' WHERE id = 23443;

UPDATE
  tracking_inventory
SET
  quantity_picked = ?
WHERE
  id = ?

UPDATE tracking_inventory SET quantity_picked = 1 WHERE id = 64945;