SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    10444, 10027, 10023, 10044, 10060, 10427, 
    10024, 10035, 10038, 10014, 10016, 
    10047
  )

Query time 0.00069

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
10014 STG-D-CRT1-N P A 1 0.00 6.00 19.000 0 0 0 0.00 0 1460464208 1743601069 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 25 106 activity N [] 0 N N 0 0
10016 STG-D-ARN1-N P A 1 0.00 0.00 14.000 0 0 0 0.00 0 1460545425 1743601069 0 N N N B 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 25 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"2017138383":{"product_id":"10016","amount":"0","modifier":"0","modifier_type":"A"},"1705103013":{"product_id":"8364","amount":"0","modifier":"0","modifier_type":"A"},"56058081":{"product_id":"8367","amount":"0","modifier":"0","modifier_type":"A"},"214961003":{"product_id":"8371","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
10023 STG-D-RDS1-N P A 1 0.00 5.00 11.000 0 0 0 0.00 0 1460717667 1743601062 0 N N N B 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 25 106 activity N [] 0 N N 0 0
10024 STG-D-VNZ1-N P A 1 0.00 5.00 8.500 0 0 0 0.00 0 1460717668 1743601068 0 N N N B 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 25 106 activity N [] 0 N N 0 0
10027 STG-E-CLB1-N P A 1 0.00 0.00 16.000 0 0 0 0.00 0 1460969371 1743601062 0 N N N B 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 25 10 activity N [] 0 N N 0 0
10035 STG-E-NPL2-N P A 1 0.00 0.00 13.500 0 0 0 0.00 0 1460969373 1743601068 0 N N N B 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 25 10 activity N [] 0 N N 0 0
10038 STG-E-GRN2-N P A 1 0.00 0.00 13.000 0 0 0 0.00 0 1460969373 1743601068 0 N N N B 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 25 10 activity N [] 0 N N 0 price 2019/10 0
10044 STG-E-AMS2-N P A 1 0.00 7.00 9.000 0 0 0 0.00 0 1460969374 1749808895 0 N N N B 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 25 106 activity N [] 0 N N 0 0
10047 STG-C-BST1-N P A 1 0.00 -7.00 8.700 0 0 0 0.00 0 1461065336 1743601069 0 N N N B 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 25 10 activity N [] 0 N N 0 0
10060 STG-C-R540-N P A 1 0.00 1.00 13.000 0 0 0 0.00 0 1461065337 1743601065 0 N N N B 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 25 10 activity N [] 0 N N 0 0
10427 STG-D-KEN2-P P A 1 0.00 0.00 15.200 0 0 0 0.00 0 1605774885 1743601068 0 N N N B 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;} 10 N 0 25 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1705103013":{"product_id":"8364","amount":"0","modifier":"0","modifier_type":"A"},"312933939":{"product_id":"8365","amount":"0","modifier":"0","modifier_type":"A"},"214961003":{"product_id":"8371","amount":"0","modifier":"0","modifier_type":"A"},"799267712":{"product_id":"10176","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
10444 STG-C-CMB2-P P A 1 0.00 0.00 20.000 0 0 0 0.00 0 1606127297 1743601062 0 N N N B 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;} 10 N 0 25 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1705103013":{"product_id":"8364","amount":"0","modifier":"0","modifier_type":"A"},"312933939":{"product_id":"8365","amount":"0","modifier":"0","modifier_type":"A"},"2077703165":{"product_id":"8370","amount":"0","modifier":"0","modifier_type":"A"},"799267712":{"product_id":"10176","amount":"0","modifier":"0","modifier_type":"A"},"1689510930":{"product_id":"10445","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0