SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    13460, 13488, 13461, 13489, 13462, 13490, 
    13463, 13491, 13464, 13492, 13465, 
    13493, 13466, 13494
  )

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.02513418,
    "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": 14,
          "cost": 0.02513418,
          "filtered": 100,
          "attached_condition": "cscart_products.product_id in (13460,13488,13461,13489,13462,13490,13463,13491,13464,13492,13465,13493,13466,13494)"
        }
      }
    ]
  }
}

Result

product_id product_code product_type status bigbuy_product_id 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 facebook_obj_type parent_product_id buy_now_url units_in_product show_price_per_x_units ab__stickers_manual_ids ab__stickers_generated_ids wc_free_shipping wc_product_id nt_bigbuy_product_id nt_is_synced nt_zap_update_timestamp shopify_product_id shopify_account_id shopify_is_parent
13460 122_3M22 P A 0 942 0.00 5 0.000 0 0 0 0.00 0 1741952874 1744383036 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 1.000 N 0 0 N 0 0 0 Y
13461 123_3M23 P A 0 942 9.50 5 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 1.000 N 0 0 N 0 0 0 Y
13462 124_3M24 P A 0 942 9.50 5 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 1.000 N 0 0 N 0 0 0 Y
13463 125_3M24 P A 0 942 10.00 15 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 1.000 N 0 0 N 0 0 0 Y
13464 126_3M24 P A 0 942 6.00 15 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 1.000 N 0 0 N 0 0 0 Y
13465 127_3M24 P A 0 942 7.50 15 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 1.000 N 0 0 N 0 0 0 Y
13466 128_3M24 V A 0 942 12.00 5 0.000 0 0 0 0.00 0 1741952874 1744385640 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 13494 0.000 1.000 N 0 0 N 0 0 0 Y
13488 122_10M2 V A 0 942 0.00 5 0.000 0 0 0 0.00 0 1741952874 1744383036 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 13460 0.000 1.000 N 0 0 N 0 0 0 Y
13489 123_10M3 V A 0 942 0.00 5 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 13461 0.000 1.000 N 0 0 N 0 0 0 Y
13490 124_10M4 V A 0 942 0.00 5 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 13462 0.000 1.000 N 0 0 N 0 0 0 Y
13491 125_10M5 V A 0 942 0.00 15 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 13463 0.000 1.000 N 0 0 N 0 0 0 Y
13492 126_10M6 V A 0 942 0.00 15 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 13464 0.000 1.000 N 0 0 N 0 0 0 Y
13493 127_10M7 V A 0 942 0.00 15 0.000 0 0 0 0.00 0 1741952874 1744818321 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 13465 0.000 1.000 N 0 0 N 0 0 0 Y
13494 128_10M8 P A 0 942 0.00 5 0.000 0 0 0 0.00 0 1741952874 1744385640 0 N N N N N N N Y 3 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 1.000 N 0 0 N 0 0 0 Y