SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    428427, 427728, 430953, 401174, 410003, 
    414674, 454104, 409191, 447293, 430593, 
    420431, 401982
  )

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.0216566,
    "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": 12,
          "cost": 0.0216566,
          "filtered": 100,
          "attached_condition": "cscart_products.product_id in (428427,427728,430953,401174,410003,414674,454104,409191,447293,430593,420431,401982)"
        }
      }
    ]
  }
}

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
401174 NSZ769714 P A 2 216.35 37 1.450 0 0 0 0.00 0 1766144439 1766826287 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
401982 CPC445246 P A 2 2435.18 285 5.680 0 0 0 0.00 0 1766827004 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
409191 YOY804552 P A 2 1249.53 220 4.560 0 0 0 0.00 0 1766829165 1766829122 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
410003 ZPS013997 P A 2 2039.18 203 23.080 0 0 0 0.00 0 1766829406 1766829362 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
414674 ZEG825330 P A 2 204.24 422 20.770 0 0 0 0.00 0 1766830803 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
420431 PAI316272 P A 2 2780.53 313 14.700 0 0 0 0.00 0 1766832526 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
427728 NMX450859 P A 2 1372.32 172 19.970 0 0 0 0.00 0 1766834712 1766834642 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
428427 MOW694406 P A 2 759.76 194 23.690 0 0 0 0.00 0 1766834929 1766834883 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
430593 TBH718017 P A 2 2328.43 271 24.760 0 0 0 0.00 0 1766835551 1766835482 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
430953 LGY334745 P A 2 1971.39 7 14.270 0 0 0 0.00 0 1766835673 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
447293 WCY402734 P A 2 1003.29 16 5.000 0 0 0 0.00 0 1766840573 1766840523 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
454104 RMT752146 P A 2 311.75 346 21.010 0 0 0 0.00 0 1766842612 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