SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    68092, 76582, 65927, 66093, 69281, 76718, 
    78107, 95488, 95684, 98324
  )

Query time 0.00046

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 10 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
65927 DCHVA004 P A 1 8.99 1 0.000 0 0 0 0.00 0 1517374972 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 Y 1616758989 Y 2021-12-17 17:37:27 0
66093 HDCHA003 P A 1 8.99 1 0.000 0 0 0 0.00 0 1517979770 0 Y N N B N R Y N N Y 10 1517961600 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 5054283487541 Y 1616758993 Y 2021-12-17 17:37:27 0
68092 HDCB17 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525669215 0 Y N N B N R Y N N Y 10 1525647600 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 5054283659634 GBKQU1847800 N 68108 Copyright Control Various Artists 1525670638 Y 2021-12-17 17:37:27 0
69281 HDCPS004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1531090800 0 Y N N B N R Y N N Y 10 1531090800 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 5054283768220 GBKQU1868512 N 69287 Copyright Control Frank Farrell 1530853210 Y 2021-12-17 17:37:27 0
76582 HDCER003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1501628400 0 Y N N B N R Y N N Y 10 1501628400 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 5054284405575 GBKQU1775682 N 76592 Copyright Control Various Artists 1558071162 Y 2021-12-17 17:37:27 0
76718 HDCES003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1527462000 0 Y N N B N R Y N N Y 10 1527462000 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 5054284405506 GBKQU1855050 N 76738 Copyright Control Various Artists 1558073856 Y 2021-12-17 17:37:27 0
78107 HDCT13RR P A 1 1.69 1 0.000 0 0 0 0.00 0 1446422400 0 Y N N B N R Y N N Y 10 1446422400 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 5054284423937 GBKQU1592859 N 78115 Copyright Control Various Artists 1560413355 Y 2021-12-17 17:37:27 0
95488 HDCRFTL001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620774000 0 Y N N B N R Y N N Y 10 1620774000 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 5054285876237 GBKQU2149806 N 95491 Copyright Control Various Artists 1619716216 Y 2021-12-17 17:37:27 0
95684 HDCHA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620191119 0 Y N N B N R Y N N Y 10 1620169200 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 5054285874240 GBKQU2149332 N 95685 Copyright Control Various Artists 1620192490 Y 2021-12-17 17:37:27 0
98324 HDCHHS6 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628809200 0 Y N N B N R Y N N Y 10 1628809200 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 5054286099574 GBKQU2188683 N 98336 Copyright Control Various Artists 1628615410 Y 2021-12-17 17:37:27 0