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

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.nb_pallet AS nb_pallet_4,
  t0.nb_unit AS nb_unit_5,
  t0.eta AS eta_6,
  t0.received_at AS received_at_7,
  t0.manifest_import AS manifest_import_8,
  t0.note AS note_9,
  t0.cost_po AS cost_po_10,
  t0.cost_transport AS cost_transport_11,
  t0.cost_customs AS cost_customs_12,
  t0.msrp_value AS msrp_value_13,
  t0.finances_selling_estimated AS finances_selling_estimated_14,
  t0.seal_number_provided AS seal_number_provided_15,
  t0.seal_number_received AS seal_number_received_16,
  t0.nb_unit_received AS nb_unit_received_17,
  t0.nb_pallet_received AS nb_pallet_received_18,
  t0.seal_number_na AS seal_number_na_19,
  t0.note_reception AS note_reception_20,
  t0.location AS location_21,
  t0.progress_step_reception AS progress_step_reception_22,
  t0.progress_step_scan_manifest AS progress_step_scan_manifest_23,
  t0.progress_step_import_manifest AS progress_step_import_manifest_24,
  t0.progress_step_analysis AS progress_step_analysis_25,
  t0.progress_step_preparation AS progress_step_preparation_26,
  t0.progress_step_triage AS progress_step_triage_27,
  t0.progress_step_photobooth AS progress_step_photobooth_28,
  t0.progress_step_listing AS progress_step_listing_29,
  t0.progress_step_conciliation AS progress_step_conciliation_30,
  t0.preparation_total_units AS preparation_total_units_31,
  t0.preparation_total_extended AS preparation_total_extended_32,
  t0.preparation_total_selling_extended AS preparation_total_selling_extended_33,
  t0.preparation_total_cps AS preparation_total_cps_34,
  t0.preparation_total_lots AS preparation_total_lots_35,
  t0.import_product_quantity AS import_product_quantity_36,
  t0.import_unit_quantity AS import_unit_quantity_37,
  t0.is_truckload AS is_truckload_38,
  t0.progress_step_truckload AS progress_step_truckload_39,
  t0.is_autoanalysis_running AS is_autoanalysis_running_40,
  t0.is_autoanalysis_done AS is_autoanalysis_done_41,
  t0.bol_supplier AS bol_supplier_42,
  t0.customs_description AS customs_description_43,
  t0.customs_country_of_origin AS customs_country_of_origin_44,
  t0.customs_hs_code AS customs_hs_code_45,
  t0.cost_production AS cost_production_46,
  t0.next_cp_number AS next_cp_number_47,
  t0.is_auto_triage AS is_auto_triage_48,
  t0.is_lot_import_allowed AS is_lot_import_allowed_49,
  t0.has_premade_lots AS has_premade_lots_50,
  t0.is_auto_triage_truckload AS is_auto_triage_truckload_51,
  t0.auto_triage_category_name AS auto_triage_category_name_52,
  t0.auto_triage_category_discount AS auto_triage_category_discount_53,
  t0.archived_at AS archived_at_54,
  t0.is_final AS is_final_55,
  t0.final_total_manifest_items AS final_total_manifest_items_56,
  t0.final_total_analyzed_items AS final_total_analyzed_items_57,
  t0.final_total_different_items AS final_total_different_items_58,
  t0.final_total_triage_items AS final_total_triage_items_59,
  t0.final_import_unit_quantity AS final_import_unit_quantity_60,
  t0.final_total_hours AS final_total_hours_61,
  t0.final_total_scans_per_hour AS final_total_scans_per_hour_62,
  t0.final_msrp AS final_msrp_63,
  t0.final_estimated_sales_listing AS final_estimated_sales_listing_64,
  t0.final_selling_po AS final_selling_po_65,
  t0.final_cog_real AS final_cog_real_66,
  t0.final_nb_lots AS final_nb_lots_67,
  t0.is_new_mappings_required AS is_new_mappings_required_68,
  t0.auto_analysis_start_at AS auto_analysis_start_at_69,
  t0.auto_analysis_end_at AS auto_analysis_end_at_70,
  t0.current_synccentric_campaign AS current_synccentric_campaign_71,
  t0.analysis_queue_priority AS analysis_queue_priority_72,
  t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73,
  t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74,
  t0.synccentric_export_current_page AS synccentric_export_current_page_75,
  t0.synccentric_export_last_page AS synccentric_export_last_page_76,
  t0.is_synccentric_search_required AS is_synccentric_search_required_77,
  t0.is_synccentric_import_running AS is_synccentric_import_running_78,
  t0.is_synccentric_import_done AS is_synccentric_import_done_79,
  t0.is_synccentric_search_running AS is_synccentric_search_running_80,
  t0.is_synccentric_search_done AS is_synccentric_search_done_81,
  t0.is_synccentric_export_running AS is_synccentric_export_running_82,
  t0.is_synccentric_export_done AS is_synccentric_export_done_83,
  t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84,
  t0.is_synccentric_import_started AS is_synccentric_import_started_85,
  t0.is_synccentric_export_started AS is_synccentric_export_started_86,
  t0.is_autoanalysis_started AS is_autoanalysis_started_87,
  t0.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88,
  t0.has_batch_ids AS has_batch_ids_89,
  t0.status_id AS status_id_90,
  t0.supplier_id AS supplier_id_91,
  t0.product_condition_id AS product_condition_id_92,
  t0.manifest_style_id AS manifest_style_id_93,
  t0.invoice_style_id AS invoice_style_id_94,
  t0.supplier_invoice_state_id AS supplier_invoice_state_id_95,
  t0.warehouse_id AS warehouse_id_96,
  t0.auto_triage_category_id AS auto_triage_category_id_97
