SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    94011, 94010, 94009, 94008, 94007, 94006, 
    94851, 89228, 94777, 94772, 94133, 
    94760, 92912, 94726, 94708, 94707, 
    94706, 94687, 94570, 94569
  )

Query time 0.00047

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
89228 RRR017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617750000 0 Y N N B N R Y N N Y 10 1617750000 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 23rd Precinct Music, Copyright Control Gary Cooke / Frank Farrell 1642007565 Y 07/04/2021 07/05/2021 2021-12-17 17:37:27 0
92912 VCR310 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617404400 0 Y N N B N R Y N N Y 10 1617318000 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 Ryan Tregurtha / Terence Blunt 1617351390 Y 2021-12-17 17:37:27 0
94006 RFRELOADED1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617922800 0 Y N N B N R Y N N Y 10 1617922800 1619132400 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 5054285721599 GBKQU1345031 N 94017 Copyright Control Dan Roubtsov 1615352707 Y 2021-12-17 17:37:27 0
94007 RFRELOADED1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617922800 0 Y N N B N R Y N N Y 10 1617922800 1619132400 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 5054285721599 GBKQU1705482 N 94017 Copyright Control Dan Roubtsov 1615352707 Y 2021-12-17 17:37:27 0
94008 RFRELOADED1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617922800 0 Y N N B N R Y N N Y 10 1617922800 1619132400 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 5054285721599 GBKQU1402221 N 94017 Copyright Control Dan Roubtsov 1615352707 Y 2021-12-17 17:37:27 0
94009 RFRELOADED1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617922800 0 Y N N B N R Y N N Y 10 1617922800 1619132400 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 5054285721599 GBLV61632046 N 94017 Copyright Control Dan Roubtsov 1615352708 Y 2021-12-17 17:37:27 0
94010 RFRELOADED1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617922800 0 Y N N B N R Y N N Y 10 1617922800 1619132400 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 5054285721599 GBLV61632031 N 94017 Copyright Control Dan Roubtsov 1615352708 Y 2021-12-17 17:37:27 0
94011 RFRELOADED1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617922800 0 Y N N B N R Y N N Y 10 1617922800 1619132400 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 5054285721599 GBKQU2122726 N 94017 Copyright Control Dan Roubtsov 1615352708 Y 2021-12-17 17:37:27 0
94133 PDR036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617602510 0 Y N N B N R Y N N Y 10 1617577200 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 c dundar 1617602519 Y 2021-12-17 17:37:27 0
94569 KR016 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 Gary Toomey/Vicki Robinson 1617044038 Y 2021-12-17 17:37:27 0
94570 VRF005 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 Slenderman 1617078409 Y 2021-12-17 17:37:27 0
94687 FR127 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, Copyright Control Rob Yellowley, Rob Healy 1641481097 Y 02/04/2021 02/05/2021 2021-12-17 17:37:27 0
94706 BB019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617356934 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 Tara Nicholson 1617357621 Y 2021-12-17 17:37:27 0
94707 IA012A P A 1 1.69 1 0.000 0 0 0 0.00 0 1617360573 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 Ben Miles 1617361226 Y 2021-12-17 17:37:27 0
94708 IA012B P A 1 1.69 1 0.000 0 0 0 0.00 0 1617360702 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 Tara N/ Jared Blyth 1617361247 Y 2021-12-17 17:37:27 0
94726 SSD038 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617395022 0 Y N N B N R Y N N Y 10 1617318000 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 AUTO N Sugar Skull Digital Carl Pearce/Cheryl Pearce 1617395422 Y 2021-12-17 17:37:27 0
94760 SS091 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617471870 0 Y N N B N R Y N N Y 10 1617404400 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 Slingshot Recordings Paul Norris/Kelly Ward 1617471921 Y 2021-12-17 17:37:27 0
94772 HF035 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617603907 0 Y N N B N R Y N N Y 10 1617577200 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 Paul Norris/Dylan Foley 1617604221 Y 2021-12-17 17:37:27 0
94777 ESP068 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617639379 0 Y N N B N R Y N N Y 10 1617577200 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 1617640225 Y 2021-12-17 17:37:27 0
94851 FTHH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1617884756 0 Y N N B N R Y N N Y 10 1617836400 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 FINGER THUMB RECORDS JASON M 1617894825 Y 2021-12-17 17:37:27 0