SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    203, 204, 205, 206, 207, 208, 209, 210, 
    211, 212, 213, 214, 215, 216, 217, 218, 
    219, 220, 221, 222, 223, 224, 225, 226
  )

Query time 0.00116

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 (203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226)"
    }
  }
}

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 buy_now_url units_in_product show_price_per_x_units split_for_sale main_unit material_group stock_norm min_stock_level max_stock_level reorder_level safety_stock
203 6972106233450 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
204 6972106233382 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
205 6972106233443 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
206 6972106233399 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
207 6972106233405 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
208 7613032403522 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
209 7613032488048 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
210 7613034964090 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
211 4901330740672 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
212 3041091221957 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
213 3041091222039 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
214 3041091222015 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
215 3041091222022 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
216 3041091221926 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
217 3041091221940 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
218 3700653812087 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
219 4987244170446 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
220 9369998023530 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
221 4903308035605 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
222 030000410004 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
223 030000315828 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
224 4902820108057 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
225 4973655938706 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000
226 4973655938720 P A 1 0.00 0.000 0 0 0 0.00 0 1661577133 1734422409 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 N G 0.000 0.000 0.000 0.000 0.000