1
0.44 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 = 112 ;
Copy
2
0.11 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.11 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.13 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 . status_id AS status_id_89 , t0 . supplier_id AS supplier_id_90 , t0 . product_condition_id AS product_condition_id_91 , t0 . manifest_style_id AS manifest_style_id_92 , t0 . invoice_style_id AS invoice_style_id_93 , t0 . supplier_invoice_state_id AS supplier_invoice_state_id_94 , t0 . warehouse_id AS warehouse_id_95 , t0 . auto_triage_category_id AS auto_triage_category_id_96 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 . status_id AS status_id_89 ,
t0 . supplier_id AS supplier_id_90 ,
t0 . product_condition_id AS product_condition_id_91 ,
t0 . manifest_style_id AS manifest_style_id_92 ,
t0 . invoice_style_id AS invoice_style_id_93 ,
t0 . supplier_invoice_state_id AS supplier_invoice_state_id_94 ,
t0 . warehouse_id AS warehouse_id_95 ,
t0 . auto_triage_category_id AS auto_triage_category_id_96
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 . status_id AS status_id_89 , t0 . supplier_id AS supplier_id_90 , t0 . product_condition_id AS product_condition_id_91 , t0 . manifest_style_id AS manifest_style_id_92 , t0 . invoice_style_id AS invoice_style_id_93 , t0 . supplier_invoice_state_id AS supplier_invoice_state_id_94 , t0 . warehouse_id AS warehouse_id_95 , t0 . auto_triage_category_id AS auto_triage_category_id_96 FROM po t0 WHERE t0 . id = '3000' ;
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 = 3000 ;
Copy
6
0.15 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 = 4 ;
Copy
7
0.11 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 :
[
"821729775051 "
28
]
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 = '821729775051' AND t0 . supplier_id = 28 LIMIT 1 ;
Copy
8
4.20 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 , u1_ . id AS id_47 , u1_ . code AS code_48 , u1_ . is_doublon_checked AS is_doublon_checked_49 , m0_ . po_id AS po_id_50 , m0_ . product_id AS product_id_51 , m0_ . scanned_by_id AS scanned_by_id_52 , m0_ . imported_by_id AS imported_by_id_53 , m0_ . analyzed_by_id AS analyzed_by_id_54 , m0_ . supplier_id AS supplier_id_55 , m0_ . original_preparation_lot_id AS original_preparation_lot_id_56 , m0_ . restock_category_id AS restock_category_id_57 , m0_ . preparation_lot_id AS preparation_lot_id_58 , m0_ . triage_category_id AS triage_category_id_59 , u1_ . po_id AS po_id_60 , u1_ . manifest_item_id AS manifest_item_id_61 , u1_ . product_id AS product_id_62 FROM manifest_item m0_ INNER JOIN unique_id u1_ ON m0_ . id = u1_ . manifest_item_id WHERE m0_ . po_id = ? AND (m0_ . code LIKE ? OR m0_ . merchant_sku LIKE ? OR u1_ . code LIKE ? ) LIMIT 1
Parameters :
[
3000
"821729775051 "
"821729775051 "
"821729775051 "
]
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 ,
u1_ . id AS id_47 ,
u1_ . code AS code_48 ,
u1_ . is_doublon_checked AS is_doublon_checked_49 ,
m0_ . po_id AS po_id_50 ,
m0_ . product_id AS product_id_51 ,
m0_ . scanned_by_id AS scanned_by_id_52 ,
m0_ . imported_by_id AS imported_by_id_53 ,
m0_ . analyzed_by_id AS analyzed_by_id_54 ,
m0_ . supplier_id AS supplier_id_55 ,
m0_ . original_preparation_lot_id AS original_preparation_lot_id_56 ,
m0_ . restock_category_id AS restock_category_id_57 ,
m0_ . preparation_lot_id AS preparation_lot_id_58 ,
m0_ . triage_category_id AS triage_category_id_59 ,
u1_ . po_id AS po_id_60 ,
u1_ . manifest_item_id AS manifest_item_id_61 ,
u1_ . product_id AS product_id_62
FROM
manifest_item m0_
INNER JOIN unique_id u1_ ON m0_ . id = u1_ . manifest_item_id
WHERE
m0_ . po_id = ?
AND (
m0_ . code LIKE ?
OR m0_ . merchant_sku LIKE ?
OR u1_ . code LIKE ?
)
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 , u1_ . id AS id_47 , u1_ . code AS code_48 , u1_ . is_doublon_checked AS is_doublon_checked_49 , m0_ . po_id AS po_id_50 , m0_ . product_id AS product_id_51 , m0_ . scanned_by_id AS scanned_by_id_52 , m0_ . imported_by_id AS imported_by_id_53 , m0_ . analyzed_by_id AS analyzed_by_id_54 , m0_ . supplier_id AS supplier_id_55 , m0_ . original_preparation_lot_id AS original_preparation_lot_id_56 , m0_ . restock_category_id AS restock_category_id_57 , m0_ . preparation_lot_id AS preparation_lot_id_58 , m0_ . triage_category_id AS triage_category_id_59 , u1_ . po_id AS po_id_60 , u1_ . manifest_item_id AS manifest_item_id_61 , u1_ . product_id AS product_id_62 FROM manifest_item m0_ INNER JOIN unique_id u1_ ON m0_ . id = u1_ . manifest_item_id WHERE m0_ . po_id = 3000 AND (m0_ . code LIKE '821729775051' OR m0_ . merchant_sku LIKE '821729775051' OR u1_ . code LIKE '821729775051' ) 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 = 28 ;
Copy
10
8.64 ms
SELECT p0_ . id AS id_0 , p0_ . code AS code_1 , p0_ . name AS name_2 , p0_ . msrp AS msrp_3 , p0_ . analyzed_at AS analyzed_at_4 , p0_ . photo AS photo_5 , p0_ . cp_quantity AS cp_quantity_6 , p0_ . cp_number AS cp_number_7 , p0_ . cp_name AS cp_name_8 , p0_ . cp_discount AS cp_discount_9 , p0_ . has_expiration_date AS has_expiration_date_10 , p0_ . cp_format AS cp_format_11 , p0_ . cp_packaged_units AS cp_packaged_units_12 , p0_ . cp_photos AS cp_photos_13 , p0_ . cp_weight AS cp_weight_14 , p0_ . cp_package AS cp_package_15 , p0_ . old_cp_number AS old_cp_number_16 , p0_ . is_flag_preparation_done AS is_flag_preparation_done_17 , p0_ . has_marketing_photo_request AS has_marketing_photo_request_18 , p0_ . is_oversize AS is_oversize_19 , p0_ . old_name AS old_name_20 , p0_ . is_updated AS is_updated_21 , p0_ . scraper_class AS scraper_class_22 , p0_ . scraper_id AS scraper_id_23 , p0_ . is_upc_checked AS is_upc_checked_24 , p0_ . is_upc_valid AS is_upc_valid_25 , p0_ . is_ean_checked AS is_ean_checked_26 , p0_ . is_ean_valid AS is_ean_valid_27 , p0_ . is_validation AS is_validation_28 , p0_ . is_category_validation AS is_category_validation_29 , p0_ . previous_category_id AS previous_category_id_30 , p0_ . last_category_change_at AS last_category_change_at_31 , p0_ . restock_category_id AS restock_category_id_32 , p0_ . analyzed_by_id AS analyzed_by_id_33 , p0_ . upcitemdb_id AS upcitemdb_id_34 , p0_ . synccentric_id AS synccentric_id_35 FROM product p0_ WHERE p0_ . code = ? ORDER BY p0_ . id DESC LIMIT 1
Parameters :
[
"821729775051 "
]
SELECT p0_ . id AS id_0 , p0_ . code AS code_1 , p0_ . name AS name_2 , p0_ . msrp AS msrp_3 , p0_ . analyzed_at AS analyzed_at_4 , p0_ . photo AS photo_5 , p0_ . cp_quantity AS cp_quantity_6 , p0_ . cp_number AS cp_number_7 , p0_ . cp_name AS cp_name_8 , p0_ . cp_discount AS cp_discount_9 , p0_ . has_expiration_date AS has_expiration_date_10 , p0_ . cp_format AS cp_format_11 , p0_ . cp_packaged_units AS cp_packaged_units_12 , p0_ . cp_photos AS cp_photos_13 , p0_ . cp_weight AS cp_weight_14 , p0_ . cp_package AS cp_package_15 , p0_ . old_cp_number AS old_cp_number_16 , p0_ . is_flag_preparation_done AS is_flag_preparation_done_17 , p0_ . has_marketing_photo_request AS has_marketing_photo_request_18 , p0_ . is_oversize AS is_oversize_19 , p0_ . old_name AS old_name_20 , p0_ . is_updated AS is_updated_21 , p0_ . scraper_class AS scraper_class_22 , p0_ . scraper_id AS scraper_id_23 , p0_ . is_upc_checked AS is_upc_checked_24 , p0_ . is_upc_valid AS is_upc_valid_25 , p0_ . is_ean_checked AS is_ean_checked_26 , p0_ . is_ean_valid AS is_ean_valid_27 , p0_ . is_validation AS is_validation_28 , p0_ . is_category_validation AS is_category_validation_29 , p0_ . previous_category_id AS previous_category_id_30 , p0_ . last_category_change_at AS last_category_change_at_31 , p0_ . restock_category_id AS restock_category_id_32 , p0_ . analyzed_by_id AS analyzed_by_id_33 , p0_ . upcitemdb_id AS upcitemdb_id_34 , p0_ . synccentric_id AS synccentric_id_35 FROM product p0_ WHERE p0_ . code = '821729775051' ORDER BY p0_ . id DESC LIMIT 1 ;
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 = 28 AND t0 . restock_category_id = 155 LIMIT 1 ;
Copy
12
0.06 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.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_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.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_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.15 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 . has_oversize AS has_oversize_14 , t0 . google_id AS google_id_15 , t0 . max_quantity_same_lot_item AS max_quantity_same_lot_item_16 , t0 . parent_id AS parent_id_17 , t0 . scan_category_group_id AS scan_category_group_id_18 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 . has_oversize AS has_oversize_14 , t0 . google_id AS google_id_15 , t0 . max_quantity_same_lot_item AS max_quantity_same_lot_item_16 , t0 . parent_id AS parent_id_17 , t0 . scan_category_group_id AS scan_category_group_id_18 FROM category t0 WHERE t0 . id = 155 ;
Copy
16
0.13 ms
SELECT t0 . id AS id_1 , t0 . sku AS sku_2 , t0 . converted AS converted_3 , t0 . supplier_id AS supplier_id_4 , t0 . product_id AS product_id_5 FROM merchant_sku t0 WHERE t0 . product_id = ?
SELECT t0 . id AS id_1 , t0 . sku AS sku_2 , t0 . converted AS converted_3 , t0 . supplier_id AS supplier_id_4 , t0 . product_id AS product_id_5 FROM merchant_sku t0 WHERE t0 . product_id = 1143144 ;
Copy
17
0.10 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
18
1.44 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 , show_oversize_button , user_id , po_id , manifest_item_id , lot_id , action_id , triage_question_id , lot_item_id , scan_category_group_id , oversize_lot_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"ts682de35fb49a8 "
"821729775051 "
"direct "
0
0
0
0
0
0
0
0
null
0
null
null
0
null
null
null
0
0
0
null
0
112
3000
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 ,
show_oversize_button , user_id , po_id ,
manifest_item_id , lot_id , action_id ,
triage_question_id , lot_item_id ,
scan_category_group_id , oversize_lot_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 , show_oversize_button , user_id , po_id , manifest_item_id , lot_id , action_id , triage_question_id , lot_item_id , scan_category_group_id , oversize_lot_id ) VALUES ('ts682de35fb49a8' , '821729775051' , 'direct' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , NULL , 0 , NULL , NULL , 0 , NULL , NULL , NULL , 0 , 0 , 0 , NULL , 0 , 112 , 3000 , NULL , NULL , NULL , NULL , NULL , NULL , NULL );
Copy
19
3.87 ms
INSERT INTO manifest_item (code , quantity , method , msrp , name , category , merchant_sku , is_analyzed , analyzed_at , is_auto_analyzed , converted , is_generic , position , is_cp , is_high_value , is_prepared , preparation_cp_quantity , preparation_units_per_cp_lot , preparation_cp_total_units , preparation_cp_extended , preparation_cp_discount , cp_name , cp_display_name , preparation_cp_selling_extended , preparation_lot_units , preparation_lot_discount , preparation_lot_extended , preparation_lot_selling_extended , is_upcitemdb_error , is_already_in_database , photo , quantity_imported , quantity_scanned , quantity_triage , is_flag_preparation_done , premade_lot_number , is_prepare_autoanalysis_done , is_synccentric_search_required , is_sent_to_prepare_autoanalysis , is_sent_to_synccentric , is_sent_to_autoanalysis , is_validation , is_skipped_for_analysis , supplier_pallet_number , created_at , updated_at , po_id , product_id , scanned_by_id , imported_by_id , analyzed_by_id , supplier_id , original_preparation_lot_id , restock_category_id , preparation_lot_id , triage_category_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"821729775051 "
1
"triage "
null
null
null
"0082172977505 "
1
"2025-05-21 11:01:13 "
1
0
0
0
0
0
0
null
null
null
null
null
null
null
null
null
null
null
null
0
1
null
null
null
null
0
null
0
0
0
0
0
0
0
null
"2025-05-21 11:01:13 "
"2025-05-21 11:01:13 "
3000
1143144
112
null
112
null
null
null
null
null
]
INSERT INTO manifest_item (
code , quantity , method , msrp , name ,
category , merchant_sku , is_analyzed ,
analyzed_at , is_auto_analyzed , converted ,
is_generic , position , is_cp , is_high_value ,
is_prepared , preparation_cp_quantity ,
preparation_units_per_cp_lot , preparation_cp_total_units ,
preparation_cp_extended , preparation_cp_discount ,
cp_name , cp_display_name , preparation_cp_selling_extended ,
preparation_lot_units , preparation_lot_discount ,
preparation_lot_extended , preparation_lot_selling_extended ,
is_upcitemdb_error , is_already_in_database ,
photo , quantity_imported , quantity_scanned ,
quantity_triage , is_flag_preparation_done ,
premade_lot_number , is_prepare_autoanalysis_done ,
is_synccentric_search_required ,
is_sent_to_prepare_autoanalysis ,
is_sent_to_synccentric , is_sent_to_autoanalysis ,
is_validation , is_skipped_for_analysis ,
supplier_pallet_number , created_at ,
updated_at , po_id , product_id , scanned_by_id ,
imported_by_id , analyzed_by_id ,
supplier_id , original_preparation_lot_id ,
restock_category_id , preparation_lot_id ,
triage_category_id
)
VALUES
(
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ?
)
Copy
INSERT INTO manifest_item (code , quantity , method , msrp , name , category , merchant_sku , is_analyzed , analyzed_at , is_auto_analyzed , converted , is_generic , position , is_cp , is_high_value , is_prepared , preparation_cp_quantity , preparation_units_per_cp_lot , preparation_cp_total_units , preparation_cp_extended , preparation_cp_discount , cp_name , cp_display_name , preparation_cp_selling_extended , preparation_lot_units , preparation_lot_discount , preparation_lot_extended , preparation_lot_selling_extended , is_upcitemdb_error , is_already_in_database , photo , quantity_imported , quantity_scanned , quantity_triage , is_flag_preparation_done , premade_lot_number , is_prepare_autoanalysis_done , is_synccentric_search_required , is_sent_to_prepare_autoanalysis , is_sent_to_synccentric , is_sent_to_autoanalysis , is_validation , is_skipped_for_analysis , supplier_pallet_number , created_at , updated_at , po_id , product_id , scanned_by_id , imported_by_id , analyzed_by_id , supplier_id , original_preparation_lot_id , restock_category_id , preparation_lot_id , triage_category_id ) VALUES ('821729775051' , 1 , 'triage' , NULL , NULL , NULL , '0082172977505' , 1 , '2025-05-21 11:01:13' , 1 , 0 , 0 , 0 , 0 , 0 , 0 , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , 0 , 1 , NULL , NULL , NULL , NULL , 0 , NULL , 0 , 0 , 0 , 0 , 0 , 0 , 0 , NULL , '2025-05-21 11:01:13' , '2025-05-21 11:01:13' , 3000 , 1143144 , 112 , NULL , 112 , NULL , NULL , NULL , NULL , NULL );
Copy
20
0.27 ms
UPDATE supplier SET has_actions = ? , has_validation = ? , has_high_value = ? , is_active = ? , is_deleted = ? WHERE id = ?
Parameters :
[
0
1
0
1
0
28
]
UPDATE supplier SET has_actions = 0 , has_validation = 1 , has_high_value = 0 , is_active = 1 , is_deleted = 0 WHERE id = 28 ;
Copy
21
0.15 ms
UPDATE manifest_style SET is_active = ? WHERE id = ?
UPDATE manifest_style SET is_active = 1 WHERE id = 4 ;
Copy
22
0.10 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 17529 ;
Copy
23
0.08 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 17530 ;
Copy
24
0.11 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 17531 ;
Copy
25
0.13 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 17532 ;
Copy
26
0.12 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 17533 ;
Copy
27
0.14 ms
UPDATE category SET is_updated = ? , is_active = ? WHERE id = ?
UPDATE category SET is_updated = 0 , is_active = 1 WHERE id = 155 ;
Copy
28
0.70 ms
"COMMIT"
29
0.09 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . supplier_id AS supplier_id_3 , t0 . product_condition_id AS product_condition_id_4 , t0 . category_id AS category_id_5 FROM supplier_product_condition_discount t0 WHERE t0 . supplier_id = ? AND t0 . product_condition_id = ? AND t0 . category_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . supplier_id AS supplier_id_3 , t0 . product_condition_id AS product_condition_id_4 , t0 . category_id AS category_id_5 FROM supplier_product_condition_discount t0 WHERE t0 . supplier_id = 28 AND t0 . product_condition_id = 2 AND t0 . category_id = 155 LIMIT 1 ;
Copy
30
0.09 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_condition_id AS product_condition_id_3 , t0 . category_id AS category_id_4 FROM product_condition_discount t0 WHERE t0 . product_condition_id = ? AND t0 . category_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_condition_id AS product_condition_id_3 , t0 . category_id AS category_id_4 FROM product_condition_discount t0 WHERE t0 . product_condition_id = 2 AND t0 . category_id = 155 LIMIT 1 ;
Copy
31
2.62 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 . is_oversize AS is_oversize_32 , t0 . cost AS cost_33 , t0 . is_imported AS is_imported_34 , t0 . supplier_pallet_number AS supplier_pallet_number_35 , t0 . created_at AS created_at_36 , t0 . updated_at AS updated_at_37 , t0 . po_id AS po_id_38 , t0 . category_id AS category_id_39 , t0 . cp_product_id AS cp_product_id_40 , t0 . product_condition_id AS product_condition_id_41 , t0 . merged_with_id AS merged_with_id_42 , t0 . preparation_lot_id AS preparation_lot_id_43 , t0 . previous_po_id AS previous_po_id_44 , t0 . related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0 . po_id = ? AND t0 . category_id = ? AND t0 . is_high_value = ? AND t0 . is_cp = ? AND t0 . is_oversize = ? AND t0 . is_closed = ? AND t0 . product_condition_id = ? LIMIT 1
Parameters :
[
3000
155
0
0
0
0
2
]
SELECT
t0 . id AS id_1 ,
t0 . number AS number_2 ,
t0 . package_units AS package_units_3 ,
t0 . weight AS weight_4 ,
t0 . user AS user_5 ,
t0 . format AS format_6 ,
t0 . photos AS photos_7 ,
t0 . name AS name_8 ,
t0 . extended AS extended_9 ,
t0 . units AS units_10 ,
t0 . discount AS discount_11 ,
t0 . estimated_sales AS estimated_sales_12 ,
t0 . is_initialized AS is_initialized_13 ,
t0 . msrp_current AS msrp_current_14 ,
t0 . is_closed AS is_closed_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_cp AS is_cp_17 ,
t0 . estimated_sales_min_target AS estimated_sales_min_target_18 ,
t0 . estimated_sales_max_target AS estimated_sales_max_target_19 ,
t0 . display_name AS display_name_20 ,
t0 . quantity AS quantity_21 ,
t0 . cp_quantity AS cp_quantity_22 ,
t0 . is_truckload AS is_truckload_23 ,
t0 . is_photos_compressed AS is_photos_compressed_24 ,
t0 . is_destroy AS is_destroy_25 ,
t0 . package_sizes AS package_sizes_26 ,
t0 . is_listing_done AS is_listing_done_27 ,
t0 . discount_triage AS discount_triage_28 ,
t0 . volumetric_weight AS volumetric_weight_29 ,
t0 . real_weight AS real_weight_30 ,
t0 . previous_number AS previous_number_31 ,
t0 . is_oversize AS is_oversize_32 ,
t0 . cost AS cost_33 ,
t0 . is_imported AS is_imported_34 ,
t0 . supplier_pallet_number AS supplier_pallet_number_35 ,
t0 . created_at AS created_at_36 ,
t0 . updated_at AS updated_at_37 ,
t0 . po_id AS po_id_38 ,
t0 . category_id AS category_id_39 ,
t0 . cp_product_id AS cp_product_id_40 ,
t0 . product_condition_id AS product_condition_id_41 ,
t0 . merged_with_id AS merged_with_id_42 ,
t0 . preparation_lot_id AS preparation_lot_id_43 ,
t0 . previous_po_id AS previous_po_id_44 ,
t0 . related_front_product_id AS related_front_product_id_45
FROM
lot t0
WHERE
t0 . po_id = ?
AND t0 . category_id = ?
AND t0 . is_high_value = ?
AND t0 . is_cp = ?
AND t0 . is_oversize = ?
AND t0 . is_closed = ?
AND t0 . product_condition_id = ?
LIMIT
1
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 . is_oversize AS is_oversize_32 , t0 . cost AS cost_33 , t0 . is_imported AS is_imported_34 , t0 . supplier_pallet_number AS supplier_pallet_number_35 , t0 . created_at AS created_at_36 , t0 . updated_at AS updated_at_37 , t0 . po_id AS po_id_38 , t0 . category_id AS category_id_39 , t0 . cp_product_id AS cp_product_id_40 , t0 . product_condition_id AS product_condition_id_41 , t0 . merged_with_id AS merged_with_id_42 , t0 . preparation_lot_id AS preparation_lot_id_43 , t0 . previous_po_id AS previous_po_id_44 , t0 . related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0 . po_id = 3000 AND t0 . category_id = 155 AND t0 . is_high_value = 0 AND t0 . is_cp = 0 AND t0 . is_oversize = 0 AND t0 . is_closed = 0 AND t0 . product_condition_id = 2 LIMIT 1 ;
Copy
32
1.96 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 . lot_id AS lot_id_8 , t0 . product_id AS product_id_9 , t0 . po_id AS po_id_10 , t0 . manifest_item_id AS manifest_item_id_11 , t0 . original_lot_id AS original_lot_id_12 , t0 . duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0 . lot_id = ? ORDER BY t0 . extended DESC
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . lot_id AS lot_id_8 , t0 . product_id AS product_id_9 , t0 . po_id AS po_id_10 , t0 . manifest_item_id AS manifest_item_id_11 , t0 . original_lot_id AS original_lot_id_12 , t0 . duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0 . lot_id = 53210 ORDER BY t0 . extended DESC ;
Copy
33
0.72 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 = 4376316 ;
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 = 4376487 ;
Copy
35
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 = 4376470 ;
Copy
36
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 = 4376310 ;
Copy
37
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 = 4376303 ;
Copy
38
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 = 4376490 ;
Copy
39
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 = 4376476 ;
Copy
40
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 = 4376959 ;
Copy
41
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 = 4376491 ;
Copy
42
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 = 4376218 ;
Copy
43
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 = 4376479 ;
Copy
44
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 = 4376482 ;
Copy
45
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 = 4376834 ;
Copy
46
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 = 4376213 ;
Copy
47
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 = 4376898 ;
Copy
48
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 = 4376297 ;
Copy
49
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 = 4376459 ;
Copy
50
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 = 4376875 ;
Copy
51
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 = 4376304 ;
Copy
52
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 = 4376980 ;
Copy
53
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 = 4376990 ;
Copy
54
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 = 4376457 ;
Copy
55
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 = 4376266 ;
Copy
56
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 = 4376196 ;
Copy
57
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 = 4376965 ;
Copy
58
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 = 4376493 ;
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 = 4376899 ;
Copy
60
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 = 4376824 ;
Copy
61
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 = 4376977 ;
Copy
62
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 = 4376982 ;
Copy
63
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 = 4376986 ;
Copy
64
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 = 4376991 ;
Copy
65
0.26 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 = 4376740 ;
Copy
66
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 = 4376896 ;
Copy
67
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 = 4376314 ;
Copy
68
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 = 4376973 ;
Copy
69
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 = 4376983 ;
Copy
70
0.21 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 = 4376989 ;
Copy
71
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 = 4376854 ;
Copy
72
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 = 4376436 ;
Copy
73
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 = 4376222 ;
Copy
74
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 = 4376231 ;
Copy
75
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 = 4376278 ;
Copy
76
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 = 4376833 ;
Copy
77
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 = 4376979 ;
Copy
78
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 = 4376987 ;
Copy
79
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 = 4376985 ;
Copy
80
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 = 4376914 ;
Copy
81
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 = 4376828 ;
Copy
82
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 = 4376844 ;
Copy
83
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 = 4376727 ;
Copy
84
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 = 4376840 ;
Copy
85
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 = 4376841 ;
Copy
86
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 = 4376846 ;
Copy
87
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 = 4376890 ;
Copy
88
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 = 4376748 ;
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 = 4376267 ;
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 = 4376323 ;
Copy
91
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 = 4376198 ;
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 = 4376215 ;
Copy
93
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 = 4376850 ;
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 = 4376894 ;
Copy
95
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 = 4376895 ;
Copy
96
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 = 4376433 ;
Copy
97
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 = 4376435 ;
Copy
98
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 = 4376729 ;
Copy
99
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 = 4376219 ;
Copy
100
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 = 4376826 ;
Copy
101
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 = 4376829 ;
Copy
102
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 = 4376992 ;
Copy
103
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 = 4376298 ;
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 = 4376302 ;
Copy
105
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 = 4376233 ;
Copy
106
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 = 4376428 ;
Copy
107
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 = 4376447 ;
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 = 4376200 ;
Copy
109
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 = 4376229 ;
Copy
110
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 = 4376750 ;
Copy
111
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 = 4376312 ;
Copy
112
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 = 4376993 ;
Copy
113
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 = 4376975 ;
Copy
114
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 = 4376984 ;
Copy
115
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 = 4376988 ;
Copy
116
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 = 4376223 ;
Copy
117
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 = 4376449 ;
Copy
118
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 = 4376453 ;
Copy
119
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 = 4376715 ;
Copy
120
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 = 4376465 ;
Copy
121
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 = 4376755 ;
Copy
122
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 = 4376313 ;
Copy
123
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 = 4376315 ;
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 = 4376317 ;
Copy
125
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 = 4376319 ;
Copy
126
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 = 4376901 ;
Copy
127
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 = 4376935 ;
Copy
128
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 = 4376779 ;
Copy
129
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 = 4376208 ;
Copy
130
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 = 4376767 ;
Copy
131
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 = 4376778 ;
Copy
132
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 = 4376441 ;
Copy
133
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 = 4376445 ;
Copy
134
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 = 4376454 ;
Copy
135
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 = 4376780 ;
Copy
136
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 = 4376783 ;
Copy
137
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 = 4376273 ;
Copy
138
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 = 4376737 ;
Copy
139
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 = 4376761 ;
Copy
140
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 = 4376764 ;
Copy
141
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 = 4376784 ;
Copy
142
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 = 4376797 ;
Copy
143
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 = 4376822 ;
Copy
144
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 = 4376726 ;
Copy
145
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 = 4376232 ;
Copy
146
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 = 4376765 ;
Copy
147
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 = 4376766 ;
Copy
148
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 = 4376843 ;
Copy
149
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 = 4376865 ;
Copy
150
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 = 4376431 ;
Copy
151
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 = 4376439 ;
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 = 4376444 ;
Copy
153
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 = 4376462 ;
Copy
154
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 = 4376207 ;
Copy
155
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 = 4376721 ;
Copy
156
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 = 4376217 ;
Copy
157
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 = 4376733 ;
Copy
158
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 = 4376225 ;
Copy
159
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 = 4376741 ;
Copy
160
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 = 4376744 ;
Copy
161
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 = 4376747 ;
Copy
162
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 = 4376239 ;
Copy
163
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 = 4376209 ;
Copy
164
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 = 4376455 ;
Copy
165
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 = 4376458 ;
Copy
166
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 = 4376203 ;
Copy
167
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 = 4376722 ;
Copy
168
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 = 4376478 ;
Copy
169
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 = 4376481 ;
Copy
170
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 = 4376738 ;
Copy
171
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 = 4376237 ;
Copy
172
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 = 4376238 ;
Copy
173
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 = 4376793 ;
Copy
174
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 = 4376205 ;
Copy
175
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 = 4376195 ;
Copy
176
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 = 4376835 ;
Copy
177
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 = 4376836 ;
Copy
178
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 = 4376853 ;
Copy
179
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 = 4376906 ;
Copy
180
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 = 4376910 ;
Copy
181
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 = 4376911 ;
Copy
182
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 = 4376913 ;
Copy
183
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 = 4376827 ;
Copy
184
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 = 4376858 ;
Copy
185
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 = 4376819 ;
Copy
186
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 = 4376321 ;
Copy
187
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 = 4376866 ;
Copy
188
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 = 4376867 ;
Copy
189
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 = 4376869 ;
Copy
190
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 = 4376881 ;
Copy
191
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 = 4376419 ;
Copy
192
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 = 4376422 ;
Copy
193
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 = 4376423 ;
Copy
194
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 = 4376430 ;
Copy
195
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 = 4376437 ;
Copy
196
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 = 4376450 ;
Copy
197
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 = 4376461 ;
Copy
198
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 = 4376468 ;
Copy
199
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 = 4376469 ;
Copy
200
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 = 4376216 ;
Copy
201
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 = 4376731 ;
Copy
202
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 = 4376734 ;
Copy
203
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 = 4376739 ;
Copy
204
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 = 4376743 ;
Copy
205
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 = 4376745 ;
Copy
206
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 = 4376749 ;
Copy
207
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 = 4376768 ;
Copy
208
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 = 4376787 ;
Copy
209
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 = 4376789 ;
Copy
210
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 = 4376790 ;
Copy
211
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 = 4376794 ;
Copy
212
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 = 4376424 ;
Copy
213
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 = 4376752 ;
Copy
214
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 = 4376763 ;
Copy
215
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 = 4376770 ;
Copy
216
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 = 4376220 ;
Copy
217
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 = 4376206 ;
Copy
218
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 = 4376210 ;
Copy
219
0.05 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
220
0.31 ms
UPDATE triage_scan SET manifest_item_id = ? WHERE id = ?
Parameters :
[
5723695
5916102
]
UPDATE triage_scan SET manifest_item_id = 5723695 WHERE id = 5916102 ;
Copy
221
0.29 ms
UPDATE lot SET units = ? , estimated_sales = ? , msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
555
605.76
6057.58
0
0
"2025-05-21 11:01:13 "
53210
]
UPDATE lot SET units = 555 , estimated_sales = 605.76 , msrp_current = 6057.58 , is_high_value = 0 , is_cp = 0 , updated_at = '2025-05-21 11:01:13' WHERE id = 53210 ;
Copy
222
0.56 ms
"COMMIT"
223
0.56 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 . is_oversize AS is_oversize_32 , t0 . cost AS cost_33 , t0 . is_imported AS is_imported_34 , t0 . supplier_pallet_number AS supplier_pallet_number_35 , t0 . created_at AS created_at_36 , t0 . updated_at AS updated_at_37 , t0 . po_id AS po_id_38 , t0 . category_id AS category_id_39 , t0 . cp_product_id AS cp_product_id_40 , t0 . product_condition_id AS product_condition_id_41 , t0 . merged_with_id AS merged_with_id_42 , t0 . preparation_lot_id AS preparation_lot_id_43 , t0 . previous_po_id AS previous_po_id_44 , t0 . related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0 . po_id = ? AND t0 . category_id = ? AND t0 . is_closed = ? AND t0 . is_oversize = ? LIMIT 1
Parameters :
[
3000
155
0
1
]
SELECT
t0 . id AS id_1 ,
t0 . number AS number_2 ,
t0 . package_units AS package_units_3 ,
t0 . weight AS weight_4 ,
t0 . user AS user_5 ,
t0 . format AS format_6 ,
t0 . photos AS photos_7 ,
t0 . name AS name_8 ,
t0 . extended AS extended_9 ,
t0 . units AS units_10 ,
t0 . discount AS discount_11 ,
t0 . estimated_sales AS estimated_sales_12 ,
t0 . is_initialized AS is_initialized_13 ,
t0 . msrp_current AS msrp_current_14 ,
t0 . is_closed AS is_closed_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_cp AS is_cp_17 ,
t0 . estimated_sales_min_target AS estimated_sales_min_target_18 ,
t0 . estimated_sales_max_target AS estimated_sales_max_target_19 ,
t0 . display_name AS display_name_20 ,
t0 . quantity AS quantity_21 ,
t0 . cp_quantity AS cp_quantity_22 ,
t0 . is_truckload AS is_truckload_23 ,
t0 . is_photos_compressed AS is_photos_compressed_24 ,
t0 . is_destroy AS is_destroy_25 ,
t0 . package_sizes AS package_sizes_26 ,
t0 . is_listing_done AS is_listing_done_27 ,
t0 . discount_triage AS discount_triage_28 ,
t0 . volumetric_weight AS volumetric_weight_29 ,
t0 . real_weight AS real_weight_30 ,
t0 . previous_number AS previous_number_31 ,
t0 . is_oversize AS is_oversize_32 ,
t0 . cost AS cost_33 ,
t0 . is_imported AS is_imported_34 ,
t0 . supplier_pallet_number AS supplier_pallet_number_35 ,
t0 . created_at AS created_at_36 ,
t0 . updated_at AS updated_at_37 ,
t0 . po_id AS po_id_38 ,
t0 . category_id AS category_id_39 ,
t0 . cp_product_id AS cp_product_id_40 ,
t0 . product_condition_id AS product_condition_id_41 ,
t0 . merged_with_id AS merged_with_id_42 ,
t0 . preparation_lot_id AS preparation_lot_id_43 ,
t0 . previous_po_id AS previous_po_id_44 ,
t0 . related_front_product_id AS related_front_product_id_45
FROM
lot t0
WHERE
t0 . po_id = ?
AND t0 . category_id = ?
AND t0 . is_closed = ?
AND t0 . is_oversize = ?
LIMIT
1
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 . is_oversize AS is_oversize_32 , t0 . cost AS cost_33 , t0 . is_imported AS is_imported_34 , t0 . supplier_pallet_number AS supplier_pallet_number_35 , t0 . created_at AS created_at_36 , t0 . updated_at AS updated_at_37 , t0 . po_id AS po_id_38 , t0 . category_id AS category_id_39 , t0 . cp_product_id AS cp_product_id_40 , t0 . product_condition_id AS product_condition_id_41 , t0 . merged_with_id AS merged_with_id_42 , t0 . preparation_lot_id AS preparation_lot_id_43 , t0 . previous_po_id AS previous_po_id_44 , t0 . related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0 . po_id = 3000 AND t0 . category_id = 155 AND t0 . is_closed = 0 AND t0 . is_oversize = 1 LIMIT 1 ;
Copy
224
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
225
0.64 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 . lot_id AS lot_id_8 , t0 . product_id AS product_id_9 , t0 . po_id AS po_id_10 , t0 . manifest_item_id AS manifest_item_id_11 , t0 . original_lot_id AS original_lot_id_12 , t0 . duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0 . lot_id = ? ORDER BY t0 . extended DESC
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . lot_id AS lot_id_8 , t0 . product_id AS product_id_9 , t0 . po_id AS po_id_10 , t0 . manifest_item_id AS manifest_item_id_11 , t0 . original_lot_id AS original_lot_id_12 , t0 . duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0 . lot_id = 53214 ORDER BY t0 . extended DESC ;
Copy
226
0.33 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 = 4376403 ;
Copy
227
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 = 4376368 ;
Copy
228
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 = 4376723 ;
Copy
229
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 = 4376404 ;
Copy
230
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 = 4376385 ;
Copy
231
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 = 4376390 ;
Copy
232
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 = 4376374 ;
Copy
233
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 = 4376372 ;
Copy
234
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 = 4376378 ;
Copy
235
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 = 4376395 ;
Copy
236
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 = 4376407 ;
Copy
237
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 = 4376942 ;
Copy
238
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 = 4376383 ;
Copy
239
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 = 4376387 ;
Copy
240
0.32 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 = 4376418 ;
Copy
241
0.27 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 = 4376412 ;
Copy
242
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 = 4376400 ;
Copy
243
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 = 4376406 ;
Copy
244
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 = 4376421 ;
Copy
245
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 = 4376856 ;
Copy
246
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 = 4376369 ;
Copy
247
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 = 4376371 ;
Copy
248
0.21 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 = 4376373 ;
Copy
249
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 = 4376375 ;
Copy
250
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 = 4376380 ;
Copy
251
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 = 4376381 ;
Copy
252
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 = 4376396 ;
Copy
253
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 = 4376397 ;
Copy
254
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 = 4376413 ;
Copy
255
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 = 4376817 ;
Copy
256
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 = 4376847 ;
Copy
257
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 = 4376852 ;
Copy
258
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 = 4376399 ;
Copy
259
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 = 4376411 ;
Copy
260
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 = 4376820 ;
Copy
261
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 = 4376401 ;
Copy
262
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 = 4376427 ;
Copy
263
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 = 4376415 ;
Copy
264
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 = 4376821 ;
Copy
265
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 = 4376417 ;
Copy
266
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 = 4376426 ;
Copy
267
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 = 4376759 ;
Copy
268
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 = 4376781 ;
Copy
269
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 = 4376782 ;
Copy
270
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
271
0.33 ms
UPDATE triage_scan SET confirm_request = ? , msrp = ? , lot_id = ? , oversize_lot_id = ? WHERE id = ?
Parameters :
[
"872611 - 872615 "
19.97
53210
53214
5916102
]
UPDATE triage_scan SET confirm_request = '872611 - 872615' , msrp = 19.97 , lot_id = 53210 , oversize_lot_id = 53214 WHERE id = 5916102 ;
Copy
272
0.15 ms
UPDATE lot SET msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
1203.5
0
0
"2025-05-21 11:01:13 "
53214
]
UPDATE lot SET msrp_current = 1203.5 , is_high_value = 0 , is_cp = 0 , updated_at = '2025-05-21 11:01:13' WHERE id = 53214 ;
Copy
273
0.51 ms
"COMMIT"
274
0.36 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 . show_oversize_button AS show_oversize_button_25 , t0 . user_id AS user_id_26 , t0 . po_id AS po_id_27 , t0 . manifest_item_id AS manifest_item_id_28 , t0 . lot_id AS lot_id_29 , t0 . action_id AS action_id_30 , t0 . triage_question_id AS triage_question_id_31 , t0 . lot_item_id AS lot_item_id_32 , t0 . scan_category_group_id AS scan_category_group_id_33 , t0 . oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0 . po_id = ? AND t0 . session_number = ? AND t0 . user_id = ? ORDER BY t0 . id DESC LIMIT 5
Parameters :
[
3000
"ts682de35fb49a8 "
112
]
SELECT t0 . id AS id_1 , t0 . session_number AS session_number_2 , t0 . code AS code_3 , t0 . scan_type AS scan_type_4 , t0 . is_confirmed AS is_confirmed_5 , t0 . is_generic AS is_generic_6 , t0 . is_validation AS is_validation_7 , t0 . is_category_validation AS is_category_validation_8 , t0 . is_action AS is_action_9 , t0 . is_question AS is_question_10 , t0 . has_error AS has_error_11 , t0 . is_deleted AS is_deleted_12 , t0 . confirm_request AS confirm_request_13 , t0 . is_error AS is_error_14 , t0 . result_template AS result_template_15 , t0 . msrp AS msrp_16 , t0 . has_cp AS has_cp_17 , t0 . cp_name AS cp_name_18 , t0 . cp_number AS cp_number_19 , t0 . cp_quantity AS cp_quantity_20 , t0 . is_confirmed_lot AS is_confirmed_lot_21 , t0 . is_confirmed_cp AS is_confirmed_cp_22 , t0 . is_rejected AS is_rejected_23 , t0 . cp_package AS cp_package_24 , t0 . show_oversize_button AS show_oversize_button_25 , t0 . user_id AS user_id_26 , t0 . po_id AS po_id_27 , t0 . manifest_item_id AS manifest_item_id_28 , t0 . lot_id AS lot_id_29 , t0 . action_id AS action_id_30 , t0 . triage_question_id AS triage_question_id_31 , t0 . lot_item_id AS lot_item_id_32 , t0 . scan_category_group_id AS scan_category_group_id_33 , t0 . oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0 . po_id = 3000 AND t0 . session_number = 'ts682de35fb49a8' AND t0 . user_id = 112 ORDER BY t0 . id DESC LIMIT 5 ;
Copy
275
0.07 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
276
0.07 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 = 112 AND t0 . is_closed = 0 ORDER BY t0 . id DESC LIMIT 1 ;
Copy
277
0.07 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
278
0.12 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
279
0.06 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
280
0.14 ms
UPDATE `product_condition` SET is_active = ? WHERE id = ?
UPDATE `product_condition` SET is_active = 1 WHERE id = 2 ;
Copy
281
0.14 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
89.82
4376368
]
UPDATE lot_item SET extended = 89.82 WHERE id = 4376368 ;
Copy
282
0.10 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
74.85
4376385
]
UPDATE lot_item SET extended = 74.85 WHERE id = 4376385 ;
Copy
283
0.09 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
74.85
4376390
]
UPDATE lot_item SET extended = 74.85 WHERE id = 4376390 ;
Copy
284
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
44.91
4376372
]
UPDATE lot_item SET extended = 44.91 WHERE id = 4376372 ;
Copy
285
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
44.91
4376378
]
UPDATE lot_item SET extended = 44.91 WHERE id = 4376378 ;
Copy
286
0.05 ms
"COMMIT"
287
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 :
[
28
4
112
"2025-05-21 00:00:00 "
"2025-05-21 11:01:13 "
]
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 = 28 AND s0_ . scan_category_group_id = 4 AND s0_ . user_id = 112 AND s0_ . created_at > = '2025-05-21 00:00:00' AND s0_ . created_at < = '2025-05-21 11:01:13' ORDER BY s0_ . id DESC ;
Copy
288
0.61 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . supplier_pallet_number AS supplier_pallet_number_45 ,
t0 . created_at AS created_at_46 ,
t0 . updated_at AS updated_at_47 ,
t0 . po_id AS po_id_48 ,
t0 . product_id AS product_id_49 ,
t0 . scanned_by_id AS scanned_by_id_50 ,
t0 . imported_by_id AS imported_by_id_51 ,
t0 . analyzed_by_id AS analyzed_by_id_52 ,
t0 . supplier_id AS supplier_id_53 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_54 ,
t0 . restock_category_id AS restock_category_id_55 ,
t0 . preparation_lot_id AS preparation_lot_id_56 ,
t0 . triage_category_id AS triage_category_id_57
FROM
manifest_item t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = 5723690 ;
Copy
289
0.12 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 . is_oversize AS is_oversize_20 , t0 . old_name AS old_name_21 , t0 . is_updated AS is_updated_22 , t0 . scraper_class AS scraper_class_23 , t0 . scraper_id AS scraper_id_24 , t0 . is_upc_checked AS is_upc_checked_25 , t0 . is_upc_valid AS is_upc_valid_26 , t0 . is_ean_checked AS is_ean_checked_27 , t0 . is_ean_valid AS is_ean_valid_28 , t0 . is_validation AS is_validation_29 , t0 . is_category_validation AS is_category_validation_30 , t0 . previous_category_id AS previous_category_id_31 , t0 . last_category_change_at AS last_category_change_at_32 , t0 . restock_category_id AS restock_category_id_33 , t0 . analyzed_by_id AS analyzed_by_id_34 , t0 . upcitemdb_id AS upcitemdb_id_35 , t0 . synccentric_id AS synccentric_id_36 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 . is_oversize AS is_oversize_20 , t0 . old_name AS old_name_21 , t0 . is_updated AS is_updated_22 , t0 . scraper_class AS scraper_class_23 , t0 . scraper_id AS scraper_id_24 , t0 . is_upc_checked AS is_upc_checked_25 , t0 . is_upc_valid AS is_upc_valid_26 , t0 . is_ean_checked AS is_ean_checked_27 , t0 . is_ean_valid AS is_ean_valid_28 , t0 . is_validation AS is_validation_29 , t0 . is_category_validation AS is_category_validation_30 , t0 . previous_category_id AS previous_category_id_31 , t0 . last_category_change_at AS last_category_change_at_32 , t0 . restock_category_id AS restock_category_id_33 , t0 . analyzed_by_id AS analyzed_by_id_34 , t0 . upcitemdb_id AS upcitemdb_id_35 , t0 . synccentric_id AS synccentric_id_36 FROM product t0 WHERE t0 . id = 1137448 ;
Copy
290
0.37 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . supplier_pallet_number AS supplier_pallet_number_45 ,
t0 . created_at AS created_at_46 ,
t0 . updated_at AS updated_at_47 ,
t0 . po_id AS po_id_48 ,
t0 . product_id AS product_id_49 ,
t0 . scanned_by_id AS scanned_by_id_50 ,
t0 . imported_by_id AS imported_by_id_51 ,
t0 . analyzed_by_id AS analyzed_by_id_52 ,
t0 . supplier_id AS supplier_id_53 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_54 ,
t0 . restock_category_id AS restock_category_id_55 ,
t0 . preparation_lot_id AS preparation_lot_id_56 ,
t0 . triage_category_id AS triage_category_id_57
FROM
manifest_item t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = 5723691 ;
Copy
291
0.61 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . supplier_pallet_number AS supplier_pallet_number_45 ,
t0 . created_at AS created_at_46 ,
t0 . updated_at AS updated_at_47 ,
t0 . po_id AS po_id_48 ,
t0 . product_id AS product_id_49 ,
t0 . scanned_by_id AS scanned_by_id_50 ,
t0 . imported_by_id AS imported_by_id_51 ,
t0 . analyzed_by_id AS analyzed_by_id_52 ,
t0 . supplier_id AS supplier_id_53 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_54 ,
t0 . restock_category_id AS restock_category_id_55 ,
t0 . preparation_lot_id AS preparation_lot_id_56 ,
t0 . triage_category_id AS triage_category_id_57
FROM
manifest_item t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = 5723692 ;
Copy
292
0.11 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 . is_oversize AS is_oversize_20 , t0 . old_name AS old_name_21 , t0 . is_updated AS is_updated_22 , t0 . scraper_class AS scraper_class_23 , t0 . scraper_id AS scraper_id_24 , t0 . is_upc_checked AS is_upc_checked_25 , t0 . is_upc_valid AS is_upc_valid_26 , t0 . is_ean_checked AS is_ean_checked_27 , t0 . is_ean_valid AS is_ean_valid_28 , t0 . is_validation AS is_validation_29 , t0 . is_category_validation AS is_category_validation_30 , t0 . previous_category_id AS previous_category_id_31 , t0 . last_category_change_at AS last_category_change_at_32 , t0 . restock_category_id AS restock_category_id_33 , t0 . analyzed_by_id AS analyzed_by_id_34 , t0 . upcitemdb_id AS upcitemdb_id_35 , t0 . synccentric_id AS synccentric_id_36 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 . is_oversize AS is_oversize_20 , t0 . old_name AS old_name_21 , t0 . is_updated AS is_updated_22 , t0 . scraper_class AS scraper_class_23 , t0 . scraper_id AS scraper_id_24 , t0 . is_upc_checked AS is_upc_checked_25 , t0 . is_upc_valid AS is_upc_valid_26 , t0 . is_ean_checked AS is_ean_checked_27 , t0 . is_ean_valid AS is_ean_valid_28 , t0 . is_validation AS is_validation_29 , t0 . is_category_validation AS is_category_validation_30 , t0 . previous_category_id AS previous_category_id_31 , t0 . last_category_change_at AS last_category_change_at_32 , t0 . restock_category_id AS restock_category_id_33 , t0 . analyzed_by_id AS analyzed_by_id_34 , t0 . upcitemdb_id AS upcitemdb_id_35 , t0 . synccentric_id AS synccentric_id_36 FROM product t0 WHERE t0 . id = 1137441 ;
Copy
293
0.52 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . supplier_pallet_number AS supplier_pallet_number_45 ,
t0 . created_at AS created_at_46 ,
t0 . updated_at AS updated_at_47 ,
t0 . po_id AS po_id_48 ,
t0 . product_id AS product_id_49 ,
t0 . scanned_by_id AS scanned_by_id_50 ,
t0 . imported_by_id AS imported_by_id_51 ,
t0 . analyzed_by_id AS analyzed_by_id_52 ,
t0 . supplier_id AS supplier_id_53 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_54 ,
t0 . restock_category_id AS restock_category_id_55 ,
t0 . preparation_lot_id AS preparation_lot_id_56 ,
t0 . triage_category_id AS triage_category_id_57
FROM
manifest_item t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . quantity AS quantity_3 , t0 . method AS method_4 , t0 . msrp AS msrp_5 , t0 . name AS name_6 , t0 . category AS category_7 , t0 . merchant_sku AS merchant_sku_8 , t0 . is_analyzed AS is_analyzed_9 , t0 . analyzed_at AS analyzed_at_10 , t0 . is_auto_analyzed AS is_auto_analyzed_11 , t0 . converted AS converted_12 , t0 . is_generic AS is_generic_13 , t0 . position AS position_14 , t0 . is_cp AS is_cp_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_prepared AS is_prepared_17 , t0 . preparation_cp_quantity AS preparation_cp_quantity_18 , t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 , t0 . preparation_cp_total_units AS preparation_cp_total_units_20 , t0 . preparation_cp_extended AS preparation_cp_extended_21 , t0 . preparation_cp_discount AS preparation_cp_discount_22 , t0 . cp_name AS cp_name_23 , t0 . cp_display_name AS cp_display_name_24 , t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 , t0 . preparation_lot_units AS preparation_lot_units_26 , t0 . preparation_lot_discount AS preparation_lot_discount_27 , t0 . preparation_lot_extended AS preparation_lot_extended_28 , t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 , t0 . is_upcitemdb_error AS is_upcitemdb_error_30 , t0 . is_already_in_database AS is_already_in_database_31 , t0 . photo AS photo_32 , t0 . quantity_imported AS quantity_imported_33 , t0 . quantity_scanned AS quantity_scanned_34 , t0 . quantity_triage AS quantity_triage_35 , t0 . is_flag_preparation_done AS is_flag_preparation_done_36 , t0 . premade_lot_number AS premade_lot_number_37 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 , t0 . is_synccentric_search_required AS is_synccentric_search_required_39 , t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 , t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 , t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 , t0 . is_validation AS is_validation_43 , t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 , t0 . supplier_pallet_number AS supplier_pallet_number_45 , t0 . created_at AS created_at_46 , t0 . updated_at AS updated_at_47 , t0 . po_id AS po_id_48 , t0 . product_id AS product_id_49 , t0 . scanned_by_id AS scanned_by_id_50 , t0 . imported_by_id AS imported_by_id_51 , t0 . analyzed_by_id AS analyzed_by_id_52 , t0 . supplier_id AS supplier_id_53 , t0 . original_preparation_lot_id AS original_preparation_lot_id_54 , t0 . restock_category_id AS restock_category_id_55 , t0 . preparation_lot_id AS preparation_lot_id_56 , t0 . triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0 . id = 5723693 ;
Copy