SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2785, 2783, 2779, 2780, 2782, 2781, 2786, 
    2784, 2777, 2616, 2615, 2778
  )

Query time 0.00055

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": 12,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (2785,2783,2779,2780,2782,2781,2786,2784,2777,2616,2615,2778)"
    }
  }
}

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 yml2_brand yml2_origin_country yml2_store yml2_pickup yml2_delivery yml2_adult yml2_delivery_options yml2_bid yml2_cbid yml2_fee yml2_model yml2_sales_notes yml2_type_prefix yml2_offer_type yml2_market_category yml2_manufacturer_warranty yml2_expiry yml2_purchase_price yml2_description yml2_cpa buy_now_url external_id update_1c ab__stickers_manual_ids ab__stickers_generated_ids coloristica_id allow_fractional_amount product_amount_step sale_type my_supplier_id supplier_amount manufacturer_code supplier_access_count rf_stop_update_price rf_stop_update_amount rf_stop_update_status rf_cost gr__fe09_pickup_options
2615 74852 P A 1 0.00 2 0.000 0 0 0 0.00 0 1717050515 1741947674 0 N N N B N R Y N N Y 10 0 N 1 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74852 Y 30,33 74852 1 0 0 0 Y N N 0.00 a:0:{}
2616 74851 P A 1 0.00 2 0.000 0 0 0 0.00 0 1717050961 1741947647 0 N N N B N R Y N N Y 10 0 N 1 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74851 Y 33,30 74851 1 0 0 0 Y N N 0.00 a:0:{}
2777 74994 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742211920 1742218834 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74994 Y 74994 1 0 0 74994 0 Y N N 0.00 a:0:{}
2778 74986 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742215534 1742216061 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74986 Y 74986 1 0 0 74986 0 Y N N 0.00 a:0:{}
2779 74989 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742216076 1742987483 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74989 Y 74989 1 0 0 74989 0 Y N N 0.00 a:0:{}
2780 74996 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742216211 1742987404 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74996 Y 74996 1 0 0 74996 0 Y N N 0.00 a:0:{}
2781 74997 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742216457 1742219068 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74997 Y 74997 1 0 0 74997 0 Y N N 0.00 a:0:{}
2782 74990 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742218920 1742219056 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74990 Y 74990 1 0 0 74990 0 Y N N 0.00 a:0:{}
2783 74991 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742219341 1742220161 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74991 Y 74991 1 0 0 74991 0 Y N N 0.00 a:0:{}
2784 74999 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742220166 1742220300 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74999 Y 74999 1 0 0 74999 0 Y N N 0.00 a:0:{}
2785 74995 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742220403 1742220834 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74995 Y 74995 1 0 0 74995 0 Y N N 0.00 a:0:{}
2786 74988 P A 1 0.00 1 0.000 0 0 0 0.00 0 1742220625 1742220811 0 N N N B N R Y N N Y 10 0 N 0 0 0 0 7,10 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;} 0 N a:0:{} 0 0 0 0 Y 74988 Y 74988 1 0 0 74988 0 Y N N 0.00 a:0:{}