SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    98472, 98471, 98470, 98469, 98468, 98467, 
    98430, 98392, 98377, 97901, 97817, 
    97108, 92932, 92931, 98391, 98386, 
    92930, 98380, 98379, 98378
  )

Query time 0.00070

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
92930 VCR329 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628895600 0 Y N N B N R Y N N Y 10 1628809200 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 Joe Bloggs 1628848450 Y 2021-12-17 17:37:27 0
92931 VCR330 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 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 Tim Clowes 1612124200 Y 2021-12-17 17:37:27 0
92932 VCR330 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 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 Tim Clowes 1612124251 Y 2021-12-17 17:37:27 0
97108 FD055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 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 Carl Pearce / Cheryl Pearce 1624355167 Y 2021-12-17 17:37:27 0
97817 PMD043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 1630623600 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 5054286046325 GBKQU2180284 N Pumped Joe Longbottom 1626844206 Y 2021-12-17 17:37:27 0
97901 UTHHD049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 1630623600 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 5054286063117 GBKQU2182929 N Ultratech Dance Music UK Tara Nicholson 1627059902 Y 2021-12-17 17:37:27 0
98377 TTLFD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 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 Joshua Brown/Liam McDermott 1641760647 Y 20/08/2021 19/09/2021 2021-12-17 17:37:27 0
98378 PDR049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628833147 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 Pat Glenny 1628833528 Y 2021-12-17 17:37:27 0
98379 BB029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628842534 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 Ben Miles / Tara Nicholson / Jared Nes 1637696072 Y 2021-12-17 17:37:27 0
98380 BDR013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628853146 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 Sam Didden / Aaron Reichert 1643636214 Y 13/08/2021 12/09/2021 2021-12-17 17:37:27 0
98386 FCP005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628969716 0 Y N N B N R Y N N Y 10 1628895600 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 Peter Edwards 1628970329 Y 2021-12-17 17:37:27 0
98391 HF051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629097930 0 Y N N B N R Y N N Y 10 1629068400 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 Gary Toomey/Peter Maxwell 1629127119 Y 2021-12-17 17:37:27 0
98392 GAR015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 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 Matt Clarkson 1642253104 Y 20/08/2021 19/09/2021 2021-12-17 17:37:27 0
98430 KT011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629414000 0 Y N N B N R Y N N Y 10 1629414000 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 Kaki Trax Paul Norris 1629297796 Y 2021-12-17 17:37:27 0
98467 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629453995 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454525 Y 2021-12-17 17:37:27 0
98468 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454049 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454540 Y 2021-12-17 17:37:27 0
98469 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454097 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629455417 Y 2021-12-17 17:37:27 0
98470 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454167 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454651 Y 2021-12-17 17:37:27 0
98471 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454210 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454672 Y 2021-12-17 17:37:27 0
98472 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454259 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454691 Y 2021-12-17 17:37:27 0