SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    12574, 12550, 12544, 12564, 12577, 12579, 
    12555, 12560, 12556, 12561, 12572, 
    12583, 12591, 12582, 12590, 12571, 
    12632, 12559, 12631, 15938
  )

Query time 0.00071

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": 20,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (12574,12550,12544,12564,12577,12579,12555,12560,12556,12561,12572,12583,12591,12582,12590,12571,12632,12559,12631,15938)"
    }
  }
}

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 fiscal_data_1212 mark_code_type parent_product_id yml2_brand yml2_origin_country yml2_store yml2_pickup yml2_delivery yml2_adult yml2_delivery_options yml2_bid 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 units_in_product show_price_per_x_units source_import_key is_stock_split_by_warehouses ab__stickers_manual_ids ab__stickers_generated_ids allow_fractional_amount product_amount_step sale_type
12544 43 P A 1 0.00 3 8.000 0 0 0 0.00 0 1605105199 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:18;s:9:"box_width";i:18;s:10:"box_height";i:160;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,42,43,44 1
12550 58 P A 1 0.00 3 8.000 0 0 0 0.00 0 1605105199 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:18;s:9:"box_width";i:18;s:10:"box_height";i:160;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33 1
12555 69900 P A 1 0.00 11 8.000 0 0 0 0.00 0 1605105199 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:18;s:9:"box_width";i:18;s:10:"box_height";i:160;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,73,42,43,44 1
12556 69901 P A 1 0.00 10 8.000 0 0 0 0.00 0 1605105199 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:18;s:9:"box_width";i:18;s:10:"box_height";i:160;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,42,43,44 1
12559 69908 P A 1 0.00 6 8.000 0 0 0 0.00 0 1605105199 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:18;s:9:"box_width";i:18;s:10:"box_height";i:160;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,73,42,43 1
12560 70107 P A 1 0.00 5 11.000 0 0 0 0.00 0 1608728571 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:22;s:9:"box_width";i:22;s:10:"box_height";i:200;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,72,42,43,44 1
12561 70108 P A 1 0.00 11 11.000 0 0 0 0.00 0 1608729939 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:22;s:9:"box_width";i:22;s:10:"box_height";i:200;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,42,43,44 1
12564 72054 P A 1 0.00 3 0.000 0 0 0 0.00 0 1638524547 1776154757 0 N N N B N R Y N N Y 10 0 B 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,42,43,44 1
12571 72159 P A 1 0.00 5 0.000 0 0 0 0.00 0 1623418654 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 30,33,72,42,43,44 1
12572 72160 P A 1 0.00 4 0.000 0 0 0 0.00 0 1623421941 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 30,33,42,43,44 1
12574 72166 P A 1 0.00 5 0.000 0 0 0 0.00 0 1712927954 1776154757 0 N N N B N R Y N N Y 10 0 B 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 30,33,42,43,44 1
12577 72771 P A 1 0.00 13 8.000 0 0 0 0.00 0 1605105199 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:18;s:9:"box_width";i:18;s:10:"box_height";i:160;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,73,42,43,44 1
12579 72825 P A 1 0.00 6 0.000 0 0 0 0.00 0 1639672983 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,42,43,44 1
12582 73221 P A 1 0.00 7 0.000 0 0 0 0.00 0 1658329887 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,3 1
12583 73222 P A 1 0.00 10 0.000 0 0 0 0.00 0 1658329641 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,30,73,42,43,44 1
12590 73526 P A 1 0.00 8 0.000 0 0 0 0.00 0 1671727083 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,3 1
12591 73527 P A 1 0.00 6 0.000 0 0 0 0.00 0 1671727009 1776154757 0 N N N B N R Y N N Y 10 0 S 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,3,42,43,44 1
12631 74850 P A 1 0.00 1 0.000 0 0 0 0.00 0 1741965440 1776154757 0 N N N B N R Y N N Y 10 0 N 0 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 42,43,44 1
12632 74851 P A 1 0.00 2 0.000 0 0 0 0.00 0 1717058161 1776154757 0 N N N B N R Y N N Y 10 0 N 1 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 Y 33,3 1
15938 1111138 P A 1 0.00 3 0.000 0 0 0 0.00 0 1708421155 1776154757 0 N N N B N R Y N N Y 10 0 N 0 0 7 N 0 P F 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;} 1 0 N a:0:{} 0 0 Y 0.000 1.000 N N 0