SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    457753, 457758, 457766, 457790, 457596, 
    457603, 457625, 457657, 457660, 457678, 
    457686, 457495, 457520, 457524, 457561, 
    457563, 457573, 457581, 457584, 457492, 
    457385, 457400, 457421, 457433
  )

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.04252208,
    "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": 24,
          "cost": 0.04252208,
          "filtered": 100,
          "attached_condition": "cscart_products.product_id in (457753,457758,457766,457790,457596,457603,457625,457657,457660,457678,457686,457495,457520,457524,457561,457563,457573,457581,457584,457492,457385,457400,457421,457433)"
        }
      }
    ]
  }
}

Result

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 show_videos_before_images autoplay_videos facebook_obj_type parent_product_id buy_now_url units_in_product show_price_per_x_units sg_is_synced sg_solr_update_timestamp resale_product sg_review_analysis allow_sg_quotation sg_quotation_note sg_seo_suggest sg_performance_suggest enable_flutterwave_subscription is_auction_product sg_created_by_user_id sg_product_condition sg_zoho_id xero_product_id
457385 TQY558327 P A 2 871.71 445 14.720 0 0 0 0.00 0 1766843600 1766844041 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457400 SGY496402 P A 5 1604.85 358 10.380 0 0 0 0.00 0 1766843600 1766844168 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457421 PUQ930571 P A 5 495.43 2 6.550 0 0 0 0.00 0 1766843600 1766844168 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457433 CUC904644 P A 5 1339.99 109 4.320 0 0 0 0.00 0 1766843600 1766844168 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457492 LJR204651 P A 2 1632.33 91 13.890 0 0 0 0.00 0 1766844296 1766844296 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457495 NBD590340 P A 5 707.53 231 16.620 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457520 NSB805000 P A 5 124.23 12 16.570 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457524 ADJ358257 P A 2 2032.87 266 10.390 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457561 EXU478430 P A 5 846.56 426 7.470 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457563 ZMK560512 P A 2 1509.57 344 1.120 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457573 QAC690044 P A 2 1701.92 342 19.030 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457581 YNB649759 P A 2 1015.76 117 2.640 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457584 UCQ555350 P A 2 229.44 58 15.830 0 0 0 0.00 0 1766844425 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457596 ETF423184 P A 5 1753.95 244 20.460 0 0 0 0.00 0 1766844449 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457603 PRC377397 P A 2 1763.48 236 9.850 0 0 0 0.00 0 1766844449 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457625 XTK406024 P A 2 1923.05 36 20.580 0 0 0 0.00 0 1766844449 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457657 QJD038854 P A 5 1057.78 321 20.630 0 0 0 0.00 0 1766844449 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457660 NKM170126 P A 5 2404.03 316 10.020 0 0 0 0.00 0 1766844449 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457678 AJB688658 P A 2 2123.54 475 15.150 0 0 0 0.00 0 1766844449 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457686 QGM925725 P A 2 1659.33 248 10.100 0 0 0 0.00 0 1766844449 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457753 JVI383763 P A 2 412.23 358 17.530 0 0 0 0.00 0 1766844473 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457758 XHR128343 P A 5 1103.44 454 11.530 0 0 0 0.00 0 1766844473 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457766 UDR727485 P A 5 364.39 374 13.800 0 0 0 0.00 0 1766844473 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N
457790 CHC634591 P A 2 930.18 96 19.310 0 0 0 0.00 0 1766844473 1766844425 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 N 0 1 Y N N N N 0 N