SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    110562, 110561, 110560, 110498, 110497, 
    110461, 111790, 110444, 111668, 111372, 
    111120, 111119, 110544, 110385, 110368, 
    110367, 110363, 110362, 110361, 110360
  )

Query time 0.00058

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
110360 CSD128 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286938637 GBKQU2289521 N Copyright Control Christoph Lehmann 1666157402 Y 2022-10-19 06:30:02 0
110361 TWOVGT5A P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286958178 GBKQU2292278 N Tidy Publishing Scott Attrill 1668757207 Y 2022-10-19 06:30:02 0
110362 ONESEVENTY146 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286961529 GBKQU2292841 N Copyright Control Tatsunoshin Fujiyoshi 1668757223 Y 2022-10-19 06:30:03 0
110363 ONESEVENTY146 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286961529 GBKQU2292842 N Copyright Control Tatsunoshin Fujiyoshi 1666157404 Y 2022-10-19 06:30:04 0
110367 VDH065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286938903 GBKQU2289545 N Various Digital Hardcore Kenny Watson, Rikki Jeffree 1666159202 Y 2022-10-19 07:00:02 0
110368 VDH065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286938903 GBKQU2289546 N Various Digital Hardcore Kenny Watson, Rikki Jeffree 1666159203 Y 2022-10-19 07:00:03 0
110385 KTRAR073 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286987994 GBKQU2296895 N Copyright Control Junya Iida 1668757236 Y 2022-10-19 18:15:03 0
110444 STI324 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668988800 0 Y N N B N R Y N N Y 10 1668988800 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 5054286906667 GBKQU2284538 N Copyright Control G. Covington, Ronnie C 1666418402 Y 2022-10-22 07:00:02 0
110461 STI327 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669161600 0 Y N N B N R Y N N Y 10 1669161600 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 5054286906742 GBKQU2284545 N Copyright Control B. Cooper 1666590301 Y 2022-10-24 06:45:01 0
110497 MOUTHDATA100 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669248000 0 Y N N B N R Y N N Y 10 1669248000 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 5054286988588 GBKQU2297044 N Copyright Control Luke McMillan 1666675802 Y 2022-10-25 06:30:02 0
110498 MOUTHDATA100 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669248000 0 Y N N B N R Y N N Y 10 1669248000 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 5054286988588 GBKQU2297045 N Copyright Control Luke McMillan 1666675803 Y 2022-10-25 06:30:03 0
110544 247HC283 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054287003860 UKT6B2200501 N Copyright Control Robert Cox, Alasdair Taylor 1668757251 Y 2022-10-27 18:30:02 0
110560 MOK269 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669248000 0 Y N N B N R Y N N Y 10 1669248000 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 5054286994978 NLLB82200118 N 110571 Copyright Control Various Artists 1667022305 Y 2022-10-29 06:45:05 0
110561 MOK269 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669248000 0 Y N N B N R Y N N Y 10 1669248000 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 5054286994978 NLLB82200119 N 110571 Copyright Control Various Artists 1667022306 Y 2022-10-29 06:45:06 0
110562 MOK269 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669248000 0 Y N N B N R Y N N Y 10 1669248000 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 5054286994978 NLLB82200120 N 110571 Copyright Control Various Artists 1667022306 Y 2022-10-29 06:45:06 0
111119 247HC301 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054287027255 UKT6B2200668 N Copyright Control Darren Heavey, Luis Jungkeit 1668757274 Y 2022-11-08 18:15:18 0
111120 247HC301 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054287027255 UKT6B2200669 N Copyright Control Darren Heavey, Luis Jungkeit 1667927719 Y 2022-11-08 18:15:19 0
111372 DNZF1358 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054287029006 GBLV62202981 N DNZ Records Sethrow Gallagher 1668014086 Y 2022-11-09 18:14:46 0
111668 EX065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054287035724 GBLV62204014 N Exode Records Cristiano Astore 1668186901 Y 2022-11-11 18:15:01 0
111790 DNZF1361 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669075200 0 Y N N B N R Y N N Y 10 1669075200 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 5054287044108 GBLV62205305 N DNZ Records Michael Piper, Gareth Jones 1668577507 Y 2022-11-16 06:45:07 0