SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2732, 2737, 2739, 2731, 2736, 2733, 2734, 
    2741, 2740, 2735, 2738, 2728
  )

Query time 0.00050

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 (2732,2737,2739,2731,2736,2733,2734,2741,2740,2735,2738,2728)"
    }
  }
}

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
2728 75440 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738231449 1741935736 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 75440 Y 0 0 0 75440 0 Y N N 0.00 a:0:{}
2731 75443 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738231802 1741935852 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 75443 Y 0 0 0 75443 0 Y N N 0.00 a:0:{}
2732 75444 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738233216 1741935819 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 75444 Y 0 0 0 75444 0 Y N N 0.00 a:0:{}
2733 75445 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738233903 1741935800 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 75445 Y 0 0 0 75445 0 Y N N 0.00 a:0:{}
2734 75446 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738234583 1741935789 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 75446 Y 0 0 0 75446 0 Y N N 0.00 a:0:{}
2735 75447 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738234764 1741935813 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 75447 Y 0 0 0 75447 0 Y N N 0.00 a:0:{}
2736 75448 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738234923 1741935785 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 75448 Y 0 0 0 75448 0 Y N N 0.00 a:0:{}
2737 75449 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738235314 1741935779 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 75449 Y 0 0 0 75449 0 Y N N 0.00 a:0:{}
2738 75450 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738235656 1741935824 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 75450 Y 0 0 0 75450 0 Y N N 0.00 a:0:{}
2739 75451 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738235767 1741935830 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 75451 Y 0 0 0 75451 0 Y N N 0.00 a:0:{}
2740 75452 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738235870 1741935795 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 75452 Y 0 0 0 75452 0 Y N N 0.00 a:0:{}
2741 75453 P A 1 0.00 1 0.000 0 0 0 0.00 0 1738235972 1741935774 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 75453 Y 0 0 0 75453 0 Y N N 0.00 a:0:{}