SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    93232, 1645, 93574, 93526, 93067, 93064, 
    93063, 93003, 93002, 93001, 93000, 
    92999, 92998, 92997, 92996, 92995, 
    92994, 92993, 92992, 92991
  )

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
1645 twistedtraxx78 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B Y R Y N N Y 10 1615507200 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;} TDISC004D N twisted traxx rikrom 1610714575 Y 2021-12-17 17:37:27 0
92991 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU0908042 N 93004 Copyright Control Various Artists 1612199725 Y 2021-12-17 17:37:27 0
92992 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1872200 N 93004 Copyright Control Various Artists 1612199725 Y 2021-12-17 17:37:27 0
92993 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1875273 N 93004 Copyright Control Various Artists 1612199725 Y 2021-12-17 17:37:27 0
92994 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632036 N 93004 Copyright Control Various Artists 1612199726 Y 2021-12-17 17:37:27 0
92995 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU0907633 N 93004 Copyright Control Various Artists 1612199726 Y 2021-12-17 17:37:27 0
92996 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632038 N 93004 Copyright Control Various Artists 1612199726 Y 2021-12-17 17:37:27 0
92997 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU0907019 N 93004 Copyright Control Various Artists 1612199726 Y 2021-12-17 17:37:27 0
92998 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632025 N 93004 Copyright Control Various Artists 1612199726 Y 2021-12-17 17:37:27 0
92999 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1872206 N 93004 Copyright Control Various Artists 1612199727 Y 2021-12-17 17:37:27 0
93000 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1872194 N 93004 Copyright Control Various Artists 1612199727 Y 2021-12-17 17:37:27 0
93001 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBLV61632033 N 93004 Copyright Control Various Artists 1612199727 Y 2021-12-17 17:37:27 0
93002 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU1872207 N 93004 Copyright Control Various Artists 1612199727 Y 2021-12-17 17:37:27 0
93003 BORHH1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614729600 0 Y N N B N R Y N N Y 10 1614729600 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 5054285441435 GBKQU0908047 N 93004 Copyright Control Various Artists 1612199728 Y 2021-12-17 17:37:27 0
93063 Cheek514A P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 5054285545966 GBKQU2092539 N Warner Chappell Music / Copyright Control Beverley Craven, James Williams, Bryan Sweeney, Kenny Hayes 1612329002 Y 2021-12-17 17:37:27 0
93064 Cheek514A P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 5054285545966 GBLV62033785 N Warner Chappell Music / Copyright Control Beverley Craven, James Williams, Bryan Sweeney, Kenny Hayes 1619644359 Y 2021-12-17 17:37:27 0
93067 ST026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 5054285626580 GBKQU2106648 N Copyright Control Ben Warren 1619644363 Y 2021-12-17 17:37:27 0
93232 CR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615507200 0 Y N N B N R Y N N Y 10 1615507200 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 5054285632055 GBKQU2107588 N Copyright Control John Evans 1619644366 Y 2021-12-17 17:37:27 0
93526 PTR156 P A 1 1.69 1 0.000 0 0 0 0.00 0 1614902400 0 Y N N B N R Y N N Y 10 1614902400 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 5054285707807 GBKQU2120951 N Power Tracks Records Power Tracks Records 1614014405 Y 2021-12-17 17:37:27 0
93574 DNZF959 P A 1 1.69 1 0.000 0 0 0 0.00 0 1615161600 0 Y N N B N R Y N N Y 10 1615161600 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 5054285713464 GBKQU2121725 N DNZ Records DJ Pulse 1614143702 Y 2021-12-17 17:37:27 0