SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    100564, 100494, 100493, 100477, 100251, 
    100248, 100180, 99431, 99373, 93465, 
    100470, 100446, 100405, 100404, 100403, 
    100393, 100392, 100391, 100300, 100247
  )

Query time 0.00060

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
93465 VCR344 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;} 4 N Copyright Control Barmak Hatamian 1613683290 Y 2021-12-17 17:37:27 0
99373 KD-003 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 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 K-Zone Digital Baseglitz/Jay Key 1638307591 Y 2021-12-17 17:37:27 0
99431 FD062 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;} 3 N Copyright Control Bryn Whiting / Elle Mariachi 1636461311 Y 2021-12-17 17:37:27 0
100180 TTLFD019 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 N 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 Copyright Control Paul Clark 1642190522 Y 26/11/2021 26/12/2021 2021-12-17 17:37:27 0
100247 TB20R016 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;} 4 N Toolbox Publishing Nik Denton 1636663230 Y 2021-12-17 17:37:27 0
100248 TB20R017 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;} 4 N Truelove Music Paul King / Gonzalo Rivas 1636663285 Y 2021-12-17 17:37:27 0
100251 WLHH032 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;} 4 N Welovehardhouse Amp Attack / Paul King 1636665101 Y 2021-12-17 17:37:27 0
100300 GAR023 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;} 4 N Copyright Control Craig Bywater, Dale Dean 1642253870 Y 19/11/2021 19/12/2021 2021-12-17 17:37:27 0
100391 IA027 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;} 4 N Copyright Control Ant Roberts 1637258992 Y 2021-12-17 17:37:27 0
100392 FCP018 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;} 4 N Full Circle Productions Tara Nicholson 1637267490 Y 2021-12-17 17:37:27 0
100393 EM010 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;} 3 N Copyright Control Ben Miles/ Richard Senior 1637269532 Y 2021-12-17 17:37:27 0
100403 FSD003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637311684 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;} 4 N Toolbox Digital Martin Harrison/Ben Vennard 1637312421 Y 2021-12-17 17:37:27 0
100404 BDR022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637311836 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;} 4 N Copyright Control Jud Roper 1643558054 Y 19/11/2021 19/12/2021 2021-12-17 17:37:27 0
100405 BDR2-003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637312241 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;} 4 N Copyright Control Dave Grabowski 1643558144 Y 19/11/2021 19/12/2021 2021-12-17 17:37:27 0
100446 HF064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637571606 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;} 4 N Toolbox Digital Darrell White 1637572523 Y 2021-12-17 17:37:27 0
100470 SPINBALL058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1637602554 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;} 4 N Truelove Music Dom Sweeten 1637603130 Y 2021-12-17 17:37:27 0
100477 SPINBALL059 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;} 4 N Truelove Music Dom Sweeten 1637686593 Y 2021-12-17 17:37:27 0
100493 GAR024B 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 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 Dean Richardson/David Marsh 1642254128 Y 26/11/2021 26/12/2021 2021-12-17 17:37:27 0
100494 GAR024 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;} 4 N Toolbox Publishing, Copyright Control Gaz Fullard, Maria DiTomasso, David Jackson 1642253997 Y 26/11/2021 26/12/2021 2021-12-17 17:37:27 0
100564 PR004 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;} 4 N Pulse 8 Records Michael Smith & Filippo Del Moro 1637786601 Y 2021-12-17 17:37:27 0