SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    436654, 458480, 403102, 432285, 403973, 
    442807, 440814, 407763, 441694, 412081, 
    434268, 426164
  )

Query time 0.00042

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 (436654,458480,403102,432285,403973,442807,440814,407763,441694,412081,434268,426164)"
        }
      }
    ]
  }
}

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
403102 AUQ797431 P A 2 2160.93 264 6.480 0 0 0 0.00 0 1766827343 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
403973 PBZ074929 P A 5 898.45 425 24.260 0 0 0 0.00 0 1766827604 1766827563 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
407763 EFX303020 P A 2 741.39 392 24.780 0 0 0 0.00 0 1766828764 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
412081 EJB477483 P A 5 182.60 39 22.640 0 0 0 0.00 0 1766830028 1766829963 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
426164 PME273972 P A 2 800.31 154 15.060 0 0 0 0.00 0 1766834232 1766834162 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
432285 LQZ586669 P A 5 528.31 242 7.070 0 0 0 0.00 0 1766836083 1766836083 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
434268 DPH747424 P A 5 1387.44 138 1.780 0 0 0 0.00 0 1766836683 1766836682 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
436654 JFG213903 P A 2 1893.57 235 22.370 0 0 0 0.00 0 1766837404 1766837403 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
440814 ZIL507710 P A 2 769.14 399 2.680 0 0 0 0.00 0 1766838628 1766838603 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
441694 OKK142644 P A 5 1785.87 415 6.350 0 0 0 0.00 0 1766838890 1766838843 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
442807 MDN171538 P A 2 222.42 388 16.090 0 0 0 0.00 0 1766839227 1766839203 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
458480 ZWR597827 P A 5 379.89 26 23.440 0 0 0 0.00 0 1766844749 1766844723 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