SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    49541, 49543, 48864, 48865, 48862, 48863, 
    49160, 48856, 48660, 48835, 48860, 
    49153, 48663, 49125, 47503, 49542, 
    49158, 49126, 49122, 48496, 49155, 
    49163, 49504, 49154, 49127, 49162, 
    49129, 49131, 49161, 49157, 48662, 
    48659
  )

Query time 0.00148

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 (49541,49543,48864,48865,48862,48863,49160,48856,48660,48835,48860,49153,48663,49125,47503,49542,49158,49126,49122,48496,49155,49163,49504,49154,49127,49162,49129,49131,49161,49157,48662,48659)"
        }
      }
    ]
  }
}