SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    454572, 450411, 428039, 444761, 429912, 
    420188, 424206, 407306, 428074, 418172, 
    410488, 432848, 436654, 442418, 440178, 
    403102, 407983, 446645, 403027, 424154, 
    407388, 442807, 440814, 407763, 422443, 
    404639, 402405, 456168, 439861, 426164, 
    458074, 423893, 421671, 450937, 432839, 
    441211, 407193, 406544, 425690, 408244, 
    436662, 405337, 419836, 438212, 447927, 
    433468, 426945, 409284, 441349, 429101, 
    413884, 422954, 444490, 453668, 415810, 
    448981, 438027, 427590, 452812, 431070, 
    455014, 451830, 460460, 415931, 401798, 
    423061, 441431, 408605, 430102, 455206, 
    431661, 456097, 426037, 432328, 419677, 
    402123, 424736, 414301, 414111, 454261, 
    414904, 416994, 415347, 416119, 408593, 
    405205, 449548, 416483, 422144, 418477, 
    429319, 415762, 434095, 411652, 460288, 
    435044
  )

Query time 0.00093

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.16771496,
    "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": 96,
          "cost": 0.16771496,
          "filtered": 100,
          "attached_condition": "cscart_products.product_id in (454572,450411,428039,444761,429912,420188,424206,407306,428074,418172,410488,432848,436654,442418,440178,403102,407983,446645,403027,424154,407388,442807,440814,407763,422443,404639,402405,456168,439861,426164,458074,423893,421671,450937,432839,441211,407193,406544,425690,408244,436662,405337,419836,438212,447927,433468,426945,409284,441349,429101,413884,422954,444490,453668,415810,448981,438027,427590,452812,431070,455014,451830,460460,415931,401798,423061,441431,408605,430102,455206,431661,456097,426037,432328,419677,402123,424736,414301,414111,454261,414904,416994,415347,416119,408593,405205,449548,416483,422144,418477,429319,415762,434095,411652,460288,435044)"
        }
      }
    ]
  }
}