FROM
  po t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.nb_pallet AS nb_pallet_4, t0.nb_unit AS nb_unit_5, t0.eta AS eta_6, t0.received_at AS received_at_7, t0.manifest_import AS manifest_import_8, t0.note AS note_9, t0.cost_po AS cost_po_10, t0.cost_transport AS cost_transport_11, t0.cost_customs AS cost_customs_12, t0.msrp_value AS msrp_value_13, t0.finances_selling_estimated AS finances_selling_estimated_14, t0.seal_number_provided AS seal_number_provided_15, t0.seal_number_received AS seal_number_received_16, t0.nb_unit_received AS nb_unit_received_17, t0.nb_pallet_received AS nb_pallet_received_18, t0.seal_number_na AS seal_number_na_19, t0.note_reception AS note_reception_20, t0.location AS location_21, t0.progress_step_reception AS progress_step_reception_22, t0.progress_step_scan_manifest AS progress_step_scan_manifest_23, t0.progress_step_import_manifest AS progress_step_import_manifest_24, t0.progress_step_analysis AS progress_step_analysis_25, t0.progress_step_preparation AS progress_step_preparation_26, t0.progress_step_triage AS progress_step_triage_27, t0.progress_step_photobooth AS progress_step_photobooth_28, t0.progress_step_listing AS progress_step_listing_29, t0.progress_step_conciliation AS progress_step_conciliation_30, t0.preparation_total_units AS preparation_total_units_31, t0.preparation_total_extended AS preparation_total_extended_32, t0.preparation_total_selling_extended AS preparation_total_selling_extended_33, t0.preparation_total_cps AS preparation_total_cps_34, t0.preparation_total_lots AS preparation_total_lots_35, t0.import_product_quantity AS import_product_quantity_36, t0.import_unit_quantity AS import_unit_quantity_37, t0.is_truckload AS is_truckload_38, t0.progress_step_truckload AS progress_step_truckload_39, t0.is_autoanalysis_running AS is_autoanalysis_running_40, t0.is_autoanalysis_done AS is_autoanalysis_done_41, t0.bol_supplier AS bol_supplier_42, t0.customs_description AS customs_description_43, t0.customs_country_of_origin AS customs_country_of_origin_44, t0.customs_hs_code AS customs_hs_code_45, t0.cost_production AS cost_production_46, t0.next_cp_number AS next_cp_number_47, t0.is_auto_triage AS is_auto_triage_48, t0.is_lot_import_allowed AS is_lot_import_allowed_49, t0.has_premade_lots AS has_premade_lots_50, t0.is_auto_triage_truckload AS is_auto_triage_truckload_51, t0.auto_triage_category_name AS auto_triage_category_name_52, t0.auto_triage_category_discount AS auto_triage_category_discount_53, t0.archived_at AS archived_at_54, t0.is_final AS is_final_55, t0.final_total_manifest_items AS final_total_manifest_items_56, t0.final_total_analyzed_items AS final_total_analyzed_items_57, t0.final_total_different_items AS final_total_different_items_58, t0.final_total_triage_items AS final_total_triage_items_59, t0.final_import_unit_quantity AS final_import_unit_quantity_60, t0.final_total_hours AS final_total_hours_61, t0.final_total_scans_per_hour AS final_total_scans_per_hour_62, t0.final_msrp AS final_msrp_63, t0.final_estimated_sales_listing AS final_estimated_sales_listing_64, t0.final_selling_po AS final_selling_po_65, t0.final_cog_real AS final_cog_real_66, t0.final_nb_lots AS final_nb_lots_67, t0.is_new_mappings_required AS is_new_mappings_required_68, t0.auto_analysis_start_at AS auto_analysis_start_at_69, t0.auto_analysis_end_at AS auto_analysis_end_at_70, t0.current_synccentric_campaign AS current_synccentric_campaign_71, t0.analysis_queue_priority AS analysis_queue_priority_72, t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74, t0.synccentric_export_current_page AS synccentric_export_current_page_75, t0.synccentric_export_last_page AS synccentric_export_last_page_76, t0.is_synccentric_search_required AS is_synccentric_search_required_77, t0.is_synccentric_import_running AS is_synccentric_import_running_78, t0.is_synccentric_import_done AS is_synccentric_import_done_79, t0.is_synccentric_search_running AS is_synccentric_search_running_80, t0.is_synccentric_search_done AS is_synccentric_search_done_81, t0.is_synccentric_export_running AS is_synccentric_export_running_82, t0.is_synccentric_export_done AS is_synccentric_export_done_83, t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84, t0.is_synccentric_import_started AS is_synccentric_import_started_85, t0.is_synccentric_export_started AS is_synccentric_export_started_86, t0.is_autoanalysis_started AS is_autoanalysis_started_87, t0.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88, t0.has_batch_ids AS has_batch_ids_89, t0.status_id AS status_id_90, t0.supplier_id AS supplier_id_91, t0.product_condition_id AS product_condition_id_92, t0.manifest_style_id AS manifest_style_id_93, t0.invoice_style_id AS invoice_style_id_94, t0.supplier_invoice_state_id AS supplier_invoice_state_id_95, t0.warehouse_id AS warehouse_id_96, t0.auto_triage_category_id AS auto_triage_category_id_97 FROM po t0 WHERE t0.id = '3559';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.exchange_rate AS exchange_rate_3,
  t0.position AS position_4,
  t0.is_msrp_source AS is_msrp_source_5,
  t0.is_name_source AS is_name_source_6
