SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    98376, 98365, 98364, 98362, 98353, 98226, 
    98177, 97708, 97684, 97679, 97678, 
    97664, 98178, 98267, 98266, 98265, 
    98264, 98263, 98262, 98261
  )

Query time 0.00037

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
97664 DS035 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 Craig Jones 1626161104 Y 2021-12-17 17:37:27 0
97678 ED010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 1630018800 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 5054285942611 GBKQU2163077 N Copyright Control Alpha A 1626239103 Y 2021-12-17 17:37:27 0
97679 ED010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 1630018800 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 5054285942611 GBKQU2163078 N Copyright Control Alpha A 1626239103 Y 2021-12-17 17:37:27 0
97684 ED012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 1630018800 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 5054285967317 GBKQU2167265 N Copyright control Jay Goodall & Legion 1626239703 Y 2021-12-17 17:37:27 0
97708 PMD042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 1630018800 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 5054286046271 GBKQU2180281 N Pumped Drake Liddell 1626455101 Y 2021-12-17 17:37:27 0
98177 TB20R002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 Andy Farley / Ross Homson 1628075498 Y 2021-12-17 17:37:27 0
98178 RRR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628636400 0 Y N N B N R Y N N Y 10 1628636400 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 Phil Wale Phil Wale 1642013789 Y 11/08/2021 10/09/2021 2021-12-17 17:37:27 0
98226 GARH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 1642254577 Y 13/08/2021 12/09/2021 2021-12-17 17:37:27 0
98261 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor/Chris Waddleton 1628596573 Y 2021-12-17 17:37:27 0
98262 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor/Wayne Smart 1628596574 Y 2021-12-17 17:37:27 0
98263 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor 1628596574 Y 2021-12-17 17:37:27 0
98264 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor/Joel Burns 1628596564 Y 2021-12-17 17:37:27 0
98265 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Paul Norris/Gary O'Connor 1628596563 Y 2021-12-17 17:37:27 0
98266 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor 1628596562 Y 2021-12-17 17:37:27 0
98267 DSBC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor 1628596560 Y 2021-12-17 17:37:27 0
98353 FRISKY007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 Boris The Noss 1633878715 Y 2021-12-17 17:37:27 0
98362 SSD046 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 Tara N 1636017932 Y 2021-12-17 17:37:27 0
98364 DIP RMX3037/2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 UKWDN2100006 N Dip Music Mik Cree/Rich Page/Gordi Elliot 1628774661 Y 2021-12-17 17:37:27 0
98365 DIP RMX3037/1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 UKWDN2100005 N Dip Music Mik Cree/Rich Page/Gordi Elliot 1628775015 Y 2021-12-17 17:37:27 0
98376 FCP004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 Adam Bennett 1628790389 Y 2021-12-17 17:37:27 0