SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    8303, 8665, 9880, 8286, 9818, 9883, 8666, 
    8300, 8306, 8289, 8361, 8304
  )

Query time 0.00056

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
8286 STG-E-CLB1-P P A 1 0.00 2.00 19.000 0 0 0 0.00 0 1376863200 1743601008 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
8289 STG-E-CLF2-P P A 1 0.00 3.00 17.000 0 0 0 0.00 0 1376863200 1743601014 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 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1012311907":{"product_id":"10029","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
8300 STG-C-MNS1-P P A 1 0.00 16.00 15.000 0 0 0 0.00 0 1376863200 1743601012 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 1743601006 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
8304 STG-E-NPL2-P P A 1 0.00 -4.00 13.700 0 0 0 0.00 0 1376863200 1743601015 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 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"754702857":{"product_id":"10035","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
8306 STG-E-PLR2-P P A 1 0.00 0.00 15.100 0 0 0 0.00 0 1376863200 1743601014 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 10 activity Y {"0":{"product_id":"[","amount":"[","modifier":"[","modifier_type":"A"},"1024083163":{"product_id":"10037","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
8361 STG-N-IVOR P A 1 0.00 0.00 12.000 0 0 0 0.00 0 1454146661 1743601015 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
8665 STG-E-GRN1-P P A 1 0.00 3.00 12.000 0 0 0 0.00 0 1376863200 1743601006 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 1743601012 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 1743601009 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 1743601007 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 1749808852 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