FROM
  upcitemdb_source t0
WHERE
  t0.is_msrp_source = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_msrp_source = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.exchange_rate AS exchange_rate_3,
  t0.position AS position_4,
  t0.is_msrp_source AS is_msrp_source_5,
  t0.is_name_source AS is_name_source_6
FROM
  upcitemdb_source t0
WHERE
  t0.is_name_source = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_name_source = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.is_unclassified AS is_unclassified_2,
  t0.is_cp AS is_cp_3,
  t0.is_high_value AS is_high_value_4,
  t0.units AS units_5,
  t0.msrp_total AS msrp_total_6,
  t0.nb_lots AS nb_lots_7,
  t0.name AS name_8,
  t0.discount AS discount_9,
  t0.estimated_sales AS estimated_sales_10,
  t0.cp_quantity AS cp_quantity_11,
  t0.display_name AS display_name_12,
  t0.is_empty AS is_empty_13,
  t0.is_action AS is_action_14,
  t0.is_flag_preparation_done AS is_flag_preparation_done_15,
  t0.is_oversize AS is_oversize_16,
  t0.po_id AS po_id_17,
  t0.restock_category_id AS restock_category_id_18,
  t0.merged_with_id AS merged_with_id_19,
  t0.cp_product_id AS cp_product_id_20,
  t0.cp_manifest_item_id AS cp_manifest_item_id_21,
  t0.product_condition_id AS product_condition_id_22
FROM
  preparation_lot t0
WHERE
  t0.po_id = ?
ORDER BY
  t0.estimated_sales DESC

