SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    439616, 439621, 439635, 439459, 439482, 
    439484, 439497, 439503, 439522, 439527, 
    439533, 439366, 439367, 439400, 439408, 
    439424, 439426, 439427, 439258, 439269, 
    439272, 439283, 439284, 439310, 439312, 
    439320, 439332, 439161, 439162, 439177, 
    439184, 439194, 439201, 439207, 439215, 
    439224, 439226, 439228, 439044, 439049, 
    439064, 439094, 439096, 439112, 439116, 
    438942, 438950, 438958
  )

Query time 0.00084

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.08425304,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_products",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "loops": 1,
          "rows": 48,
          "cost": 0.08425304,
          "filtered": 100,
          "attached_condition": "cscart_products.product_id in (439616,439621,439635,439459,439482,439484,439497,439503,439522,439527,439533,439366,439367,439400,439408,439424,439426,439427,439258,439269,439272,439283,439284,439310,439312,439320,439332,439161,439162,439177,439184,439194,439201,439207,439215,439224,439226,439228,439044,439049,439064,439094,439096,439112,439116,438942,438950,438958)"
        }
      }
    ]
  }
}