SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    94857, 94814, 95739, 95696, 95695, 89230, 
    95546, 95200, 94865, 94683, 93093, 
    92916, 95501, 95500, 95499, 95498, 
    95497, 95496, 95495, 95494
  )

Query time 0.00073

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
89230 RRR019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620169200 0 Y N N B N R Y N N Y 10 1620169200 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 Dale West 1642007691 Y 05/05/2021 04/06/2021 2021-12-17 17:37:27 0
92916 VCR314 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619737200 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;} 4 N Copyright Control John Newell 1619767438 Y 2021-12-17 17:37:27 0
93093 HHF012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 1646603685 Y 01/05/2021 31/05/2021 2021-12-17 17:37:27 0
94683 PMD038 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 1621033200 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 labelworx 5054285794364 GBKQU2135601 N Pumped Joe Longbottom Sonya J Williams 1617254101 Y 2021-12-17 17:37:27 0
94814 PMD039 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620342000 0 Y N N B N R Y N N Y 10 1620342000 1621551600 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 labelworx 5054285794371 GBKQU2135602 N Pumped Marc Daniels 1617772503 Y 2021-12-17 17:37:27 0
94857 UTHHD047 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620342000 0 Y N N B N R Y N N Y 10 1620342000 1621551600 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 labelworx 5054285820636 GBKQU2140163 N Ultratech Dance Music UK Jay Middleton 1617902102 Y 2021-12-17 17:37:27 0
94865 BTN009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 1621206000 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 labelworx 5054285822760 GBKQU2140746 N Bring The Noise Recordings Ben Kaye 1617902404 Y 2021-12-17 17:37:27 0
95200 BMR213 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 1622415600 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;} 3 labelworx 5054285852200 GBKQU2144781 N Beast Mode Recordings Tim Herlihy, Alexei Reynolds 1618849817 Y 2021-12-17 17:37:27 0
95494 SPEAK008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619747715 0 Y N N B N R Y N N Y 10 1619737200 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 Lee Silvester 1641997607 Y 30/04/2021 30/05/2021 2021-12-17 17:37:27 0
95495 BB021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619755061 0 Y N N B N R Y N N Y 10 1619737200 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 Richard Senior 1637683144 Y 2021-12-17 17:37:27 0
95496 KK005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619755136 0 Y N N B N R Y N N Y 10 1619737200 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 Dan Hall 1619755242 Y 2021-12-17 17:37:27 0
95497 VRF008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619766104 0 Y N N B N R Y N N Y 10 1619737200 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 Paul Reeves 1619791820 Y 2021-12-17 17:37:27 0
95498 BDR004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619766728 0 Y N N B N R Y N N Y 10 1619737200 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 Dave Grabowski 1643556417 Y 30/04/2021 30/05/2021 2021-12-17 17:37:27 0
95499 ESP070 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619780576 0 Y N N B N R Y N N Y 10 1619737200 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 Energy Source Productions DJ Serenity 1619781321 Y 2021-12-17 17:37:27 0
95500 TMP174 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619798971 0 Y N N B N R Y N N Y 10 1619737200 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 Tempo Trax Adam Bennett & Andrew Holmes 1619799329 Y 2021-12-17 17:37:27 0
95501 TMP175 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619799035 0 Y N N B N R Y N N Y 10 1619737200 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 Tempo Trax Barney Coombes 1619799353 Y 2021-12-17 17:37:27 0
95546 HF038 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620023072 0 Y N N B N R Y N N Y 10 1619996400 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 Digital David Jackson/Craig Millar 1620023424 Y 2021-12-17 17:37:27 0
95695 BDREP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620199731 0 Y N N B N R Y N N Y 10 1620169200 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 Dave Grabowski 1643556498 Y 05/05/2021 04/06/2021 2021-12-17 17:37:27 0
95696 BDREP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620199866 0 Y N N B N R Y N N Y 10 1620169200 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 Dave Grabowski 1643556535 Y 05/05/2021 04/06/2021 2021-12-17 17:37:27 0
95739 ST12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620283417 0 Y N N B N R Y N N Y 10 1620255600 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 Hatfish Music Ben Miles & James Nardi 1620283538 Y 2021-12-17 17:37:27 0