SELECT t0.id AS id_1, t0.is_unclassified AS is_unclassified_2, t0.is_cp AS is_cp_3, t0.is_high_value AS is_high_value_4, t0.units AS units_5, t0.msrp_total AS msrp_total_6, t0.nb_lots AS nb_lots_7, t0.name AS name_8, t0.discount AS discount_9, t0.estimated_sales AS estimated_sales_10, t0.cp_quantity AS cp_quantity_11, t0.display_name AS display_name_12, t0.is_empty AS is_empty_13, t0.is_action AS is_action_14, t0.is_flag_preparation_done AS is_flag_preparation_done_15, t0.is_oversize AS is_oversize_16, t0.po_id AS po_id_17, t0.restock_category_id AS restock_category_id_18, t0.merged_with_id AS merged_with_id_19, t0.cp_product_id AS cp_product_id_20, t0.cp_manifest_item_id AS cp_manifest_item_id_21, t0.product_condition_id AS product_condition_id_22 FROM preparation_lot t0 WHERE t0.po_id = 3559 ORDER BY t0.estimated_sales DESC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.quantity AS quantity_3,
  t0.method AS method_4,
  t0.msrp AS msrp_5,
  t0.name AS name_6,
  t0.category AS category_7,
  t0.merchant_sku AS merchant_sku_8,
  t0.is_analyzed AS is_analyzed_9,
  t0.analyzed_at AS analyzed_at_10,
  t0.is_auto_analyzed AS is_auto_analyzed_11,
  t0.converted AS converted_12,
  t0.is_generic AS is_generic_13,
  t0.position AS position_14,
  t0.is_cp AS is_cp_15,
  t0.is_high_value AS is_high_value_16,
  t0.is_prepared AS is_prepared_17,
  t0.preparation_cp_quantity AS preparation_cp_quantity_18,
  t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19,
  t0.preparation_cp_total_units AS preparation_cp_total_units_20,
  t0.preparation_cp_extended AS preparation_cp_extended_21,
  t0.preparation_cp_discount AS preparation_cp_discount_22,
  t0.cp_name AS cp_name_23,
  t0.cp_display_name AS cp_display_name_24,
  t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25,
  t0.preparation_lot_units AS preparation_lot_units_26,
  t0.preparation_lot_discount AS preparation_lot_discount_27,
  t0.preparation_lot_extended AS preparation_lot_extended_28,
  t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29,
  t0.is_upcitemdb_error AS is_upcitemdb_error_30,
  t0.is_already_in_database AS is_already_in_database_31,
  t0.photo AS photo_32,
  t0.quantity_imported AS quantity_imported_33,
  t0.quantity_scanned AS quantity_scanned_34,
  t0.quantity_triage AS quantity_triage_35,
  t0.is_flag_preparation_done AS is_flag_preparation_done_36,
  t0.premade_lot_number AS premade_lot_number_37,
  t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38,
  t0.is_synccentric_search_required AS is_synccentric_search_required_39,
  t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40,
  t0.is_sent_to_synccentric AS is_sent_to_synccentric_41,
  t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42,
  t0.is_validation AS is_validation_43,
  t0.is_skipped_for_analysis AS is_skipped_for_analysis_44,
  t0.supplier_pallet_number AS supplier_pallet_number_45,
  t0.created_at AS created_at_46,
  t0.updated_at AS updated_at_47,
  t0.po_id AS po_id_48,
  t0.product_id AS product_id_49,
  t0.scanned_by_id AS scanned_by_id_50,
  t0.imported_by_id AS imported_by_id_51,
  t0.analyzed_by_id AS analyzed_by_id_52,
  t0.supplier_id AS supplier_id_53,
  t0.original_preparation_lot_id AS original_preparation_lot_id_54,
  t0.restock_category_id AS restock_category_id_55,
  t0.preparation_lot_id AS preparation_lot_id_56,
  t0.triage_category_id AS triage_category_id_57
FROM
  manifest_item t0
WHERE
  t0.preparation_lot_id = ?
ORDER BY
  t0.preparation_lot_extended DESC

