SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    112148, 111842, 111841, 111840, 111839, 
    112382, 111756, 111755, 111754, 111753, 
    111751, 111750, 111749, 111748, 111747, 
    111746, 111745, 111744, 111743, 111742
  )

Query time 0.00094

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
111742 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 GBKQU2256793 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111743 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 GBKQU2259487 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111744 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 GBKQU2268681 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111745 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 GBKQU2256439 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111746 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 GBKQU2255350 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111747 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 GBKQU2252145 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111748 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 TFT202200003 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111749 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 GBKQU2250771 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111750 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 GBKQU2255805 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111751 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 UK9E92200303 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111753 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 GBKQU2037631 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111754 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 GBKQU2241823 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111755 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 GBKQU2238908 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111756 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 GBKQU2241638 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111839 MOUTHDATA101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671062400 0 Y N N B N R Y N N Y 10 1671062400 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 5054287037520 GBLV62204195 N Copyright Control Carl Alexandrow, Dan Martin, Peter Nitschke 1668618905 Y 2022-11-16 18:15:05 0
111840 MOUTHDATA101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671062400 0 Y N N B N R Y N N Y 10 1671062400 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 5054287037520 GBLV62204196 N Copyright Control Carl Alexandrow, Dan Martin, Peter Nitschke 1668618905 Y 2022-11-16 18:15:05 0
111841 MOUTHDATA101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671062400 0 Y N N B N R Y N N Y 10 1671062400 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 5054287037520 GBLV62204197 N Copyright Control Carl Alexandrow, Dan Martin, Peter Nitschke 1668618906 Y 2022-11-16 18:15:06 0
111842 MOUTHDATA101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671062400 0 Y N N B N R Y N N Y 10 1671062400 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 5054287037520 GBLV62204198 N Copyright Control Carl Alexandrow, Dan Martin, Peter Nitschke 1668618906 Y 2022-11-16 18:15:06 0
112148 DARKUL156 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671062400 0 Y N N B N R Y N N Y 10 1671062400 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 5054287074242 GBLV62209973 N Copyright Control Noel Wessels 1669914901 Y 2022-12-01 18:15:01 0
112382 DNZF1376 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 5054287087648 GBLV62211950 N DNZ Records Brett Cooper 1670522401 Y 2022-12-08 19:00:01 0