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

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.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.status_id AS status_id_88,
  t0.supplier_id AS supplier_id_89,
  t0.product_condition_id AS product_condition_id_90,
  t0.manifest_style_id AS manifest_style_id_91,
  t0.invoice_style_id AS invoice_style_id_92,
  t0.supplier_invoice_state_id AS supplier_invoice_state_id_93,
  t0.warehouse_id AS warehouse_id_94,
  t0.auto_triage_category_id AS auto_triage_category_id_95
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.status_id AS status_id_88, t0.supplier_id AS supplier_id_89, t0.product_condition_id AS product_condition_id_90, t0.manifest_style_id AS manifest_style_id_91, t0.invoice_style_id AS invoice_style_id_92, t0.supplier_invoice_state_id AS supplier_invoice_state_id_93, t0.warehouse_id AS warehouse_id_94, t0.auto_triage_category_id AS auto_triage_category_id_95 FROM po t0 WHERE t0.id = '2634';

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.last_scan_at AS last_scan_at_3,
  t0.po_id AS po_id_4,
  t0.user_id AS user_id_5
FROM
  triage_user t0
WHERE
  t0.po_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.last_scan_at AS last_scan_at_3, t0.po_id AS po_id_4, t0.user_id AS user_id_5 FROM triage_user t0 WHERE t0.po_id = 2634;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  manifest_style t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM manifest_style t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.session_number AS session_number_2,
  t0.code AS code_3,
  t0.scan_type AS scan_type_4,
  t0.is_confirmed AS is_confirmed_5,
  t0.is_generic AS is_generic_6,
  t0.is_validation AS is_validation_7,
  t0.is_category_validation AS is_category_validation_8,
  t0.is_action AS is_action_9,
  t0.is_question AS is_question_10,
  t0.has_error AS has_error_11,
  t0.is_deleted AS is_deleted_12,
  t0.confirm_request AS confirm_request_13,
  t0.is_error AS is_error_14,
  t0.result_template AS result_template_15,
  t0.msrp AS msrp_16,
  t0.has_cp AS has_cp_17,
  t0.cp_name AS cp_name_18,
  t0.cp_number AS cp_number_19,
  t0.cp_quantity AS cp_quantity_20,
  t0.is_confirmed_lot AS is_confirmed_lot_21,
  t0.is_confirmed_cp AS is_confirmed_cp_22,
  t0.is_rejected AS is_rejected_23,
  t0.cp_package AS cp_package_24,
  t0.show_oversize_button AS show_oversize_button_25,
  t0.user_id AS user_id_26,
  t0.po_id AS po_id_27,
  t0.manifest_item_id AS manifest_item_id_28,
  t0.lot_id AS lot_id_29,
  t0.action_id AS action_id_30,
  t0.triage_question_id AS triage_question_id_31,
  t0.lot_item_id AS lot_item_id_32,
  t0.scan_category_group_id AS scan_category_group_id_33,
  t0.oversize_lot_id AS oversize_lot_id_34
FROM
  triage_scan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.session_number AS session_number_2, t0.code AS code_3, t0.scan_type AS scan_type_4, t0.is_confirmed AS is_confirmed_5, t0.is_generic AS is_generic_6, t0.is_validation AS is_validation_7, t0.is_category_validation AS is_category_validation_8, t0.is_action AS is_action_9, t0.is_question AS is_question_10, t0.has_error AS has_error_11, t0.is_deleted AS is_deleted_12, t0.confirm_request AS confirm_request_13, t0.is_error AS is_error_14, t0.result_template AS result_template_15, t0.msrp AS msrp_16, t0.has_cp AS has_cp_17, t0.cp_name AS cp_name_18, t0.cp_number AS cp_number_19, t0.cp_quantity AS cp_quantity_20, t0.is_confirmed_lot AS is_confirmed_lot_21, t0.is_confirmed_cp AS is_confirmed_cp_22, t0.is_rejected AS is_rejected_23, t0.cp_package AS cp_package_24, t0.show_oversize_button AS show_oversize_button_25, t0.user_id AS user_id_26, t0.po_id AS po_id_27, t0.manifest_item_id AS manifest_item_id_28, t0.lot_id AS lot_id_29, t0.action_id AS action_id_30, t0.triage_question_id AS triage_question_id_31, t0.lot_item_id AS lot_item_id_32, t0.scan_category_group_id AS scan_category_group_id_33, t0.oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0.id = '5050088';

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.created_at AS created_at_45,
  t0.updated_at AS updated_at_46,
  t0.po_id AS po_id_47,
  t0.product_id AS product_id_48,
  t0.scanned_by_id AS scanned_by_id_49,
  t0.imported_by_id AS imported_by_id_50,
  t0.analyzed_by_id AS analyzed_by_id_51,
  t0.supplier_id AS supplier_id_52,
  t0.original_preparation_lot_id AS original_preparation_lot_id_53,
  t0.restock_category_id AS restock_category_id_54,
  t0.preparation_lot_id AS preparation_lot_id_55,
  t0.triage_category_id AS triage_category_id_56
