SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    919, 918, 924, 922, 921, 925, 525, 917, 
    916, 955, 942, 941, 446, 953, 952, 951, 
    949, 948, 947, 946, 945, 944, 982, 980, 
    979, 978, 981, 478, 977, 975, 974, 973, 
    972, 971, 970, 994, 996, 493, 985, 986, 
    988, 990, 991, 993, 1003, 1001, 1000, 
    508, 5727, 5729, 5730, 5731, 5732, 5733, 
    5734, 5735, 5736, 5739, 5741, 5742, 
    5743, 5744, 5745, 5746, 5747, 5748, 
    5749, 5750, 5752, 5753, 5754, 5755, 
    5756, 5757, 5758, 5759, 5760, 5761, 
    5762, 7004, 7005, 7006, 7007, 7008, 
    7009, 7010, 7011, 7012, 7013, 7014, 
    7015, 10284, 10285, 10286, 10287, 10288, 
    10289, 10290, 10291, 10292, 10293
  )

Query time 0.00191

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "70.71"
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 101,
      "rows_produced_per_join": 101,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_products`.`product_id` in (919,918,924,922,921,925,525,917,916,955,942,941,446,953,952,951,949,948,947,946,945,944,982,980,979,978,981,478,977,975,974,973,972,971,970,994,996,493,985,986,988,990,991,993,1003,1001,1000,508,5727,5729,5730,5731,5732,5733,5734,5735,5736,5739,5741,5742,5743,5744,5745,5746,5747,5748,5749,5750,5752,5753,5754,5755,5756,5757,5758,5759,5760,5761,5762,7004,7005,7006,7007,7008,7009,7010,7011,7012,7013,7014,7015,10284,10285,10286,10287,10288,10289,10290,10291,10292,10293))",
      "cost_info": {
        "read_cost": "60.61",
        "eval_cost": "10.10",
        "prefix_cost": "70.71",
        "data_read_per_join": "446K"
      },
      "used_columns": [
        "product_id",
        "product_code",
        "product_type",
        "status",
        "company_id",
        "list_price",
        "amount",
        "weight",
        "length",
        "width",
        "height",
        "shipping_freight",
        "low_avail_limit",
        "timestamp",
        "updated_timestamp",
        "usergroup_ids",
        "is_edp",
        "edp_shipping",
        "unlimited_download",
        "tracking",
        "free_shipping",
        "zero_price_action",
        "is_pbp",
        "is_op",
        "is_oper",
        "is_returnable",
        "return_period",
        "avail_since",
        "out_of_stock_actions",
        "localization",
        "min_qty",
        "max_qty",
        "qty_step",
        "list_qty_count",
        "tax_ids",
        "age_verification",
        "age_limit",
        "options_type",
        "exceptions_type",
        "details_layout",
        "shipping_params",
        "facebook_obj_type",
        "parent_product_id",
        "buy_now_url",
        "units_in_product",
        "show_price_per_x_units",
        "ab__stickers_manual_ids",
        "ab__stickers_generated_ids"
      ]
    }
  }
}