SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    99122, 99121, 99120, 99119, 99106, 99104, 
    99099, 99052, 98970, 98764, 98763, 
    98762, 98761, 98760, 98759, 98758, 
    98757, 98756, 98755, 98754
  )

Query time 0.00039

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
98754 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195737 N 98764 Hot Box Digital Various Artists 1630516507 Y 2021-12-17 17:37:27 0
98755 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195738 N 98764 Hot Box Digital Various Artists 1630516507 Y 2021-12-17 17:37:27 0
98756 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195739 N 98764 Hot Box Digital Various Artists 1630516507 Y 2021-12-17 17:37:27 0
98757 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195740 N 98764 Hot Box Digital Various Artists 1630516507 Y 2021-12-17 17:37:27 0
98758 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195741 N 98764 Hot Box Digital Various Artists 1630516507 Y 2021-12-17 17:37:27 0
98759 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195742 N 98764 Hot Box Digital Various Artists 1630516507 Y 2021-12-17 17:37:27 0
98760 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195743 N 98764 Hot Box Digital Various Artists 1630516508 Y 2021-12-17 17:37:27 0
98761 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195744 N 98764 Hot Box Digital Various Artists 1630516508 Y 2021-12-17 17:37:27 0
98762 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195745 N 98764 Hot Box Digital Various Artists 1630516508 Y 2021-12-17 17:37:27 0
98763 BOX004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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 5054286141877 GBKQU2195746 N 98764 Hot Box Digital Various Artists 1630516509 Y 2021-12-17 17:37:27 0
98764 BOX004 P A 1 8.99 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 1633042800 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;} 13 labelworx 5054286141877 Y 1743769570 Y 2021-12-17 17:37:27 0
98970 GAR018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 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 Craig Bywater, Dale Dean 1642253398 Y 17/09/2021 17/10/2021 2021-12-17 17:37:27 0
99052 FSD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 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 Barney Coombs 1631704423 Y 2021-12-17 17:37:27 0
99099 TBHH036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 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 / Copyright Control Andrew Shenton / Matt Smith 1631735206 Y 2021-12-17 17:37:27 0
99104 FD057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 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 Phil Wale 1631788419 Y 2021-12-17 17:37:27 0
99106 EM007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 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 Grabowski 1631809906 Y 2021-12-17 17:37:27 0
99119 FCP010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 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 Graham Jenkins 1631817507 Y 2021-12-17 17:37:27 0
99120 BB033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631833200 0 Y N N B N R Y N N Y 10 1631833200 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 1631819814 Y 2021-12-17 17:37:27 0
99121 IA019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631873384 0 Y N N B N R Y N N Y 10 1631833200 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 Zillin Redeker/Tara Nicholson 1631873726 Y 2021-12-17 17:37:27 0
99122 NFR011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631874404 0 Y N N B N R Y N N Y 10 1631833200 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 GBKQU2195946 N Fevah Records Alexei Reynolds, Eoin Richards 1631876220 Y 2021-12-17 17:37:27 0