SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    99645, 98789, 89238, 99517, 98766, 92937, 
    99473, 99472, 99471, 99470, 99469, 
    99467, 99466, 99442, 99437, 99432, 
    99428, 99414, 99276, 99271
  )

Query time 0.00041

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
89238 RRR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633474800 0 Y N N B N R Y N N Y 10 1633474800 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 Matt Pickup / Tom Parr 1642008856 Y 06/10/2021 05/11/2021 2021-12-17 17:37:27 0
92937 VCR336 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633129200 0 Y N N B N R Y N N Y 10 1633042800 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 Toolbox Publishing Aaron Crozier / Seanie Jackson / Adam Butler 1633072733 Y 2021-12-17 17:37:27 0
98766 ATRREGEN02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633129200 0 Y N N B N R Y N N Y 10 1633129200 1634338800 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 5054286138280 GBKQU2195008 N Copyright Control Dan Roubtsov 1630559401 Y 2021-12-17 17:37:27 0
98789 ATRREGEN03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633474800 0 Y N N B N R Y N N Y 10 1633474800 1634684400 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 5054286138297 GBKQU2195009 N Copyright Control Dan Roubtsov 1630904705 Y 2021-12-17 17:37:27 0
99271 GAR020B P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 Alexie Reynolds 1642253658 Y 01/10/2021 31/10/2021 2021-12-17 17:37:27 0
99276 TB20R010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 Truelove Music / Toolbox Publishing Nik Denton / Paul King 1632561785 Y 2021-12-17 17:37:27 0
99414 FLY016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 FiveOne/KP 1632862113 Y 2021-12-17 17:37:27 0
99428 FD058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 Aaron James / Barbie Ambrose / Damien Blanes 1632911513 Y 2021-12-17 17:37:27 0
99432 HLXR071 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 GB9W52100003 N Copyright Control Karl Davies 1642174546 Y 01/10/2021 31/10/2021 2021-12-17 17:37:27 0
99437 VRF013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 Lab 4/Slenderman 1632967545 Y 2021-12-17 17:37:27 0
99442 FBR342 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 Ben Stevens, Tanya Sly, Gary Sly 1632983377 Y 2021-12-17 17:37:27 0
99466 EM008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 David Marsh 1633024563 Y 2021-12-17 17:37:27 0
99467 FCP012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633042800 0 Y N N B N R Y N N Y 10 1633042800 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 Alpha A 1633030396 Y 2021-12-17 17:37:27 0
99469 TGR081 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633066823 0 Y N N B N R Y N N Y 10 1633042800 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 Matt Smith/Ryan Harris 1633067388 Y 2021-12-17 17:37:27 0
99470 PDR056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633074611 0 Y N N B N R Y N N Y 10 1633042800 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 Stuart Moir 1633087844 Y 2021-12-17 17:37:27 0
99471 XA021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633075878 0 Y N N B N R Y N N Y 10 1633042800 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 xxxx N Copy Control Dion Phillips 1633076627 Y 2021-12-17 17:37:27 0
99472 BDR016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633076276 0 Y N N B N R Y N N Y 10 1633042800 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 Darragh Mulligan 1643557500 Y 01/10/2021 31/10/2021 2021-12-17 17:37:27 0
99473 IA021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633081528 0 Y N N B N R Y N N Y 10 1633042800 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 Graham Jenkins 1633082486 Y 2021-12-17 17:37:27 0
99517 HF057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633332201 0 Y N N B N R Y N N Y 10 1633302000 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 Phil Wale 1633332631 Y 2021-12-17 17:37:27 0
99645 DD156 P A 1 1.69 1 0.000 0 0 0 0.00 0 1633546670 0 Y N N B N R Y N N Y 10 1633474800 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 GBLV62108248 N Copyright Control Jolene 1633546827 Y 2021-12-17 17:37:27 0