SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    8304, 9885, 9882, 8288, 8275, 8733, 8362, 
    8305, 8299, 9877, 8277, 8720
  )

Query time 0.00060

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
8275 STG-D-CRT1-P P A 1 0.00 0.00 18.000 0 0 0 0.00 0 1376776800 1751368358 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"},"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"},"1774880797":{"product_id":"10014","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 kk 25/04/2020 0
8277 STG-D-CRT3-P P A 1 0.00 0.00 18.000 0 0 0 0.00 0 1376776800 1751370095 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"},"1417380117":{"product_id":"10022","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 kk 25/04/2020 0
8288 STG-E-CLF1-P P A 1 0.00 0.00 17.000 0 0 0 0.00 0 1376863200 1751368303 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 {"1263638517":{"product_id":"10028","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
8299 STG-C-MNS2-P P A 1 0.00 0.00 15.000 0 0 0 0.00 0 1376863200 1751375226 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"},"1553018502":{"product_id":"10030","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
8304 STG-E-NPL2-P P A 1 0.00 -4.00 13.700 0 0 0 0.00 0 1376863200 1751368133 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
8305 STG-E-PLR1-P P A 1 0.00 0.00 15.100 0 0 0 0.00 0 1376863200 1751368427 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"},"1242395725":{"product_id":"10036","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
8362 STG-N-RUST P A 1 0.00 0.00 11.000 0 0 0 0.00 0 1454146676 1743601019 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
8720 STG-C-PRM1-P P A 1 0.00 0.00 10.500 0 0 0 0.00 0 1060293600 1751370737 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"},"1800463197":{"product_id":"10057","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
8733 STG-C-R540-P P A 1 0.00 0.00 22.000 0 0 0 0.00 0 1060293600 1743601019 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"},"568777411":{"product_id":"10060","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"},"2077703165":{"product_id":"8370","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
9877 STG-E-NPL3-P P A 1 0.00 -89.00 13.700 0 0 0 0.00 0 1454339672 1751368613 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"},"35726995":{"product_id":"10042","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"},"1951420535":{"product_id":"8366","amount":"0","modifier":"0","modifier_type":"A"},"214961003":{"product_id":"8371","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0
9882 STG-E-AMS1-P P A 1 0.00 0.00 15.500 0 0 0 0.00 0 1454347957 1751375147 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"},"1965430277":{"product_id":"10043","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"},"1951420535":{"product_id":"8366","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
9885 STG-C-LFT1-P P A 1 0.00 0.00 10.000 0 0 0 0.00 0 1454351307 1751375355 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"},"475517899":{"product_id":"10056","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"},"214961003":{"product_id":"8371","amount":"0","modifier":"0","modifier_type":"A"}} 0 N N 0 0