SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2380, 2372, 2371, 2370, 2377, 2373, 2375, 
    2386, 2381, 2374, 2379, 2378
  )

Query time 0.00069

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 12,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (2380,2372,2371,2370,2377,2373,2375,2386,2381,2374,2379,2378)"
    }
  }
}

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params facebook_obj_type parent_product_id yml2_brand yml2_origin_country yml2_store yml2_pickup yml2_delivery yml2_adult yml2_delivery_options yml2_bid yml2_cbid yml2_fee yml2_model yml2_sales_notes yml2_type_prefix yml2_offer_type yml2_market_category yml2_manufacturer_warranty yml2_expiry yml2_purchase_price yml2_description yml2_cpa buy_now_url external_id update_1c ab__stickers_manual_ids ab__stickers_generated_ids coloristica_id allow_fractional_amount product_amount_step sale_type my_supplier_id supplier_amount manufacturer_code supplier_access_count rf_stop_update_price rf_stop_update_amount rf_stop_update_status rf_cost gr__fe09_pickup_options
2370 73874 P A 1 0.00 43.93 0.000 0 0 0 0.00 0 1701378000 1741355689 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73874 Y 0 0 0 73874 0 Y N N 0.00 a:0:{}
2371 73875 P A 1 0.00 33.45 0.000 0 0 0 0.00 0 1701378000 1741355683 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73875 Y 0 0 0 73875 0 Y N N 0.00 a:0:{}
2372 73876 P A 1 0.00 404.86 0.000 0 0 0 0.00 0 1701378000 1741355678 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73876 Y 0 0 0 73876 0 Y N N 0.00 a:0:{}
2373 73877 P A 1 0.00 181.7 0.000 0 0 0 0.00 0 1701378000 1741355699 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73877 Y 0 0 0 73877 0 Y N N 0.00 a:0:{}
2374 73878 P A 1 0.00 152.06 0.000 0 0 0 0.00 0 1701378000 1741355728 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73878 Y 0 0 0 73878 0 Y N N 0.00 a:0:{}
2375 73879 P A 1 0.00 450.1 0.000 0 0 0 0.00 0 1701378000 1741355705 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73879 Y 0 0 0 73879 0 Y N N 0.00 a:0:{}
2377 73881 P A 1 0.00 141.35 0.000 0 0 0 0.00 0 1701378000 1741355694 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73881 Y 0 0 0 73881 0 Y N N 0.00 a:0:{}
2378 73882 P A 1 0.00 3.39 0.000 0 0 0 0.00 0 1701378000 1741355734 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73882 Y 0 0 0 73882 0 Y N N 0.00 a:0:{}
2379 73883 P A 1 0.00 203.36 0.000 0 0 0 0.00 0 1701378000 1741355723 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73883 Y 0 0 0 73883 0 Y N N 0.00 a:0:{}
2380 73884 P A 1 0.00 151.26 0.000 0 0 0 0.00 0 1701378000 1741355672 0 N N N B N R Y N N Y 10 0 S 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73884 Y 0 0 0 73884 0 Y N N 0.00 a:0:{}
2381 73885 P A 1 0.00 296.82 0.000 0 0 0 0.00 0 1701378000 1741355716 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73885 Y 0 0 0 73885 0 Y N N 0.00 a:0:{}
2386 73890 P A 1 0.00 13.78 0.000 0 0 0 0.00 0 1701378000 1741355710 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 10 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N a:0:{} 0 0 0 0 Y 73890 Y 0 0 0 73890 0 Y N N 0.00 a:0:{}