SELECT t0.id AS id_1, t0.code AS code_2, t0.quantity AS quantity_3, t0.method AS method_4, t0.msrp AS msrp_5, t0.name AS name_6, t0.category AS category_7, t0.merchant_sku AS merchant_sku_8, t0.is_analyzed AS is_analyzed_9, t0.analyzed_at AS analyzed_at_10, t0.is_auto_analyzed AS is_auto_analyzed_11, t0.converted AS converted_12, t0.is_generic AS is_generic_13, t0.position AS position_14, t0.is_cp AS is_cp_15, t0.is_high_value AS is_high_value_16, t0.is_prepared AS is_prepared_17, t0.preparation_cp_quantity AS preparation_cp_quantity_18, t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19, t0.preparation_cp_total_units AS preparation_cp_total_units_20, t0.preparation_cp_extended AS preparation_cp_extended_21, t0.preparation_cp_discount AS preparation_cp_discount_22, t0.cp_name AS cp_name_23, t0.cp_display_name AS cp_display_name_24, t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25, t0.preparation_lot_units AS preparation_lot_units_26, t0.preparation_lot_discount AS preparation_lot_discount_27, t0.preparation_lot_extended AS preparation_lot_extended_28, t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29, t0.is_upcitemdb_error AS is_upcitemdb_error_30, t0.is_already_in_database AS is_already_in_database_31, t0.photo AS photo_32, t0.quantity_imported AS quantity_imported_33, t0.quantity_scanned AS quantity_scanned_34, t0.quantity_triage AS quantity_triage_35, t0.is_flag_preparation_done AS is_flag_preparation_done_36, t0.premade_lot_number AS premade_lot_number_37, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38, t0.is_synccentric_search_required AS is_synccentric_search_required_39, t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40, t0.is_sent_to_synccentric AS is_sent_to_synccentric_41, t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42, t0.is_validation AS is_validation_43, t0.is_skipped_for_analysis AS is_skipped_for_analysis_44, t0.supplier_pallet_number AS supplier_pallet_number_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.po_id AS po_id_48, t0.product_id AS product_id_49, t0.scanned_by_id AS scanned_by_id_50, t0.imported_by_id AS imported_by_id_51, t0.analyzed_by_id AS analyzed_by_id_52, t0.supplier_id AS supplier_id_53, t0.original_preparation_lot_id AS original_preparation_lot_id_54, t0.restock_category_id AS restock_category_id_55, t0.preparation_lot_id AS preparation_lot_id_56, t0.triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0.preparation_lot_id = 32324 ORDER BY t0.preparation_lot_extended DESC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.quantity AS quantity_3,
  t0.method AS method_4,
  t0.msrp AS msrp_5,
  t0.name AS name_6,
  t0.category AS category_7,
  t0.merchant_sku AS merchant_sku_8,
  t0.is_analyzed AS is_analyzed_9,
  t0.analyzed_at AS analyzed_at_10,
  t0.is_auto_analyzed AS is_auto_analyzed_11,
  t0.converted AS converted_12,
  t0.is_generic AS is_generic_13,
  t0.position AS position_14,
  t0.is_cp AS is_cp_15,
  t0.is_high_value AS is_high_value_16,
  t0.is_prepared AS is_prepared_17,
  t0.preparation_cp_quantity AS preparation_cp_quantity_18,
  t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19,
  t0.preparation_cp_total_units AS preparation_cp_total_units_20,
  t0.preparation_cp_extended AS preparation_cp_extended_21,
  t0.preparation_cp_discount AS preparation_cp_discount_22,
  t0.cp_name AS cp_name_23,
  t0.cp_display_name AS cp_display_name_24,
  t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25,
  t0.preparation_lot_units AS preparation_lot_units_26,
  t0.preparation_lot_discount AS preparation_lot_discount_27,
  t0.preparation_lot_extended AS preparation_lot_extended_28,
  t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29,
  t0.is_upcitemdb_error AS is_upcitemdb_error_30,
  t0.is_already_in_database AS is_already_in_database_31,
  t0.photo AS photo_32,
  t0.quantity_imported AS quantity_imported_33,
  t0.quantity_scanned AS quantity_scanned_34,
  t0.quantity_triage AS quantity_triage_35,
  t0.is_flag_preparation_done AS is_flag_preparation_done_36,
  t0.premade_lot_number AS premade_lot_number_37,
  t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38,
  t0.is_synccentric_search_required AS is_synccentric_search_required_39,
  t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40,
  t0.is_sent_to_synccentric AS is_sent_to_synccentric_41,
  t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42,
  t0.is_validation AS is_validation_43,
  t0.is_skipped_for_analysis AS is_skipped_for_analysis_44,
  t0.supplier_pallet_number AS supplier_pallet_number_45,
  t0.created_at AS created_at_46,
  t0.updated_at AS updated_at_47,
  t0.po_id AS po_id_48,
  t0.product_id AS product_id_49,
  t0.scanned_by_id AS scanned_by_id_50,
  t0.imported_by_id AS imported_by_id_51,
  t0.analyzed_by_id AS analyzed_by_id_52,
  t0.supplier_id AS supplier_id_53,
  t0.original_preparation_lot_id AS original_preparation_lot_id_54,
  t0.restock_category_id AS restock_category_id_55,
  t0.preparation_lot_id AS preparation_lot_id_56,
  t0.triage_category_id AS triage_category_id_57
