SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2507, 2501, 2498, 2504, 2500, 2505, 2503, 
    2499, 2497, 2508, 2506, 2509
  )

Query time 0.00055

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 (2507,2501,2498,2504,2500,2505,2503,2499,2497,2508,2506,2509)"
    }
  }
}

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
2497 74367 P A 1 0.00 164.65 0.000 0 0 0 0.00 0 1706648400 1741353045 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 74367 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2498 74368 P A 1 0.00 1.13 0.000 0 0 0 0.00 0 1706562000 1741352280 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 74368 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2499 74369 P A 1 0.00 481.7 0.000 0 0 0 0.00 0 1706475600 1741353050 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 74369 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2500 74370 P A 1 0.00 90.5 0.000 0 0 0 0.00 0 1706302800 1741352295 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 74370 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2501 74371 P A 1 0.00 566.65 0.000 0 0 0 0.00 0 1706302800 1741352276 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 74371 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2503 74373 P A 1 0.00 420.79 0.000 0 0 0 0.00 0 1706130000 1741352299 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 74373 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2504 74374 P A 1 0.00 541.57 0.000 0 0 0 0.00 0 1706043600 1741352285 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 74374 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2505 74375 P A 1 0.00 589.94 0.000 0 0 0 0.00 0 1705957200 1741352290 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 74375 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2506 74376 P A 1 0.00 596.13 0.000 0 0 0 0.00 0 1705870800 1741353064 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 74376 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2507 74377 P A 1 0.00 476.72 0.000 0 0 0 0.00 0 1705784400 1741352253 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 74377 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2508 74378 P A 1 0.00 613.25 0.000 0 0 0 0.00 0 1705698000 1741353054 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 74378 Y 30 0 0 0 0 Y N N 0.00 a:0:{}
2509 74379 P A 1 0.00 648.99 0.000 0 0 0 0.00 0 1705611600 1741353059 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 74379 Y 30 0 0 0 0 Y N N 0.00 a:0:{}