SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    92453, 92452, 92451, 1643, 92832, 92831, 
    92670, 92669, 92275, 92274, 92272, 
    92271, 92270, 92269, 92268, 92061, 
    92008, 91998, 92557, 92500
  )

Query time 0.00055

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
1643 twistedtraxx76 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B Y R Y N N Y 10 1613088000 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;} TDISC004B N twisted traxx prohibited 1610714354 Y 2021-12-17 17:37:27 0
91998 BTIDMUSIC088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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 5054285552810 GBLV62035076 N BTID Music Wigman, Hayes 1617959153 Y 2021-12-17 17:37:27 0
92008 UNTIDY042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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 5054285532805 GBLV62031476 N Toolbox Publishing James Revill 1617959155 Y 2021-12-17 17:37:27 0
92061 ravenew20205 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611964800 0 Y N N B N R Y N N Y 10 1611964800 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 5054285564806 UK7J92000007 N Rave essentials David Bridson 1609391104 Y 2021-12-17 17:37:27 0
92268 Cheek509 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285413197 GBLV62010009 N Copyright Control Bernd Burhoff, Jens Oettrich, Oliver Froning 1609909505 Y 2021-12-17 17:37:27 0
92269 Cheek509 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285413197 GBLV62010010 N Copyright Control Bernd Burhoff, Jens Oettrich, Oliver Froning 1609909506 Y 2021-12-17 17:37:27 0
92270 Cheek509 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285413197 GBLV62010011 N Copyright Control Bernd Burhoff, Jens Oettrich, Oliver Froning 1609909506 Y 2021-12-17 17:37:27 0
92271 Cheek509 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285413197 GBLV62010012 N Copyright Control Bernd Burhoff, Jens Oettrich, Oliver Froning 1609909506 Y 2021-12-17 17:37:27 0
92272 Cheek509 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285413197 GBLV62010013 N Copyright Control Bernd Burhoff, Jens Oettrich, Oliver Froning 1609909506 Y 2021-12-17 17:37:27 0
92274 ST023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285539866 GBLV62032749 N Copyright control Dan Hall 1617959158 Y 2021-12-17 17:37:27 0
92275 ST023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285539866 GBLV62032750 N Copyright control Dan Hall 1609909507 Y 2021-12-17 17:37:27 0
92451 BTIDMUSIC086 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 5054285552865 GBLV62035079 N BTID Music Trengove, Hayes 1617959160 Y 2021-12-17 17:37:27 0
92452 CR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 5054285595732 GBKQU2101487 N Copyright Control John Hemming 1617959162 Y 2021-12-17 17:37:27 0
92453 UNTIDYUX01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 5054285602522 GBKQU2102432 N Truelove Music Various Artists 1617959165 Y 2021-12-17 17:37:27 0
92500 TIDYBAEP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 5054285620359 GBKQU2105352 N Copyright Control Various Artists 1617959151 Y 2021-12-17 17:37:27 0
92557 DNZ434 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611705600 0 Y N N B N R Y N N Y 10 1611705600 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 5054285626900 GBKQU2106702 N DNZ Records Daz McGregor 1610991030 Y 2021-12-17 17:37:27 0
92669 BTIDMUSIC066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285632901 GBKQU2107699 N Copyright Control Hayes, Farrell, Parsons 1611162901 Y 2021-12-17 17:37:27 0
92670 BTIDMUSIC066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285632901 GBKQU2107700 N Copyright Control Hayes, Farrell, Parsons 1611162901 Y 2021-12-17 17:37:27 0
92831 DNZ435 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285650585 GBKQU2110713 N DNZ Records Adelle 1611767405 Y 2021-12-17 17:37:27 0
92832 DNZ435 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285650585 GBKQU2110715 N DNZ Records Adelle 1611767408 Y 2021-12-17 17:37:27 0