SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    9868, 9876, 9820, 8285, 9482, 8273, 10423, 
    9819, 8283, 9483, 9879, 9875
  )

Query time 0.00075

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
8273 STG-D-ARN1-P P A 1 0.00 0.00 19.000 0 0 0 0.00 0 1376776800 1743601032 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"},"2017138383":{"product_id":"10016","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"},"1705103013":{"product_id":"8364","amount":"0","modifier":"0","modifier_type":"A"},"1823806149":{"product_id":"593","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
8283 STG-D-VNZ1-P P A 1 0.00 0.00 11.000 0 0 0 0.00 0 1376776800 1743601033 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"},"1122491358":{"product_id":"10024","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"},"1823806149":{"product_id":"593","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
8285 STG-D-VNZ4-P P A 1 0.00 0.00 11.000 0 0 0 0.00 0 1376776800 1751370872 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"},"1393968398":{"product_id":"10026","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"},"1823806149":{"product_id":"593","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
9482 STG-C-BST2-P P A 1 0.00 -3.00 14.400 0 0 0 0.00 0 1376776800 1751370929 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"},"487272563":{"product_id":"10048","amount":"0","modifier":"0","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 kk 25/04/2020 0
9483 STG-C-BST3-P P A 1 0.00 0.00 14.400 0 0 0 0.00 0 1376776800 1743601035 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"},"1779171557":{"product_id":"10049","amount":"0","modifier":"0","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 kk 25/04/2020 0
9819 STG-E-TMB2-P P A 1 0.00 0.00 13.800 0 0 0 0.00 0 1449701336 1743601032 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 {"312933939":{"product_id":"8365","amount":"0","modifier":"0","modifier_type":"A"},"1705103013":{"product_id":"8364","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
9820 STG-E-TMB3-P P A 1 0.00 0.00 13.800 0 0 0 0.00 0 1449701602 1751370810 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 {"312933939":{"product_id":"8365","amount":"0","modifier":"0","modifier_type":"A"},"1705103013":{"product_id":"8364","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
9868 STG-N-BIAN P A 1 0.00 0.00 12.700 0 0 0 0.00 0 1453850179 1743601025 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 {"312933939":{"product_id":"8365","amount":"0","modifier":"0","modifier_type":"A"},"1705103013":{"product_id":"8364","amount":"0","modifier":"0","modifier_type":"A"},"793011027":{"product_id":"10191","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
9875 STG-C-PRM2-P P A 1 0.00 -23.00 10.000 0 0 0 0.00 0 1138662000 1743601037 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;} 10 N 0 25 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"68157746":{"product_id":"10058","amount":"0","modifier":"0","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"}} 0 N N 0 kk 25/04/2020 0
9876 STG-D-YORK-P P A 1 0.00 0.00 11.000 0 0 0 0.00 0 1454337767 1743601027 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"}} 0 N N 0 0
9879 STG-E-GRN4-P P A 1 0.00 0.00 12.000 0 0 0 0.00 0 1454340382 1743601036 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"},"44634898":{"product_id":"582","amount":"0","modifier":"0","modifier_type":"A"},"1374175881":{"product_id":"10461","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
10423 STG-D-JUR1-P P A 1 0.00 -1.00 21.000 0 0 0 0.00 0 1605697643 1743601034 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 {"1705103013":{"product_id":"8364","amount":"0","modifier":"0","modifier_type":"A"},"214961003":{"product_id":"8371","amount":"0","modifier":"0","modifier_type":"A"},"854147988":{"product_id":"10425","amount":"0","modifier":"0","modifier_type":"A"},"312933939":{"product_id":"8365","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 kk 25/04/2020 0