SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    99218, 98671, 98706, 98162, 98629, 98621, 
    98620, 98619, 98614, 98611, 98610, 
    98594, 98482, 98439, 98438, 98429, 
    98180, 97985, 97983, 97982
  )

Query time 0.00051

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
97982 Cheek541 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 1631228400 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 5054285775974 GBKQU2132539 N Copyright Control Danny Gibson 1627449006 Y 2021-12-17 17:37:27 0
97983 Cheek541 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 1631228400 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 5054285775974 GBKQU2132540 N Copyright Control Danny Gibson 1627449007 Y 2021-12-17 17:37:27 0
97985 PMD044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 1631228400 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 5054286046356 GBKQU2180288 N Pumped Joe Longbottom 1627449302 Y 2021-12-17 17:37:27 0
98162 BTN017R P A 1 1.69 1 0.000 0 0 0 0.00 0 1630278000 0 Y N N B N R Y N N Y 10 1630278000 1631487600 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 labelworx 5054286081098 GBKQU2185922 N Bring The Noise Recordings Jason 'Kinetic' Hill. 1628010301 Y 2021-12-17 17:37:27 0
98180 WLHH029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Welovehardhouse Gordon John / Paul Saliba 1629390084 Y 2021-12-17 17:37:27 0
98429 UBT053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Captain Strange 1629277971 Y 2021-12-17 17:37:27 0
98438 EM006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Kieran Bradbury 1629382754 Y 2021-12-17 17:37:27 0
98439 SS092 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Slingshot Recordings Paul Norris/Pat Glenny 1629389816 Y 2021-12-17 17:37:27 0
98482 GARHT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Adam Bennett / Alexie Reynolds 1642255760 Y 27/08/2021 26/09/2021 2021-12-17 17:37:27 0
98594 FR136 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Rob Yellowley 1641484257 Y 27/08/2021 26/09/2021 2021-12-17 17:37:27 0
98610 TGR080 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Binty/Mitchell James/Paul Batten 1629959753 Y 2021-12-17 17:37:27 0
98611 BB030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Carl Yates 1637696059 Y 2021-12-17 17:37:27 0
98614 FCP007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Andrew Holmes 1630002432 Y 2021-12-17 17:37:27 0
98619 TMP184 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630069240 0 Y N N B N R Y N N Y 10 1630018800 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 Paul Hunter/Peter Davidson/Matt Clarkson 1630070127 Y 2021-12-17 17:37:27 0
98620 TB20R003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630081156 0 Y N N B N R Y N N Y 10 1630018800 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 Nik Denton / Ross Homson 1630081825 Y 2021-12-17 17:37:27 0
98621 TB20R004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630082288 0 Y N N B N R Y N N Y 10 1630018800 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 Marc Johnson 1630082726 Y 2021-12-17 17:37:27 0
98629 BDR014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630098196 0 Y N N B N R Y N N Y 10 1630018800 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 1643557410 Y 27/08/2021 26/09/2021 2021-12-17 17:37:27 0
98671 HF053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630391731 0 Y N N B N R Y N N Y 10 1630364400 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 Digital Si Mowling/Kev Pickford 1630392326 Y 2021-12-17 17:37:27 0
98706 PR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630364400 0 Y N N B N R Y N N Y 10 1630364400 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 Pulse 8 Records Michael Smith / Guy Mearns 1630444701 Y 2021-12-17 17:37:27 0
99218 HWR021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630450800 0 Y N N B N R Y N N Y 10 1630450800 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 Nico Ahlqvist 1632308588 Y 2021-12-17 17:37:27 0