SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    99381, 99279, 92940, 99916, 99866, 99806, 
    99805, 99804, 99790, 99789, 99753, 
    99751, 99439, 99434, 99429, 99278, 
    99257, 99219, 99372, 99360
  )

Query time 0.00043

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
92940 VCR339 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Ben Stevens 1612124712 Y 2021-12-17 17:37:27 0
99219 HWR022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 Hooverweight Records Jud Roper 1632311231 Y 2021-12-17 17:37:27 0
99257 FT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 Casey Fournere 1632336554 Y 2021-12-17 17:37:27 0
99278 TB20R012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 / Hatfish Music Nik Denton / Paul Glazby 1632561888 Y 2021-12-17 17:37:27 0
99279 TB20R013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 / Truelove Music Nik Denton / Justin Bourne / Dom Sweeten 1632561975 Y 2021-12-17 17:37:27 0
99360 RR10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634079600 0 Y N N B N R Y N N Y 10 1634079600 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 RipRoar Digital Dark Suspects 1652287373 Y 2021-12-17 17:37:27 0
99372 KD-002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634166000 0 Y N N B N R Y N N Y 10 1634166000 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 K-Zone Digital Danny Gilligan/James Nardi 1634885303 Y 2021-12-17 17:37:27 0
99381 HOT088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 1636070400 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 5054286198079 GBLV62104831 N Hot Box Digital Gaz Pritchard & Team Sly 1632848705 Y 2021-12-17 17:37:27 0
99429 FD059 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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;} 3 N Copyright Control Dan Carter 1633530121 Y 2021-12-17 17:37:27 0
99434 FBR344 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 Peter Davidson 1632945712 Y 2021-12-17 17:37:27 0
99439 VR010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 Slenderman/Ross Farley 1632975123 Y 2021-12-17 17:37:27 0
99751 TBHH037a P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 1634149696 Y 2021-12-17 17:37:27 0
99753 NITROX122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 Toolbox Publishing / 23rd Precinct James Jackson / Frank Farrell 1642451706 Y 2021-12-17 17:37:27 0
99789 FCPEP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 Full Circle Productions Zillin Redeker 1634240819 Y 2021-12-17 17:37:27 0
99790 FCPEP002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634252400 0 Y N N B N R Y N N Y 10 1634252400 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 Full Circle Productions Andrew Holmes 1634241695 Y 2021-12-17 17:37:27 0
99804 FSD002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634283854 0 Y N N B N R Y N N Y 10 1634252400 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 Ben Warren 1634283921 Y 2021-12-17 17:37:27 0
99805 IA022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634287528 0 Y N N B N R Y N N Y 10 1634252400 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 Ben Miles 1634288424 Y 2021-12-17 17:37:27 0
99806 BDR018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634309908 0 Y N N B N R Y N N Y 10 1634252400 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 Jud Roper 1643557589 Y 15/10/2021 14/11/2021 2021-12-17 17:37:27 0
99866 HF059 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634540379 0 Y N N B N R Y N N Y 10 1634511600 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 Toolbox Digital Graham Jenkins/Gem Stone 1635001155 Y 2021-12-17 17:37:27 0
99916 WLHH031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634848036 0 Y N N B N R Y N N Y 10 1634770800 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 Welovehardhouse Rick James 1634848223 Y 2021-12-17 17:37:27 0