SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    452645, 442668, 451860, 438623, 447040, 
    419169, 420289, 433472, 450998, 425857, 
    410176, 457277
  )

Query time 0.00069

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 (452645,442668,451860,438623,447040,419169,420289,433472,450998,425857,410176,457277)"
        }
      }
    ]
  }
}

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
410176 QGS431733 P A 2 105.67 379 2.170 0 0 0 0.00 0 1766829485 1766829483 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
419169 ODX255680 P A 2 2771.29 138 6.420 0 0 0 0.00 0 1766832145 1766832122 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
420289 GUB835800 P A 5 119.37 110 20.880 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
425857 OFY985701 P A 5 44.66 127 24.000 0 0 0 0.00 0 1766834163 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
433472 UNF993219 P A 2 354.93 62 11.280 0 0 0 0.00 0 1766836443 1766836442 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
438623 GTR998824 P A 5 531.76 298 14.940 0 0 0 0.00 0 1766837953 1766837883 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
442668 ZCC133655 P A 5 17.38 301 12.420 0 0 0 0.00 0 1766839204 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
447040 FCZ447344 P A 2 308.19 292 22.150 0 0 0 0.00 0 1766840479 1766840403 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
450998 QIZ408715 P A 2 1402.15 154 2.110 0 0 0 0.00 0 1766841676 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
451860 UBJ396994 P A 2 1399.23 319 15.520 0 0 0 0.00 0 1766841915 1766841843 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
452645 QSC771510 P A 5 664.51 441 5.400 0 0 0 0.00 0 1766842156 1766842082 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
457277 MTU507120 P A 5 642.71 85 8.730 0 0 0 0.00 0 1766843548 1766843790 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