SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    31964, 113408, 118255, 31165, 32790, 
    52428, 52435, 73429, 80787, 88373
  )

Query time 0.00035

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
31165 LWEGHD02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1383177600 0 Y N N B N R Y N N Y 10 1383177600 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 5052653819015 GBKQU1355064 N 31188 Copyright Control Various Artists 1397625426 Y 2021-12-17 17:37:27 0
31964 LWEI006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1328745600 0 Y N N B N R Y N N Y 10 1328745600 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 5052653202879 GBKQU1156599 N 31979 Copyright Control Various Artists 1397627479 Y 2021-12-17 17:37:27 0
32790 LWADE04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1350687600 0 Y N N B N R Y N N Y 10 1350687600 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 5052653409650 GBKQU1293602 N 32801 Copyright Control Various Artists 1397629648 Y 2021-12-17 17:37:27 0
52428 LWEGHH06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1474239600 0 Y N N B N R Y N N Y 10 1474239600 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 5054282502801 GBKQU1627106 N 52445 Copyright Control Various Artists 1471752068 Y 2021-12-17 17:37:27 0
52435 LWEGHH06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1474239600 0 Y N N B N R Y N N Y 10 1474239600 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 5054282502801 GBKQU1639178 N 52445 Copyright Control Various Artists 1471752085 Y 2021-12-17 17:37:27 0
73429 LWHDA14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1546560000 0 Y N N B N R Y N N Y 10 1546560000 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 5054284141343 GBKQU1824884 N 73434 Copyright Control Various Artists 1545368406 Y 2021-12-17 17:37:27 0
80787 LWHDB06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1570402800 0 Y N N B N R Y N N Y 10 1570402800 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 5054284619200 GBKQU1900767 N 80801 Copyright Control Various Artists 1568782807 Y 2021-12-17 17:37:27 0
88373 LWHDB15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600815600 0 Y N N B N R Y N N Y 10 1600815600 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 5054285291559 GBLV61925045 N 88391 Copyright Control Various Artists 1598892445 Y 2021-12-17 17:37:27 0
113408 LWHARDS08 P A 1 1.69 1 0.000 0 0 0 0.00 0 1675987200 0 Y N N B N R Y N N Y 10 1675987200 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 5054287176427 GBKQU2275090 N 113414 Copyright Control Various Artists 1674581413 Y 2023-01-24 18:30:13 0
118255 LWHARDS15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1696806000 0 Y N N B N R Y N N Y 10 1696806000 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 5054287568734 GBKQU2325569 N Copyright Control Various Artists 1694236503 Y 2023-09-09 06:15:03 0