FROM
  manifest_item t0
WHERE
  t0.preparation_lot_id = ?
ORDER BY
  t0.preparation_lot_extended DESC

SELECT t0.id AS id_1, t0.code AS code_2, t0.quantity AS quantity_3, t0.method AS method_4, t0.msrp AS msrp_5, t0.name AS name_6, t0.category AS category_7, t0.merchant_sku AS merchant_sku_8, t0.is_analyzed AS is_analyzed_9, t0.analyzed_at AS analyzed_at_10, t0.is_auto_analyzed AS is_auto_analyzed_11, t0.converted AS converted_12, t0.is_generic AS is_generic_13, t0.position AS position_14, t0.is_cp AS is_cp_15, t0.is_high_value AS is_high_value_16, t0.is_prepared AS is_prepared_17, t0.preparation_cp_quantity AS preparation_cp_quantity_18, t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19, t0.preparation_cp_total_units AS preparation_cp_total_units_20, t0.preparation_cp_extended AS preparation_cp_extended_21, t0.preparation_cp_discount AS preparation_cp_discount_22, t0.cp_name AS cp_name_23, t0.cp_display_name AS cp_display_name_24, t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25, t0.preparation_lot_units AS preparation_lot_units_26, t0.preparation_lot_discount AS preparation_lot_discount_27, t0.preparation_lot_extended AS preparation_lot_extended_28, t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29, t0.is_upcitemdb_error AS is_upcitemdb_error_30, t0.is_already_in_database AS is_already_in_database_31, t0.photo AS photo_32, t0.quantity_imported AS quantity_imported_33, t0.quantity_scanned AS quantity_scanned_34, t0.quantity_triage AS quantity_triage_35, t0.is_flag_preparation_done AS is_flag_preparation_done_36, t0.premade_lot_number AS premade_lot_number_37, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38, t0.is_synccentric_search_required AS is_synccentric_search_required_39, t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40, t0.is_sent_to_synccentric AS is_sent_to_synccentric_41, t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42, t0.is_validation AS is_validation_43, t0.is_skipped_for_analysis AS is_skipped_for_analysis_44, t0.supplier_pallet_number AS supplier_pallet_number_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.po_id AS po_id_48, t0.product_id AS product_id_49, t0.scanned_by_id AS scanned_by_id_50, t0.imported_by_id AS imported_by_id_51, t0.analyzed_by_id AS analyzed_by_id_52, t0.supplier_id AS supplier_id_53, t0.original_preparation_lot_id AS original_preparation_lot_id_54, t0.restock_category_id AS restock_category_id_55, t0.preparation_lot_id AS preparation_lot_id_56, t0.triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0.preparation_lot_id = 32329 ORDER BY t0.preparation_lot_extended DESC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.quantity AS quantity_3,
  t0.method AS method_4,
  t0.msrp AS msrp_5,
  t0.name AS name_6,
  t0.category AS category_7,
  t0.merchant_sku AS merchant_sku_8,
  t0.is_analyzed AS is_analyzed_9,
  t0.analyzed_at AS analyzed_at_10,
  t0.is_auto_analyzed AS is_auto_analyzed_11,
  t0.converted AS converted_12,
  t0.is_generic AS is_generic_13,
  t0.position AS position_14,
  t0.is_cp AS is_cp_15,
  t0.is_high_value AS is_high_value_16,
  t0.is_prepared AS is_prepared_17,
  t0.preparation_cp_quantity AS preparation_cp_quantity_18,
  t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19,
  t0.preparation_cp_total_units AS preparation_cp_total_units_20,
  t0.preparation_cp_extended AS preparation_cp_extended_21,
  t0.preparation_cp_discount AS preparation_cp_discount_22,
  t0.cp_name AS cp_name_23,
  t0.cp_display_name AS cp_display_name_24,
  t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25,
  t0.preparation_lot_units AS preparation_lot_units_26,
  t0.preparation_lot_discount AS preparation_lot_discount_27,
  t0.preparation_lot_extended AS preparation_lot_extended_28,
  t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29,
  t0.is_upcitemdb_error AS is_upcitemdb_error_30,
  t0.is_already_in_database AS is_already_in_database_31,
  t0.photo AS photo_32,
  t0.quantity_imported AS quantity_imported_33,
  t0.quantity_scanned AS quantity_scanned_34,
  t0.quantity_triage AS quantity_triage_35,
  t0.is_flag_preparation_done AS is_flag_preparation_done_36,
  t0.premade_lot_number AS premade_lot_number_37,
  t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38,
  t0.is_synccentric_search_required AS is_synccentric_search_required_39,
  t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40,
  t0.is_sent_to_synccentric AS is_sent_to_synccentric_41,
  t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42,
  t0.is_validation AS is_validation_43,
  t0.is_skipped_for_analysis AS is_skipped_for_analysis_44,
  t0.supplier_pallet_number AS supplier_pallet_number_45,
  t0.created_at AS created_at_46,
  t0.updated_at AS updated_at_47,
  t0.po_id AS po_id_48,
  t0.product_id AS product_id_49,
  t0.scanned_by_id AS scanned_by_id_50,
  t0.imported_by_id AS imported_by_id_51,
  t0.analyzed_by_id AS analyzed_by_id_52,
  t0.supplier_id AS supplier_id_53,
  t0.original_preparation_lot_id AS original_preparation_lot_id_54,
  t0.restock_category_id AS restock_category_id_55,
  t0.preparation_lot_id AS preparation_lot_id_56,
  t0.triage_category_id AS triage_category_id_57
