SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    44943, 44986, 44987, 44988, 44989, 44990, 
    44991, 44992, 44993, 44994, 44995, 
    44996, 44997, 44998, 44999, 45000, 
    45001, 45002, 45003, 45004, 45005, 
    45006, 45007, 45008
  )

Query time 0.00291

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": 24,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (44943,44986,44987,44988,44989,44990,44991,44992,44993,44994,44995,44996,44997,44998,44999,45000,45001,45002,45003,45004,45005,45006,45007,45008)"
        }
      }
    ]
  }
}