SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    94351, 94332, 93035, 92516, 94682, 92885, 
    94581, 94559, 93751, 94131, 92911, 
    94523, 94521, 94520, 94519, 94518, 
    94517, 94516, 94511, 94510
  )

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
92516 FD045 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617318000 0 Y N N B N R Y N N Y 10 1617318000 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;} 4 N Copyright Control Ann-Marie Jenkins 1610793630 Y 2021-12-17 17:37:27 0
92885 HHF011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617231600 0 Y N N B N R Y N N Y 10 1617231600 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;} 4 N Toolbox Publishing, Copyright Control Artem Svirchevskiy / Matt Clarkson 1646603638 Y 01/04/2021 01/05/2021 2021-12-17 17:37:27 0
92911 VCR309 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616803200 0 Y N N B N R Y N N Y 10 1616716800 0 N 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;} 4 N Copyright Control Sean Stanley 1616744815 Y 2021-12-17 17:37:27 0
93035 FBR341 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617318000 0 Y N N B N R Y N N Y 10 1617318000 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;} 4 N Copyright Control Rob Hills 1612270222 Y 2021-12-17 17:37:27 0
93751 BTN006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616972400 0 Y N N B N R Y N N Y 10 1616972400 1618182000 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;} 1 labelworx 5054285692509 GBKQU2118016 N Bring the noise recordings Phil 'Mobi D' Wale 1614402301 Y 2021-12-17 17:37:27 0
94131 PDR035 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616889600 0 Y N N B N R Y N N Y 10 1616889600 0 N 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;} 4 N copyright control adam bennett 1616919605 Y 2021-12-17 17:37:27 0
94332 TBR211 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617318000 0 Y N N B N R Y N N Y 10 1617318000 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;} 4 N Toolbox Publishing Dawn Lee / Kate Fairbrother 1616421627 Y 2021-12-17 17:37:27 0
94351 WLHH026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617318000 0 Y N N B N R Y N N Y 10 1617318000 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;} 4 N Welovehardhouse Amp Attack 1617189384 Y 2021-12-17 17:37:27 0
94510 KR015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616716800 0 Y N N B N R Y N N Y 10 1616716800 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;} 4 N Copyright Control Karim Fassih/Martyn Boswell 1616694249 Y 2021-12-17 17:37:27 0
94511 FR126 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616716800 0 Y N N B N R Y N N Y 10 1616716800 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;} 4 N Toolbox Publishing, Copyright Control Paul Luffman / Leigh Day / Rob Yellowley 1641480987 Y 26/03/2021 25/04/2021 2021-12-17 17:37:27 0
94516 BB018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616738328 0 Y N N B N R Y N N Y 10 1616716800 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;} 4 N Copyright Control Alexei Reynolds 1616738420 Y 2021-12-17 17:37:27 0
94517 BB018B P A 1 1.69 1 0.000 0 0 0 0.00 0 1616738692 0 Y N N B N R Y N N Y 10 1616716800 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;} 4 N Copyright Control Alexei Reynolds 1616739320 Y 2021-12-17 17:37:27 0
94518 KK003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616738797 0 Y N N B N R Y N N Y 10 1616716800 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;} 4 N Copyright Control Ben Miles 1616739341 Y 2021-12-17 17:37:27 0
94519 BDR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616748151 0 Y N N B N R Y N N Y 10 1616716800 0 N 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;} 4 N Copyright Control Dave Grabowsi / Zillin Redeker 1643556299 Y 26/03/2021 25/04/2021 2021-12-17 17:37:27 0
94520 RPR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616762116 0 Y N N B N R Y N N Y 10 1616716800 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;} 4 AUTOGENERATE N none Jussi Leppanen 1616762720 Y 2021-12-17 17:37:27 0
94521 MHR077 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616769238 0 Y N N B N R Y N N Y 10 1616716800 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;} 4 N MCPS Michael Franklin 1616769921 Y 2021-12-17 17:37:27 0
94523 SPEAK007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1616774527 0 Y N N B N R Y N N Y 10 1616716800 0 N 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;} 4 N Toolbox Publishing Wayne German 1641997598 Y 26/03/2021 25/04/2021 2021-12-17 17:37:27 0
94559 HF034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617000531 0 Y N N B N R Y N N Y 10 1616972400 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;} 4 N Toolbox Digital Tom Parr/Peter Maxwell 1617001228 Y 2021-12-17 17:37:27 0
94581 GAR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617131611 0 Y N N B N R Y N N Y 10 1617058800 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;} 4 N Global Awakening Records Andrew Holmes 1617131721 Y 2021-12-17 17:37:27 0
94682 XA018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617231600 0 Y N N B N R Y N N Y 10 1617231600 0 N 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;} 4 XA018 N Copyright Control / Toolbox Publishing Dion Phillips, Lee Silvester 1646339477 Y 01/04/2021 01/05/2021 2021-12-17 17:37:27 0