SELECT 
  cscart_products.*, 
  cscart_products.ebay_status, 
  cscart_products.ebay_template_id 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    18349, 18350, 18351, 18352, 18353, 18354, 
    18355, 18356, 18357, 18358, 18359, 
    18360, 18361, 18362, 18363, 18364
  )

Query time 0.00030

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 (18349,18350,18351,18352,18353,18354,18355,18356,18357,18358,18359,18360,18361,18362,18363,18364)"
    }
  }
}

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
18349 52940T4000 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 19 Y N 0 Letter N N unpaid 0 0 0 N
18350 52941T4000 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 43 Y N 0 Letter N N unpaid 0 0 0 N
18351 52960CU000 P A 1 0.00 0 0.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 87 Y N 0 Letter N N unpaid 0 0 0 N
18352 54551J5000 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 24 Y N 0 Letter N N unpaid 0 0 0 N
18353 54584J5000 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 13 Y N 0 Letter N N unpaid 0 0 0 N
18354 54810J5100 P A 1 0.00 0 30.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
18355 54813J5100 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 17 Y N 0 Letter N N unpaid 0 0 0 N
18356 54814J5000 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 37 Y N 0 Letter N N unpaid 0 0 0 N
18357 54815J5000 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 78 Y N 0 Letter N N unpaid 0 0 0 N
18358 54699G9500 P A 1 0.00 0 0.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 23 Y N 0 Letter N N unpaid 0 0 0 N
18359 54626J5000 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 13 Y N 0 Letter N N unpaid 0 0 0 N
18360 54630G9800 P A 1 0.00 0 7.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 19 Y N 0 Letter N N unpaid 0 0 0 N
18361 54650G9810 P A 1 0.00 0 8.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 87 Y N 0 Letter N N unpaid 0 0 0 N
18362 54660G9810 P A 1 0.00 0 8.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 97 Y N 0 Letter N N unpaid 0 0 0 N
18363 55307G9200 P A 1 0.00 0 6.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 86 Y N 0 Letter N N unpaid 0 0 0 N
18364 55325J5000 P A 1 0.00 0 0.700 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 25 Y N 0 Letter N N unpaid 0 0 0 N