SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111741, 111740, 111739, 111738, 111737, 
    111736, 111735, 111734, 111733, 111732, 
    111689, 111836, 111835, 111685, 111677, 
    111676, 111675, 111674, 111771, 111770
  )

Query time 0.00036

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
111674 BRR206 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670803200 0 Y N N B N R Y N N Y 10 1670803200 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 5054287008407 GBKQU2240032 N 111678 Electronic Muzik Organization Various Artists 1668230106 Y 2022-11-12 06:15:06 0
111675 BRR206 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670803200 0 Y N N B N R Y N N Y 10 1670803200 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 5054287008407 GBKQU2145752 N 111678 Electronic Muzik Organization Various Artists 1668230107 Y 2022-11-12 06:15:07 0
111676 BRR206 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670803200 0 Y N N B N R Y N N Y 10 1670803200 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 5054287008407 GBKQU2228799 N 111678 Electronic Muzik Organization Various Artists 1668230107 Y 2022-11-12 06:15:07 0
111677 BRR206 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670803200 0 Y N N B N R Y N N Y 10 1670803200 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 5054287008407 GBKQU2147968 N 111678 Electronic Muzik Organization Various Artists 1668230107 Y 2022-11-12 06:15:07 0
111685 ASD002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670803200 0 Y N N B N R Y N N Y 10 1670803200 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 5054287013371 GBLV62200775 N Copyright Control B. Carberry 1668231007 Y 2022-11-12 06:30:07 0
111689 DARKULOST02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670889600 0 Y N N B N R Y N N Y 10 1670889600 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 5054285703038 GBKQU2120064 N Copyright Control Alan Robertson 1668316501 Y 2022-11-13 06:15:01 0
111732 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2262609 N 111757 Copyright Control Various Artists 1668402920 Y 2022-11-14 06:15:20 0
111733 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2266074 N 111757 Copyright Control Various Artists 1668402920 Y 2022-11-14 06:15:20 0
111734 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2265909 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111735 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2265954 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111736 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2265963 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111737 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2264435 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111738 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2246076 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111739 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2247358 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111740 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2260709 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111741 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2261517 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111770 247HC293 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670544000 0 Y N N B N R Y N N Y 10 1670544000 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 5054287036950 UKT6B2200672 N Copyright Control Robert Cox, Adam Hambly 1668532509 Y 2022-11-15 18:15:09 0
111771 247HC293 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670544000 0 Y N N B N R Y N N Y 10 1670544000 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 5054287036950 UKT6B2200673 N Copyright Control Robert Cox, Adam Hambly 1668532509 Y 2022-11-15 18:15:09 0
111835 CR235 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670803200 0 Y N N B N R Y N N Y 10 1670803200 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 5054287038671 GBLV62204429 N Contagious Records Rik Norton-Wilkes & Martin Renstar 1668618901 Y 2022-11-16 18:15:01 0
111836 CR235 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670803200 0 Y N N B N R Y N N Y 10 1670803200 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 5054287038671 GBLV62204430 N Contagious Records Rik Norton-Wilkes & Martin Renstar 1668618903 Y 2022-11-16 18:15:03 0