深圳智汇创想科技有限公司

[步骤]

  (37555358 <= id AND id <= 40237883)  ID 范围太大 查询时间长 导致大量卡顿 仓库崩溃

select `id`,`p_id`,`warehouse_type`,`warehouse_level`,`warehouse_name`,`seller_name`,`exist_child`,`source_id`,`source_status`,`fulfillment_country`,`customer_id`,`seller_id`,`fnsku`,`asin`,`msku`,`p_asin`,`fulfillable_quantity`,`inbound_working_quantity`,`inbound_shipped_quantity`,`inbound_receiving_quantity`,`inbound_quantity`,`total_reserved_quantity`,`pending_customer_order_quantity`,`pending_transshipment_quantity`,`fc_processing_quantity`,`total_unfulfillable_quantity`,`inventory_age_0_to_30_days`,`inventory_age_31_to_60_days`,`inventory_age_61_to_90_days`,`inventory_age_0_to_90_days`,`inventory_age_91_to_180_days`,`inventory_age_181_to_330_days`,`inventory_age_181_to_270_days`,`inventory_age_271_to_365_days`,`inventory_age_331_to_365_days`,`inventory_age_365_plus_days`,`days_of_supply`,`weeks_of_cover_t30`,`weeks_of_cover_t90`,`item_volume`,`volume_unit_measurement`,`storage_volume`,`sell_through`,`estimated_excess_quantity`,`sales_amount_1_days`,`sales_amount_7_days`,`sales_amount_14_days`,`sales_amount_30_days`,`sales_amount_60_days`,`sales_amount_90_days`,`is_deleted`,`create_time`,`update_time`,`created_by`,`updated_by`,`last_update_time`,`remark`,`is_narf`,`is_pan_eu`,`is_efn`,`item_name`,`product_name_cn`,`sku`,`image_url`,`salesman_id`,`salesman_name`,`first_business_people_id`,`first_business_people_name`,`country_code`,`currency_code`,`projected_to_be_charged_ltsf`,`projected_to_be_charged_ltsf_cny`,`projected_to_be_charged_ltsf_usd`,`estimated_storage_cost_next_month`,`estimated_storage_cost_next_month_cny`,`estimated_storage_cost_next_month_usd`,`qty_to_be_charged_ltsf_6_to_12_mo`,`qty_to_be_charged_ltsf_12_last_mo`,`projected_to_be_charged_ltsf_6_to_12_mo`,`projected_to_be_charged_ltsf_6_to_12_mo_cny`,`projected_to_be_charged_ltsf_6_to_12_mo_usd`,`projected_to_be_charged_ltsf_12_last_mo`,`projected_to_be_charged_ltsf_12_last_mo_cny`,`projected_to_be_charged_ltsf_12_last_mo_usd`,`transit_quantity`,`pre_received_date`,`goods_value`,`goods_value_cny`,`goods_value_usd`,`first_received_time`,`last_buy_price_cny`,`last_buy_price_usd`,`last_buy_price_local`,`inventory_analysis_remark_time`,`inventory_analysis_remark`,`historical_days_of_supply`,`fba_minimum_inventory_level`,`short_term_historical_days_of_supply`,`long_term_historical_days_of_supply`,`recommended_ship_in_quantity`,`recommended_ship_in_date`,`version`,`product_group`,`storage_type`,`low_price_type` from t_amz_fba_virtual_inventory  where  (37555358 <= id AND id <= 40237883)

[结果]

[期望]