SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111643, 111642, 111641, 111640, 111639, 
    111638, 111637, 111669, 110650, 111393, 
    111392, 110577, 110576, 110559, 110558, 
    110557, 111872, 111667, 111666, 111385
  )

Query time 0.00035

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 Using where

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit 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 exclusive_end_date 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 final_category aggregator aggregator_id ean isrc tbid is_album from_album publisher writers updated_timestamp available_worldwide stream_release_date download_release_date added_timestamp parent_product_id
110557 KKR168 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669593600 0 Y N N B N R Y N N Y 10 1669593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054286996767 GBKQU2298230 N Copyright Control Paul Lattermann 1667020501 Y 2022-10-29 06:15:01 0
110558 KKV022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669593600 0 Y N N B N R Y N N Y 10 1669593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054286996798 GBKQU2298233 N Copyright Control Angel Arnulfo Bran Alvarez, Brandon David Ren Pacajoj 1667022302 Y 2022-10-29 06:45:02 0
110559 KKV022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669593600 0 Y N N B N R Y N N Y 10 1669593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054286996798 GBKQU2298234 N Copyright Control Angel Arnulfo Bran Alvarez, Brandon David Ren Pacajoj 1667022303 Y 2022-10-29 06:45:03 0
110576 KKR167 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669593600 0 Y N N B N R Y N N Y 10 1669593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054286996217 GBKQU2298131 N Copyright Control Olav Bosch, Whout Marneef 1667022312 Y 2022-10-29 06:45:12 0
110577 KKR167 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669593600 0 Y N N B N R Y N N Y 10 1669593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054286996217 GBKQU2298132 N Copyright Control Olav Bosch, Whout Marneef 1667022312 Y 2022-10-29 06:45:12 0
110650 SPOON249A P A 1 1.69 1 0.000 0 0 0 0.00 0 1669680000 0 Y N N B N R Y N N Y 10 1669680000 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287015061 NL4AW2224901 N Copyright Control Mitchell de Jonge, Tim Udo, Yohann Mercier, Lucas Simons 1667409302 Y 2022-11-02 18:15:02 0
111385 KKRMX001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669334400 0 Y N N B N R Y N N Y 10 1669334400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287029648 GBLV62203058 N Copyright Control Wolfgang Burger, Dario Hoelling 1668014093 Y 2022-11-09 18:14:53 0
111392 MQDRHRD012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669593600 0 Y N N B N R Y N N Y 10 1669593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287029723 GBLV62203071 N +QDance Records David Almarcha 1668014102 Y 2022-11-09 18:15:02 0
111393 MQDRHRD012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669593600 0 Y N N B N R Y N N Y 10 1669593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287029723 GBLV62203072 N +QDance Records David Almarcha 1668014102 Y 2022-11-09 18:15:02 0
111637 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287032501 ATR981226680 N 111665 Copyright Control Various 1668100523 Y 2022-11-10 18:15:23 0
111638 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287032501 ATR981226681 N 111665 Copyright Control Various 1668100523 Y 2022-11-10 18:15:23 0
111639 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287032501 ATR981228757 N 111665 Copyright Control Various 1668100524 Y 2022-11-10 18:15:24 0
111640 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287032501 ATR981228761 N 111665 Copyright Control Various 1668100525 Y 2022-11-10 18:15:25 0
111641 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287032501 ATR981229104 N 111665 Copyright Control Various 1668100525 Y 2022-11-10 18:15:25 0
111642 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287032501 ATR981230095 N 111665 Copyright Control Various 1668100525 Y 2022-11-10 18:15:25 0
111643 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287032501 ATR981230376 N 111665 Copyright Control Various 1668100526 Y 2022-11-10 18:15:26 0
111666 UPR217 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669334400 0 Y N N B N R Y N N Y 10 1669334400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287033867 NL3TA2209401 N Copyright Control Jorg van Hees 1668143701 Y 2022-11-11 06:15:01 0
111667 WRD018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669334400 0 Y N N B N R Y N N Y 10 1669334400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287033812 GBLV62203793 N Copyright Control Simone Marazzi 1668143704 Y 2022-11-11 06:15:04 0
111669 UPR218 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669680000 0 Y N N B N R Y N N Y 10 1669680000 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287035755 NL3TA2209501 N Copyright Control Paul Aarts 1668187804 Y 2022-11-11 18:30:04 0
111872 HB18 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669334400 0 Y N N B N R Y N N Y 10 1669334400 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5054287047178 GBLV62205801 N Copyright Control M. Comis 1668705303 Y 2022-11-17 18:15:03 0