SELECT 
  cscart_products.*, 
  cscart_products.ebay_status, 
  cscart_products.ebay_template_id 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    10656, 10657, 10658, 10659, 10660, 10661, 
    10662, 10663, 10664, 10671, 10673, 
    10675, 10676, 10677, 10678, 10679
  )

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 16,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (10656,10657,10658,10659,10660,10661,10662,10663,10664,10671,10673,10675,10676,10677,10678,10679)"
    }
  }
}

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 facebook_obj_type parent_product_id buy_now_url units_in_product show_price_per_x_units payment_ids staff_notes purchase_qty social_proof_popup_product_output ab__stickers_manual_ids ab__stickers_generated_ids is_stock_split_by_warehouses ebay_template_id product_hash ebay_price package_type ebay_status ebay_override_price is_invoice ei_for_user_id ei_status ei_order_id cp_in_stock_status cp_in_stock_specific_status cp_out_of_stock_status cp_out_of_stock_specific_status cp_extended_marketing_prohibit_review mb_ai_registration_job_id
10656 91961T1260 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 49 Y N 0 Letter N N unpaid 0 0 0 N
10657 91961T1270 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 61 Y N 0 Letter N N unpaid 0 0 0 N
10658 91961T1630 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 92 Y N 0 Letter N N unpaid 0 0 0 N
10659 91961T1640 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 91 Y N 0 Letter N N unpaid 0 0 0 N
10660 91961T1650 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 34 Y N 0 Letter N N unpaid 0 0 0 N
10661 91961T1660 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 57 Y N 0 Letter N N unpaid 0 0 0 N
10662 91961T1700 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 4 Y N 0 Letter N N unpaid 0 0 0 N
10663 91961T1670 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 60 Y N 0 Letter N N unpaid 0 0 0 N
10664 91961T1210 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 11 Y N 0 Letter N N unpaid 0 0 0 N
10671 919G5T1310 P A 1 0.00 0 0.800 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 98 Y N 0 Letter N N unpaid 0 0 0 N
10673 91981C5030 P A 1 0.00 0 0.200 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 99 Y N 0 Letter N N unpaid 0 0 0 N
10675 91961T1190 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 67 Y N 0 Letter N N unpaid 0 0 0 N
10676 91981T1040 P A 1 0.00 0 0.200 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 28 Y N 0 Letter N N unpaid 0 0 0 N
10677 91981A9080 P A 1 0.00 0 0.200 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 38 Y N 0 Letter N N unpaid 0 0 0 N
10678 91961T1200 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 23 Y N 0 Letter N N unpaid 0 0 0 N
10679 91961T1130 P A 1 0.00 0 1.500 0 0 0 0.00 0 1715914159 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 55 Y N 0 Letter N N unpaid 0 0 0 N