SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    6568, 2205, 2193, 2192, 6567, 3558, 2204, 
    676, 6563, 659, 666, 677, 6569, 658, 
    2203, 6566, 2597, 674, 2599, 2202, 2187, 
    2190, 661, 673, 670, 660, 664, 665, 2195, 
    2189
  )

Query time 0.00140

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_products",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "rows": 30,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (6568,2205,2193,2192,6567,3558,2204,676,6563,659,666,677,6569,658,2203,6566,2597,674,2599,2202,2187,2190,661,673,670,660,664,665,2195,2189)"
        }
      }
    ]
  }
}