1
0.49 ms
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 = 114 ;
Copy
2
0.13 ms
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 ;
Copy
3
0.12 ms
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 ;
Copy
4
0.20 ms
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 = ?
Copy
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 = '3722' ;
Copy
5
0.12 ms
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 = 3722 ;
Copy
6
0.13 ms
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 = 2 ;
Copy
7
0.14 ms
SELECT t0 . id AS id_1 , t0 . sku AS sku_2 , t0 . action AS action_3 , t0 . supplier_id AS supplier_id_4 FROM special_merchant_sku t0 WHERE t0 . sku = ? AND t0 . supplier_id = ? LIMIT 1
Parameters :
[
"B0DQYNDHHJ "
55
]
SELECT t0 . id AS id_1 , t0 . sku AS sku_2 , t0 . action AS action_3 , t0 . supplier_id AS supplier_id_4 FROM special_merchant_sku t0 WHERE t0 . sku = 'B0DQYNDHHJ' AND t0 . supplier_id = 55 LIMIT 1 ;
Copy
8
2.25 ms
SELECT m0_ . id AS id_0 , m0_ . code AS code_1 , m0_ . quantity AS quantity_2 , m0_ . method AS method_3 , m0_ . msrp AS msrp_4 , m0_ . name AS name_5 , m0_ . category AS category_6 , m0_ . merchant_sku AS merchant_sku_7 , m0_ . is_analyzed AS is_analyzed_8 , m0_ . analyzed_at AS analyzed_at_9 , m0_ . is_auto_analyzed AS is_auto_analyzed_10 , m0_ . converted AS converted_11 , m0_ . is_generic AS is_generic_12 , m0_ . position AS position_13 , m0_ . is_cp AS is_cp_14 , m0_ . is_high_value AS is_high_value_15 , m0_ . is_prepared AS is_prepared_16 , m0_ . preparation_cp_quantity AS preparation_cp_quantity_17 , m0_ . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_18 , m0_ . preparation_cp_total_units AS preparation_cp_total_units_19 , m0_ . preparation_cp_extended AS preparation_cp_extended_20 , m0_ . preparation_cp_discount AS preparation_cp_discount_21 , m0_ . cp_name AS cp_name_22 , m0_ . cp_display_name AS cp_display_name_23 , m0_ . preparation_cp_selling_extended AS preparation_cp_selling_extended_24 , m0_ . preparation_lot_units AS preparation_lot_units_25 , m0_ . preparation_lot_discount AS preparation_lot_discount_26 , m0_ . preparation_lot_extended AS preparation_lot_extended_27 , m0_ . preparation_lot_selling_extended AS preparation_lot_selling_extended_28 , m0_ . is_upcitemdb_error AS is_upcitemdb_error_29 , m0_ . is_already_in_database AS is_already_in_database_30 , m0_ . photo AS photo_31 , m0_ . quantity_imported AS quantity_imported_32 , m0_ . quantity_scanned AS quantity_scanned_33 , m0_ . quantity_triage AS quantity_triage_34 , m0_ . is_flag_preparation_done AS is_flag_preparation_done_35 , m0_ . premade_lot_number AS premade_lot_number_36 , m0_ . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_37 , m0_ . is_synccentric_search_required AS is_synccentric_search_required_38 , m0_ . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_39 , m0_ . is_sent_to_synccentric AS is_sent_to_synccentric_40 , m0_ . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_41 , m0_ . is_validation AS is_validation_42 , m0_ . is_skipped_for_analysis AS is_skipped_for_analysis_43 , m0_ . supplier_pallet_number AS supplier_pallet_number_44 , m0_ . created_at AS created_at_45 , m0_ . updated_at AS updated_at_46 , i1_ . id AS id_47 , i1_ . code AS code_48 , i1_ . is_doublon_checked AS is_doublon_checked_49 , i1_ . created_at AS created_at_50 , i1_ . updated_at AS updated_at_51 , m0_ . po_id AS po_id_52 , m0_ . product_id AS product_id_53 , m0_ . scanned_by_id AS scanned_by_id_54 , m0_ . imported_by_id AS imported_by_id_55 , m0_ . analyzed_by_id AS analyzed_by_id_56 , m0_ . supplier_id AS supplier_id_57 , m0_ . original_preparation_lot_id AS original_preparation_lot_id_58 , m0_ . restock_category_id AS restock_category_id_59 , m0_ . preparation_lot_id AS preparation_lot_id_60 , m0_ . triage_category_id AS triage_category_id_61 , i1_ . po_id AS po_id_62 , i1_ . manifest_item_id AS manifest_item_id_63 , i1_ . product_id AS product_id_64 , i1_ . supplier_id AS supplier_id_65 FROM manifest_item m0_ LEFT JOIN internal_sku i1_ ON m0_ . id = i1_ . manifest_item_id WHERE m0_ . po_id = ? AND (m0_ . code = ? OR m0_ . merchant_sku = ? OR i1_ . code = ? ) LIMIT 1
Parameters :
[
3722
"B0DQYNDHHJ "
"B0DQYNDHHJ "
"B0DQYNDHHJ "
]
SELECT
m0_ . id AS id_0 ,
m0_ . code AS code_1 ,
m0_ . quantity AS quantity_2 ,
m0_ . method AS method_3 ,
m0_ . msrp AS msrp_4 ,
m0_ . name AS name_5 ,
m0_ . category AS category_6 ,
m0_ . merchant_sku AS merchant_sku_7 ,
m0_ . is_analyzed AS is_analyzed_8 ,
m0_ . analyzed_at AS analyzed_at_9 ,
m0_ . is_auto_analyzed AS is_auto_analyzed_10 ,
m0_ . converted AS converted_11 ,
m0_ . is_generic AS is_generic_12 ,
m0_ . position AS position_13 ,
m0_ . is_cp AS is_cp_14 ,
m0_ . is_high_value AS is_high_value_15 ,
m0_ . is_prepared AS is_prepared_16 ,
m0_ . preparation_cp_quantity AS preparation_cp_quantity_17 ,
m0_ . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_18 ,
m0_ . preparation_cp_total_units AS preparation_cp_total_units_19 ,
m0_ . preparation_cp_extended AS preparation_cp_extended_20 ,
m0_ . preparation_cp_discount AS preparation_cp_discount_21 ,
m0_ . cp_name AS cp_name_22 ,
m0_ . cp_display_name AS cp_display_name_23 ,
m0_ . preparation_cp_selling_extended AS preparation_cp_selling_extended_24 ,
m0_ . preparation_lot_units AS preparation_lot_units_25 ,
m0_ . preparation_lot_discount AS preparation_lot_discount_26 ,
m0_ . preparation_lot_extended AS preparation_lot_extended_27 ,
m0_ . preparation_lot_selling_extended AS preparation_lot_selling_extended_28 ,
m0_ . is_upcitemdb_error AS is_upcitemdb_error_29 ,
m0_ . is_already_in_database AS is_already_in_database_30 ,
m0_ . photo AS photo_31 ,
m0_ . quantity_imported AS quantity_imported_32 ,
m0_ . quantity_scanned AS quantity_scanned_33 ,
m0_ . quantity_triage AS quantity_triage_34 ,
m0_ . is_flag_preparation_done AS is_flag_preparation_done_35 ,
m0_ . premade_lot_number AS premade_lot_number_36 ,
m0_ . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_37 ,
m0_ . is_synccentric_search_required AS is_synccentric_search_required_38 ,
m0_ . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_39 ,
m0_ . is_sent_to_synccentric AS is_sent_to_synccentric_40 ,
m0_ . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_41 ,
m0_ . is_validation AS is_validation_42 ,
m0_ . is_skipped_for_analysis AS is_skipped_for_analysis_43 ,
m0_ . supplier_pallet_number AS supplier_pallet_number_44 ,
m0_ . created_at AS created_at_45 ,
m0_ . updated_at AS updated_at_46 ,
i1_ . id AS id_47 ,
i1_ . code AS code_48 ,
i1_ . is_doublon_checked AS is_doublon_checked_49 ,
i1_ . created_at AS created_at_50 ,
i1_ . updated_at AS updated_at_51 ,
m0_ . po_id AS po_id_52 ,
m0_ . product_id AS product_id_53 ,
m0_ . scanned_by_id AS scanned_by_id_54 ,
m0_ . imported_by_id AS imported_by_id_55 ,
m0_ . analyzed_by_id AS analyzed_by_id_56 ,
m0_ . supplier_id AS supplier_id_57 ,
m0_ . original_preparation_lot_id AS original_preparation_lot_id_58 ,
m0_ . restock_category_id AS restock_category_id_59 ,
m0_ . preparation_lot_id AS preparation_lot_id_60 ,
m0_ . triage_category_id AS triage_category_id_61 ,
i1_ . po_id AS po_id_62 ,
i1_ . manifest_item_id AS manifest_item_id_63 ,
i1_ . product_id AS product_id_64 ,
i1_ . supplier_id AS supplier_id_65
FROM
manifest_item m0_
LEFT JOIN internal_sku i1_ ON m0_ . id = i1_ . manifest_item_id
WHERE
m0_ . po_id = ?
AND (
m0_ . code = ?
OR m0_ . merchant_sku = ?
OR i1_ . code = ?
)
LIMIT
1
Copy
SELECT m0_ . id AS id_0 , m0_ . code AS code_1 , m0_ . quantity AS quantity_2 , m0_ . method AS method_3 , m0_ . msrp AS msrp_4 , m0_ . name AS name_5 , m0_ . category AS category_6 , m0_ . merchant_sku AS merchant_sku_7 , m0_ . is_analyzed AS is_analyzed_8 , m0_ . analyzed_at AS analyzed_at_9 , m0_ . is_auto_analyzed AS is_auto_analyzed_10 , m0_ . converted AS converted_11 , m0_ . is_generic AS is_generic_12 , m0_ . position AS position_13 , m0_ . is_cp AS is_cp_14 , m0_ . is_high_value AS is_high_value_15 , m0_ . is_prepared AS is_prepared_16 , m0_ . preparation_cp_quantity AS preparation_cp_quantity_17 , m0_ . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_18 , m0_ . preparation_cp_total_units AS preparation_cp_total_units_19 , m0_ . preparation_cp_extended AS preparation_cp_extended_20 , m0_ . preparation_cp_discount AS preparation_cp_discount_21 , m0_ . cp_name AS cp_name_22 , m0_ . cp_display_name AS cp_display_name_23 , m0_ . preparation_cp_selling_extended AS preparation_cp_selling_extended_24 , m0_ . preparation_lot_units AS preparation_lot_units_25 , m0_ . preparation_lot_discount AS preparation_lot_discount_26 , m0_ . preparation_lot_extended AS preparation_lot_extended_27 , m0_ . preparation_lot_selling_extended AS preparation_lot_selling_extended_28 , m0_ . is_upcitemdb_error AS is_upcitemdb_error_29 , m0_ . is_already_in_database AS is_already_in_database_30 , m0_ . photo AS photo_31 , m0_ . quantity_imported AS quantity_imported_32 , m0_ . quantity_scanned AS quantity_scanned_33 , m0_ . quantity_triage AS quantity_triage_34 , m0_ . is_flag_preparation_done AS is_flag_preparation_done_35 , m0_ . premade_lot_number AS premade_lot_number_36 , m0_ . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_37 , m0_ . is_synccentric_search_required AS is_synccentric_search_required_38 , m0_ . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_39 , m0_ . is_sent_to_synccentric AS is_sent_to_synccentric_40 , m0_ . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_41 , m0_ . is_validation AS is_validation_42 , m0_ . is_skipped_for_analysis AS is_skipped_for_analysis_43 , m0_ . supplier_pallet_number AS supplier_pallet_number_44 , m0_ . created_at AS created_at_45 , m0_ . updated_at AS updated_at_46 , i1_ . id AS id_47 , i1_ . code AS code_48 , i1_ . is_doublon_checked AS is_doublon_checked_49 , i1_ . created_at AS created_at_50 , i1_ . updated_at AS updated_at_51 , m0_ . po_id AS po_id_52 , m0_ . product_id AS product_id_53 , m0_ . scanned_by_id AS scanned_by_id_54 , m0_ . imported_by_id AS imported_by_id_55 , m0_ . analyzed_by_id AS analyzed_by_id_56 , m0_ . supplier_id AS supplier_id_57 , m0_ . original_preparation_lot_id AS original_preparation_lot_id_58 , m0_ . restock_category_id AS restock_category_id_59 , m0_ . preparation_lot_id AS preparation_lot_id_60 , m0_ . triage_category_id AS triage_category_id_61 , i1_ . po_id AS po_id_62 , i1_ . manifest_item_id AS manifest_item_id_63 , i1_ . product_id AS product_id_64 , i1_ . supplier_id AS supplier_id_65 FROM manifest_item m0_ LEFT JOIN internal_sku i1_ ON m0_ . id = i1_ . manifest_item_id WHERE m0_ . po_id = 3722 AND (m0_ . code = 'B0DQYNDHHJ' OR m0_ . merchant_sku = 'B0DQYNDHHJ' OR i1_ . code = 'B0DQYNDHHJ' ) LIMIT 1 ;
Copy
9
0.16 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . has_actions AS has_actions_3 , t0 . has_validation AS has_validation_4 , t0 . has_high_value AS has_high_value_5 , t0 . is_active AS is_active_6 , t0 . has_scrapper AS has_scrapper_7 , t0 . sources_upc AS sources_upc_8 , t0 . sources_merchant_sku AS sources_merchant_sku_9 , t0 . sources_category AS sources_category_10 , t0 . sources_name AS sources_name_11 , t0 . sources_msrp AS sources_msrp_12 , t0 . sources_photo AS sources_photo_13 , t0 . sources_action AS sources_action_14 , t0 . is_required_upc AS is_required_upc_15 , t0 . is_required_merchant_sku AS is_required_merchant_sku_16 , t0 . is_required_category AS is_required_category_17 , t0 . is_required_name AS is_required_name_18 , t0 . is_required_msrp AS is_required_msrp_19 , t0 . is_required_photo AS is_required_photo_20 , t0 . is_required_action AS is_required_action_21 , t0 . public_name AS public_name_22 , t0 . is_deleted AS is_deleted_23 , t0 . product_generic_link AS product_generic_link_24 , t0 . billing_name AS billing_name_25 , t0 . billing_address AS billing_address_26 , t0 . tax_name1 AS tax_name1_27 , t0 . tax_rate1 AS tax_rate1_28 , t0 . tax_name2 AS tax_name2_29 , t0 . tax_rate2 AS tax_rate2_30 , t0 . tax_number1 AS tax_number1_31 , t0 . tax_number2 AS tax_number2_32 , t0 . tax_currency AS tax_currency_33 , t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 , t0 . has_continuous_po AS has_continuous_po_35 , t0 . newsletter_default_subject AS newsletter_default_subject_36 , t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 , t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 , t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 , t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 , t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 , t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 , t0 . scraper_class AS scraper_class_43 , t0 . has_splited_scraper AS has_splited_scraper_44 , t0 . has_synccentric_data AS has_synccentric_data_45 , t0 . has_upcitemdb_data AS has_upcitemdb_data_46 , t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 , t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 , t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 , t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 , t0 . user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . has_actions AS has_actions_3 ,
t0 . has_validation AS has_validation_4 ,
t0 . has_high_value AS has_high_value_5 ,
t0 . is_active AS is_active_6 ,
t0 . has_scrapper AS has_scrapper_7 ,
t0 . sources_upc AS sources_upc_8 ,
t0 . sources_merchant_sku AS sources_merchant_sku_9 ,
t0 . sources_category AS sources_category_10 ,
t0 . sources_name AS sources_name_11 ,
t0 . sources_msrp AS sources_msrp_12 ,
t0 . sources_photo AS sources_photo_13 ,
t0 . sources_action AS sources_action_14 ,
t0 . is_required_upc AS is_required_upc_15 ,
t0 . is_required_merchant_sku AS is_required_merchant_sku_16 ,
t0 . is_required_category AS is_required_category_17 ,
t0 . is_required_name AS is_required_name_18 ,
t0 . is_required_msrp AS is_required_msrp_19 ,
t0 . is_required_photo AS is_required_photo_20 ,
t0 . is_required_action AS is_required_action_21 ,
t0 . public_name AS public_name_22 ,
t0 . is_deleted AS is_deleted_23 ,
t0 . product_generic_link AS product_generic_link_24 ,
t0 . billing_name AS billing_name_25 ,
t0 . billing_address AS billing_address_26 ,
t0 . tax_name1 AS tax_name1_27 ,
t0 . tax_rate1 AS tax_rate1_28 ,
t0 . tax_name2 AS tax_name2_29 ,
t0 . tax_rate2 AS tax_rate2_30 ,
t0 . tax_number1 AS tax_number1_31 ,
t0 . tax_number2 AS tax_number2_32 ,
t0 . tax_currency AS tax_currency_33 ,
t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 ,
t0 . has_continuous_po AS has_continuous_po_35 ,
t0 . newsletter_default_subject AS newsletter_default_subject_36 ,
t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 ,
t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 ,
t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 ,
t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 ,
t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 ,
t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 ,
t0 . scraper_class AS scraper_class_43 ,
t0 . has_splited_scraper AS has_splited_scraper_44 ,
t0 . has_synccentric_data AS has_synccentric_data_45 ,
t0 . has_upcitemdb_data AS has_upcitemdb_data_46 ,
t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 ,
t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 ,
t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 ,
t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 ,
t0 . user_group_id AS user_group_id_51
FROM
supplier t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . has_actions AS has_actions_3 , t0 . has_validation AS has_validation_4 , t0 . has_high_value AS has_high_value_5 , t0 . is_active AS is_active_6 , t0 . has_scrapper AS has_scrapper_7 , t0 . sources_upc AS sources_upc_8 , t0 . sources_merchant_sku AS sources_merchant_sku_9 , t0 . sources_category AS sources_category_10 , t0 . sources_name AS sources_name_11 , t0 . sources_msrp AS sources_msrp_12 , t0 . sources_photo AS sources_photo_13 , t0 . sources_action AS sources_action_14 , t0 . is_required_upc AS is_required_upc_15 , t0 . is_required_merchant_sku AS is_required_merchant_sku_16 , t0 . is_required_category AS is_required_category_17 , t0 . is_required_name AS is_required_name_18 , t0 . is_required_msrp AS is_required_msrp_19 , t0 . is_required_photo AS is_required_photo_20 , t0 . is_required_action AS is_required_action_21 , t0 . public_name AS public_name_22 , t0 . is_deleted AS is_deleted_23 , t0 . product_generic_link AS product_generic_link_24 , t0 . billing_name AS billing_name_25 , t0 . billing_address AS billing_address_26 , t0 . tax_name1 AS tax_name1_27 , t0 . tax_rate1 AS tax_rate1_28 , t0 . tax_name2 AS tax_name2_29 , t0 . tax_rate2 AS tax_rate2_30 , t0 . tax_number1 AS tax_number1_31 , t0 . tax_number2 AS tax_number2_32 , t0 . tax_currency AS tax_currency_33 , t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 , t0 . has_continuous_po AS has_continuous_po_35 , t0 . newsletter_default_subject AS newsletter_default_subject_36 , t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 , t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 , t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 , t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 , t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 , t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 , t0 . scraper_class AS scraper_class_43 , t0 . has_splited_scraper AS has_splited_scraper_44 , t0 . has_synccentric_data AS has_synccentric_data_45 , t0 . has_upcitemdb_data AS has_upcitemdb_data_46 , t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 , t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 , t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 , t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 , t0 . user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0 . id = 55 ;
Copy
10
0.15 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . msrp AS msrp_4 , t0 . analyzed_at AS analyzed_at_5 , t0 . photo AS photo_6 , t0 . cp_quantity AS cp_quantity_7 , t0 . cp_number AS cp_number_8 , t0 . cp_name AS cp_name_9 , t0 . cp_discount AS cp_discount_10 , t0 . has_expiration_date AS has_expiration_date_11 , t0 . cp_format AS cp_format_12 , t0 . cp_packaged_units AS cp_packaged_units_13 , t0 . cp_photos AS cp_photos_14 , t0 . cp_weight AS cp_weight_15 , t0 . cp_package AS cp_package_16 , t0 . old_cp_number AS old_cp_number_17 , t0 . is_flag_preparation_done AS is_flag_preparation_done_18 , t0 . has_marketing_photo_request AS has_marketing_photo_request_19 , t0 . old_name AS old_name_20 , t0 . is_updated AS is_updated_21 , t0 . scraper_class AS scraper_class_22 , t0 . scraper_id AS scraper_id_23 , t0 . is_upc_checked AS is_upc_checked_24 , t0 . is_upc_valid AS is_upc_valid_25 , t0 . is_ean_checked AS is_ean_checked_26 , t0 . is_ean_valid AS is_ean_valid_27 , t0 . is_validation AS is_validation_28 , t0 . is_category_validation AS is_category_validation_29 , t0 . previous_category_id AS previous_category_id_30 , t0 . last_category_change_at AS last_category_change_at_31 , t0 . restock_category_id AS restock_category_id_32 , t0 . analyzed_by_id AS analyzed_by_id_33 , t0 . upcitemdb_id AS upcitemdb_id_34 , t0 . synccentric_id AS synccentric_id_35 FROM product t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . msrp AS msrp_4 , t0 . analyzed_at AS analyzed_at_5 , t0 . photo AS photo_6 , t0 . cp_quantity AS cp_quantity_7 , t0 . cp_number AS cp_number_8 , t0 . cp_name AS cp_name_9 , t0 . cp_discount AS cp_discount_10 , t0 . has_expiration_date AS has_expiration_date_11 , t0 . cp_format AS cp_format_12 , t0 . cp_packaged_units AS cp_packaged_units_13 , t0 . cp_photos AS cp_photos_14 , t0 . cp_weight AS cp_weight_15 , t0 . cp_package AS cp_package_16 , t0 . old_cp_number AS old_cp_number_17 , t0 . is_flag_preparation_done AS is_flag_preparation_done_18 , t0 . has_marketing_photo_request AS has_marketing_photo_request_19 , t0 . old_name AS old_name_20 , t0 . is_updated AS is_updated_21 , t0 . scraper_class AS scraper_class_22 , t0 . scraper_id AS scraper_id_23 , t0 . is_upc_checked AS is_upc_checked_24 , t0 . is_upc_valid AS is_upc_valid_25 , t0 . is_ean_checked AS is_ean_checked_26 , t0 . is_ean_valid AS is_ean_valid_27 , t0 . is_validation AS is_validation_28 , t0 . is_category_validation AS is_category_validation_29 , t0 . previous_category_id AS previous_category_id_30 , t0 . last_category_change_at AS last_category_change_at_31 , t0 . restock_category_id AS restock_category_id_32 , t0 . analyzed_by_id AS analyzed_by_id_33 , t0 . upcitemdb_id AS upcitemdb_id_34 , t0 . synccentric_id AS synccentric_id_35 FROM product t0 WHERE t0 . id = 1351323 ;
Copy
11
0.13 ms
SELECT t0 . id AS id_1 , t0 . supplier_id AS supplier_id_2 , t0 . restock_category_id AS restock_category_id_3 , t0 . triage_category_id AS triage_category_id_4 FROM triage_category t0 WHERE t0 . supplier_id = ? AND t0 . restock_category_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . supplier_id AS supplier_id_2 , t0 . restock_category_id AS restock_category_id_3 , t0 . triage_category_id AS triage_category_id_4 FROM triage_category t0 WHERE t0 . supplier_id = 55 AND t0 . restock_category_id = 123 LIMIT 1 ;
Copy
12
0.09 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM configuration t0 WHERE t0 . name = ? LIMIT 1
Parameters :
[
"CP_MIN_QUANTITY "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM configuration t0 WHERE t0 . name = 'CP_MIN_QUANTITY' LIMIT 1 ;
Copy
13
0.12 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM configuration t0 WHERE t0 . name = ? LIMIT 1
Parameters :
[
"CP_MIN_MSRP "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM configuration t0 WHERE t0 . name = 'CP_MIN_MSRP' LIMIT 1 ;
Copy
14
0.13 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM configuration t0 WHERE t0 . name = ? LIMIT 1
Parameters :
[
"CP_ALLOWED_PRODUCT_CONDITIONS "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM configuration t0 WHERE t0 . name = 'CP_ALLOWED_PRODUCT_CONDITIONS' LIMIT 1 ;
Copy
15
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
16
0.55 ms
INSERT INTO triage_scan (session_number , code , scan_type , is_confirmed , is_generic , is_validation , is_category_validation , is_action , is_question , has_error , is_deleted , confirm_request , is_error , result_template , msrp , has_cp , cp_name , cp_number , cp_quantity , is_confirmed_lot , is_confirmed_cp , is_rejected , cp_package , batch_id_code , max_quantity_same_lot_item , is_high_value , user_id , po_id , manifest_item_id , lot_id , action_id , triage_question_id , lot_item_id , scan_category_group_id , category_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"ts69404ceaf27dd "
"B0DQYNDHHJ "
"manifest "
0
0
0
0
0
0
0
0
null
0
null
null
0
null
null
null
0
0
0
null
null
null
0
114
3722
null
null
null
null
null
null
null
]
INSERT INTO triage_scan (
session_number , code , scan_type , is_confirmed ,
is_generic , is_validation , is_category_validation ,
is_action , is_question , has_error ,
is_deleted , confirm_request , is_error ,
result_template , msrp , has_cp , cp_name ,
cp_number , cp_quantity , is_confirmed_lot ,
is_confirmed_cp , is_rejected , cp_package ,
batch_id_code , max_quantity_same_lot_item ,
is_high_value , user_id , po_id , manifest_item_id ,
lot_id , action_id , triage_question_id ,
lot_item_id , scan_category_group_id ,
category_id
)
VALUES
(
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ?
)
Copy
INSERT INTO triage_scan (session_number , code , scan_type , is_confirmed , is_generic , is_validation , is_category_validation , is_action , is_question , has_error , is_deleted , confirm_request , is_error , result_template , msrp , has_cp , cp_name , cp_number , cp_quantity , is_confirmed_lot , is_confirmed_cp , is_rejected , cp_package , batch_id_code , max_quantity_same_lot_item , is_high_value , user_id , po_id , manifest_item_id , lot_id , action_id , triage_question_id , lot_item_id , scan_category_group_id , category_id ) VALUES ('ts69404ceaf27dd' , 'B0DQYNDHHJ' , 'manifest' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , NULL , 0 , NULL , NULL , 0 , NULL , NULL , NULL , 0 , 0 , 0 , NULL , NULL , NULL , 0 , 114 , 3722 , NULL , NULL , NULL , NULL , NULL , NULL , NULL );
Copy
17
0.21 ms
UPDATE supplier SET has_actions = ? , has_validation = ? , has_high_value = ? , is_active = ? , is_deleted = ? WHERE id = ?
Parameters :
[
0
1
0
1
0
55
]
UPDATE supplier SET has_actions = 0 , has_validation = 1 , has_high_value = 0 , is_active = 1 , is_deleted = 0 WHERE id = 55 ;
Copy
18
0.14 ms
UPDATE manifest_style SET is_active = ? WHERE id = ?
UPDATE manifest_style SET is_active = 1 WHERE id = 2 ;
Copy
19
0.14 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 19946 ;
Copy
20
0.11 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 19947 ;
Copy
21
0.11 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 19948 ;
Copy
22
0.16 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 19949 ;
Copy
23
0.08 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 19950 ;
Copy
24
2.22 ms
"COMMIT"
25
0.13 ms
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 . po_id AS po_id_16 , t0 . restock_category_id AS restock_category_id_17 , t0 . merged_with_id AS merged_with_id_18 , t0 . cp_product_id AS cp_product_id_19 , t0 . cp_manifest_item_id AS cp_manifest_item_id_20 , t0 . product_condition_id AS product_condition_id_21 FROM preparation_lot t0 WHERE t0 . id = ?
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 . po_id AS po_id_16 , t0 . restock_category_id AS restock_category_id_17 , t0 . merged_with_id AS merged_with_id_18 , t0 . cp_product_id AS cp_product_id_19 , t0 . cp_manifest_item_id AS cp_manifest_item_id_20 , t0 . product_condition_id AS product_condition_id_21 FROM preparation_lot t0 WHERE t0 . id = 33214 ;
Copy
26
0.49 ms
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 . po_id = ? AND t0 . category_id = ? AND t0 . is_closed = ? AND t0 . is_cp = ? AND t0 . is_high_value = ?
Parameters :
[
3722
52
0
0
0
]
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 . po_id = ?
AND t0 . category_id = ?
AND t0 . is_closed = ?
AND t0 . is_cp = ?
AND t0 . is_high_value = ?
Copy
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 . po_id = 3722 AND t0 . category_id = 52 AND t0 . is_closed = 0 AND t0 . is_cp = 0 AND t0 . is_high_value = 0 ;
Copy
27
0.13 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_main AS is_main_3 , t0 . generic_value AS generic_value_4 , t0 . high_value_threshold AS high_value_threshold_5 , t0 . is_updated AS is_updated_6 , t0 . is_active AS is_active_7 , t0 . can_have_cp AS can_have_cp_8 , t0 . slug AS slug_9 , t0 . is_public AS is_public_10 , t0 . generic_high_value AS generic_high_value_11 , t0 . newsletter_default_footer_image AS newsletter_default_footer_image_12 , t0 . newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_13 , t0 . google_id AS google_id_14 , t0 . max_quantity_same_lot_item AS max_quantity_same_lot_item_15 , t0 . parent_id AS parent_id_16 , t0 . scan_category_group_id AS scan_category_group_id_17 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_main AS is_main_3 , t0 . generic_value AS generic_value_4 , t0 . high_value_threshold AS high_value_threshold_5 , t0 . is_updated AS is_updated_6 , t0 . is_active AS is_active_7 , t0 . can_have_cp AS can_have_cp_8 , t0 . slug AS slug_9 , t0 . is_public AS is_public_10 , t0 . generic_high_value AS generic_high_value_11 , t0 . newsletter_default_footer_image AS newsletter_default_footer_image_12 , t0 . newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_13 , t0 . google_id AS google_id_14 , t0 . max_quantity_same_lot_item AS max_quantity_same_lot_item_15 , t0 . parent_id AS parent_id_16 , t0 . scan_category_group_id AS scan_category_group_id_17 FROM category t0 WHERE t0 . id = 52 ;
Copy
28
0.44 ms
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 = 60379 ORDER BY t0 . extended DESC ;
Copy
29
0.20 ms
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 = 4902180 ;
Copy
30
0.59 ms
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 = 4902244 ;
Copy
31
0.23 ms
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 = 4904019 ;
Copy
32
0.18 ms
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 = 4907594 ;
Copy
33
0.15 ms
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 = 4902193 ;
Copy
34
0.16 ms
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 = 4902256 ;
Copy
35
0.19 ms
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 = 4904184 ;
Copy
36
0.18 ms
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 = 4904014 ;
Copy
37
0.15 ms
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 = 4904136 ;
Copy
38
0.10 ms
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 = 4904104 ;
Copy
39
0.10 ms
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 = 4907622 ;
Copy
40
0.09 ms
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 = 4904093 ;
Copy
41
0.10 ms
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 = 4902486 ;
Copy
42
0.09 ms
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 = 4902429 ;
Copy
43
0.09 ms
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 = 4902190 ;
Copy
44
0.10 ms
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 = 4902247 ;
Copy
45
0.09 ms
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 = 4904039 ;
Copy
46
0.09 ms
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 = 4907602 ;
Copy
47
0.09 ms
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 = 4902540 ;
Copy
48
0.09 ms
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 = 4902157 ;
Copy
49
0.09 ms
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 = 4907634 ;
Copy
50
0.09 ms
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 = 4904412 ;
Copy
51
0.12 ms
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 = 4902206 ;
Copy
52
0.14 ms
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 = 4902176 ;
Copy
53
0.10 ms
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 = 4904061 ;
Copy
54
0.09 ms
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 = 4904140 ;
Copy
55
0.09 ms
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 = 4907604 ;
Copy
56
0.09 ms
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 = 4904076 ;
Copy
57
0.13 ms
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 = 4904190 ;
Copy
58
0.09 ms
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 = 4904196 ;
Copy
59
0.09 ms
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 = 4904193 ;
Copy
60
0.09 ms
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 = 4904164 ;
Copy
61
0.09 ms
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 = 4904416 ;
Copy
62
0.09 ms
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 = 4904089 ;
Copy
63
0.09 ms
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 = 4902282 ;
Copy
64
0.13 ms
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 = 4902430 ;
Copy
65
0.09 ms
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 = 4902528 ;
Copy
66
0.09 ms
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 = 4902255 ;
Copy
67
0.09 ms
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 = 4904074 ;
Copy
68
0.09 ms
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 = 4902526 ;
Copy
69
0.09 ms
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 = 4902537 ;
Copy
70
0.13 ms
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 = 4904163 ;
Copy
71
0.09 ms
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 = 4904112 ;
Copy
72
0.09 ms
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 = 4902542 ;
Copy
73
0.09 ms
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 = 4907592 ;
Copy
74
0.09 ms
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 = 4902177 ;
Copy
75
0.09 ms
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 = 4904103 ;
Copy
76
0.09 ms
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 = 4902527 ;
Copy
77
0.10 ms
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 = 4904146 ;
Copy
78
0.09 ms
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 = 4904387 ;
Copy
79
0.09 ms
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 = 4902159 ;
Copy
80
0.09 ms
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 = 4904095 ;
Copy
81
0.09 ms
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 = 4907612 ;
Copy
82
0.09 ms
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 = 4902154 ;
Copy
83
0.10 ms
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 = 4902409 ;
Copy
84
0.09 ms
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 = 4904423 ;
Copy
85
0.10 ms
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 = 4904324 ;
Copy
86
0.09 ms
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 = 4902408 ;
Copy
87
0.10 ms
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 = 4902431 ;
Copy
88
0.25 ms
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 = 60429 ORDER BY t0 . extended DESC ;
Copy
89
0.15 ms
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 = 4905379 ;
Copy
90
0.11 ms
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 = 4905423 ;
Copy
91
0.15 ms
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 = 4906078 ;
Copy
92
0.10 ms
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 = 4906198 ;
Copy
93
0.16 ms
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 = 4906187 ;
Copy
94
0.14 ms
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 = 4906228 ;
Copy
95
0.18 ms
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 = 4906158 ;
Copy
96
0.15 ms
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 = 4906029 ;
Copy
97
0.10 ms
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 = 4905359 ;
Copy
98
0.11 ms
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 = 4906238 ;
Copy
99
0.09 ms
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 = 4906163 ;
Copy
100
0.10 ms
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 = 4905428 ;
Copy
101
0.09 ms
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 = 4905442 ;
Copy
102
0.11 ms
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 = 4905878 ;
Copy
103
0.09 ms
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 = 4905355 ;
Copy
104
0.12 ms
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 = 4906473 ;
Copy
105
0.09 ms
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 = 4906195 ;
Copy
106
0.12 ms
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 = 4907646 ;
Copy
107
0.09 ms
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 = 4905443 ;
Copy
108
0.12 ms
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 = 4906725 ;
Copy
109
0.10 ms
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 = 4907486 ;
Copy
110
0.13 ms
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 = 4907208 ;
Copy
111
0.09 ms
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 = 4905383 ;
Copy
112
0.12 ms
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 = 4906033 ;
Copy
113
0.09 ms
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 = 4907209 ;
Copy
114
0.13 ms
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 = 4906691 ;
Copy
115
0.09 ms
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 = 4907485 ;
Copy
116
0.14 ms
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 = 4905954 ;
Copy
117
0.09 ms
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 = 4905399 ;
Copy
118
0.18 ms
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 = 4905406 ;
Copy
119
0.09 ms
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 = 4906510 ;
Copy
120
0.09 ms
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 = 4906523 ;
Copy
121
0.09 ms
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 = 4905439 ;
Copy
122
0.18 ms
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 = 60440 ORDER BY t0 . extended DESC ;
Copy
123
0.10 ms
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 = 4907164 ;
Copy
124
0.10 ms
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 = 4907175 ;
Copy
125
0.15 ms
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 = 4907185 ;
Copy
126
0.14 ms
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 = 4907177 ;
Copy
127
0.10 ms
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 = 4907163 ;
Copy
128
0.14 ms
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 = 4907198 ;
Copy
129
0.09 ms
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 = 4907193 ;
Copy
130
0.17 ms
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 = 4907173 ;
Copy
131
0.10 ms
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 = 4907172 ;
Copy
132
0.15 ms
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 = 4907187 ;
Copy
133
0.10 ms
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 = 4907184 ;
Copy
134
0.09 ms
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 = 4907166 ;
Copy
135
0.09 ms
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 = 4907162 ;
Copy
136
0.09 ms
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 = 4907192 ;
Copy
137
0.09 ms
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 = 4907188 ;
Copy
138
0.23 ms
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 = 60442 ORDER BY t0 . extended DESC ;
Copy
139
0.15 ms
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 = 4907205 ;
Copy
140
0.15 ms
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 = 4907224 ;
Copy
141
0.15 ms
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 = 4907572 ;
Copy
142
0.17 ms
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 = 4907507 ;
Copy
143
0.14 ms
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 = 4907221 ;
Copy
144
0.10 ms
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 = 4907220 ;
Copy
145
0.09 ms
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 = 4907587 ;
Copy
146
0.13 ms
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 = 4907504 ;
Copy
147
0.10 ms
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 = 4907511 ;
Copy
148
0.10 ms
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 = 4907515 ;
Copy
149
0.09 ms
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 = 4907447 ;
Copy
150
0.09 ms
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 = 4907638 ;
Copy
151
0.10 ms
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 = 4907609 ;
Copy
152
0.13 ms
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 = 4907582 ;
Copy
153
0.09 ms
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 = 4907506 ;
Copy
154
0.09 ms
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 = 4907566 ;
Copy
155
0.09 ms
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 = 4907513 ;
Copy
156
0.09 ms
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 = 4907465 ;
Copy
157
0.09 ms
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 = 4907204 ;
Copy
158
0.09 ms
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 = 4907514 ;
Copy
159
0.13 ms
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 = 4907483 ;
Copy
160
0.09 ms
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 = 4907588 ;
Copy
161
0.09 ms
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 = 4907611 ;
Copy
162
0.09 ms
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 = 4907579 ;
Copy
163
0.09 ms
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 = 4907223 ;
Copy
164
0.09 ms
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 = 4907464 ;
Copy
165
0.09 ms
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 = 4907623 ;
Copy
166
0.09 ms
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 = 4907444 ;
Copy
167
0.09 ms
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 = 4907211 ;
Copy
168
0.09 ms
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 = 4907210 ;
Copy
169
0.04 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
170
0.10 ms
UPDATE preparation_lot SET is_empty = ? , is_action = ? WHERE id = ?
Parameters :
[
0
0
33214
]
UPDATE preparation_lot SET is_empty = 0 , is_action = 0 WHERE id = 33214 ;
Copy
171
0.11 ms
UPDATE category SET is_updated = ? , is_active = ? WHERE id = ?
UPDATE category SET is_updated = 1 , is_active = 1 WHERE id = 52 ;
Copy
172
0.20 ms
UPDATE triage_scan SET confirm_request = ? , msrp = ? , max_quantity_same_lot_item = ? , manifest_item_id = ? , category_id = ? WHERE id = ?
Parameters :
[
"943123 - 944804 - 944811 - 944812 "
13.77
1000
7229972
52
7734906
]
UPDATE triage_scan SET confirm_request = '943123 - 944804 - 944811 - 944812' , msrp = 13.77 , max_quantity_same_lot_item = 1000 , manifest_item_id = 7229972 , category_id = 52 WHERE id = 7734906 ;
Copy
173
0.18 ms
UPDATE lot SET msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
4412.96
0
0
"2025-12-15 13:28:09 "
60379
]
UPDATE lot SET msrp_current = 4412.96 , is_high_value = 0 , is_cp = 0 , updated_at = '2025-12-15 13:28:09' WHERE id = 60379 ;
Copy
174
0.10 ms
UPDATE lot SET msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
2667.57
0
0
"2025-12-15 13:28:09 "
60429
]
UPDATE lot SET msrp_current = 2667.57 , is_high_value = 0 , is_cp = 0 , updated_at = '2025-12-15 13:28:09' WHERE id = 60429 ;
Copy
175
0.09 ms
UPDATE lot SET msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
2878.72
0
0
"2025-12-15 13:28:09 "
60440
]
UPDATE lot SET msrp_current = 2878.72 , is_high_value = 0 , is_cp = 0 , updated_at = '2025-12-15 13:28:09' WHERE id = 60440 ;
Copy
176
0.08 ms
UPDATE lot SET msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
2051.22
0
0
"2025-12-15 13:28:09 "
60442
]
UPDATE lot SET msrp_current = 2051.22 , is_high_value = 0 , is_cp = 0 , updated_at = '2025-12-15 13:28:09' WHERE id = 60442 ;
Copy
177
0.09 ms
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (? , ? )
Parameters :
[
7734906
60379
]
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (7734906 , 60379 );
Copy
178
0.07 ms
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (? , ? )
Parameters :
[
7734906
60429
]
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (7734906 , 60429 );
Copy
179
0.06 ms
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (? , ? )
Parameters :
[
7734906
60440
]
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (7734906 , 60440 );
Copy
180
0.06 ms
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (? , ? )
Parameters :
[
7734906
60442
]
INSERT INTO triage_scan_lot (triage_scan_id , lot_id ) VALUES (7734906 , 60442 );
Copy
181
0.46 ms
"COMMIT"
182
0.28 ms
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 . batch_id_code AS batch_id_code_25 , t0 . max_quantity_same_lot_item AS max_quantity_same_lot_item_26 , t0 . is_high_value AS is_high_value_27 , t0 . user_id AS user_id_28 , t0 . po_id AS po_id_29 , t0 . manifest_item_id AS manifest_item_id_30 , t0 . lot_id AS lot_id_31 , t0 . action_id AS action_id_32 , t0 . triage_question_id AS triage_question_id_33 , t0 . lot_item_id AS lot_item_id_34 , t0 . scan_category_group_id AS scan_category_group_id_35 , t0 . category_id AS category_id_36 FROM triage_scan t0 WHERE t0 . po_id = ? AND t0 . session_number = ? AND t0 . user_id = ? ORDER BY t0 . id DESC LIMIT 5
Parameters :
[
3722
"ts69404ceaf27dd "
114
]
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 . batch_id_code AS batch_id_code_25 , t0 . max_quantity_same_lot_item AS max_quantity_same_lot_item_26 , t0 . is_high_value AS is_high_value_27 , t0 . user_id AS user_id_28 , t0 . po_id AS po_id_29 , t0 . manifest_item_id AS manifest_item_id_30 , t0 . lot_id AS lot_id_31 , t0 . action_id AS action_id_32 , t0 . triage_question_id AS triage_question_id_33 , t0 . lot_item_id AS lot_item_id_34 , t0 . scan_category_group_id AS scan_category_group_id_35 , t0 . category_id AS category_id_36 FROM triage_scan t0 WHERE t0 . po_id = 3722 AND t0 . session_number = 'ts69404ceaf27dd' AND t0 . user_id = 114 ORDER BY t0 . id DESC LIMIT 5 ;
Copy
183
0.13 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 , t0 . position AS position_4 , t0 . gtm_value AS gtm_value_5 , t0 . facebook_value AS facebook_value_6 FROM `product_condition` t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 , t0 . position AS position_4 , t0 . gtm_value AS gtm_value_5 , t0 . facebook_value AS facebook_value_6 FROM `product_condition` t0 WHERE t0 . id = 2 ;
Copy
184
0.13 ms
SELECT t0 . id AS id_1 , t0 . nb_scans AS nb_scans_2 , t0 . module AS module_3 , t0 . is_closed AS is_closed_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . nb_scans_per_minute AS nb_scans_per_minute_7 , t0 . nb_minutes AS nb_minutes_8 , t0 . user_id AS user_id_9 , t0 . po_id AS po_id_10 , t0 . scan_category_group_id AS scan_category_group_id_11 , t0 . user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0 . user_id = ? AND t0 . is_closed = ? ORDER BY t0 . id DESC LIMIT 1
SELECT t0 . id AS id_1 , t0 . nb_scans AS nb_scans_2 , t0 . module AS module_3 , t0 . is_closed AS is_closed_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . nb_scans_per_minute AS nb_scans_per_minute_7 , t0 . nb_minutes AS nb_minutes_8 , t0 . user_id AS user_id_9 , t0 . po_id AS po_id_10 , t0 . scan_category_group_id AS scan_category_group_id_11 , t0 . user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0 . user_id = 114 AND t0 . is_closed = 0 ORDER BY t0 . id DESC LIMIT 1 ;
Copy
185
0.10 ms
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . start_at AS start_at_3 , t0 . end_at AS end_at_4 , t0 . nb_employees AS nb_employees_5 , t0 . employees_rate AS employees_rate_6 , t0 . nb_hours AS nb_hours_7 , t0 . weighted_daily_performance AS weighted_daily_performance_8 , t0 . weighted_daily_performance_per_employee_per_hour AS weighted_daily_performance_per_employee_per_hour_9 , t0 . weighted_daily_performance_per_employee_per_hour_average AS weighted_daily_performance_per_employee_per_hour_average_10 , t0 . objective AS objective_11 , t0 . calculated_employees_rate AS calculated_employees_rate_12 , t0 . scans_per_hour90average AS scans_per_hour90average_13 , t0 . total_scans AS total_scans_14 , t0 . current_nb_hours AS current_nb_hours_15 , t0 . supplier_id AS supplier_id_16 , t0 . user_group_id AS user_group_id_17 FROM report_performance t0 WHERE t0 . user_group_id IS NULL ORDER BY t0 . date DESC LIMIT 1
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . start_at AS start_at_3 , t0 . end_at AS end_at_4 , t0 . nb_employees AS nb_employees_5 , t0 . employees_rate AS employees_rate_6 , t0 . nb_hours AS nb_hours_7 , t0 . weighted_daily_performance AS weighted_daily_performance_8 , t0 . weighted_daily_performance_per_employee_per_hour AS weighted_daily_performance_per_employee_per_hour_9 , t0 . weighted_daily_performance_per_employee_per_hour_average AS weighted_daily_performance_per_employee_per_hour_average_10 , t0 . objective AS objective_11 , t0 . calculated_employees_rate AS calculated_employees_rate_12 , t0 . scans_per_hour90average AS scans_per_hour90average_13 , t0 . total_scans AS total_scans_14 , t0 . current_nb_hours AS current_nb_hours_15 , t0 . supplier_id AS supplier_id_16 , t0 . user_group_id AS user_group_id_17 FROM report_performance t0 WHERE t0 . user_group_id IS NULL ORDER BY t0 . date DESC LIMIT 1 ;
Copy
186
0.09 ms
SELECT t0 . id AS id_1 , t0 . nb_scans AS nb_scans_2 , t0 . module AS module_3 , t0 . is_closed AS is_closed_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . nb_scans_per_minute AS nb_scans_per_minute_7 , t0 . nb_minutes AS nb_minutes_8 , t0 . user_id AS user_id_9 , t0 . po_id AS po_id_10 , t0 . scan_category_group_id AS scan_category_group_id_11 , t0 . user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0 . is_closed = ?
SELECT t0 . id AS id_1 , t0 . nb_scans AS nb_scans_2 , t0 . module AS module_3 , t0 . is_closed AS is_closed_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . nb_scans_per_minute AS nb_scans_per_minute_7 , t0 . nb_minutes AS nb_minutes_8 , t0 . user_id AS user_id_9 , t0 . po_id AS po_id_10 , t0 . scan_category_group_id AS scan_category_group_id_11 , t0 . user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0 . is_closed = 0 ;
Copy
187
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
188
0.15 ms
UPDATE `product_condition` SET is_active = ? WHERE id = ?
UPDATE `product_condition` SET is_active = 1 WHERE id = 2 ;
Copy
189
0.13 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
489.9
4902244
]
UPDATE lot_item SET extended = 489.9 WHERE id = 4902244 ;
Copy
190
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
419.86
4904019
]
UPDATE lot_item SET extended = 419.86 WHERE id = 4904019 ;
Copy
191
0.13 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
77.65
4902486
]
UPDATE lot_item SET extended = 77.65 WHERE id = 4902486 ;
Copy
192
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
72.66
4906238
]
UPDATE lot_item SET extended = 72.66 WHERE id = 4906238 ;
Copy
193
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
62.72
4905442
]
UPDATE lot_item SET extended = 62.72 WHERE id = 4905442 ;
Copy
194
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
55.2
4905355
]
UPDATE lot_item SET extended = 55.2 WHERE id = 4905355 ;
Copy
195
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
489.93
4907164
]
UPDATE lot_item SET extended = 489.93 WHERE id = 4907164 ;
Copy
196
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
454.41
4907205
]
UPDATE lot_item SET extended = 454.41 WHERE id = 4907205 ;
Copy
197
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
131.89
4907507
]
UPDATE lot_item SET extended = 131.89 WHERE id = 4907507 ;
Copy
198
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
28.2
4907465
]
UPDATE lot_item SET extended = 28.2 WHERE id = 4907465 ;
Copy
199
0.04 ms
"COMMIT"
200
0.07 ms
SELECT s0_ . id AS id_0 , s0_ . nb_scans AS nb_scans_1 , s0_ . module AS module_2 , s0_ . is_closed AS is_closed_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . nb_scans_per_minute AS nb_scans_per_minute_6 , s0_ . nb_minutes AS nb_minutes_7 , s0_ . user_id AS user_id_8 , s0_ . po_id AS po_id_9 , s0_ . scan_category_group_id AS scan_category_group_id_10 , s0_ . user_group_id AS user_group_id_11 FROM scan_session s0_ INNER JOIN po p1_ ON s0_ . po_id = p1_ . id WHERE s0_ . nb_scans > 25 AND p1_ . supplier_id = ? AND s0_ . scan_category_group_id = ? AND s0_ . user_id = ? AND s0_ . created_at > = ? AND s0_ . created_at < = ? ORDER BY s0_ . id DESC
Parameters :
[
55
2
114
"2025-12-15 00:00:00 "
"2025-12-15 13:28:09 "
]
SELECT s0_ . id AS id_0 , s0_ . nb_scans AS nb_scans_1 , s0_ . module AS module_2 , s0_ . is_closed AS is_closed_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . nb_scans_per_minute AS nb_scans_per_minute_6 , s0_ . nb_minutes AS nb_minutes_7 , s0_ . user_id AS user_id_8 , s0_ . po_id AS po_id_9 , s0_ . scan_category_group_id AS scan_category_group_id_10 , s0_ . user_group_id AS user_group_id_11 FROM scan_session s0_ INNER JOIN po p1_ ON s0_ . po_id = p1_ . id WHERE s0_ . nb_scans > 25 AND p1_ . supplier_id = 55 AND s0_ . scan_category_group_id = 2 AND s0_ . user_id = 114 AND s0_ . created_at > = '2025-12-15 00:00:00' AND s0_ . created_at < = '2025-12-15 13:28:09' ORDER BY s0_ . id DESC ;
Copy
201
0.12 ms
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 ;
Copy