SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    71, 42, 43, 44, 45, 46, 70, 47, 48, 41, 49, 
    50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 
    60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 
    72
  )

Query time 0.00089

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_products",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 102,
          "filtered": 31.37254906,
          "attached_condition": "cscart_products.product_id in (71,42,43,44,45,46,70,47,48,41,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,72)"
        }
      }
    ]
  }
}