1
0.47 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 = 95 ;
Copy
2
0.11 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . exchange_rate AS exchange_rate_3 , t0 . position AS position_4 , t0 . is_msrp_source AS is_msrp_source_5 , t0 . is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0 . is_msrp_source = ? ORDER BY t0 . position ASC
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . exchange_rate AS exchange_rate_3 , t0 . position AS position_4 , t0 . is_msrp_source AS is_msrp_source_5 , t0 . is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0 . is_msrp_source = 1 ORDER BY t0 . position ASC ;
Copy
3
0.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.16 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 . status_id AS status_id_88 , t0 . supplier_id AS supplier_id_89 , t0 . product_condition_id AS product_condition_id_90 , t0 . manifest_style_id AS manifest_style_id_91 , t0 . invoice_style_id AS invoice_style_id_92 , t0 . supplier_invoice_state_id AS supplier_invoice_state_id_93 , t0 . warehouse_id AS warehouse_id_94 , t0 . auto_triage_category_id AS auto_triage_category_id_95 FROM po t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . number AS number_2 ,
t0 . active AS active_3 ,
t0 . nb_pallet AS nb_pallet_4 ,
t0 . nb_unit AS nb_unit_5 ,
t0 . eta AS eta_6 ,
t0 . received_at AS received_at_7 ,
t0 . manifest_import AS manifest_import_8 ,
t0 . note AS note_9 ,
t0 . cost_po AS cost_po_10 ,
t0 . cost_transport AS cost_transport_11 ,
t0 . cost_customs AS cost_customs_12 ,
t0 . msrp_value AS msrp_value_13 ,
t0 . finances_selling_estimated AS finances_selling_estimated_14 ,
t0 . seal_number_provided AS seal_number_provided_15 ,
t0 . seal_number_received AS seal_number_received_16 ,
t0 . nb_unit_received AS nb_unit_received_17 ,
t0 . nb_pallet_received AS nb_pallet_received_18 ,
t0 . seal_number_na AS seal_number_na_19 ,
t0 . note_reception AS note_reception_20 ,
t0 . location AS location_21 ,
t0 . progress_step_reception AS progress_step_reception_22 ,
t0 . progress_step_scan_manifest AS progress_step_scan_manifest_23 ,
t0 . progress_step_import_manifest AS progress_step_import_manifest_24 ,
t0 . progress_step_analysis AS progress_step_analysis_25 ,
t0 . progress_step_preparation AS progress_step_preparation_26 ,
t0 . progress_step_triage AS progress_step_triage_27 ,
t0 . progress_step_photobooth AS progress_step_photobooth_28 ,
t0 . progress_step_listing AS progress_step_listing_29 ,
t0 . progress_step_conciliation AS progress_step_conciliation_30 ,
t0 . preparation_total_units AS preparation_total_units_31 ,
t0 . preparation_total_extended AS preparation_total_extended_32 ,
t0 . preparation_total_selling_extended AS preparation_total_selling_extended_33 ,
t0 . preparation_total_cps AS preparation_total_cps_34 ,
t0 . preparation_total_lots AS preparation_total_lots_35 ,
t0 . import_product_quantity AS import_product_quantity_36 ,
t0 . import_unit_quantity AS import_unit_quantity_37 ,
t0 . is_truckload AS is_truckload_38 ,
t0 . progress_step_truckload AS progress_step_truckload_39 ,
t0 . is_autoanalysis_running AS is_autoanalysis_running_40 ,
t0 . is_autoanalysis_done AS is_autoanalysis_done_41 ,
t0 . bol_supplier AS bol_supplier_42 ,
t0 . customs_description AS customs_description_43 ,
t0 . customs_country_of_origin AS customs_country_of_origin_44 ,
t0 . customs_hs_code AS customs_hs_code_45 ,
t0 . cost_production AS cost_production_46 ,
t0 . next_cp_number AS next_cp_number_47 ,
t0 . is_auto_triage AS is_auto_triage_48 ,
t0 . is_lot_import_allowed AS is_lot_import_allowed_49 ,
t0 . has_premade_lots AS has_premade_lots_50 ,
t0 . is_auto_triage_truckload AS is_auto_triage_truckload_51 ,
t0 . auto_triage_category_name AS auto_triage_category_name_52 ,
t0 . auto_triage_category_discount AS auto_triage_category_discount_53 ,
t0 . archived_at AS archived_at_54 ,
t0 . is_final AS is_final_55 ,
t0 . final_total_manifest_items AS final_total_manifest_items_56 ,
t0 . final_total_analyzed_items AS final_total_analyzed_items_57 ,
t0 . final_total_different_items AS final_total_different_items_58 ,
t0 . final_total_triage_items AS final_total_triage_items_59 ,
t0 . final_import_unit_quantity AS final_import_unit_quantity_60 ,
t0 . final_total_hours AS final_total_hours_61 ,
t0 . final_total_scans_per_hour AS final_total_scans_per_hour_62 ,
t0 . final_msrp AS final_msrp_63 ,
t0 . final_estimated_sales_listing AS final_estimated_sales_listing_64 ,
t0 . final_selling_po AS final_selling_po_65 ,
t0 . final_cog_real AS final_cog_real_66 ,
t0 . final_nb_lots AS final_nb_lots_67 ,
t0 . is_new_mappings_required AS is_new_mappings_required_68 ,
t0 . auto_analysis_start_at AS auto_analysis_start_at_69 ,
t0 . auto_analysis_end_at AS auto_analysis_end_at_70 ,
t0 . current_synccentric_campaign AS current_synccentric_campaign_71 ,
t0 . analysis_queue_priority AS analysis_queue_priority_72 ,
t0 . is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74 ,
t0 . synccentric_export_current_page AS synccentric_export_current_page_75 ,
t0 . synccentric_export_last_page AS synccentric_export_last_page_76 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_77 ,
t0 . is_synccentric_import_running AS is_synccentric_import_running_78 ,
t0 . is_synccentric_import_done AS is_synccentric_import_done_79 ,
t0 . is_synccentric_search_running AS is_synccentric_search_running_80 ,
t0 . is_synccentric_search_done AS is_synccentric_search_done_81 ,
t0 . is_synccentric_export_running AS is_synccentric_export_running_82 ,
t0 . is_synccentric_export_done AS is_synccentric_export_done_83 ,
t0 . is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84 ,
t0 . is_synccentric_import_started AS is_synccentric_import_started_85 ,
t0 . is_synccentric_export_started AS is_synccentric_export_started_86 ,
t0 . is_autoanalysis_started AS is_autoanalysis_started_87 ,
t0 . status_id AS status_id_88 ,
t0 . supplier_id AS supplier_id_89 ,
t0 . product_condition_id AS product_condition_id_90 ,
t0 . manifest_style_id AS manifest_style_id_91 ,
t0 . invoice_style_id AS invoice_style_id_92 ,
t0 . supplier_invoice_state_id AS supplier_invoice_state_id_93 ,
t0 . warehouse_id AS warehouse_id_94 ,
t0 . auto_triage_category_id AS auto_triage_category_id_95
FROM
po t0
WHERE
t0 . id = ?
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 . status_id AS status_id_88 , t0 . supplier_id AS supplier_id_89 , t0 . product_condition_id AS product_condition_id_90 , t0 . manifest_style_id AS manifest_style_id_91 , t0 . invoice_style_id AS invoice_style_id_92 , t0 . supplier_invoice_state_id AS supplier_invoice_state_id_93 , t0 . warehouse_id AS warehouse_id_94 , t0 . auto_triage_category_id AS auto_triage_category_id_95 FROM po t0 WHERE t0 . id = '2569' ;
Copy
5
0.07 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 = 2569 ;
Copy
6
0.06 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 FROM manifest_style t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 FROM manifest_style t0 WHERE t0 . id = 4 ;
Copy
7
0.24 ms
SELECT t0 . id AS id_1 , t0 . session_number AS session_number_2 , t0 . code AS code_3 , t0 . scan_type AS scan_type_4 , t0 . is_confirmed AS is_confirmed_5 , t0 . is_generic AS is_generic_6 , t0 . is_validation AS is_validation_7 , t0 . is_category_validation AS is_category_validation_8 , t0 . is_action AS is_action_9 , t0 . is_question AS is_question_10 , t0 . has_error AS has_error_11 , t0 . is_deleted AS is_deleted_12 , t0 . confirm_request AS confirm_request_13 , t0 . is_error AS is_error_14 , t0 . result_template AS result_template_15 , t0 . msrp AS msrp_16 , t0 . has_cp AS has_cp_17 , t0 . cp_name AS cp_name_18 , t0 . cp_number AS cp_number_19 , t0 . cp_quantity AS cp_quantity_20 , t0 . is_confirmed_lot AS is_confirmed_lot_21 , t0 . is_confirmed_cp AS is_confirmed_cp_22 , t0 . is_rejected AS is_rejected_23 , t0 . cp_package AS cp_package_24 , t0 . show_oversize_button AS show_oversize_button_25 , t0 . user_id AS user_id_26 , t0 . po_id AS po_id_27 , t0 . manifest_item_id AS manifest_item_id_28 , t0 . lot_id AS lot_id_29 , t0 . action_id AS action_id_30 , t0 . triage_question_id AS triage_question_id_31 , t0 . lot_item_id AS lot_item_id_32 , t0 . scan_category_group_id AS scan_category_group_id_33 , t0 . oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0 . id = ?
Parameters :
[
"5050044 "
]
SELECT t0 . id AS id_1 , t0 . session_number AS session_number_2 , t0 . code AS code_3 , t0 . scan_type AS scan_type_4 , t0 . is_confirmed AS is_confirmed_5 , t0 . is_generic AS is_generic_6 , t0 . is_validation AS is_validation_7 , t0 . is_category_validation AS is_category_validation_8 , t0 . is_action AS is_action_9 , t0 . is_question AS is_question_10 , t0 . has_error AS has_error_11 , t0 . is_deleted AS is_deleted_12 , t0 . confirm_request AS confirm_request_13 , t0 . is_error AS is_error_14 , t0 . result_template AS result_template_15 , t0 . msrp AS msrp_16 , t0 . has_cp AS has_cp_17 , t0 . cp_name AS cp_name_18 , t0 . cp_number AS cp_number_19 , t0 . cp_quantity AS cp_quantity_20 , t0 . is_confirmed_lot AS is_confirmed_lot_21 , t0 . is_confirmed_cp AS is_confirmed_cp_22 , t0 . is_rejected AS is_rejected_23 , t0 . cp_package AS cp_package_24 , t0 . show_oversize_button AS show_oversize_button_25 , t0 . user_id AS user_id_26 , t0 . po_id AS po_id_27 , t0 . manifest_item_id AS manifest_item_id_28 , t0 . lot_id AS lot_id_29 , t0 . action_id AS action_id_30 , t0 . triage_question_id AS triage_question_id_31 , t0 . lot_item_id AS lot_item_id_32 , t0 . scan_category_group_id AS scan_category_group_id_33 , t0 . oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0 . id = '5050044' ;
Copy
8
0.29 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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . created_at AS created_at_45 ,
t0 . updated_at AS updated_at_46 ,
t0 . po_id AS po_id_47 ,
t0 . product_id AS product_id_48 ,
t0 . scanned_by_id AS scanned_by_id_49 ,
t0 . imported_by_id AS imported_by_id_50 ,
t0 . analyzed_by_id AS analyzed_by_id_51 ,
t0 . supplier_id AS supplier_id_52 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_53 ,
t0 . restock_category_id AS restock_category_id_54 ,
t0 . preparation_lot_id AS preparation_lot_id_55 ,
t0 . triage_category_id AS triage_category_id_56
FROM
manifest_item t0
WHERE
t0 . id = ?
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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = 4807185 ;
Copy
9
2.32 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 . created_at AS created_at_35 , t0 . updated_at AS updated_at_36 , t0 . po_id AS po_id_37 , t0 . category_id AS category_id_38 , t0 . cp_product_id AS cp_product_id_39 , t0 . product_condition_id AS product_condition_id_40 , t0 . merged_with_id AS merged_with_id_41 , t0 . preparation_lot_id AS preparation_lot_id_42 , t0 . previous_po_id AS previous_po_id_43 , t0 . related_front_product_id AS related_front_product_id_44 FROM lot t0 WHERE t0 . number = ? AND t0 . is_closed = ? AND t0 . po_id = ? LIMIT 1
Parameters :
[
"829832 "
0
2569
]
SELECT
t0 . id AS id_1 ,
t0 . number AS number_2 ,
t0 . package_units AS package_units_3 ,
t0 . weight AS weight_4 ,
t0 . user AS user_5 ,
t0 . format AS format_6 ,
t0 . photos AS photos_7 ,
t0 . name AS name_8 ,
t0 . extended AS extended_9 ,
t0 . units AS units_10 ,
t0 . discount AS discount_11 ,
t0 . estimated_sales AS estimated_sales_12 ,
t0 . is_initialized AS is_initialized_13 ,
t0 . msrp_current AS msrp_current_14 ,
t0 . is_closed AS is_closed_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_cp AS is_cp_17 ,
t0 . estimated_sales_min_target AS estimated_sales_min_target_18 ,
t0 . estimated_sales_max_target AS estimated_sales_max_target_19 ,
t0 . display_name AS display_name_20 ,
t0 . quantity AS quantity_21 ,
t0 . cp_quantity AS cp_quantity_22 ,
t0 . is_truckload AS is_truckload_23 ,
t0 . is_photos_compressed AS is_photos_compressed_24 ,
t0 . is_destroy AS is_destroy_25 ,
t0 . package_sizes AS package_sizes_26 ,
t0 . is_listing_done AS is_listing_done_27 ,
t0 . discount_triage AS discount_triage_28 ,
t0 . volumetric_weight AS volumetric_weight_29 ,
t0 . real_weight AS real_weight_30 ,
t0 . previous_number AS previous_number_31 ,
t0 . is_oversize AS is_oversize_32 ,
t0 . cost AS cost_33 ,
t0 . is_imported AS is_imported_34 ,
t0 . created_at AS created_at_35 ,
t0 . updated_at AS updated_at_36 ,
t0 . po_id AS po_id_37 ,
t0 . category_id AS category_id_38 ,
t0 . cp_product_id AS cp_product_id_39 ,
t0 . product_condition_id AS product_condition_id_40 ,
t0 . merged_with_id AS merged_with_id_41 ,
t0 . preparation_lot_id AS preparation_lot_id_42 ,
t0 . previous_po_id AS previous_po_id_43 ,
t0 . related_front_product_id AS related_front_product_id_44
FROM
lot t0
WHERE
t0 . number = ?
AND t0 . is_closed = ?
AND t0 . po_id = ?
LIMIT
1
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 . created_at AS created_at_35 , t0 . updated_at AS updated_at_36 , t0 . po_id AS po_id_37 , t0 . category_id AS category_id_38 , t0 . cp_product_id AS cp_product_id_39 , t0 . product_condition_id AS product_condition_id_40 , t0 . merged_with_id AS merged_with_id_41 , t0 . preparation_lot_id AS preparation_lot_id_42 , t0 . previous_po_id AS previous_po_id_43 , t0 . related_front_product_id AS related_front_product_id_44 FROM lot t0 WHERE t0 . number = '829832' AND t0 . is_closed = 0 AND t0 . po_id = 2569 LIMIT 1 ;
Copy
10
0.11 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.64 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . lot_id AS lot_id_8 , t0 . product_id AS product_id_9 , t0 . po_id AS po_id_10 , t0 . manifest_item_id AS manifest_item_id_11 , t0 . original_lot_id AS original_lot_id_12 , t0 . duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0 . lot_id = ? ORDER BY t0 . extended DESC
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . msrp AS msrp_3 , t0 . quantity AS quantity_4 , t0 . extended AS extended_5 , t0 . is_truckload AS is_truckload_6 , t0 . is_converted AS is_converted_7 , t0 . lot_id AS lot_id_8 , t0 . product_id AS product_id_9 , t0 . po_id AS po_id_10 , t0 . manifest_item_id AS manifest_item_id_11 , t0 . original_lot_id AS original_lot_id_12 , t0 . duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0 . lot_id = 48067 ORDER BY t0 . extended DESC ;
Copy
12
0.22 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062076 ;
Copy
13
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 = 3970551 ;
Copy
14
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 = 3967919 ;
Copy
15
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 = 3967999 ;
Copy
16
0.26 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3967886 ;
Copy
17
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 = 3969038 ;
Copy
18
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 = 3968107 ;
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 = 3967944 ;
Copy
20
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 = 3968123 ;
Copy
21
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 = 3968052 ;
Copy
22
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 = 3968989 ;
Copy
23
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 = 3968103 ;
Copy
24
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 = 3968328 ;
Copy
25
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 = 4062071 ;
Copy
26
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 = 3968010 ;
Copy
27
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 = 3968032 ;
Copy
28
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 = 3968024 ;
Copy
29
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 = 3969167 ;
Copy
30
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 = 3968135 ;
Copy
31
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 = 3968172 ;
Copy
32
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 = 3967991 ;
Copy
33
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 = 3968122 ;
Copy
34
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 = 3967994 ;
Copy
35
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 = 3968027 ;
Copy
36
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 = 3967968 ;
Copy
37
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 = 3969130 ;
Copy
38
0.10 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968157 ;
Copy
39
0.12 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968085 ;
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 = 3968021 ;
Copy
41
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 = 3969311 ;
Copy
42
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 = 3968117 ;
Copy
43
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968162 ;
Copy
44
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 = 3967953 ;
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 = 3968017 ;
Copy
46
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 = 3967964 ;
Copy
47
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968035 ;
Copy
48
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 = 3969082 ;
Copy
49
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 = 3968155 ;
Copy
50
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3967993 ;
Copy
51
0.57 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968022 ;
Copy
52
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 = 4062070 ;
Copy
53
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 = 3968264 ;
Copy
54
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 = 3969258 ;
Copy
55
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968099 ;
Copy
56
0.09 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3970628 ;
Copy
57
0.37 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968289 ;
Copy
58
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 = 3967967 ;
Copy
59
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 = 3967949 ;
Copy
60
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 = 3967936 ;
Copy
61
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 = 3969309 ;
Copy
62
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 = 3968012 ;
Copy
63
0.23 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3967952 ;
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 = 3969009 ;
Copy
65
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 = 3969047 ;
Copy
66
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 = 3969163 ;
Copy
67
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 = 3969235 ;
Copy
68
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 = 3968134 ;
Copy
69
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 = 3968295 ;
Copy
70
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 = 3968982 ;
Copy
71
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 = 3968166 ;
Copy
72
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 = 3968184 ;
Copy
73
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 = 3968031 ;
Copy
74
0.17 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3969055 ;
Copy
75
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 = 3969230 ;
Copy
76
0.12 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3967971 ;
Copy
77
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 = 3968302 ;
Copy
78
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 = 3967970 ;
Copy
79
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968029 ;
Copy
80
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 = 3968030 ;
Copy
81
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 = 3969308 ;
Copy
82
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3969095 ;
Copy
83
0.12 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3969006 ;
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 = 3968308 ;
Copy
85
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3969271 ;
Copy
86
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968145 ;
Copy
87
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 = 3969315 ;
Copy
88
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 = 3968324 ;
Copy
89
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 = 3968178 ;
Copy
90
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968154 ;
Copy
91
0.23 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968023 ;
Copy
92
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 = 3968279 ;
Copy
93
0.11 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 3968168 ;
Copy
94
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 = 3967892 ;
Copy
95
0.05 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
96
0.13 ms
UPDATE manifest_style SET is_active = ? WHERE id = ?
UPDATE manifest_style SET is_active = 1 WHERE id = 4 ;
Copy
97
0.10 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 15925 ;
Copy
98
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 15926 ;
Copy
99
0.26 ms
UPDATE triage_scan SET is_confirmed = ? WHERE id = ?
Parameters :
[
1
5050044
]
UPDATE triage_scan SET is_confirmed = 1 WHERE id = 5050044 ;
Copy
100
0.35 ms
UPDATE lot SET units = ? , estimated_sales = ? , msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
864
2031.33
11285.19
0
0
"2024-12-23 14:37:01 "
48067
]
UPDATE lot SET units = 864 , estimated_sales = 2031.33 , msrp_current = 11285.19 , is_high_value = 0 , is_cp = 0 , updated_at = '2024-12-23 14:37:01' WHERE id = 48067 ;
Copy
101
0.09 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
2998.8
3970551
]
UPDATE lot_item SET extended = 2998.8 WHERE id = 3970551 ;
Copy
102
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
509.8
3968107
]
UPDATE lot_item SET extended = 509.8 WHERE id = 3968107 ;
Copy
103
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
375.6
3968123
]
UPDATE lot_item SET extended = 375.6 WHERE id = 3968123 ;
Copy
104
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
199.43
3968103
]
UPDATE lot_item SET extended = 199.43 WHERE id = 3968103 ;
Copy
105
0.08 ms
UPDATE lot_item SET quantity = ? , extended = ? WHERE id = ?
Parameters :
[
9
215.73
4062076
]
UPDATE lot_item SET quantity = 9 , extended = 215.73 WHERE id = 4062076 ;
Copy
106
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
76.65
3968172
]
UPDATE lot_item SET extended = 76.65 WHERE id = 3968172 ;
Copy
107
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
29.88
3968035
]
UPDATE lot_item SET extended = 29.88 WHERE id = 3968035 ;
Copy
108
0.07 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
14.88
3967952
]
UPDATE lot_item SET extended = 14.88 WHERE id = 3967952 ;
Copy
109
0.85 ms
UPDATE lot_item_origin SET quantity = ? WHERE id = ?
Parameters :
[
9
5077849
]
UPDATE lot_item_origin SET quantity = 9 WHERE id = 5077849 ;
Copy
110
0.80 ms
"COMMIT"
111
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 = 132 ;
Copy
112
1.27 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 = 95 AND t0 . is_closed = 0 ORDER BY t0 . id DESC LIMIT 1 ;
Copy
113
0.08 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
114
0.29 ms
UPDATE triage_scan SET confirm_request = ? , is_confirmed_lot = ? , lot_item_id = ? , scan_category_group_id = ? WHERE id = ?
Parameters :
[
null
1
4062076
7
5050044
]
UPDATE triage_scan SET confirm_request = NULL , is_confirmed_lot = 1 , lot_item_id = 4062076 , scan_category_group_id = 7 WHERE id = 5050044 ;
Copy
115
0.19 ms
UPDATE category SET is_updated = ? , is_active = ? WHERE id = ?
UPDATE category SET is_updated = 0 , is_active = 1 WHERE id = 132 ;
Copy
116
0.22 ms
UPDATE scan_session SET nb_scans = ? , updated_at = ? , nb_scans_per_minute = ? WHERE id = ?
Parameters :
[
14
"2024-12-23 14:37:01 "
7.0
315529
]
UPDATE scan_session SET nb_scans = 14 , updated_at = '2024-12-23 14:37:01' , nb_scans_per_minute = 7 WHERE id = 315529 ;
Copy
117
0.51 ms
"COMMIT"
118
0.40 ms
SELECT t0 . id AS id_1 , t0 . session_number AS session_number_2 , t0 . code AS code_3 , t0 . scan_type AS scan_type_4 , t0 . is_confirmed AS is_confirmed_5 , t0 . is_generic AS is_generic_6 , t0 . is_validation AS is_validation_7 , t0 . is_category_validation AS is_category_validation_8 , t0 . is_action AS is_action_9 , t0 . is_question AS is_question_10 , t0 . has_error AS has_error_11 , t0 . is_deleted AS is_deleted_12 , t0 . confirm_request AS confirm_request_13 , t0 . is_error AS is_error_14 , t0 . result_template AS result_template_15 , t0 . msrp AS msrp_16 , t0 . has_cp AS has_cp_17 , t0 . cp_name AS cp_name_18 , t0 . cp_number AS cp_number_19 , t0 . cp_quantity AS cp_quantity_20 , t0 . is_confirmed_lot AS is_confirmed_lot_21 , t0 . is_confirmed_cp AS is_confirmed_cp_22 , t0 . is_rejected AS is_rejected_23 , t0 . cp_package AS cp_package_24 , t0 . show_oversize_button AS show_oversize_button_25 , t0 . user_id AS user_id_26 , t0 . po_id AS po_id_27 , t0 . manifest_item_id AS manifest_item_id_28 , t0 . lot_id AS lot_id_29 , t0 . action_id AS action_id_30 , t0 . triage_question_id AS triage_question_id_31 , t0 . lot_item_id AS lot_item_id_32 , t0 . scan_category_group_id AS scan_category_group_id_33 , t0 . oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0 . po_id = ? AND t0 . session_number = ? AND t0 . user_id = ? ORDER BY t0 . id DESC LIMIT 5
Parameters :
[
2569
"ts6769bb055e973 "
95
]
SELECT t0 . id AS id_1 , t0 . session_number AS session_number_2 , t0 . code AS code_3 , t0 . scan_type AS scan_type_4 , t0 . is_confirmed AS is_confirmed_5 , t0 . is_generic AS is_generic_6 , t0 . is_validation AS is_validation_7 , t0 . is_category_validation AS is_category_validation_8 , t0 . is_action AS is_action_9 , t0 . is_question AS is_question_10 , t0 . has_error AS has_error_11 , t0 . is_deleted AS is_deleted_12 , t0 . confirm_request AS confirm_request_13 , t0 . is_error AS is_error_14 , t0 . result_template AS result_template_15 , t0 . msrp AS msrp_16 , t0 . has_cp AS has_cp_17 , t0 . cp_name AS cp_name_18 , t0 . cp_number AS cp_number_19 , t0 . cp_quantity AS cp_quantity_20 , t0 . is_confirmed_lot AS is_confirmed_lot_21 , t0 . is_confirmed_cp AS is_confirmed_cp_22 , t0 . is_rejected AS is_rejected_23 , t0 . cp_package AS cp_package_24 , t0 . show_oversize_button AS show_oversize_button_25 , t0 . user_id AS user_id_26 , t0 . po_id AS po_id_27 , t0 . manifest_item_id AS manifest_item_id_28 , t0 . lot_id AS lot_id_29 , t0 . action_id AS action_id_30 , t0 . triage_question_id AS triage_question_id_31 , t0 . lot_item_id AS lot_item_id_32 , t0 . scan_category_group_id AS scan_category_group_id_33 , t0 . oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0 . po_id = 2569 AND t0 . session_number = 'ts6769bb055e973' AND t0 . user_id = 95 ORDER BY t0 . id DESC LIMIT 5 ;
Copy
119
0.15 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
120
0.07 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 , t0 . position AS position_4 , t0 . gtm_value AS gtm_value_5 , t0 . facebook_value AS facebook_value_6 FROM `product_condition` t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_active AS is_active_3 , t0 . position AS position_4 , t0 . gtm_value AS gtm_value_5 , t0 . facebook_value AS facebook_value_6 FROM `product_condition` t0 WHERE t0 . id = 2 ;
Copy
121
0.44 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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . created_at AS created_at_45 ,
t0 . updated_at AS updated_at_46 ,
t0 . po_id AS po_id_47 ,
t0 . product_id AS product_id_48 ,
t0 . scanned_by_id AS scanned_by_id_49 ,
t0 . imported_by_id AS imported_by_id_50 ,
t0 . analyzed_by_id AS analyzed_by_id_51 ,
t0 . supplier_id AS supplier_id_52 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_53 ,
t0 . restock_category_id AS restock_category_id_54 ,
t0 . preparation_lot_id AS preparation_lot_id_55 ,
t0 . triage_category_id AS triage_category_id_56
FROM
manifest_item t0
WHERE
t0 . id = ?
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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = 4807173 ;
Copy
122
0.12 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . msrp AS msrp_4 , t0 . analyzed_at AS analyzed_at_5 , t0 . photo AS photo_6 , t0 . cp_quantity AS cp_quantity_7 , t0 . cp_number AS cp_number_8 , t0 . cp_name AS cp_name_9 , t0 . cp_discount AS cp_discount_10 , t0 . has_expiration_date AS has_expiration_date_11 , t0 . cp_format AS cp_format_12 , t0 . cp_packaged_units AS cp_packaged_units_13 , t0 . cp_photos AS cp_photos_14 , t0 . cp_weight AS cp_weight_15 , t0 . cp_package AS cp_package_16 , t0 . old_cp_number AS old_cp_number_17 , t0 . is_flag_preparation_done AS is_flag_preparation_done_18 , t0 . has_marketing_photo_request AS has_marketing_photo_request_19 , t0 . is_oversize AS is_oversize_20 , t0 . old_name AS old_name_21 , t0 . is_updated AS is_updated_22 , t0 . scraper_class AS scraper_class_23 , t0 . scraper_id AS scraper_id_24 , t0 . is_upc_checked AS is_upc_checked_25 , t0 . is_upc_valid AS is_upc_valid_26 , t0 . is_ean_checked AS is_ean_checked_27 , t0 . is_ean_valid AS is_ean_valid_28 , t0 . is_validation AS is_validation_29 , t0 . is_category_validation AS is_category_validation_30 , t0 . previous_category_id AS previous_category_id_31 , t0 . last_category_change_at AS last_category_change_at_32 , t0 . restock_category_id AS restock_category_id_33 , t0 . analyzed_by_id AS analyzed_by_id_34 , t0 . upcitemdb_id AS upcitemdb_id_35 , t0 . synccentric_id AS synccentric_id_36 FROM product t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . msrp AS msrp_4 , t0 . analyzed_at AS analyzed_at_5 , t0 . photo AS photo_6 , t0 . cp_quantity AS cp_quantity_7 , t0 . cp_number AS cp_number_8 , t0 . cp_name AS cp_name_9 , t0 . cp_discount AS cp_discount_10 , t0 . has_expiration_date AS has_expiration_date_11 , t0 . cp_format AS cp_format_12 , t0 . cp_packaged_units AS cp_packaged_units_13 , t0 . cp_photos AS cp_photos_14 , t0 . cp_weight AS cp_weight_15 , t0 . cp_package AS cp_package_16 , t0 . old_cp_number AS old_cp_number_17 , t0 . is_flag_preparation_done AS is_flag_preparation_done_18 , t0 . has_marketing_photo_request AS has_marketing_photo_request_19 , t0 . is_oversize AS is_oversize_20 , t0 . old_name AS old_name_21 , t0 . is_updated AS is_updated_22 , t0 . scraper_class AS scraper_class_23 , t0 . scraper_id AS scraper_id_24 , t0 . is_upc_checked AS is_upc_checked_25 , t0 . is_upc_valid AS is_upc_valid_26 , t0 . is_ean_checked AS is_ean_checked_27 , t0 . is_ean_valid AS is_ean_valid_28 , t0 . is_validation AS is_validation_29 , t0 . is_category_validation AS is_category_validation_30 , t0 . previous_category_id AS previous_category_id_31 , t0 . last_category_change_at AS last_category_change_at_32 , t0 . restock_category_id AS restock_category_id_33 , t0 . analyzed_by_id AS analyzed_by_id_34 , t0 . upcitemdb_id AS upcitemdb_id_35 , t0 . synccentric_id AS synccentric_id_36 FROM product t0 WHERE t0 . id = 1085375 ;
Copy
123
0.29 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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . created_at AS created_at_45 ,
t0 . updated_at AS updated_at_46 ,
t0 . po_id AS po_id_47 ,
t0 . product_id AS product_id_48 ,
t0 . scanned_by_id AS scanned_by_id_49 ,
t0 . imported_by_id AS imported_by_id_50 ,
t0 . analyzed_by_id AS analyzed_by_id_51 ,
t0 . supplier_id AS supplier_id_52 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_53 ,
t0 . restock_category_id AS restock_category_id_54 ,
t0 . preparation_lot_id AS preparation_lot_id_55 ,
t0 . triage_category_id AS triage_category_id_56
FROM
manifest_item t0
WHERE
t0 . id = ?
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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = 4807174 ;
Copy
124
0.22 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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . created_at AS created_at_45 ,
t0 . updated_at AS updated_at_46 ,
t0 . po_id AS po_id_47 ,
t0 . product_id AS product_id_48 ,
t0 . scanned_by_id AS scanned_by_id_49 ,
t0 . imported_by_id AS imported_by_id_50 ,
t0 . analyzed_by_id AS analyzed_by_id_51 ,
t0 . supplier_id AS supplier_id_52 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_53 ,
t0 . restock_category_id AS restock_category_id_54 ,
t0 . preparation_lot_id AS preparation_lot_id_55 ,
t0 . triage_category_id AS triage_category_id_56
FROM
manifest_item t0
WHERE
t0 . id = ?
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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = 4807178 ;
Copy
125
0.25 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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . code AS code_2 ,
t0 . quantity AS quantity_3 ,
t0 . method AS method_4 ,
t0 . msrp AS msrp_5 ,
t0 . name AS name_6 ,
t0 . category AS category_7 ,
t0 . merchant_sku AS merchant_sku_8 ,
t0 . is_analyzed AS is_analyzed_9 ,
t0 . analyzed_at AS analyzed_at_10 ,
t0 . is_auto_analyzed AS is_auto_analyzed_11 ,
t0 . converted AS converted_12 ,
t0 . is_generic AS is_generic_13 ,
t0 . position AS position_14 ,
t0 . is_cp AS is_cp_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_prepared AS is_prepared_17 ,
t0 . preparation_cp_quantity AS preparation_cp_quantity_18 ,
t0 . preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19 ,
t0 . preparation_cp_total_units AS preparation_cp_total_units_20 ,
t0 . preparation_cp_extended AS preparation_cp_extended_21 ,
t0 . preparation_cp_discount AS preparation_cp_discount_22 ,
t0 . cp_name AS cp_name_23 ,
t0 . cp_display_name AS cp_display_name_24 ,
t0 . preparation_cp_selling_extended AS preparation_cp_selling_extended_25 ,
t0 . preparation_lot_units AS preparation_lot_units_26 ,
t0 . preparation_lot_discount AS preparation_lot_discount_27 ,
t0 . preparation_lot_extended AS preparation_lot_extended_28 ,
t0 . preparation_lot_selling_extended AS preparation_lot_selling_extended_29 ,
t0 . is_upcitemdb_error AS is_upcitemdb_error_30 ,
t0 . is_already_in_database AS is_already_in_database_31 ,
t0 . photo AS photo_32 ,
t0 . quantity_imported AS quantity_imported_33 ,
t0 . quantity_scanned AS quantity_scanned_34 ,
t0 . quantity_triage AS quantity_triage_35 ,
t0 . is_flag_preparation_done AS is_flag_preparation_done_36 ,
t0 . premade_lot_number AS premade_lot_number_37 ,
t0 . is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38 ,
t0 . is_synccentric_search_required AS is_synccentric_search_required_39 ,
t0 . is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40 ,
t0 . is_sent_to_synccentric AS is_sent_to_synccentric_41 ,
t0 . is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42 ,
t0 . is_validation AS is_validation_43 ,
t0 . is_skipped_for_analysis AS is_skipped_for_analysis_44 ,
t0 . created_at AS created_at_45 ,
t0 . updated_at AS updated_at_46 ,
t0 . po_id AS po_id_47 ,
t0 . product_id AS product_id_48 ,
t0 . scanned_by_id AS scanned_by_id_49 ,
t0 . imported_by_id AS imported_by_id_50 ,
t0 . analyzed_by_id AS analyzed_by_id_51 ,
t0 . supplier_id AS supplier_id_52 ,
t0 . original_preparation_lot_id AS original_preparation_lot_id_53 ,
t0 . restock_category_id AS restock_category_id_54 ,
t0 . preparation_lot_id AS preparation_lot_id_55 ,
t0 . triage_category_id AS triage_category_id_56
FROM
manifest_item t0
WHERE
t0 . id = ?
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 . created_at AS created_at_45 , t0 . updated_at AS updated_at_46 , t0 . po_id AS po_id_47 , t0 . product_id AS product_id_48 , t0 . scanned_by_id AS scanned_by_id_49 , t0 . imported_by_id AS imported_by_id_50 , t0 . analyzed_by_id AS analyzed_by_id_51 , t0 . supplier_id AS supplier_id_52 , t0 . original_preparation_lot_id AS original_preparation_lot_id_53 , t0 . restock_category_id AS restock_category_id_54 , t0 . preparation_lot_id AS preparation_lot_id_55 , t0 . triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0 . id = 4807181 ;
Copy