FROM
  manifest_item t0
WHERE
  t0.id = ?

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.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.po_id AS po_id_47, t0.product_id AS product_id_48, t0.scanned_by_id AS scanned_by_id_49, t0.imported_by_id AS imported_by_id_50, t0.analyzed_by_id AS analyzed_by_id_51, t0.supplier_id AS supplier_id_52, t0.original_preparation_lot_id AS original_preparation_lot_id_53, t0.restock_category_id AS restock_category_id_54, t0.preparation_lot_id AS preparation_lot_id_55, t0.triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0.id = 4807229;

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.is_oversize AS is_oversize_32,
  t0.cost AS cost_33,
  t0.is_imported AS is_imported_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.number = ?
  AND t0.is_closed = ?
  AND t0.po_id = ?
LIMIT
  1

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.is_oversize AS is_oversize_32, t0.cost AS cost_33, t0.is_imported AS is_imported_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.number = '836344' AND t0.is_closed = 0 AND t0.po_id = 2634 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.contact_main_name AS contact_main_name_4,
  t0.contact_main_phone AS contact_main_phone_5,
  t0.contact_main_extension AS contact_main_extension_6,
  t0.contact_main_email AS contact_main_email_7,
  t0.contact_director_name AS contact_director_name_8,
  t0.contact_director_phone AS contact_director_phone_9,
  t0.contact_director_extension AS contact_director_extension_10,
  t0.contact_director_email AS contact_director_email_11,
  t0.contact_supervisor_name AS contact_supervisor_name_12,
  t0.contact_supervisor_phone AS contact_supervisor_phone_13,
  t0.contact_supervisor_extension AS contact_supervisor_extension_14,
  t0.contact_supervisor_email AS contact_supervisor_email_15,
  t0.contact_shipping_name AS contact_shipping_name_16,
  t0.contact_shipping_phone AS contact_shipping_phone_17,
  t0.contact_shipping_extension AS contact_shipping_extension_18,
  t0.contact_shipping_email AS contact_shipping_email_19,
  t0.contact_billing_name AS contact_billing_name_20,
  t0.contact_billing_phone AS contact_billing_phone_21,
  t0.contact_billing_extension AS contact_billing_extension_22,
  t0.contact_billing_email AS contact_billing_email_23,
  t0.email AS email_24,
  t0.is_active AS is_active_25,
  t0.shipping_state AS shipping_state_26,
  t0.shipping_country AS shipping_country_27,
  t0.shipping_postcode AS shipping_postcode_28,
  t0.is_deleted AS is_deleted_29
FROM
  warehouse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.contact_main_name AS contact_main_name_4, t0.contact_main_phone AS contact_main_phone_5, t0.contact_main_extension AS contact_main_extension_6, t0.contact_main_email AS contact_main_email_7, t0.contact_director_name AS contact_director_name_8, t0.contact_director_phone AS contact_director_phone_9, t0.contact_director_extension AS contact_director_extension_10, t0.contact_director_email AS contact_director_email_11, t0.contact_supervisor_name AS contact_supervisor_name_12, t0.contact_supervisor_phone AS contact_supervisor_phone_13, t0.contact_supervisor_extension AS contact_supervisor_extension_14, t0.contact_supervisor_email AS contact_supervisor_email_15, t0.contact_shipping_name AS contact_shipping_name_16, t0.contact_shipping_phone AS contact_shipping_phone_17, t0.contact_shipping_extension AS contact_shipping_extension_18, t0.contact_shipping_email AS contact_shipping_email_19, t0.contact_billing_name AS contact_billing_name_20, t0.contact_billing_phone AS contact_billing_phone_21, t0.contact_billing_extension AS contact_billing_extension_22, t0.contact_billing_email AS contact_billing_email_23, t0.email AS email_24, t0.is_active AS is_active_25, t0.shipping_state AS shipping_state_26, t0.shipping_country AS shipping_country_27, t0.shipping_postcode AS shipping_postcode_28, t0.is_deleted AS is_deleted_29 FROM warehouse t0 WHERE t0.id = 1;

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.lot_id AS lot_id_8,
  t0.product_id AS product_id_9,
  t0.po_id AS po_id_10,
  t0.manifest_item_id AS manifest_item_id_11,
  t0.original_lot_id AS original_lot_id_12,
  t0.duplicate_of_id AS duplicate_of_id_13
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.lot_id AS lot_id_8, t0.product_id AS product_id_9, t0.po_id AS po_id_10, t0.manifest_item_id AS manifest_item_id_11, t0.original_lot_id AS original_lot_id_12, t0.duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0.lot_id = 49492 ORDER BY t0.extended DESC;