1
0.32 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 = 121 ;
Copy
2
0.13 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . exchange_rate AS exchange_rate_3 , t0 . position AS position_4 , t0 . is_msrp_source AS is_msrp_source_5 , t0 . is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0 . is_msrp_source = ? ORDER BY t0 . position ASC
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . exchange_rate AS exchange_rate_3 , t0 . position AS position_4 , t0 . is_msrp_source AS is_msrp_source_5 , t0 . is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0 . is_msrp_source = 1 ORDER BY t0 . position ASC ;
Copy
3
0.10 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . exchange_rate AS exchange_rate_3 , t0 . position AS position_4 , t0 . is_msrp_source AS is_msrp_source_5 , t0 . is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0 . is_name_source = ? ORDER BY t0 . position ASC
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . exchange_rate AS exchange_rate_3 , t0 . position AS position_4 , t0 . is_msrp_source AS is_msrp_source_5 , t0 . is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0 . is_name_source = 1 ORDER BY t0 . position ASC ;
Copy
4
0.20 ms
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . active AS active_3 , t0 . nb_pallet AS nb_pallet_4 , t0 . nb_unit AS nb_unit_5 , t0 . eta AS eta_6 , t0 . received_at AS received_at_7 , t0 . manifest_import AS manifest_import_8 , t0 . note AS note_9 , t0 . cost_po AS cost_po_10 , t0 . cost_transport AS cost_transport_11 , t0 . cost_customs AS cost_customs_12 , t0 . msrp_value AS msrp_value_13 , t0 . finances_selling_estimated AS finances_selling_estimated_14 , t0 . seal_number_provided AS seal_number_provided_15 , t0 . seal_number_received AS seal_number_received_16 , t0 . nb_unit_received AS nb_unit_received_17 , t0 . nb_pallet_received AS nb_pallet_received_18 , t0 . seal_number_na AS seal_number_na_19 , t0 . note_reception AS note_reception_20 , t0 . location AS location_21 , t0 . progress_step_reception AS progress_step_reception_22 , t0 . progress_step_scan_manifest AS progress_step_scan_manifest_23 , t0 . progress_step_import_manifest AS progress_step_import_manifest_24 , t0 . progress_step_analysis AS progress_step_analysis_25 , t0 . progress_step_preparation AS progress_step_preparation_26 , t0 . progress_step_triage AS progress_step_triage_27 , t0 . progress_step_photobooth AS progress_step_photobooth_28 , t0 . progress_step_listing AS progress_step_listing_29 , t0 . progress_step_conciliation AS progress_step_conciliation_30 , t0 . preparation_total_units AS preparation_total_units_31 , t0 . preparation_total_extended AS preparation_total_extended_32 , t0 . preparation_total_selling_extended AS preparation_total_selling_extended_33 , t0 . preparation_total_cps AS preparation_total_cps_34 , t0 . preparation_total_lots AS preparation_total_lots_35 , t0 . import_product_quantity AS import_product_quantity_36 , t0 . import_unit_quantity AS import_unit_quantity_37 , t0 . is_truckload AS is_truckload_38 , t0 . progress_step_truckload AS progress_step_truckload_39 , t0 . is_autoanalysis_running AS is_autoanalysis_running_40 , t0 . is_autoanalysis_done AS is_autoanalysis_done_41 , t0 . bol_supplier AS bol_supplier_42 , t0 . customs_description AS customs_description_43 , t0 . customs_country_of_origin AS customs_country_of_origin_44 , t0 . customs_hs_code AS customs_hs_code_45 , t0 . cost_production AS cost_production_46 , t0 . next_cp_number AS next_cp_number_47 , t0 . is_auto_triage AS is_auto_triage_48 , t0 . is_lot_import_allowed AS is_lot_import_allowed_49 , t0 . has_premade_lots AS has_premade_lots_50 , t0 . is_auto_triage_truckload AS is_auto_triage_truckload_51 , t0 . auto_triage_category_name AS auto_triage_category_name_52 , t0 . auto_triage_category_discount AS auto_triage_category_discount_53 , t0 . archived_at AS archived_at_54 , t0 . is_final AS is_final_55 , t0 . final_total_manifest_items AS final_total_manifest_items_56 , t0 . final_total_analyzed_items AS final_total_analyzed_items_57 , t0 . final_total_different_items AS final_total_different_items_58 , t0 . final_total_triage_items AS final_total_triage_items_59 , t0 . final_import_unit_quantity AS final_import_unit_quantity_60 , t0 . final_total_hours AS final_total_hours_61 , t0 . final_total_scans_per_hour AS final_total_scans_per_hour_62 , t0 . final_msrp AS final_msrp_63 , t0 . final_estimated_sales_listing AS final_estimated_sales_listing_64 , t0 . final_selling_po AS final_selling_po_65 , t0 . final_cog_real AS final_cog_real_66 , t0 . final_nb_lots AS final_nb_lots_67 , t0 . is_new_mappings_required AS is_new_mappings_required_68 , t0 . auto_analysis_start_at AS auto_analysis_start_at_69 , t0 . auto_analysis_end_at AS auto_analysis_end_at_70 , t0 . current_synccentric_campaign AS current_synccentric_campaign_71 , t0 . analysis_queue_priority AS analysis_queue_priority_72 , t0 . is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74 , t0 . synccentric_export_current_page AS synccentric_export_current_page_75 , t0 . synccentric_export_last_page AS synccentric_export_last_page_76 , t0 . is_synccentric_search_required AS is_synccentric_search_required_77 , t0 . is_synccentric_import_running AS is_synccentric_import_running_78 , t0 . is_synccentric_import_done AS is_synccentric_import_done_79 , t0 . is_synccentric_search_running AS is_synccentric_search_running_80 , t0 . is_synccentric_search_done AS is_synccentric_search_done_81 , t0 . is_synccentric_export_running AS is_synccentric_export_running_82 , t0 . is_synccentric_export_done AS is_synccentric_export_done_83 , t0 . is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84 , t0 . is_synccentric_import_started AS is_synccentric_import_started_85 , t0 . is_synccentric_export_started AS is_synccentric_export_started_86 , t0 . is_autoanalysis_started AS is_autoanalysis_started_87 , t0 . has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88 , t0 . has_batch_ids AS has_batch_ids_89 , t0 . status_id AS status_id_90 , t0 . supplier_id AS supplier_id_91 , t0 . product_condition_id AS product_condition_id_92 , t0 . manifest_style_id AS manifest_style_id_93 , t0 . invoice_style_id AS invoice_style_id_94 , t0 . supplier_invoice_state_id AS supplier_invoice_state_id_95 , t0 . warehouse_id AS warehouse_id_96 , t0 . auto_triage_category_id AS auto_triage_category_id_97 FROM po t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . number AS number_2 ,
t0 . active AS active_3 ,
t0 . nb_pallet AS nb_pallet_4 ,
t0 . nb_unit AS nb_unit_5 ,
t0 . eta AS eta_6 ,
t0 . received_at AS received_at_7 ,
t0 . manifest_import AS manifest_import_8 ,
t0 . note AS note_9 ,
t0 . cost_po AS cost_po_10 ,
t0 . cost_transport AS cost_transport_11 ,
t0 . cost_customs AS cost_customs_12 ,
t0 . msrp_value AS msrp_value_13 ,
t0 . finances_selling_estimated AS finances_selling_estimated_14 ,
t0 . seal_number_provided AS seal_number_provided_15 ,
t0 . seal_number_received AS seal_number_received_16 ,
t0 . nb_unit_received AS nb_unit_received_17 ,
t0 . nb_pallet_received AS nb_pallet_received_18 ,
t0 . seal_number_na AS seal_number_na_19 ,
t0 . note_reception AS note_reception_20 ,
t0 . location AS location_21 ,
t0 . progress_step_reception AS progress_step_reception_22 ,
t0 . progress_step_scan_manifest AS progress_step_scan_manifest_23 ,
t0 . progress_step_import_manifest AS progress_step_import_manifest_24 ,
t0 . progress_step_analysis AS progress_step_analysis_25 ,
t0 . progress_step_preparation AS progress_step_preparation_26 ,
t0 . progress_step_triage AS progress_step_triage_27 ,
t0 . progress_step_photobooth AS progress_step_photobooth_28 ,
t0 . progress_step_listing AS progress_step_listing_29 ,
t0 . progress_step_conciliation AS progress_step_conciliation_30 ,
t0 . preparation_total_units AS preparation_total_units_31 ,
t0 . preparation_total_extended AS preparation_total_extended_32 ,
t0 . preparation_total_selling_extended AS preparation_total_selling_extended_33 ,
t0 . preparation_total_cps AS preparation_total_cps_34 ,
t0 . preparation_total_lots AS preparation_total_lots_35 ,
t0 . import_product_quantity AS import_product_quantity_36 ,
t0 . import_unit_quantity AS import_unit_quantity_37 ,
t0 . is_truckload AS is_truckload_38 ,
t0 . progress_step_truckload AS progress_step_truckload_39 ,
t0 . is_autoanalysis_running AS is_autoanalysis_running_40 ,
t0 . is_autoanalysis_done AS is_autoanalysis_done_41 ,
t0 . bol_supplier AS bol_supplier_42 ,
t0 . customs_description AS customs_description_43 ,
t0 . customs_country_of_origin AS customs_country_of_origin_44 ,
t0 . customs_hs_code AS customs_hs_code_45 ,
t0 . cost_production AS cost_production_46 ,
t0 . next_cp_number AS next_cp_number_47 ,
t0 . is_auto_triage AS is_auto_triage_48 ,
t0 . is_lot_import_allowed AS is_lot_import_allowed_49 ,
t0 . has_premade_lots AS has_premade_lots_50 ,
t0 . is_auto_triage_truckload AS is_auto_triage_truckload_51 ,
t0 . auto_triage_category_name AS auto_triage_category_name_52 ,
t0 . auto_triage_category_discount AS auto_triage_category_discount_53 ,
t0 . archived_at AS archived_at_54 ,
t0 . is_final AS is_final_55 ,
t0 . final_total_manifest_items AS final_total_manifest_items_56 ,
t0 . final_total_analyzed_items AS final_total_analyzed_items_57 ,
t0 . final_total_different_items AS final_total_different_items_58 ,
t0 . final_total_triage_items AS final_total_triage_items_59 ,
t0 . final_import_unit_quantity AS final_import_unit_quantity_60 ,
t0 . final_total_hours AS final_total_hours_61 ,
t0 . final_total_scans_per_hour AS final_total_scans_per_hour_62 ,
t0 . final_msrp AS final_msrp_63 ,
t0 . final_estimated_sales_listing AS final_estimated_sales_listing_64 ,
t0 . final_selling_po AS final_selling_po_65 ,
t0 . final_cog_real AS final_cog_real_66 ,
t0 . final_nb_lots AS final_nb_lots_67 ,
t0 . is_new_mappings_required AS is_new_mappings_required_68 ,
t0 . auto_analysis_start_at AS auto_analysis_start_at_69 ,
t0 . auto_analysis_end_at AS auto_analysis_end_at_70 ,
t0 . current_synccentric_campaign AS current_synccentric_campaign_71 ,
t0 . analysis_queue_priority AS analysis_queue_priority_72 ,
t0 . is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74 ,
t0 . synccentric_export_current_page AS synccentric_export_current_page_75 ,
t0 . synccentric_export_last_page AS synccentric_export_last_page_76 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_77 ,
t0 . is_synccentric_import_running AS is_synccentric_import_running_78 ,
t0 . is_synccentric_import_done AS is_synccentric_import_done_79 ,
t0 . is_synccentric_search_running AS is_synccentric_search_running_80 ,
t0 . is_synccentric_search_done AS is_synccentric_search_done_81 ,
t0 . is_synccentric_export_running AS is_synccentric_export_running_82 ,
t0 . is_synccentric_export_done AS is_synccentric_export_done_83 ,
t0 . is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84 ,
t0 . is_synccentric_import_started AS is_synccentric_import_started_85 ,
t0 . is_synccentric_export_started AS is_synccentric_export_started_86 ,
t0 . is_autoanalysis_started AS is_autoanalysis_started_87 ,
t0 . has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88 ,
t0 . has_batch_ids AS has_batch_ids_89 ,
t0 . status_id AS status_id_90 ,
t0 . supplier_id AS supplier_id_91 ,
t0 . product_condition_id AS product_condition_id_92 ,
t0 . manifest_style_id AS manifest_style_id_93 ,
t0 . invoice_style_id AS invoice_style_id_94 ,
t0 . supplier_invoice_state_id AS supplier_invoice_state_id_95 ,
t0 . warehouse_id AS warehouse_id_96 ,
t0 . auto_triage_category_id AS auto_triage_category_id_97
FROM
po t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . active AS active_3 , t0 . nb_pallet AS nb_pallet_4 , t0 . nb_unit AS nb_unit_5 , t0 . eta AS eta_6 , t0 . received_at AS received_at_7 , t0 . manifest_import AS manifest_import_8 , t0 . note AS note_9 , t0 . cost_po AS cost_po_10 , t0 . cost_transport AS cost_transport_11 , t0 . cost_customs AS cost_customs_12 , t0 . msrp_value AS msrp_value_13 , t0 . finances_selling_estimated AS finances_selling_estimated_14 , t0 . seal_number_provided AS seal_number_provided_15 , t0 . seal_number_received AS seal_number_received_16 , t0 . nb_unit_received AS nb_unit_received_17 , t0 . nb_pallet_received AS nb_pallet_received_18 , t0 . seal_number_na AS seal_number_na_19 , t0 . note_reception AS note_reception_20 , t0 . location AS location_21 , t0 . progress_step_reception AS progress_step_reception_22 , t0 . progress_step_scan_manifest AS progress_step_scan_manifest_23 , t0 . progress_step_import_manifest AS progress_step_import_manifest_24 , t0 . progress_step_analysis AS progress_step_analysis_25 , t0 . progress_step_preparation AS progress_step_preparation_26 , t0 . progress_step_triage AS progress_step_triage_27 , t0 . progress_step_photobooth AS progress_step_photobooth_28 , t0 . progress_step_listing AS progress_step_listing_29 , t0 . progress_step_conciliation AS progress_step_conciliation_30 , t0 . preparation_total_units AS preparation_total_units_31 , t0 . preparation_total_extended AS preparation_total_extended_32 , t0 . preparation_total_selling_extended AS preparation_total_selling_extended_33 , t0 . preparation_total_cps AS preparation_total_cps_34 , t0 . preparation_total_lots AS preparation_total_lots_35 , t0 . import_product_quantity AS import_product_quantity_36 , t0 . import_unit_quantity AS import_unit_quantity_37 , t0 . is_truckload AS is_truckload_38 , t0 . progress_step_truckload AS progress_step_truckload_39 , t0 . is_autoanalysis_running AS is_autoanalysis_running_40 , t0 . is_autoanalysis_done AS is_autoanalysis_done_41 , t0 . bol_supplier AS bol_supplier_42 , t0 . customs_description AS customs_description_43 , t0 . customs_country_of_origin AS customs_country_of_origin_44 , t0 . customs_hs_code AS customs_hs_code_45 , t0 . cost_production AS cost_production_46 , t0 . next_cp_number AS next_cp_number_47 , t0 . is_auto_triage AS is_auto_triage_48 , t0 . is_lot_import_allowed AS is_lot_import_allowed_49 , t0 . has_premade_lots AS has_premade_lots_50 , t0 . is_auto_triage_truckload AS is_auto_triage_truckload_51 , t0 . auto_triage_category_name AS auto_triage_category_name_52 , t0 . auto_triage_category_discount AS auto_triage_category_discount_53 , t0 . archived_at AS archived_at_54 , t0 . is_final AS is_final_55 , t0 . final_total_manifest_items AS final_total_manifest_items_56 , t0 . final_total_analyzed_items AS final_total_analyzed_items_57 , t0 . final_total_different_items AS final_total_different_items_58 , t0 . final_total_triage_items AS final_total_triage_items_59 , t0 . final_import_unit_quantity AS final_import_unit_quantity_60 , t0 . final_total_hours AS final_total_hours_61 , t0 . final_total_scans_per_hour AS final_total_scans_per_hour_62 , t0 . final_msrp AS final_msrp_63 , t0 . final_estimated_sales_listing AS final_estimated_sales_listing_64 , t0 . final_selling_po AS final_selling_po_65 , t0 . final_cog_real AS final_cog_real_66 , t0 . final_nb_lots AS final_nb_lots_67 , t0 . is_new_mappings_required AS is_new_mappings_required_68 , t0 . auto_analysis_start_at AS auto_analysis_start_at_69 , t0 . auto_analysis_end_at AS auto_analysis_end_at_70 , t0 . current_synccentric_campaign AS current_synccentric_campaign_71 , t0 . analysis_queue_priority AS analysis_queue_priority_72 , t0 . is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73 , t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74 , t0 . synccentric_export_current_page AS synccentric_export_current_page_75 , t0 . synccentric_export_last_page AS synccentric_export_last_page_76 , t0 . is_synccentric_search_required AS is_synccentric_search_required_77 , t0 . is_synccentric_import_running AS is_synccentric_import_running_78 , t0 . is_synccentric_import_done AS is_synccentric_import_done_79 , t0 . is_synccentric_search_running AS is_synccentric_search_running_80 , t0 . is_synccentric_search_done AS is_synccentric_search_done_81 , t0 . is_synccentric_export_running AS is_synccentric_export_running_82 , t0 . is_synccentric_export_done AS is_synccentric_export_done_83 , t0 . is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84 , t0 . is_synccentric_import_started AS is_synccentric_import_started_85 , t0 . is_synccentric_export_started AS is_synccentric_export_started_86 , t0 . is_autoanalysis_started AS is_autoanalysis_started_87 , t0 . has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88 , t0 . has_batch_ids AS has_batch_ids_89 , t0 . status_id AS status_id_90 , t0 . supplier_id AS supplier_id_91 , t0 . product_condition_id AS product_condition_id_92 , t0 . manifest_style_id AS manifest_style_id_93 , t0 . invoice_style_id AS invoice_style_id_94 , t0 . supplier_invoice_state_id AS supplier_invoice_state_id_95 , t0 . warehouse_id AS warehouse_id_96 , t0 . auto_triage_category_id AS auto_triage_category_id_97 FROM po t0 WHERE t0 . id = '3242' ;
Copy
5
0.10 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 = 3242 ;
Copy
6
0.10 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 FROM manifest_style t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 FROM manifest_style t0 WHERE t0 . id = 2 ;
Copy
7
0.28 ms
SELECT t0 . id AS id_1 , t0 . session_number AS session_number_2 , t0 . code AS code_3 , t0 . scan_type AS scan_type_4 , t0 . is_confirmed AS is_confirmed_5 , t0 . is_generic AS is_generic_6 , t0 . is_validation AS is_validation_7 , t0 . is_category_validation AS is_category_validation_8 , t0 . is_action AS is_action_9 , t0 . is_question AS is_question_10 , t0 . has_error AS has_error_11 , t0 . is_deleted AS is_deleted_12 , t0 . confirm_request AS confirm_request_13 , t0 . is_error AS is_error_14 , t0 . result_template AS result_template_15 , t0 . msrp AS msrp_16 , t0 . has_cp AS has_cp_17 , t0 . cp_name AS cp_name_18 , t0 . cp_number AS cp_number_19 , t0 . cp_quantity AS cp_quantity_20 , t0 . is_confirmed_lot AS is_confirmed_lot_21 , t0 . is_confirmed_cp AS is_confirmed_cp_22 , t0 . is_rejected AS is_rejected_23 , t0 . cp_package AS cp_package_24 , t0 . show_oversize_button AS show_oversize_button_25 , t0 . batch_id_code AS batch_id_code_26 , t0 . user_id AS user_id_27 , t0 . po_id AS po_id_28 , t0 . manifest_item_id AS manifest_item_id_29 , t0 . lot_id AS lot_id_30 , t0 . action_id AS action_id_31 , t0 . triage_question_id AS triage_question_id_32 , t0 . lot_item_id AS lot_item_id_33 , t0 . scan_category_group_id AS scan_category_group_id_34 , t0 . oversize_lot_id AS oversize_lot_id_35 FROM triage_scan t0 WHERE t0 . id = ?
Parameters :
[
"6527014 "
]
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 . batch_id_code AS batch_id_code_26 , t0 . user_id AS user_id_27 , t0 . po_id AS po_id_28 , t0 . manifest_item_id AS manifest_item_id_29 , t0 . lot_id AS lot_id_30 , t0 . action_id AS action_id_31 , t0 . triage_question_id AS triage_question_id_32 , t0 . lot_item_id AS lot_item_id_33 , t0 . scan_category_group_id AS scan_category_group_id_34 , t0 . oversize_lot_id AS oversize_lot_id_35 FROM triage_scan t0 WHERE t0 . id = '6527014' ;
Copy
8
0.31 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 . number = ? AND t0 . is_closed = ? AND t0 . po_id = ? LIMIT 1
Parameters :
[
"896807 "
0
3242
]
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 . number = ?
AND t0 . is_closed = ?
AND t0 . po_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 . number = '896807' AND t0 . is_closed = 0 AND t0 . po_id = 3242 LIMIT 1 ;
Copy
9
0.28 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 = 6378120 ;
Copy
10
0.15 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
11
0.63 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . batch_id_code AS batch_id_code_8 , t0 . lot_id AS lot_id_9 , t0 . product_id AS product_id_10 , t0 . po_id AS po_id_11 , t0 . manifest_item_id AS manifest_item_id_12 , t0 . original_lot_id AS original_lot_id_13 , t0 . duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0 . lot_id = ? ORDER BY t0 . extended DESC
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . batch_id_code AS batch_id_code_8 , t0 . lot_id AS lot_id_9 , t0 . product_id AS product_id_10 , t0 . po_id AS po_id_11 , t0 . manifest_item_id AS manifest_item_id_12 , t0 . original_lot_id AS original_lot_id_13 , t0 . duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0 . lot_id = 56328 ORDER BY t0 . extended DESC ;
Copy
12
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 = 4605864 ;
Copy
13
0.24 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602263 ;
Copy
14
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 = 4602639 ;
Copy
15
0.71 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602617 ;
Copy
16
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 = 4604581 ;
Copy
17
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 = 4603314 ;
Copy
18
0.53 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602262 ;
Copy
19
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 = 4601047 ;
Copy
20
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 = 4601289 ;
Copy
21
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 = 4600791 ;
Copy
22
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 = 4604713 ;
Copy
23
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 = 4602289 ;
Copy
24
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 = 4604402 ;
Copy
25
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 = 4601296 ;
Copy
26
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 = 4604602 ;
Copy
27
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 = 4602837 ;
Copy
28
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 = 4604749 ;
Copy
29
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 = 4600879 ;
Copy
30
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 = 4604722 ;
Copy
31
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 = 4605131 ;
Copy
32
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 = 4602455 ;
Copy
33
0.15 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602845 ;
Copy
34
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 = 4603025 ;
Copy
35
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 = 4601078 ;
Copy
36
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 = 4601683 ;
Copy
37
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 = 4602341 ;
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 = 4605490 ;
Copy
39
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 = 4603323 ;
Copy
40
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 = 4602499 ;
Copy
41
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 = 4602357 ;
Copy
42
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 = 4602567 ;
Copy
43
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 = 4603390 ;
Copy
44
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 = 4600929 ;
Copy
45
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 = 4602483 ;
Copy
46
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 = 4603944 ;
Copy
47
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 = 4605050 ;
Copy
48
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 = 4605807 ;
Copy
49
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 = 4601036 ;
Copy
50
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 = 4600943 ;
Copy
51
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 = 4602484 ;
Copy
52
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 = 4605124 ;
Copy
53
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 = 4601743 ;
Copy
54
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 = 4605080 ;
Copy
55
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 = 4603928 ;
Copy
56
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 = 4600872 ;
Copy
57
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 = 4601125 ;
Copy
58
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 = 4602340 ;
Copy
59
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 = 4603490 ;
Copy
60
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 = 4602577 ;
Copy
61
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 = 4601104 ;
Copy
62
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 = 4604697 ;
Copy
63
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 = 4602346 ;
Copy
64
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 = 4603608 ;
Copy
65
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 = 4602138 ;
Copy
66
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 = 4602475 ;
Copy
67
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 = 4604764 ;
Copy
68
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 = 4605815 ;
Copy
69
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 = 4603348 ;
Copy
70
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 = 4604382 ;
Copy
71
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 = 4605130 ;
Copy
72
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 = 4602460 ;
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 = 4603618 ;
Copy
74
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 = 4600813 ;
Copy
75
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 = 4600922 ;
Copy
76
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 = 4600798 ;
Copy
77
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 = 4601839 ;
Copy
78
0.49 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4604734 ;
Copy
79
0.28 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4600941 ;
Copy
80
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 = 4604037 ;
Copy
81
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 = 4604015 ;
Copy
82
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 = 4604945 ;
Copy
83
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 = 4600991 ;
Copy
84
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 = 4604357 ;
Copy
85
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 = 4604560 ;
Copy
86
0.30 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602369 ;
Copy
87
0.35 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4603960 ;
Copy
88
0.31 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602356 ;
Copy
89
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 = 4600956 ;
Copy
90
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 = 4600810 ;
Copy
91
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 = 4602727 ;
Copy
92
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 = 4601836 ;
Copy
93
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 = 4605042 ;
Copy
94
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 = 4603665 ;
Copy
95
0.24 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602637 ;
Copy
96
0.39 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4604933 ;
Copy
97
0.25 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4604978 ;
Copy
98
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 = 4602471 ;
Copy
99
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 = 4604735 ;
Copy
100
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 = 4600993 ;
Copy
101
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 = 4601107 ;
Copy
102
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 = 4604329 ;
Copy
103
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 = 4603561 ;
Copy
104
0.25 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4601131 ;
Copy
105
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 = 4605830 ;
Copy
106
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 = 4603430 ;
Copy
107
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 = 4600948 ;
Copy
108
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 = 4605095 ;
Copy
109
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 = 4601138 ;
Copy
110
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 = 4602338 ;
Copy
111
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 = 4603685 ;
Copy
112
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 = 4603613 ;
Copy
113
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 = 4601133 ;
Copy
114
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 = 4602725 ;
Copy
115
0.30 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4605845 ;
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 = 4602344 ;
Copy
117
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 = 4603599 ;
Copy
118
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 = 4602510 ;
Copy
119
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 = 4603840 ;
Copy
120
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 = 4601030 ;
Copy
121
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 = 4601843 ;
Copy
122
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 = 4604746 ;
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 = 4605559 ;
Copy
124
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 = 4601037 ;
Copy
125
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 = 4604362 ;
Copy
126
0.28 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4602650 ;
Copy
127
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
128
0.13 ms
UPDATE manifest_style SET is_active = ? WHERE id = ?
UPDATE manifest_style SET is_active = 1 WHERE id = 2 ;
Copy
129
0.10 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 18663 ;
Copy
130
0.15 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 18664 ;
Copy
131
0.13 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 18665 ;
Copy
132
0.13 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 18666 ;
Copy
133
0.09 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 18667 ;
Copy
134
0.23 ms
UPDATE triage_scan SET is_confirmed = ? , lot_id = ? WHERE id = ?
Parameters :
[
1
null
6527014
]
UPDATE triage_scan SET is_confirmed = 1 , lot_id = NULL WHERE id = 6527014 ;
Copy
135
0.23 ms
UPDATE lot SET units = ? , estimated_sales = ? , msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
525
1438.28
7990.43
0
0
"2025-08-26 14:16:55 "
56328
]
UPDATE lot SET units = 525 , estimated_sales = 1438.28 , msrp_current = 7990.43 , is_high_value = 0 , is_cp = 0 , updated_at = '2025-08-26 14:16:55' WHERE id = 56328 ;
Copy
136
0.09 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
1717.4
4602263
]
UPDATE lot_item SET extended = 1717.4 WHERE id = 4602263 ;
Copy
137
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
539.82
4602639
]
UPDATE lot_item SET extended = 539.82 WHERE id = 4602639 ;
Copy
138
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
254.85
4602262
]
UPDATE lot_item SET extended = 254.85 WHERE id = 4602262 ;
Copy
139
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
162.6
4602289
]
UPDATE lot_item SET extended = 162.6 WHERE id = 4602289 ;
Copy
140
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
121.14
4602837
]
UPDATE lot_item SET extended = 121.14 WHERE id = 4602837 ;
Copy
141
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
116.82
4604749
]
UPDATE lot_item SET extended = 116.82 WHERE id = 4604749 ;
Copy
142
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
80.07
4601078
]
UPDATE lot_item SET extended = 80.07 WHERE id = 4601078 ;
Copy
143
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
35.16
4602484
]
UPDATE lot_item SET extended = 35.16 WHERE id = 4602484 ;
Copy
144
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
31.65
4603490
]
UPDATE lot_item SET extended = 31.65 WHERE id = 4603490 ;
Copy
145
0.08 ms
UPDATE lot_item SET quantity = ? , extended = ? WHERE id = ?
Parameters :
[
6
23.52
4605864
]
UPDATE lot_item SET quantity = 6 , extended = 23.52 WHERE id = 4605864 ;
Copy
146
1.16 ms
UPDATE lot_item_origin SET quantity = ? WHERE id = ?
Parameters :
[
6
5901847
]
UPDATE lot_item_origin SET quantity = 6 WHERE id = 5901847 ;
Copy
147
0.55 ms
"COMMIT"
148
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 = 1190077 ;
Copy
149
0.11 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 = 5 ;
Copy
150
0.21 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 = 121 AND t0 . is_closed = 0 ORDER BY t0 . id DESC LIMIT 1 ;
Copy
151
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
152
0.17 ms
UPDATE triage_scan SET confirm_request = ? , is_confirmed_lot = ? , lot_item_id = ? , scan_category_group_id = ? WHERE id = ?
Parameters :
[
null
1
4605864
2
6527014
]
UPDATE triage_scan SET confirm_request = NULL , is_confirmed_lot = 1 , lot_item_id = 4605864 , scan_category_group_id = 2 WHERE id = 6527014 ;
Copy
153
0.20 ms
UPDATE category SET is_updated = ? , is_active = ? WHERE id = ?
UPDATE category SET is_updated = 1 , is_active = 1 WHERE id = 5 ;
Copy
154
0.25 ms
UPDATE scan_session SET nb_scans = ? , updated_at = ? , nb_scans_per_minute = ? WHERE id = ?
Parameters :
[
35
"2025-08-26 14:16:55 "
7.0
350316
]
UPDATE scan_session SET nb_scans = 35 , updated_at = '2025-08-26 14:16:55' , nb_scans_per_minute = 7 WHERE id = 350316 ;
Copy
155
0.56 ms
"COMMIT"
156
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 . batch_id_code AS batch_id_code_26 , t0 . user_id AS user_id_27 , t0 . po_id AS po_id_28 , t0 . manifest_item_id AS manifest_item_id_29 , t0 . lot_id AS lot_id_30 , t0 . action_id AS action_id_31 , t0 . triage_question_id AS triage_question_id_32 , t0 . lot_item_id AS lot_item_id_33 , t0 . scan_category_group_id AS scan_category_group_id_34 , t0 . oversize_lot_id AS oversize_lot_id_35 FROM triage_scan t0 WHERE t0 . po_id = ? AND t0 . session_number = ? AND t0 . user_id = ? ORDER BY t0 . id DESC LIMIT 5
Parameters :
[
3242
"ts68adf8a6c3819 "
121
]
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 . batch_id_code AS batch_id_code_26 , t0 . user_id AS user_id_27 , t0 . po_id AS po_id_28 , t0 . manifest_item_id AS manifest_item_id_29 , t0 . lot_id AS lot_id_30 , t0 . action_id AS action_id_31 , t0 . triage_question_id AS triage_question_id_32 , t0 . lot_item_id AS lot_item_id_33 , t0 . scan_category_group_id AS scan_category_group_id_34 , t0 . oversize_lot_id AS oversize_lot_id_35 FROM triage_scan t0 WHERE t0 . po_id = 3242 AND t0 . session_number = 'ts68adf8a6c3819' AND t0 . user_id = 121 ORDER BY t0 . id DESC LIMIT 5 ;
Copy
157
0.21 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . has_actions AS has_actions_3 , t0 . has_validation AS has_validation_4 , t0 . has_high_value AS has_high_value_5 , t0 . is_active AS is_active_6 , t0 . has_scrapper AS has_scrapper_7 , t0 . sources_upc AS sources_upc_8 , t0 . sources_merchant_sku AS sources_merchant_sku_9 , t0 . sources_category AS sources_category_10 , t0 . sources_name AS sources_name_11 , t0 . sources_msrp AS sources_msrp_12 , t0 . sources_photo AS sources_photo_13 , t0 . sources_action AS sources_action_14 , t0 . is_required_upc AS is_required_upc_15 , t0 . is_required_merchant_sku AS is_required_merchant_sku_16 , t0 . is_required_category AS is_required_category_17 , t0 . is_required_name AS is_required_name_18 , t0 . is_required_msrp AS is_required_msrp_19 , t0 . is_required_photo AS is_required_photo_20 , t0 . is_required_action AS is_required_action_21 , t0 . public_name AS public_name_22 , t0 . is_deleted AS is_deleted_23 , t0 . product_generic_link AS product_generic_link_24 , t0 . billing_name AS billing_name_25 , t0 . billing_address AS billing_address_26 , t0 . tax_name1 AS tax_name1_27 , t0 . tax_rate1 AS tax_rate1_28 , t0 . tax_name2 AS tax_name2_29 , t0 . tax_rate2 AS tax_rate2_30 , t0 . tax_number1 AS tax_number1_31 , t0 . tax_number2 AS tax_number2_32 , t0 . tax_currency AS tax_currency_33 , t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 , t0 . has_continuous_po AS has_continuous_po_35 , t0 . newsletter_default_subject AS newsletter_default_subject_36 , t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 , t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 , t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 , t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 , t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 , t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 , t0 . scraper_class AS scraper_class_43 , t0 . has_splited_scraper AS has_splited_scraper_44 , t0 . has_synccentric_data AS has_synccentric_data_45 , t0 . has_upcitemdb_data AS has_upcitemdb_data_46 , t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 , t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 , t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 , t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 , t0 . user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . has_actions AS has_actions_3 ,
t0 . has_validation AS has_validation_4 ,
t0 . has_high_value AS has_high_value_5 ,
t0 . is_active AS is_active_6 ,
t0 . has_scrapper AS has_scrapper_7 ,
t0 . sources_upc AS sources_upc_8 ,
t0 . sources_merchant_sku AS sources_merchant_sku_9 ,
t0 . sources_category AS sources_category_10 ,
t0 . sources_name AS sources_name_11 ,
t0 . sources_msrp AS sources_msrp_12 ,
t0 . sources_photo AS sources_photo_13 ,
t0 . sources_action AS sources_action_14 ,
t0 . is_required_upc AS is_required_upc_15 ,
t0 . is_required_merchant_sku AS is_required_merchant_sku_16 ,
t0 . is_required_category AS is_required_category_17 ,
t0 . is_required_name AS is_required_name_18 ,
t0 . is_required_msrp AS is_required_msrp_19 ,
t0 . is_required_photo AS is_required_photo_20 ,
t0 . is_required_action AS is_required_action_21 ,
t0 . public_name AS public_name_22 ,
t0 . is_deleted AS is_deleted_23 ,
t0 . product_generic_link AS product_generic_link_24 ,
t0 . billing_name AS billing_name_25 ,
t0 . billing_address AS billing_address_26 ,
t0 . tax_name1 AS tax_name1_27 ,
t0 . tax_rate1 AS tax_rate1_28 ,
t0 . tax_name2 AS tax_name2_29 ,
t0 . tax_rate2 AS tax_rate2_30 ,
t0 . tax_number1 AS tax_number1_31 ,
t0 . tax_number2 AS tax_number2_32 ,
t0 . tax_currency AS tax_currency_33 ,
t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 ,
t0 . has_continuous_po AS has_continuous_po_35 ,
t0 . newsletter_default_subject AS newsletter_default_subject_36 ,
t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 ,
t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 ,
t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 ,
t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 ,
t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 ,
t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 ,
t0 . scraper_class AS scraper_class_43 ,
t0 . has_splited_scraper AS has_splited_scraper_44 ,
t0 . has_synccentric_data AS has_synccentric_data_45 ,
t0 . has_upcitemdb_data AS has_upcitemdb_data_46 ,
t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 ,
t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 ,
t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 ,
t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 ,
t0 . user_group_id AS user_group_id_51
FROM
supplier t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . has_actions AS has_actions_3 , t0 . has_validation AS has_validation_4 , t0 . has_high_value AS has_high_value_5 , t0 . is_active AS is_active_6 , t0 . has_scrapper AS has_scrapper_7 , t0 . sources_upc AS sources_upc_8 , t0 . sources_merchant_sku AS sources_merchant_sku_9 , t0 . sources_category AS sources_category_10 , t0 . sources_name AS sources_name_11 , t0 . sources_msrp AS sources_msrp_12 , t0 . sources_photo AS sources_photo_13 , t0 . sources_action AS sources_action_14 , t0 . is_required_upc AS is_required_upc_15 , t0 . is_required_merchant_sku AS is_required_merchant_sku_16 , t0 . is_required_category AS is_required_category_17 , t0 . is_required_name AS is_required_name_18 , t0 . is_required_msrp AS is_required_msrp_19 , t0 . is_required_photo AS is_required_photo_20 , t0 . is_required_action AS is_required_action_21 , t0 . public_name AS public_name_22 , t0 . is_deleted AS is_deleted_23 , t0 . product_generic_link AS product_generic_link_24 , t0 . billing_name AS billing_name_25 , t0 . billing_address AS billing_address_26 , t0 . tax_name1 AS tax_name1_27 , t0 . tax_rate1 AS tax_rate1_28 , t0 . tax_name2 AS tax_name2_29 , t0 . tax_rate2 AS tax_rate2_30 , t0 . tax_number1 AS tax_number1_31 , t0 . tax_number2 AS tax_number2_32 , t0 . tax_currency AS tax_currency_33 , t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 , t0 . has_continuous_po AS has_continuous_po_35 , t0 . newsletter_default_subject AS newsletter_default_subject_36 , t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 , t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 , t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 , t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 , t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 , t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 , t0 . scraper_class AS scraper_class_43 , t0 . has_splited_scraper AS has_splited_scraper_44 , t0 . has_synccentric_data AS has_synccentric_data_45 , t0 . has_upcitemdb_data AS has_upcitemdb_data_46 , t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 , t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 , t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 , t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 , t0 . user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0 . id = 55 ;
Copy
158
0.10 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
159
0.33 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 = 6378108 ;
Copy
160
0.30 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 = 6378111 ;
Copy
161
0.30 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 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . number AS number_2 ,
t0 . package_units AS package_units_3 ,
t0 . weight AS weight_4 ,
t0 . user AS user_5 ,
t0 . format AS format_6 ,
t0 . photos AS photos_7 ,
t0 . name AS name_8 ,
t0 . extended AS extended_9 ,
t0 . units AS units_10 ,
t0 . discount AS discount_11 ,
t0 . estimated_sales AS estimated_sales_12 ,
t0 . is_initialized AS is_initialized_13 ,
t0 . msrp_current AS msrp_current_14 ,
t0 . is_closed AS is_closed_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_cp AS is_cp_17 ,
t0 . estimated_sales_min_target AS estimated_sales_min_target_18 ,
t0 . estimated_sales_max_target AS estimated_sales_max_target_19 ,
t0 . display_name AS display_name_20 ,
t0 . quantity AS quantity_21 ,
t0 . cp_quantity AS cp_quantity_22 ,
t0 . is_truckload AS is_truckload_23 ,
t0 . is_photos_compressed AS is_photos_compressed_24 ,
t0 . is_destroy AS is_destroy_25 ,
t0 . package_sizes AS package_sizes_26 ,
t0 . is_listing_done AS is_listing_done_27 ,
t0 . discount_triage AS discount_triage_28 ,
t0 . volumetric_weight AS volumetric_weight_29 ,
t0 . real_weight AS real_weight_30 ,
t0 . previous_number AS previous_number_31 ,
t0 . 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 . id = ?
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 . id = 56386 ;
Copy
162
0.18 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . batch_id_code AS batch_id_code_8 , t0 . lot_id AS lot_id_9 , t0 . product_id AS product_id_10 , t0 . po_id AS po_id_11 , t0 . manifest_item_id AS manifest_item_id_12 , t0 . original_lot_id AS original_lot_id_13 , t0 . duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . batch_id_code AS batch_id_code_8 , t0 . lot_id AS lot_id_9 , t0 . product_id AS product_id_10 , t0 . po_id AS po_id_11 , t0 . manifest_item_id AS manifest_item_id_12 , t0 . original_lot_id AS original_lot_id_13 , t0 . duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0 . id = 4605868 ;
Copy
163
0.38 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 = 6378114 ;
Copy
164
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 = 1181842 ;
Copy
165
0.19 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . batch_id_code AS batch_id_code_8 , t0 . lot_id AS lot_id_9 , t0 . product_id AS product_id_10 , t0 . po_id AS po_id_11 , t0 . manifest_item_id AS manifest_item_id_12 , t0 . original_lot_id AS original_lot_id_13 , t0 . duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . batch_id_code AS batch_id_code_8 , t0 . lot_id AS lot_id_9 , t0 . product_id AS product_id_10 , t0 . po_id AS po_id_11 , t0 . manifest_item_id AS manifest_item_id_12 , t0 . original_lot_id AS original_lot_id_13 , t0 . duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0 . id = 4605872 ;
Copy
166
0.41 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 = 6378117 ;
Copy
167
0.14 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 = 1181812 ;
Copy