SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    98021, 98020, 98019, 98018, 98017, 98016, 
    98015, 98014, 97917, 97758, 97671, 
    97663, 97471, 97470, 97469, 97468, 
    97292, 97291, 97178, 89232
  )

Query time 0.00045

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
89232 RRR025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627426800 0 Y N N B N R Y N N Y 10 1627426800 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 Matt Pickup / Stevie-Louise Pickup 1642008394 Y 28/07/2021 27/08/2021 2021-12-17 17:37:27 0
97178 UBT052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Fabio Seramota 1624618552 Y 2021-12-17 17:37:27 0
97291 ED011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 1628809200 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 5054285942710 GBKQU2163091 N Copyright Control D-Fi and KP 1625030704 Y 2021-12-17 17:37:27 0
97292 ED011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 1628809200 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 5054285942710 GBKQU2163092 N Copyright Control D-Fi and KP 1625030704 Y 2021-12-17 17:37:27 0
97468 Cheek536B P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054285895757 GBKQU2153781 N Copyright Control Andreas Till, Dirk Hilger, Roland Kugler, Sacha Collisson, Simon Greenaway, Hans Hartel 1627676571 Y 2021-12-17 17:37:27 0
97469 Cheek536B P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054285895757 GBKQU2143600 N Copyright Control Andreas Till, Dirk Hilger, Roland Kugler, Sacha Collisson, Simon Greenaway, Hans Hartel 1627676594 Y 2021-12-17 17:37:27 0
97470 Cheek536B P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054285895757 GBKQU2153782 N Copyright Control Andreas Till, Dirk Hilger, Roland Kugler, Sacha Collisson, Simon Greenaway, Hans Hartel 1627676619 Y 2021-12-17 17:37:27 0
97471 Cheek536B P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054285895757 GBKQU2153783 N Copyright Control Andreas Till, Dirk Hilger, Roland Kugler, Sacha Collisson, Simon Greenaway, Hans Hartel 1627676642 Y 2021-12-17 17:37:27 0
97663 DS034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Martin Cook 1626161102 Y 2021-12-17 17:37:27 0
97671 TMP182 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Tempo Trax Dean Richardson 1628272493 Y 2021-12-17 17:37:27 0
97758 GARH003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Rikki Shane 1642254523 Y 30/07/2021 29/08/2021 2021-12-17 17:37:27 0
97917 EM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Adrian John HoggBuss 1646337416 Y 30/07/2021 29/08/2021 2021-12-17 17:37:27 0
98014 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Gaz Pritchard 1627462046 Y 2021-12-17 17:37:27 0
98015 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Team Sly 1627463068 Y 2021-12-17 17:37:27 0
98016 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Vandalize/Pete Maxwell 1629127460 Y 2021-12-17 17:37:27 0
98017 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Team Sly/Unit DVSN 1627463077 Y 2021-12-17 17:37:27 0
98018 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Vandalize & Team Sly 1627463080 Y 2021-12-17 17:37:27 0
98019 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Darrell White 1627463083 Y 2021-12-17 17:37:27 0
98020 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Naughty Tempo 1627463086 Y 2021-12-17 17:37:27 0
98021 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Mickey Bo/Mickey G 1627463088 Y 2021-12-17 17:37:27 0