SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    200, 201, 202, 203, 204, 205, 206, 207, 
    208, 209, 210, 211, 212, 213, 215, 217, 
    218, 220, 222, 224, 225, 226, 227, 228
  )

Query time 0.00061

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": 24,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,217,218,220,222,224,225,226,227,228)"
    }
  }
}

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 parent_product_id addon_ship_start_date
200 X02002U30A P A 1 0.00 12 0.000 0 0 0 0.00 0 1328731200 1328771918 0 N N N N Y N N Y 10 0 N N 0 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 0
201 V02011EWI8 P A 1 0.00 20 0.000 0 0 0 0.00 0 1328731200 1328772038 0 N N N N Y N N Y 10 0 N N 0 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 0
202 T0202OTGXT P A 1 0.00 15 0.000 0 0 0 0.00 0 1328731200 1328772204 0 N N N N Y N N Y 10 0 N N 0 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 0
203 R02034W1ZL P A 1 0.00 20 0.000 0 0 0 0.00 0 1328731200 1328772336 0 N N N N Y N N Y 10 0 N N 0 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 0
204 B0204ZOC1I P A 1 0.00 25 0.000 0 0 0 0.00 0 1328731200 1328773218 0 N N N N Y N N Y 10 0 N N 0 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 0
205 Y0205HGGEI P A 1 0.00 35 0.000 0 0 0 0.00 0 1328731200 1328792701 0 N N N N Y N N Y 10 0 N N 0 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 0
206 Q0206MCK7B P A 1 0.00 10 0.000 0 0 0 0.00 0 1328731200 1328792777 0 N N N N Y N N Y 10 0 N N 0 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 0
207 W0207TLU5R P A 1 0.00 15 0.000 0 0 0 0.00 0 1328731200 1328792688 0 N N N N Y N N Y 10 0 N N 0 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 0
208 F0208V084C P A 1 0.00 20 0.000 0 0 0 0.00 0 1328731200 1328792728 0 N N N N Y N N Y 10 0 N N 0 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 0
209 G0209Y9N72 P A 1 0.00 10 0.000 0 0 0 0.00 0 1328731200 1328792337 0 N N N N Y N N Y 10 0 N N 0 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 0
210 D0210M5AN1 P A 1 0.00 10 0.000 0 0 0 0.00 0 1328731200 1328792316 0 N N N N Y N N Y 10 0 N N 0 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 0
211 H021184FO0 P A 1 0.00 5 0.000 0 0 0 0.00 0 1328731200 1328792295 0 N N N N Y N N Y 10 0 N N 0 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 0
212 P0212CTOEA P A 1 0.00 15 0.000 0 0 0 0.00 0 1328731200 1328792641 0 N N N N Y N N Y 10 0 N N 0 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 0
213 R0213E2U6B P A 1 0.00 20 0.000 0 0 0 0.00 0 1328731200 1328785857 0 N N N N Y N N Y 10 0 N N 0 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 0
215 O02154E04H P A 1 0.00 15 0.000 0 0 0 0.00 0 1328731200 1328777255 0 N N N N Y N N Y 10 0 N N 0 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 0
217 H0217E3OE9 P A 1 0.00 9 0.000 0 0 0 0.00 0 1328731200 1328777310 0 N N N N Y N N Y 10 0 N N 0 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 0
218 B0218UO9WS P A 1 0.00 10 0.000 0 0 0 0.00 0 1328731200 1328777475 0 N N N N Y N N Y 10 0 N N 0 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 0
220 P0220KHOS3 P A 1 0.00 9 0.000 0 0 0 0.00 0 1328731200 1328778133 0 N N N N Y N N Y 10 0 N N 0 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 0
222 P0222KUH4T P A 1 0.00 10 0.000 0 0 0 0.00 0 1328731200 1328782543 0 N N N N Y N N Y 10 0 N N 0 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 0
224 Y0224Y3QQU P A 1 0.00 10 0.000 0 0 0 0.00 0 1328731200 1328784992 0 N N N N Y N N Y 10 0 N N 0 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 0
225 E0225PPZPL P A 1 0.00 10 0.000 0 0 0 0.00 0 1328731200 1328785170 0 N N N N Y N N Y 10 0 N N 0 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 0
226 P02266IOPQ P A 1 0.00 15 0.000 0 0 0 0.00 0 1328731200 1328785951 0 N N N N Y N N Y 10 0 N N 0 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 0
227 L0227FHI2Y P A 1 0.00 13 0.000 0 0 0 0.00 0 1328731200 1328786258 0 N N N N Y N N Y 10 0 N N 0 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 0
228 I0228OF40N P A 1 0.00 25 0.000 0 0 0 0.00 0 1328731200 1328786599 0 N N N N Y N N Y 10 0 N N 0 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 0