1
0.29 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.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_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.09 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.17 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 = '2655' ;
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 = 2655 ;
Copy
6
0.09 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.31 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 :
[
"5058156 "
]
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 = '5058156' ;
Copy
8
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 = 4815291 ;
Copy
9
0.33 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 :
[
"838416 "
0
2655
]
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 = '838416' AND t0 . is_closed = 0 AND t0 . po_id = 2655 LIMIT 1 ;
Copy
10
0.36 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 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . number AS number_2 ,
t0 . package_units AS package_units_3 ,
t0 . weight AS weight_4 ,
t0 . user AS user_5 ,
t0 . format AS format_6 ,
t0 . photos AS photos_7 ,
t0 . name AS name_8 ,
t0 . extended AS extended_9 ,
t0 . units AS units_10 ,
t0 . discount AS discount_11 ,
t0 . estimated_sales AS estimated_sales_12 ,
t0 . is_initialized AS is_initialized_13 ,
t0 . msrp_current AS msrp_current_14 ,
t0 . is_closed AS is_closed_15 ,
t0 . is_high_value AS is_high_value_16 ,
t0 . is_cp AS is_cp_17 ,
t0 . estimated_sales_min_target AS estimated_sales_min_target_18 ,
t0 . estimated_sales_max_target AS estimated_sales_max_target_19 ,
t0 . display_name AS display_name_20 ,
t0 . quantity AS quantity_21 ,
t0 . cp_quantity AS cp_quantity_22 ,
t0 . is_truckload AS is_truckload_23 ,
t0 . is_photos_compressed AS is_photos_compressed_24 ,
t0 . is_destroy AS is_destroy_25 ,
t0 . package_sizes AS package_sizes_26 ,
t0 . is_listing_done AS is_listing_done_27 ,
t0 . discount_triage AS discount_triage_28 ,
t0 . volumetric_weight AS volumetric_weight_29 ,
t0 . real_weight AS real_weight_30 ,
t0 . previous_number AS previous_number_31 ,
t0 . is_oversize AS is_oversize_32 ,
t0 . cost AS cost_33 ,
t0 . is_imported AS is_imported_34 ,
t0 . 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 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . package_units AS package_units_3 , t0 . weight AS weight_4 , t0 . user AS user_5 , t0 . format AS format_6 , t0 . photos AS photos_7 , t0 . name AS name_8 , t0 . extended AS extended_9 , t0 . units AS units_10 , t0 . discount AS discount_11 , t0 . estimated_sales AS estimated_sales_12 , t0 . is_initialized AS is_initialized_13 , t0 . msrp_current AS msrp_current_14 , t0 . is_closed AS is_closed_15 , t0 . is_high_value AS is_high_value_16 , t0 . is_cp AS is_cp_17 , t0 . estimated_sales_min_target AS estimated_sales_min_target_18 , t0 . estimated_sales_max_target AS estimated_sales_max_target_19 , t0 . display_name AS display_name_20 , t0 . quantity AS quantity_21 , t0 . cp_quantity AS cp_quantity_22 , t0 . is_truckload AS is_truckload_23 , t0 . is_photos_compressed AS is_photos_compressed_24 , t0 . is_destroy AS is_destroy_25 , t0 . package_sizes AS package_sizes_26 , t0 . is_listing_done AS is_listing_done_27 , t0 . discount_triage AS discount_triage_28 , t0 . volumetric_weight AS volumetric_weight_29 , t0 . real_weight AS real_weight_30 , t0 . previous_number AS previous_number_31 , t0 . is_oversize AS is_oversize_32 , t0 . cost AS cost_33 , t0 . is_imported AS is_imported_34 , t0 . 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 . id = 49433 ;
Copy
11
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
12
0.11 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 = 49413 ORDER BY t0 . extended DESC ;
Copy
13
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 = 4063641 ;
Copy
14
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 = 4059334 ;
Copy
15
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 = 4057447 ;
Copy
16
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 = 4057457 ;
Copy
17
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057158 ;
Copy
18
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058696 ;
Copy
19
0.06 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056592 ;
Copy
20
0.06 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056596 ;
Copy
21
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062825 ;
Copy
22
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056597 ;
Copy
23
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058295 ;
Copy
24
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059429 ;
Copy
25
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057649 ;
Copy
26
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063349 ;
Copy
27
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059142 ;
Copy
28
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057159 ;
Copy
29
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058674 ;
Copy
30
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063111 ;
Copy
31
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056604 ;
Copy
32
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057489 ;
Copy
33
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058251 ;
Copy
34
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059137 ;
Copy
35
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063353 ;
Copy
36
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059313 ;
Copy
37
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059456 ;
Copy
38
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059150 ;
Copy
39
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058970 ;
Copy
40
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059373 ;
Copy
41
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058216 ;
Copy
42
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058881 ;
Copy
43
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059201 ;
Copy
44
0.07 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058717 ;
Copy
45
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062754 ;
Copy
46
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063494 ;
Copy
47
0.06 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064742 ;
Copy
48
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062774 ;
Copy
49
0.06 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063685 ;
Copy
50
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062808 ;
Copy
51
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057621 ;
Copy
52
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059145 ;
Copy
53
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059282 ;
Copy
54
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062775 ;
Copy
55
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058291 ;
Copy
56
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062776 ;
Copy
57
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059436 ;
Copy
58
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059280 ;
Copy
59
0.06 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059048 ;
Copy
60
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059289 ;
Copy
61
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063080 ;
Copy
62
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056585 ;
Copy
63
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059375 ;
Copy
64
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059284 ;
Copy
65
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059098 ;
Copy
66
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063389 ;
Copy
67
0.06 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062934 ;
Copy
68
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059433 ;
Copy
69
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063098 ;
Copy
70
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062858 ;
Copy
71
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057537 ;
Copy
72
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058527 ;
Copy
73
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059103 ;
Copy
74
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057574 ;
Copy
75
0.09 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064682 ;
Copy
76
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064109 ;
Copy
77
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064616 ;
Copy
78
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058585 ;
Copy
79
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064376 ;
Copy
80
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063073 ;
Copy
81
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058509 ;
Copy
82
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062869 ;
Copy
83
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063495 ;
Copy
84
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057509 ;
Copy
85
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057456 ;
Copy
86
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063390 ;
Copy
87
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063650 ;
Copy
88
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062837 ;
Copy
89
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062862 ;
Copy
90
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063077 ;
Copy
91
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064269 ;
Copy
92
0.08 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058583 ;
Copy
93
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064747 ;
Copy
94
0.07 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063160 ;
Copy
95
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058588 ;
Copy
96
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059287 ;
Copy
97
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057515 ;
Copy
98
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062772 ;
Copy
99
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063104 ;
Copy
100
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063100 ;
Copy
101
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063499 ;
Copy
102
0.04 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063072 ;
Copy
103
0.04 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062856 ;
Copy
104
0.04 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063401 ;
Copy
105
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062887 ;
Copy
106
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059028 ;
Copy
107
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056608 ;
Copy
108
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058519 ;
Copy
109
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062850 ;
Copy
110
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058773 ;
Copy
111
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063418 ;
Copy
112
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057474 ;
Copy
113
0.07 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058524 ;
Copy
114
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056611 ;
Copy
115
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063084 ;
Copy
116
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062864 ;
Copy
117
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064776 ;
Copy
118
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063097 ;
Copy
119
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058296 ;
Copy
120
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058299 ;
Copy
121
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058304 ;
Copy
122
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062974 ;
Copy
123
0.04 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057605 ;
Copy
124
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059285 ;
Copy
125
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4056607 ;
Copy
126
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058586 ;
Copy
127
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4064622 ;
Copy
128
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057539 ;
Copy
129
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063472 ;
Copy
130
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063485 ;
Copy
131
0.04 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058161 ;
Copy
132
0.04 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063149 ;
Copy
133
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4059024 ;
Copy
134
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058504 ;
Copy
135
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058972 ;
Copy
136
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062911 ;
Copy
137
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058579 ;
Copy
138
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4058162 ;
Copy
139
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4062865 ;
Copy
140
0.04 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4063474 ;
Copy
141
0.06 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 = 49433 ORDER BY t0 . extended DESC ;
Copy
142
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057613 ;
Copy
143
0.05 ms
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = ?
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . lot_item_id AS lot_item_id_3 , t0 . po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0 . lot_item_id = 4057841 ;
Copy
144
0.06 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
145
0.13 ms
UPDATE manifest_style SET is_active = ? WHERE id = ?
UPDATE manifest_style SET is_active = 1 WHERE id = 4 ;
Copy
146
0.08 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16038 ;
Copy
147
0.08 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16039 ;
Copy
148
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16040 ;
Copy
149
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16041 ;
Copy
150
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16042 ;
Copy
151
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16043 ;
Copy
152
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16044 ;
Copy
153
0.06 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16045 ;
Copy
154
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16046 ;
Copy
155
0.06 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16047 ;
Copy
156
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16048 ;
Copy
157
0.07 ms
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = 0 WHERE id = 16049 ;
Copy
158
0.65 ms
UPDATE triage_scan SET is_confirmed = ? , oversize_lot_id = ? WHERE id = ?
Parameters :
[
1
null
5058156
]
UPDATE triage_scan SET is_confirmed = 1 , oversize_lot_id = NULL WHERE id = 5058156 ;
Copy
159
0.22 ms
UPDATE lot SET units = ? , estimated_sales = ? , msrp_current = ? , is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
1016
640.37
6403.73
0
0
"2024-12-24 11:45:16 "
49413
]
UPDATE lot SET units = 1016 , estimated_sales = 640.37 , msrp_current = 6403.73 , is_high_value = 0 , is_cp = 0 , updated_at = '2024-12-24 11:45:16' WHERE id = 49413 ;
Copy
160
0.12 ms
UPDATE lot SET is_high_value = ? , is_cp = ? , updated_at = ? WHERE id = ?
Parameters :
[
0
0
"2024-12-24 11:45:16 "
49433
]
UPDATE lot SET is_high_value = 0 , is_cp = 0 , updated_at = '2024-12-24 11:45:16' WHERE id = 49433 ;
Copy
161
0.09 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
147.36
4058295
]
UPDATE lot_item SET extended = 147.36 WHERE id = 4058295 ;
Copy
162
0.16 ms
UPDATE lot_item SET quantity = ? , extended = ? WHERE id = ?
Parameters :
[
41
141.86
4063641
]
UPDATE lot_item SET quantity = 41 , extended = 141.86 WHERE id = 4063641 ;
Copy
163
0.13 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
130.4
4063349
]
UPDATE lot_item SET extended = 130.4 WHERE id = 4063349 ;
Copy
164
0.12 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
129.6
4059142
]
UPDATE lot_item SET extended = 129.6 WHERE id = 4059142 ;
Copy
165
0.09 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
119.64
4058674
]
UPDATE lot_item SET extended = 119.64 WHERE id = 4058674 ;
Copy
166
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
117.29
4063111
]
UPDATE lot_item SET extended = 117.29 WHERE id = 4063111 ;
Copy
167
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
116.64
4056604
]
UPDATE lot_item SET extended = 116.64 WHERE id = 4056604 ;
Copy
168
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
97.24
4058251
]
UPDATE lot_item SET extended = 97.24 WHERE id = 4058251 ;
Copy
169
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
92.82
4059137
]
UPDATE lot_item SET extended = 92.82 WHERE id = 4059137 ;
Copy
170
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
62.91
4062774
]
UPDATE lot_item SET extended = 62.91 WHERE id = 4062774 ;
Copy
171
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
24.71
4063098
]
UPDATE lot_item SET extended = 24.71 WHERE id = 4063098 ;
Copy
172
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
23.76
4057537
]
UPDATE lot_item SET extended = 23.76 WHERE id = 4057537 ;
Copy
173
0.08 ms
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters :
[
6.86
4056611
]
UPDATE lot_item SET extended = 6.86 WHERE id = 4056611 ;
Copy
174
2.69 ms
UPDATE lot_item_origin SET quantity = ? WHERE id = ?
Parameters :
[
41
5081390
]
UPDATE lot_item_origin SET quantity = 41 WHERE id = 5081390 ;
Copy
175
1.63 ms
"COMMIT"
176
0.08 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 = 3 ;
Copy
177
0.11 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
178
0.07 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
179
0.30 ms
UPDATE triage_scan SET confirm_request = ? , is_confirmed_lot = ? , lot_item_id = ? , scan_category_group_id = ? WHERE id = ?
Parameters :
[
null
1
4063641
6
5058156
]
UPDATE triage_scan SET confirm_request = NULL , is_confirmed_lot = 1 , lot_item_id = 4063641 , scan_category_group_id = 6 WHERE id = 5058156 ;
Copy
180
0.19 ms
UPDATE category SET is_updated = ? , is_active = ? WHERE id = ?
UPDATE category SET is_updated = 1 , is_active = 1 WHERE id = 3 ;
Copy
181
0.45 ms
UPDATE scan_session SET nb_scans = ? , updated_at = ? , nb_scans_per_minute = ? WHERE id = ?
Parameters :
[
181
"2024-12-24 11:45:16 "
5.03
315611
]
UPDATE scan_session SET nb_scans = 181 , updated_at = '2024-12-24 11:45:16' , nb_scans_per_minute = 5.03 WHERE id = 315611 ;
Copy
182
0.57 ms
"COMMIT"
183
0.52 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 :
[
2655
"ts676adcf87f001 "
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 = 2655 AND t0 . session_number = 'ts676adcf87f001' AND t0 . user_id = 95 ORDER BY t0 . id DESC LIMIT 5 ;
Copy
184
0.18 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . has_actions AS has_actions_3 , t0 . has_validation AS has_validation_4 , t0 . has_high_value AS has_high_value_5 , t0 . is_active AS is_active_6 , t0 . has_scrapper AS has_scrapper_7 , t0 . sources_upc AS sources_upc_8 , t0 . sources_merchant_sku AS sources_merchant_sku_9 , t0 . sources_category AS sources_category_10 , t0 . sources_name AS sources_name_11 , t0 . sources_msrp AS sources_msrp_12 , t0 . sources_photo AS sources_photo_13 , t0 . sources_action AS sources_action_14 , t0 . is_required_upc AS is_required_upc_15 , t0 . is_required_merchant_sku AS is_required_merchant_sku_16 , t0 . is_required_category AS is_required_category_17 , t0 . is_required_name AS is_required_name_18 , t0 . is_required_msrp AS is_required_msrp_19 , t0 . is_required_photo AS is_required_photo_20 , t0 . is_required_action AS is_required_action_21 , t0 . public_name AS public_name_22 , t0 . is_deleted AS is_deleted_23 , t0 . product_generic_link AS product_generic_link_24 , t0 . billing_name AS billing_name_25 , t0 . billing_address AS billing_address_26 , t0 . tax_name1 AS tax_name1_27 , t0 . tax_rate1 AS tax_rate1_28 , t0 . tax_name2 AS tax_name2_29 , t0 . tax_rate2 AS tax_rate2_30 , t0 . tax_number1 AS tax_number1_31 , t0 . tax_number2 AS tax_number2_32 , t0 . tax_currency AS tax_currency_33 , t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 , t0 . has_continuous_po AS has_continuous_po_35 , t0 . newsletter_default_subject AS newsletter_default_subject_36 , t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 , t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 , t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 , t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 , t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 , t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 , t0 . scraper_class AS scraper_class_43 , t0 . has_splited_scraper AS has_splited_scraper_44 , t0 . has_synccentric_data AS has_synccentric_data_45 , t0 . has_upcitemdb_data AS has_upcitemdb_data_46 , t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 , t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 , t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 , t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 , t0 . user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . has_actions AS has_actions_3 ,
t0 . has_validation AS has_validation_4 ,
t0 . has_high_value AS has_high_value_5 ,
t0 . is_active AS is_active_6 ,
t0 . has_scrapper AS has_scrapper_7 ,
t0 . sources_upc AS sources_upc_8 ,
t0 . sources_merchant_sku AS sources_merchant_sku_9 ,
t0 . sources_category AS sources_category_10 ,
t0 . sources_name AS sources_name_11 ,
t0 . sources_msrp AS sources_msrp_12 ,
t0 . sources_photo AS sources_photo_13 ,
t0 . sources_action AS sources_action_14 ,
t0 . is_required_upc AS is_required_upc_15 ,
t0 . is_required_merchant_sku AS is_required_merchant_sku_16 ,
t0 . is_required_category AS is_required_category_17 ,
t0 . is_required_name AS is_required_name_18 ,
t0 . is_required_msrp AS is_required_msrp_19 ,
t0 . is_required_photo AS is_required_photo_20 ,
t0 . is_required_action AS is_required_action_21 ,
t0 . public_name AS public_name_22 ,
t0 . is_deleted AS is_deleted_23 ,
t0 . product_generic_link AS product_generic_link_24 ,
t0 . billing_name AS billing_name_25 ,
t0 . billing_address AS billing_address_26 ,
t0 . tax_name1 AS tax_name1_27 ,
t0 . tax_rate1 AS tax_rate1_28 ,
t0 . tax_name2 AS tax_name2_29 ,
t0 . tax_rate2 AS tax_rate2_30 ,
t0 . tax_number1 AS tax_number1_31 ,
t0 . tax_number2 AS tax_number2_32 ,
t0 . tax_currency AS tax_currency_33 ,
t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 ,
t0 . has_continuous_po AS has_continuous_po_35 ,
t0 . newsletter_default_subject AS newsletter_default_subject_36 ,
t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 ,
t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 ,
t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 ,
t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 ,
t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 ,
t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 ,
t0 . scraper_class AS scraper_class_43 ,
t0 . has_splited_scraper AS has_splited_scraper_44 ,
t0 . has_synccentric_data AS has_synccentric_data_45 ,
t0 . has_upcitemdb_data AS has_upcitemdb_data_46 ,
t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 ,
t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 ,
t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 ,
t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 ,
t0 . user_group_id AS user_group_id_51
FROM
supplier t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . has_actions AS has_actions_3 , t0 . has_validation AS has_validation_4 , t0 . has_high_value AS has_high_value_5 , t0 . is_active AS is_active_6 , t0 . has_scrapper AS has_scrapper_7 , t0 . sources_upc AS sources_upc_8 , t0 . sources_merchant_sku AS sources_merchant_sku_9 , t0 . sources_category AS sources_category_10 , t0 . sources_name AS sources_name_11 , t0 . sources_msrp AS sources_msrp_12 , t0 . sources_photo AS sources_photo_13 , t0 . sources_action AS sources_action_14 , t0 . is_required_upc AS is_required_upc_15 , t0 . is_required_merchant_sku AS is_required_merchant_sku_16 , t0 . is_required_category AS is_required_category_17 , t0 . is_required_name AS is_required_name_18 , t0 . is_required_msrp AS is_required_msrp_19 , t0 . is_required_photo AS is_required_photo_20 , t0 . is_required_action AS is_required_action_21 , t0 . public_name AS public_name_22 , t0 . is_deleted AS is_deleted_23 , t0 . product_generic_link AS product_generic_link_24 , t0 . billing_name AS billing_name_25 , t0 . billing_address AS billing_address_26 , t0 . tax_name1 AS tax_name1_27 , t0 . tax_rate1 AS tax_rate1_28 , t0 . tax_name2 AS tax_name2_29 , t0 . tax_rate2 AS tax_rate2_30 , t0 . tax_number1 AS tax_number1_31 , t0 . tax_number2 AS tax_number2_32 , t0 . tax_currency AS tax_currency_33 , t0 . weight_per_pallet_feet AS weight_per_pallet_feet_34 , t0 . has_continuous_po AS has_continuous_po_35 , t0 . newsletter_default_subject AS newsletter_default_subject_36 , t0 . newsletter_default_preview_text AS newsletter_default_preview_text_37 , t0 . newsletter_default_header_line1 AS newsletter_default_header_line1_38 , t0 . newsletter_default_header_line2 AS newsletter_default_header_line2_39 , t0 . newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40 , t0 . newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41 , t0 . newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42 , t0 . scraper_class AS scraper_class_43 , t0 . has_splited_scraper AS has_splited_scraper_44 , t0 . has_synccentric_data AS has_synccentric_data_45 , t0 . has_upcitemdb_data AS has_upcitemdb_data_46 , t0 . apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47 , t0 . is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48 , t0 . shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49 , t0 . shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50 , t0 . user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0 . id = 28 ;
Copy
185
0.11 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
186
0.29 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
187
93.39 ms
SELECT t0 . id AS id_1 , t0 . nb_scans AS nb_scans_2 , t0 . module AS module_3 , t0 . is_closed AS is_closed_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . nb_scans_per_minute AS nb_scans_per_minute_7 , t0 . nb_minutes AS nb_minutes_8 , t0 . user_id AS user_id_9 , t0 . po_id AS po_id_10 , t0 . scan_category_group_id AS scan_category_group_id_11 , t0 . user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0 . is_closed = ?
SELECT t0 . id AS id_1 , t0 . nb_scans AS nb_scans_2 , t0 . module AS module_3 , t0 . is_closed AS is_closed_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . nb_scans_per_minute AS nb_scans_per_minute_7 , t0 . nb_minutes AS nb_minutes_8 , t0 . user_id AS user_id_9 , t0 . po_id AS po_id_10 , t0 . scan_category_group_id AS scan_category_group_id_11 , t0 . user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0 . is_closed = 0 ;
Copy
188
0.15 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
189
0.28 ms
UPDATE supplier SET has_actions = ? , has_validation = ? , has_high_value = ? , is_active = ? , is_deleted = ? WHERE id = ?
Parameters :
[
0
1
0
1
0
28
]
UPDATE supplier SET has_actions = 0 , has_validation = 1 , has_high_value = 0 , is_active = 1 , is_deleted = 0 WHERE id = 28 ;
Copy
190
0.19 ms
UPDATE `product_condition` SET is_active = ? WHERE id = ?
UPDATE `product_condition` SET is_active = 1 WHERE id = 2 ;
Copy
191
0.14 ms
"COMMIT"
192
10.10 ms
SELECT s0_ . id AS id_0 , s0_ . nb_scans AS nb_scans_1 , s0_ . module AS module_2 , s0_ . is_closed AS is_closed_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . nb_scans_per_minute AS nb_scans_per_minute_6 , s0_ . nb_minutes AS nb_minutes_7 , s0_ . user_id AS user_id_8 , s0_ . po_id AS po_id_9 , s0_ . scan_category_group_id AS scan_category_group_id_10 , s0_ . user_group_id AS user_group_id_11 FROM scan_session s0_ INNER JOIN po p1_ ON s0_ . po_id = p1_ . id WHERE s0_ . nb_scans > 25 AND p1_ . supplier_id = ? AND s0_ . scan_category_group_id = ? AND s0_ . user_id = ? AND s0_ . created_at > = ? AND s0_ . created_at < = ? ORDER BY s0_ . id DESC
Parameters :
[
28
6
95
"2024-12-24 00:00:00 "
"2024-12-24 11:45:16 "
]
SELECT s0_ . id AS id_0 , s0_ . nb_scans AS nb_scans_1 , s0_ . module AS module_2 , s0_ . is_closed AS is_closed_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . nb_scans_per_minute AS nb_scans_per_minute_6 , s0_ . nb_minutes AS nb_minutes_7 , s0_ . user_id AS user_id_8 , s0_ . po_id AS po_id_9 , s0_ . scan_category_group_id AS scan_category_group_id_10 , s0_ . user_group_id AS user_group_id_11 FROM scan_session s0_ INNER JOIN po p1_ ON s0_ . po_id = p1_ . id WHERE s0_ . nb_scans > 25 AND p1_ . supplier_id = 28 AND s0_ . scan_category_group_id = 6 AND s0_ . user_id = 95 AND s0_ . created_at > = '2024-12-24 00:00:00' AND s0_ . created_at < = '2024-12-24 11:45:16' ORDER BY s0_ . id DESC ;
Copy
193
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
194
0.68 ms
UPDATE user SET current_scan_average = ? WHERE id = ?
Parameters :
[
266.63
95
]
UPDATE user SET current_scan_average = 266.63 WHERE id = 95 ;
Copy
195
0.75 ms
"COMMIT"