SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    3837, 3843, 4184, 880, 4888, 6081, 31922, 
    229, 6088, 4173, 215, 38748, 4388, 28114, 
    3495, 6085, 214, 4176, 4887, 4449, 6082, 
    3830, 3502, 4889, 2768, 28133, 31923, 
    3827, 31925, 3853, 6186, 6083
  )

Query time 0.00664

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": 32,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (3837,3843,4184,880,4888,6081,31922,229,6088,4173,215,38748,4388,28114,3495,6085,214,4176,4887,4449,6082,3830,3502,4889,2768,28133,31923,3827,31925,3853,6186,6083)"
        }
      }
    ]
  }
}