SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    100147, 100146, 100145, 100000, 99981, 
    99977, 99976, 99975, 99974, 99961, 
    99926, 99925, 100304, 100253, 99999, 
    99998, 99997, 99897, 99896, 100294
  )

Query time 0.00048

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
99896 Cheek553A P A 1 1.69 1 0.000 0 0 0 0.00 0 1637280000 0 Y N N B N R Y N N Y 10 1637280000 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;} labelworx 5054286096290 GBKQU2188166 N Media Songs Andrea Remondini, Mario Piperno, Mauro Picotto, Riccardo Ferri 1634706304 Y 2021-12-17 17:37:27 0
99897 Cheek553A P A 1 1.69 1 0.000 0 0 0 0.00 0 1637280000 0 Y N N B N R Y N N Y 10 1637280000 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;} labelworx 5054286096290 GBKQU2188167 N Media Songs Andrea Remondini, Mario Piperno, Mauro Picotto, Riccardo Ferri 1698091596 Y 2021-12-17 17:37:27 0
99925 LTR18 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637539200 0 Y N N B N R Y N N Y 10 1637539200 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;} labelworx 5054286195405 GBLV62104499 N Copyright Control Ben Warren 1634966102 Y 2021-12-17 17:37:27 0
99926 LTR18 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637539200 0 Y N N B N R Y N N Y 10 1637539200 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;} labelworx 5054286195405 GBLV62104500 N Copyright Control Ben Warren 1634966102 Y 2021-12-17 17:37:27 0
99961 BMR2211 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637798400 0 Y N N B N R Y N N Y 10 1637798400 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;} labelworx 5054286186793 GBKQU2182667 N Beast Mode Recordings Scott Sell, Alexei Reynolds 1698091555 Y 2021-12-17 17:37:27 0
99974 TIBUK013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286204725 GBLV62106231 N Copyright Control Wayne Rixon 1635312902 Y 2021-12-17 17:37:27 0
99975 TIBUK013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286204725 GBLV62107665 N Copyright Control Wayne Rixon 1635312902 Y 2021-12-17 17:37:27 0
99976 TIBUK013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286204725 GBLV62107666 N Copyright Control Wayne Rixon 1635312902 Y 2021-12-17 17:37:27 0
99977 TIBUK013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286204725 GBLV62107667 N Copyright Control Wayne Rixon 1635312903 Y 2021-12-17 17:37:27 0
99981 UNTIDYUX006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286233947 GBLV62111100 N Toolbox Publishing, Truelove Music Nik Denton, Paul King 1698091617 Y 2021-12-17 17:37:27 0
99997 UNTIDYT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637280000 0 Y N N B N R Y N N Y 10 1637280000 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;} labelworx 5054286257639 GBLV62115936 N Tidy Publishing Jodie Doherty, Gary Whatley, Kris O'Rourke 1698091600 Y 2021-12-17 17:37:27 0
99998 UNTIDYT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637280000 0 Y N N B N R Y N N Y 10 1637280000 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;} labelworx 5054286257639 GBLV62115937 N Tidy Publishing Jodie Doherty, Gary Whatley, Kris O'Rourke 1698091544 Y 2021-12-17 17:37:27 0
99999 UNTIDYT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637280000 0 Y N N B N R Y N N Y 10 1637280000 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;} labelworx 5054286257639 GBLV62115938 N Tidy Publishing Jodie Doherty, Gary Whatley, Kris O'Rourke 1698091556 Y 2021-12-17 17:37:27 0
100000 TIDYD06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286256601 GBLV62115914 N Truelove Music Paul Maddox 1698091566 Y 2021-12-17 17:37:27 0
100145 UNTIUDYTR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286274681 GBLV62119210 N 100162 Copyright Control Ali Wilson 1698091610 Y 2021-12-17 17:37:27 0
100146 UNTIUDYTR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286274681 GBLV62119172 N 100162 Copyright Control Ali Wilson 1636089006 Y 2021-12-17 17:37:27 0
100147 UNTIUDYTR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637884800 0 Y N N B N R Y N N Y 10 1637884800 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;} labelworx 5054286274681 GBLV62119171 N 100162 Copyright Control Ali Wilson 1636089006 Y 2021-12-17 17:37:27 0
100253 SHARPD013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637280000 0 Y N N B N R Y N N Y 10 1637280000 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;} labelworx 5054286289838 GBLV62121899 N Copyright Control Patrick Cools, Stephane Durand 1698091818 Y 2021-12-17 17:37:27 0
100294 HDCSU004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636934400 0 Y N N B N R Y N N Y 10 1636934400 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;} labelworx 5054286291138 GBLV62122119 N 100295 Copyright Control Various Artists 1636785921 Y 2021-12-17 17:37:27 0
100304 INDHARD032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637280000 0 Y N N B N R Y N N Y 10 1637280000 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;} N Indicate Rob Hills, Mike Drain 1637005146 Y 2021-12-17 17:37:27 0