SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    427186, 437962, 413207, 434226, 413616, 
    400971, 429866, 439522, 404231, 420223, 
    402063, 434025, 453641, 414955, 407875, 
    430665, 451077, 403015, 438963, 450825, 
    401687, 443424, 427907, 457801, 454192, 
    427353, 414432, 436128, 421748, 421122, 
    417392, 431455
  )

Query time 0.00079

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.0564324,
    "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": 32,
          "cost": 0.0564324,
          "filtered": 100,
          "attached_condition": "cscart_products.product_id in (427186,437962,413207,434226,413616,400971,429866,439522,404231,420223,402063,434025,453641,414955,407875,430665,451077,403015,438963,450825,401687,443424,427907,457801,454192,427353,414432,436128,421748,421122,417392,431455)"
        }
      }
    ]
  }
}

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
400971 HKG635395 P A 1 53.25 138 7.730 0 0 0 0.00 0 1766144404 1766825777 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 Y 1766394961 1 Y N N N N 0 N
401687 FJF926916 P A 5 773.92 249 19.970 0 0 0 0.00 0 1766826870 1766826810 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
402063 JGG990607 P A 5 1901.39 270 12.540 0 0 0 0.00 0 1766827024 1766826962 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
403015 PYG989512 P A 2 245.77 171 19.560 0 0 0 0.00 0 1766827323 1766827322 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
404231 PER082838 P A 2 32.59 32 16.960 0 0 0 0.00 0 1766827648 1766827647 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
407875 BOB594199 P A 5 2027.33 255 21.420 0 0 0 0.00 0 1766828786 1766828763 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
413207 KQE102050 P A 2 1638.23 352 15.140 0 0 0 0.00 0 1766830366 1766830323 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
413616 KKD762332 P A 2 1695.86 439 7.030 0 0 0 0.00 0 1766830487 1766830443 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
414432 WIO867209 P A 5 1942.14 228 5.410 0 0 0 0.00 0 1766830726 1766830683 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
414955 ZNK798954 P A 5 887.91 274 5.520 0 0 0 0.00 0 1766830870 1766830803 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
417392 KEX613377 P A 5 533.30 85 4.700 0 0 0 0.00 0 1766831644 1766831643 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
420223 IEE504945 P A 2 96.14 267 19.840 0 0 0 0.00 0 1766832483 1766832483 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
421122 VMW852709 P A 2 402.30 368 5.640 0 0 0 0.00 0 1766832744 1766832722 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
421748 OMY568795 P A 2 1854.78 250 16.690 0 0 0 0.00 0 1766832909 1766832845 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
427186 AEP827845 P A 5 2253.90 10 17.140 0 0 0 0.00 0 1766834545 1766834522 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
427353 RKE218506 P A 5 1503.64 41 21.690 0 0 0 0.00 0 1766834589 1766834522 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
427907 OKC020861 P A 2 797.35 214 1.850 0 0 0 0.00 0 1766834763 1766834763 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
429866 EJY739558 P A 5 641.99 174 7.330 0 0 0 0.00 0 1766835363 1766835363 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
430665 SZV296006 P A 5 657.37 305 16.090 0 0 0 0.00 0 1766835604 1766835603 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
431455 ZNF323101 P A 5 728.31 293 17.580 0 0 0 0.00 0 1766835844 1766835843 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
434025 FBN668940 P A 5 630.98 368 1.960 0 0 0 0.00 0 1766836586 1766836563 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
434226 DQS157963 P A 5 2056.82 183 12.030 0 0 0 0.00 0 1766836632 1766836563 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
436128 OYK706576 P A 2 1289.90 254 0.830 0 0 0 0.00 0 1766837210 1766837163 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
437962 CPI270830 P A 2 185.18 474 9.980 0 0 0 0.00 0 1766837789 1766837765 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
438963 SEH926000 P A 2 1789.87 189 22.120 0 0 0 0.00 0 1766838074 1766838003 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
439522 RLV488175 P A 2 379.96 399 18.600 0 0 0 0.00 0 1766838243 1766838242 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
443424 LUL311622 P A 2 139.08 361 5.610 0 0 0 0.00 0 1766839392 1766839322 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
450825 RWE363209 P A 2 1461.93 212 15.780 0 0 0 0.00 0 1766841628 1766841603 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
451077 AZY802960 P A 5 1239.68 292 24.860 0 0 0 0.00 0 1766841723 1766841723 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
453641 DVZ322088 P A 5 1571.70 230 6.020 0 0 0 0.00 0 1766842468 1766842442 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
454192 MRP121577 P A 5 1302.93 153 5.270 0 0 0 0.00 0 1766842636 1766842563 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
457801 TSP604500 P A 2 619.78 348 24.800 0 0 0 0.00 0 1766844497 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