SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    8303, 8665, 9880, 8281, 8286, 9818, 8371, 
    8364, 9883, 8666, 8300, 8365
  )

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
8281 STG-D-RDS1-P P A 1 0.00 61.00 10.500 0 0 0 0.00 0 1376776800 1751367247 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 107 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"595374467":{"product_id":"10023","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"},"454079002":{"product_id":"8369","amount":"0","modifier":"0","modifier_type":"A"},"1823806149":{"product_id":"593","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
8286 STG-E-CLB1-P P A 1 0.00 2.00 19.000 0 0 0 0.00 0 1376863200 1751367538 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"},"605123996":{"product_id":"10027","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"},"454079002":{"product_id":"8369","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
8300 STG-C-MNS1-P P A 1 0.00 16.00 15.000 0 0 0 0.00 0 1376863200 1751375260 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 106 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"731258384":{"product_id":"10031","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 15/04/2020 0
8303 STG-E-NPL1-P P A 1 0.00 19.00 13.700 0 0 0 0.00 0 1376863200 1751366997 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;} 100 N 0 25 106 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1543301791":{"product_id":"10034","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
8364 STG-A-GRUN P A 1 0.00 -5.00 16.000 0 0 0 0.00 0 1454150266 1743601011 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 19 10 activity N [] 0 N N 0 0
8365 STG-A-PELA P A 1 0.00 5.00 16.000 0 0 0 0.00 0 1454150293 1743601014 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 6 106 activity N [] 0 N N 0 0
8371 STG-A-IZK2 P A 1 0.00 5.00 16.000 0 0 0 0.00 0 1454150637 1743601009 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 22 106 activity N [] 0 N N 0 0
8665 STG-E-GRN1-P P A 1 0.00 3.00 12.000 0 0 0 0.00 0 1376863200 1751374929 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"},"979861700":{"product_id":"10033","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"},"1705103013":{"product_id":"8364","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
8666 STG-E-GRN2-P P A 1 0.00 0.00 12.000 0 0 0 0.00 0 1376863200 1751374952 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"},"1380624052":{"product_id":"10038","amount":"0","modifier":"0","modifier_type":"A"},"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 kk 25/04/2020 0
9818 STG-E-TMB1-P P A 1 0.00 0.00 13.800 0 0 0 0.00 0 1449700120 1751375058 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
9880 STG-E-GRN5-P P A 1 0.00 9.00 12.000 0 0 0 0.00 0 1454340563 1751375005 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 106 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1691846871":{"product_id":"10041","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
9883 STG-E-AMS2-P P A 1 0.00 11.00 15.500 0 0 0 0.00 0 1454348957 1751375177 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 Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"347962456":{"product_id":"10044","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"},"454079002":{"product_id":"8369","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