SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111882, 111881, 111880, 111878, 112552, 
    111863, 111845, 114692, 114691, 114690, 
    114689, 112371, 112370, 112369, 112017, 
    112010, 111861, 111860, 111859, 111858
  )

Query time 0.00051

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
111845 PUR066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671235200 0 Y N N B N R Y N N Y 10 1671235200 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 5054287036899 GBLV62204155 N Pink Unicorn Records Sarah Garlot 1668662101 Y 2022-11-17 06:15:01 0
111858 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100389 N 111862 Copyright Control Various Artists 1668662110 Y 2022-11-17 06:15:10 0
111859 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200377 N 111862 Copyright Control Various Artists 1668662110 Y 2022-11-17 06:15:10 0
111860 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2200370 N 111862 Copyright Control Various Artists 1668662110 Y 2022-11-17 06:15:10 0
111861 STMLP021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287033201 GBY3G2100391 N 111862 Copyright Control Various Artists 1668662110 Y 2022-11-17 06:15:10 0
111863 247HC289 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671235200 0 Y N N B N R Y N N Y 10 1671235200 0 B 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;} labelworx 5054287005819 UKT6B2200566 N Copyright Control Darren Heavey 1673037571 Y 2022-11-17 06:15:11 0
111878 ASD003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287013388 GBLV62200776 N Copyright Control B. Carberry 1668835801 Y 2022-11-19 06:30:01 0
111880 THR202203 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287042258 GBLV62205002 N Twisted Hardcore Records Daniel B 1668835823 Y 2022-11-19 06:30:23 0
111881 THR202203 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287042258 GBLV62205003 N Twisted Hardcore Records Daniel B 1668835824 Y 2022-11-19 06:30:24 0
111882 AAA008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671408000 0 Y N N B N R Y N N Y 10 1671408000 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 5054287042302 GBLV62205012 N Copyright Control Ben Fraser 1668835825 Y 2022-11-19 06:30:25 0
112010 KTRAR075 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 0 B 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;} labelworx 5054287061136 GBLV62208156 N Copyright Control Dune, M-Project 1673037520 Y 2022-11-24 19:30:02 0
112017 NTWO029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 0 B 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;} labelworx 5054287062577 GBLV62208303 N Copyright Control Michael Brown 1673037539 Y 2022-11-25 18:45:01 0
112369 VDR023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287085668 GBLV62211678 N Violent Disorder Records Lee Morris 1670477472 Y 2022-12-08 06:31:12 0
112370 VDR023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287085668 GBLV62211679 N Violent Disorder Records Lee Morris 1670477472 Y 2022-12-08 06:31:12 0
112371 VDR023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287085668 GBLV62211680 N Violent Disorder Records Lee Morris 1670477473 Y 2022-12-08 06:31:13 0
112552 PCR091A P A 1 1.69 1 0.000 0 0 0 0.00 0 1671321600 0 Y N N B N R Y N N Y 10 1671321600 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 5054287102846 NLS202200344 N 2 Dex Publishing Angelo Zevenhek 1671211801 Y 2022-12-16 18:30:01 0
114689 DTK08 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287165919 GBKQU2307880 N DTK Records Get Han, Ergoth 1679334334 Y 2023-03-20 18:30:03 0
114690 DTK08 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287165919 GBKQU2307881 N DTK Records Get Han, Ergoth 1679334349 Y 2023-03-20 18:30:03 0
114691 DTK08 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287165919 GBKQU2307882 N DTK Records Get Han, Ergoth 1679334366 Y 2023-03-20 18:30:03 0
114692 DTK08 P A 1 1.69 1 0.000 0 0 0 0.00 0 1671148800 0 Y N N B N R Y N N Y 10 1671148800 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 5054287165919 GBKQU2307883 N DTK Records Get Han, Ergoth 1679334381 Y 2023-03-20 18:30:04 0