FROM
  manifest_item t0
WHERE
  t0.preparation_lot_id = ?
ORDER BY
  t0.preparation_lot_extended DESC

SELECT t0.id AS id_1, t0.code AS code_2, t0.quantity AS quantity_3, t0.method AS method_4, t0.msrp AS msrp_5, t0.name AS name_6, t0.category AS category_7, t0.merchant_sku AS merchant_sku_8, t0.is_analyzed AS is_analyzed_9, t0.analyzed_at AS analyzed_at_10, t0.is_auto_analyzed AS is_auto_analyzed_11, t0.converted AS converted_12, t0.is_generic AS is_generic_13, t0.position AS position_14, t0.is_cp AS is_cp_15, t0.is_high_value AS is_high_value_16, t0.is_prepared AS is_prepared_17, t0.preparation_cp_quantity AS preparation_cp_quantity_18, t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19, t0.preparation_cp_total_units AS preparation_cp_total_units_20, t0.preparation_cp_extended AS preparation_cp_extended_21, t0.preparation_cp_discount AS preparation_cp_discount_22, t0.cp_name AS cp_name_23, t0.cp_display_name AS cp_display_name_24, t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25, t0.preparation_lot_units AS preparation_lot_units_26, t0.preparation_lot_discount AS preparation_lot_discount_27, t0.preparation_lot_extended AS preparation_lot_extended_28, t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29, t0.is_upcitemdb_error AS is_upcitemdb_error_30, t0.is_already_in_database AS is_already_in_database_31, t0.photo AS photo_32, t0.quantity_imported AS quantity_imported_33, t0.quantity_scanned AS quantity_scanned_34, t0.quantity_triage AS quantity_triage_35, t0.is_flag_preparation_done AS is_flag_preparation_done_36, t0.premade_lot_number AS premade_lot_number_37, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38, t0.is_synccentric_search_required AS is_synccentric_search_required_39, t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40, t0.is_sent_to_synccentric AS is_sent_to_synccentric_41, t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42, t0.is_validation AS is_validation_43, t0.is_skipped_for_analysis AS is_skipped_for_analysis_44, t0.supplier_pallet_number AS supplier_pallet_number_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.po_id AS po_id_48, t0.product_id AS product_id_49, t0.scanned_by_id AS scanned_by_id_50, t0.imported_by_id AS imported_by_id_51, t0.analyzed_by_id AS analyzed_by_id_52, t0.supplier_id AS supplier_id_53, t0.original_preparation_lot_id AS original_preparation_lot_id_54, t0.restock_category_id AS restock_category_id_55, t0.preparation_lot_id AS preparation_lot_id_56, t0.triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0.preparation_lot_id = 32323 ORDER BY t0.preparation_lot_extended DESC;