SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    433362, 439284, 446655, 419527, 420051, 
    423502, 419788, 424035, 441409, 443409, 
    408990, 457492
  )

Query time 0.00032

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 (433362,439284,446655,419527,420051,423502,419788,424035,441409,443409,408990,457492)"
        }
      }
    ]
  }
}

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
408990 QJM690186 P A 2 48.50 347 10.770 0 0 0 0.00 0 1766829123 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
419527 UIG567880 P A 2 992.06 192 21.860 0 0 0 0.00 0 1766832265 1766832242 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
419788 ZPW482243 P A 2 352.70 454 23.010 0 0 0 0.00 0 1766832308 1766832242 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
420051 VPN137474 P A 2 2189.55 494 12.750 0 0 0 0.00 0 1766832406 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
423502 UJK714815 P A 2 1935.62 31 22.680 0 0 0 0.00 0 1766833466 1766833442 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
424035 RGQ237631 P A 2 231.61 177 3.850 0 0 0 0.00 0 1766833607 1766833562 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
433362 RXS220610 P A 2 1737.12 217 16.460 0 0 0 0.00 0 1766836392 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
439284 BQS832632 P A 2 1529.06 324 0.860 0 0 0 0.00 0 1766838170 1766838122 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
441409 WTE647571 P A 2 777.43 341 20.260 0 0 0 0.00 0 1766838794 1766838723 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
443409 GHN816100 P A 2 77.71 168 6.290 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
446655 IYL782489 P A 2 1751.20 292 17.360 0 0 0 0.00 0 1766840356 1766840283 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