SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    8427, 7160, 8428, 8431, 9799, 8433, 8434, 
    8435, 8436, 8438, 8439, 8440, 8441, 
    8442, 7159, 8444, 8445, 8447, 8448, 
    8450, 10934, 7444, 7789, 7790
  )

Query time 0.00070

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_products",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "rows": 24,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (8427,7160,8428,8431,9799,8433,8434,8435,8436,8438,8439,8440,8441,8442,7159,8444,8445,8447,8448,8450,10934,7444,7789,7790)"
        }
      }
    ]
  }
}

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_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 ab__stickers_manual_ids ab__stickers_generated_ids image_extension fiscal_data_1212 mark_code_type
7159 997049 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
7160 997031 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
7444 997064 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475375 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
7789 997065 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475375 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
7790 997066 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475375 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8427 997030 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8428 997032 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8431 991034 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475373 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8433 997037 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8434 997038 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1746689367 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8435 997039 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8436 997040 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8438 997044 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8439 997045 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8440 997046 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8441 997047 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8442 997048 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8444 997051 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8445 997052 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8447 997055 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475375 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8448 997056 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475375 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
8450 997058 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475375 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
9799 997036 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475374 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1
10934 997061 P A 1 0.00 0 0.000 0 0 0 0.00 0 1617300338 1745475375 0 N N N N N N N Y 10 0 N N 0 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 0 0 Y jpg 1