SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    93938, 92908, 92679, 93934, 93931, 93930, 
    93929, 93927, 93907, 93906, 93905, 
    93902, 93796, 93784, 93544, 93459, 
    93069, 93068, 93797, 93774
  )

Query time 0.00044

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
92679 FBR339 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614988800 0 Y N N B N R Y N N Y 10 1614902400 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 James Dumbrell 1614932059 Y 2021-12-17 17:37:27 0
92908 VCR306 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614988800 0 Y N N B N R Y N N Y 10 1614902400 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 Hatfish Music Paul Glazby 1614932023 Y 2021-12-17 17:37:27 0
93068 Cheek514B P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 1616112000 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 5054285589007 GBKQU2100166 N Warner Chappell Music / Copyright Control Beverley Craven, James Williams, Bryan Sweeney, Kenny Hayes 1612329302 Y 2021-12-17 17:37:27 0
93069 Cheek514B P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 1616112000 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 5054285589007 GBKQU2100167 N Warner Chappell Music / Copyright Control Beverley Craven, James Williams, Bryan Sweeney, Kenny Hayes 1612329302 Y 2021-12-17 17:37:27 0
93459 HOT081 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 1616112000 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 5054285702178 GBKQU2119964 N Hot Box Digital The Hoover Jocks 1613669403 Y 2021-12-17 17:37:27 0
93544 WLHH024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 Garath Roberts 1614422992 Y 2021-12-17 17:37:27 0
93774 HF030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614582624 0 Y N N B N R Y N N Y 10 1614556800 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 Digital Paul Clark 1642190554 Y 2021-12-17 17:37:27 0
93784 KR013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 Martin Harrison/Nick Hayward 1643751769 Y 05/03/2021 04/04/2021 2021-12-17 17:37:27 0
93796 UBT047 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 Unbounded Traxx Damien Blanes 1614670661 Y 2021-12-17 17:37:27 0
93797 ST10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614676039 0 Y N N B N R Y N N Y 10 1614643200 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 Muisc James Nardi 1614676519 Y 2021-12-17 17:37:27 0
93902 SSD036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 Pete Warwick 1616186234 Y 2021-12-17 17:37:27 0
93905 BZK079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 Owens / James Jackson 1614795697 Y 2021-12-17 17:37:27 0
93906 TBR210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 Carl Yates 1614795916 Y 2021-12-17 17:37:27 0
93907 VRF003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 1614960460 Y 2021-12-17 17:37:27 0
93927 HLXR069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 GB9W52100001 N Toolbox Publishing Rob Yellowley 1641938292 Y 05/03/2021 04/04/2021 2021-12-17 17:37:27 0
93929 KK002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614926986 0 Y N N B N R Y N N Y 10 1614902400 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 1614927620 Y 2021-12-17 17:37:27 0
93930 IA011A P A 1 1.69 1 0.000 0 0 0 0.00 0 1614939471 0 Y N N B N R Y N N Y 10 1614902400 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/ Ben Miles 1614940223 Y 2021-12-17 17:37:27 0
93931 IA011B P A 1 1.69 1 0.000 0 0 0 0.00 0 1614939519 0 Y N N B N R Y N N Y 10 1614902400 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 1614940242 Y 2021-12-17 17:37:27 0
93934 DS033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614966099 0 Y N N B N R Y N N Y 10 1614902400 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 Digital Snail Gary O'Connor 1614966323 Y 2021-12-17 17:37:27 0
93938 TMP172 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615039799 0 Y N N B N R Y N N Y 10 1614988800 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 Aynsley Byrne 1615040123 Y 2021-12-17 17:37:27 0