SELECT 
  cscart_products.*, 
  cscart_products.ebay_status, 
  cscart_products.ebay_template_id 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    22063, 22064, 22065, 22066, 22067, 22068, 
    22069, 22070, 22071, 22072, 22073, 
    22074, 22075, 22076, 22077, 22078
  )

Query time 0.00035

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 (22063,22064,22065,22066,22067,22068,22069,22070,22071,22072,22073,22074,22075,22076,22077,22078)"
    }
  }
}

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
22063 252802T001 P A 1 0.00 0 0.800 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 1 Y N 0 Letter N N unpaid 0 0 0 N
22064 252812T001 P A 1 0.00 0 0.800 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 27 Y N 0 Letter N N unpaid 0 0 0 N
22065 25310AR000 P A 1 0.00 0 23.300 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 24 Y N 0 Letter N N unpaid 0 0 0 N
22066 253L0AR200 P A 1 0.00 0 23.300 0 0 0 0.00 0 1715937452 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
22067 25336AR000 P A 1 0.00 0 0.200 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 58 Y N 0 Letter N N unpaid 0 0 0 N
22068 25380AR000 P A 1 0.00 0 20.000 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 95 Y N 0 Letter N N unpaid 0 0 0 N
22069 253S3AR000 P A 1 0.00 0 0.400 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 47 Y N 0 Letter N N unpaid 0 0 0 N
22070 25414AR000 P A 1 0.00 0 1.000 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 17 Y N 0 Letter N N unpaid 0 0 0 N
22071 25415AR000 P A 1 0.00 0 1.000 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 63 Y N 0 Letter N N unpaid 0 0 0 N
22072 25430AR000 P A 1 0.00 0 3.000 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 12 Y N 0 Letter N N unpaid 0 0 0 N
22073 25450AR000 P A 1 0.00 0 0.800 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 81 Y N 0 Letter N N unpaid 0 0 0 N
22074 25450AR050 P A 1 0.00 0 0.800 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 27 Y N 0 Letter N N unpaid 0 0 0 N
22075 254E0AR000 P A 1 0.00 0 4.500 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 62 Y N 0 Letter N N unpaid 0 0 0 N
22076 254L5AR000 P A 1 0.00 0 0.800 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 N 0 0 0.000 1.000 0 100 Y N 0 Letter N N unpaid 0 0 0 N
22077 254W0AR000 P A 1 0.00 0 4.500 0 0 0 0.00 0 1715937452 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
22078 291B0AR000 P A 1 0.00 0 11.800 0 0 0 0.00 0 1715937452 1721911507 0 N N N N N N N N Y 14 0 B 9 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 0 34 Y N 0 2638975717 Letter N N unpaid 0 0 0 N