Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.is_active AS is_active_3,
  t0.roles AS roles_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.default_language AS default_language_7,
  t0.scan_sound AS scan_sound_8,
  t0.is_deleted AS is_deleted_9,
  t0.firstname AS firstname_10,
  t0.lastname AS lastname_11,
  t0.main_role AS main_role_12,
  t0.is_allowed_continuous_po AS is_allowed_continuous_po_13,
  t0.current_average90 AS current_average90_14,
  t0.current_group_average90 AS current_group_average90_15,
  t0.average90_at AS average90_at_16,
  t0.current_scan_average AS current_scan_average_17,
  t0.default_module_id AS default_module_id_18,
  t0.warehouse_id AS warehouse_id_19,
  t0.user_group_id AS user_group_id_20,
  t0.scan_category_group_id AS scan_category_group_id_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.is_active AS is_active_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.default_language AS default_language_7, t0.scan_sound AS scan_sound_8, t0.is_deleted AS is_deleted_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.main_role AS main_role_12, t0.is_allowed_continuous_po AS is_allowed_continuous_po_13, t0.current_average90 AS current_average90_14, t0.current_group_average90 AS current_group_average90_15, t0.average90_at AS average90_at_16, t0.current_scan_average AS current_scan_average_17, t0.default_module_id AS default_module_id_18, t0.warehouse_id AS warehouse_id_19, t0.user_group_id AS user_group_id_20, t0.scan_category_group_id AS scan_category_group_id_21 FROM user t0 WHERE t0.id = 68;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.package_units AS package_units_3,
  t0.weight AS weight_4,
  t0.user AS user_5,
  t0.format AS format_6,
  t0.photos AS photos_7,
  t0.name AS name_8,
  t0.extended AS extended_9,
  t0.units AS units_10,
  t0.discount AS discount_11,
  t0.estimated_sales AS estimated_sales_12,
  t0.is_initialized AS is_initialized_13,
  t0.msrp_current AS msrp_current_14,
  t0.is_closed AS is_closed_15,
  t0.is_high_value AS is_high_value_16,
  t0.is_cp AS is_cp_17,
  t0.estimated_sales_min_target AS estimated_sales_min_target_18,
  t0.estimated_sales_max_target AS estimated_sales_max_target_19,
  t0.display_name AS display_name_20,
  t0.quantity AS quantity_21,
  t0.cp_quantity AS cp_quantity_22,
  t0.is_truckload AS is_truckload_23,
  t0.is_photos_compressed AS is_photos_compressed_24,
  t0.is_destroy AS is_destroy_25,
  t0.package_sizes AS package_sizes_26,
  t0.is_listing_done AS is_listing_done_27,
  t0.discount_triage AS discount_triage_28,
  t0.volumetric_weight AS volumetric_weight_29,
  t0.real_weight AS real_weight_30,
  t0.previous_number AS previous_number_31,
  t0.cost AS cost_32,
  t0.is_imported AS is_imported_33,
  t0.supplier_pallet_number AS supplier_pallet_number_34,
  t0.created_at AS created_at_35,
  t0.updated_at AS updated_at_36,
  t0.po_id AS po_id_37,
  t0.category_id AS category_id_38,
  t0.cp_product_id AS cp_product_id_39,
  t0.product_condition_id AS product_condition_id_40,
  t0.merged_with_id AS merged_with_id_41,
  t0.preparation_lot_id AS preparation_lot_id_42,
  t0.previous_po_id AS previous_po_id_43,
  t0.related_front_product_id AS related_front_product_id_44
FROM
  lot t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.package_units AS package_units_3, t0.weight AS weight_4, t0.user AS user_5, t0.format AS format_6, t0.photos AS photos_7, t0.name AS name_8, t0.extended AS extended_9, t0.units AS units_10, t0.discount AS discount_11, t0.estimated_sales AS estimated_sales_12, t0.is_initialized AS is_initialized_13, t0.msrp_current AS msrp_current_14, t0.is_closed AS is_closed_15, t0.is_high_value AS is_high_value_16, t0.is_cp AS is_cp_17, t0.estimated_sales_min_target AS estimated_sales_min_target_18, t0.estimated_sales_max_target AS estimated_sales_max_target_19, t0.display_name AS display_name_20, t0.quantity AS quantity_21, t0.cp_quantity AS cp_quantity_22, t0.is_truckload AS is_truckload_23, t0.is_photos_compressed AS is_photos_compressed_24, t0.is_destroy AS is_destroy_25, t0.package_sizes AS package_sizes_26, t0.is_listing_done AS is_listing_done_27, t0.discount_triage AS discount_triage_28, t0.volumetric_weight AS volumetric_weight_29, t0.real_weight AS real_weight_30, t0.previous_number AS previous_number_31, t0.cost AS cost_32, t0.is_imported AS is_imported_33, t0.supplier_pallet_number AS supplier_pallet_number_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.po_id AS po_id_37, t0.category_id AS category_id_38, t0.cp_product_id AS cp_product_id_39, t0.product_condition_id AS product_condition_id_40, t0.merged_with_id AS merged_with_id_41, t0.preparation_lot_id AS preparation_lot_id_42, t0.previous_po_id AS previous_po_id_43, t0.related_front_product_id AS related_front_product_id_44 FROM lot t0 WHERE t0.id = '60435';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.msrp AS msrp_3,
  t0.quantity AS quantity_4,
  t0.extended AS extended_5,
  t0.is_truckload AS is_truckload_6,
  t0.is_converted AS is_converted_7,
  t0.batch_id_code AS batch_id_code_8,
  t0.lot_id AS lot_id_9,
  t0.product_id AS product_id_10,
  t0.po_id AS po_id_11,
  t0.manifest_item_id AS manifest_item_id_12,
  t0.original_lot_id AS original_lot_id_13,
  t0.duplicate_of_id AS duplicate_of_id_14
FROM
  lot_item t0
WHERE
  t0.lot_id = ?
ORDER BY
  t0.extended DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.msrp AS msrp_3, t0.quantity AS quantity_4, t0.extended AS extended_5, t0.is_truckload AS is_truckload_6, t0.is_converted AS is_converted_7, t0.batch_id_code AS batch_id_code_8, t0.lot_id AS lot_id_9, t0.product_id AS product_id_10, t0.po_id AS po_id_11, t0.manifest_item_id AS manifest_item_id_12, t0.original_lot_id AS original_lot_id_13, t0.duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0.lot_id = 60435 ORDER BY t0.extended DESC;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.lot_item_id AS lot_item_id_3,
  t0.po_id AS po_id_4
FROM
  lot_item_origin t0
WHERE
  t0.lot_item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = 4906347;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.lot_item_id AS lot_item_id_3,
  t0.po_id AS po_id_4
FROM
  lot_item_origin t0
WHERE
  t0.lot_item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = 4906336;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  lot
SET
  msrp_current = ?,
  is_high_value = ?,
  is_cp = ?,
  real_weight = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE lot SET msrp_current = 3893.43, is_high_value = 0, is_cp = 0, real_weight = 600, updated_at = '2025-12-15 11:26:10' WHERE id = 60435;

"COMMIT"

"COMMIT";