SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    10012, 718, 9967, 9844, 710, 720, 9931, 
    9840, 719, 715, 10946, 9964
  )

Query time 0.00046

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
710 ODF-850110 A 1 0.00 0.00 2.000 0 0 0 0.00 0 1454489575 1743601054 0 N N N B 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 1 activity N [] 0 N N 0 p/u: 12/02/2020 15.07.2022 MK AKT ZDJ 0
715 fkr-zwl A 1 0.00 0.00 2.000 0 0 0 0.00 0 1454489616 1743601059 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 10 activity N [] 0 2Ye7x6Jb7gw N N 0 p/u: 17/02/2020 0
718 ODF-850045 P A 1 0.00 0.00 2.000 0 0 0 0.00 0 1454489874 1743601052 0 N N N B 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 10 activity N [] 0 N N 0 p/u: 17/02/2020 0
719 ODF-850039 A 1 0.00 0.00 2.000 0 0 0 0.00 0 1454489895 1743601057 0 N N N B 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 6 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"365711066":{"product_id":"720","amount":"0","modifier":"0","modifier_type":"A"},"1657503308":{"product_id":"721","amount":"0","modifier":"0","modifier_type":"A"},"1371844437":{"product_id":"9969","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 p/u: 17/02/2020 0
720 ODF-55036 A 1 0.00 0.00 2.000 0 0 0 0.00 0 1454489941 1743601055 0 N N N B 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 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1195222461":{"product_id":"719","amount":"0","modifier":"0","modifier_type":"A"},"1657503308":{"product_id":"721","amount":"0","modifier":"0","modifier_type":"A"},"1371844437":{"product_id":"9969","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 p/u: 17/02/2020 0
9840 ODV-RML P A 1 0.00 0.00 10.000 0 0 0 0.00 0 1452344462 1743601059 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 {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1368141388":{"product_id":"10065","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
9844 ODV-DML P A 1 0.00 0.00 10.000 0 0 0 0.00 0 1452344463 1743601055 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 {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1368141388":{"product_id":"10065","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
9931 fak-ak-arf-zw P A 1 0.00 1.00 0.000 0 0 0 0.00 0 1455967179 1743601055 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 0 0 activity Y {"1477948253":{"product_id":"713","amount":"0","modifier":"0","modifier_type":"A"},"1239821711":{"product_id":"711","amount":"0","modifier":"0","modifier_type":"A"},"1054940441":{"product_id":"710","amount":"0","modifier":"0","modifier_type":"A"},"1323590716":{"product_id":"10232","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
9964 ODF-850036 P A 1 0.00 1.00 4.000 0 0 0 0.00 0 1458030329 1743601061 0 N N N B 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 0 10 activity Y {"679299028":{"product_id":"716","amount":"0","modifier":"0","modifier_type":"A"},"1477948253":{"product_id":"713","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 p/u: 17/02/2020 0
9967 ODF 62073 P A 1 0.00 1.00 1.000 0 0 0 0.00 0 1458042848 1743601053 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 0 5 activity N [] 0 N N 0 p/u: 17/02/2020 14.07.2022 MK AKT ZDJ 0
10012 fak-ak-amz-z-wave P A 1 0.00 0.00 0.000 0 0 0 0.00 0 1460192679 1743601051 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 0 0 activity Y {"679299028":{"product_id":"716","amount":"0","modifier":"0","modifier_type":"A"},"1477948253":{"product_id":"713","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 07.07.2022 mk - akt zdjęć 17.08.2022 mk akt opisu 0
10946 ODV-EDG P A 1 0.00 0.00 22.500 0 0 0 0.00 0 1697028733 1743601063 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 1 AD 12.10.2023r Produkt w trakcie 0