SELECT 
  cscart_products.*, 
  cscart_products.ebay_status, 
  cscart_products.ebay_template_id 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    282971, 286602, 283081, 283125, 286561, 
    282507, 283098, 286611, 279396, 282889, 
    282945, 286621, 277944, 286500, 286533, 
    284472, 286574, 279355, 278025, 278209, 
    285797, 279438, 270384, 281368, 270320, 
    286493, 277872, 286557, 278250, 278190, 
    285798, 285799, 285796, 285794, 286704, 
    281369
  )

Query time 0.00146

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "50.64"
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 36,
      "rows_produced_per_join": 36,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "43.44",
        "eval_cost": "7.20",
        "prefix_cost": "50.64",
        "data_read_per_join": "281K"
      },
      "used_columns": [
        "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",
        "master_product_id",
        "master_product_status",
        "master_product_offers_count",
        "prestashop_product_id",
        "prestashop_account_id",
        "prestashop_is_parent",
        "amz_condition",
        "amz_condition_note",
        "amz_product_id",
        "amz_product_id_type",
        "transfer_price",
        "tax_value",
        "ebay_template_id",
        "product_hash",
        "ebay_price",
        "package_type",
        "ebay_status",
        "ebay_override_price",
        "subscription_product",
        "interval",
        "interval_count",
        "ec_rfq_product_type",
        "ec_rfq_service_options"
      ],
      "attached_condition": "(`webmarco`.`cscart_products`.`product_id` in (282971,286602,283081,283125,286561,282507,283098,286611,279396,282889,282945,286621,277944,286500,286533,284472,286574,279355,278025,278209,285797,279438,270384,281368,270320,286493,277872,286557,278250,278190,285798,285799,285796,285794,286704,281369))"
    }
  }
}

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 master_product_id master_product_status master_product_offers_count prestashop_product_id prestashop_account_id prestashop_is_parent amz_condition amz_condition_note amz_product_id amz_product_id_type transfer_price tax_value ebay_template_id product_hash ebay_price package_type ebay_status ebay_override_price subscription_product interval interval_count ec_rfq_product_type ec_rfq_service_options
270320 WM2339VH P A 539 0.00 1 0.000 0 0 0 0.00 0 1649855748 1662823570 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 3915738631 Letter N N day P
270384 WM6681DY P A 539 0.00 1 0.000 0 0 0 0.00 0 1649947599 1660242475 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 2963520550 Letter N P
277872 WM2764WT_3892 P A 539 0.00 1 0.000 0 0 0 0.00 0 1654865462 1660567363 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 269251593 Letter N P
277944 WM2439MV_D4F9 P A 539 0.00 1 0.000 0 0 0 0.00 0 1654871169 1659448534 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 3813421008 Letter N P
278025 WM9842WQ_D303 P A 539 0.00 1 0.000 0 0 0 0.00 0 1654874290 1659448986 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 1683724277 Letter N P
278190 WM7996PG_845E P A 539 0.00 1 0.000 0 0 0 0.00 0 1654951585 1660567486 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 1175170428 Letter N P
278209 WM6860ZC_3449 P A 539 0.00 1 0.000 0 0 0 0.00 0 1654955419 1660567283 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 3010402692 Letter N P
278250 WM6873PM_A276 P A 539 0.00 1 0.000 0 0 0 0.00 0 1654964750 1660567627 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 3176067372 Letter N P
279355 WM7785RP_BF39 P A 539 0.00 1 0.000 0 0 0 0.00 0 1655116836 1659448576 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 2594574190 Letter N N day P
279396 WM1362HF_E13C P A 539 0.00 1 0.000 0 0 0 0.00 0 1655122734 1659202550 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 633937547 Letter N N day P
279438 WM1211ZN_FA0E P A 539 0.00 1 0.000 0 0 0 0.00 0 1655124113 1659448649 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 3793354621 Letter N P
281368 WM2492IH P A 539 0.00 1 0.000 0 0 0 0.00 0 1655300450 1658216879 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 51921716 Letter N P
281369 WM6256FJ P A 539 0.00 1 0.000 0 0 0 0.00 0 1655302853 1658217150 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 3023984041 Letter N P
282507 WM3491PK_7E78 P A 539 0.00 1 0.000 0 0 0 0.00 0 1655809246 1659449169 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 1234462683 Letter N P
282889 WM0270VM P A 539 0.00 1 0.000 0 0 0 0.00 0 1655992757 1658306178 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 2303508918 Letter N N day P
282945 WM1613WZ_8B0B P A 539 0.00 1 0.000 0 0 0 0.00 0 1655995101 1658245997 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 889494784 Letter N N day P
282971 WM7879BE P A 539 0.00 1 0.000 0 0 0 0.00 0 1655996043 1658141813 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 1198512009 Letter N P
283081 WM7110FU P A 539 0.00 1 0.000 0 0 0 0.00 0 1656073221 1658222715 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 1041457239 Letter N P
283098 WM0450PY P A 539 0.00 1 0.000 0 0 0 0.00 0 1656076249 1658220936 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 3065865469 Letter N P
283125 WM2042AP P A 539 0.00 1 0.000 0 0 0 0.00 0 1656077806 1658222760 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 1750005039 Letter N P
284472 WM6355AI_E331 P A 539 0.00 1 0.000 0 0 0 0.00 0 1656440609 1659450109 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 365176423 Letter N P
285794 WM5355HY P A 539 0.00 1 0.000 0 0 0 0.00 0 1656687311 1658238283 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 3449115230 Letter N P
285796 WM5252UV P A 539 0.00 1 0.000 0 0 0 0.00 0 1656688319 1658239142 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 2987167711 Letter N P
285797 WM5014FG P A 539 0.00 1 0.000 0 0 0 0.00 0 1656689329 1686148552 0 Y N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 3760099234 Letter N N day P
285798 WM2972UQ P A 539 0.00 1 0.000 0 0 0 0.00 0 1656690491 1658240567 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 1531942921 Letter N P
285799 WM3003HJ P A 539 0.00 1 0.000 0 0 0 0.00 0 1656691063 1658240313 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} activity 0 0 A 0 0 0 Y 0.00 0.00 0 709569303 Letter N P
286493 WM7505ZZ P A 539 0.00 1 0.000 0 0 0 0.00 0 1659106634 1659346726 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 4201451085 Letter N P
286500 WM5662IS_280E P A 539 0.00 1 0.000 0 0 0 0.00 0 1659199299 1659199488 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 156926683 Letter N P
286533 WM1587PH P A 539 0.00 1 0.000 0 0 0 0.00 0 1659451517 1659451899 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 1716833492 Letter N P
286557 WM7794TA_EEC1 P A 539 0.00 1 0.000 0 0 0 0.00 0 1659551521 1660568314 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 529694689 Letter N P
286561 WM5819ZX_1298 P A 539 0.00 1 0.000 0 0 0 0.00 0 1659553286 1659555507 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 2950804060 Letter N P
286574 WM0523GP_E920 P A 539 0.00 1 0.000 0 0 0 0.00 0 1659554826 1660568587 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 2556451588 Letter N P
286602 WM4356HP_0DA0 P A 539 0.00 1 0.000 0 0 0 0.00 0 1659705585 1660568170 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 1714825049 Letter N P
286611 WM7387OB_757D P A 539 0.00 1 0.000 0 0 0 0.00 0 1659707240 1660568106 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 1968437089 Letter N P
286621 WM9338RY_3C3A P A 539 0.00 1 0.000 0 0 0 0.00 0 1659708295 1660567817 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 3432777083 Letter N P
286704 WM3230JQ P A 539 0.00 1 0.000 0 0 0 0.00 0 1661092046 1661092167 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F 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;} product 0 0 A 0 0 0 Y 0.00 0.00 0 188568059 Letter N N day P