SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    11485, 10960, 10201, 397, 10188, 10353, 
    10355, 1655, 388, 395, 10163, 9871
  )

Query time 0.00051

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY,product_id_idx PRIMARY 3 12 Using index condition

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 shipping_availability_id ms_type master_id unit_price aval_status facebook_obj_type cp_additinal_product_enabled cp_additinal_product_items cp_delivery_date youtube_link show_youtube_video replace_main_image size_chart_id staff_notes emo_pn emo_paczka emo_dostawca emo_kreskowy emo_nrdostawcy emo_uwagi emo_source
388 ODF 8725 A 1 0.00 0.00 0.000 0 0 0 0.00 0 1451741493 1743601035 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 0 p/u: 17/02/2020 AD 14.11.2023 Włączone ponownie 0
395 ODF 8778 A 1 0.00 0.00 0.000 0 0 0 0.00 0 1453455541 1743601035 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 0 25.10.2022 mk price update/akt cen + 13% 0
397 ODF 87DL A 1 0.00 0.00 0.000 0 0 0 0.00 0 1453193674 1743601021 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"828798611":{"product_id":"706","amount":"0","modifier":"0","modifier_type":"A"},"1601861446":{"product_id":"717","amount":"0","modifier":"0","modifier_type":"A"},"989859408":{"product_id":"10389","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 25.10.2022 mk price update/akt cen + 6% 0
1655 ODF 8747 P A 1 0.00 0.00 0.000 0 0 0 0.00 0 1451742027 1743601031 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"429948050":{"product_id":"10011","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 25.10.2022 mk price update/akt cen + 18% 0
9871 ODF 871X P A 1 0.00 1.00 0.000 0 0 0 0.00 0 1453975087 1743601047 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 0 25.10.2022 mk price update/akt cen + 8% 0
10163 ODF 875A A 1 0.00 0.00 0.000 0 0 0 0.00 0 1490345426 1743601036 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 0 activity N [] 0 N N 0 25.10.2022 mk price update/akt cen + 12% 0
10188 ODF 87DF A 1 0.00 0.00 0.000 0 0 0 0.00 0 1500975809 1743601022 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"1579586812":{"product_id":"709","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 08.07.2022 mk akt zdjęć 18.07.2022 mk aktualizacja treści 25.10.2022 mk price update/akt cen + 16% 0
10201 ODF 87DJ P A 1 0.00 0.00 0.000 0 0 0 0.00 0 1520854537 1743601020 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"828798611":{"product_id":"706","amount":"0","modifier":"0","modifier_type":"A"},"556170291":{"product_id":"4939","amount":"0","modifier":"0","modifier_type":"A"},"1601861446":{"product_id":"717","amount":"0","modifier":"0","modifier_type":"A"},"1897124715":{"product_id":"10104","amount":"0","modifier":"0","modifier_type":"A"},"989859408":{"product_id":"10389","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 08.07.2022 mk akt zdjęć 18.07.2022 mk akt. treści 25.10.2022 mk - price update/akt cen + 6% 0
10353 ODF 87DN P A 1 0.00 1.00 0.000 0 0 0 0.00 0 1558437044 1743601023 0 N N N O N R N N N Y 10 0 N 1 0 1 0 6 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 0 0 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"1579586812":{"product_id":"709","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 08.07.2022 mk akt zdjęć 18.07.2022 mk małe poprawki w treści 25.10.2022 mk price update/akt cen + 15% 0
10355 ODF 87DH P A 1 0.00 1.00 0.000 0 0 0 0.00 0 1558437295 1743601026 0 N N N O N R N N N Y 10 0 N 1 0 1 0 6 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 0 0 0 activity Y {"485452311":{"product_id":"10711","amount":"1","modifier":"0","modifier_type":"A"},"1579586812":{"product_id":"709","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 25.10.2022 mk price update/akt cen + 17% 0
10960 ODF-87WT A 1 0.00 0.00 0.000 0 0 0 0.00 0 1697790340 1748952145 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 10 activity Y {"1725723642":{"product_id":"11199","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 0 AD 15.12 Wir arbeiten ganz viel. 0
11485 ODF-87WN A 1 0.00 0.00 0.000 0 0 0 0.00 0 1743666981 1748952156 0 N N N O N R N N N Y 10 0 N 0 0 0 0 6 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 M 0 26 10 activity Y {"1725723642":{"product_id":"11199","amount":"1","modifier":"0","modifier_type":"A"}} 0 N N 0 AD 15.12 Wir arbeiten ganz viel. 0