SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    80587, 80567, 80015, 80010, 80009, 80004, 
    80472, 103007, 80448, 80001, 80272, 
    80080, 80079, 80078, 80077, 80076, 
    80075, 80074, 80073, 80072
  )

Query time 0.00039

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
80001 BR0058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567206000 0 Y N N B N R Y N N Y 10 1567206000 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 5054284552651 GBKQU1981039 N Peer Music G. May, E. Ash, R. McFarland 1565240403 Y 2021-12-17 17:37:27 0
80004 CheekWE14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567724400 0 Y N N B N R Y N N Y 10 1567724400 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 5054284479347 GBKQU1687279 N 80023 Copyright Control Various Artists 1565240405 Y 2021-12-17 17:37:27 0
80009 CheekWE14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567724400 0 Y N N B N R Y N N Y 10 1567724400 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 5054284479347 GBLV61608176 N 80023 Copyright Control Various Artists 1565240406 Y 2021-12-17 17:37:27 0
80010 CheekWE14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567724400 0 Y N N B N R Y N N Y 10 1567724400 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 5054284479347 GBKQU1732987 N 80023 Copyright Control Various Artists 1565240406 Y 2021-12-17 17:37:27 0
80015 CheekWE14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567724400 0 Y N N B N R Y N N Y 10 1567724400 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 5054284479347 GBKQU1955041 N 80023 Copyright Control Various Artists 1565240406 Y 2021-12-17 17:37:27 0
80072 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1291649 N 80081 Copyright Control Various Artists 1565413248 Y 2021-12-17 17:37:27 0
80073 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 AU5T41200062 N 80081 Copyright Control Various Artists 1565413248 Y 2021-12-17 17:37:27 0
80074 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1017378 N 80081 Copyright Control Various Artists 1565413248 Y 2021-12-17 17:37:27 0
80075 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1019747 N 80081 Copyright Control Various Artists 1565413248 Y 2021-12-17 17:37:27 0
80076 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1022990 N 80081 Copyright Control Various Artists 1565413248 Y 2021-12-17 17:37:27 0
80077 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1357160 N 80081 Copyright Control Various Artists 1565413248 Y 2021-12-17 17:37:27 0
80078 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1766185 N 80081 Copyright Control Various Artists 1565413249 Y 2021-12-17 17:37:27 0
80079 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1900962 N 80081 Copyright Control Various Artists 1565413249 Y 2021-12-17 17:37:27 0
80080 LWHDB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284560465 GBKQU1399143 N 80081 Copyright Control Various Artists 1565413249 Y 2021-12-17 17:37:27 0
80272 DNZF616 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567119600 0 Y N N B N R Y N N Y 10 1567119600 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 5054284571362 GBKQU1984567 N DNZ Records Que & Rkay 1566363602 Y 2021-12-17 17:37:27 0
80448 DNZF617 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567378800 0 Y N N B N R Y N N Y 10 1567378800 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 5054284587127 GBKQU1987461 N DNZ Records DJ Miho 1567054818 Y 2021-12-17 17:37:27 0
80472 DNZF620 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567638000 0 Y N N B N R Y N N Y 10 1567638000 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 5054284588872 GBKQU1987818 N DNZ Records Alec Fury 1567141203 Y 2021-12-17 17:37:27 0
80567 DNZF621 P A 1 1.69 1 0.000 0 0 0 0.00 0 1567983600 0 Y N N B N R Y N N Y 10 1567983600 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 5054284595610 GBKQU1989268 N DNZ Records DJ Joe Mc 1567659602 Y 2021-12-17 17:37:27 0
80587 DNZF622 P A 1 1.69 1 0.000 0 0 0 0.00 0 1568070000 0 Y N N B N R Y N N Y 10 1568070000 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 5054284595634 GBKQU1989270 N DNZ Records Jamie B 1567659608 Y 2021-12-17 17:37:27 0
103007 T25DJP05D P A 1 1.69 1 0.000 0 0 0 0.00 0 1567551600 0 Y N N B N R Y N N Y 10 1567551600 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 5054286475002 GBKQU1949525 N 103016 Copyright Control Various Artists 1644527216 Y 2022-02-10 18:31:10 0