SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    97698, 97697, 97696, 97695, 97669, 97655, 
    97558, 97393, 96323, 96738, 89235, 
    97593, 97584, 97095, 97094, 97582, 
    97562, 97561, 97511, 94776
  )

Query time 0.00045

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
89235 RRR024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626217200 0 Y N N B N R Y N N Y 10 1626217200 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 / Copyright Control Matt Pickup / Andy Farley 1642008595 Y 14/07/2021 13/08/2021 2021-12-17 17:37:27 0
94776 FD052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1625785200 0 Y N N B N R Y N N Y 10 1625785200 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 David Morrish 1624352680 Y 2021-12-17 17:37:27 0
96323 TBHH035a P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 / Ben Miles 1621581815 Y 2021-12-17 17:37:27 0
96738 ST18 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626303600 0 Y N N B N R Y N N Y 10 1626303600 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 Hatfish music James Nardi 1622908432 Y 2021-12-17 17:37:27 0
97094 BTN014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626044400 0 Y N N B N R Y N N Y 10 1626044400 1627254000 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 5054285992326 GBKQU2171281 N Bring the noise recordings Jason 'Nawty' Briley & Laura Skelton 1624296303 Y 2021-12-17 17:37:27 0
97095 BTN014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626044400 0 Y N N B N R Y N N Y 10 1626044400 1627254000 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 5054285992326 GBKQU2171282 N Bring the noise recordings Jason 'Nawty' Briley & Laura Skelton 1624296304 Y 2021-12-17 17:37:27 0
97393 HWR020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 Hooverweight Records Tara N 1711483246 Y 2021-12-17 17:37:27 0
97511 GAR013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1625785200 0 Y N N B N R Y N N Y 10 1625785200 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 Andrew Holmes 1642252826 Y 09/07/2021 08/08/2021 2021-12-17 17:37:27 0
97558 WLHH028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 Ben Warren 1625920644 Y 2021-12-17 17:37:27 0
97561 BB026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1625811579 0 Y N N B N R Y N N Y 10 1625785200 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 1625812225 Y 2021-12-17 17:37:27 0
97562 IA016B P A 1 1.69 1 0.000 0 0 0 0.00 0 1625822308 0 Y N N B N R Y N N Y 10 1625785200 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 Boski/BizarreQ 1625823027 Y 2021-12-17 17:37:27 0
97582 Buz105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1625922317 0 Y N N B N R Y N N Y 10 1625871600 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 Sean Stanley 1627735690 Y 2021-12-17 17:37:27 0
97584 ESP075 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626044400 0 Y N N B N R Y N N Y 10 1626044400 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 1626006768 Y 2021-12-17 17:37:27 0
97593 HF047 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626074701 0 Y N N B N R Y N N Y 10 1626044400 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 David Jackson/Danny Clark 1626075025 Y 2021-12-17 17:37:27 0
97655 GARH002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 Dean Richardson/Paul Hunter 1642254475 Y 16/07/2021 15/08/2021 2021-12-17 17:37:27 0
97669 TMP180 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 Karl Davies/Wayne German 1626177265 Y 2021-12-17 17:37:27 0
97695 FCP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 Full Circle Productions Andrew Holmes, Rob Yellowley 1647283708 Y 2021-12-17 17:37:27 0
97696 SSD045 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 Auto N Sugar Skull Digital Boski 1626303991 Y 2021-12-17 17:37:27 0
97697 DIP 3034/2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 UKWDN2100004 N Dip Music Alan Brown 1628339463 Y 2021-12-17 17:37:27 0
97698 DIP 3034/1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626390000 0 Y N N B N R Y N N Y 10 1626390000 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 UKWDN2100003 N Dip Music Alan Brown 1628339416 Y 2021-12-17 17:37:27 0