SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    418429, 428304, 454998, 401192, 420138, 
    420200, 411483, 433250, 448259, 456498, 
    453797, 440607
  )

Query time 0.00028

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 (418429,428304,454998,401192,420138,420200,411483,433250,448259,456498,453797,440607)"
        }
      }
    ]
  }
}

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
401192 KES751066 P A 2 2112.74 54 3.950 0 0 0 0.00 0 1766144439 1766826417 0 N N N N N N N Y 10 0 N N 0 N N 0 0.000 1.000 Y 1766159521 1 Y N N N N 0 N
411483 GVA410642 P A 5 920.98 427 24.260 0 0 0 0.00 0 1766829865 1766829842 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
418429 BLI057953 P A 2 261.88 105 7.750 0 0 0 0.00 0 1766831926 1766831883 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
420138 VQY681482 P A 2 1113.80 464 0.670 0 0 0 0.00 0 1766832427 1766832363 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
420200 EDR898806 P A 2 1929.84 429 23.060 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
428304 RCK676270 P A 2 88.48 452 9.230 0 0 0 0.00 0 1766834884 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
433250 VMR759364 P A 5 2293.58 263 19.880 0 0 0 0.00 0 1766836369 1766836323 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
440607 LPA499026 P A 5 692.83 256 24.950 0 0 0 0.00 0 1766838554 1766838483 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
448259 BJR199587 P A 5 1843.06 275 4.410 0 0 0 0.00 0 1766840836 1766840763 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
453797 VBM655704 P A 2 2203.38 294 10.320 0 0 0 0.00 0 1766842520 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
454998 GEE735983 P A 2 690.43 140 6.360 0 0 0 0.00 0 1766842879 1766842803 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
456498 LEL403565 P A 2 2149.87 409 21.180 0 0 0 0.00 0 1766843330 1766843282 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