SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    82152, 82121, 82120, 82572, 82433, 82432, 
    82543, 82541, 82540, 82467, 83931, 
    82483, 82434, 81978, 81977, 82361, 
    82230, 82235, 82001, 82000
  )

Query time 0.00043

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
81977 Cheek451 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576195200 0 Y N N B N R Y N N Y 10 1576195200 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 5054284594521 GBKQU1982788 N Copyright Control Patrick Donelan 1573707632 Y 2021-12-17 17:37:27 0
81978 Cheek451 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576195200 0 Y N N B N R Y N N Y 10 1576195200 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 5054284594521 GBKQU1989087 N Copyright Control Patrick Donelan 1573707632 Y 2021-12-17 17:37:27 0
82000 Evmix015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1575590400 0 Y N N B N R Y N N Y 10 1575590400 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 5054284722689 GBKQU1748327 N 82002 23rd Precinct Music Ltd Scott Brown 1573707657 Y 2021-12-17 17:37:27 0
82001 Evmix015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1575590400 0 Y N N B N R Y N N Y 10 1575590400 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 5054284722689 GBKQU1748396 N 82002 23rd Precinct Music Ltd Scott Brown 1573707658 Y 2021-12-17 17:37:27 0
82120 Cheek455 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576800000 0 Y N N B N R Y N N Y 10 1576800000 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 5054284594354 GBKQU1982787 N Copyright Control Randy Lewis 1574312407 Y 2021-12-17 17:37:27 0
82121 Cheek455 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576800000 0 Y N N B N R Y N N Y 10 1576800000 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 5054284594354 GBKQU1989043 N Copyright Control Randy Lewis 1574312407 Y 2021-12-17 17:37:27 0
82152 EvLeg12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576800000 0 Y N N B N R Y N N Y 10 1576800000 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 5054284744131 GBLV61919550 N 23rd Precinct Music Ltd Scott Brown, Tony Aungsoe 1574398809 Y 2021-12-17 17:37:27 0
82230 DNZF685 P A 1 1.69 1 0.000 0 0 0 0.00 0 1575936000 0 Y N N B N R Y N N Y 10 1575936000 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 5054284752792 GBLV61921078 N DNZ Records Garbie Project 1574830813 Y 2021-12-17 17:37:27 0
82235 DNZF683 P A 1 1.69 1 0.000 0 0 0 0.00 0 1575590400 0 Y N N B N R Y N N Y 10 1575590400 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 5054284750293 GBLV61920637 N DNZ Records Garbie Project 1574830827 Y 2021-12-17 17:37:27 0
82361 DNZF687 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576108800 0 Y N N B N R Y N N Y 10 1576108800 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 5054284756400 GBLV61921587 N DNZ Records Nova Scotia, Garbie Project 1575003601 Y 2021-12-17 17:37:27 0
82432 CATID057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576713600 0 Y N N B N R Y N N Y 10 1576713600 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 5054284764559 NLN6L1900069 N The Funky Cat Publishing H.C. van Dam, C.S. Jensen 1575435634 Y 2021-12-17 17:37:27 0
82433 CATID057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576713600 0 Y N N B N R Y N N Y 10 1576713600 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 5054284764559 NLN6L1900070 N The Funky Cat Publishing H.C. van Dam, C.S. Jensen 1575435634 Y 2021-12-17 17:37:27 0
82434 PTR101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576195200 0 Y N N B N R Y N N Y 10 1576195200 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 5054284763378 GBLV61922902 N Juan Carlos Caracena Martinez Juan Carlos Caracena Martinez 1575435634 Y 2021-12-17 17:37:27 0
82467 DNZF692 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576540800 0 Y N N B N R Y N N Y 10 1576540800 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 5054284767338 GBLV61923787 N DNZ Records MC Clarkie 1575608412 Y 2021-12-17 17:37:27 0
82483 DNZF688 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576195200 0 Y N N B N R Y N N Y 10 1576195200 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 5054284767321 GBLV61923786 N DNZ Records Rescue! 1575608419 Y 2021-12-17 17:37:27 0
82540 DNZ381 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576627200 0 Y N N B N R Y N N Y 10 1576627200 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 5054284769042 GBLV61924188 N DNZ Records DJ Chiki 1575954002 Y 2021-12-17 17:37:27 0
82541 DNZ381 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576627200 0 Y N N B N R Y N N Y 10 1576627200 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 5054284769042 GBLV61924189 N DNZ Records DJ Chiki 1575954002 Y 2021-12-17 17:37:27 0
82543 DNZ381 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576627200 0 Y N N B N R Y N N Y 10 1576627200 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 5054284769042 GBLV61924191 N DNZ Records DJ Chiki 1575954003 Y 2021-12-17 17:37:27 0
82572 DNZ382 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576713600 0 Y N N B N R Y N N Y 10 1576713600 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 5054284777085 GBLV61925613 N DNZ Records DJ Oskar 1576040409 Y 2021-12-17 17:37:27 0
83931 IR085 P A 1 1.69 1 0.000 0 0 0 0.00 0 1576454400 0 Y N N B N R Y N N Y 10 1576454400 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 5054284741987 GBLV61919150 N Innergize Records Strix 1581831579 Y 2021-12-17 17:37:27 0